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_SUM_ADJ dependencies on PSP_SUMMARY_LINES

Line 384: FROM psp_summary_lines

380:
381: --Bug 1776606 : Introduced the two cursors
382: CURSOR sum_lines_cur(P_PAYROLL_CONTROL_ID IN NUMBER) IS
383: SELECT count(*)
384: FROM psp_summary_lines
385: WHERE payroll_control_id = p_payroll_control_id
386: AND status_code <> 'A';
387:
388: CURSOR adj_lines_cur(P_PAYROLL_CONTROL_ID IN NUMBER) IS

Line 445: FROM psp_summary_lines

441:
442: DELETE FROM pa_transaction_interface_all
443: -- WHERE batch_name = g_gms_batch_name
444: WHERE batch_name IN (SELECT GMS_BATCH_NAME
445: FROM psp_summary_lines
446: WHERE PAYROLL_CONTROL_ID IN(SELECT payroll_control_id
447: FROM psp_payroll_controls
448: WHERE adj_sum_batch_name =p_adj_sum_batch_name))
449: ---AND transaction_status_code = 'A' delete 'R' also, for 2445196

Line 456: FROM psp_summary_lines

452: -- introduced following stmnt for 2445196
453: delete from gms_transaction_interface_all
454: -- where batch_name = g_gms_batch_name
455: WHERE batch_name IN (SELECT GMS_BATCH_NAME
456: FROM psp_summary_lines
457: WHERE PAYROLL_CONTROL_ID IN(SELECT payroll_control_id
458: FROM psp_payroll_controls
459: WHERE adj_sum_batch_name =p_adj_sum_batch_name))
460: and transaction_source = 'GOLD';

Line 569: psp_summary_lines psl

565: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
566: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
567: FROM psp_adjustment_lines pal,
568: psp_distribution_lines_history pdlh,
569: psp_summary_lines psl
570: WHERE pal.status_code = 'N'
571: AND pal.gl_code_combination_id is not null
572: AND pal.payroll_control_id = p_payroll_control_id
573: AND pal.orig_source_type = 'D'

Line 600: psp_summary_lines psl

596: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
597: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
598: FROM psp_adjustment_lines pal,
599: psp_adjustment_lines_history palh,
600: psp_summary_lines psl
601: WHERE pal.status_code = 'N'
602: AND pal.gl_code_combination_id is not null
603: AND pal.payroll_control_id = p_payroll_control_id
604: AND pal.orig_source_type = 'A'

Line 631: psp_summary_lines psl

627: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
628: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
629: FROM psp_adjustment_lines pal,
630: psp_pre_gen_dist_lines_history pglh,
631: psp_summary_lines psl
632: WHERE pal.status_code = 'N'
633: AND pal.gl_code_combination_id is not null
634: AND pal.payroll_control_id = p_payroll_control_id
635: AND pal.orig_source_type = 'P'

Line 988: SELECT PSP_SUMMARY_LINES_S.NEXTVAL

