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_ENC_LIQ_TRAN dependencies on PSP_ENC_SUMMARY_LINES_S

Line 1789: UPDATE psp_Enc_summary_lines S1 set S1.status_code='A' where

1785:
1786: IF l_status_code = 'R' THEN
1787: if l_sup_enc_summary_line_id <>0 then
1788:
1789: UPDATE psp_Enc_summary_lines S1 set S1.status_code='A' where
1790: S1.enc_summary_line_id=l_sup_enc_summary_line_id and
1791: S1.status_code='S' and not exists
1792: -- added code to ensure there is no L line before reverting S
1793: -- for 2479579

Line 1794: (select 1 from psp_enc_summary_lines S2

1790: S1.enc_summary_line_id=l_sup_enc_summary_line_id and
1791: S1.status_code='S' and not exists
1792: -- added code to ensure there is no L line before reverting S
1793: -- for 2479579
1794: (select 1 from psp_enc_summary_lines S2
1795: where S2.status_code = 'L' and S1.enc_control_id = S2.enc_control_id
1796: and S2.superceded_line_id = l_sup_enc_summary_line_id);
1797: / * mark the change_flag in psp_Enc_lineS_history as well * /
1798: -- Update the change_flag to 'U' as per HQ review comment for Enh. 2143723

Line 2258: VALUES (psp_enc_summary_lines_s.NEXTVAL, g_bg_id,

2254: attribute6, attribute7, attribute8,
2255: attribute9, attribute10, liquidate_request_id,
2256: proposed_termination_date, last_update_date, last_updated_by,
2257: last_update_login, created_by, creation_date)
2258: VALUES (psp_enc_summary_lines_s.NEXTVAL, g_bg_id,
2259: r_liq_lines.enc_control_id(recno), r_liq_lines.time_period_id(recno),
2260: r_liq_lines.person_id(recno), r_liq_lines.assignment_id(recno),
2261: r_liq_lines.effective_date(recno), r_liq_lines.set_of_books_id(recno),
2262: r_liq_lines.gl_code_combination_id(recno), r_liq_lines.summary_amount(recno),

Line 2458: update psp_enc_summary_lines set status_code='S'

2454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2455: END IF;
2456:
2457: / * Flag the original line as Superceded* /
2458: update psp_enc_summary_lines set status_code='S'
2459: where enc_summary_line_id=enc_liq_rec.enc_summary_line_id;
2460:
2461:
2462:

Line 2536: SELECT PSP_ENC_SUMMARY_LINES_S.NEXTVAL

2532: p_expenditure_item_id IN NUMBER, -- bug 4068182
2533: p_return_status OUT NOCOPY VARCHAR2
2534: ) IS
2535: BEGIN
2536: SELECT PSP_ENC_SUMMARY_LINES_S.NEXTVAL
2537: INTO P_ENC_SUMMARY_LINE_ID
2538: FROM DUAL;
2539: INSERT INTO PSP_ENC_SUMMARY_LINES(
2540: ENC_SUMMARY_LINE_ID,

Line 3747: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_enc_summary_lines setting interface_status');

3743: -- status_code = 'R'
3744: WHERE enc_summary_line_id = r_interface.enc_summary_line_id(recno)
3745: AND r_interface.status(recno) <> 'P'
3746: AND SUBSTR(r_interface.status(recno), 1, 1) <> 'W';
3747: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_enc_summary_lines setting interface_status');
3748:
3749: IF (SQL%ROWCOUNT > 0) THEN
3750: g_liq_has_failed_transactions := TRUE;
3751: g_rejected_group_id := p_group_id;

Line 3795: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_enc_summary_lines setting status_code to ''L'' SQL%ROWCOUNT ' || SQL%ROWCOUNT);

3791: SET status_code = 'L'
3792: WHERE enc_summary_line_id = r_interface.enc_summary_line_id(recno)
3793: AND status_code = 'N';
3794:
3795: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_enc_summary_lines setting status_code to ''L'' SQL%ROWCOUNT ' || SQL%ROWCOUNT);
3796:
3797:
3798: IF (g_person_id IS NOT NULL) THEN
3799: FORALL recno IN 1..r_interface.enc_summary_line_id.COUNT

Line 3917: update psp_enc_summary_lines set status_code='A' where

3913: -- status_code = 'A'
3914: status_code='R'
3915: WHERE rowid = l_rowid;
3916:
3917: update psp_enc_summary_lines set status_code='A' where
3918: enc_summary_line_id in (select superceded_line_id from
3919: psp_Enc_summary_lines where rowid=l_rowid);
3920:
3921: ELSE

Line 4056: update psp_Enc_summary_lines set ------dr_cr_flag='D',

4052: -- insert into psp_stout values (99, 'project_id is '||l_project_id);
4053: -- insert into psp_stout values (99, 'award id is '||l_award_id);
4054: --- modified the update for 2530853, flipping the sign of amount if 'C'
4055: if l_gl_project_flag ='P' then
4056: update psp_Enc_summary_lines set ------dr_cr_flag='D',
4057: summary_amount= decode(dr_cr_flag,'C',-summary_amount,summary_amount)
4058: where rowid=l_rowid;
4059: end if;
4060:

Line 4750: VALUES (psp_enc_summary_lines_s.NEXTVAL, g_bg_id,

4746: attribute6, attribute7, attribute8,
4747: attribute9, attribute10, liquidate_request_id,
4748: proposed_termination_date, last_update_date, last_updated_by,
4749: last_update_login, created_by, creation_date)
4750: VALUES (psp_enc_summary_lines_s.NEXTVAL, g_bg_id,
4751: r_liq_lines.enc_control_id(recno), r_liq_lines.time_period_id(recno),
4752: r_liq_lines.person_id(recno), r_liq_lines.assignment_id(recno),
4753: r_liq_lines.effective_date(recno), r_liq_lines.set_of_books_id(recno),
4754: r_liq_lines.project_id(recno), r_liq_lines.task_id(recno),

Line 4975: update psp_enc_summary_lines set status_code='S'

4971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4972: END IF;
4973:
4974: / * Flag the original line as Superceded* /
4975: update psp_enc_summary_lines set status_code='S'
4976: where enc_summary_line_id=enc_liq_rec.enc_summary_line_id;
4977: END LOOP;
4978:
4979: END LOOP;

Line 5690: update psp_Enc_summary_lines set gms_posting_override_date=l_effective_date

5686:
5687: -- Replaced != by <> ib the foll. condn. for GSCC warning.
5688: if trunc(l_effective_date) <> trunc(int_rec.effective_date)
5689: then
5690: update psp_Enc_summary_lines set gms_posting_override_date=l_effective_date
5691: where enc_summary_line_id=int_rec.enc_summary_line_id;
5692: end if;
5693:
5694: l_exp_end_dt := pa_utils.getweekending(l_effective_date);

Line 6389: update psp_enc_summary_lines set status_code ='A' where

6385: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gms_trancsaction_interface_all sql%rowcount'||sql%rowcount);
6386: ***/
6387:
6388: /***** Converted the following UPDATE to BULK for R12 performance fixes (bug 4507892)
6389: update psp_enc_summary_lines set status_code ='A' where
6390: enc_summary_line_id in (select superceded_line_id from
6391: psp_enc_summary_lines where gms_batch_name=p_gms_batch_name);
6392: End of comment for bug fix 4507892 *****/
6393: -- Introduced the following fo bug fix 4507892

Line 6436: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from psp_enc_summary_lines sql%rowcount'||sql%rowcount);

6432: AND gms_batch_name = p_gms_batch_name;
6433: -- Bug 13036705
6434: -- and enc_control_id = p_enc_control_id;
6435:
6436: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from psp_enc_summary_lines sql%rowcount'||sql%rowcount);
6437:
6438: -- Introduced the folowing for bug fix 4625734
6439: FORALL recno IN 1..r_enc_controls.enc_control_id.COUNT
6440: UPDATE psp_enc_controls pec

Line 6735: update psp_enc_summary_lines set status_code='A' where

6731: -- status_code = 'A'
6732: status_code = 'R'
6733: WHERE rowid = l_rowid;
6734:
6735: update psp_enc_summary_lines set status_code='A' where
6736: enc_summary_line_id in (select superceded_line_id from
6737: psp_Enc_summary_lines where rowid=l_rowid);
6738:
6739: ELSE

Line 6858: update psp_Enc_summary_lines set ----- dr_cr_flag='C',

6854: -- insert into psp_stout values (99, 'project_id is '||l_project_id);
6855: -- insert into psp_stout values (99, 'award id is '||l_award_id);
6856: --- modified the update for 2530853, flipping the sign of amount if 'C'
6857: if l_gl_project_flag ='G' then
6858: update psp_Enc_summary_lines set ----- dr_cr_flag='C',
6859: summary_amount=decode(dr_cr_flag,'C', -summary_amount,summary_amount)
6860: where rowid=l_rowid;
6861: end if;
6862: