APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_RBS_PLANS_OUT_TMP

Line 219: DELETE FROM pa_rbs_plans_out_tmp;

215: l_stage := 'Start of populate_rbsmap_tmp';
216: print_msg(g_debug_flag,l_stage);
217: /* Initialize the IN and OUT tmp tables */
218: DELETE FROM pa_rbs_plans_in_tmp ;
219: DELETE FROM pa_rbs_plans_out_tmp;
220: If p_calling_mode = 'BUDGET_VERSION' Then
221: l_stage := 'Inserting recrods into pa_rbs_plans_in_tmp for the budget version';
222: print_msg(g_debug_flag,l_stage);
223: INSERT INTO pa_rbs_plans_in_tmp

Line 1291: FROM pa_rbs_plans_out_tmp rsmap;

1287: ,null
1288: ,null
1289: ,null
1290: ,null
1291: FROM pa_rbs_plans_out_tmp rsmap;
1292:
1293: CURSOR cur_resrbsmapRejections IS
1294: SELECT resmap.txn_source_id
1295: ,resmap.resource_list_member_id

Line 1307: ,pa_rbs_plans_out_tmp rbsmap

1303: ,rbsmap.rbs_element_id
1304: ,rbsmap.txn_accum_header_id
1305: ,null -- rbsmap.rbs_map_rejection_code
1306: FROM pa_res_list_map_tmp4 resmap
1307: ,pa_rbs_plans_out_tmp rbsmap
1308: WHERE resmap.txn_source_id = rbsmap.source_id ;
1309:
1310: l_stage varchar2(1000);
1311:

Line 1362: from pa_rbs_plans_out_tmp;

1358: Elsif p_process_code = 'RBS_MAP' Then
1359: If NVL(g_debug_flag,'N') = 'Y' Then /* Bug No. 4419245 */
1360: select count(*)
1361: into l_count
1362: from pa_rbs_plans_out_tmp;
1363: print_msg(g_debug_flag,'For Debug purpose counting Number of records from mapping temp table is ['||l_count||']');
1364: /* just for debug purpose priting the values of all the reocrds*/
1365: FOR i IN ( select * from pa_rbs_plans_out_tmp ) LOOP
1366: print_msg(g_debug_flag,'Value from rbs outtmp SourceId['||i.source_id||']RbsEleId['||i.rbs_element_id||']TxnAccum['||i.txn_accum_header_id||']');

Line 1365: FOR i IN ( select * from pa_rbs_plans_out_tmp ) LOOP

1361: into l_count
1362: from pa_rbs_plans_out_tmp;
1363: print_msg(g_debug_flag,'For Debug purpose counting Number of records from mapping temp table is ['||l_count||']');
1364: /* just for debug purpose priting the values of all the reocrds*/
1365: FOR i IN ( select * from pa_rbs_plans_out_tmp ) LOOP
1366: print_msg(g_debug_flag,'Value from rbs outtmp SourceId['||i.source_id||']RbsEleId['||i.rbs_element_id||']TxnAccum['||i.txn_accum_header_id||']');
1367: END LOOP;
1368: End if; /* Bug No. 4419245 */
1369: l_stage := 'Opening RBS map rejections cursor';

Line 1396: from pa_rbs_plans_out_tmp;

1392: from pa_res_list_map_tmp4;
1393: print_msg(g_debug_flag,'For Debug purpose counting Number of records from RESmapping temp table is ['||l_count||']');
1394: select count(*)
1395: into l_count
1396: from pa_rbs_plans_out_tmp;
1397: print_msg(g_debug_flag,'For Debug purpose counting Number of records from RBSmapping temp table is ['||l_count||']');
1398: End if; /* Bug No. 4419245 */
1399: l_stage := 'Opening ResRBS map rejections cursor';
1400: print_msg(g_debug_flag,l_stage);