APPS.HR_HRHD_RIR_WF dependencies on HR_HRHD_RIR_WF

Line 1: PACKAGE BODY HR_HRHD_RIR_WF as

1: PACKAGE BODY HR_HRHD_RIR_WF as
2: /* $Header: perhdrsyn.pkb 120.2.12010000.6 2008/11/28 05:54:38 sathkris noship $ */
3:
4: /* Procedures called inside the workflow process HR RIR Process starts */
5:

Line 52: p_job_data := hr_hrhd_rir_wf.sif_job_data(p_job_id => p_job_id,

48: v_tag := dbms_xmldom.getNodeName(v_node);
49: v_node_2 := dbms_xmldom.getfirstchild(v_node ); -- can't recall why needed
50: p_date_to := dbms_xmldom.getnodevalue(v_node_2);
51:
52: p_job_data := hr_hrhd_rir_wf.sif_job_data(p_job_id => p_job_id,
53: p_job_op_flag => 'U',
54: p_date_to => FALSE);
55:
56:

Line 68: p_job_data := hr_hrhd_rir_wf.sif_job_data(p_job_id => p_job_id,

64: p_event_data => p_job_data);
65:
66: if p_date_to is not null
67: then
68: p_job_data := hr_hrhd_rir_wf.sif_job_data(p_job_id => p_job_id,
69: p_job_op_flag => 'U',
70: p_date_to => TRUE);
71:
72: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

Line 134: p_job_data := hr_hrhd_rir_wf.sif_job_data(p_job_id => p_job_id,

130: v_node_2 := dbms_xmldom.getfirstchild(v_node ); -- can't recall why needed
131: p_date_to := dbms_xmldom.getnodevalue(v_node_2);
132:
133:
134: p_job_data := hr_hrhd_rir_wf.sif_job_data(p_job_id => p_job_id,
135: p_job_op_flag => 'I',
136: p_date_to => FALSE);
137:
138: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

Line 147: p_job_data := hr_hrhd_rir_wf.sif_job_data(p_job_id => p_job_id,

143: p_event_data => p_job_data);
144:
145: if p_date_to is not null
146: then
147: p_job_data := hr_hrhd_rir_wf.sif_job_data(p_job_id => p_job_id,
148: p_job_op_flag => 'U',
149: p_date_to => TRUE);
150:
151: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

Line 202: p_job_data := hr_hrhd_rir_wf.sif_job_data(p_job_id => p_job_id,

198: v_node_2 := dbms_xmldom.getfirstchild(v_node ); -- can't recall why needed
199: p_job_id := dbms_xmldom.getnodevalue(v_node_2);
200:
201:
202: p_job_data := hr_hrhd_rir_wf.sif_job_data(p_job_id => p_job_id,
203: p_job_op_flag => 'D',
204: p_date_to => TRUE);
205:
206:

Line 269: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,

265: v_tag := dbms_xmldom.getNodeName(v_node);
266: v_node_2 := dbms_xmldom.getfirstchild(v_node ); -- can't recall why needed
267: p_inactive_date := dbms_xmldom.getnodevalue(v_node_2);
268:
269: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,
270: p_loc_op_flag => 'I',
271: p_inactive_date => FALSE);
272:
273: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

Line 285: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,

281:
282:
283: if p_inactive_date is not null
284: then
285: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,
286: p_loc_op_flag => 'U',
287: p_inactive_date => TRUE);
288:
289: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

Line 354: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,

350: v_tag := dbms_xmldom.getNodeName(v_node);
351: v_node_2 := dbms_xmldom.getfirstchild(v_node ); -- can't recall why needed
352: p_inactive_date := dbms_xmldom.getnodevalue(v_node_2);
353:
354: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,
355: p_loc_op_flag => 'U',
356: p_inactive_date => FALSE);
357:
358: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

Line 367: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,

363: p_event_data => p_location_data);
364:
365: if p_inactive_date is not null
366: then
367: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,
368: p_loc_op_flag => 'U',
369: p_inactive_date => TRUE);
370:
371: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

Line 428: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,

424: v_node_2 := dbms_xmldom.getfirstchild(v_node ); -- can't recall why needed
425: p_location_id := dbms_xmldom.getnodevalue(v_node_2);
426:
427:
428: p_location_data := hr_hrhd_rir_wf.sif_location_data(p_location_id => p_location_id,
429: p_loc_op_flag => 'D',
430: p_inactive_date => TRUE);
431:
432: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

Line 510: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,

506: -- open csr_chk_hr_org(p_organization_id);
507: -- fetch csr_chk_hr_org into p_hr_org_chk;
508: -- if csr_chk_hr_org%found
509: -- then
510: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
511: p_org_op_flag => 'I',
512: p_date_to => FALSE);
513:
514: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

Line 526: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,

522:
523:
524: if p_date_to is not null
525: then
526: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
527: p_org_op_flag => 'U',
528: p_date_to => TRUE);
529:
530: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

Line 611: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,

607: fetch csr_chk_hr_org into p_hr_org_chk;
608: if csr_chk_hr_org%found
609: then
610:
611: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
612: p_org_op_flag => 'U',
613: p_date_to => FALSE);
614:
615: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

Line 625: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,

621: p_event_data => p_organization_data);
622:
623: if p_date_to is not null
624: then
625: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
626: p_org_op_flag => 'U',
627: p_date_to => TRUE);
628:
629: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

Line 699: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,

695: fetch csr_chk_hr_org into p_hr_org_chk;
696: if csr_chk_hr_org%found
697: then
698:
699: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
700: p_org_op_flag => 'D',
701: p_date_to => TRUE);
702:
703: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

Line 793: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',

