DBA Data[Home] [Help]

APPS.GMA_PURGE_COPY dependencies on USER_TABLES

Line 10: p_arcrowtablename user_tables.table_name%TYPE,

6: FUNCTION archiveengine(p_purge_id sy_purg_mst.purge_id%TYPE,
7: p_owner user_users.username%TYPE,
8: p_appl_short_name fnd_application.application_short_name%TYPE,
9: p_user NUMBER,
10: p_arcrowtablename user_tables.table_name%TYPE,
11: p_tablecount INTEGER,
12: p_tablename_tab GMA_PURGE_DDL.g_tablename_tab_type,
13: p_tableaction_tab GMA_PURGE_DDL.g_tableaction_tab_type,
14: p_debug_flag BOOLEAN,

Line 19: l_arctablename user_tables.table_name%TYPE;

15: p_commitfrequency INTEGER)
16: RETURN BOOLEAN IS
17: -- This FUNCTION logs, copies, deletes, commits. You name it.
18:
19: l_arctablename user_tables.table_name%TYPE;
20: -- name of current archive targe table
21: l_detailcursor INTEGER; -- cursor for detail row statement
22:
23: l_detailrowid ROWID; -- current detail row rowid

Line 27: l_sourcetable user_tables.table_name%TYPE;

23: l_detailrowid ROWID; -- current detail row rowid
24:
25: l_return INTEGER; -- holds number of rows returned
26:
27: l_sourcetable user_tables.table_name%TYPE;
28:
29: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
30:
31: l_transcount PLS_INTEGER; -- transaction commit counter