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_SUM_TRAN dependencies on PSP_ENC_LINES

Line 412: UPDATE psp_enc_lines

408: AND superceded_line_id IS NULL
409: AND status_code = 'N';
410: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted un-imported summary lines (' || SQL%ROWCOUNT || ')');
411:
412: UPDATE psp_enc_lines
413: SET suspense_org_account_id = NULL,
414: gl_code_combination_id = orig_gl_code_combination_id,
415: project_id = orig_project_id,
416: task_id = orig_task_id,

Line 425: UPDATE psp_enc_lines

421: encumbrance_date = prev_effective_date
422: WHERE payroll_action_id = p_payroll_action_id
423: AND suspense_reason_code like 'ES:%';
424:
425: UPDATE psp_enc_lines
426: SET orig_gl_code_combination_id = NULL,
427: orig_project_id = NULL,
428: orig_task_id = NULL,
429: orig_award_id = NULL,

Line 556: -- When the program returns a failure status, it also updates PSP_ENC_LINES

552: -- This procedure updates the table PSP_ENC_CONTROLS with ACTION_CODE = 'P',
553: -- if the program is completed with a return code of success and if the
554: -- return code is failed it updates ACTION_CODE = 'N'.
555:
556: -- When the program returns a failure status, it also updates PSP_ENC_LINES
557: -- with STATUS_CODE = 'N' and PSP_ENC_SUMMARY_LINES with STATUS_CODE = 'R'
558:
559: -- ##########################################################################
560:

Line 571: FROM psp_enc_lines

567: AND pesl.status_code = 'N';
568:
569: CURSOR check_enc_lines IS
570: SELECT COUNT(1)
571: FROM psp_enc_lines
572: WHERE payroll_action_id = p_payroll_action_id
573: AND enc_start_date <= g_def_end_date;
574:
575: l_pending_line_count NUMBER;

Line 594: DELETE psp_enc_lines

590: FETCH check_enc_lines INTO l_enc_lines_cnt;
591: CLOSE check_enc_lines;
592:
593: IF (l_enc_lines_cnt = 0) THEN
594: DELETE psp_enc_lines
595: WHERE payroll_action_id = p_payroll_action_id;
596: END IF;
597:
598: move_rej_lines_to_arch(p_payroll_action_id);

Line 630: FROM psp_enc_lines pel

626: SET process_phase = 'summarize_transfer'
627: WHERE payroll_action_id = p_payroll_action_id
628: AND process_code = 'ST'
629: AND EXISTS (SELECT 1
630: FROM psp_enc_lines pel
631: WHERE pel.payroll_action_id = p_payroll_action_id);
632: IF (SQL%ROWCOUNT > 0) THEN
633: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase to summarize and transfer re-processing');
634: END IF;

Line 739: FROM psp_enc_lines pel

735: enc_control_rec enc_control_cur%ROWTYPE;
736: / * Included as part of Bug fix #1776606 * /
737: CURSOR gl_gms_line_count_cur IS
738: SELECT count(*)
739: FROM psp_enc_lines pel
740: -- ,psp_enc_controls pec
741: WHERE pel.enc_control_id= enc_control_rec.enc_control_id
742: AND pel.time_period_id = enc_control_rec.time_period_id
743: AND pel.encumbrance_amount<>0

Line 788: FROM psp_enc_lines pel

784: -- in psp_enc_controls to 'P' or 'N'
785: / * Commented as part of bug fix #1776606
786: SELECT nvl(sum(encumbrance_amount),0)
787: INTO l_o_enc_sum
788: FROM psp_enc_lines pel
789: -- ,psp_enc_controls pec
790: WHERE pel.enc_control_id = enc_control_rec.enc_control_id
791: AND pel.time_period_id = enc_control_rec.time_period_id
792: AND pel.business_group_id = g_business_group_id

Line 878: -- This procedure summarizes all the lines from psp_enc_lines

874: END;
875: End of comment for Create and Update multi thread enh. *****/
876:
877: -- ##########################################################################
878: -- This procedure summarizes all the lines from psp_enc_lines
879: -- and inserts the summarized lines into psp_enc_summary_lines
880:
881: -- Depending on the setup options, this procedure groups transactions from
882: -- PSP_ENC_LINES and inserts the summarized lines into PSP_ENC_SUMMARY_LINES

Line 882: -- PSP_ENC_LINES and inserts the summarized lines into PSP_ENC_SUMMARY_LINES

878: -- This procedure summarizes all the lines from psp_enc_lines
879: -- and inserts the summarized lines into psp_enc_summary_lines
880:
881: -- Depending on the setup options, this procedure groups transactions from
882: -- PSP_ENC_LINES and inserts the summarized lines into PSP_ENC_SUMMARY_LINES
883:
884: -- There are two setup options in PSP_ENC_SETUP_OPTIONS table called 'TIME_BASED_SUMM'
885: -- and 'CI_BASED_SUMM_GL' on which the procedure depends.
886:

Line 951: FROM PSP_ENC_LINES PEL,

947: DECODE(g_dff_grouping_option, 'Y', DECODE(suspense_org_account_id, NULL, pel.attribute7, pos.attribute7), NULL) attribute7,
948: DECODE(g_dff_grouping_option, 'Y', DECODE(suspense_org_account_id, NULL, pel.attribute8, pos.attribute8), NULL) attribute8,
949: DECODE(g_dff_grouping_option, 'Y', DECODE(suspense_org_account_id, NULL, pel.attribute9, pos.attribute9), NULL) attribute9,
950: DECODE(g_dff_grouping_option, 'Y', DECODE(suspense_org_account_id, NULL, pel.attribute10, pos.attribute10), NULL) attribute10
951: FROM PSP_ENC_LINES PEL,
952: PER_TIME_PERIODS PTP,
953: -- ,GL_SETS_OF_BOOKS SOB,
954: -- GL_CODE_COMBINATIONS GCC,
955: PSP_ORGANIZATION_ACCOUNTS POS

Line 999: FROM PSP_ENC_LINES PEL,

