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

Line 371: from psp_summary_lines

367:
368: if (payroll_control_rec.phase = 'Submitted_TI_Request') then
369: select max(gms_batch_name)
370: into l_gms_batch_name
371: from psp_summary_lines
372: where payroll_control_id = payroll_control_rec.payroll_control_id;
373:
374: select count(*)
375: into l_ti_not_complete

Line 512: DELETE FROM psp_summary_lines

508: If l_line_counter = 0 then
509:
510: /* commented for 2445196
511: -- delete any rejected summary lines
512: DELETE FROM psp_summary_lines
513: WHERE payroll_control_id = payroll_control_rec.payroll_control_id
514: AND status_code = 'R';
515: */
516:

Line 544: DELETE FROM psp_summary_lines

540: WHERE ppgd.payroll_control_id = payroll_control_rec.payroll_control_id;
541:
542: IF l_line_counter = 0 THEN
543: /* commented for 2445196
544: DELETE FROM psp_summary_lines
545: WHERE payroll_control_id = payroll_control_rec.payroll_control_id
546: AND status_code = 'R';
547: */
548:

Line 1097: SELECT PSP_SUMMARY_LINES_S.NEXTVAL

1093: psp_general.get_gms_effective_date(p_person_id,l_gms_posting_effective_date);
1094: END IF;
1095: -- Code ended for Enhancement Employee Assignment with Zero Work Days
1096:
1097: SELECT PSP_SUMMARY_LINES_S.NEXTVAL
1098: INTO P_SUMMARY_LINE_ID
1099: FROM DUAL;
1100: INSERT INTO PSP_SUMMARY_LINES(
1101: SUMMARY_LINE_ID,

Line 1100: INSERT INTO PSP_SUMMARY_LINES(

1096:
1097: SELECT PSP_SUMMARY_LINES_S.NEXTVAL
1098: INTO P_SUMMARY_LINE_ID
1099: FROM DUAL;
1100: INSERT INTO PSP_SUMMARY_LINES(
1101: SUMMARY_LINE_ID,
1102: PERSON_ID,
1103: ASSIGNMENT_ID,
1104: TIME_PERIOD_ID,

Line 1284: FROM psp_summary_lines psl

1280: psl.attribute27,
1281: psl.attribute28,
1282: psl.attribute29,
1283: psl.attribute30
1284: FROM psp_summary_lines psl
1285: WHERE psl.status_code = 'N'
1286: AND psl.gl_code_combination_id IS NOT NULL
1287: AND psl.payroll_control_id = l_payroll_control_id;
1288:

Line 1385: -- update psp_summary_lines with group_id

1381:
1382: LOOP
1383: FETCH gl_payroll_control_cursor INTO gl_payroll_control_rec;
1384: EXIT WHEN gl_payroll_control_cursor%NOTFOUND;
1385: -- update psp_summary_lines with group_id
1386:
1387: UPDATE psp_summary_lines
1388: SET group_id = l_group_id
1389: WHERE status_code = 'N'

Line 1387: UPDATE psp_summary_lines

1383: FETCH gl_payroll_control_cursor INTO gl_payroll_control_rec;
1384: EXIT WHEN gl_payroll_control_cursor%NOTFOUND;
1385: -- update psp_summary_lines with group_id
1386:
1387: UPDATE psp_summary_lines
1388: SET group_id = l_group_id
1389: WHERE status_code = 'N'
1390: AND gl_code_combination_id IS NOT NULL
1391: AND payroll_control_id = gl_payroll_control_rec.payroll_control_id;

Line 1455: from psp_summary_lines

1451:
1452: else --- 2444657 ...phase = Submitted_JI_Request
1453: select group_id
1454: into l_group_id
1455: from psp_summary_lines
1456: where payroll_control_id in
1457: (SELECT payroll_control_id
1458: FROM psp_payroll_controls
1459: WHERE source_type = gl_batch_rec.source_type

Line 1568: -- mark the successfully transferred records as 'A' in psp_summary_lines and psp_distribution_lines

1564: FETCH gl_payroll_control_cursor INTO gl_payroll_control_rec;
1565: EXIT WHEN gl_payroll_control_cursor%NOTFOUND;
1566:
1567:
1568: -- mark the successfully transferred records as 'A' in psp_summary_lines and psp_distribution_lines
1569: -- and transfer the successful records to the history table
1570: -- 1874696:changed l_period_end_date to NULL in tie back call
1571: -- Bug 22663344 reverted null value to l_period_end_date
1572: gl_tie_back(gl_payroll_control_rec.payroll_control_id,

Line 1705: FROM psp_summary_lines

1701: p_return_status OUT NOCOPY VARCHAR2) IS
1702: CURSOR gl_tie_back_success_cur IS
1703: SELECT summary_line_id,
1704: dr_cr_flag,summary_amount
1705: FROM psp_summary_lines
1706: WHERE group_id = p_group_id
1707: AND payroll_control_id = p_payroll_control_id;
1708:
1709: CURSOR gl_tie_back_reject_cur IS

Line 1716: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898

1712: FROM gl_interface
1713: WHERE group_id = p_group_id
1714: AND set_of_books_id = p_set_of_books_id
1715: AND user_je_source_name = 'OLD'
1716: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898
1717: WHERE GROUP_ID = p_group_id
1718: AND payroll_control_id = p_payroll_control_id);
1719:
1720:

Line 1920: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898

1916: from gl_interface
1917: where status = 'NEW'
1918: and group_id = p_group_id
1919: and user_je_source_name = 'OLD'
1920: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898
1921: WHERE GROUP_ID = p_group_id
1922: AND payroll_control_id = p_payroll_control_id);
1923:
1924: if l_no_run > 0 then

Line 1929: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898

1925:
1926: delete from gl_interface
1927: where group_id = p_group_id
1928: and user_je_source_name = 'OLD'
1929: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898
1930: WHERE GROUP_ID = p_group_id
1931: AND payroll_control_id = p_payroll_control_id);
1932:
1933:

Line 1934: delete from psp_summary_lines

1930: WHERE GROUP_ID = p_group_id
1931: AND payroll_control_id = p_payroll_control_id);
1932:
1933:
1934: delete from psp_summary_lines
1935: where payroll_control_id = p_payroll_control_id
1936: and group_id = p_group_id;
1937:
1938: --- bug 4328598 -- fix begin

