1: PACKAGE BODY pay_payact_pkg as
2: /* $Header: pypayact.pkb 120.1.12010000.2 2008/08/06 08:10:40 ubhat 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:
91: into leg_param
92: from pay_payroll_actions ppa
93: where ppa.payroll_action_id = pactid;
94:
95: -- pay_process := pay_payact_pkg.get_parameter('P_P_TY',leg_param);
96:
97: select ppa.legislative_parameters,
98: pay_payrg_pkg.get_parameter('P_P_TY', ppa.legislative_parameters),
99: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
709: l_business_group_id ,
710: l_start_date,
711: l_effective_date;
712: close c_inputs;
713: process_type := pay_payact_pkg.get_parameter('P_P_TY',leg_param) ;
714:
715: -- BALANCE AJUSTMENT
716: if process_type = 'BA' then
717:
740: -- dynamic assignment_set_id
741: -- Assignment set funtionality starts here and ends before the
742: -- endloop of this cur
743:
744: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
745:
746: -- Generating the assignment actions only for assignment where
747: -- Assignment_flag = Y
748: if ass_set_id is not null then
811: -- Assignment set funtionality starts here and ends before the
812: -- endloop of this cur
813:
814:
815: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
816:
817: -- Generating the assignment actions only for assignment where
818: -- Assignment_flag = Y
819: if ass_set_id is not null then
880: -- Assignment set funtionality starts here and ends before the
881: -- endloop of this cur
882:
883:
884: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
885:
886: -- Generating the assignment actions only for assignment where
887: -- Assignment_flag = Y
888: if ass_set_id is not null then
950: -- Assignment set funtionality starts here and ends before the
951: -- endloop of this cur
952:
953:
954: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
955:
956: -- Generating the assignment actions only for assignment where
957: -- Assignment_flag = Y
958: if ass_set_id is not null then
1020: -- Assignment set funtionality starts here and ends before the
1021: -- endloop of this cur
1022:
1023:
1024: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
1025:
1026: -- Generating the assignment actions only for assignment where
1027: -- Assignment_flag = Y
1028: if ass_set_id is not null then
1092: -- Assignment set funtionality starts here and ends before the
1093: -- endloop of this cur
1094:
1095:
1096: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
1097:
1098: -- Generating the assignment actions only for assignment where
1099: -- Assignment_flag = Y
1100: if ass_set_id is not null then
1164: -- Assignment set funtionality starts here and ends before the
1165: -- endloop of this cur
1166:
1167:
1168: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
1169:
1170: -- Generating the assignment actions only for assignment where
1171: -- Assignment_flag = Y
1172: if ass_set_id is not null then
1232: -- Assignment set funtionality starts here and ends before the
1233: -- endloop of this cur
1234:
1235:
1236: ass_set_id := pay_payact_pkg.get_parameter('PASID',leg_param);
1237:
1238: -- Generating the assignment actions only for assignment where
1239: -- Assignment_flag = Y
1240: if ass_set_id is not null then
1414: return par_value;
1415: --
1416: end get_parameter;
1417:
1418: end pay_payact_pkg;