[Home] [Help]
1: PACKAGE BODY pay_payact_pkg as
2: /* $Header: pypayact.pkb 120.2.12020000.2 2012/07/27 16:04:17 rnestor ship $ */
3: /*
4: ******************************************************************
5: * *
16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_payact_pkg
21:
22: Description : This package defines the cursors needed to run
23: Payroll Activity Report for Multi-Threaded
24:
93: into leg_param
94: from pay_payroll_actions ppa
95: where ppa.payroll_action_id = pactid;
96:
97: -- pay_process := pay_payact_pkg.get_parameter('P_P_TY',leg_param);
98:
99: select ppa.legislative_parameters,
100: pay_payrg_pkg.get_parameter('P_P_TY', ppa.legislative_parameters),
101: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
712: l_business_group_id ,
713: l_start_date,
714: l_effective_date;
715: close c_inputs;
716: process_type := pay_payact_pkg.get_parameter('P_P_TY',leg_param) ;
717:
718: -- BALANCE AJUSTMENT
719: if process_type = 'BA' then
720:
743: -- dynamic assignment_set_id
744: -- Assignment set funtionality starts here and ends before the
745: -- endloop of this cur
746:
747: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
748:
749: -- Generating the assignment actions only for assignment where
750: -- Assignment_flag = Y
751: if ass_set_id is not null then
814: -- Assignment set funtionality starts here and ends before the
815: -- endloop of this cur
816:
817:
818: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
819:
820: -- Generating the assignment actions only for assignment where
821: -- Assignment_flag = Y
822: if ass_set_id is not null then
883: -- Assignment set funtionality starts here and ends before the
884: -- endloop of this cur
885:
886:
887: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
888:
889: -- Generating the assignment actions only for assignment where
890: -- Assignment_flag = Y
891: if ass_set_id is not null then
953: -- Assignment set funtionality starts here and ends before the
954: -- endloop of this cur
955:
956:
957: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
958:
959: -- Generating the assignment actions only for assignment where
960: -- Assignment_flag = Y
961: if ass_set_id is not null then
1023: -- Assignment set funtionality starts here and ends before the
1024: -- endloop of this cur
1025:
1026:
1027: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
1028:
1029: -- Generating the assignment actions only for assignment where
1030: -- Assignment_flag = Y
1031: if ass_set_id is not null then
1095: -- Assignment set funtionality starts here and ends before the
1096: -- endloop of this cur
1097:
1098:
1099: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
1100:
1101: -- Generating the assignment actions only for assignment where
1102: -- Assignment_flag = Y
1103: if ass_set_id is not null then
1167: -- Assignment set funtionality starts here and ends before the
1168: -- endloop of this cur
1169:
1170:
1171: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
1172:
1173: -- Generating the assignment actions only for assignment where
1174: -- Assignment_flag = Y
1175: if ass_set_id is not null then
1235: -- Assignment set funtionality starts here and ends before the
1236: -- endloop of this cur
1237:
1238:
1239: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
1240:
1241: -- Generating the assignment actions only for assignment where
1242: -- Assignment_flag = Y
1243: if ass_set_id is not null then
1417: return par_value;
1418: --
1419: end get_parameter;
1420:
1421: end pay_payact_pkg;