Line 1974: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898

1970: FROM gl_interface
1971: WHERE group_id = p_group_id
1972: AND user_je_source_name = 'OLD'
1973: AND set_of_books_id = p_set_of_books_id
1974: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898
1975: WHERE GROUP_ID = p_group_id
1976: AND payroll_control_id = p_payroll_control_id);
1977:
1978:

Line 1997: UPDATE psp_summary_lines

1993: CLOSE gl_tie_back_reject_cur;
1994: EXIT;
1995: END IF;
1996: -- update summary_lines with the reject status code
1997: UPDATE psp_summary_lines
1998: SET interface_status = l_status, status_code = 'R'
1999: WHERE summary_line_id = to_number(l_reference6);
2000:
2001: OPEN assign_susp_ac_cur(to_number(l_reference6));

Line 2050: from psp_summary_lines where summary_line_id = to_number(l_reference6);

2046: l_reversal_ac_failed := 'Y';
2047:
2048: if x_lines_glccid is null then
2049: select gl_code_combination_id into x_lines_glccid
2050: from psp_summary_lines where summary_line_id = to_number(l_reference6);
2051: end if;
2052:
2053: ELSE
2054:

Line 2257: and reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898

2253: delete gl_interface
2254: where group_id = p_group_id
2255: and set_of_books_id = p_set_of_books_id
2256: AND user_je_source_name = l_user_je_source_name
2257: and reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898
2258: WHERE GROUP_ID = p_group_id
2259: AND payroll_control_id = p_payroll_control_id);
2260:
2261: IF l_reversal_ac_failed = 'Y' THEN

Line 2278: FROM psp_summary_lines

2274: p_period_end_date,distribution_date)
2275: WHERE suspense_reason_code like 'ST:%'
2276: AND summary_line_id
2277: IN (SELECT summary_line_id
2278: FROM psp_summary_lines
2279: WHERE payroll_control_id = p_payroll_control_id);
2280: ELSIF p_source_type = 'P' THEN
2281:
2282: UPDATE psp_pre_gen_dist_lines

