APPS.PA_RESOURCE_MAPPING dependencies on PA_RES_LIST_MAP_TMP3

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

330: --Generate the INSERT clause for the
331: --given format and operation type
332: IF p_operation_type = 'TMP3' THEN
333:
334: l_insert_clause := 'INSERT INTO pa_res_list_map_tmp3 ( RES_FORMAT_ID, RESOURCE_LIST_MEMBER_ID, RES_LIST_MEM_SEQ, ';
335: l_res_tokens := get_format_res_tokens (p_resource_class_id, p_res_format_id);
336:
337: FOR i IN 1..l_res_tokens.COUNT LOOP
338:

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

513:
514: ELSIF p_operation_type = 'TMP4' THEN
515:
516: --Generate from clause
517: l_from_clause := ' FROM ' || p_src_table || ' tab1, pa_res_list_map_tmp3 tab2';
518:
519: RETURN l_from_clause;
520:
521: END IF;--end operation type

Line 775: pa_res_list_map_tmp3 tmp3,

771: tmp3.NAMED_ROLE,
772: cls.RESOURCE_CLASS_ID,
773: cls.RESOURCE_CLASS_CODE
774: FROM
775: pa_res_list_map_tmp3 tmp3,
776: pa_resource_classes_b cls
777: WHERE
778: RESOURCE_LIST_MEMBER_ID IS NULL AND
779: nvl(tmp3.resource_class_id, l_resource_class_id) = cls.resource_class_id;

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

918: l_SQL_statement := NULL; --reset SQL statement
919:
920: --
921: -- Replaced truncate statement with delete for resolving the auto commit issue.
922: --EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || get_pa_schema_name || '.PA_RES_LIST_MAP_TMP3');
923: EXECUTE IMMEDIATE ('DELETE FROM ' || get_pa_schema_name || '.PA_RES_LIST_MAP_TMP3');
924: pa_debug.reset_err_stack;
925:
926: RETURN 0;

Line 923: EXECUTE IMMEDIATE ('DELETE FROM ' || get_pa_schema_name || '.PA_RES_LIST_MAP_TMP3');

919:
920: --
921: -- Replaced truncate statement with delete for resolving the auto commit issue.
922: --EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || get_pa_schema_name || '.PA_RES_LIST_MAP_TMP3');
923: EXECUTE IMMEDIATE ('DELETE FROM ' || get_pa_schema_name || '.PA_RES_LIST_MAP_TMP3');
924: pa_debug.reset_err_stack;
925:
926: RETURN 0;
927: