eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_PAYTRN dependencies on PAY_COSTS

Line 135: and exists (select assignment_action_id from pay_costs where

131: and pai1.locking_action_id = paa2.assignment_action_id) -- End of changes for bug fix 3263333
132: and paa2.payroll_action_id = ppa2.payroll_action_id
133: and ppa2.action_type = 'C'
134: and ppa2.action_status='C'
135: and exists (select assignment_action_id from pay_costs where
136: assignment_action_id=paa2.assignment_action_id)
137: UNION
138: -- broke the decode for bug 6409008
139: /* Now for 'B'*/

Line 163: (select assignment_action_id from pay_costs where assignment_action_id=paa1.assignment_action_id))

159: and pai1.locked_action_id = paa2.assignment_action_id) -- End of changes for bug fix 3263333
160: and paa2.payroll_action_id = ppa2.payroll_action_id
161: and ppa2.action_type not in ('R','Q' ,'F','V')
162: and exists
163: (select assignment_action_id from pay_costs where assignment_action_id=paa1.assignment_action_id))
164: UNION
165: /* Now for '0' etc: */
166: (select paa1.assignment_id, paa1.assignment_action_id,
167: ppa1.payroll_id, ppa1.payroll_action_id, ppa1.effective_date, ppa1.date_earned,

Line 189: (select assignment_action_id from pay_costs where assignment_action_id=paa1.assignment_action_id))

185: and pai1.locked_action_id = paa2.assignment_action_id) -- End of changes for bug fix 3263333
186: and paa2.payroll_action_id = ppa2.payroll_action_id
187: and ppa2.action_type not in ('R','Q' ,'F','V')
188: and exists
189: (select assignment_action_id from pay_costs where assignment_action_id=paa1.assignment_action_id))
190: order by 9 desc, 7 desc, 2 desc; -- Bug 7116131;
191:
192: /*added end*/
193:

Line 244: and a.assignment_action_id in (select distinct(assignment_action_id) from pay_costs)

240: and (a.assignment_id = b.assignment_id and
241: ((l_start_date between effective_start_date and effective_end_date) or
242: (l_end_date between effective_start_date and effective_end_date) or
243: (l_start_date <= effective_start_date and l_end_date >= effective_end_date)))
244: and a.assignment_action_id in (select distinct(assignment_action_id) from pay_costs)
245: order by a.assignment_id;
246:
247:
248: check on effective date changed

Line 250: restriction on assignment_action id in selecting only those employees for whom arecord exists in pay_costs table:-

246:
247:
248: check on effective date changed
249: g_payroll_rec.effective_date between b.effective_start_date and b.effective_end_date)
250: restriction on assignment_action id in selecting only those employees for whom arecord exists in pay_costs table:-
251: fixed by Subha, :- Caltech
252: */
253: --Declare variables for above cursor
254:

Line 261: CURSOR get_pay_costs_csr is

257: l_person_id number := 0;
258: l_employee_name varchar2(240);
259: l_cur_rec number;
260:
261: CURSOR get_pay_costs_csr is
262: SELECT a.cost_id, --- REgular run results
263: a.costed_value,
264: a.debit_or_credit,
265: a.balance_or_cost,

Line 277: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,

273: ptp.start_date tp_start_date,
274: ptp.end_date tp_end_date,
275: ptp.time_period_id,
276: NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id
277: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,
278: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,
279: pay_input_values_f piv
280: WHERE a.assignment_action_id = l_assignment_action_id and
281: SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND

Line 319: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,

315: ptp.start_date tp_start_date,
316: ptp.end_date tp_end_date,
317: ptp.time_period_id,
318: NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id
319: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,
320: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,
321: pay_input_values_f piv
322: WHERE a.assignment_action_id = l_assignment_action_id and
323: SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND

Line 347: g_pay_costs_rec get_pay_costs_csr%ROWTYPE;

343: and ptp.payroll_id = l_payroll_id
344: and b.end_date between ptp.start_date and ptp.end_date
345: order by time_period_id desc , 15 asc;
346:
347: g_pay_costs_rec get_pay_costs_csr%ROWTYPE;
348:
349: CURSOR check_payroll_lines_csr is
350: SELECT cost_id
351: FROM PSP_PAYROLL_LINES

Line 352: WHERE cost_id = g_pay_costs_rec.cost_id;

348:
349: CURSOR check_payroll_lines_csr is
350: SELECT cost_id
351: FROM PSP_PAYROLL_LINES
352: WHERE cost_id = g_pay_costs_rec.cost_id;
353:
354: --Declare variable for above cursor
355:
356: l_cost_id number(15) := 0;

Line 518: WHERE element_entry_id = g_pay_costs_rec.source_id;

514:
515: CURSOR ee_date_earned_cur IS
516: SELECT effective_start_date, effective_end_date,date_earned --LD Dev
517: FROM pay_element_entries_f
518: WHERE element_entry_id = g_pay_costs_rec.source_id;
519:
520: CURSOR emphours_config_cur IS
521: SELECT DECODE(pcv_information1, 'Y', 'H', 'M') employee_hours
522: FROM pqp_configuration_values

Line 849: -- moving calendar logic to LOOP of get_pay_costs_csr

845:
846:
847: EXIT WHEN get_payroll_assig_actions_csr%NOTFOUND; -- Exit when last record is reached
848: BEGIN
849: -- moving calendar logic to LOOP of get_pay_costs_csr
850:
851:
852:
853:

Line 854: -- Get all transactions from pay_costs table based on

850:
851:
852:
853:
854: -- Get all transactions from pay_costs table based on
855: -- assignment_action_id we got from assignment actions
856:
857:
858: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_assigment_id, l_assignment_action_id, p_time_period_id = '||l_assignment_id||','||

Line 866: OPEN get_pay_costs_csr;

862: hr_utility.trace('l_assignment_action_id = '||l_assignment_action_id);
863: hr_utility.trace('p_time_period_id = '||p_time_period_id);
864: hr_utility.trace('g_payroll_asg_rec.effective_date = '||g_payroll_asg_rec.effective_date);
865:
866: OPEN get_pay_costs_csr;
867: FETCH get_pay_costs_csr into g_pay_costs_rec;
868: IF get_pay_costs_csr%NOTFOUND then
869: hr_utility.trace(' get_pay_costs_csr NO_DATA_FOUND l_assignment_action_id = '||l_assignment_action_id);
870: raise NO_COST_DATA_FOUND;

Line 867: FETCH get_pay_costs_csr into g_pay_costs_rec;

863: hr_utility.trace('p_time_period_id = '||p_time_period_id);
864: hr_utility.trace('g_payroll_asg_rec.effective_date = '||g_payroll_asg_rec.effective_date);
865:
866: OPEN get_pay_costs_csr;
867: FETCH get_pay_costs_csr into g_pay_costs_rec;
868: IF get_pay_costs_csr%NOTFOUND then
869: hr_utility.trace(' get_pay_costs_csr NO_DATA_FOUND l_assignment_action_id = '||l_assignment_action_id);
870: raise NO_COST_DATA_FOUND;
871: close get_pay_costs_csr;

Line 868: IF get_pay_costs_csr%NOTFOUND then

864: hr_utility.trace('g_payroll_asg_rec.effective_date = '||g_payroll_asg_rec.effective_date);
865:
866: OPEN get_pay_costs_csr;
867: FETCH get_pay_costs_csr into g_pay_costs_rec;
868: IF get_pay_costs_csr%NOTFOUND then
869: hr_utility.trace(' get_pay_costs_csr NO_DATA_FOUND l_assignment_action_id = '||l_assignment_action_id);
870: raise NO_COST_DATA_FOUND;
871: close get_pay_costs_csr;
872: END IF;

Line 869: hr_utility.trace(' get_pay_costs_csr NO_DATA_FOUND l_assignment_action_id = '||l_assignment_action_id);

865:
866: OPEN get_pay_costs_csr;
867: FETCH get_pay_costs_csr into g_pay_costs_rec;
868: IF get_pay_costs_csr%NOTFOUND then
869: hr_utility.trace(' get_pay_costs_csr NO_DATA_FOUND l_assignment_action_id = '||l_assignment_action_id);
870: raise NO_COST_DATA_FOUND;
871: close get_pay_costs_csr;
872: END IF;
873: close get_pay_costs_csr;

Line 871: close get_pay_costs_csr;

867: FETCH get_pay_costs_csr into g_pay_costs_rec;
868: IF get_pay_costs_csr%NOTFOUND then
869: hr_utility.trace(' get_pay_costs_csr NO_DATA_FOUND l_assignment_action_id = '||l_assignment_action_id);
870: raise NO_COST_DATA_FOUND;
871: close get_pay_costs_csr;
872: END IF;
873: close get_pay_costs_csr;
874: l_prev_time_period_id := null;
875: l_prev_start_date := TO_DATE('1','j');

Line 873: close get_pay_costs_csr;

869: hr_utility.trace(' get_pay_costs_csr NO_DATA_FOUND l_assignment_action_id = '||l_assignment_action_id);
870: raise NO_COST_DATA_FOUND;
871: close get_pay_costs_csr;
872: END IF;
873: close get_pay_costs_csr;
874: l_prev_time_period_id := null;
875: l_prev_start_date := TO_DATE('1','j');
876: l_prev_end_date := TO_DATE('1','j');
877:

Line 878: hr_utility.trace(' opening get_pay_costs_csr for l_assignment_action_id = '||l_assignment_action_id);

874: l_prev_time_period_id := null;
875: l_prev_start_date := TO_DATE('1','j');
876: l_prev_end_date := TO_DATE('1','j');
877:
878: hr_utility.trace(' opening get_pay_costs_csr for l_assignment_action_id = '||l_assignment_action_id);
879:
880: OPEN get_pay_costs_csr;
881: LOOP --LOOP1 begin
882: BEGIN

Line 880: OPEN get_pay_costs_csr;

876: l_prev_end_date := TO_DATE('1','j');
877:
878: hr_utility.trace(' opening get_pay_costs_csr for l_assignment_action_id = '||l_assignment_action_id);
879:
880: OPEN get_pay_costs_csr;
881: LOOP --LOOP1 begin
882: BEGIN
883: fetch get_pay_costs_csr into g_pay_costs_rec;
884: EXIT WHEN get_pay_costs_csr%NOTFOUND ;

Line 883: fetch get_pay_costs_csr into g_pay_costs_rec;

879:
880: OPEN get_pay_costs_csr;
881: LOOP --LOOP1 begin
882: BEGIN
883: fetch get_pay_costs_csr into g_pay_costs_rec;
884: EXIT WHEN get_pay_costs_csr%NOTFOUND ;
885:
886: hr_utility.trace(' NEXT loop iteration');
887: hr_utility.trace(' old value g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));

Line 884: EXIT WHEN get_pay_costs_csr%NOTFOUND ;

880: OPEN get_pay_costs_csr;
881: LOOP --LOOP1 begin
882: BEGIN
883: fetch get_pay_costs_csr into g_pay_costs_rec;
884: EXIT WHEN get_pay_costs_csr%NOTFOUND ;
885:
886: hr_utility.trace(' NEXT loop iteration');
887: hr_utility.trace(' old value g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
888: hr_utility.trace(' g_pay_costs_rec.source_id: ' || to_char(g_pay_costs_rec.source_id));

Line 888: hr_utility.trace(' g_pay_costs_rec.source_id: ' || to_char(g_pay_costs_rec.source_id));

884: EXIT WHEN get_pay_costs_csr%NOTFOUND ;
885:
886: hr_utility.trace(' NEXT loop iteration');
887: hr_utility.trace(' old value g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
888: hr_utility.trace(' g_pay_costs_rec.source_id: ' || to_char(g_pay_costs_rec.source_id));
889:
890: hr_utility.trace('***************Printing values************');
891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);
892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);

Line 891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);

887: hr_utility.trace(' old value g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
888: hr_utility.trace(' g_pay_costs_rec.source_id: ' || to_char(g_pay_costs_rec.source_id));
889:
890: hr_utility.trace('***************Printing values************');
891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);
892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);
893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);

Line 892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);

888: hr_utility.trace(' g_pay_costs_rec.source_id: ' || to_char(g_pay_costs_rec.source_id));
889:
890: hr_utility.trace('***************Printing values************');
891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);
892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);
893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);

Line 893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);

889:
890: hr_utility.trace('***************Printing values************');
891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);
892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);
893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);

Line 894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);

890: hr_utility.trace('***************Printing values************');
891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);
892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);
893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);

Line 895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);

891: hr_utility.trace('g_pay_costs_rec.cost_id = '||g_pay_costs_rec.cost_id);
892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);
893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);

Line 896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);

892: hr_utility.trace('g_pay_costs_rec.costed_value = '||g_pay_costs_rec.costed_value);
893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);

Line 897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);

893: hr_utility.trace('g_pay_costs_rec.debit_or_credit = '||g_pay_costs_rec.debit_or_credit);
894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);

Line 898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);

894: hr_utility.trace('g_pay_costs_rec.balance_or_cost = '||g_pay_costs_rec.balance_or_cost);
895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);

Line 899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);

895: hr_utility.trace('g_pay_costs_rec.cost_allocation_keyflex_id = '||g_pay_costs_rec.cost_allocation_keyflex_id);
896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);

Line 900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);

896: hr_utility.trace('g_pay_costs_rec.element_type_id = '||g_pay_costs_rec.element_type_id);
897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);
904: hr_utility.trace('g_pay_costs_rec.time_period_id = '||g_pay_costs_rec.time_period_id);

Line 901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);

897: hr_utility.trace('g_pay_costs_rec.output_currency_code = '||g_pay_costs_rec.output_currency_code);
898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);
904: hr_utility.trace('g_pay_costs_rec.time_period_id = '||g_pay_costs_rec.time_period_id);
905: hr_utility.trace('g_pay_costs_rec.source_id = '||g_pay_costs_rec.source_id);

Line 902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);

898: hr_utility.trace('g_pay_costs_rec.start_date = '||g_pay_costs_rec.start_date);
899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);
904: hr_utility.trace('g_pay_costs_rec.time_period_id = '||g_pay_costs_rec.time_period_id);
905: hr_utility.trace('g_pay_costs_rec.source_id = '||g_pay_costs_rec.source_id);
906: hr_utility.trace('***************Continue************');

Line 903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);

899: hr_utility.trace('g_pay_costs_rec.end_date = '||g_pay_costs_rec.end_date);
900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);
904: hr_utility.trace('g_pay_costs_rec.time_period_id = '||g_pay_costs_rec.time_period_id);
905: hr_utility.trace('g_pay_costs_rec.source_id = '||g_pay_costs_rec.source_id);
906: hr_utility.trace('***************Continue************');
907:

Line 904: hr_utility.trace('g_pay_costs_rec.time_period_id = '||g_pay_costs_rec.time_period_id);

900: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);
904: hr_utility.trace('g_pay_costs_rec.time_period_id = '||g_pay_costs_rec.time_period_id);
905: hr_utility.trace('g_pay_costs_rec.source_id = '||g_pay_costs_rec.source_id);
906: hr_utility.trace('***************Continue************');
907:
908:

Line 905: hr_utility.trace('g_pay_costs_rec.source_id = '||g_pay_costs_rec.source_id);

901: hr_utility.trace('g_pay_costs_rec.action_type = '||g_pay_costs_rec.action_type);
902: hr_utility.trace('g_pay_costs_rec.tp_start_date = '||g_pay_costs_rec.tp_start_date);
903: hr_utility.trace('g_pay_costs_rec.tp_end_date = '||g_pay_costs_rec.tp_end_date);
904: hr_utility.trace('g_pay_costs_rec.time_period_id = '||g_pay_costs_rec.time_period_id);
905: hr_utility.trace('g_pay_costs_rec.source_id = '||g_pay_costs_rec.source_id);
906: hr_utility.trace('***************Continue************');
907:
908:
909: g_entry_date_earned := NULL;

Line 920: hr_utility.trace(' g_pay_costs_rec.date_earned: ' || to_char(g_pay_costs_rec.date_earned,'DD-MON-YYYY'));

916:
917: hr_utility.trace(' after cursor g_effective_start_date: ' || to_char(g_effective_start_date,'DD-MON-YYYY'));
918: hr_utility.trace(' after cursor g_effective_end_date: ' || to_char(g_effective_end_date,'DD-MON-YYYY'));
919: hr_utility.trace(' after cursor g_entry_date_earned: ' || to_char(g_entry_date_earned,'DD-MON-YYYY'));
920: hr_utility.trace(' g_pay_costs_rec.date_earned: ' || to_char(g_pay_costs_rec.date_earned,'DD-MON-YYYY'));
921:
922: /* Commented for bug 6046087
923: -- Bug 5642002: get the element date if available
924: g_start_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.start_date), g_pay_costs_rec.tp_start_date);

Line 924: g_start_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.start_date), g_pay_costs_rec.tp_start_date);

920: hr_utility.trace(' g_pay_costs_rec.date_earned: ' || to_char(g_pay_costs_rec.date_earned,'DD-MON-YYYY'));
921:
922: /* Commented for bug 6046087
923: -- Bug 5642002: get the element date if available
924: g_start_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.start_date), g_pay_costs_rec.tp_start_date);
925: g_end_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.end_date), g_pay_costs_rec.tp_end_date);
926: */
927:
928: -- Introduced the following IF - END IF for Bug 6046087

Line 925: g_end_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.end_date), g_pay_costs_rec.tp_end_date);

921:
922: /* Commented for bug 6046087
923: -- Bug 5642002: get the element date if available
924: g_start_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.start_date), g_pay_costs_rec.tp_start_date);
925: g_end_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.end_date), g_pay_costs_rec.tp_end_date);
926: */
927:
928: -- Introduced the following IF - END IF for Bug 6046087
929: IF (g_ignore_date_earned = 'Y') THEN

Line 930: g_start_date := g_pay_costs_rec.tp_start_date;

926: */
927:
928: -- Introduced the following IF - END IF for Bug 6046087
929: IF (g_ignore_date_earned = 'Y') THEN
930: g_start_date := g_pay_costs_rec.tp_start_date;
931: g_end_date := g_pay_costs_rec.tp_end_date;
932:
933: hr_utility.trace('IF cost_id, start_Date,
934: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||

Line 931: g_end_date := g_pay_costs_rec.tp_end_date;

927:
928: -- Introduced the following IF - END IF for Bug 6046087
929: IF (g_ignore_date_earned = 'Y') THEN
930: g_start_date := g_pay_costs_rec.tp_start_date;
931: g_end_date := g_pay_costs_rec.tp_end_date;
932:
933: hr_utility.trace('IF cost_id, start_Date,
934: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||
935: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||

Line 934: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||

930: g_start_date := g_pay_costs_rec.tp_start_date;
931: g_end_date := g_pay_costs_rec.tp_end_date;
932:
933: hr_utility.trace('IF cost_id, start_Date,
934: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||
935: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||
936: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
937:
938: ELSE

Line 935: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||

931: g_end_date := g_pay_costs_rec.tp_end_date;
932:
933: hr_utility.trace('IF cost_id, start_Date,
934: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||
935: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||
936: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
937:
938: ELSE
939: -- Moved the following statement inside ELSE clause for bug 8993953 to avoid overrides

Line 936: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);

932:
933: hr_utility.trace('IF cost_id, start_Date,
934: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||
935: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||
936: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
937:
938: ELSE
939: -- Moved the following statement inside ELSE clause for bug 8993953 to avoid overrides
940: g_pay_costs_rec.date_earned := NVL(g_entry_date_earned, g_pay_costs_rec.date_earned);

Line 940: g_pay_costs_rec.date_earned := NVL(g_entry_date_earned, g_pay_costs_rec.date_earned);

936: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
937:
938: ELSE
939: -- Moved the following statement inside ELSE clause for bug 8993953 to avoid overrides
940: g_pay_costs_rec.date_earned := NVL(g_entry_date_earned, g_pay_costs_rec.date_earned);
941:
942: hr_utility.trace(' after nvl condition g_pay_costs_rec.date_earned: ' || to_char(g_pay_costs_rec.date_earned,'DD-MON-YYYY'));
943:
944: g_start_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.start_date), g_pay_costs_rec.tp_start_date);

Line 942: hr_utility.trace(' after nvl condition g_pay_costs_rec.date_earned: ' || to_char(g_pay_costs_rec.date_earned,'DD-MON-YYYY'));

938: ELSE
939: -- Moved the following statement inside ELSE clause for bug 8993953 to avoid overrides
940: g_pay_costs_rec.date_earned := NVL(g_entry_date_earned, g_pay_costs_rec.date_earned);
941:
942: hr_utility.trace(' after nvl condition g_pay_costs_rec.date_earned: ' || to_char(g_pay_costs_rec.date_earned,'DD-MON-YYYY'));
943:
944: g_start_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.start_date), g_pay_costs_rec.tp_start_date);
945: g_end_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.end_date), g_pay_costs_rec.tp_end_date);
946:

Line 944: g_start_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.start_date), g_pay_costs_rec.tp_start_date);

940: g_pay_costs_rec.date_earned := NVL(g_entry_date_earned, g_pay_costs_rec.date_earned);
941:
942: hr_utility.trace(' after nvl condition g_pay_costs_rec.date_earned: ' || to_char(g_pay_costs_rec.date_earned,'DD-MON-YYYY'));
943:
944: g_start_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.start_date), g_pay_costs_rec.tp_start_date);
945: g_end_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.end_date), g_pay_costs_rec.tp_end_date);
946:
947: hr_utility.trace('ELSE cost_id, start_Date,
948: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||

Line 945: g_end_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.end_date), g_pay_costs_rec.tp_end_date);

