APPS.PAY_CN_EXT dependencies on PAY_ACTION_INFORMATION

Line 54: hr_utility.set_location('China : Inserting into pay_action_information ', 30);

50: l_request_id := fnd_global.conc_request_id;
51:
52: hr_utility.set_location('China : Request ID -> '||l_request_id, 20);
53:
54: hr_utility.set_location('China : Inserting into pay_action_information ', 30);
55:
56: -- Insert the parameters into pay_action_information table so that
57: -- the parameters are available to other threads based on the request ID
58: --

Line 56: -- Insert the parameters into pay_action_information table so that

52: hr_utility.set_location('China : Request ID -> '||l_request_id, 20);
53:
54: hr_utility.set_location('China : Inserting into pay_action_information ', 30);
55:
56: -- Insert the parameters into pay_action_information table so that
57: -- the parameters are available to other threads based on the request ID
58: --
59: INSERT INTO pay_action_information
60: ( action_information_id

Line 59: INSERT INTO pay_action_information

55:
56: -- Insert the parameters into pay_action_information table so that
57: -- the parameters are available to other threads based on the request ID
58: --
59: INSERT INTO pay_action_information
60: ( action_information_id
61: , action_context_id -- Request Id
62: , action_context_type -- EXT
63: , action_information_category -- EXT_INFO

Line 75: ( pay_action_information_s.nextval

71: , action_information8 -- Filling Date
72: , action_information9 -- Report Type
73: )
74: VALUES
75: ( pay_action_information_s.nextval
76: , l_request_id
77: , 'EXT'
78: , 'EXT_INFO'
79: , p_phf_si_type

Line 93: hr_utility.set_location('China : Inserted into pay_action_information ', 40);

89:
90:
91: COMMIT;
92:
93: hr_utility.set_location('China : Inserted into pay_action_information ', 40);
94:
95: hr_utility.set_location('China : Leaving -> '||l_proc_name, 10);
96:
97: EXCEPTION

Line 137: hr_utility.set_location('China : Deleting row pay_action_information ', 30);

133: l_request_id := fnd_global.conc_request_id;
134:
135: hr_utility.set_location('China : Request ID -> '||l_request_id, 20);
136:
137: hr_utility.set_location('China : Deleting row pay_action_information ', 30);
138:
139: -- Delete from Pay_action_information
140: --
141: DELETE FROM pay_action_information

Line 139: -- Delete from Pay_action_information

135: hr_utility.set_location('China : Request ID -> '||l_request_id, 20);
136:
137: hr_utility.set_location('China : Deleting row pay_action_information ', 30);
138:
139: -- Delete from Pay_action_information
140: --
141: DELETE FROM pay_action_information
142: WHERE action_context_id = l_request_id
143: AND action_context_type = 'EXT'

Line 141: DELETE FROM pay_action_information

137: hr_utility.set_location('China : Deleting row pay_action_information ', 30);
138:
139: -- Delete from Pay_action_information
140: --
141: DELETE FROM pay_action_information
142: WHERE action_context_id = l_request_id
143: AND action_context_type = 'EXT'
144: AND action_information_category = 'EXT_INFO';
145:

Line 148: hr_utility.set_location('China : Deleted from pay_action_information ', 40);

144: AND action_information_category = 'EXT_INFO';
145:
146: COMMIT;
147:
148: hr_utility.set_location('China : Deleted from pay_action_information ', 40);
149:
150: hr_utility.set_location('China : Leaving -> '||l_proc_name, 10);
151:
152: EXCEPTION

Line 226: -- Cursor to fetch the data from pay_action_information based on

222: WHERE request_id = p_request_id;
223: --
224:
225:
226: -- Cursor to fetch the data from pay_action_information based on
227: -- request IDs
228: --
229: CURSOR csr_ext_info( p_request_id NUMBER
230: , p_parent_id NUMBER)

Line 242: FROM pay_action_information

238: , action_information6 -- Contribution Area
239: , action_information7 -- Contribution Year
240: , action_information8 -- Filling Date
241: , action_information9 -- Report Type
242: FROM pay_action_information
243: WHERE action_context_id IN ( p_request_id, p_parent_id)
244: AND action_context_type = 'EXT'
245: AND action_information_category = 'EXT_INFO';
246: --