Line 2290: FROM psp_summary_lines

2286: p_period_end_date,distribution_date)
2287: WHERE suspense_reason_code like 'ST:%'
2288: AND summary_line_id
2289: IN (SELECT summary_line_id
2290: FROM psp_summary_lines
2291: WHERE payroll_control_id = p_payroll_control_id);
2292: END IF;
2293:
2294: /* End of code for Bug 3065856 */

Line 2336: FROM psp_summary_lines

2332: p_period_end_date,distribution_date)
2333: WHERE suspense_reason_code like 'ST:%'
2334: AND summary_line_id
2335: IN (SELECT summary_line_id
2336: FROM psp_summary_lines
2337: WHERE payroll_control_id = p_payroll_control_id );
2338: ELSIF p_source_type = 'P' THEN
2339: UPDATE psp_pre_gen_dist_lines
2340: SET suspense_org_account_id = NULL,

Line 2347: FROM psp_summary_lines

2343: p_period_end_date,distribution_date)
2344: WHERE suspense_reason_code like 'ST:%'
2345: AND summary_line_id
2346: IN ( SELECT summary_line_id
2347: FROM psp_summary_lines
2348: WHERE payroll_control_id = p_payroll_control_id );
2349: END IF;
2350:
2351: /* End of code for Bug 3065866 */

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

2404: IF gl_tie_back_success_cur%NOTFOUND THEN
2405: CLOSE gl_tie_back_success_cur;
2406: EXIT;
2407: END IF;
2408: -- update records in psp_summary_lines as 'A'
2409: UPDATE psp_summary_lines
2410: SET status_code = 'A'
2411: WHERE summary_line_id = l_summary_line_id;
2412:

Line 2409: UPDATE psp_summary_lines

2405: CLOSE gl_tie_back_success_cur;
2406: EXIT;
2407: END IF;
2408: -- update records in psp_summary_lines as 'A'
2409: UPDATE psp_summary_lines
2410: SET status_code = 'A'
2411: WHERE summary_line_id = l_summary_line_id;
2412:
2413: IF l_dr_cr_flag = 'D' THEN

Line 3514: FROM psp_summary_lines psl

3510: psl.attribute8,
3511: psl.attribute9,
3512: psl.attribute10,
3513: org_id
3514: FROM psp_summary_lines psl
3515: WHERE psl.status_code = 'N'
3516: AND psl.gl_code_combination_id IS NULL
3517: AND psl.payroll_control_id = p_payroll_control_id;
3518:

Line 3571: FROM psp_summary_lines psl

3567:
3568:
3569: Cursor operating_unit_csr(p_payroll_control_id IN NUMBER) IS
3570: SELECT Distinct org_id
3571: FROM psp_summary_lines psl
3572: WHERE psl.status_code = 'N'
3573: AND psl.gl_code_combination_id IS NULL
3574: AND psl.payroll_control_id = p_payroll_control_id;
3575:

Line 3668: -- update psp_summary_lines with gms batch name

3664: INTO l_gms_batch_name
3665: FROM dual;
3666: */
3667: -- R12 MOAC Uptake. Moved this code to loop
3668: -- update psp_summary_lines with gms batch name
3669: FOR I in 1..org_id_tab.count
3670: LOOP
3671: UPDATE psp_summary_lines
3672: SET gms_batch_name = gms_batch_name_tab(i) -- R12 MOAC uptake. changed from l_gms_batch_name

Line 3671: UPDATE psp_summary_lines

3667: -- R12 MOAC Uptake. Moved this code to loop
3668: -- update psp_summary_lines with gms batch name
3669: FOR I in 1..org_id_tab.count
3670: LOOP
3671: UPDATE psp_summary_lines
3672: SET gms_batch_name = gms_batch_name_tab(i) -- R12 MOAC uptake. changed from l_gms_batch_name
3673: WHERE payroll_control_id = gms_batch_rec.payroll_control_id
3674: AND status_code = 'N'
3675: AND gl_code_combination_id IS NULL

Line 3912: from psp_summary_lines

3908: for i in 1..org_id_tab.count
3909: loop
3910: select gms_batch_name
3911: into gms_batch_name_tab(i)
3912: from psp_summary_lines
3913: where payroll_control_id = gms_batch_rec.payroll_control_id
3914: and org_id = org_id_tab(i)
3915: and project_id is not null
3916: and rownum = 1;

