10: p_indexcount INTEGER,
11: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,
12: p_idx_tablespaces_count IN OUT NOCOPY INTEGER,
13: p_owner user_users.username%TYPE,
14: p_appl_short_name fnd_application.application_short_name%TYPE,
15: p_disable_constraints BOOLEAN,
16: p_debug_flag BOOLEAN)
17: RETURN BOOLEAN;
18:
22: FUNCTION initarchive
23: (p_purge_id sy_purg_mst.purge_id%TYPE,
24: p_purge_type sy_purg_def.purge_type%TYPE,
25: p_owner user_users.username%TYPE,
26: p_appl_short_name fnd_application.application_short_name%TYPE,
27: p_arctablename user_tables.table_name%TYPE,
28: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_type,
29: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,
30: p_tablecount IN OUT NOCOPY INTEGER,
40: PROCEDURE doarchive
41: (p_purge_id sy_purg_mst.purge_id%TYPE,
42: p_purge_type sy_purg_def.purge_type%TYPE,
43: p_owner user_users.username%TYPE,
44: p_appl_short_name fnd_application.application_short_name%TYPE,
45: p_user NUMBER,
46: p_arcrowtable user_tables.table_name%TYPE,
47: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_type,
48: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,
56:
57: PROCEDURE getrows
58: (p_purge_id sy_purg_mst.purge_id%TYPE,
59: p_owner user_users.username%TYPE,
60: p_appl_short_name fnd_application.application_short_name%TYPE,
61: p_sqlstatement sy_purg_def.sqlstatement%TYPE,
62: p_tablespace user_tablespaces.tablespace_name%TYPE,
63: p_arcrowtable user_tables.table_name%TYPE,
64: p_debug_flag BOOLEAN);
74:
75: PROCEDURE archive(p_purge_id sy_purg_mst.purge_id%TYPE,
76: p_purge_type sy_purg_def.purge_type%TYPE,
77: p_owner user_users.username%TYPE,
78: p_appl_short_name fnd_application.application_short_name%TYPE,
79: p_user NUMBER,
80: p_sqlstatement sy_purg_def.sqlstatement%TYPE,
81: p_arcrowbasename user_tables.table_name%TYPE,
82: p_arctablespace user_tablespaces.tablespace_name%TYPE,
93:
94: PROCEDURE purge(p_purge_id sy_purg_mst.purge_id%TYPE,
95: p_purge_type sy_purg_def.purge_type%TYPE,
96: p_owner user_users.username%TYPE,
97: p_appl_short_name fnd_application.application_short_name%TYPE,
98: p_debug_flag BOOLEAN);
99:
100: /* These four GLPOSTED functions is added to check for unposted transactions in purge types,
101: The main purpose of this is not to delete any transaction which have unposted rows in it. */
166:
167: PROCEDURE doarchive(p_purge_id sy_purg_mst.purge_id%TYPE,
168: p_purge_type sy_purg_def.purge_type%TYPE,
169: p_owner user_users.username%TYPE,
170: p_appl_short_name fnd_application.application_short_name%TYPE,
171: p_user NUMBER,
172: p_arcrowtable user_tables.table_name%TYPE,
173: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_type,
174: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,
371: p_indexcount INTEGER,
372: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,
373: p_idx_tablespaces_count IN OUT NOCOPY INTEGER,
374: p_owner user_users.username%TYPE,
375: p_appl_short_name fnd_application.application_short_name%TYPE,
376: p_disable_constraints BOOLEAN,
377: p_debug_flag BOOLEAN)
378: RETURN BOOLEAN IS
379: BEGIN
418: FUNCTION initarchive
419: (p_purge_id sy_purg_mst.purge_id%TYPE,
420: p_purge_type sy_purg_def.purge_type%TYPE,
421: p_owner user_users.username%TYPE,
422: p_appl_short_name fnd_application.application_short_name%TYPE,
423: p_arctablename user_tables.table_name%TYPE,
424: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_type,
425: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,
426: p_tablecount IN OUT NOCOPY INTEGER,
579:
580: PROCEDURE main(errbuf OUT NOCOPY VARCHAR2,
581: retcode OUT NOCOPY VARCHAR2,
582: p_purge_id IN sy_purg_mst.purge_id%TYPE,
583: p_appl_short_name IN fnd_application.application_short_name%TYPE,
584: p_job_run IN NUMBER,
585: p_job_name IN VARCHAR2) IS
586:
587:
1185: /***********************************************************/
1186:
1187: PROCEDURE getrows(p_purge_id sy_purg_mst.purge_id%TYPE,
1188: p_owner user_users.username%TYPE,
1189: p_appl_short_name fnd_application.application_short_name%TYPE,
1190: p_sqlstatement sy_purg_def.sqlstatement%TYPE,
1191: p_tablespace user_tablespaces.tablespace_name%TYPE,
1192: p_arcrowtable user_tables.table_name%TYPE,
1193: p_debug_flag BOOLEAN) IS
1349:
1350: PROCEDURE archive(p_purge_id sy_purg_mst.purge_id%TYPE,
1351: p_purge_type sy_purg_def.purge_type%TYPE,
1352: p_owner user_users.username%TYPE,
1353: p_appl_short_name fnd_application.application_short_name%TYPE,
1354: p_user NUMBER,
1355: p_sqlstatement sy_purg_def.sqlstatement%TYPE,
1356: p_arcrowbasename user_tables.table_name%TYPE,
1357: p_arctablespace user_tablespaces.tablespace_name%TYPE,
1469:
1470: PROCEDURE purge(p_purge_id sy_purg_mst.purge_id%TYPE,
1471: p_purge_type sy_purg_def.purge_type%TYPE,
1472: p_owner user_users.username%TYPE,
1473: p_appl_short_name fnd_application.application_short_name%TYPE,
1474: p_debug_flag BOOLEAN) IS
1475: -- drop archive tables, reset views
1476:
1477: CURSOR l_viewtables_cur(c_purge_type sy_purg_mst.purge_type%TYPE) IS