APPS.PSP_SUM_TRANS dependencies on PSP_SUMMARY_LINES_S

Line 1180: SELECT PSP_SUMMARY_LINES_S.NEXTVAL

1176: psp_general.get_gms_effective_date(p_person_id,l_gms_posting_effective_date);
1177: END IF;
1178: -- Code ended for Enhancement Employee Assignment with Zero Work Days
1179:
1180: SELECT PSP_SUMMARY_LINES_S.NEXTVAL
1181: INTO P_SUMMARY_LINE_ID
1182: FROM DUAL;
1183: INSERT INTO PSP_SUMMARY_LINES(
1184: SUMMARY_LINE_ID,

Line 2574: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_summary_lines set status_code = A count: '||sql%rowcount);

2570: UPDATE psp_summary_lines
2571: SET status_code = 'A'
2572: WHERE summary_line_id = l_summary_line_id;
2573:
2574: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_summary_lines set status_code = A count: '||sql%rowcount);
2575:
2576: IF l_dr_cr_flag = 'D' THEN
2577: l_dr_summary_amount := l_dr_summary_amount + l_summary_amount;
2578: ELSIF l_dr_cr_flag = 'C' THEN

Line 3873: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_summary_lines set status_code for org_id'||org_id_tab(i)||' to N count: '||sql%rowcount);

3869: AND status_code = 'N'
3870: AND gl_code_combination_id IS NULL
3871: AND org_id = org_id_tab(i); -- R12 MOAC uptake
3872:
3873: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_summary_lines set status_code for org_id'||org_id_tab(i)||' to N count: '||sql%rowcount);
3874:
3875: END LOOP;
3876:
3877: