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_FP_GEN_FCST_AMT_PUB1 dependencies on PA_RESOURCE_ASGN_CURR_TMP

Line 107: -- This flag tracks if the pa_resource_asgn_curr_tmp global

103:
104: l_res_asg_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
105: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
106:
107: -- This flag tracks if the pa_resource_asgn_curr_tmp global
108: -- temp table has been deleted/cleared yet.
109: l_rbc_tmp_tbl_deleted_flag VARCHAR2(1);
110:
111: -- This flag tracks if calling maintain_data API in Insert

Line 197: -- Logic that deletes the pa_resource_asgn_curr_tmp

193: END IF;
194:
195: -- Initialize l_rbc_tmp_tbl_deleted_flag.
196: -- Intended Usage:
197: -- Logic that deletes the pa_resource_asgn_curr_tmp
198: -- global temp table should set this flag to 'Y' so that
199: -- downstream code knows that the table has been cleared
200: -- by this procedure.
201: l_rbc_tmp_tbl_deleted_flag := 'N';

Line 255: DELETE pa_resource_asgn_curr_tmp;

251:
252: l_maint_data_ins_req_flag := 'Y';
253:
254: IF l_rbc_tmp_tbl_deleted_flag = 'N' THEN
255: DELETE pa_resource_asgn_curr_tmp;
256: l_rbc_tmp_tbl_deleted_flag := 'Y';
257:
258: IF p_pa_debug_mode = 'Y' THEN
259: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

Line 260: ( p_msg => 'Records Deleted from pa_resource_asgn_curr_tmp',

256: l_rbc_tmp_tbl_deleted_flag := 'Y';
257:
258: IF p_pa_debug_mode = 'Y' THEN
259: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
260: ( p_msg => 'Records Deleted from pa_resource_asgn_curr_tmp',
261: --p_called_mode => p_called_mode,
262: p_module_name => l_module_name,
263: p_log_level => l_log_level );
264: END IF;

Line 268: INSERT INTO PA_RESOURCE_ASGN_CURR_TMP

264: END IF;
265: END IF; -- IF l_rbc_tmp_tbl_deleted_flag = 'N' THEN
266:
267: FORALL i IN 1..l_res_asg_id_tab.count
268: INSERT INTO PA_RESOURCE_ASGN_CURR_TMP
269: ( resource_assignment_id,
270: txn_currency_code,
271: txn_raw_cost_rate_override,
272: txn_burden_cost_rate_override,

Line 284: 'PA_RESOURCE_ASGN_CURR_TMP:['||sql%Rowcount||']',

280:
281: IF p_pa_debug_mode = 'Y' THEN
282: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
283: ( p_msg => 'Number of records Inserted into ' ||
284: 'PA_RESOURCE_ASGN_CURR_TMP:['||sql%Rowcount||']',
285: --p_called_mode => p_called_mode,
286: p_module_name => l_module_name,
287: p_log_level => l_log_level );
288: END IF;

Line 342: DELETE pa_resource_asgn_curr_tmp;

338:
339: l_maint_data_ins_req_flag := 'Y';
340:
341: IF l_rbc_tmp_tbl_deleted_flag = 'N' THEN
342: DELETE pa_resource_asgn_curr_tmp;
343: l_rbc_tmp_tbl_deleted_flag := 'Y';
344:
345: IF p_pa_debug_mode = 'Y' THEN
346: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

Line 347: ( p_msg => 'Records Deleted from pa_resource_asgn_curr_tmp',

343: l_rbc_tmp_tbl_deleted_flag := 'Y';
344:
345: IF p_pa_debug_mode = 'Y' THEN
346: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
347: ( p_msg => 'Records Deleted from pa_resource_asgn_curr_tmp',
348: --p_called_mode => p_called_mode,
349: p_module_name => l_module_name,
350: p_log_level => l_log_level );
351: END IF;

Line 357: -- begin inserted into pa_resource_asgn_curr_tmp.

353:
354: -- Because the planning txns involved in Update Case 1
355: -- and Update Case 2 are mutually exclusive, no extra
356: -- logic needs to be added to avoid duplicate records
357: -- begin inserted into pa_resource_asgn_curr_tmp.
358: --
359: -- In the future, if additional Update Cases with
360: -- overlapping txns are added, then a precedence of
361: -- updates will need to be determined with corresponding

Line 366: INSERT INTO PA_RESOURCE_ASGN_CURR_TMP

362: -- updates to the global temporary table.
363:
364: -- Note: all rate overrides are implicitly set to Null.
365: FORALL i IN 1..l_res_asg_id_tab.count
366: INSERT INTO PA_RESOURCE_ASGN_CURR_TMP
367: ( resource_assignment_id,
368: txn_currency_code )
369: VALUES
370: ( l_res_asg_id_tab(i),

Line 376: 'PA_RESOURCE_ASGN_CURR_TMP:['||sql%Rowcount||']',

372:
373: IF p_pa_debug_mode = 'Y' THEN
374: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
375: ( p_msg => 'Number of records Inserted into ' ||
376: 'PA_RESOURCE_ASGN_CURR_TMP:['||sql%Rowcount||']',
377: --p_called_mode => p_called_mode,
378: p_module_name => l_module_name,
379: p_log_level => l_log_level );
380: END IF;

Line 3703: DELETE pa_resource_asgn_curr_tmp;

3699: -- the populate_display_qty() and maintain_data() API calls.
3700:
3701: -- Populate the display quantity for non-manually added resources.
3702:
3703: DELETE pa_resource_asgn_curr_tmp;
3704:
3705: INSERT INTO pa_resource_asgn_curr_tmp
3706: ( resource_assignment_id )
3707: SELECT ra.resource_assignment_id

Line 3705: INSERT INTO pa_resource_asgn_curr_tmp

3701: -- Populate the display quantity for non-manually added resources.
3702:
3703: DELETE pa_resource_asgn_curr_tmp;
3704:
3705: INSERT INTO pa_resource_asgn_curr_tmp
3706: ( resource_assignment_id )
3707: SELECT ra.resource_assignment_id
3708: FROM pa_resource_assignments ra
3709: WHERE ra.budget_version_id = p_budget_version_id

Line 3738: DELETE pa_resource_asgn_curr_tmp;

3734:
3735: -- Call MAINTAIN_DATA to roll up amounts to pa_resource_asgn_curr
3736: -- for non-manually added resources. First, populate temp table data.
3737:
3738: DELETE pa_resource_asgn_curr_tmp;
3739:
3740: INSERT INTO pa_resource_asgn_curr_tmp
3741: ( resource_assignment_id,
3742: txn_currency_code,

Line 3740: INSERT INTO pa_resource_asgn_curr_tmp

3736: -- for non-manually added resources. First, populate temp table data.
3737:
3738: DELETE pa_resource_asgn_curr_tmp;
3739:
3740: INSERT INTO pa_resource_asgn_curr_tmp
3741: ( resource_assignment_id,
3742: txn_currency_code,
3743: txn_raw_cost_rate_override,
3744: txn_burden_cost_rate_override,