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 SY_PURG_DEF

Line 24: p_purge_type sy_purg_def.purge_type%TYPE,

20: p_status INTEGER);
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,

Line 42: p_purge_type sy_purg_def.purge_type%TYPE,

38: RETURN BOOLEAN;
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,

Line 61: p_sqlstatement sy_purg_def.sqlstatement%TYPE,

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);
65:

Line 76: p_purge_type sy_purg_def.purge_type%TYPE,

72: p_totarchiverows IN OUT NOCOPY INTEGER,
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,

Line 80: p_sqlstatement sy_purg_def.sqlstatement%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,
83: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_type,
84: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,

Line 95: p_purge_type sy_purg_def.purge_type%TYPE,

91: p_disable_constraints BOOLEAN,
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:

Line 106: p_purge_type sy_purg_def.purge_type%TYPE,

102:
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:

Line 114: p_purge_type sy_purg_def.purge_type%TYPE,

110:
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:

Line 122: p_purge_type sy_purg_def.purge_type%TYPE,

118:
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:

Line 130: p_purge_type sy_purg_def.purge_type%TYPE,

126:
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:

Line 138: p_purge_type sy_purg_def.purge_type%TYPE,

134:
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:

Line 145: p_purge_type sy_purg_def.purge_type%TYPE,

141: RETURN CHAR;
142:
143: -- Insert rows in temporary table for PROD and APRD KH
144: PROCEDURE Tempinsert(p_purge_id sy_purg_mst.purge_id%TYPE,
145: p_purge_type sy_purg_def.purge_type%TYPE,
146: p_all_ids number,
147: p_debug_flag BOOLEAN);
148:
149: -- Drop the temporary table for PROD and APRD KH

Line 151: p_purge_type sy_purg_def.purge_type%TYPE,

147: p_debug_flag BOOLEAN);
148:
149: -- Drop the temporary table for PROD and APRD KH
150: PROCEDURE Tempdrop(p_purge_id sy_purg_mst.purge_id%TYPE,
151: p_purge_type sy_purg_def.purge_type%TYPE,
152: p_debug_flag BOOLEAN);
153:
154: -- Drop the temporary table for PROD and APRD KH
155: PROCEDURE ResetTestPurge(p_purge_id sy_purg_mst.purge_id%TYPE,

Line 156: p_purge_type sy_purg_def.purge_type%TYPE,

152: p_debug_flag BOOLEAN);
153:
154: -- Drop the temporary table for PROD and APRD KH
155: PROCEDURE ResetTestPurge(p_purge_id sy_purg_mst.purge_id%TYPE,
156: p_purge_type sy_purg_def.purge_type%TYPE,
157: p_debug_flag varchar2);
158:
159: -- Created a FUNCTION for GSCC standard fix bug 3871659
160: --Standard: File.Sql.6 - Do NOT include any references to hardcoded schema

Line 168: p_purge_type sy_purg_def.purge_type%TYPE,

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

Line 420: p_purge_type sy_purg_def.purge_type%TYPE,

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

Line 439: CURSOR l_tablename_rows_cur (c_purge_type sy_purg_def.purge_type%TYPE,

435: -- Check archive row table to make sure all columns are real
436: -- tables with the right row type (rowid). Put all table names
437: -- in p_arctablestab, with master table first.
438:
439: CURSOR l_tablename_rows_cur (c_purge_type sy_purg_def.purge_type%TYPE,
440: c_arctablename user_tables.table_name%TYPE,
441: c_schema_name VARCHAR2) IS
442: SELECT UC.column_name arctable
443: , UC.data_type drowtype

Line 448: , sy_purg_def_act SD

444: , decode(nvl(SD.archive_action,'K'),'D','D','K') arcaction
445: , UU.default_tablespace arctablespace
446: FROM all_tab_columns UC
447: , dba_users UU
448: , sy_purg_def_act SD
449: , sy_purg_def SP
450: WHERE UC.owner = c_schema_name
451: AND UU.USERNAME='GMA'
452: AND SD.purge_type = SP.purge_type

Line 449: , sy_purg_def SP

445: , UU.default_tablespace arctablespace
446: FROM all_tab_columns UC
447: , dba_users UU
448: , sy_purg_def_act SD
449: , sy_purg_def SP
450: WHERE UC.owner = c_schema_name
451: AND UU.USERNAME='GMA'
452: AND SD.purge_type = SP.purge_type
453: AND SD.table_name = UC.column_name

Line 467: , sy_purg_def_act SD

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'
471: AND SD.purge_type = SP.purge_type

Line 468: , sy_purg_def SP

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'
471: AND SD.purge_type = SP.purge_type
472: AND SD.table_name = UC.column_name

Line 628: , sy_purg_def SD

624: , nvl(SM.commit_frequency,750) commit_frequency
625: , nvl(SM.object_owner,'') object_owner
626: FROM dba_users UU
627: , sy_purg_mst SM
628: , sy_purg_def SD
629: WHERE SD.purge_type (+) = SM.purge_type
630: AND UU.username = 'GMA'
631: AND SM.purge_id = c_purge_id;
632:

Line 641: , sy_purg_def_crit DC

637: , REPLACE(NVL(DC.value_mask,'{X}'),
638: '{X}',
639: NVL(MC.crit_value,DC.default_value)) value
640: FROM sy_purg_mst_crit MC
641: , sy_purg_def_crit DC
642: , sy_purg_mst MS
643: WHERE MC.crit_tag = DC.crit_tag
644: AND MC.purge_id = MS.purge_id
645: AND DC.purge_type = MS.purge_type

Line 657: l_sqlstatement sy_purg_def.sqlstatement%TYPE;

653: l_starttime DATE;
654: l_inittime DATE;
655:
656: l_user NUMBER;
657: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
658: l_purge_type sy_purg_def.purge_type%TYPE;
659: l_tablespace user_tablespaces.tablespace_name%TYPE;
660:
661: l_tablenames_tab GMA_PURGE_DDL.g_tablename_tab_type;

Line 658: l_purge_type sy_purg_def.purge_type%TYPE;

654: l_inittime DATE;
655:
656: l_user NUMBER;
657: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
658: l_purge_type sy_purg_def.purge_type%TYPE;
659: l_tablespace user_tablespaces.tablespace_name%TYPE;
660:
661: l_tablenames_tab GMA_PURGE_DDL.g_tablename_tab_type;
662: l_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_type;

Line 1190: p_sqlstatement sy_purg_def.sqlstatement%TYPE,

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
1194:

Line 1201: l_sqlstatement sy_purg_def.sqlstatement%TYPE;

1197: l_result INTEGER;
1198: l_rows INTEGER;
1199: l_cursor INTEGER;
1200: l_badstatement EXCEPTION;
1201: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
1202:
1203: BEGIN
1204:
1205: l_cursor := DBMS_SQL.OPEN_CURSOR;

Line 1257: l_sqlstatement sy_purg_def.sqlstatement%TYPE;

1253:
1254: l_result INTEGER;
1255: l_archiverows INTEGER; -- number of rows archived from this table
1256: l_deleterows INTEGER; -- number of rows deleted from this table
1257: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
1258: l_cursor INTEGER;
1259: l_tableno INTEGER;
1260:
1261: BEGIN

Line 1351: p_purge_type sy_purg_def.purge_type%TYPE,

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

Line 1355: p_sqlstatement sy_purg_def.sqlstatement%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,
1358: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_type,
1359: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,

Line 1471: p_purge_type sy_purg_def.purge_type%TYPE,

1467:
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

Line 1479: FROM sy_purg_def_act

1475: -- drop archive tables, reset views
1476:
1477: CURSOR l_viewtables_cur(c_purge_type sy_purg_mst.purge_type%TYPE) IS
1478: SELECT table_name
1479: FROM sy_purg_def_act
1480: WHERE purge_type = c_purge_type;
1481:
1482: BEGIN
1483:

Line 1523: p_purge_type sy_purg_def.purge_type%TYPE,

1519:
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

Line 1679: p_purge_type sy_purg_def.purge_type%TYPE,

1675: end if;
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

Line 1815: p_purge_type sy_purg_def.purge_type%TYPE,

1811: END GLPOSTED_JRNL;
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

Line 2014: p_purge_type sy_purg_def.purge_type%TYPE,

2010:
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:

Line 2144: p_purge_type sy_purg_def.purge_type%TYPE,

2140: end if;
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:

Line 2155: l_sqlstatement sy_purg_def.sqlstatement%TYPE;

2151: l_result INTEGER;
2152: l_rows INTEGER;
2153: l_cursor INTEGER;
2154: l_badstatement EXCEPTION;
2155: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
2156:
2157: l_temptable Varchar2(2000);
2158:
2159: -- start of khaja code

Line 2235: p_purge_type sy_purg_def.purge_type%TYPE,

2231:
2232: END tempcreate;
2233:
2234: PROCEDURE Tempinsert(p_purge_id sy_purg_mst.purge_id%TYPE,
2235: p_purge_type sy_purg_def.purge_type%TYPE,
2236: p_all_ids number,
2237: p_debug_flag BOOLEAN)
2238: IS
2239:

Line 2246: l_sqlstatement sy_purg_def.sqlstatement%TYPE;

2242: l_result INTEGER;
2243: l_rows INTEGER;
2244: l_cursor INTEGER;
2245: l_badstatement EXCEPTION;
2246: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
2247:
2248: l_temptable Varchar2(2000);
2249:
2250: -- start of khaja code

Line 2305: p_purge_type sy_purg_def.purge_type%TYPE,

2301:
2302: END tempinsert;
2303:
2304: PROCEDURE Tempdrop(p_purge_id sy_purg_mst.purge_id%TYPE,
2305: p_purge_type sy_purg_def.purge_type%TYPE,
2306: p_debug_flag BOOLEAN)
2307: IS
2308:
2309: -- create master rows table for archive

Line 2315: l_sqlstatement sy_purg_def.sqlstatement%TYPE;

2311: l_result INTEGER;
2312: l_rows INTEGER;
2313: l_cursor INTEGER;
2314: l_badstatement EXCEPTION;
2315: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
2316:
2317: l_temptable Varchar2(2000);
2318:
2319: -- start of khaja code

Line 2375: p_purge_type sy_purg_def.purge_type%TYPE,

2371:
2372: END Tempdrop;
2373:
2374: PROCEDURE ResetTestPurge(p_purge_id sy_purg_mst.purge_id%TYPE,
2375: p_purge_type sy_purg_def.purge_type%TYPE,
2376: p_debug_flag varchar2)
2377: IS
2378: --Prepare the SQL to get all table_names which needs to be renamed based on the
2379: --archive_action equal to 'K'

Line 2388: FROM SY_PURG_MST A, Sy_purg_def_act B

2384: WHERE owner = c_schema_name
2385: AND
2386: table_name IN(
2387: SELECT 'T' ||LPAD(TO_CHAR(A.purge_id),5,'0')||'_'||B.table_name
2388: FROM SY_PURG_MST A, Sy_purg_def_act B
2389: WHERE A.purge_type=B.purge_type AND A.purge_id=ppurge_id
2390: union
2391: SELECT 'T'||LPAD(TO_CHAR(A.purge_id),5,'0')||'_'||'ARCHIVEROWS'
2392: FROM SY_PURG_MST A

Line 2407: l_sqlstatement sy_purg_def.sqlstatement%TYPE;

2403: l_result INTEGER;
2404: l_rows INTEGER:=0;
2405: l_cursor INTEGER;
2406: l_badstatement EXCEPTION;
2407: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
2408:
2409: l_temptable Varchar2(2000);
2410:
2411: -- start of khaja code