941:
942: hr_utility.trace(' after nvl condition g_pay_costs_rec.date_earned: ' || to_char(g_pay_costs_rec.date_earned,'DD-MON-YYYY'));
943:
944: g_start_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.start_date), g_pay_costs_rec.tp_start_date);
945: g_end_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.end_date), g_pay_costs_rec.tp_end_date);
946:
947: hr_utility.trace('ELSE cost_id, start_Date,
948: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||
949: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||

Line 948: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||

944: g_start_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.start_date), g_pay_costs_rec.tp_start_date);
945: g_end_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.end_date), g_pay_costs_rec.tp_end_date);
946:
947: hr_utility.trace('ELSE cost_id, start_Date,
948: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||
949: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||
950: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
951: END IF;
952:

Line 949: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||

945: g_end_date := NVL(NVL(g_entry_date_earned, g_pay_costs_rec.end_date), g_pay_costs_rec.tp_end_date);
946:
947: hr_utility.trace('ELSE cost_id, start_Date,
948: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||
949: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||
950: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
951: END IF;
952:
953: hr_utility.trace(' g_start_date ' || to_char(g_start_date,'DD-MON-YYYY'));

Line 950: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);

946:
947: hr_utility.trace('ELSE cost_id, start_Date,
948: end_Date, tp_id , action_type='||g_pay_costs_rec.cost_id||','||
949: g_pay_costs_rec.tp_start_date||','||g_pay_costs_rec.tp_end_date||','||
950: g_pay_costs_rec.time_period_id||','||g_pay_costs_rec.action_type);
951: END IF;
952:
953: hr_utility.trace(' g_start_date ' || to_char(g_start_date,'DD-MON-YYYY'));
954: hr_utility.trace(' g_end_date ' || to_char(g_end_date,'DD-MON-YYYY'));

Line 969: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||

965: IF (l_aw_column IS NOT NULL) THEN
966: BEGIN
967: EXECUTE IMMEDIATE 'SELECT ' || l_gl_column || ', ' || l_pt_column || ', ' ||
968: l_tk_column || ', ' || l_aw_column || ', ' || l_eo_column || ', ' || l_et_column ||
969: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
970: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
971: INTO l_or_gl_ccid, l_or_project_id, l_or_task_id, l_or_award_id, l_or_expenditure_org_id, l_or_expenditure_type
972: USING g_pay_costs_rec.date_earned;
973: EXCEPTION

Line 972: USING g_pay_costs_rec.date_earned;

968: l_tk_column || ', ' || l_aw_column || ', ' || l_eo_column || ', ' || l_et_column ||
969: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
970: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
971: INTO l_or_gl_ccid, l_or_project_id, l_or_task_id, l_or_award_id, l_or_expenditure_org_id, l_or_expenditure_type
972: USING g_pay_costs_rec.date_earned;
973: EXCEPTION
974: WHEN OTHERS THEN
975: hr_utility.trace(' No Element Entry record found');
976: END;

Line 981: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||

977: ELSE
978: BEGIN
979: EXECUTE IMMEDIATE 'SELECT ' || l_gl_column || ', ' || l_pt_column || ', ' ||
980: l_tk_column || ', ' || l_eo_column || ', ' || l_et_column ||
981: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
982: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
983: INTO l_or_gl_ccid, l_or_project_id, l_or_task_id, l_or_expenditure_org_id, l_or_expenditure_type
984: USING g_pay_costs_rec.date_earned;
985: EXCEPTION

Line 984: USING g_pay_costs_rec.date_earned;

980: l_tk_column || ', ' || l_eo_column || ', ' || l_et_column ||
981: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
982: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
983: INTO l_or_gl_ccid, l_or_project_id, l_or_task_id, l_or_expenditure_org_id, l_or_expenditure_type
984: USING g_pay_costs_rec.date_earned;
985: EXCEPTION
986: WHEN OTHERS THEN
987: hr_utility.trace(' No Element Entry record found');
988: END;

Line 993: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||

989: END IF;
990: ELSIF (l_gl_column IS NOT NULL) THEN
991: BEGIN
992: EXECUTE IMMEDIATE 'SELECT ' || l_gl_column ||
993: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
994: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
995: INTO l_or_gl_ccid
996: USING g_pay_costs_rec.date_earned;
997: EXCEPTION

Line 996: USING g_pay_costs_rec.date_earned;

992: EXECUTE IMMEDIATE 'SELECT ' || l_gl_column ||
993: ' FROM pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
994: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
995: INTO l_or_gl_ccid
996: USING g_pay_costs_rec.date_earned;
997: EXCEPTION
998: WHEN OTHERS THEN
999: hr_utility.trace(' No Element Entry record found');
1000: END;

Line 1007: g_pay_costs_rec.source_id ||

1003: BEGIN
1004: EXECUTE IMMEDIATE 'SELECT ' || l_pt_column || ', ' || l_tk_column || ', ' ||
1005: l_aw_column || ', ' || l_eo_column || ', ' || l_et_column ||
1006: ' FROM pay_element_entries_f WHERE element_entry_id = ' ||
1007: g_pay_costs_rec.source_id ||
1008: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
1009: INTO l_or_project_id, l_or_task_id, l_or_award_id, l_or_expenditure_org_id, l_or_expenditure_type
1010: USING g_pay_costs_rec.date_earned;
1011: EXCEPTION

Line 1010: USING g_pay_costs_rec.date_earned;

1006: ' FROM pay_element_entries_f WHERE element_entry_id = ' ||
1007: g_pay_costs_rec.source_id ||
1008: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
1009: INTO l_or_project_id, l_or_task_id, l_or_award_id, l_or_expenditure_org_id, l_or_expenditure_type
1010: USING g_pay_costs_rec.date_earned;
1011: EXCEPTION
1012: WHEN OTHERS THEN
1013: hr_utility.trace(' No Element Entry record found');
1014: END;

Line 1020: g_pay_costs_rec.source_id ||

1016: BEGIN
1017: EXECUTE IMMEDIATE 'SELECT ' || l_pt_column || ', ' || l_tk_column || ', ' ||
1018: l_eo_column || ', ' || l_et_column ||
1019: ' FROM pay_element_entries_f WHERE element_entry_id = ' ||
1020: g_pay_costs_rec.source_id ||
1021: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
1022: INTO l_or_project_id, l_or_task_id, l_or_expenditure_org_id, l_or_expenditure_type
1023: USING g_pay_costs_rec.date_earned;
1024: EXCEPTION

Line 1023: USING g_pay_costs_rec.date_earned;

1019: ' FROM pay_element_entries_f WHERE element_entry_id = ' ||
1020: g_pay_costs_rec.source_id ||
1021: ' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
1022: INTO l_or_project_id, l_or_task_id, l_or_expenditure_org_id, l_or_expenditure_type
1023: USING g_pay_costs_rec.date_earned;
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: hr_utility.trace(' No Element Entry record found');
1027: END;

Line 1039: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;

1035: SELECT full_name
1036: INTO l_employee_name
1037: FROM per_people_f
1038: WHERE person_id = l_person_id
1039: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1040: l_value := 'Organization Id = ' || TO_CHAR(l_or_expenditure_org_id);
1041: l_table := 'HR_ORGANIZATION_UNITS';
1042: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1043: fnd_message.set_token('VALUE', l_value);

Line 1059: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;

1055: SELECT full_name
1056: INTO l_employee_name
1057: FROM per_people_f
1058: WHERE person_id = l_person_id
1059: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1060: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1061: l_table := 'PA_PROJECTS_ALL';
1062: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1063: fnd_message.set_token('VALUE',l_value);

Line 1079: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;

1075: SELECT full_name
1076: INTO l_employee_name
1077: FROM per_people_f
1078: WHERE person_id = l_person_id
1079: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1080: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1081: l_table := 'PA_PROJECTS_ALL';
1082: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
1083: fnd_message.set_token('VALUE',l_value);

Line 1099: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;

1095: SELECT full_name
1096: INTO l_employee_name
1097: FROM per_people_f
1098: WHERE person_id = l_person_id
1099: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1100: l_value := 'TaskId = ' || TO_CHAR(l_or_task_id);
1101: l_table := 'PA_TASKS';
1102: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1103: fnd_message.set_token('VALUE',l_value);

Line 1120: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;

1116: SELECT full_name
1117: INTO l_employee_name
1118: FROM per_people_f
1119: WHERE person_id = l_person_id
1120: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1121: l_value := 'Award Id = ' || TO_CHAR(l_or_award_id);
1122: l_table := 'GMS_AWARDS_ALL';
1123: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1124: fnd_message.set_token('VALUE',l_value);

Line 1141: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;

1137: SELECT full_name
1138: INTO l_employee_name
1139: FROM per_people_f
1140: WHERE person_id = l_person_id
1141: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1142: l_value := 'Expenditure Type = ' || l_or_expenditure_type;
1143: l_table := 'PA_EXPENDITURE_TYPES';
1144: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1145: fnd_message.set_token('VALUE',l_value);

Line 1156: if g_pay_costs_rec.time_period_id <> nvl(l_prev_time_period_id, -1) OR

1152: CLOSE expenditure_type_cur;
1153: END IF;
1154:
1155: --- recreate the calendar for reversal time period
1156: if g_pay_costs_rec.time_period_id <> nvl(l_prev_time_period_id, -1) OR
1157: g_start_date <> l_prev_start_date OR
1158: g_end_date <> l_prev_end_date
1159: then
1160: hr_utility.trace(' CHANGE IN TIME PERIOD ');

Line 1161: l_prev_time_period_id := g_pay_costs_rec.time_period_id;

1157: g_start_date <> l_prev_start_date OR
1158: g_end_date <> l_prev_end_date
1159: then
1160: hr_utility.trace(' CHANGE IN TIME PERIOD ');
1161: l_prev_time_period_id := g_pay_costs_rec.time_period_id;
1162: l_prev_start_date := g_start_date;
1163: l_prev_end_date := g_end_date;
1164:
1165: -- Create an working calander (array) for this transaction.

Line 1169: -- moved the calendar code inside the get_pay_costs cursor for handling of payroll reversals

1165: -- Create an working calander (array) for this transaction.
1166: -- Array contains no of rows that is equal to no. of days that payroll period has.
1167: -- Each row will have either 'Y' if that day is working day or 'N' if
1168: -- that day is non-working day
1169: -- moved the calendar code inside the get_pay_costs cursor for handling of payroll reversals
1170: -- CREATE_WORKING_CALENDAR;
1171: create_working_calendar(l_assignment_id);
1172: g_no_of_person_work_days := g_no_of_work_days;
1173:

Line 1212: if (g_pay_costs_rec.time_period_id = time_period_id_a(i)

1208:
1209: for i in 1..time_period_id_a.count
1210: loop
1211: hr_utility.trace(' KKKK='||i);
1212: if (g_pay_costs_rec.time_period_id = time_period_id_a(i)
1213: AND g_pay_costs_rec.output_currency_code = currency_code_a(i)) -- Bug 6468271
1214: then
1215: hr_utility.trace(' KXyy='||i);
1216: l_export_id := payroll_control_id_a(i);

Line 1213: AND g_pay_costs_rec.output_currency_code = currency_code_a(i)) -- Bug 6468271

1209: for i in 1..time_period_id_a.count
1210: loop
1211: hr_utility.trace(' KKKK='||i);
1212: if (g_pay_costs_rec.time_period_id = time_period_id_a(i)
1213: AND g_pay_costs_rec.output_currency_code = currency_code_a(i)) -- Bug 6468271
1214: then
1215: hr_utility.trace(' KXyy='||i);
1216: l_export_id := payroll_control_id_a(i);
1217: hr_utility.trace(' KXzy='||i);

Line 1231: hr_utility.trace(' Found cost record Cost_id, costed_value =' ||g_pay_costs_rec.cost_id||','||g_pay_costs_rec.costed_value);

1227: end;
1228: hr_utility.trace(' AFTER SET l_export_id');
1229: end if;
1230:
1231: hr_utility.trace(' Found cost record Cost_id, costed_value =' ||g_pay_costs_rec.cost_id||','||g_pay_costs_rec.costed_value);
1232: -- Bug 1994421 : Zero Work Days Build - Assigned values to variables for processing non active assignments -lveerubh
1233: g_non_active_flag := 'N';
1234: g_hire_zero_Work_days := 'N';
1235: g_all_holiday_zero_work_days := 'N';

Line 1240: X_COSTED_VALUE => g_pay_costs_rec.costed_value,

1236: /* New procedure added for continuing if zero work days :- Caltech, Yale :- subha */
1237:
1238: /*IF ((g_entry_date_earned IS NULL) or (g_ignore_date_earned = 'Y')) THEN -- Bug 6046087*/ --6779790
1239: CHECK_ZERO_WORK_DAYS( X_ASSIGNMENT_ID => l_assignment_id,
1240: X_COSTED_VALUE => g_pay_costs_rec.costed_value,
1241: x_start_date => TRUNC(g_start_date), --Bug 6046087
1242: x_end_date => TRUNC(g_end_date), --Bug 6046087
1243: X_RETURN_STATUS => l_return_status);
1244:

Line 1271: hr_utility.trace(' l_prev_currency_code, g_pay_costs_rec.output_currency_code = '||l_prev_currency_code||','||

1267: hr_utility.trace(' l_counter = '||l_counter);
1268: IF l_counter > 0 then
1269: -- Introduced for bug fix 2916848
1270:
1271: hr_utility.trace(' l_prev_currency_code, g_pay_costs_rec.output_currency_code = '||l_prev_currency_code||','||
1272: g_pay_costs_rec.output_currency_code);
1273: -- Commented this if condition for bug 9435225
1274: -- IF nvl(l_prev_currency_code,g_pay_costs_rec.output_currency_code) <> g_pay_costs_rec.output_currency_code THEN
1275: l_prev_currency_code := g_pay_costs_rec.output_currency_code;

Line 1272: g_pay_costs_rec.output_currency_code);

1268: IF l_counter > 0 then
1269: -- Introduced for bug fix 2916848
1270:
1271: hr_utility.trace(' l_prev_currency_code, g_pay_costs_rec.output_currency_code = '||l_prev_currency_code||','||
1272: g_pay_costs_rec.output_currency_code);
1273: -- Commented this if condition for bug 9435225
1274: -- IF nvl(l_prev_currency_code,g_pay_costs_rec.output_currency_code) <> g_pay_costs_rec.output_currency_code THEN
1275: l_prev_currency_code := g_pay_costs_rec.output_currency_code;
1276: l_export_id := NULL;

Line 1274: -- IF nvl(l_prev_currency_code,g_pay_costs_rec.output_currency_code) <> g_pay_costs_rec.output_currency_code THEN

1270:
1271: hr_utility.trace(' l_prev_currency_code, g_pay_costs_rec.output_currency_code = '||l_prev_currency_code||','||
1272: g_pay_costs_rec.output_currency_code);
1273: -- Commented this if condition for bug 9435225
1274: -- IF nvl(l_prev_currency_code,g_pay_costs_rec.output_currency_code) <> g_pay_costs_rec.output_currency_code THEN
1275: l_prev_currency_code := g_pay_costs_rec.output_currency_code;
1276: l_export_id := NULL;
1277: FOR i IN 1..r_payroll_control_array.r_payroll_control_id.COUNT
1278: LOOP

Line 1275: l_prev_currency_code := g_pay_costs_rec.output_currency_code;

1271: hr_utility.trace(' l_prev_currency_code, g_pay_costs_rec.output_currency_code = '||l_prev_currency_code||','||
1272: g_pay_costs_rec.output_currency_code);
1273: -- Commented this if condition for bug 9435225
1274: -- IF nvl(l_prev_currency_code,g_pay_costs_rec.output_currency_code) <> g_pay_costs_rec.output_currency_code THEN
1275: l_prev_currency_code := g_pay_costs_rec.output_currency_code;
1276: l_export_id := NULL;
1277: FOR i IN 1..r_payroll_control_array.r_payroll_control_id.COUNT
1278: LOOP
1279: IF (r_payroll_control_array.r_currency_code(i) = l_prev_currency_code) THEN

Line 1293: IF (g_pay_costs_rec.output_currency_code = g_bg_currency_code AND

1289: END LOOP;
1290: -- END IF;
1291:
1292: -- Introduced the following for bug fix 3107800
1293: IF (g_pay_costs_rec.output_currency_code = g_bg_currency_code AND
1294: g_bg_currency_code = g_sob_currency_code) THEN
1295: l_exchange_rate_type := NULL;
1296: ELSE
1297: l_exchange_rate_type := g_exchange_rate_type;

Line 1321: psp_general.get_currency_precision(g_pay_costs_rec.output_currency_code,

1317:
1318: l_total_num_rec:= l_total_num_rec + 1;
1319: l_cur_rec:= l_total_num_rec;
1320:
1321: psp_general.get_currency_precision(g_pay_costs_rec.output_currency_code,
1322: g_precision,
1323: g_ext_precision);
1324:
1325: r_payroll_control_array.r_currency_code(l_cur_rec) := g_pay_costs_rec.output_currency_code;

Line 1325: r_payroll_control_array.r_currency_code(l_cur_rec) := g_pay_costs_rec.output_currency_code;

1321: psp_general.get_currency_precision(g_pay_costs_rec.output_currency_code,
1322: g_precision,
1323: g_ext_precision);
1324:
1325: r_payroll_control_array.r_currency_code(l_cur_rec) := g_pay_costs_rec.output_currency_code;
1326:
1327: r_payroll_control_array.r_payroll_control_id(l_cur_rec) := l_export_id;
1328:
1329: r_payroll_control_array.r_tot_dr(l_cur_rec) := 0;

Line 1337: l_prev_currency_code := g_pay_costs_rec.output_currency_code;

1333: r_payroll_control_array.r_precision(l_cur_rec):= g_precision;
1334: r_payroll_control_array.r_ext_precision(l_cur_rec):=g_ext_precision;
1335:
1336:
1337: l_prev_currency_code := g_pay_costs_rec.output_currency_code;
1338:
1339:
1340: PSP_PAYROLL_CONTROLS_PKG.INSERT_ROW(
1341: X_ROWID => x_rowid,

Line 1347: X_TIME_PERIOD_ID => g_pay_costs_rec.time_period_id,

1343: X_PAYROLL_ACTION_ID => g_payroll_asg_rec.payroll_action_id,
1344: X_PAYROLL_SOURCE_CODE => l_payroll_source,
1345: X_SOURCE_TYPE => 'O',
1346: X_PAYROLL_ID => l_payroll_id,
1347: X_TIME_PERIOD_ID => g_pay_costs_rec.time_period_id,
1348: X_BATCH_NAME => NULL,
1349: X_NUMBER_OF_CR => 0,
1350: X_NUMBER_OF_DR => 0,
1351: X_TOTAL_DR_AMOUNT => 0,

Line 1371: x_currency_code => g_pay_costs_rec.output_currency_code,

1367: X_GL_PHASE => NULL,
1368: X_GMS_PHASE => NULL,
1369: X_ADJ_SUM_BATCH_NAME => NULL,
1370: -- Introduced the following for bug fix 2916848
1371: x_currency_code => g_pay_costs_rec.output_currency_code,
1372: x_exchange_rate_type => null,
1373: x_parent_payroll_control_id => l_parent_control_id); --- exch rate =null for 3108109
1374:
1375: l_array_count := nvl(time_period_id_a.count,0) + 1;

Line 1376: time_period_id_a(l_array_count) := g_pay_costs_rec.time_period_id;

1372: x_exchange_rate_type => null,
1373: x_parent_payroll_control_id => l_parent_control_id); --- exch rate =null for 3108109
1374:
1375: l_array_count := nvl(time_period_id_a.count,0) + 1;
1376: time_period_id_a(l_array_count) := g_pay_costs_rec.time_period_id;
1377: payroll_control_id_a(l_array_count ) := l_export_id;
1378: currency_code_a(l_array_count) := g_pay_costs_rec.output_currency_code; -- Bug 6468271
1379:
1380: update psp_payroll_controls

Line 1378: currency_code_a(l_array_count) := g_pay_costs_rec.output_currency_code; -- Bug 6468271

1374:
1375: l_array_count := nvl(time_period_id_a.count,0) + 1;
1376: time_period_id_a(l_array_count) := g_pay_costs_rec.time_period_id;
1377: payroll_control_id_a(l_array_count ) := l_export_id;
1378: currency_code_a(l_array_count) := g_pay_costs_rec.output_currency_code; -- Bug 6468271
1379:
1380: update psp_payroll_controls
1381: set run_id = l_run_id
1382: where payroll_control_id = l_export_id;

Line 1393: P_COST_KEYFLEX_ID => g_pay_costs_rec.cost_allocation_keyflex_id,

1389:
1390: PSP_GENERAL.GET_GL_CCID(
1391: P_PAYROLL_ID => l_payroll_id,
1392: P_SET_OF_BOOKS_ID => l_resp_set_of_books_id,
1393: P_COST_KEYFLEX_ID => g_pay_costs_rec.cost_allocation_keyflex_id,
1394: X_GL_CCID => l_gl_ccid);
1395:
1396: IF l_gl_ccid = 0 or l_gl_ccid IS NULL then
1397: l_error_api_name := 'GET_GL_CCID : ';

Line 1399: fnd_message.set_token('COST_ID', g_pay_costs_rec.cost_allocation_keyflex_id);

1395:
1396: IF l_gl_ccid = 0 or l_gl_ccid IS NULL then
1397: l_error_api_name := 'GET_GL_CCID : ';
1398: fnd_message.set_name('PSP','PSP_NO_GL_FOR_COSTING');
1399: fnd_message.set_token('COST_ID', g_pay_costs_rec.cost_allocation_keyflex_id);
1400: fnd_msg_pub.add;
1401: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1402: ELSIF l_gl_ccid <> l_clearing_account then
1403: l_gl_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_gl_ccid);

Line 1410: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);

