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.PA_PROGRESS_PVT dependencies on PA_PROG_ACT_BY_PERIOD_TEMP

Line 9843: DELETE FROM PA_PROG_ACT_BY_PERIOD_TEMP;

9839: l_res_list_mismatch_flag := 'N';
9840: END IF;
9841:
9842: -- Delete any existing records from the table first
9843: DELETE FROM PA_PROG_ACT_BY_PERIOD_TEMP;
9844:
9845: -- Populate the PA_PROG_ACT_BY_PERIOD_TEMP table from pa_budget_lines init columns data
9846: -- Using task_id and resource list member id fetch mapping target resource assignment id
9847:

Line 9845: -- Populate the PA_PROG_ACT_BY_PERIOD_TEMP table from pa_budget_lines init columns data

9841:
9842: -- Delete any existing records from the table first
9843: DELETE FROM PA_PROG_ACT_BY_PERIOD_TEMP;
9844:
9845: -- Populate the PA_PROG_ACT_BY_PERIOD_TEMP table from pa_budget_lines init columns data
9846: -- Using task_id and resource list member id fetch mapping target resource assignment id
9847:
9848: /* Begin code to fix Bug # 4144300. */
9849:

Line 9878: -- Bulk insert the PL/SQL tables into the table: PA_PROG_ACT_BY_PERIOD_TEMP.

9874: I_END_DATE(l_index) := cur_ppabpt_rec.end_date;
9875:
9876: end loop;
9877:
9878: -- Bulk insert the PL/SQL tables into the table: PA_PROG_ACT_BY_PERIOD_TEMP.
9879:
9880: forall i in 1..l_index
9881:
9882: INSERT INTO PA_PROG_ACT_BY_PERIOD_TEMP

Line 9882: INSERT INTO PA_PROG_ACT_BY_PERIOD_TEMP

9878: -- Bulk insert the PL/SQL tables into the table: PA_PROG_ACT_BY_PERIOD_TEMP.
9879:
9880: forall i in 1..l_index
9881:
9882: INSERT INTO PA_PROG_ACT_BY_PERIOD_TEMP
9883: (
9884: PROJECT_ID
9885: ,STRUCTURE_VERSION_ID
9886: ,TASK_ID

Line 9947: INSERT INTO PA_PROG_ACT_BY_PERIOD_TEMP

9943: /* End code to fix Bug # 4144300. */
9944:
9945: /* Begin commenting out the following code to fix Bug # 4144300.
9946:
9947: INSERT INTO PA_PROG_ACT_BY_PERIOD_TEMP
9948: (
9949: PROJECT_ID
9950: ,STRUCTURE_VERSION_ID
9951: ,TASK_ID

Line 10028: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.copy_actuals_for_workplan', x_Msg => 'No of records inserted into PA_PROG_ACT_BY_PERIOD_TEMP '||l_no_of_recs_for_processing, x_Log_Level=> 3);

10024:
10025: l_no_of_recs_for_processing := SQL%ROWCOUNT;
10026:
10027: IF l_debug_mode = 'Y' THEN
10028: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.copy_actuals_for_workplan', x_Msg => 'No of records inserted into PA_PROG_ACT_BY_PERIOD_TEMP '||l_no_of_recs_for_processing, x_Log_Level=> 3);
10029: END IF;
10030:
10031: --Bug 3953743. If No records are inserted into the tmp table then the API need not be called at all.
10032: IF l_no_of_recs_for_processing > 0 THEN