[Home] [Help]
1353: END ;
1354:
1355: -- end of select valid projects
1356: --Bug 5635857. Select the pending commitments for eligible projects and insert them
1357: --into the temoporary table pa_commitment_txns_tmp so that they can be used later
1358: -- in the code
1359: --Note that if the below condition is changed then the code for updating the commitments
1360: --should also be changed in the FOR loop
1361:
3630: RAISE;
3631: END Get_curr_end_date;
3632:
3633: /*
3634: --Bug 5635857. This procedure will populate pa_commitment_txns_tmp table from
3635: --pa_commitment_txns_v. This table will later be used in processing
3636: --Dynamic Insert statement is used since otherwise its not possible to get and insert
3637: --the data from pa_commitment_txns_v for all the projects in one go.
3638: PROCEDURE populate_cmt_tmp_table
3652: l_current_pa_period_flag Varchar2(1);
3653:
3654: BEGIN
3655:
3656: DELETE FROM pa_commitment_txns_tmp;
3657:
3658: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);
3659: x_last_update_date := NVL(FND_GLOBAL.USER_ID,-1);
3660: x_created_by := NVL(FND_GLOBAL.USER_ID,-1);
3669: FOR i IN 1..p_project_id_tbl.COUNT LOOP
3670:
3671: IF l_sql IS NULL THEN
3672:
3673: l_sql:='INSERT INTO pa_commitment_txns_tmp ' ||
3674: '( PROJECT_ID, '||
3675: 'TASK_ID, '||
3676: 'TRANSACTION_SOURCE, '||
3677: 'LINE_TYPE, '||
3892: l_client_extn_mode VARCHAR2(1); --14090312
3893:
3894: BEGIN
3895:
3896: DELETE FROM pa_commitment_txns_tmp;
3897: DELETE FROM pa_pjm_po_commitments_tmp; /* Bug 6408874 */
3898: DELETE FROM pa_pjm_req_commitments_tmp; /* Bug 6408874 */
3899: DELETE FROM pa_proj_summ_tmp; -- BUG 10107257 Addition of DELETE
3900: -- DELETE FROM pa_fp_ra_map_tmp;
4142: /* Bug 6408874 */
4143:
4144: /* forall i in 1..TmpProjectTab.count BUG 10107257 */
4145:
4146: INSERT INTO pa_commitment_txns_tmp
4147: (PROJECT_ID,
4148: TASK_ID,
4149: TRANSACTION_SOURCE,
4150: LINE_TYPE,