APPS.PAY_BALANCE_UPLOAD dependencies on PAY_ACTION_CONTEXTS

Line 2060: -- For WCB type of elements should create an entry in pay_action_contexts

2056: -----------------------------------------------------------------------------
2057: -- NAME
2058: -- wcb_context_setup
2059: -- PURPOSE
2060: -- For WCB type of elements should create an entry in pay_action_contexts
2061: -- ARGUMENTS
2062: -- USES
2063: -- NOTES
2064: -----------------------------------------------------------------------------

Line 2279: hr_utility.trace('Updating pay_action_contexts');

2275: return;
2276: END IF;
2277:
2278: begin
2279: hr_utility.trace('Updating pay_action_contexts');
2280: select assignment_action_id into l_assignment_action_id from pay_assignment_actions where
2281: payroll_action_id = p_payroll_action_id and assignment_id = p_asg_id;
2282: hr_utility.trace('l_assignment_action_id '||l_assignment_action_id);
2283: INSERT INTO pay_action_contexts

Line 2283: INSERT INTO pay_action_contexts

2279: hr_utility.trace('Updating pay_action_contexts');
2280: select assignment_action_id into l_assignment_action_id from pay_assignment_actions where
2281: payroll_action_id = p_payroll_action_id and assignment_id = p_asg_id;
2282: hr_utility.trace('l_assignment_action_id '||l_assignment_action_id);
2283: INSERT INTO pay_action_contexts
2284: (ASSIGNMENT_ACTION_ID
2285: ,ASSIGNMENT_ID
2286: ,CONTEXT_ID
2287: ,CONTEXT_VALUE)

Line 2294: p_message := 'Insert Record in pay_action_contexts successfully';

2290: ,p_asg_id
2291: ,(select context_id from ff_contexts where context_name = 'SOURCE_ID')
2292: ,l_reporting_unit_id);
2293: commit;
2294: p_message := 'Insert Record in pay_action_contexts successfully';
2295: EXCEPTION
2296: when others then
2297: hr_utility.trace('Exception raised while inserting data in pay_action_contexts '||p_asg_id);
2298: p_message := 'Exception raised while inserting data in pay_action_contexts '||p_asg_id;

Line 2297: hr_utility.trace('Exception raised while inserting data in pay_action_contexts '||p_asg_id);

2293: commit;
2294: p_message := 'Insert Record in pay_action_contexts successfully';
2295: EXCEPTION
2296: when others then
2297: hr_utility.trace('Exception raised while inserting data in pay_action_contexts '||p_asg_id);
2298: p_message := 'Exception raised while inserting data in pay_action_contexts '||p_asg_id;
2299: end;
2300:
2301: end wcb_context_setup;

Line 2298: p_message := 'Exception raised while inserting data in pay_action_contexts '||p_asg_id;

2294: p_message := 'Insert Record in pay_action_contexts successfully';
2295: EXCEPTION
2296: when others then
2297: hr_utility.trace('Exception raised while inserting data in pay_action_contexts '||p_asg_id);
2298: p_message := 'Exception raised while inserting data in pay_action_contexts '||p_asg_id;
2299: end;
2300:
2301: end wcb_context_setup;
2302: