eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMA_PURGE_ENGINE dependencies on USER_USERS

Line 13: p_owner user_users.username%TYPE,

9: p_indexes_tab GMA_PURGE_DDL.g_statement_tab_type,
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;

Line 25: p_owner user_users.username%TYPE,

21:
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,

Line 43: p_owner user_users.username%TYPE,

39:
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,

Line 59: p_owner user_users.username%TYPE,

55: p_debug_flag BOOLEAN);
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,

Line 77: p_owner user_users.username%TYPE,

73: p_totdeleterows IN OUT NOCOPY INTEGER);
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,

Line 96: p_owner user_users.username%TYPE,

92: p_debug_flag BOOLEAN);
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,

Line 107: p_owner user_users.username%TYPE,

103: /* added new TEMP TABLE logic */
104: FUNCTION GLPOSTED_OPSO
105: (P_Purge_id in sy_purg_mst.purge_id%TYPE,
106: p_purge_type sy_purg_def.purge_type%TYPE,
107: p_owner user_users.username%TYPE,
108: p_debug_flag BOOLEAN)
109: RETURN LONG;
110:
111: /* added new TEMP TABLE logic */

Line 115: p_owner user_users.username%TYPE,

111: /* added new TEMP TABLE logic */
112: FUNCTION GLPOSTED_JRNL
113: (P_Purge_id in sy_purg_mst.purge_id%TYPE,
114: p_purge_type sy_purg_def.purge_type%TYPE,
115: p_owner user_users.username%TYPE,
116: p_debug_flag BOOLEAN)
117: RETURN LONG;
118:
119: /* added new TEMP TABLE logic */

Line 123: p_owner user_users.username%TYPE,

119: /* added new TEMP TABLE logic */
120: FUNCTION GLPOSTED_PORD
121: (P_Purge_id in sy_purg_mst.purge_id%TYPE,
122: p_purge_type sy_purg_def.purge_type%TYPE,
123: p_owner user_users.username%TYPE,
124: p_debug_flag BOOLEAN)
125: RETURN LONG;
126:
127: /* added new TEMP TABLE logic */

Line 131: p_owner user_users.username%TYPE,

127: /* added new TEMP TABLE logic */
128: FUNCTION GLPOSTED_PROD
129: (P_Purge_id in sy_purg_mst.purge_id%TYPE,
130: p_purge_type sy_purg_def.purge_type%TYPE,
131: p_owner user_users.username%TYPE,
132: p_debug_flag BOOLEAN)
133: RETURN LONG;
134:
135:

Line 139: p_owner user_users.username%TYPE,

135:
136: -- Create temporary table for PROD and APRD KH
137: FUNCTION Tempcreate(p_purge_id sy_purg_mst.purge_id%TYPE,
138: p_purge_type sy_purg_def.purge_type%TYPE,
139: p_owner user_users.username%TYPE,
140: p_debug_flag BOOLEAN)
141: RETURN CHAR;
142:
143: -- Insert rows in temporary table for PROD and APRD KH

Line 169: p_owner user_users.username%TYPE,

165: /***********************************************************/
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,

Line 374: p_owner user_users.username%TYPE,

370: p_indexes_tab GMA_PURGE_DDL.g_statement_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

Line 421: p_owner user_users.username%TYPE,

417:
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,

Line 466: FROM user_users UU

462: nvl(SP.default_target_tablespace,
463: UU.default_tablespace
464: )
465: ) arctablespace
466: FROM user_users UU
467: , sy_purg_def_act SD
468: , sy_purg_def SP
469: , all_tab_columns UC
470: WHERE UC.owner='GMA'

Line 599: l_owner user_users.username%TYPE;

595: l_debug_flag BOOLEAN;
596: l_disable_constraints BOOLEAN;
597: l_sizing BOOLEAN;
598: l_commitfrequency INTEGER;
599: l_owner user_users.username%TYPE;
600: l_owner_verify user_users.username%TYPE;
601: l_aol_status BOOLEAN;
602:
603: l_status sy_purg_mst.purge_status%TYPE;

Line 600: l_owner_verify user_users.username%TYPE;

596: l_disable_constraints BOOLEAN;
597: l_sizing BOOLEAN;
598: l_commitfrequency INTEGER;
599: l_owner user_users.username%TYPE;
600: l_owner_verify user_users.username%TYPE;
601: l_aol_status BOOLEAN;
602:
603: l_status sy_purg_mst.purge_status%TYPE;
604: l_testarcstatus sy_purg_mst.status%TYPE;

Line 633: -- Made BY KHAJA FROM user_users UU

629: WHERE SD.purge_type (+) = SM.purge_type
630: AND UU.username = 'GMA'
631: AND SM.purge_id = c_purge_id;
632:
633: -- Made BY KHAJA FROM user_users UU
634: CURSOR l_critcursor_cur(c_purge_id sy_purg_mst.purge_id%TYPE) IS
635:
636: SELECT DC.crit_tag crit_tag
637: , REPLACE(NVL(DC.value_mask,'{X}'),

Line 1188: p_owner user_users.username%TYPE,

1184:
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,

Line 1352: p_owner user_users.username%TYPE,

1348: /***********************************************************/
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,

Line 1472: p_owner user_users.username%TYPE,

1468: /***********************************************************/
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:

Line 1524: p_owner user_users.username%TYPE,

1520: END report_exit;
1521:
1522: FUNCTION GLPOSTED_OPSO(P_Purge_id in sy_purg_mst.purge_id%TYPE,
1523: p_purge_type sy_purg_def.purge_type%TYPE,
1524: p_owner user_users.username%TYPE,
1525: p_debug_flag BOOLEAN)
1526: RETURN LONG
1527: is
1528: cursor purge_crit is

Line 1680: p_owner user_users.username%TYPE,

1676: END GLPOSTED_OPSO;
1677:
1678: FUNCTION GLPOSTED_JRNL(P_Purge_id in sy_purg_mst.purge_id%TYPE,
1679: p_purge_type sy_purg_def.purge_type%TYPE,
1680: p_owner user_users.username%TYPE,
1681: p_debug_flag BOOLEAN)
1682: RETURN LONG
1683: is
1684: cursor purge_crit is

Line 1816: p_owner user_users.username%TYPE,

1812:
1813: FUNCTION GLPOSTED_PROD
1814: (P_Purge_id sy_purg_mst.purge_id%TYPE,
1815: p_purge_type sy_purg_def.purge_type%TYPE,
1816: p_owner user_users.username%TYPE,
1817: p_debug_flag BOOLEAN)
1818: RETURN LONG
1819: IS
1820:

Line 2015: p_owner user_users.username%TYPE,

2011: END GLPOSTED_PROD;
2012:
2013: FUNCTION GLPOSTED_PORD(P_Purge_id in sy_purg_mst.purge_id%TYPE,
2014: p_purge_type sy_purg_def.purge_type%TYPE,
2015: p_owner user_users.username%TYPE,
2016: p_debug_flag BOOLEAN)
2017: RETURN LONG
2018:
2019: is

Line 2145: p_owner user_users.username%TYPE,

2141: END GLPOSTED_PORD;
2142:
2143: FUNCTION Tempcreate(p_purge_id sy_purg_mst.purge_id%TYPE,
2144: p_purge_type sy_purg_def.purge_type%TYPE,
2145: p_owner user_users.username%TYPE,
2146: p_debug_flag BOOLEAN) RETURN CHAR
2147: IS
2148:
2149: -- create master rows table for archive