APPS.PAY_SIMULATOR_SS_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 13: The Insertion of data into the PER_ASSIGNMENT_EXTRA_INFO and Submition

9: Name
10: Payroll Simulation Self Service Package
11: Purpose
12: This package handles the Payroll Simulation process requests from UI.
13: The Insertion of data into the PER_ASSIGNMENT_EXTRA_INFO and Submition
14: and completion of the Payroll Simulation Concurrent Program
15: History
16: 02 Feb 2013 apudiped Initial Version Created
17: 04 Feb 2013 apudiped Removed GSCC errors

Line 42: DELETE FROM per_assignment_extra_info

38: WHERE assignment_id = p_assignment_id
39: AND ACTION_CONTEXT_TYPE = 'ERROR';
40:
41:
42: DELETE FROM per_assignment_extra_info
43: WHERE assignment_id = p_assignment_id
44: AND aei_information_category like '%/_SIMULATION/_REGION_' escape '/';
45:
46: commit;

Line 88: FROM per_assignment_extra_info

84: , p_del_flag IN varchar2) IS
85: BEGIN
86: IF p_del_flag = 'true' THEN
87: DELETE
88: FROM per_assignment_extra_info
89: WHERE assignment_id = p_assignment_id
90: AND aei_information_category = p_info_category;
91: END IF;
92:

Line 94: INTO per_assignment_extra_info (assignment_extra_info_id

90: AND aei_information_category = p_info_category;
91: END IF;
92:
93: INSERT
94: INTO per_assignment_extra_info (assignment_extra_info_id
95: , assignment_id
96: , information_type
97: , aei_information_category
98: , aei_information1

Line 128: VALUES (per_assignment_extra_info_s.nextval

124: , aei_information27
125: , aei_information28
126: , aei_information29
127: , aei_information30)
128: VALUES (per_assignment_extra_info_s.nextval
129: , p_assignment_id
130: , p_info_category
131: , p_info_category
132: , p_val1