1: PACKAGE BODY pay_generic_upgrade AS
2: /* $Header: pycogus.pkb 120.5.12010000.6 2009/10/21 05:28:30 sivanara ship $ */
3:
4:
5: /* Name : set_upgrade_status
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;
40: --
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: --
62: end;
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;
85: --
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: --
107: end;
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;
131: --
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: --
155: end;
424: --
425: else
426: --
427: pay_core_utils.assert_condition(
428: 'pay_generic_upgrade.range_cursor:2',
429: 1 = 2);
430: --
431: end if;
432: --
468: --
469: else
470: --
471: pay_core_utils.assert_condition(
472: 'pay_generic_upgrade.range_cursor:3',
473: 1 = 2);
474: --
475: end if;
476: --
476: --
477: else
478: --
479: pay_core_utils.assert_condition(
480: 'pay_generic_upgrade.range_cursor:1',
481: 1 = 2);
482: --
483: end if;
484: --
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: --
538: else
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
840: if (l_thread_level = 'PER') then
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
879: if (l_thread_level = 'PER') then
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
918: pay_core_utils.assert_condition(
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;
923: --
1071: --
1072: end deinitialise;
1073: --
1074: --
1075: END pay_generic_upgrade;