APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_RES_LIST_MAP_TMP4

Line 731: DELETE FROM pa_res_list_map_tmp4;

727: l_stage := 'Start of populate_resmap_tmp ';
728: print_msg(g_debug_flag,l_stage);
729: /* Initialize the IN and OUT tmp tables */
730: DELETE FROM pa_res_list_map_tmp1;
731: DELETE FROM pa_res_list_map_tmp4;
732:
733:
734: IF p_budget_version_id is NOT NULL Then
735: print_msg(g_debug_flag, 'Getting project structure version Id for ResMap');

Line 772: INSERT INTO pa_res_list_map_tmp4

768: l_stage := 'Inserting recrods into pa_res_list_map_tmp1 for the given budget version';
769: print_msg(g_debug_flag,l_stage);
770: IF l_uncategorized_flag = 'Y' THEN
771:
772: INSERT INTO pa_res_list_map_tmp4
773: (TXN_SOURCE_ID
774: ,TXN_SOURCE_TYPE_CODE
775: ,PERSON_ID
776: ,JOB_ID

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

964: /* Insert these plsql tables into ResMap Temp Tables*/
965: If g_TXN_SOURCE_ID_sqltab.COUNT > 0 Then
966:
967: IF l_uncategorized_flag = 'Y' THEN
968: l_stage := 'Inserting records into pa_res_list_map_tmp4 from PLSQL tables';
969: print_msg(g_debug_flag,l_stage);
970: FORALL i IN g_TXN_SOURCE_ID_sqltab.FIRST .. g_TXN_SOURCE_ID_sqltab.LAST
971: INSERT INTO pa_res_list_map_tmp4
972: (TXN_SOURCE_ID

Line 971: INSERT INTO pa_res_list_map_tmp4

967: IF l_uncategorized_flag = 'Y' THEN
968: l_stage := 'Inserting records into pa_res_list_map_tmp4 from PLSQL tables';
969: print_msg(g_debug_flag,l_stage);
970: FORALL i IN g_TXN_SOURCE_ID_sqltab.FIRST .. g_TXN_SOURCE_ID_sqltab.LAST
971: INSERT INTO pa_res_list_map_tmp4
972: (TXN_SOURCE_ID
973: ,TXN_SOURCE_TYPE_CODE
974: ,PERSON_ID
975: ,JOB_ID

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

1164: /* Insert these system.tab into ResMap Temp Tables*/
1165: If g_TXN_SOURCE_ID_systab.COUNT > 0 Then
1166: IF l_uncategorized_flag = 'Y' THEN
1167:
1168: l_stage := 'Inserting records into pa_res_list_map_tmp4 from SYSTEM tables';
1169: print_msg(g_debug_flag,l_stage);
1170: FORALL i IN g_TXN_SOURCE_ID_systab.FIRST .. g_TXN_SOURCE_ID_systab.LAST
1171: INSERT INTO pa_res_list_map_tmp4
1172: (TXN_SOURCE_ID

Line 1171: INSERT INTO pa_res_list_map_tmp4

1167:
1168: l_stage := 'Inserting records into pa_res_list_map_tmp4 from SYSTEM tables';
1169: print_msg(g_debug_flag,l_stage);
1170: FORALL i IN g_TXN_SOURCE_ID_systab.FIRST .. g_TXN_SOURCE_ID_systab.LAST
1171: INSERT INTO pa_res_list_map_tmp4
1172: (TXN_SOURCE_ID
1173: ,TXN_SOURCE_TYPE_CODE
1174: ,PERSON_ID
1175: ,JOB_ID

Line 1489: FROM pa_res_list_map_tmp4 rsmap;

1485: ,null
1486: ,null
1487: ,null
1488: ,null
1489: FROM pa_res_list_map_tmp4 rsmap;
1490:
1491: CURSOR cur_rbsmapRejections IS
1492: SELECT rsmap.source_id
1493: ,rsmap.rbs_element_id

Line 1519: FROM pa_res_list_map_tmp4 resmap

1515: ,null -- rbsmap.rbs_map_rejection_code
1516: ,rbsmap.rbs_element_id
1517: ,rbsmap.txn_accum_header_id
1518: ,null -- rbsmap.rbs_map_rejection_code
1519: FROM pa_res_list_map_tmp4 resmap
1520: ,pa_rbs_plans_out_tmp rbsmap
1521: WHERE resmap.txn_source_id = rbsmap.source_id ;
1522:
1523: l_stage varchar2(1000);

Line 1549: from pa_res_list_map_tmp4;

1545: If p_process_code = 'RES_MAP' Then
1546: If NVL(g_debug_flag,'N') = 'Y' Then /* Bug No. 4419245 */
1547: select count(*)
1548: into l_count
1549: from pa_res_list_map_tmp4;
1550: print_msg(g_debug_flag,'For Debug purpose counting Number of records from mapping temp table is ['||l_count||']');
1551: end if; /* Bug No. 4419245 */
1552: l_stage := 'Opening Resource Mapping rejection cursor';
1553: print_msg(g_debug_flag,l_stage);

Line 1605: from pa_res_list_map_tmp4;

1601: Elsif p_process_code = 'RES_RBS_MAP' Then
1602: If NVL(g_debug_flag,'N') = 'Y' Then /* Bug No. 4419245 */
1603: select count(*)
1604: into l_count
1605: from pa_res_list_map_tmp4;
1606: print_msg(g_debug_flag,'For Debug purpose counting Number of records from RESmapping temp table is ['||l_count||']');
1607: select count(*)
1608: into l_count
1609: from pa_rbs_plans_out_tmp;