995: pel.person_id,
996: pel.gl_code_combination_id gl_ccid
997: -- sob.set_of_books_id,
998: -- decode(suspense_org_account_id, null, pel.gl_code_combination_id, pos.gl_code_combination_id) gl_ccid
999: FROM PSP_ENC_LINES PEL,
1000: PER_TIME_PERIODS PTP
1001: -- ,GL_SETS_OF_BOOKS SOB,
1002: -- GL_CODE_COMBINATIONS GCC,
1003: -- PSP_ORGANIZATION_ACCOUNTS POS

Line 1033: FROM PSP_ENC_LINES PEL,

1029: pel.gl_project_flag,
1030: pel.gl_code_combination_id gl_ccid
1031: -- sob.set_of_books_id,
1032: -- decode(suspense_org_account_id, null, pel.gl_code_combination_id, pos.gl_code_combination_id) gl_ccid
1033: FROM PSP_ENC_LINES PEL,
1034: PER_TIME_PERIODS PTP
1035: -- ,GL_SETS_OF_BOOKS SOB,
1036: -- GL_CODE_COMBINATIONS GCC,
1037: -- PSP_ORGANIZATION_ACCOUNTS POS

Line 1072: FROM PSP_ENC_LINES PEL,

1068: pel.assignment_id,
1069: pel.gl_code_combination_id gl_ccid
1070: -- ,sob.set_of_books_id,
1071: -- decode(suspense_org_account_id, null, pel.gl_code_combination_id, pos.gl_code_combination_id) gl_ccid
1072: FROM PSP_ENC_LINES PEL,
1073: GL_PERIODS GLP,
1074: GL_SETS_OF_BOOKS SOB,
1075: -- ,GL_CODE_COMBINATIONS GCC,
1076: -- PSP_ORGANIZATION_ACCOUNTS POS

Line 1104: FROM PSP_ENC_LINES PEL,

1100: pel.gl_project_flag,
1101: pel.person_id,
1102: pel.gl_code_combination_id gl_ccid
1103: -- ,decode(suspense_org_account_id, null, pel.gl_code_combination_id, pos.gl_code_combination_id) gl_ccid
1104: FROM PSP_ENC_LINES PEL,
1105: GL_PERIODS GLP,
1106: GL_SETS_OF_BOOKS SOB
1107: -- ,GL_CODE_COMBINATIONS GCC,
1108: -- PSP_ORGANIZATION_ACCOUNTS POS

Line 1134: FROM PSP_ENC_LINES PEL,

1130: sum(pel.encumbrance_amount) sum_amt,
1131: pel.gl_project_flag,
1132: pel.gl_code_combination_id gl_ccid
1133: -- ,decode(suspense_org_account_id, null, pel.gl_code_combination_id, pos.gl_code_combination_id) gl_ccid
1134: FROM PSP_ENC_LINES PEL,
1135: GL_PERIODS GLP,
1136: GL_SETS_OF_BOOKS SOB
1137: -- ,GL_CODE_COMBINATIONS GCC,
1138: -- PSP_ORGANIZATION_ACCOUNTS POS

Line 1288: UPDATE psp_enc_lines

1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: END IF;
1286:
1287: IF (g_dff_grouping_option = 'N') THEN -- Introduced for bug fix 2908859
1288: UPDATE psp_enc_lines
1289: SET enc_summary_line_id = l_enc_summary_line_id
1290: WHERE enc_control_id = enc_control_rec.enc_control_id
1291: AND payroll_id = enc_control_rec.payroll_id
1292: AND time_period_id = enc_control_rec.time_period_id

Line 1308: UPDATE psp_enc_lines

1304: AND poa.gl_code_combination_id = enc_sum_lines_p1_rec.gl_ccid))
1305: OR gl_code_combination_id = enc_sum_lines_p1_rec.gl_ccid);
1306: -- Introduced ELSE portion for bug fix 2908859
1307: ELSE
1308: UPDATE psp_enc_lines
1309: SET enc_summary_line_id = l_enc_summary_line_id
1310: WHERE enc_control_id = enc_control_rec.enc_control_id
1311: AND payroll_id = enc_control_rec.payroll_id
1312: AND time_period_id = enc_control_rec.time_period_id

Line 1407: UPDATE psp_enc_lines

1403: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1405: END IF;
1406:
1407: UPDATE psp_enc_lines
1408: SET enc_summary_line_id = l_enc_summary_line_id
1409: WHERE enc_control_id = enc_control_rec.enc_control_id
1410: AND payroll_id = enc_control_rec.payroll_id
1411: ANd time_period_id = enc_control_rec.time_period_id

Line 1472: UPDATE psp_enc_lines

1468: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: END IF;
1471:
1472: UPDATE psp_enc_lines
1473: SET enc_summary_line_id = l_enc_summary_line_id
1474: WHERE enc_control_id = enc_control_rec.enc_control_id
1475: AND time_period_id = enc_control_rec.time_period_id
1476: AND payroll_id = enc_control_rec.payroll_id

Line 1539: UPDATE psp_enc_lines

1535: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1537: END IF;
1538:
1539: UPDATE psp_enc_lines
1540: SET enc_summary_line_id = l_enc_summary_line_id
1541: WHERE enc_control_id = enc_control_rec.enc_control_id
1542: AND time_period_id = enc_control_rec.time_period_id
1543: AND payroll_id = enc_control_rec.payroll_id

Line 1603: UPDATE psp_enc_lines

1599: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1601: END IF;
1602:
1603: UPDATE psp_enc_lines
1604: SET enc_summary_line_id = l_enc_summary_line_id
1605: WHERE enc_control_id = enc_control_rec.enc_control_id
1606: AND payroll_id = enc_control_rec.payroll_id
1607: AND time_period_id = enc_control_rec.time_period_id

Line 1666: UPDATE psp_enc_lines

1662: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1664: END IF;
1665:
1666: UPDATE psp_enc_lines
1667: SET enc_summary_line_id = l_enc_summary_line_id
1668: WHERE enc_control_id = enc_control_rec.enc_control_id
1669: AND payroll_id = enc_control_rec.payroll_id
1670: AND time_period_id = enc_control_rec.time_period_id

Line 2716: FROM psp_enc_lines pel