Line 3984: -- mark the successfully transferred records as 'A' in psp_summary_lines and psp_distribution_lines

3980: p_business_group_id ,
3981: p_set_of_books_id );
3982: ENd if;
3983:
3984: -- mark the successfully transferred records as 'A' in psp_summary_lines and psp_distribution_lines
3985: -- and transfer the successful records to the history table
3986: --- Bug 2663344 reverted NULL to l_period_end_date in tie back call
3987: hr_utility.trace(' before loop for gms_tie_back');
3988: FOR I in 1..org_id_tab.count

Line 4050: FROM psp_summary_lines

4046: p_return_status OUT NOCOPY VARCHAR2) IS
4047: CURSOR gms_tie_back_success_cur IS
4048: SELECT summary_line_id,
4049: dr_cr_flag,summary_amount
4050: FROM psp_summary_lines
4051: WHERE gms_batch_name = p_gms_batch_name;
4052:
4053:
4054: CURSOR gms_tie_back_reject_cur IS

Line 4269: From PSP_SUMMARY_LINES PSL

4265: summary_lines_rec SUMMARY_LINES_TYPE;
4266:
4267: Cursor SUMMARY_LINES_csr IS
4268: Select SUMMARY_LINE_ID, to_CHAR(SUMMARY_LINE_ID) , GMS_BATCH_NAME
4269: From PSP_SUMMARY_LINES PSL
4270: where PSL.GMS_BATCH_NAME = p_gms_batch_name;
4271: -- Bug 4369939: Performance fix END
4272:
4273:

Line 4318: delete from psp_summary_lines

4314: where batch_name = p_gms_batch_name
4315: and transaction_source = 'GOLD';
4316: end if;
4317:
4318: delete from psp_summary_lines
4319: where gms_batch_name = to_number(p_gms_batch_name)
4320: and payroll_control_id = p_payroll_control_id;
4321:
4322:

Line 4394: UPDATE psp_summary_lines

4390: END IF;
4391:
4392: -- update summary_lines with the reject status code
4393: IF l_trx_status_code in ('R', 'PO', 'PI', 'PR') THEN
4394: UPDATE psp_summary_lines
4395: SET interface_status = l_trx_reject_code, status_code = 'R',
4396: expenditure_ending_date = l_expenditure_ending_date, -- added 5 fields for 2445196
4397: expenditure_id = l_expenditure_id, interface_id=l_interface_id,
4398: expenditure_item_id=l_expenditure_item_id, txn_interface_id=l_txn_interface_id

Line 4401: UPDATE psp_summary_lines

4397: expenditure_id = l_expenditure_id, interface_id=l_interface_id,
4398: expenditure_item_id=l_expenditure_item_id, txn_interface_id=l_txn_interface_id
4399: WHERE summary_line_id = to_number(l_orig_trx_reference);
4400: ELSIF l_trx_status_code = 'A' THEN
4401: UPDATE psp_summary_lines
4402: SET interface_status = l_trx_reject_code, status_code = 'A',
4403: expenditure_ending_date = l_expenditure_ending_date, -- added 5 fields for 2445196
4404: expenditure_id = l_expenditure_id, interface_id=l_interface_id,
4405: expenditure_item_id=l_expenditure_item_id, txn_interface_id=l_txn_interface_id

Line 4410: FROM psp_summary_lines

4406: WHERE summary_line_id = to_number(l_orig_trx_reference);
4407:
4408: SELECT summary_amount,dr_cr_flag
4409: INTO l_summary_amount,l_dr_cr_flag
4410: FROM psp_summary_lines
4411: WHERE summary_line_id = to_number(l_orig_trx_reference) ;
4412: hr_utility.trace('entered gms_tie_back4');
4413: IF l_dr_cr_flag = 'D' THEN
4414: l_dr_summary_amount := l_dr_summary_amount + l_summary_amount;

Line 4803: FROM psp_summary_lines

