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 STANDARD

Line 159: -- Created a FUNCTION for GSCC standard fix bug 3871659

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
161: FUNCTION Get_GmaSchemaName
162: RETURN VARCHAR2;
163:

Line 160: --Standard: File.Sql.6 - Do NOT include any references to hardcoded schema

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
161: FUNCTION Get_GmaSchemaName
162: RETURN VARCHAR2;
163:
164:

Line 1281: -- Created a FUNCTION for GSCC standard fix bug 3871659

1277:
1278: FOR l_tableno IN 0 .. p_tablecount LOOP
1279:
1280:
1281: -- Created a FUNCTION for GSCC standard fix bug 3871659
1282: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema
1283:
1284: -- l_sqlstatement := 'SELECT COUNT(*) FROM '
1285: l_sqlstatement := 'SELECT COUNT(*) FROM ' ||Get_GmaSchemaName||'.'||

Line 1282: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema

1278: FOR l_tableno IN 0 .. p_tablecount LOOP
1279:
1280:
1281: -- Created a FUNCTION for GSCC standard fix bug 3871659
1282: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema
1283:
1284: -- l_sqlstatement := 'SELECT COUNT(*) FROM '
1285: l_sqlstatement := 'SELECT COUNT(*) FROM ' ||Get_GmaSchemaName||'.'||
1286: GMA_PURGE_UTILITIES.makearcname(p_purge_id,

Line 1558: -- DELETE_MARK Standard: 0=Active record (default); 1=Marked for (logical) deletion.

1554: AND (order_status = -1 or order_status = 25) ;
1555:
1556: -- COMPLETED_IND Completed indicator. 0=Pending transaction, 1=Completed transaction.
1557: -- GL_POSTED_IND GL posted indicator. 0=Not posted to GL, 1=Posted to GL.
1558: -- DELETE_MARK Standard: 0=Active record (default); 1=Marked for (logical) deletion.
1559: -- TRANS_ID (PK) Unique key for the transaction.
1560:
1561: --(in 1,2) and TRANS_ID not in (SELECT TRANS_ID from ic_tran_pnd where doc_id=pdoc_id and doc_type='OPSO' and delete_mark=1)
1562:

Line 2048: DELETE_MARK Standard: 0=Active record (default); 1=Marked for (logical) deletion.

2044: AND (PH2.po_status = 20);
2045:
2046: /*
2047: RECV_LINE_ID (PK) This column may contain a receipt or a return line number: Recpt: fk to po_recv_dtl; Rtrn: fk to po_rtrn_dtl.
2048: DELETE_MARK Standard: 0=Active record (default); 1=Marked for (logical) deletion.
2049: */
2050:
2051: cursor c2 (ppo_id po_recv_hst.po_id%type) is
2052: select count(*)

Line 2189: -- Created a FUNCTION for GSCC standard fix bug 3871659

2185: IF l_result=0 then
2186:
2187: l_sqlstatement := 'INSERT INTO '||p_owner ||'.'||l_temptable|| ' values(:V_bindfix)';
2188:
2189: -- Created a FUNCTION for GSCC standard fix bug 3871659
2190: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema
2191:
2192: GMA_PURGE_UTILITIES.printlong(p_purge_id,
2193: 'Temporary table '||Get_GmaSchemaName||'.'||l_temptable||' created.');

Line 2190: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema

2186:
2187: l_sqlstatement := 'INSERT INTO '||p_owner ||'.'||l_temptable|| ' values(:V_bindfix)';
2188:
2189: -- Created a FUNCTION for GSCC standard fix bug 3871659
2190: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema
2191:
2192: GMA_PURGE_UTILITIES.printlong(p_purge_id,
2193: 'Temporary table '||Get_GmaSchemaName||'.'||l_temptable||' created.');
2194: -- 'Temporary table '||l_temptable||' created.');

Line 2263: -- Created a FUNCTION for GSCC standard fix bug 3871659

2259:
2260: l_cursor := DBMS_SQL.OPEN_CURSOR;
2261:
2262: -- l_sqlstatement := 'INSERT INTO ' || 'GMA' || '.' ||
2263: -- Created a FUNCTION for GSCC standard fix bug 3871659
2264: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema
2265:
2266: l_sqlstatement := 'INSERT INTO ' ||Get_GmaSchemaName||'.' ||
2267: l_temptable|| ' values(:all_ids)';

Line 2264: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema

2260: l_cursor := DBMS_SQL.OPEN_CURSOR;
2261:
2262: -- l_sqlstatement := 'INSERT INTO ' || 'GMA' || '.' ||
2263: -- Created a FUNCTION for GSCC standard fix bug 3871659
2264: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema
2265:
2266: l_sqlstatement := 'INSERT INTO ' ||Get_GmaSchemaName||'.' ||
2267: l_temptable|| ' values(:all_ids)';
2268:

Line 2332: -- Created a FUNCTION for GSCC standard fix bug 3871659

2328:
2329: l_cursor := DBMS_SQL.OPEN_CURSOR;
2330:
2331: -- l_sqlstatement := 'DROP TABLE ' || 'GMA' || '.' ||l_temptable;
2332: -- Created a FUNCTION for GSCC standard fix bug 3871659
2333: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema
2334:
2335: l_sqlstatement := 'DROP TABLE ' ||Get_GmaSchemaName||'.' ||l_temptable;
2336:

Line 2333: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema

2329: l_cursor := DBMS_SQL.OPEN_CURSOR;
2330:
2331: -- l_sqlstatement := 'DROP TABLE ' || 'GMA' || '.' ||l_temptable;
2332: -- Created a FUNCTION for GSCC standard fix bug 3871659
2333: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema
2334:
2335: l_sqlstatement := 'DROP TABLE ' ||Get_GmaSchemaName||'.' ||l_temptable;
2336:
2337: IF (p_debug_flag = TRUE) THEN

Line 2348: -- Created a FUNCTION for GSCC standard fix bug 3871659

2344: IF l_result <> 0 THEN
2345: RAISE l_badstatement;
2346: END IF;
2347:
2348: -- Created a FUNCTION for GSCC standard fix bug 3871659
2349: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema
2350:
2351: GMA_PURGE_UTILITIES.printlong(p_purge_id,
2352: 'Temporary table '||Get_GmaSchemaName||'.'||l_temptable||' dropped.');

Line 2349: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema

2345: RAISE l_badstatement;
2346: END IF;
2347:
2348: -- Created a FUNCTION for GSCC standard fix bug 3871659
2349: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema
2350:
2351: GMA_PURGE_UTILITIES.printlong(p_purge_id,
2352: 'Temporary table '||Get_GmaSchemaName||'.'||l_temptable||' dropped.');
2353: -- 'Temporary table '||l_temptable||' dropped.');

Line 2478: -- Created a FUNCTION for GSCC standard fix bug 3871659

2474: 'Unhandled EXCEPTION - ' || sqlerrm);
2475: RAISE;
2476: END ResetTestPurge;
2477:
2478: -- Created a FUNCTION for GSCC standard fix bug 3871659
2479: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema
2480:
2481: FUNCTION Get_GmaSchemaName
2482: RETURN VARCHAR2

Line 2479: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema

2475: RAISE;
2476: END ResetTestPurge;
2477:
2478: -- Created a FUNCTION for GSCC standard fix bug 3871659
2479: -- Standard: File.Sql.6 - Do NOT include any references to hardcoded schema
2480:
2481: FUNCTION Get_GmaSchemaName
2482: RETURN VARCHAR2
2483: IS