2712: CURSOR assign_susp_ac_cur(P_ENC_LINE_ID IN NUMBER) IS
2713: SELECT pel.rowid,
2714: pel.encumbrance_date,
2715: pel.suspense_org_account_id
2716: FROM psp_enc_lines pel
2717: WHERE pel.enc_summary_line_id = p_enc_line_id
2718: and enc_control_id=p_enc_control_id ; -- this added to fix suspense ac postings
2719: -- bug fix 1671938
2720:

Line 2735: psp_enc_lines pel

2731: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
2732: SELECT hou.organization_id, hou.name
2733: FROM hr_all_organization_units hou,
2734: per_assignments_f paf,
2735: psp_enc_lines pel
2736: WHERE pel.enc_summary_line_id = p_line_id
2737: AND pel.assignment_id = paf.assignment_id
2738: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date
2739: AND paf.organization_id = hou.organization_id

Line 2749: psp_enc_lines pel

2745: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
2746: SELECT hou.organization_id, hou.name
2747: FROM hr_all_organization_units hou,
2748: per_assignments_f paf,
2749: psp_enc_lines pel
2750: WHERE
2751: -- pel.enc_summary_line_id = p_line_id
2752: pel.rowid=p_rowid
2753: AND pel.assignment_id = paf.assignment_id

Line 2775: psp_enc_lines pel

2771: pel.suspense_org_account_id,
2772: pel.gl_code_combination_id
2773: FROM hr_organization_units hou,
2774: per_assignments_f paf,
2775: psp_enc_lines pel
2776: WHERE pel.enc_summary_line_id = p_enc_summary_line_id
2777: AND pel.assignment_id = paf.assignment_id
2778: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date
2779: AND paf.organization_id = hou.organization_id

Line 2959: UPDATE psp_enc_lines

2955: null;
2956: --- fIx for bug 1671938/1888408
2957:
2958: / *
2959: UPDATE psp_enc_lines
2960: SET status_code = 'N'
2961: WHERE rowid = l_rowid;
2962: -- if the suspense a/c failed,update the status of the whole batch and display the error
2963:

Line 2975: UPDATE psp_enc_lines

2971: l_suspense_ac_failed := 'Y';
2972:
2973: / * Commented the following for Bug 3194807
2974:
2975: UPDATE psp_enc_lines
2976: SET suspense_reason_code = l_status,
2977: status_code = 'N'
2978: WHERE rowid = l_rowid;
2979:

Line 3076: UPDATE psp_enc_lines

3072:
3073: -- assign the organization suspense account and gl status
3074: / * For Bug fix 3194807 * /
3075:
3076: UPDATE psp_enc_lines
3077: SET prev_effective_date = encumbrance_date
3078: WHERE rowid = l_rowid;
3079: / * End of changes for Bug fix 3194807 * /
3080:

Line 3081: UPDATE psp_enc_lines

3077: SET prev_effective_date = encumbrance_date
3078: WHERE rowid = l_rowid;
3079: / * End of changes for Bug fix 3194807 * /
3080:
3081: UPDATE psp_enc_lines
3082: SET suspense_org_account_id = l_organization_account_id,
3083: suspense_reason_code = 'ES:' || l_status,
3084: gl_project_flag = l_gl_project_flag,
3085: -- encumbrance_date = l_encumbrance_date, for Bug 3194807

Line 3134: UPDATE psp_enc_lines

3130:
3131:
3132: / * Added the following for Bug 3194807 * /
3133:
3134: UPDATE psp_enc_lines
3135: SET suspense_org_account_id = NULL,
3136: suspense_reason_code = NULL,
3137: gl_project_flag = decode(gl_code_combination_id,NULL,'P','G'),
3138: encumbrance_date = prev_effective_date

Line 3191: UPDATE psp_enc_lines

3187: ELSIF l_dr_cr_flag = 'C' THEN
3188: l_cr_summary_amount := l_cr_summary_amount + l_summary_amount;
3189: END IF;
3190:
3191: UPDATE psp_enc_lines
3192: SET status_code = 'A'
3193: WHERE enc_summary_line_id = l_enc_summary_line_id
3194: AND enc_control_id = p_enc_control_id;
3195:

Line 3197: UPDATE psp_enc_lines

3193: WHERE enc_summary_line_id = l_enc_summary_line_id
3194: AND enc_control_id = p_enc_control_id;
3195:
3196: / * Introduced this cursor for Bug fix 3194807 * /
3197: UPDATE psp_enc_lines
3198: SET gl_code_combination_id = (SELECT poa.gl_code_combination_id
3199: FROM psp_organization_accounts poa
3200: where poa.organization_account_id = suspense_org_account_id),
3201: project_id = NULL,

Line 3211: -- move the transferred records to psp_enc_lines_history

