APPS.PAY_CORE_UPGRADE_PKG dependencies on PAY_CORE_UTILS

Line 478: pay_core_utils.get_process_path(prr.assignment_action_id),

474: begin
475: --
476: select prr.source_id,
477: prr.element_type_id,
478: pay_core_utils.get_process_path(prr.assignment_action_id),
479: prr.assignment_action_id,
480: paa.source_action_id
481: into l_src_entry_id,
482: l_src_et_id,

Line 493: pay_core_utils.assert_condition(

489: and prr.assignment_action_id = paa.assignment_action_id;
490: --
491: exception
492: when no_data_found then
493: pay_core_utils.assert_condition(
494: 'upg_retro_proc_det_frm_ee:1',
495: 1 = 2);
496: --
497: end;

Line 521: pay_core_utils.assert_condition(

517: l_run_result_id:= null;
518: l_src_entry_id := eerec.source_id;
519: --
520: if (eerec.element_type_id is null) then
521: pay_core_utils.assert_condition(
522: 'upg_retro_proc_det_frm_ee:4',
523: 1 = 2);
524: end if;
525: --

Line 557: --pay_core_utils.assert_condition(

553: into l_src_et_id
554: from pay_element_types_f
555: where retro_summ_ele_id = eerec.element_type_id;
556: else
557: --pay_core_utils.assert_condition(
558: -- 'upg_retro_proc_det_frm_ee:8',
559: -- 1 = 2);
560: --
561: -- Since there can be many then take the first one.

Line 599: select pay_core_utils.get_process_path(assignment_action_id)

595: end if;
596: end;
597: end;
598: begin
599: select pay_core_utils.get_process_path(assignment_action_id)
600: into l_ppath
601: from pay_assignment_actions
602: where source_action_id = l_src_asg_act_id
603: and run_type_id = eerec.source_run_type

Line 631: pay_core_utils.get_process_path(prr.assignment_action_id),

627: begin
628: --
629: select prr.source_id,
630: prr.element_type_id,
631: pay_core_utils.get_process_path(prr.assignment_action_id),
632: prr.assignment_action_id,
633: paa.source_action_id
634: into l_src_entry_id,
635: l_src_et_id,

Line 646: pay_core_utils.assert_condition(

642: and prr.assignment_action_id = paa.assignment_action_id;
643: --
644: exception
645: when no_data_found then
646: pay_core_utils.assert_condition(
647: 'upg_retro_proc_det_frm_ee:3',
648: 1 = 2);
649: --
650: end;

Line 676: pay_core_utils.assert_condition(

672: l_run_result_id:= null;
673: l_src_entry_id := eerec.source_id;
674: --
675: if (eerec.element_type_id is null) then
676: pay_core_utils.assert_condition(
677: 'upg_retro_proc_det_frm_ee:4',
678: 1 = 2);
679: end if;
680: --

Line 714: -- pay_core_utils.assert_condition(

710: from pay_element_types_f
711: where retro_summ_ele_id = eerec.element_type_id;
712: -- and element_type_id = l_src_et_id;
713: else
714: -- pay_core_utils.assert_condition(
715: -- 'upg_retro_proc_det_frm_ee:9',
716: -- 1 = 2);
717: --
718: -- Since there can be many then take the first one.

Line 756: select pay_core_utils.get_process_path(assignment_action_id)

752: end if;
753: end;
754: end;
755: begin
756: select pay_core_utils.get_process_path(assignment_action_id)
757: into l_ppath
758: from pay_assignment_actions
759: where source_action_id = l_src_asg_act_id
760: and run_type_id = eerec.source_run_type

Line 1147: pay_core_utils.get_leg_context_iv_name('JURISDICTION_CODE', l_leg_code,

1143: where asg.assignment_id = p_assignment_id
1144: and pbg.business_group_id = asg.business_group_id
1145: and rownum = 1;
1146: --
1147: pay_core_utils.get_leg_context_iv_name('JURISDICTION_CODE', l_leg_code,
1148: g_jur_name, l_found);
1149: --
1150: if (l_found = FALSE) then
1151: g_jur_name := 'Jurisdiction';

Line 1154: pay_core_utils.get_upgrade_status(l_bus_grp,

1150: if (l_found = FALSE) then
1151: g_jur_name := 'Jurisdiction';
1152: end if;
1153: --
1154: pay_core_utils.get_upgrade_status(l_bus_grp,
1155: 'RR_SPARSE_JC',
1156: l_status);
1157: if (upper(l_status)='Y') then
1158: l_found := FALSE;

Line 1436: pay_core_utils.get_upgrade_status

1432: -- We can not do the upgrade unless
1433: -- a previous upgrade has completed
1434: -- successfully
1435: --
1436: pay_core_utils.get_upgrade_status
1437: (l_bus_grpid,
1438: 'EE_PROC_DETAILS',
1439: l_complete);
1440:

Line 1442: pay_core_utils.assert_condition(

1438: 'EE_PROC_DETAILS',
1439: l_complete);
1440:
1441: if (l_complete <> 'Y') then
1442: pay_core_utils.assert_condition(
1443: 'upg_timedef_baldate:1',
1444: 1 = 2);
1445: end if;
1446: --