DBA Data[Home] [Help]

APPS.IEX_TERR_WINNERS_PUB dependencies on IEX_TERR_WINNERS_PUB

Line 1: PACKAGE BODY IEX_TERR_WINNERS_PUB AS

1: PACKAGE BODY IEX_TERR_WINNERS_PUB AS
2: /* $Header: iexttwpb.pls 120.1 2005/12/06 07:43:18 lkkumar noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- Start of Comments

Line 7: -- PACKAGE NAME: IEX_TERR_WINNERS_PUB

3:
4: ---------------------------------------------------------------------------
5: -- Start of Comments
6: ---------------------------------------------------------------------------
7: -- PACKAGE NAME: IEX_TERR_WINNERS_PUB
8: -- ---------------------------------------------------------------------
9: -- PURPOSE
10: --
11: -- Public Package for the concurrent program

Line 28: G_PKG_NAME CONSTANT VARCHAR2(30):='IEX_TERR_WINNERS_PUB';

24:
25: /*-------------------------------------------------------------------------+
26: | PRIVATE CONSTANTS
27: +-------------------------------------------------------------------------*/
28: G_PKG_NAME CONSTANT VARCHAR2(30):='IEX_TERR_WINNERS_PUB';
29: G_FILE_NAME CONSTANT VARCHAR2(12):='asxttwpb.pls';
30:
31:
32: /*-------------------------------------------------------------------------+

Line 114: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in Analyze_Table');

110: DBMS_STATS.gather_table_stats(SCHEMA, TABLE_NAME, cascade=>TRUE, degree=>8, estimate_percent=>P_PERCENT);
111:
112: EXCEPTION
113: WHEN others THEN
114: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in Analyze_Table');
115: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||
116: ' SQLERRM: ' || SQLERRM);
117: RAISE;
118: END Analyze_Table;

Line 115: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||

111:
112: EXCEPTION
113: WHEN others THEN
114: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in Analyze_Table');
115: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||
116: ' SQLERRM: ' || SQLERRM);
117: RAISE;
118: END Analyze_Table;
119:

Line 123: END IEX_TERR_WINNERS_PUB;

119:
120:
121:
122:
123: END IEX_TERR_WINNERS_PUB;