789: wf_event.AddParameterToList('person_op_flag','I',myparameters);
790: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
791: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
792:
793: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',
794: p_when => p_date,
795: p_parameters => myparameters);
796:
797: if p_assignment_id is not null

Line 799: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',

795: p_parameters => myparameters);
796:
797: if p_assignment_id is not null
798: then
799: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
800: p_when => p_date,
801: p_parameters => myparameters);
802: end if;
803:

Line 806: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id =>p_person_id ,

802: end if;
803:
804: else
805:
806: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id =>p_person_id ,
807: p_address_id => null,
808: p_phone_id => null,
809: p_person_op_flag => 'I',
810: p_date => p_date);

Line 821: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id =>p_assignment_id ,

817: p_event_data => p_person_data);
818:
819: if p_assignment_id is not null
820: then
821: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id =>p_assignment_id ,
822: p_asg_op_flag => 'I',
823: p_date => p_date);
824:
825:

Line 934: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',

930: wf_event.AddParameterToList('eff_date',p_date,myparameters);
931: wf_event.AddParameterToList('person_op_flag','U',myparameters);
932: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
933:
934: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',
935: p_when => p_date,
936: p_parameters => myparameters);
937:
938:

Line 941: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id =>p_person_id ,

937:
938:
939: else
940:
941: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id =>p_person_id ,
942: p_address_id => null,
943: p_phone_id => null,
944: p_person_op_flag => 'U',
945: p_date => p_date);

Line 1048: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.address_callbackable',

1044: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1045: wf_event.AddParameterToList('address_id',p_address_id,myparameters);
1046: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1047:
1048: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.address_callbackable',
1049: p_when => p_date,
1050: p_parameters => myparameters);
1051:
1052:

Line 1055: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id =>p_person_id ,

1051:
1052:
1053: else
1054:
1055: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id =>p_person_id ,
1056: p_address_id => p_address_id,
1057: p_phone_id => null,
1058: p_person_op_flag => 'U',
1059: p_date => p_date);

Line 1164: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.phone_callbackable',

1160: wf_event.AddParameterToList('eff_date',p_date,myparameters);
1161: wf_event.AddParameterToList('phone_id',p_phone_id,myparameters);
1162: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1163:
1164: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.phone_callbackable',
1165: p_when => p_date,
1166: p_parameters => myparameters);
1167:
1168:

Line 1171: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id =>p_person_id ,

1167:
1168:
1169: else
1170:
1171: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id =>p_person_id ,
1172: p_address_id => null,
1173: p_phone_id => p_phone_id,
1174: p_person_op_flag => 'U',
1175: p_date => p_date);

Line 1281: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',

1277: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1278: wf_event.AddParameterToList('asg_op_flag','I',myparameters);
1279: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1280:
1281: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
1282: p_when => p_eff_start_date,
1283: p_parameters => myparameters);
1284:
1285: else

Line 1287: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id =>p_assignment_id ,

1283: p_parameters => myparameters);
1284:
1285: else
1286:
1287: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id =>p_assignment_id ,
1288: p_asg_op_flag => 'I',
1289: p_date => p_eff_start_date);
1290:
1291:

Line 1393: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',

1389: wf_event.AddParameterToList('eff_start_date',p_eff_start_date,myparameters);
1390: wf_event.AddParameterToList('asg_op_flag','U',myparameters);
1391: wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1392:
1393: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
1394: p_when => p_eff_start_date,
1395: p_parameters => myparameters);
1396:
1397: else

Line 1399: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id =>p_assignment_id ,

1395: p_parameters => myparameters);
1396:
1397: else
1398:
1399: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id =>p_assignment_id ,
1400: p_asg_op_flag => 'U',
1401: p_date => p_eff_start_date);
1402:
1403:

Line 2418: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id => p_assignment_id,

2414: and (nvl(p_final_process_date,p_final_process_date_t) = p_final_process_date_t)
2415: and (nvl(p_accepted_termination_date,p_accepted_termination_date_t) = p_accepted_termination_date_t)
2416: then
2417:
2418: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id => p_assignment_id,
2419: p_asg_op_flag =>p_asg_op_flag,
2420: p_date => to_date(p_eff_start_date,'DD/MM/YYYY'));
2421:
2422: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

Line 2759: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id => p_person_id,

2755: and (nvl(p_national_identifier,p_national_identifier_t) = p_national_identifier_t)
2756: and (nvl(p_email_address,p_email_address_t) = p_email_address_t) )
2757: then
2758:
2759: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id => p_person_id,
2760: p_address_id => null,
2761: p_phone_id => null,
2762: p_person_op_flag =>p_person_op_flag,
2763: p_date => to_date(p_date,'DD/MM/YYYY'));

Line 2979: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id => p_person_id,

2975: and (nvl(p_Region_2,p_Region_2_t) = p_Region_2_t)
2976: and (nvl(p_Postal_Code,p_Postal_Code_t) = p_Postal_Code_t) )
2977: then
2978:
2979: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id => p_person_id,
2980: p_address_id => p_address_id,
2981: p_phone_id => null,
2982: p_person_op_flag =>p_person_op_flag,
2983: p_date => to_date(p_date,'DD/MM/YYYY'));

Line 3104: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id => p_person_id,

3100: and (nvl(p_phone_type,p_phone_type_t) = p_phone_type_t)
3101: and (nvl(p_phone_number,p_phone_number_t) = p_phone_number_t))
3102: then
3103:
3104: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id => p_person_id,
3105: p_address_id => null,
3106: p_phone_id => p_phone_id,
3107: p_person_op_flag =>'U',
3108: p_date => to_date(p_date,'DD/MM/YYYY'));

Line 3124: end HR_HRHD_RIR_WF;

3120:
3121: end phone_callbackable;
3122:
3123:
3124: end HR_HRHD_RIR_WF;