3207: AND suspense_reason_code LIKE 'ES:%';
3208: / * End of code Changes for Bug fix 3194807 * /
3209:
3210:
3211: -- move the transferred records to psp_enc_lines_history
3212: -- Added enc_start_date ,enc_end_date columns for Enh. Enc Redesign Prorata,Bug #2259310.
3213: -- Introduced DFF columns for bug fix 2908859
3214: INSERT INTO psp_enc_lines_history
3215: (enc_line_id,business_group_id,enc_element_type_id,encumbrance_date,

Line 3214: INSERT INTO psp_enc_lines_history

3210:
3211: -- move the transferred records to psp_enc_lines_history
3212: -- Added enc_start_date ,enc_end_date columns for Enh. Enc Redesign Prorata,Bug #2259310.
3213: -- Introduced DFF columns for bug fix 2908859
3214: INSERT INTO psp_enc_lines_history
3215: (enc_line_id,business_group_id,enc_element_type_id,encumbrance_date,
3216: dr_cr_flag,encumbrance_amount,status_code,enc_line_type,schedule_line_id,org_schedule_id,
3217: default_org_account_id,suspense_org_account_id,element_account_id,gl_project_flag,
3218: enc_summary_line_id,person_id,assignment_id,award_id,task_id,expenditure_type,

Line 3235: FROM psp_enc_lines

3231: last_updated_by,last_update_login,created_by,creation_date,enc_start_date,enc_end_date,
3232: attribute_category, attribute1, attribute2, attribute3,
3233: attribute4, attribute5, attribute6, attribute7,
3234: attribute8, attribute9, attribute10
3235: FROM psp_enc_lines
3236: WHERE status_code = 'A'
3237: AND enc_summary_line_id = l_enc_summary_line_id
3238: AND enc_control_id = p_enc_control_id;
3239:

Line 3240: DELETE FROM psp_enc_lines

3236: WHERE status_code = 'A'
3237: AND enc_summary_line_id = l_enc_summary_line_id
3238: AND enc_control_id = p_enc_control_id;
3239:
3240: DELETE FROM psp_enc_lines
3241: WHERE status_code = 'A'
3242: AND enc_summary_line_id = l_enc_summary_line_id
3243: AND enc_control_id = p_enc_control_id;
3244:

Line 3338: FROM psp_enc_lines pel,

3334: pel.gl_code_combination_id,
3335: pel.suspense_org_account_id,
3336: pesl.interface_status,
3337: ptp.end_date
3338: FROM psp_enc_lines pel,
3339: psp_enc_summary_lines pesl,
3340: per_time_periods ptp
3341: WHERE pel.payroll_action_id = p_payroll_action_id
3342: AND pel.enc_summary_line_id = pesl.enc_summary_line_id

Line 3362: psp_enc_lines pel

3358: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
3359: SELECT hou.organization_id, hou.name
3360: FROM hr_all_organization_units hou,
3361: per_assignments_f paf,
3362: psp_enc_lines pel
3363: WHERE pel.rowid=p_rowid
3364: AND pel.assignment_id = paf.assignment_id
3365: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date
3366: AND paf.organization_id = hou.organization_id

Line 3615: UPDATE psp_enc_lines

3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END IF;
3613: END IF;
3614:
3615: UPDATE psp_enc_lines
3616: SET prev_effective_date = encumbrance_date,
3617: orig_gl_code_combination_id = gl_code_combination_id,
3618: orig_project_id = project_id,
3619: orig_task_id = task_id,

Line 3626: UPDATE psp_enc_lines

3622: orig_expenditure_type = expenditure_type
3623: WHERE rowid = r_suspense_ac.row_id(recno)
3624: AND enc_start_date <= g_def_end_date;
3625:
3626: UPDATE psp_enc_lines
3627: SET suspense_org_account_id = l_organization_account_id,
3628: gl_code_combination_id = l_susp_glccid,
3629: project_id = l_project_id,
3630: task_id = l_task_id,

Line 3656: UPDATE psp_enc_lines

3652: END IF;
3653: END LOOP;
3654:
3655: IF l_suspense_ac_failed = 'Y' THEN
3656: UPDATE psp_enc_lines
3657: SET suspense_org_account_id = NULL,
3658: gl_code_combination_id = orig_gl_code_combination_id,
3659: project_id = orig_project_id,
3660: task_id = orig_task_id,

Line 3672: UPDATE psp_enc_lines

3668: FROM psp_enc_summary_lines pesl
3669: WHERE pesl.payroll_action_id = p_payroll_action_id
3670: AND pesl.group_id = p_group_id
3671: AND status_code = 'R');
3672: UPDATE psp_enc_lines
3673: SET orig_gl_code_combination_id = NULL,
3674: orig_project_id = NULL,
3675: orig_task_id = NULL,
3676: orig_award_id = NULL,

Line 3732: INSERT INTO psp_enc_lines_history

3728:
3729: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code to ''A'' in psp_enc_summary_lines');
3730:
3731: FORALL recno IN 1..r_interface.enc_summary_line_id.COUNT
3732: INSERT INTO psp_enc_lines_history
3733: (enc_line_id, business_group_id, enc_element_type_id, encumbrance_date,
3734: dr_cr_flag, encumbrance_amount, status_code, enc_line_type,
3735: schedule_line_id, org_schedule_id, default_org_account_id, suspense_org_account_id,
3736: element_account_id, gl_project_flag, enc_summary_line_id, person_id,

Line 3763: FROM psp_enc_lines

3759: attribute7, attribute8, attribute9, attribute10,
3760: payroll_action_id, hierarchy_code, hierarchy_start_date, hierarchy_end_date,
3761: orig_gl_code_combination_id, orig_project_id, orig_task_id, orig_award_id,
3762: orig_expenditure_org_id, orig_expenditure_type
3763: FROM psp_enc_lines
3764: WHERE enc_summary_line_id = r_interface.enc_summary_line_id(recno);
3765: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history');
3766:
3767: FORALL recno IN 1..r_interface.enc_summary_line_id.COUNT

Line 3765: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history');

3761: orig_gl_code_combination_id, orig_project_id, orig_task_id, orig_award_id,
3762: orig_expenditure_org_id, orig_expenditure_type
3763: FROM psp_enc_lines
3764: WHERE enc_summary_line_id = r_interface.enc_summary_line_id(recno);
3765: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history');
3766:
3767: FORALL recno IN 1..r_interface.enc_summary_line_id.COUNT
3768: DELETE FROM psp_enc_lines
3769: WHERE enc_summary_line_id = r_interface.enc_summary_line_id(recno);

Line 3768: DELETE FROM psp_enc_lines

3764: WHERE enc_summary_line_id = r_interface.enc_summary_line_id(recno);
3765: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history');
3766:
3767: FORALL recno IN 1..r_interface.enc_summary_line_id.COUNT
3768: DELETE FROM psp_enc_lines
3769: WHERE enc_summary_line_id = r_interface.enc_summary_line_id(recno);
3770: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines from psp_enc_lines that are summarized and trasnferred to target systems');
3771:
3772: FORALL recno IN 1..r_interface.enc_control_id.COUNT

Line 3770: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines from psp_enc_lines that are summarized and trasnferred to target systems');

3766:
3767: FORALL recno IN 1..r_interface.enc_summary_line_id.COUNT
3768: DELETE FROM psp_enc_lines
3769: WHERE enc_summary_line_id = r_interface.enc_summary_line_id(recno);
3770: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines from psp_enc_lines that are summarized and trasnferred to target systems');
3771:
3772: FORALL recno IN 1..r_interface.enc_control_id.COUNT
3773: UPDATE psp_enc_controls pec
3774: SET gl_phase = 'TieBack',

Line 3986: -- This procedure summarizes all the lines from psp_enc_lines

3982:
3983: END;
3984:
3985: -- ##########################################################################
3986: -- This procedure summarizes all the lines from psp_enc_lines
3987: -- where gl_project_flag = 'P' and inserts the summarized lines
3988: -- into psp_enc_summary_lines
3989:
3990: -- Depending on the setup options, this procedure groups transactions from

Line 3991: -- PSP_ENC_LINES and inserts the summarized lines into PSP_ENC_SUMMARY_LINES

3987: -- where gl_project_flag = 'P' and inserts the summarized lines
3988: -- into psp_enc_summary_lines
3989:
3990: -- Depending on the setup options, this procedure groups transactions from
3991: -- PSP_ENC_LINES and inserts the summarized lines into PSP_ENC_SUMMARY_LINES
3992:
3993: -- There are two setup options in PSP_ENC_SETUP_OPTIONS table called 'TIME_BASED_SUMM'
3994: -- and 'CI_BASED_SUMM_OGM' on which the procedure depends.
3995:

Line 4058: FROM PSP_ENC_LINES PEL,

4054: pel.award_id,
4055: pel.expenditure_type,
4056: pel.expenditure_organization_id * /
4057: -- ,pai.set_of_books_id
4058: FROM PSP_ENC_LINES PEL,
4059: PER_TIME_PERIODS PTP,
4060: PSP_ORGANIZATION_ACCOUNTS POA
4061: -- ,PA_IMPLEMENTATIONS_ALL PAI
4062: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID

Line 4124: FROM PSP_ENC_LINES PEL,

4120: pel.award_id,
4121: pel.expenditure_type,
4122: pel.expenditure_organization_id,
4123: pai.set_of_books_id
4124: FROM PSP_ENC_LINES PEL,
4125: GL_PERIODS GLP,
4126: PA_IMPLEMENTATIONS_ALL PAI
4127: WHERE PEL.BUSINESS_GROUP_ID = PAI.BUSINESS_GROUP_ID
4128: AND GLP.PERIOD_TYPE = PAI.PA_PERIOD_TYPE

Line 4273: UPDATE psp_enc_lines

4269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4270: END IF;
4271:
4272: IF (g_dff_grouping_option = 'N') THEN -- Introduced for bug fix 2908859
4273: UPDATE psp_enc_lines
4274: SET enc_summary_line_id = l_enc_summary_line_id
4275: WHERE -- project_id = enc_sum_lines_p_rec.project_id Commented for bug fix 3194807
4276: -- Introduced the suspense_org_account verification for bug fix 3194807
4277: ( (suspense_org_account_id IS NOT NULL

Line 4306: UPDATE psp_enc_lines

4302: AND trunc(encumbrance_date) = trunc(enc_sum_lines_p_rec.eff_dt); ---- bug 3462452
4303: -- AND set_of_books_id = enc_sum_lines_p_rec.set_of_books_id;
4304: -- Introduced ELSE portion for bug fix 2908859
4305: ELSE
4306: UPDATE psp_enc_lines
4307: SET enc_summary_line_id = l_enc_summary_line_id
4308: WHERE enc_control_id = enc_control_rec.enc_control_id
4309: AND payroll_id = enc_control_rec.payroll_id
4310: AND time_period_id = enc_control_rec.time_period_id

Line 4412: UPDATE psp_enc_lines

4408: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4410: END IF;
4411:
4412: UPDATE psp_enc_lines
4413: SET enc_summary_line_id = l_enc_summary_line_id
4414: WHERE project_id = enc_sum_lines_g_rec.project_id
4415: AND task_id = enc_sum_lines_g_rec.task_id
4416: AND enc_control_id = enc_control_rec.enc_control_id

Line 5067: FROM psp_enc_lines pel

5063: CURSOR assign_susp_ac_cur(P_ENC_LINE_ID IN NUMBER) IS
5064: SELECT pel.rowid,
5065: pel.encumbrance_date,
5066: pel.suspense_org_account_id
5067: FROM psp_enc_lines pel
5068: WHERE pel.enc_summary_line_id = p_enc_line_id
5069: and pel.enc_control_id=p_enc_control_id;
5070: -- bUg fix 1671938
5071:

Line 5086: psp_enc_lines pel

5082: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
5083: SELECT hou.organization_id, hou.name
5084: FROM hr_all_organization_units hou,
5085: per_assignments_f paf,
5086: psp_enc_lines pel
5087: WHERE pel.enc_summary_line_id = p_line_id
5088: AND pel.assignment_id = paf.assignment_id
5089: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date
5090: AND paf.organization_id = hou.organization_id

Line 5100: psp_enc_lines pel

5096: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
5097: SELECT hou.organization_id, hou.name
5098: FROM hr_all_organization_units hou,
5099: per_assignments_f paf,
5100: psp_enc_lines pel
5101: WHERE
5102: -- pel.enc_summary_line_id = p_line_id
5103: pel.rowid=p_rowid
5104: AND pel.assignment_id = paf.assignment_id

Line 5125: psp_enc_lines pel,

5121: pel.encumbrance_date,
5122: pel.suspense_org_account_id
5123: FROM hr_organization_units hou,
5124: per_assignments_f paf,
5125: psp_enc_lines pel,
5126: WHERE pel.enc_summary_line_id = p_enc_summary_line_id
5127: AND pel.assignment_id = paf.assignment_id
5128: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date
5129: AND pel.business_group_id = g_business_group_id

Line 5339: UPDATE psp_enc_lines

5335: END IF;
5336:
5337: IF l_trx_status_code = 'A' THEN
5338:
5339: UPDATE psp_enc_lines
5340: SET status_code = 'A'
5341: WHERE rowid = l_rowid;
5342:
5343: -- move the transferred records to psp_enc_lines_history

Line 5343: -- move the transferred records to psp_enc_lines_history

5339: UPDATE psp_enc_lines
5340: SET status_code = 'A'
5341: WHERE rowid = l_rowid;
5342:
5343: -- move the transferred records to psp_enc_lines_history
5344: -- Added enc_start_date ,enc_end_date columns for Enh. Enc Redesign Prorata,Bug #2259310
5345: --dbms_output.put_line('moving rec into enc lines hist');
5346: --insert_into_psp_stout( 'moving rec into enc lines hist');
5347: -- Introduced DFF columns for bug fix 2908859

Line 5348: INSERT INTO psp_enc_lines_history

5344: -- Added enc_start_date ,enc_end_date columns for Enh. Enc Redesign Prorata,Bug #2259310
5345: --dbms_output.put_line('moving rec into enc lines hist');
5346: --insert_into_psp_stout( 'moving rec into enc lines hist');
5347: -- Introduced DFF columns for bug fix 2908859
5348: INSERT INTO psp_enc_lines_history
5349: (enc_line_id,business_group_id,enc_element_type_id,encumbrance_date,
5350: dr_cr_flag,encumbrance_amount,status_code,enc_line_type,schedule_line_id,org_schedule_id,
5351: default_org_account_id,suspense_org_account_id,element_account_id,gl_project_flag,
5352: enc_summary_line_id,person_id,assignment_id,award_id,task_id,expenditure_type,

Line 5369: FROM psp_enc_lines

5365: last_updated_by,last_update_login,created_by,creation_date,enc_start_date,enc_end_date,
5366: attribute_category, attribute1, attribute2, attribute3,
5367: attribute4, attribute5, attribute6, attribute7,
5368: attribute8, attribute9, attribute10
5369: FROM psp_enc_lines
5370: WHERE status_code = 'A'
5371: AND enc_summary_line_id = to_number(l_orig_trx_reference)
5372: AND enc_control_id = p_enc_control_id;
5373:

Line 5374: DELETE FROM psp_enc_lines

5370: WHERE status_code = 'A'
5371: AND enc_summary_line_id = to_number(l_orig_trx_reference)
5372: AND enc_control_id = p_enc_control_id;
5373:
5374: DELETE FROM psp_enc_lines
5375: WHERE status_code = 'A'
5376: AND enc_summary_line_id = to_number(l_orig_trx_reference)
5377: AND enc_control_id = p_enc_control_id;
5378:

Line 5412: UPDATE psp_enc_lines

5408: l_suspense_ac_failed := 'Y';
5409:
5410:
5411: / *Commented for Bug 3914807
5412: UPDATE psp_enc_lines
5413: SET suspense_reason_code = 'ES:' || l_trx_reject_code,
5414: status_code = 'N'
5415: WHERE rowid = l_rowid; * /
5416:

Line 5503: UPDATE psp_enc_lines

5499:
5500: END IF;
5501: / * For Bug fix 3194807 * /
5502:
5503: UPDATE psp_enc_lines
5504: SET prev_effective_date = encumbrance_date
5505: WHERE rowid = l_rowid;
5506: / * End of Bug fix 3198407 * /
5507:

Line 5508: UPDATE psp_enc_lines

5504: SET prev_effective_date = encumbrance_date
5505: WHERE rowid = l_rowid;
5506: / * End of Bug fix 3198407 * /
5507:
5508: UPDATE psp_enc_lines
5509: SET suspense_org_account_id = l_organization_account_id,
5510: suspense_reason_code = 'ES:' || l_trx_reject_code,
5511: gl_project_flag = l_gl_project_flag,
5512: -- encumbrance_date = l_encumbrance_date, Commented for Bug 3194807

Line 5554: UPDATE psp_enc_lines

5550:
5551:
5552: / * Added the following for Bug 3194807 * /
5553:
5554: UPDATE psp_enc_lines
5555: SET suspense_org_account_id = NULL,
5556: suspense_reason_code = NULL,
5557: gl_project_flag = decode(gl_code_combination_id,NULL,'P','G'),
5558: encumbrance_date = prev_effective_date

Line 5616: UPDATE psp_enc_lines

5612: -- credit is marked as -ve for posting to Oracle Projects
5613: l_cr_summary_amount := l_cr_summary_amount - l_summary_amount;
5614: END IF;
5615:
5616: UPDATE psp_enc_lines
5617: SET status_code = 'A'
5618: WHERE enc_summary_line_id = l_enc_summary_line_id
5619: AND enc_control_id = p_enc_control_id;
5620:

Line 5623: UPDATE psp_enc_lines

5619: AND enc_control_id = p_enc_control_id;
5620:
5621: / * Introduced this cursor for Bug fix 3194807 * /
5622:
5623: UPDATE psp_enc_lines
5624: SET (gl_code_combination_id,project_id,task_id,award_id,expenditure_organization_id,expenditure_type)
5625: = (select NULL,poa.project_id,poa.task_id,poa.award_id,poa.expenditure_organization_id,poa.expenditure_type
5626: from psp_organization_accounts poa
5627: where poa.organization_account_id = suspense_org_account_id

Line 5636: -- move the transferred records to psp_enc_lines_history

5632:
5633: / * End of code Changes for Bug fix 3194807 * /
5634:
5635:
5636: -- move the transferred records to psp_enc_lines_history
5637: -- Added enc_start_date ,enc_end_date columns for Enh. Enc Redesign Prorata,Bug #2259310
5638: -- Introduced DFF columns for bug fix 2908859
5639: INSERT INTO psp_enc_lines_history
5640: (enc_line_id,business_group_id,enc_element_type_id,encumbrance_date,

Line 5639: INSERT INTO psp_enc_lines_history

5635:
5636: -- move the transferred records to psp_enc_lines_history
5637: -- Added enc_start_date ,enc_end_date columns for Enh. Enc Redesign Prorata,Bug #2259310
5638: -- Introduced DFF columns for bug fix 2908859
5639: INSERT INTO psp_enc_lines_history
5640: (enc_line_id,business_group_id,enc_element_type_id,encumbrance_date,
5641: dr_cr_flag,encumbrance_amount,status_code,enc_line_type,schedule_line_id,org_schedule_id,
5642: default_org_account_id,suspense_org_account_id,element_account_id,gl_project_flag,
5643: enc_summary_line_id,person_id,assignment_id,award_id,task_id,expenditure_type,

Line 5660: FROM psp_enc_lines

5656: last_updated_by,last_update_login,created_by,creation_date,enc_start_date,enc_end_date,
5657: attribute_category, attribute1, attribute2, attribute3,
5658: attribute4, attribute5, attribute6, attribute7,
5659: attribute8, attribute9, attribute10
5660: FROM psp_enc_lines
5661: WHERE status_code = 'A'
5662: AND enc_summary_line_id = l_enc_summary_line_id
5663: AND enc_control_id = p_enc_control_id;
5664:

Line 5665: DELETE FROM psp_enc_lines

5661: WHERE status_code = 'A'
5662: AND enc_summary_line_id = l_enc_summary_line_id
5663: AND enc_control_id = p_enc_control_id;
5664:
5665: DELETE FROM psp_enc_lines
5666: WHERE status_code = 'A'
5667: AND enc_summary_line_id = l_enc_summary_line_id
5668: AND enc_control_id = p_enc_control_id;
5669:

Line 5771: FROM psp_enc_lines pel,

5767: pel.expenditure_type,
5768: pel.suspense_org_account_id,
5769: pesl.interface_status,
5770: ptp.end_date
5771: FROM psp_enc_lines pel,
5772: psp_enc_summary_lines pesl,
5773: per_time_periods ptp
5774: WHERE pel.payroll_action_id = p_payroll_action_id
5775: AND pel.enc_summary_line_id = pesl.enc_summary_line_id

Line 5795: psp_enc_lines pel

5791: CURSOR get_org_id_cur(P_ROWID IN ROWID) IS
5792: SELECT hou.organization_id, hou.name
5793: FROM hr_all_organization_units hou,
5794: per_assignments_f paf,
5795: psp_enc_lines pel
5796: WHERE pel.rowid=p_rowid
5797: AND pel.assignment_id = paf.assignment_id
5798: AND pel.encumbrance_date BETWEEN paf.effective_start_date AND paf.effective_end_date
5799: AND paf.organization_id = hou.organization_id

Line 6047: INSERT INTO psp_enc_lines_history

6043:
6044: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' r_success_recs.enc_summary_line_id.COUNT: ' || r_success_recs.enc_summary_line_id.COUNT);
6045:
6046: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6047: INSERT INTO psp_enc_lines_history
6048: (enc_line_id, business_group_id, enc_element_type_id, encumbrance_date,
6049: dr_cr_flag, encumbrance_amount, status_code, enc_line_type,
6050: schedule_line_id, org_schedule_id, default_org_account_id, suspense_org_account_id,
6051: element_account_id, gl_project_flag, enc_summary_line_id, person_id,

Line 6078: FROM psp_enc_lines

6074: attribute7, attribute8, attribute9, attribute10,
6075: payroll_action_id, hierarchy_code, hierarchy_start_date, hierarchy_end_date,
6076: orig_gl_code_combination_id, orig_project_id, orig_task_id, orig_award_id,
6077: orig_expenditure_org_id, orig_expenditure_type
6078: FROM psp_enc_lines
6079: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);
6080: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history');
6081:
6082: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT

Line 6080: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history');

6076: orig_gl_code_combination_id, orig_project_id, orig_task_id, orig_award_id,
6077: orig_expenditure_org_id, orig_expenditure_type
6078: FROM psp_enc_lines
6079: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);
6080: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history');
6081:
6082: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6083: DELETE FROM psp_enc_lines
6084: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);

Line 6083: DELETE FROM psp_enc_lines

6079: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);
6080: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history');
6081:
6082: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6083: DELETE FROM psp_enc_lines
6084: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);
6085: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines from psp_enc_lines that are summarized and trasnferred to target systems');
6086:
6087: OPEN assign_susp_ac_cur;

Line 6085: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines from psp_enc_lines that are summarized and trasnferred to target systems');

6081:
6082: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6083: DELETE FROM psp_enc_lines
6084: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);
6085: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines from psp_enc_lines that are summarized and trasnferred to target systems');
6086:
6087: OPEN assign_susp_ac_cur;
6088: FETCH assign_susp_ac_cur BULK COLLECT INTO r_suspense_ac.row_id, r_suspense_ac.encumbrance_date,
6089: r_suspense_ac.enc_start_date, r_suspense_ac.enc_end_date, r_suspense_ac.person_id,

Line 6265: UPDATE psp_enc_lines

6261: END IF;
6262: END IF;
6263: END IF;
6264:
6265: UPDATE psp_enc_lines
6266: SET prev_effective_date = encumbrance_date,
6267: prev_enc_end_date = enc_end_date,
6268: prev_encumbrance_amount = encumbrance_amount,
6269: orig_gl_code_combination_id = gl_code_combination_id,

Line 6277: UPDATE psp_enc_lines

6273: orig_expenditure_org_id = expenditure_organization_id,
6274: orig_expenditure_type = expenditure_type
6275: WHERE rowid = r_suspense_ac.row_id(recno);
6276:
6277: UPDATE psp_enc_lines
6278: SET suspense_org_account_id = l_organization_account_id,
6279: gl_code_combination_id = l_susp_glccid,
6280: project_id = l_project_id,
6281: task_id = l_task_id,

Line 6312: UPDATE psp_enc_lines

6308: END IF;
6309: END LOOP;
6310:
6311: IF l_suspense_ac_failed = 'Y' THEN
6312: UPDATE psp_enc_lines
6313: SET suspense_org_account_id = NULL,
6314: gl_code_combination_id = orig_gl_code_combination_id,
6315: project_id = orig_project_id,
6316: task_id = orig_task_id,

Line 6330: UPDATE psp_enc_lines

6326: FROM psp_enc_summary_lines pesl
6327: WHERE pesl.payroll_action_id = p_payroll_action_id
6328: AND pesl.gms_batch_name = p_gms_batch_name
6329: AND status_code = 'R');
6330: UPDATE psp_enc_lines
6331: SET orig_gl_code_combination_id = NULL,
6332: orig_project_id = NULL,
6333: orig_task_id = NULL,
6334: orig_award_id = NULL,

Line 6392: INSERT INTO psp_enc_lines_history

6388: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);
6389: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code to ''A'' in psp_enc_summary_lines');
6390:
6391: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6392: INSERT INTO psp_enc_lines_history
6393: (enc_line_id, business_group_id, enc_element_type_id, encumbrance_date,
6394: dr_cr_flag, encumbrance_amount, status_code, enc_line_type,
6395: schedule_line_id, org_schedule_id, default_org_account_id, suspense_org_account_id,
6396: element_account_id, gl_project_flag, enc_summary_line_id, person_id,

Line 6419: FROM psp_enc_lines

6415: enc_end_date, attribute_category, attribute1, attribute2,
6416: attribute3, attribute4, attribute5, attribute6,
6417: attribute7, attribute8, attribute9, attribute10,
6418: payroll_action_id, hierarchy_code, hierarchy_start_date, hierarchy_end_date
6419: FROM psp_enc_lines
6420: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);
6421: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history');
6422:
6423: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT

Line 6421: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history');

6417: attribute7, attribute8, attribute9, attribute10,
6418: payroll_action_id, hierarchy_code, hierarchy_start_date, hierarchy_end_date
6419: FROM psp_enc_lines
6420: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);
6421: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history');
6422:
6423: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6424: DELETE FROM psp_enc_lines
6425: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);

Line 6424: DELETE FROM psp_enc_lines

6420: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);
6421: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history');
6422:
6423: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6424: DELETE FROM psp_enc_lines
6425: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);
6426: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines from psp_enc_lines that are summarized and trasnferred to target systems');
6427:
6428: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT

Line 6426: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines from psp_enc_lines that are summarized and trasnferred to target systems');

6422:
6423: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6424: DELETE FROM psp_enc_lines
6425: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);
6426: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines from psp_enc_lines that are summarized and trasnferred to target systems');
6427:
6428: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6429: UPDATE psp_enc_controls pec
6430: SET gms_phase = 'TieBack',

Line 6513: FROM PSP_ENC_LINES pel,

6509: DECODE(g_dff_grouping_option, 'Y', pel.attribute8, NULL) attribute8,
6510: DECODE(g_dff_grouping_option, 'Y', pel.attribute9, NULL) attribute9,
6511: DECODE(g_dff_grouping_option, 'Y', pel.attribute10, NULL) attribute10,
6512: pa.org_id
6513: FROM PSP_ENC_LINES pel,
6514: pa_projects_all pa
6515: WHERE pel.ENCUMBRANCE_AMOUNT <> 0
6516: AND pel.payroll_action_id = p_payroll_action_id
6517: AND (g_suspense_failed = 'TRUE' OR pel.suspense_reason_code LIKE 'ES:%')

