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.3.12020000.3 2013/02/22 14:20:13 pathota ship $ */
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 514: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,

510: then
511:
512: p_date_to := nvl(p_date_to,p_date_chk);
513:
514: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
515: p_org_op_flag => 'I',
516: p_date_to => FALSE);
517:
518: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

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

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

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

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

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

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

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

699: fetch csr_chk_hr_org into p_hr_org_chk;
700: if csr_chk_hr_org%found
701: then
702: */ -- Fix For Bug # 14587491
703: p_organization_data := hr_hrhd_rir_wf.sif_organization_data(p_organization_id => p_organization_id,
704: p_org_op_flag => 'D',
705: p_date_to => TRUE);
706:
707: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

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

805: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
806:
807: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
808:
809: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',
810: p_when => p_date,
811: p_parameters => myparameters);
812:
813: if p_assignment_id is not null

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

811: p_parameters => myparameters);
812:
813: if p_assignment_id is not null
814: then
815: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
816: p_when => p_date,
817: p_parameters => myparameters);
818: end if;
819:

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

818: end if;
819:
820: else
821:
822: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id =>p_person_id ,
823: p_address_id => null,
824: p_phone_id => null,
825: p_person_op_flag => 'I',
826: p_date => p_date);

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

833: p_event_data => p_person_data);
834:
835: if p_assignment_id is not null
836: then
837: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id =>p_assignment_id ,
838: p_asg_op_flag => 'I',
839: p_date => p_date);
840:
841:

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

863: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
864:
865: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
866:
867: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
868: p_when => p_date,
869: p_parameters => myparameters);
870:
871: else

Line 873: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id =>rec_ass.assignment_id ,

869: p_parameters => myparameters);
870:
871: else
872:
873: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id =>rec_ass.assignment_id ,
874: p_asg_op_flag => 'I',
875: p_date => p_date);
876:
877:

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

1033: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1034:
1035: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1036:
1037: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.person_callbackable',
1038: p_when => p_date,
1039: p_parameters => myparameters);
1040:
1041:

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

1040:
1041:
1042: else
1043:
1044: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id =>p_person_id ,
1045: p_address_id => null,
1046: p_phone_id => null,
1047: p_person_op_flag => 'U',
1048: p_date => p_date);

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

1080: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1081:
1082: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1083:
1084: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
1085: p_when => p_date,
1086: p_parameters => myparameters);
1087:
1088: else

Line 1090: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id =>rec_ass.assignment_id ,

1086: p_parameters => myparameters);
1087:
1088: else
1089:
1090: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id =>rec_ass.assignment_id ,
1091: p_asg_op_flag => 'U',
1092: p_date => p_date);
1093:
1094:

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

1201: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1202:
1203: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1204:
1205: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.address_callbackable',
1206: p_when => p_date,
1207: p_parameters => myparameters);
1208:
1209:

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

1208:
1209:
1210: else
1211:
1212: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id =>p_person_id ,
1213: p_address_id => p_address_id,
1214: p_phone_id => null,
1215: p_person_op_flag => 'U',
1216: p_date => p_date);

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

1324: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1325:
1326: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1327:
1328: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.phone_callbackable',
1329: p_when => p_date,
1330: p_parameters => myparameters);
1331:
1332:

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

1331:
1332:
1333: else
1334:
1335: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id =>p_person_id ,
1336: p_address_id => null,
1337: p_phone_id => p_phone_id,
1338: p_person_op_flag => 'U',
1339: p_date => p_date);

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

1448: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1449:
1450: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1451:
1452: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
1453: p_when => p_eff_start_date,
1454: p_parameters => myparameters);
1455:
1456: else

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

1454: p_parameters => myparameters);
1455:
1456: else
1457:
1458: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id =>p_assignment_id ,
1459: p_asg_op_flag => 'I',
1460: p_date => p_eff_start_date);
1461:
1462:

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

1567: wf_event.AddParameterToList('transaction_id',l_transaction_id_canonical,myparameters);
1568:
1569: --wf_event.AddParameterToList('event_data',p_event_data,myparameters);
1570:
1571: wf_util.call_me_later(p_callback => 'hr_hrhd_rir_wf.workforce_callbackable',
1572: p_when => p_eff_start_date,
1573: p_parameters => myparameters);
1574:
1575: else

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

1573: p_parameters => myparameters);
1574:
1575: else
1576:
1577: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id =>p_assignment_id ,
1578: p_asg_op_flag => 'U',
1579: p_date => p_eff_start_date);
1580:
1581:

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

2617: and (nvl(p_accepted_termination_date,p_accepted_termination_date_t) = p_accepted_termination_date_t)
2618: and (nvl(p_primary_flag,p_primary_flag_t) = p_primary_flag_t)
2619: then
2620:
2621: p_assignment_data := hr_hrhd_rir_wf.sif_workforce_data(p_assignment_id => p_assignment_id,
2622: p_asg_op_flag =>p_asg_op_flag,
2623: p_date => to_date(p_eff_start_date,'DD/MM/YYYY'));
2624:
2625: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;

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

2964: and (nvl(p_national_identifier,p_national_identifier_t) = p_national_identifier_t)
2965: and (nvl(p_email_address,p_email_address_t) = p_email_address_t) )
2966: then
2967:
2968: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id => p_person_id,
2969: p_address_id => null,
2970: p_phone_id => null,
2971: p_person_op_flag =>p_person_op_flag,
2972: p_date => to_date(p_date,'DD/MM/YYYY'));

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

3206: and (nvl(p_Postal_Code,p_Postal_Code_t) = p_Postal_Code_t)
3207: and (nvl(p_primary_flag,p_primary_flag_t) = p_primary_flag_t) )
3208: then
3209:
3210: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id => p_person_id,
3211: p_address_id => p_address_id,
3212: p_phone_id => null,
3213: p_person_op_flag =>p_person_op_flag,
3214: p_date => to_date(p_date,'DD/MM/YYYY'));

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

3337: and (nvl(p_phone_type,p_phone_type_t) = p_phone_type_t)
3338: and (nvl(p_phone_number,p_phone_number_t) = p_phone_number_t))
3339: then
3340:
3341: p_person_data := hr_hrhd_rir_wf.sif_person_data(p_person_id => p_person_id,
3342: p_address_id => null,
3343: p_phone_id => p_phone_id,
3344: p_person_op_flag =>'U',
3345: p_date => to_date(p_date,'DD/MM/YYYY'));

Line 3361: end HR_HRHD_RIR_WF;

3357:
3358: end phone_callbackable;
3359:
3360:
3361: end HR_HRHD_RIR_WF;
3362: