APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_RES_LIST_MAP_TMP4

Line 540: DELETE FROM pa_res_list_map_tmp4;

536: l_stage := 'Start of populate_resmap_tmp ';
537: print_msg(g_debug_flag,l_stage);
538: /* Initialize the IN and OUT tmp tables */
539: DELETE FROM pa_res_list_map_tmp1;
540: DELETE FROM pa_res_list_map_tmp4;
541:
542:
543: IF p_budget_version_id is NOT NULL Then
544: print_msg(g_debug_flag, 'Getting project structure version Id for ResMap');

Line 581: INSERT INTO pa_res_list_map_tmp4

577: l_stage := 'Inserting recrods into pa_res_list_map_tmp1 for the given budget version';
578: print_msg(g_debug_flag,l_stage);
579: IF l_uncategorized_flag = 'Y' THEN
580:
581: INSERT INTO pa_res_list_map_tmp4
582: (TXN_SOURCE_ID
583: ,TXN_SOURCE_TYPE_CODE
584: ,PERSON_ID
585: ,JOB_ID

Line 771: l_stage := 'Inserting records into pa_res_list_map_tmp4 from PLSQL tables';

767: /* Insert these plsql tables into ResMap Temp Tables*/
768: If g_TXN_SOURCE_ID_sqltab.COUNT > 0 Then
769:
770: IF l_uncategorized_flag = 'Y' THEN
771: l_stage := 'Inserting records into pa_res_list_map_tmp4 from PLSQL tables';
772: print_msg(g_debug_flag,l_stage);
773: FORALL i IN g_TXN_SOURCE_ID_sqltab.FIRST .. g_TXN_SOURCE_ID_sqltab.LAST
774: INSERT INTO pa_res_list_map_tmp4
775: (TXN_SOURCE_ID

Line 774: INSERT INTO pa_res_list_map_tmp4

770: IF l_uncategorized_flag = 'Y' THEN
771: l_stage := 'Inserting records into pa_res_list_map_tmp4 from PLSQL tables';
772: print_msg(g_debug_flag,l_stage);
773: FORALL i IN g_TXN_SOURCE_ID_sqltab.FIRST .. g_TXN_SOURCE_ID_sqltab.LAST
774: INSERT INTO pa_res_list_map_tmp4
775: (TXN_SOURCE_ID
776: ,TXN_SOURCE_TYPE_CODE
777: ,PERSON_ID
778: ,JOB_ID

Line 962: l_stage := 'Inserting records into pa_res_list_map_tmp4 from SYSTEM tables';

958: /* Insert these system.tab into ResMap Temp Tables*/
959: If g_TXN_SOURCE_ID_systab.COUNT > 0 Then
960: IF l_uncategorized_flag = 'Y' THEN
961:
962: l_stage := 'Inserting records into pa_res_list_map_tmp4 from SYSTEM tables';
963: print_msg(g_debug_flag,l_stage);
964: FORALL i IN g_TXN_SOURCE_ID_systab.FIRST .. g_TXN_SOURCE_ID_systab.LAST
965: INSERT INTO pa_res_list_map_tmp4
966: (TXN_SOURCE_ID

Line 965: INSERT INTO pa_res_list_map_tmp4

961:
962: l_stage := 'Inserting records into pa_res_list_map_tmp4 from SYSTEM tables';
963: print_msg(g_debug_flag,l_stage);
964: FORALL i IN g_TXN_SOURCE_ID_systab.FIRST .. g_TXN_SOURCE_ID_systab.LAST
965: INSERT INTO pa_res_list_map_tmp4
966: (TXN_SOURCE_ID
967: ,TXN_SOURCE_TYPE_CODE
968: ,PERSON_ID
969: ,JOB_ID

Line 1276: FROM pa_res_list_map_tmp4 rsmap;

1272: ,null
1273: ,null
1274: ,null
1275: ,null
1276: FROM pa_res_list_map_tmp4 rsmap;
1277:
1278: CURSOR cur_rbsmapRejections IS
1279: SELECT rsmap.source_id
1280: ,rsmap.rbs_element_id

Line 1306: FROM pa_res_list_map_tmp4 resmap

1302: ,null -- rbsmap.rbs_map_rejection_code
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);

Line 1336: from pa_res_list_map_tmp4;

1332: If p_process_code = 'RES_MAP' Then
1333: If NVL(g_debug_flag,'N') = 'Y' Then /* Bug No. 4419245 */
1334: select count(*)
1335: into l_count
1336: from pa_res_list_map_tmp4;
1337: print_msg(g_debug_flag,'For Debug purpose counting Number of records from mapping temp table is ['||l_count||']');
1338: end if; /* Bug No. 4419245 */
1339: l_stage := 'Opening Resource Mapping rejection cursor';
1340: print_msg(g_debug_flag,l_stage);

Line 1392: from pa_res_list_map_tmp4;

1388: Elsif p_process_code = 'RES_RBS_MAP' Then
1389: If NVL(g_debug_flag,'N') = 'Y' Then /* Bug No. 4419245 */
1390: select count(*)
1391: into l_count
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;