Line 6640: UPDATE psp_enc_lines pel

6636: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' No of Summary lines created (t_sum_lines.enc_control_id.COUNT): ' || t_sum_lines.enc_control_id.COUNT);
6637:
6638: IF (g_dff_grouping_option = 'Y') THEN
6639: FORALL recno IN 1..t_sum_lines.enc_summary_line_id.COUNT
6640: UPDATE psp_enc_lines pel
6641: SET enc_summary_line_id = t_sum_lines.enc_summary_line_id(recno)
6642: WHERE payroll_action_id = p_payroll_action_id
6643: AND pel.enc_control_id = t_sum_lines.enc_control_id(recno)
6644: AND pel.time_period_id = t_sum_lines.time_period_id(recno)

Line 6668: UPDATE psp_enc_lines pel

6664: AND NVL(pel.attribute9, 'NULL') = NVL(t_sum_lines.attribute9(recno), 'NULL')
6665: AND NVL(pel.attribute10, 'NULL') = NVL(t_sum_lines.attribute10(recno), 'NULL');
6666: ELSE
6667: FORALL recno IN 1..t_sum_lines.enc_summary_line_id.COUNT
6668: UPDATE psp_enc_lines pel
6669: SET enc_summary_line_id = t_sum_lines.enc_summary_line_id(recno)
6670: WHERE payroll_action_id = p_payroll_action_id
6671: AND pel.enc_control_id = t_sum_lines.enc_control_id(recno)
6672: AND pel.time_period_id = t_sum_lines.time_period_id(recno)

Line 6706: FROM psp_enc_lines_history pelh

6702: NVL(expenditure_organization_id, -99),
6703: NVL(expenditure_type, '-99'),
6704: enc_start_date,
6705: enc_end_date
6706: FROM psp_enc_lines_history pelh
6707: WHERE change_flag = 'N'
6708: AND assignment_id = p_assignment_id
6709: AND payroll_id = p_payroll_id
6710: ORDER BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10;

Line 6719: UPDATE psp_enc_lines_history pelh

6715: l_nlines_counter := 0;
6716:
6717: FOR asg_no IN 1..l_asgs.payroll_id.COUNT
6718: LOOP
6719: UPDATE psp_enc_lines_history pelh
6720: SET change_flag = 'N'
6721: WHERE EXISTS (SELECT 1
6722: FROM psp_enc_summary_lines pesl
6723: WHERE pesl.enc_summary_line_id = pelh.enc_summary_line_id

Line 6728: UPDATE psp_enc_lines_history pelh

6724: AND status_code = 'A')
6725: AND assignment_id = l_asgs.assignment_id(asg_no)
6726: AND payroll_id = l_asgs.payroll_id(asg_no);
6727:
6728: UPDATE psp_enc_lines_history pelh
6729: SET hierarchy_code = 'SA'
6730: WHERE change_flag = 'N'
6731: AND hierarchy_code <> 'SA'
6732: AND suspense_org_account_id IS NOT NULL

Line 6816: UPDATE psp_enc_lines_history

6812: END IF;
6813: END LOOP;
6814:
6815: FORALL recno IN 1..t_enc_nlines.element_type_id.COUNT
6816: UPDATE psp_enc_lines_history
6817: SET hierarchy_start_date = t_enc_nlines.enc_start_date(recno),
6818: hierarchy_end_date = t_enc_nlines.enc_end_date(recno)
6819: WHERE assignment_id = t_enc_nlines.assignment_id(recno)
6820: AND payroll_id = t_enc_nlines.payroll_id(recno)