APPS.PA_RESOURCE_MAPPING dependencies on PA_RES_LIST_MAP_TMP3

Line 366: l_insert_clause := 'INSERT INTO pa_res_list_map_tmp3 ( RES_FORMAT_ID, RESOURCE_LIST_MEMBER_ID, RES_LIST_MEM_SEQ, ';

362: --Generate the INSERT clause for the
363: --given format and operation type
364: IF p_operation_type = 'TMP3' THEN
365:
366: l_insert_clause := 'INSERT INTO pa_res_list_map_tmp3 ( RES_FORMAT_ID, RESOURCE_LIST_MEMBER_ID, RES_LIST_MEM_SEQ, ';
367: l_res_tokens := get_format_res_tokens (p_resource_class_id, p_res_format_id);
368:
369: FOR i IN 1..l_res_tokens.COUNT LOOP
370:

Line 581: l_from_clause := ' FROM ' || p_src_table || ' tab1, pa_res_list_map_tmp3 tab2';

577:
578: ELSIF p_operation_type = 'TMP4' THEN
579:
580: --Generate from clause
581: l_from_clause := ' FROM ' || p_src_table || ' tab1, pa_res_list_map_tmp3 tab2';
582:
583: RETURN l_from_clause;
584:
585: END IF;--end operation type

Line 877: pa_res_list_map_tmp3 tmp3,

873: tmp3.NAMED_ROLE,
874: cls.RESOURCE_CLASS_ID,
875: cls.RESOURCE_CLASS_CODE
876: FROM
877: pa_res_list_map_tmp3 tmp3,
878: pa_resource_classes_b cls
879: WHERE
880: RESOURCE_LIST_MEMBER_ID IS NULL AND
881: nvl(tmp3.resource_class_id, l_resource_class_id) = cls.resource_class_id;

Line 1046: --EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || get_pa_schema_name || '.PA_RES_LIST_MAP_TMP3');

1042:
1043:
1044: --
1045: -- Replaced truncate statement with delete for resolving the auto commit issue.
1046: --EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || get_pa_schema_name || '.PA_RES_LIST_MAP_TMP3');
1047: EXECUTE IMMEDIATE ('DELETE FROM PA_RES_LIST_MAP_TMP3'); --bug#16865233
1048: pa_debug.reset_err_stack;
1049:
1050: RETURN 0;

Line 1047: EXECUTE IMMEDIATE ('DELETE FROM PA_RES_LIST_MAP_TMP3'); --bug#16865233

1043:
1044: --
1045: -- Replaced truncate statement with delete for resolving the auto commit issue.
1046: --EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || get_pa_schema_name || '.PA_RES_LIST_MAP_TMP3');
1047: EXECUTE IMMEDIATE ('DELETE FROM PA_RES_LIST_MAP_TMP3'); --bug#16865233
1048: pa_debug.reset_err_stack;
1049:
1050: RETURN 0;
1051:

Line 1180: pa_debug.write('map_for_format: ' || g_module_name,'Before updating pa_res_list_map_tmp3 p_format_id '||p_format_id,1);

1176:
1177: if g_resource_class_flag = 'N' then
1178:
1179: IF P_PA_DEBUG_MODE = 'Y' THEN
1180: pa_debug.write('map_for_format: ' || g_module_name,'Before updating pa_res_list_map_tmp3 p_format_id '||p_format_id,1);
1181: END IF;
1182: begin
1183:
1184: UPDATE pa_res_list_map_tmp3 a

Line 1184: UPDATE pa_res_list_map_tmp3 a

1180: pa_debug.write('map_for_format: ' || g_module_name,'Before updating pa_res_list_map_tmp3 p_format_id '||p_format_id,1);
1181: END IF;
1182: begin
1183:
1184: UPDATE pa_res_list_map_tmp3 a
1185: SET ( a.RESOURCE_CLASS_ID,a.RESOURCE_CLASS_CODE)
1186: = (SELECT c.resource_class_id ,c.resource_class_code
1187: FROM pa_Res_formats_b b,PA_RESOURCE_CLASSES_B c, PA_ACT_PRL_PRECEDENCE d
1188: WHERE b.resource_class_id = c.resource_class_id

Line 1204: pa_debug.write('map_for_format: ' || g_module_name,'After updating pa_res_list_map_tmp3 count '||SQL%ROWCOUNT,1);

1200: AND d1.res_prec_id = g_res_prec_id
1201: and d1.eff_res_format_id = p_format_id
1202: );
1203: IF P_PA_DEBUG_MODE = 'Y' THEN
1204: pa_debug.write('map_for_format: ' || g_module_name,'After updating pa_res_list_map_tmp3 count '||SQL%ROWCOUNT,1);
1205: END IF;
1206:
1207: EXCEPTION
1208: WHEN NO_DATA_FOUND THEN