1406: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1407: fnd_message.set_token('GL_ACCOUNT', l_gl_value);
1408: fnd_message.set_token('CLEARING', l_clearing_account_value);
1409: fnd_msg_pub.add;
1410: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1411: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1412: END IF;
1413: hr_utility.trace(' pass kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1414:

Line 1413: hr_utility.trace(' pass kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);

1409: fnd_msg_pub.add;
1410: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1411: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1412: END IF;
1413: hr_utility.trace(' pass kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1414:
1415: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_line_id
1416: FROM DUAL;
1417: x_rowid := NULL;

Line 1425: l_gms_posting_date := g_pay_costs_rec.date_earned;

1421: hr_utility.trace('g_non_active_flag = '||g_non_active_flag);
1422: If g_non_active_flag = 'Y' then
1423: -- date earned will be the max date any child sub line can take as effective date.
1424:
1425: l_gms_posting_date := g_pay_costs_rec.date_earned;
1426: hr_utility.trace('l_gms_posting_date = '||l_gms_posting_date);
1427:
1428: psp_general.get_gms_effective_date(l_person_id, l_gms_posting_date);
1429: hr_utility.trace('After proc call - l_gms_posting_date = '||l_gms_posting_date);

Line 1436: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);

1432:
1433: hr_utility.trace('l_gms_posting_date is null');
1434:
1435: hr_utility.trace('l_person_id = '||l_person_id);
1436: hr_utility.trace('g_pay_costs_rec.date_earned = '||g_pay_costs_rec.date_earned);
1437:
1438: hr_utility.trace('I might fail now');
1439:
1440: select distinct substr(full_name,1,50)

Line 1444: g_pay_costs_rec.date_earned between effective_start_date and effective_end_date;

1440: select distinct substr(full_name,1,50)
1441: into l_employee_name
1442: from per_people_f
1443: where person_id = l_person_id and
1444: g_pay_costs_rec.date_earned between effective_start_date and effective_end_date;
1445:
1446: hr_utility.trace('Am i successful');
1447:
1448: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_PRMRY_ASG_INACTIVE');

Line 1476: X_COST_ID => g_pay_costs_rec.cost_id,

1472: X_PAYROLL_CONTROL_ID => l_export_id ,
1473: X_SET_OF_BOOKS_ID => l_resp_set_of_books_id ,
1474: X_ASSIGNMENT_ID => l_assignment_id ,
1475: X_PERSON_ID => l_person_id ,
1476: X_COST_ID => g_pay_costs_rec.cost_id,
1477: X_ELEMENT_TYPE_ID => g_pay_costs_rec.element_type_id,
1478: X_PAY_AMOUNT => g_pay_costs_rec.costed_value ,
1479: X_STATUS_CODE => l_status_code ,
1480: X_EFFECTIVE_DATE => g_payroll_asg_rec.accounting_date,

Line 1477: X_ELEMENT_TYPE_ID => g_pay_costs_rec.element_type_id,

1473: X_SET_OF_BOOKS_ID => l_resp_set_of_books_id ,
1474: X_ASSIGNMENT_ID => l_assignment_id ,
1475: X_PERSON_ID => l_person_id ,
1476: X_COST_ID => g_pay_costs_rec.cost_id,
1477: X_ELEMENT_TYPE_ID => g_pay_costs_rec.element_type_id,
1478: X_PAY_AMOUNT => g_pay_costs_rec.costed_value ,
1479: X_STATUS_CODE => l_status_code ,
1480: X_EFFECTIVE_DATE => g_payroll_asg_rec.accounting_date,
1481: X_ACCOUNTING_DATE => g_payroll_asg_rec.accounting_date, --added for

Line 1478: X_PAY_AMOUNT => g_pay_costs_rec.costed_value ,

1474: X_ASSIGNMENT_ID => l_assignment_id ,
1475: X_PERSON_ID => l_person_id ,
1476: X_COST_ID => g_pay_costs_rec.cost_id,
1477: X_ELEMENT_TYPE_ID => g_pay_costs_rec.element_type_id,
1478: X_PAY_AMOUNT => g_pay_costs_rec.costed_value ,
1479: X_STATUS_CODE => l_status_code ,
1480: X_EFFECTIVE_DATE => g_payroll_asg_rec.accounting_date,
1481: X_ACCOUNTING_DATE => g_payroll_asg_rec.accounting_date, --added for
1482: X_EXCHANGE_RATE_TYPE => l_exchange_rate_type, -- 3108109

Line 1484: X_EARNED_DATE => g_pay_costs_rec.date_earned,

1480: X_EFFECTIVE_DATE => g_payroll_asg_rec.accounting_date,
1481: X_ACCOUNTING_DATE => g_payroll_asg_rec.accounting_date, --added for
1482: X_EXCHANGE_RATE_TYPE => l_exchange_rate_type, -- 3108109
1483: X_CHECK_DATE => g_payroll_asg_rec.pay_advice_date,
1484: X_EARNED_DATE => g_pay_costs_rec.date_earned,
1485: X_COST_ALLOCATION_KEYFLEX_ID => g_pay_costs_rec.cost_allocation_keyflex_id,
1486: X_GL_CODE_COMBINATION_ID => l_gl_ccid,
1487: X_BALANCE_AMOUNT => l_balance_amount,
1488: X_DR_CR_FLAG => g_pay_costs_rec.debit_or_credit,

Line 1485: X_COST_ALLOCATION_KEYFLEX_ID => g_pay_costs_rec.cost_allocation_keyflex_id,

1481: X_ACCOUNTING_DATE => g_payroll_asg_rec.accounting_date, --added for
1482: X_EXCHANGE_RATE_TYPE => l_exchange_rate_type, -- 3108109
1483: X_CHECK_DATE => g_payroll_asg_rec.pay_advice_date,
1484: X_EARNED_DATE => g_pay_costs_rec.date_earned,
1485: X_COST_ALLOCATION_KEYFLEX_ID => g_pay_costs_rec.cost_allocation_keyflex_id,
1486: X_GL_CODE_COMBINATION_ID => l_gl_ccid,
1487: X_BALANCE_AMOUNT => l_balance_amount,
1488: X_DR_CR_FLAG => g_pay_costs_rec.debit_or_credit,
1489: X_MODE => 'R',

Line 1488: X_DR_CR_FLAG => g_pay_costs_rec.debit_or_credit,

1484: X_EARNED_DATE => g_pay_costs_rec.date_earned,
1485: X_COST_ALLOCATION_KEYFLEX_ID => g_pay_costs_rec.cost_allocation_keyflex_id,
1486: X_GL_CODE_COMBINATION_ID => l_gl_ccid,
1487: X_BALANCE_AMOUNT => l_balance_amount,
1488: X_DR_CR_FLAG => g_pay_costs_rec.debit_or_credit,
1489: X_MODE => 'R',
1490: X_PAYROLL_ACTION_TYPE => g_pay_costs_rec.action_type,
1491: X_OR_GL_CODE_COMBINATION_ID => l_or_gl_ccid,
1492: X_OR_PROJECT_ID => l_or_project_id,

Line 1490: X_PAYROLL_ACTION_TYPE => g_pay_costs_rec.action_type,

1486: X_GL_CODE_COMBINATION_ID => l_gl_ccid,
1487: X_BALANCE_AMOUNT => l_balance_amount,
1488: X_DR_CR_FLAG => g_pay_costs_rec.debit_or_credit,
1489: X_MODE => 'R',
1490: X_PAYROLL_ACTION_TYPE => g_pay_costs_rec.action_type,
1491: X_OR_GL_CODE_COMBINATION_ID => l_or_gl_ccid,
1492: X_OR_PROJECT_ID => l_or_project_id,
1493: X_OR_TASK_ID => l_or_task_id,
1494: X_OR_AWARD_ID => l_or_award_id,

Line 1501: IF g_pay_costs_rec.debit_or_credit = 'D' then

1497:
1498: -- The following code is required as psp_payroll_controls will be updated with the total debit and credit amount
1499: hr_utility.trace('-pass 30');
1500:
1501: IF g_pay_costs_rec.debit_or_credit = 'D' then
1502: r_payroll_control_array.r_tot_dr(l_cur_rec)
1503: := r_payroll_control_array.r_tot_dr(l_cur_rec) +1;
1504:
1505: r_payroll_control_array.r_dr_amount(l_cur_rec) :=

Line 1506: r_payroll_control_array.r_dr_amount(l_cur_rec) + g_pay_costs_rec.costed_value;

1502: r_payroll_control_array.r_tot_dr(l_cur_rec)
1503: := r_payroll_control_array.r_tot_dr(l_cur_rec) +1;
1504:
1505: r_payroll_control_array.r_dr_amount(l_cur_rec) :=
1506: r_payroll_control_array.r_dr_amount(l_cur_rec) + g_pay_costs_rec.costed_value;
1507:
1508: ELSE
1509: r_payroll_control_array.r_tot_cr(l_cur_rec)
1510: := r_payroll_control_array.r_tot_cr(l_cur_rec) +1;

Line 1513: r_payroll_control_array.r_cr_amount(l_cur_rec) + g_pay_costs_rec.costed_value;

1509: r_payroll_control_array.r_tot_cr(l_cur_rec)
1510: := r_payroll_control_array.r_tot_cr(l_cur_rec) +1;
1511:
1512: r_payroll_control_array.r_cr_amount(l_cur_rec) :=
1513: r_payroll_control_array.r_cr_amount(l_cur_rec) + g_pay_costs_rec.costed_value;
1514:
1515: END IF;
1516:
1517: hr_utility.trace('-pass 40');

Line 1550: X_COST_ID => g_pay_costs_rec.cost_id,

1546: X_PAYROLL_CONTROL_ID => l_export_id ,
1547: X_SET_OF_BOOKS_ID => l_resp_set_of_books_id ,
1548: X_ASSIGNMENT_ID => l_assignment_id ,
1549: X_PERSON_ID => l_person_id ,
1550: X_COST_ID => g_pay_costs_rec.cost_id,
1551: X_ELEMENT_TYPE_ID => g_pay_costs_rec.element_type_id,
1552: X_PAY_AMOUNT => g_pay_costs_rec.costed_value ,
1553: X_STATUS_CODE => l_status_code ,
1554: X_EFFECTIVE_DATE => g_payroll_asg_rec.effective_date,

Line 1551: X_ELEMENT_TYPE_ID => g_pay_costs_rec.element_type_id,

1547: X_SET_OF_BOOKS_ID => l_resp_set_of_books_id ,
1548: X_ASSIGNMENT_ID => l_assignment_id ,
1549: X_PERSON_ID => l_person_id ,
1550: X_COST_ID => g_pay_costs_rec.cost_id,
1551: X_ELEMENT_TYPE_ID => g_pay_costs_rec.element_type_id,
1552: X_PAY_AMOUNT => g_pay_costs_rec.costed_value ,
1553: X_STATUS_CODE => l_status_code ,
1554: X_EFFECTIVE_DATE => g_payroll_asg_rec.effective_date,
1555: X_ACCOUNTING_DATE => g_payroll_asg_rec.accounting_date, --added for

Line 1552: X_PAY_AMOUNT => g_pay_costs_rec.costed_value ,

1548: X_ASSIGNMENT_ID => l_assignment_id ,
1549: X_PERSON_ID => l_person_id ,
1550: X_COST_ID => g_pay_costs_rec.cost_id,
1551: X_ELEMENT_TYPE_ID => g_pay_costs_rec.element_type_id,
1552: X_PAY_AMOUNT => g_pay_costs_rec.costed_value ,
1553: X_STATUS_CODE => l_status_code ,
1554: X_EFFECTIVE_DATE => g_payroll_asg_rec.effective_date,
1555: X_ACCOUNTING_DATE => g_payroll_asg_rec.accounting_date, --added for
1556: X_EXCHANGE_RATE_TYPE => l_exchange_rate_type, -- 3108109

Line 1558: X_EARNED_DATE => g_pay_costs_rec.date_earned,

1554: X_EFFECTIVE_DATE => g_payroll_asg_rec.effective_date,
1555: X_ACCOUNTING_DATE => g_payroll_asg_rec.accounting_date, --added for
1556: X_EXCHANGE_RATE_TYPE => l_exchange_rate_type, -- 3108109
1557: X_CHECK_DATE => g_payroll_asg_rec.pay_advice_date,
1558: X_EARNED_DATE => g_pay_costs_rec.date_earned,
1559: X_COST_ALLOCATION_KEYFLEX_ID => g_pay_costs_rec.cost_allocation_keyflex_id,
1560: X_GL_CODE_COMBINATION_ID => l_gl_ccid,
1561: X_BALANCE_AMOUNT => l_balance_amount,
1562: X_DR_CR_FLAG => g_pay_costs_rec.debit_or_credit,

Line 1559: X_COST_ALLOCATION_KEYFLEX_ID => g_pay_costs_rec.cost_allocation_keyflex_id,

1555: X_ACCOUNTING_DATE => g_payroll_asg_rec.accounting_date, --added for
1556: X_EXCHANGE_RATE_TYPE => l_exchange_rate_type, -- 3108109
1557: X_CHECK_DATE => g_payroll_asg_rec.pay_advice_date,
1558: X_EARNED_DATE => g_pay_costs_rec.date_earned,
1559: X_COST_ALLOCATION_KEYFLEX_ID => g_pay_costs_rec.cost_allocation_keyflex_id,
1560: X_GL_CODE_COMBINATION_ID => l_gl_ccid,
1561: X_BALANCE_AMOUNT => l_balance_amount,
1562: X_DR_CR_FLAG => g_pay_costs_rec.debit_or_credit,
1563: X_MODE => 'R',

Line 1562: X_DR_CR_FLAG => g_pay_costs_rec.debit_or_credit,

1558: X_EARNED_DATE => g_pay_costs_rec.date_earned,
1559: X_COST_ALLOCATION_KEYFLEX_ID => g_pay_costs_rec.cost_allocation_keyflex_id,
1560: X_GL_CODE_COMBINATION_ID => l_gl_ccid,
1561: X_BALANCE_AMOUNT => l_balance_amount,
1562: X_DR_CR_FLAG => g_pay_costs_rec.debit_or_credit,
1563: X_MODE => 'R',
1564: X_PAYROLL_ACTION_TYPE => g_pay_costs_rec.action_type,
1565: X_OR_GL_CODE_COMBINATION_ID => l_or_gl_ccid,
1566: X_OR_PROJECT_ID => l_or_project_id,

Line 1564: X_PAYROLL_ACTION_TYPE => g_pay_costs_rec.action_type,

1560: X_GL_CODE_COMBINATION_ID => l_gl_ccid,
1561: X_BALANCE_AMOUNT => l_balance_amount,
1562: X_DR_CR_FLAG => g_pay_costs_rec.debit_or_credit,
1563: X_MODE => 'R',
1564: X_PAYROLL_ACTION_TYPE => g_pay_costs_rec.action_type,
1565: X_OR_GL_CODE_COMBINATION_ID => l_or_gl_ccid,
1566: X_OR_PROJECT_ID => l_or_project_id,
1567: X_OR_TASK_ID => l_or_task_id,
1568: X_OR_AWARD_ID => l_or_award_id,

Line 1572: -- IF (l_proration_option = 'PSP' or g_pay_costs_rec.start_date IS NULL) THEN -- Introduced for bug fix 2916848

1568: X_OR_AWARD_ID => l_or_award_id,
1569: X_OR_EXPENDITURE_ORG_ID => l_or_expenditure_org_id,
1570: X_OR_EXPENDITURE_TYPE => l_or_expenditure_type);
1571:
1572: -- IF (l_proration_option = 'PSP' or g_pay_costs_rec.start_date IS NULL) THEN -- Introduced for bug fix 2916848
1573:
1574: ---IF g_pay_costs_rec.start_date IS NULL THEN ... commented for 4897071
1575:
1576: hr_utility.trace('-pass 60');

Line 1574: ---IF g_pay_costs_rec.start_date IS NULL THEN ... commented for 4897071

1570: X_OR_EXPENDITURE_TYPE => l_or_expenditure_type);
1571:
1572: -- IF (l_proration_option = 'PSP' or g_pay_costs_rec.start_date IS NULL) THEN -- Introduced for bug fix 2916848
1573:
1574: ---IF g_pay_costs_rec.start_date IS NULL THEN ... commented for 4897071
1575:
1576: hr_utility.trace('-pass 60');
1577:
1578: CREATE_DAILY_RATE_CALENDAR(

Line 1581: X_ELEMENT_TYPE_ID => g_pay_costs_rec.element_type_id,

1577:
1578: CREATE_DAILY_RATE_CALENDAR(
1579: X_ASSIGNMENT_ID => l_assignment_id,
1580: X_time_period_id => p_time_period_id,
1581: X_ELEMENT_TYPE_ID => g_pay_costs_rec.element_type_id,
1582: X_RETURN_STATUS => l_return_status);
1583: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1584: l_error_api_name := 'CREATE_DAILY_RATE_CALENDAR : ';
1585: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1590: -- compare the salary amount we got from pay costs table

1586: END IF;
1587:
1588:
1589: -- Sum up the salary from daily calendar array
1590: -- compare the salary amount we got from pay costs table
1591: -- if it is different, calculate the difference amount
1592:
1593: CALCULATE_BALANCE_AMOUNT(X_PAY_AMOUNT => g_pay_costs_rec.costed_value,
1594: X_BALANCE_AMOUNT => l_balance_amount,

Line 1593: CALCULATE_BALANCE_AMOUNT(X_PAY_AMOUNT => g_pay_costs_rec.costed_value,

1589: -- Sum up the salary from daily calendar array
1590: -- compare the salary amount we got from pay costs table
1591: -- if it is different, calculate the difference amount
1592:
1593: CALCULATE_BALANCE_AMOUNT(X_PAY_AMOUNT => g_pay_costs_rec.costed_value,
1594: X_BALANCE_AMOUNT => l_balance_amount,
1595: X_RETURN_STATUS => l_return_status);
1596: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1597: l_error_api_name := 'CREATE_BALANCE_AMOUNT : ';

Line 1606: (p_start_date => g_pay_costs_rec.start_date,

1602: /* commented for 4897071
1603: -- Introduced the following for bug fix 2916848
1604: ELSE
1605: create_prorate_calendar
1606: (p_start_date => g_pay_costs_rec.start_date,
1607: p_end_date => g_pay_costs_rec.end_date,
1608: p_pay_amount => g_pay_costs_rec.costed_value,
1609: p_payroll_line_id => l_line_id,
1610: p_balance_amount => l_balance_amount,

Line 1607: p_end_date => g_pay_costs_rec.end_date,

1603: -- Introduced the following for bug fix 2916848
1604: ELSE
1605: create_prorate_calendar
1606: (p_start_date => g_pay_costs_rec.start_date,
1607: p_end_date => g_pay_costs_rec.end_date,
1608: p_pay_amount => g_pay_costs_rec.costed_value,
1609: p_payroll_line_id => l_line_id,
1610: p_balance_amount => l_balance_amount,
1611: p_return_status => l_return_status);

Line 1608: p_pay_amount => g_pay_costs_rec.costed_value,

1604: ELSE
1605: create_prorate_calendar
1606: (p_start_date => g_pay_costs_rec.start_date,
1607: p_end_date => g_pay_costs_rec.end_date,
1608: p_pay_amount => g_pay_costs_rec.costed_value,
1609: p_payroll_line_id => l_line_id,
1610: p_balance_amount => l_balance_amount,
1611: p_return_status => l_return_status);
1612: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1625: IF g_pay_costs_rec.debit_or_credit = 'D' then

1621: UPDATE PSP_PAYROLL_LINES set balance_amount=l_balance_amount where payroll_line_id=l_line_id;
1622:
1623: -- End of bug fix 2916848
1624:
1625: IF g_pay_costs_rec.debit_or_credit = 'D' then
1626:
1627: r_payroll_control_array.r_tot_dr(l_cur_rec):=
1628: r_payroll_control_array.r_tot_dr(l_cur_rec) +1;
1629: r_payroll_control_array.r_dr_amount(l_cur_rec) :=

Line 1631: g_pay_costs_rec.costed_value;

1627: r_payroll_control_array.r_tot_dr(l_cur_rec):=
1628: r_payroll_control_array.r_tot_dr(l_cur_rec) +1;
1629: r_payroll_control_array.r_dr_amount(l_cur_rec) :=
1630: r_payroll_control_array.r_dr_amount(l_cur_rec) +
1631: g_pay_costs_rec.costed_value;
1632:
1633: ELSE
1634:
1635: r_payroll_control_array.r_tot_cr(l_cur_rec):=

Line 1640: g_pay_costs_rec.costed_value;

1636: r_payroll_control_array.r_tot_cr(l_cur_rec) +1;
1637:
1638: r_payroll_control_array.r_cr_amount(l_cur_rec) :=
1639: r_payroll_control_array.r_cr_amount(l_cur_rec) +
1640: g_pay_costs_rec.costed_value;
1641:
1642: END IF;
1643:
1644: -- If salary change happens during the payroll period

Line 1652: --- IF (l_proration_option = 'PSP' or g_pay_costs_rec.start_date is null ) THEN -- Introduced for bug fix 2916848

1648: -- write single sub-line in PSP_PAYROLL_SUB_LINES
1649: -- table
1650: -- end if;
1651:
1652: --- IF (l_proration_option = 'PSP' or g_pay_costs_rec.start_date is null ) THEN -- Introduced for bug fix 2916848
1653:
1654: --- IF g_pay_costs_rec.start_date IS NULL then .. commented for 4897071
1655: /*Bug 5642002: Added parameters x_start_date and x_end_date */
1656: CREATE_SLINE_SALARY_CHANGE (X_PAYROLL_LINE_ID => l_line_id,

Line 1654: --- IF g_pay_costs_rec.start_date IS NULL then .. commented for 4897071

1650: -- end if;
1651:
1652: --- IF (l_proration_option = 'PSP' or g_pay_costs_rec.start_date is null ) THEN -- Introduced for bug fix 2916848
1653:
1654: --- IF g_pay_costs_rec.start_date IS NULL then .. commented for 4897071
1655: /*Bug 5642002: Added parameters x_start_date and x_end_date */
1656: CREATE_SLINE_SALARY_CHANGE (X_PAYROLL_LINE_ID => l_line_id,
1657: x_start_date => TRUNC(g_start_date), -- Bug 6046087
1658: x_end_date => TRUNC(g_end_date), -- Bug 6046087

Line 1823: if (NVL(to_number(g_pay_costs_rec.costed_value),0) - NVL(l_subline_sum,0)) <> 0 then

1819: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1820: end if;
1821: close get_difference_csr;
1822: -- Added daily rate not equal to 0 to where clause to fix bug no 89157
1823: if (NVL(to_number(g_pay_costs_rec.costed_value),0) - NVL(l_subline_sum,0)) <> 0 then
1824: update psp_payroll_sub_lines
1825: set pay_amount = pay_amount + (NVL(to_number(g_pay_costs_rec.costed_value),0) - NVL(l_subline_sum,0))
1826: where payroll_line_id = l_line_id and
1827: NVL(daily_rate,0) <> 0 and

Line 1825: set pay_amount = pay_amount + (NVL(to_number(g_pay_costs_rec.costed_value),0) - NVL(l_subline_sum,0))

1821: close get_difference_csr;
1822: -- Added daily rate not equal to 0 to where clause to fix bug no 89157
1823: if (NVL(to_number(g_pay_costs_rec.costed_value),0) - NVL(l_subline_sum,0)) <> 0 then
1824: update psp_payroll_sub_lines
1825: set pay_amount = pay_amount + (NVL(to_number(g_pay_costs_rec.costed_value),0) - NVL(l_subline_sum,0))
1826: where payroll_line_id = l_line_id and
1827: NVL(daily_rate,0) <> 0 and
1828: pay_amount <> 0 and --- rounding difference to nonzero amount .. 4670588
1829: rownum = 1;

Line 1851: close get_pay_costs_csr;

1847: retcode:= FND_API.G_RET_STS_SUCCESS;
1848:
1849: END;
1850: END LOOP; -- LOOP1 end
1851: close get_pay_costs_csr;
1852:
1853: EXCEPTION
1854:
1855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1866: close get_pay_costs_csr;

1862: );
1863:
1864: return;
1865: WHEN NO_COST_DATA_FOUND then
1866: close get_pay_costs_csr;
1867: hr_utility.trace('-exception 10- sqlerrm = '||sqlerrm);
1868:
1869: IF check_payroll_lines_csr%ISOPEN THEN
1870: hr_utility.trace('-exception 10- close check_payroll_lines_csr');