984: END IF;
985: -- Code ended for Enhancement Employee Assignment with Zero Work Days
986:
987:
988: SELECT PSP_SUMMARY_LINES_S.NEXTVAL
989: INTO P_SUMMARY_LINE_ID
990: FROM DUAL;
991:
992: INSERT INTO PSP_SUMMARY_LINES(

Line 992: INSERT INTO PSP_SUMMARY_LINES(

988: SELECT PSP_SUMMARY_LINES_S.NEXTVAL
989: INTO P_SUMMARY_LINE_ID
990: FROM DUAL;
991:
992: INSERT INTO PSP_SUMMARY_LINES(
993: SUMMARY_LINE_ID,
994: PERSON_ID,
995: ASSIGNMENT_ID,
996: TIME_PERIOD_ID,

Line 1165: FROM psp_summary_lines psl

1161: psl.attribute28,
1162: psl.attribute29,
1163: psl.attribute30,
1164: psl.person_id --Included this column as part of bug fix 1828519
1165: FROM psp_summary_lines psl
1166: WHERE psl.status_code = 'N'
1167: AND psl.gl_code_combination_id IS NOT NULL
1168: AND psl.payroll_control_id = p_payroll_control_id;
1169:

Line 1268: -- update psp_summary_lines with group_id

1264: EXIT;
1265: END IF;
1266:
1267:
1268: -- update psp_summary_lines with group_id
1269: UPDATE psp_summary_lines
1270: SET group_id = l_group_id
1271: WHERE status_code = 'N'
1272: AND gl_code_combination_id IS NOT NULL

Line 1269: UPDATE psp_summary_lines

1265: END IF;
1266:
1267:
1268: -- update psp_summary_lines with group_id
1269: UPDATE psp_summary_lines
1270: SET group_id = l_group_id
1271: WHERE status_code = 'N'
1272: AND gl_code_combination_id IS NOT NULL
1273: AND payroll_control_id = gl_batch_rec.payroll_control_id;

Line 1568: FROM psp_summary_lines

1564: CURSOR gl_tie_back_success_cur(p_group_id IN NUMBER,
1565: p_payroll_control_id IN NUMBER ) IS ----added for Bug 2133056
1566: SELECT summary_line_id,
1567: dr_cr_flag,summary_amount
1568: FROM psp_summary_lines
1569: WHERE group_id = p_group_id
1570: AND payroll_control_id = p_payroll_control_id;
1571:
1572: CURSOR gl_reversal_cur(p_summary_line_id IN NUMBER) IS

Line 1641: FROM psp_summary_lines PSL,

1637:
1638: -- Included the following cursors here for accessing local varibales for bug fix 1765678
1639: CURSOR summary_group_cur IS
1640: SELECT PSL.group_id
1641: FROM psp_summary_lines PSL,
1642: psp_payroll_controls PPC
1643: WHERE PPC.payroll_control_id = PSL.payroll_control_id
1644: -- WHERE payroll_control_id = gl_tie_back_rec.payroll_control_id
1645: AND PPC.batch_name = pc_batch_rec.batch_name

Line 1773: -- update records in psp_summary_lines as 'A'

1769: END IF;
1770:
1771: --dbms_output.put_line('Am in the success loop');
1772:
1773: -- update records in psp_summary_lines as 'A'
1774: UPDATE psp_summary_lines
1775: SET status_code = 'A'
1776: WHERE summary_line_id = l_summary_line_id;
1777:

Line 1774: UPDATE psp_summary_lines

1770:
1771: --dbms_output.put_line('Am in the success loop');
1772:
1773: -- update records in psp_summary_lines as 'A'
1774: UPDATE psp_summary_lines
1775: SET status_code = 'A'
1776: WHERE summary_line_id = l_summary_line_id;
1777:
1778: IF l_dr_cr_flag = 'D' THEN

Line 1873: FROM psp_summary_lines

1869: time_period_id,
1870: summary_amount reversal_dist_amount,
1871: interface_batch_name,
1872: summary_line_id
1873: FROM psp_summary_lines
1874: WHERE payroll_control_id = p_payroll_control_id
1875: AND gl_code_combination_id IS NOT NULL
1876: AND status_code = 'N'
1877: AND business_group_id = p_business_group_id

Line 2297: psp_summary_lines psl

2293: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
2294: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
2295: FROM psp_adjustment_lines pal,
2296: psp_distribution_lines_history pdh,
2297: psp_summary_lines psl
2298: WHERE pal.status_code = 'N'
2299: AND pal.gl_code_combination_id IS NULL
2300: AND pal.payroll_control_id = p_payroll_control_id
2301: AND pdh.distribution_line_id = pal.orig_line_id

Line 2332: psp_summary_lines psl

2328: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
2329: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
2330: FROM psp_adjustment_lines pal,
2331: psp_adjustment_lines_history pal2,
2332: psp_summary_lines psl
2333: WHERE pal.status_code = 'N'
2334: AND pal.gl_code_combination_id IS NULL
2335: AND pal.payroll_control_id = p_payroll_control_id
2336: AND pal2.adjustment_line_id = pal.orig_line_id

Line 2367: psp_summary_lines psl

2363: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
2364: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
2365: FROM psp_adjustment_lines pal,
2366: psp_pre_gen_dist_lines_history pgh,
2367: psp_summary_lines psl
2368: WHERE pal.status_code = 'N'
2369: AND pal.gl_code_combination_id IS NULL
2370: AND pal.payroll_control_id = p_payroll_control_id
2371: AND pgh.pre_gen_dist_line_id = pal.orig_line_id

Line 2741: FROM psp_summary_lines psl

2737: psl.attribute8,
2738: psl.attribute9,
2739: psl.attribute10,
2740: org_id -- R12 MOAC uptake
2741: FROM psp_summary_lines psl
2742: WHERE psl.status_code = 'N'
2743: AND psl.gl_code_combination_id IS NULL
2744: AND psl.payroll_control_id = p_payroll_control_id;
2745:

Line 2839: FROM psp_summary_lines

2835: r_payroll_controls payroll_control_rec;
2836:
2837: CURSOR payroll_control_id_cur IS
2838: SELECT DISTINCT payroll_control_id
2839: FROM psp_summary_lines
2840: WHERE gms_batch_name = l_gms_batch_name;
2841: -- End of changes for bug fix 4507892
2842:
2843: -- R12 MOAC Uptake

Line 2860: psp_summary_lines psl

2856:
2857: CURSOR operating_unit_csr IS
2858: SELECT distinct org_id
2859: FROM psp_payroll_controls ppc,
2860: psp_summary_lines psl
2861: WHERE ppc.payroll_control_id = psl.payroll_control_id
2862: AND ppc.adj_sum_batch_name = p_adj_sum_batch_name
2863: AND ppc.source_type = 'A'
2864: AND (ppc.dist_dr_amount IS NOT NULL OR ppc.dist_cr_amount IS NOT NULL)

Line 2949: UPDATE psp_summary_lines

2945:
2946: -- R12 MOAC Uptake. Moved this code to loop
2947: FOR I in 1..org_id_tab.count
2948: LOOP
2949: UPDATE psp_summary_lines
2950: SET gms_batch_name = gms_batch_name_tab(i) -- l_gms_batch_name
2951: WHERE payroll_control_id = gms_batch_rec.payroll_control_id
2952: AND status_code = 'N'
2953: AND gl_code_combination_id IS NULL

Line 2959: -- update psp_summary_lines with gms batch name

2955: END LOOP;
2956:
2957: FOR i in 1..org_id_tab.count
2958: LOOP
2959: -- update psp_summary_lines with gms batch name
2960: UPDATE psp_summary_lines
2961: SET gms_batch_name = gms_batch_name_tab(i) -- l_gms_batch_name
2962: WHERE payroll_control_id = gms_batch_rec.payroll_control_id
2963: AND status_code = 'N'

Line 2960: UPDATE psp_summary_lines

2956:
2957: FOR i in 1..org_id_tab.count
2958: LOOP
2959: -- update psp_summary_lines with gms batch name
2960: UPDATE psp_summary_lines
2961: SET gms_batch_name = gms_batch_name_tab(i) -- l_gms_batch_name
2962: WHERE payroll_control_id = gms_batch_rec.payroll_control_id
2963: AND status_code = 'N'
2964: AND gl_code_combination_id IS NULL

Line 3291: from psp_summary_lines

3287: set gms_phase = 'Submitted_Import_Request'
3288: -- where gms_phase = 'Transfer_GMS_Lines'
3289: where payroll_control_id in
3290: (select distinct payroll_control_id
3291: from psp_summary_lines
3292: where gms_batch_name = l_gms_batch_name);
3293: End of comment for bug fix 4507892 *****/
3294:
3295: -- Introduced the following for bug fix 4507892

Line 3390: FROM psp_summary_lines

3386:
3387: CURSOR gms_tie_back_success_cur(p_gms_batch_name number, p_payroll_control_id number) IS
3388: SELECT summary_line_id,
3389: dr_cr_flag,summary_amount
3390: FROM psp_summary_lines
3391: WHERE gms_batch_name = p_gms_batch_name
3392: AND payroll_control_id = p_payroll_control_id;
3393:
3394:

Line 3405: from psp_summary_lines

3401: AND transaction_status_code in ('R', 'PO', 'PI', 'PR')
3402: AND transaction_source = p_txn_src
3403: AND orig_transaction_reference in
3404: (select to_char(summary_line_id)
3405: from psp_summary_lines
3406: where payroll_control_id = p_payroll_control_id
3407: and gms_batch_name = p_gms_batch_name);
3408:
3409: l_orig_org_name1 hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration

Line 3476: FROM psp_summary_lines

3472:
3473: -- the following cursors are included here for accessing the local variables for bug fix 1765678
3474: CURSOR gms_batch_name_cur IS
3475: SELECT DISTINCT gms_batch_name
3476: FROM psp_summary_lines
3477: WHERE payroll_control_id = gms_tie_back_rec.payroll_control_id
3478: AND gms_batch_name IS NOT NULL;
3479:
3480: CURSOR transaction_source_cur IS

Line 3492: FROM psp_summary_lines

3488: WHERE batch_name = TO_CHAR(l_gms_batch_name)
3489: AND transaction_source = l_txn_source
3490: AND transaction_status_code IN ('R', 'PO', 'PI', 'PR')
3491: AND orig_transaction_reference IN (SELECT TO_CHAR(summary_line_id)
3492: FROM psp_summary_lines
3493: WHERE payroll_control_id = gms_tie_back_rec.payroll_control_id
3494: AND gms_batch_name = l_gms_batch_name);
3495: FUNCTION PROCESS_COMPLETE RETURN BOOLEAN IS
3496:

Line 3552: delete from psp_summary_lines

3548: and transaction_source = 'GOLD';
3549: end if;
3550:
3551: /* Commented for 2133056, Let recover start from Import and not Summarize
3552: delete from psp_summary_lines
3553: where gms_batch_name = l_gms_batch_name
3554: and payroll_control_id = gms_tie_back_rec.payroll_control_id;
3555: */
3556: -- Added following update for 2133056

Line 3614: delete psp_summary_lines

3610: delete pa_transaction_interface_all
3611: where transaction_source in ('GOLD','OLD') and
3612: batch_name = l_gms_batch_name;
3613:
3614: delete psp_summary_lines
3615: where payroll_control_id in
3616: (select payroll_control_id
3617: from psp_payroll_controls
3618: where source_type = 'A'

Line 3753: UPDATE psp_summary_lines PSL

3749: ELSIF l_cnt_gms_interface = 0 THEN
3750:
3751: l_gms_batch_name1 := l_gms_batch_name; --Bug 6118274
3752: --- moved this stmnt from the loop below, and modified for 2445196.
3753: UPDATE psp_summary_lines PSL
3754: SET (PSL.status_code, PSL.expenditure_ending_date,PSL.expenditure_id,
3755: PSL.interface_id,PSL.expenditure_item_id,PSL.txn_interface_id) =
3756: (select 'A', PTXN.expenditure_ending_date,PTXN.expenditure_id,
3757: PTXN.interface_id,PTXN.expenditure_item_id,PTXN.txn_interface_id

Line 3787: -- update records in psp_summary_lines as 'A' , moved this stmnt above for 2445196

3783: CLOSE gms_tie_back_success_cur;
3784: EXIT;
3785: END IF;
3786:
3787: -- update records in psp_summary_lines as 'A' , moved this stmnt above for 2445196
3788:
3789: IF l_dr_cr_flag = 'D' THEN
3790: l_dr_summary_amount := l_dr_summary_amount + l_summary_amount;
3791: ELSIF l_dr_cr_flag = 'C' THEN

Line 4047: batch_name IN (SELECT gms_batch_name FROM psp_summary_lines WHERE payroll_control_id = p_payroll_control_id) and

4043: from pa_transaction_interface_all
4044: where transaction_source in ('OLD', 'GOLD') and
4045: transaction_status_code = 'A' and
4046: -- batch_name = g_gms_batch_name and
4047: batch_name IN (SELECT gms_batch_name FROM psp_summary_lines WHERE payroll_control_id = p_payroll_control_id) and
4048: rownum = 1);
4049:
4050: adj_batch_rec adj_batch_cur%ROWTYPE;
4051: BEGIN

Line 4078: from psp_summary_lines

4074: from pa_expenditure_items_all
4075: where transaction_source = 'GOLD'
4076: and orig_transaction_reference in
4077: (select to_char(summary_line_id)
4078: from psp_summary_lines
4079: where payroll_control_id in
4080: (select payroll_control_id
4081: from psp_payroll_controls
4082: where batch_name = l_batch_name

Line 4090: from psp_summary_lines

4086: delete from pa_expenditure_items_all
4087: where transaction_source in ('OLD','GOLD')
4088: and orig_transaction_reference in
4089: (select to_char(summary_line_id)
4090: from psp_summary_lines
4091: where payroll_control_id in
4092: (select payroll_control_id
4093: from psp_payroll_controls
4094: where batch_name = l_batch_name

Line 4104: from psp_summary_lines

4100: where transaction_source in ('GOLD') and
4101: batch_name = g_gms_batch_name and
4102: orig_transaction_reference in
4103: (select to_char(summary_line_id)
4104: from psp_summary_lines
4105: where payroll_control_id in
4106: (select payroll_control_id
4107: from psp_payroll_controls
4108: where batch_name = l_batch_name

Line 4120: from psp_summary_lines PSL

4116: from pa_transaction_interface_all XFACE
4117: where XFACE.transaction_source in('OLD','GOLD')
4118: and XFACE.orig_transaction_reference in
4119: (select to_char(PSL.summary_line_id)
4120: from psp_summary_lines PSL
4121: where PSL.payroll_control_id in
4122: (select PPC.payroll_control_id
4123: from psp_payroll_controls PPC
4124: where PPC.batch_name=l_batch_name

Line 4137: from psp_summary_lines

4133: where transaction_source in ('OLD','GOLD') and
4134: batch_name = g_gms_batch_name and
4135: orig_transaction_reference in
4136: (select to_char(summary_line_id)
4137: from psp_summary_lines
4138: where payroll_control_id in
4139: (select payroll_control_id
4140: from psp_payroll_controls
4141: where batch_name = l_batch_name

Line 4207: delete from psp_summary_lines

4203:
4204: delete from psp_adjustment_lines
4205: where batch_name = l_batch_name;
4206:
4207: delete from psp_summary_lines
4208: where payroll_control_id in (select payroll_control_id
4209: from psp_payroll_controls
4210: where batch_name = l_batch_name
4211: and source_type = 'A'); --- added this condn 2133056

Line 4256: FROM psp_summary_lines

4252:
4253: -- Included the following cursors here for accessing the local variables for bug fix 1765678
4254: CURSOR summary_group_cur IS
4255: SELECT MAX(group_id)
4256: FROM psp_summary_lines
4257: WHERE payroll_control_id = payroll_control_rec.payroll_control_id
4258: AND group_id IS NOT NULL;
4259:
4260: CURSOR gl_interface_status_cur IS

Line 4269: FROM psp_summary_lines

4265: AND status = 'NEW';
4266:
4267: CURSOR gms_batch_name_cur IS
4268: SELECT MAX(gms_batch_name)
4269: FROM psp_summary_lines
4270: WHERE payroll_control_id = payroll_control_rec.payroll_control_id
4271: AND gms_batch_name IS NOT NULL;
4272:
4273: CURSOR pa_txn_int_status_p_cur IS

Line 4377: delete from psp_summary_lines

4373: delete from gms_transaction_interface_all
4374: where batch_name = to_char(l_gms_batch_name)
4375: and transaction_source = 'GOLD';
4376:
4377: delete from psp_summary_lines
4378: where payroll_control_id = payroll_control_rec.payroll_control_id
4379: and gms_batch_name = l_gms_batch_name;
4380:
4381: