Oracle Alerts registration and queryyy..................

1).........EVENT ALERT.............

1)create concurreent program in sysstem admin
2) check the execution. of program
3)select alert manager as resposibility
4) define theresposibility in human resourse as application name
5) first event alert
   1) tab
   2)select table form specific application for which u have to fire aleret
   3)write the queryyy assss follows

select full_name,
last_name,
date_of_birth,
nationality,
employee_number,
sex,
original_date_of_hire into &full_name1,
&last_name1,
&date_of_birth1,
&nationality1,
&employee_number1,
&sex1,
&original_date_of_hire1 from per_all_people_f where rowid=:rowid

click on verify and run the queryyy.....

6)give the action name and in action detail
                          1)specify action name as ...1)concurre=nyt program
                                                       2)message
                                                       3)sql script
                          2)application name
                           3)concurrent program name
                           4)argument to pass to concurrent program
7)specify the action set in action set define the action set details
define the member that u have previously define as action name
8)alert details in installation we have to specify the  apps-mspl
                                                        apps-msspl
9)and save the alert to fire...

10)check the out put in the view in request........all..

2).............PERIODIC ALERT................
        

NO MSPL AND MSSPL IN PERIODIC ALERT JUST GIVE THE QUERY TO RUN THE ALERT...

1)create concurreent program in sysstem admin
2) check the execution. of program
3)select alert manager as resposibility
4) define theresposibility in human resourse as application name
5) first PERIODIC alert
    1) SELECT WHEN U HAVE TO FIRE THE ALERT ACCORDING TO THE TYPE OF ALERTTTTT CHOOSE...
   1) WRITE QUERY IN THE GIVEN SECTION AS GIVEN BELOW

select full_name,
last_name,
date_of_birth,
nationality,
employee_number,
sex,
original_date_of_hire into &full_name1,
&last_name1,
&date_of_birth1,
&nationality1,
&employee_number1,
&sex1,
&original_date_of_hire1 from per_all_people_f where rowid=:rowid

click on verify and run the queryyy.....

6)give the action name and in action detail
                          1)specify action name as ...1)concurre=TyPE CONCURRENT  program NAME HERE
                                                       2)message
                                                       3)sql script
                          2)application name
                           3)concurrent program name
                           4)argument to pass to concurrent program
7)specify the action set in action set define the action set details
define the member that u have previously define as action name
8)IMP STEP TO REMBER.....NO NEED TO GIVE THE MSPL AND MSSPL
 IN CASE OF THE PERIODIC ALERT IT FIRE THE CON CURRENT PROGRAM FOR THE TWO TIMESSS
 no needdd  of mspl,.............
alert details in installation we have to specify the  apps-mspl
                                                        apps-msspl
9)and save the alert to fire...

10)check the out put in the view in request........all..

3)package for Alert..............
package specification ...............
CREATE OR REPLACE PACKAGE XX_TRAINNING_DIP90 AS
PROCEDURE XXSHOW_DATA90(ERRBUF OUT VARCHAR2,RETCODE OUT VARCHAR2);
END XX_TRAINNING_DIP90;
/


package boddyyyyy..................

CREATE OR REPLACE PACKAGE BODY XX_TRAINNING_DIP90 AS
PROCEDURE XXSHOW_DATA90(ERRBUF OUT VARCHAR2,RETCODE OUT VARCHAR2)
IS
CURSOR C1 IS select * from per_all_people_f where original_date_of_hire=trunc(sysdate) ;
DIP_PRODUCT1 per_all_people_f%ROWTYPE;
 BEGIN
  OPEN C1;
    Fnd_file.put_line(fnd_file.output,'Employess Details who updated his data todays..................');
    Fnd_file.put_line(fnd_file.output,'full_name ,Date_of_birth ,Nationality ,employee_number ,sex ,original_date_of_hire .');
   LOOP
    FETCH C1 INTO DIP_PRODUCT1;
          EXIT WHEN C1%NOTFOUND; 
     Fnd_file.put_line(fnd_file.output,DIP_PRODUCT1.full_name||'  , '||DIP_PRODUCT1.date_of_birth||'  , '||DIP_PRODUCT1.nationality||'  ,'||DIP_PRODUCT1.employee_number||'  ,'||DIP_PRODUCT1.sex||'  ,'||DIP_PRODUCT1.original_date_of_hire);
    END LOOP;
 CLOSE C1;
 END XXSHOW_DATA90;
 END XX_TRAINNING_DIP90;
/