4799: p_period_end_date,distribution_date)
4800: WHERE suspense_reason_code like 'ST:%'
4801: AND summary_line_id
4802: IN ( SELECT summary_line_id
4803: FROM psp_summary_lines
4804: WHERE payroll_control_id = p_payroll_control_id);
4805: ELSIF p_source_type = 'P' THEN
4806: UPDATE psp_pre_gen_dist_lines
4807: SET suspense_org_account_id = NULL,

Line 4814: FROM psp_summary_lines

4810: p_period_end_date,distribution_date)
4811: WHERE suspense_reason_code like 'ST:%'
4812: AND summary_line_id
4813: IN (SELECT summary_line_id
4814: FROM psp_summary_lines
4815: WHERE payroll_control_id = p_payroll_control_id);
4816:
4817: END IF;
4818: /* End of code for Bug 3065866 */

Line 4850: FROM psp_summary_lines

4846: suspense_reason_code = NULL
4847: WHERE suspense_reason_code like 'ST:%'
4848: AND summary_line_id
4849: IN( SELECT summary_line_id
4850: FROM psp_summary_lines
4851: WHERE payroll_control_id = p_payroll_control_id);
4852: ELSIF p_source_type = 'P' THEN
4853: UPDATE psp_pre_gen_dist_lines
4854: SET suspense_org_account_id = NULL,

Line 4859: FROM psp_summary_lines

4855: suspense_reason_code = NULL
4856: WHERE suspense_reason_code like 'ST:%'
4857: AND summary_line_id
4858: IN( SELECT summary_line_id
4859: FROM psp_summary_lines
4860: WHERE payroll_control_id = p_payroll_control_id);
4861: END IF;
4862: /* End of Bug 3065866 */
4863:

Line 4897: UPDATE PSP_SUMMARY_LINES PSL

4893: SUMMARY_LINES_rec.L_SUMMARY_LINE_ID_CHAR, SUMMARY_LINES_REC.L_GMS_BATCH_NAME;
4894: CLOSE SUMMARY_LINES_CSR;
4895:
4896: FORALL i in 1.. SUMMARY_LINES_REC.L_SUMMARY_LINE_ID.count
4897: UPDATE PSP_SUMMARY_LINES PSL
4898: Set (PSL.STATUS_CODE, PSL.EXPENDITURE_ENDING_DATE,PSL.EXPENDITURE_ID,
4899: PSL.INTERFACE_ID,PSL.EXPENDITURE_ITEM_ID,PSL.TXN_INTERFACE_ID) =
4900: ( SELECT 'A', PTXN.EXPENDITURE_ENDING_DATE,PTXN.EXPENDITURE_ID, PTXN.INTERFACE_ID,
4901: PTXN.EXPENDITURE_ITEM_ID,PTXN.TXN_INTERFACE_ID

Line 4912: UPDATE psp_summary_lines PSL

4908: PSL.SUMMARY_LINE_ID = SUMMARY_LINES_REC.L_SUMMARY_LINE_ID(i);
4909:
4910: /*
4911: -- changed to update all sum lines at one shot for 2445196
4912: UPDATE psp_summary_lines PSL
4913: SET (PSL.status_code, PSL.expenditure_ending_date,PSL.expenditure_id,
4914: PSL.interface_id,PSL.expenditure_item_id,PSL.txn_interface_id) =
4915: (select 'A', PTXN.expenditure_ending_date,PTXN.expenditure_id,
4916: PTXN.interface_id,PTXN.expenditure_item_id,PTXN.txn_interface_id

Line 4935: -- update records in psp_summary_lines as 'A' moved this stmnt from here to above for 2445196.

4931: CLOSE gms_tie_back_success_cur;
4932: EXIT;
4933: END IF;
4934:
4935: -- update records in psp_summary_lines as 'A' moved this stmnt from here to above for 2445196.
4936:
4937: IF l_dr_cr_flag = 'D' THEN
4938: l_dr_summary_amount := l_dr_summary_amount + l_summary_amount;
4939: ELSIF l_dr_cr_flag = 'C' THEN

Line 5672: psp_summary_lines psl

5668: group by person_id,effort_report_id;
5669: cursor check_emp_overlap is
5670: select count(*)
5671: from psp_Eff_reports per,
5672: psp_summary_lines psl
5673: where per.person_id = psl.person_id
5674: and psl.payroll_control_id in
5675: (select payroll_control_id
5676: from psp_payroll_controls