DBA Data[Home] [Help]

APPS.PAY_GENERIC_UPGRADE dependencies on PAY_CORE_UTILS

Line 35: pay_core_utils.assert_condition(

31: */
32: if ( l_status = 'C'
33: and p_status <> 'C') then
34: --
35: pay_core_utils.assert_condition(
36: 'pay_generic_upgrade.set_upgrade_status:2',
37: 1 = 2);
38: --
39: end if;

Line 57: pay_core_utils.assert_condition(

53: values (p_upg_def_id,
54: p_status,
55: p_bus_grp);
56: else
57: pay_core_utils.assert_condition(
58: 'pay_generic_upgrade.set_upgrade_status:1',
59: 1 = 2);
60: end if;
61: --

Line 80: pay_core_utils.assert_condition(

76: */
77: if ( l_status = 'C'
78: and p_status <> 'C') then
79: --
80: pay_core_utils.assert_condition(
81: 'pay_generic_upgrade.set_upgrade_status:2',
82: 1 = 2);
83: --
84: end if;

Line 102: pay_core_utils.assert_condition(

98: values (p_upg_def_id,
99: p_status,
100: p_leg_code);
101: else
102: pay_core_utils.assert_condition(
103: 'pay_generic_upgrade.set_upgrade_status:1',
104: 1 = 2);
105: end if;
106: --

Line 126: pay_core_utils.assert_condition(

122: */
123: if ( l_status = 'C'
124: and p_status <> 'C') then
125: --
126: pay_core_utils.assert_condition(
127: 'pay_generic_upgrade.set_upgrade_status:2',
128: 1 = 2);
129: --
130: end if;

Line 150: pay_core_utils.assert_condition(

146: p_status
147: );
148: else
149:
150: pay_core_utils.assert_condition(
151: 'pay_generic_upgrade.set_upgrade_status:1',
152: 1 = 2);
153: end if;
154: --

Line 312: and pay_core_utils.get_parameter('REP_GROUP', ppa.legislative_parameters)=rg.short_name

308: select 'B',rg.thread_level
309: into l_upg_level, l_thread_level
310: from pay_report_groups rg,pay_payroll_actions ppa
311: where rg.report_format_mapping_id=l_rep_id
312: and pay_core_utils.get_parameter('REP_GROUP', ppa.legislative_parameters)=rg.short_name
313: and ppa.payroll_action_id=pactid;
314:
315: else
316: --

Line 317: select pay_core_utils.get_parameter('UPG_DEF_NAME',

313: and ppa.payroll_action_id=pactid;
314:
315: else
316: --
317: select pay_core_utils.get_parameter('UPG_DEF_NAME',
318: ppa.legislative_parameters),
319: ppa.business_group_id,
320: pbg.legislation_code
321: into l_upg_def_nm,

Line 376: pay_core_utils.assert_condition(

372: order by asg.person_id';
373: --
374: else
375: --
376: pay_core_utils.assert_condition(
377: 'pay_generic_upgrade.range_cursor:2',
378: 1 = 2);
379: --
380: end if;

Line 420: pay_core_utils.assert_condition(

416: order by pet.element_type_id';
417: --
418: else
419: --
420: pay_core_utils.assert_condition(
421: 'pay_generic_upgrade.range_cursor:3',
422: 1 = 2);
423: --
424: end if;

Line 428: pay_core_utils.assert_condition(

424: end if;
425: --
426: else
427: --
428: pay_core_utils.assert_condition(
429: 'pay_generic_upgrade.range_cursor:1',
430: 1 = 2);
431: --
432: end if;

Line 482: pay_core_utils.assert_condition(

478: dbms_sql.close_cursor(sql_cur);
479: --
480: else
481: dbms_sql.close_cursor(sql_cur);
482: pay_core_utils.assert_condition(
483: 'pay_generic_upgrade.do_qualification:1',
484: 1 = 2);
485: end if;
486: --

Line 690: and pay_core_utils.get_parameter('REP_GROUP', ppa.legislative_parameters)=rg.short_name

686: l_thread_level,
687: l_qual_proc
688: from pay_report_groups rg,pay_payroll_actions ppa
689: where rg.report_format_mapping_id=l_rep_id
690: and pay_core_utils.get_parameter('REP_GROUP', ppa.legislative_parameters)=rg.short_name
691: and ppa.payroll_action_id=p_pactid;
692:
693:
694: else

Line 695: select pay_core_utils.get_parameter('UPG_DEF_NAME',

691: and ppa.payroll_action_id=p_pactid;
692:
693:
694: else
695: select pay_core_utils.get_parameter('UPG_DEF_NAME',
696: ppa.legislative_parameters)
697: into l_upg_def_nm
698: from pay_payroll_actions ppa
699: where payroll_action_id = p_pactid;

Line 748: pay_core_utils.assert_condition(

744: );
745: --
746: end loop;
747: else
748: pay_core_utils.assert_condition(
749: 'pay_generic_upgrade.action_creation:1',
750: 1 = 2);
751: end if;
752: elsif (l_upg_level = 'L') then

Line 787: pay_core_utils.assert_condition(

783: );
784: --
785: end loop;
786: else
787: pay_core_utils.assert_condition(
788: 'pay_generic_upgrade.action_creation:2',
789: 1 = 2);
790: end if;
791: elsif (l_upg_level = 'G') then

Line 826: pay_core_utils.assert_condition(

822: );
823: --
824: end loop;
825: else
826: pay_core_utils.assert_condition(
827: 'pay_generic_upgrade.action_creation:3',
828: 1 = 2);
829: end if;
830: else

Line 831: pay_core_utils.assert_condition(

827: 'pay_generic_upgrade.action_creation:3',
828: 1 = 2);
829: end if;
830: else
831: pay_core_utils.assert_condition(
832: 'pay_generic_upgrade.action_creation:4',
833: 1 = 2);
834: end if;
835: end action_creation;

Line 868: select pay_core_utils.get_parameter('UPG_DEF_NAME',

864: object_id pay_temp_object_actions.object_id%type;
865: --
866: begin
867: --
868: select pay_core_utils.get_parameter('UPG_DEF_NAME',
869: ppa.legislative_parameters),
870: ptoa.object_id
871: into l_upg_def_nm,
872: object_id

Line 921: select pay_core_utils.get_parameter('UPG_DEF_NAME',

917: --
918: begin
919: --
920:
921: select pay_core_utils.get_parameter('UPG_DEF_NAME',
922: ppa.legislative_parameters),
923: pay_core_utils.get_parameter('REMOVE_ACT',
924: ppa.legislative_parameters),
925: ppa.business_group_id,

Line 923: pay_core_utils.get_parameter('REMOVE_ACT',

919: --
920:
921: select pay_core_utils.get_parameter('UPG_DEF_NAME',
922: ppa.legislative_parameters),
923: pay_core_utils.get_parameter('REMOVE_ACT',
924: ppa.legislative_parameters),
925: ppa.business_group_id,
926: pbg.legislation_code,
927: ppa.report_type