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.IEM_ROUTE_RUN_PROC_PVT dependencies on DBMS_DESCRIBE

Line 25: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables

21: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
22:
23: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;
24:
25: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
26: v_OverLoad DBMS_DESCRIBE.NUMBER_TABLE;
27: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
28: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
29: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;

Line 26: v_OverLoad DBMS_DESCRIBE.NUMBER_TABLE;

22:
23: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;
24:
25: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
26: v_OverLoad DBMS_DESCRIBE.NUMBER_TABLE;
27: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
28: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
29: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
30: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;

Line 27: v_Position DBMS_DESCRIBE.NUMBER_TABLE;

23: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;
24:
25: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
26: v_OverLoad DBMS_DESCRIBE.NUMBER_TABLE;
27: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
28: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
29: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
30: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
31: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;

Line 28: v_Level DBMS_DESCRIBE.NUMBER_TABLE;

24:
25: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
26: v_OverLoad DBMS_DESCRIBE.NUMBER_TABLE;
27: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
28: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
29: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
30: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
31: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
32: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;

Line 29: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;

25: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
26: v_OverLoad DBMS_DESCRIBE.NUMBER_TABLE;
27: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
28: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
29: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
30: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
31: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
32: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
33: v_Length DBMS_DESCRIBE.NUMBER_TABLE;

Line 30: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;

26: v_OverLoad DBMS_DESCRIBE.NUMBER_TABLE;
27: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
28: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
29: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
30: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
31: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
32: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
33: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
34: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;

Line 31: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;

27: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
28: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
29: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
30: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
31: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
32: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
33: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
34: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
35: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;

Line 32: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;

28: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
29: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
30: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
31: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
32: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
33: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
34: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
35: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
36: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;

Line 33: v_Length DBMS_DESCRIBE.NUMBER_TABLE;

29: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
30: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
31: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
32: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
33: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
34: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
35: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
36: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
37: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;

Line 34: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;

30: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
31: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
32: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
33: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
34: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
35: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
36: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
37: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;
38:

Line 35: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;

31: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
32: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
33: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
34: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
35: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
36: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
37: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;
38:
39: /*GLOBAL VARIABLES FOR PRIVATE USE

Line 36: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;

32: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
33: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
34: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
35: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
36: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
37: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;
38:
39: /*GLOBAL VARIABLES FOR PRIVATE USE
40: ==================================*/

Line 37: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;

33: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
34: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
35: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
36: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
37: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;
38:
39: /*GLOBAL VARIABLES FOR PRIVATE USE
40: ==================================*/
41:

Line 111: DBMS_DESCRIBE.DESCRIBE_PROCEDURE(

107: end if;
108: end if;
109:
110: --Actual API starts here
111: DBMS_DESCRIBE.DESCRIBE_PROCEDURE(
112: p_ProcName,
113: null,
114: null,
115: v_Overload,