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 333: and pay_core_utils.get_parameter('REP_GROUP', ppa.legislative_parameters)=rg.short_name

329: select 'B',rg.thread_level,rg.legislation_code
330: into l_upg_level, l_thread_level, l_leg_code
331: from pay_report_groups rg,pay_payroll_actions ppa
332: where rg.report_format_mapping_id=l_rep_id
333: and pay_core_utils.get_parameter('REP_GROUP', ppa.legislative_parameters)=rg.short_name
334: and ppa.payroll_action_id=pactid;
335:
336: else
337: --

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

334: and ppa.payroll_action_id=pactid;
335:
336: else
337: --
338: select pay_core_utils.get_parameter('UPG_DEF_NAME',
339: ppa.legislative_parameters),
340: ppa.business_group_id,
341: pbg.legislation_code
342: into l_upg_def_nm,

Line 427: pay_core_utils.assert_condition(

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

Line 471: pay_core_utils.assert_condition(

467: order by pet.element_type_id';
468: --
469: else
470: --
471: pay_core_utils.assert_condition(
472: 'pay_generic_upgrade.range_cursor:3',
473: 1 = 2);
474: --
475: end if;

Line 479: pay_core_utils.assert_condition(

475: end if;
476: --
477: else
478: --
479: pay_core_utils.assert_condition(
480: 'pay_generic_upgrade.range_cursor:1',
481: 1 = 2);
482: --
483: end if;

Line 533: pay_core_utils.assert_condition(

529: dbms_sql.close_cursor(sql_cur);
530: --
531: else
532: dbms_sql.close_cursor(sql_cur);
533: pay_core_utils.assert_condition(
534: 'pay_generic_upgrade.do_qualification:1',
535: 1 = 2);
536: end if;
537: --

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

755: l_thread_level,
756: l_qual_proc
757: from pay_report_groups rg,pay_payroll_actions ppa
758: where rg.report_format_mapping_id=l_rep_id
759: and pay_core_utils.get_parameter('REP_GROUP', ppa.legislative_parameters)=rg.short_name
760: and ppa.payroll_action_id=p_pactid;
761:
762:
763: else

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

760: and ppa.payroll_action_id=p_pactid;
761:
762:
763: else
764: select pay_core_utils.get_parameter('UPG_DEF_NAME',
765: ppa.legislative_parameters)
766: into l_upg_def_nm
767: from pay_payroll_actions ppa
768: where payroll_action_id = p_pactid;

Line 835: pay_core_utils.assert_condition(

831: );
832: --
833: end loop;
834: else
835: pay_core_utils.assert_condition(
836: 'pay_generic_upgrade.action_creation:1',
837: 1 = 2);
838: end if;
839: elsif (l_upg_level = 'L') then

Line 874: pay_core_utils.assert_condition(

870: );
871: --
872: end loop;
873: else
874: pay_core_utils.assert_condition(
875: 'pay_generic_upgrade.action_creation:2',
876: 1 = 2);
877: end if;
878: elsif (l_upg_level = 'G') then

Line 913: pay_core_utils.assert_condition(

909: );
910: --
911: end loop;
912: else
913: pay_core_utils.assert_condition(
914: 'pay_generic_upgrade.action_creation:3',
915: 1 = 2);
916: end if;
917: else

Line 918: pay_core_utils.assert_condition(

914: 'pay_generic_upgrade.action_creation:3',
915: 1 = 2);
916: end if;
917: else
918: pay_core_utils.assert_condition(
919: 'pay_generic_upgrade.action_creation:4',
920: 1 = 2);
921: end if;
922: end action_creation;

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

951: object_id pay_temp_object_actions.object_id%type;
952: --
953: begin
954: --
955: select pay_core_utils.get_parameter('UPG_DEF_NAME',
956: ppa.legislative_parameters),
957: ptoa.object_id
958: into l_upg_def_nm,
959: object_id

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

1004: --
1005: begin
1006: --
1007:
1008: select pay_core_utils.get_parameter('UPG_DEF_NAME',
1009: ppa.legislative_parameters),
1010: pay_core_utils.get_parameter('REMOVE_ACT',
1011: ppa.legislative_parameters),
1012: ppa.business_group_id,

Line 1010: pay_core_utils.get_parameter('REMOVE_ACT',

1006: --
1007:
1008: select pay_core_utils.get_parameter('UPG_DEF_NAME',
1009: ppa.legislative_parameters),
1010: pay_core_utils.get_parameter('REMOVE_ACT',
1011: ppa.legislative_parameters),
1012: ppa.business_group_id,
1013: pbg.legislation_code,
1014: ppa.report_type