17: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
18:
19: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;
20:
21: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
22: v_OverLoad DBMS_DESCRIBE.NUMBER_TABLE;
23: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
24: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
25: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
18:
19: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;
20:
21: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
22: v_OverLoad DBMS_DESCRIBE.NUMBER_TABLE;
23: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
24: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
25: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
26: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
19: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;
20:
21: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
22: v_OverLoad DBMS_DESCRIBE.NUMBER_TABLE;
23: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
24: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
25: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
26: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
27: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
20:
21: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
22: v_OverLoad DBMS_DESCRIBE.NUMBER_TABLE;
23: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
24: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
25: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
26: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
27: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
28: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
21: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
22: v_OverLoad DBMS_DESCRIBE.NUMBER_TABLE;
23: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
24: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
25: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
26: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
27: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
28: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
29: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
22: v_OverLoad DBMS_DESCRIBE.NUMBER_TABLE;
23: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
24: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
25: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
26: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
27: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
28: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
29: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
30: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
23: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
24: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
25: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
26: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
27: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
28: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
29: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
30: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
31: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
24: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
25: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
26: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
27: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
28: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
29: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
30: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
31: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
32: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
25: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
26: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
27: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
28: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
29: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
30: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
31: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
32: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
33: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;
26: v_DataType DBMS_DESCRIBE.NUMBER_TABLE;
27: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
28: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
29: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
30: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
31: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
32: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
33: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;
34:
27: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
28: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
29: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
30: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
31: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
32: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
33: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;
34:
35: /*GLOBAL VARIABLES FOR PRIVATE USE
28: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
29: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
30: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
31: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
32: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
33: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;
34:
35: /*GLOBAL VARIABLES FOR PRIVATE USE
36: ==================================*/
29: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
30: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
31: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
32: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
33: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;
34:
35: /*GLOBAL VARIABLES FOR PRIVATE USE
36: ==================================*/
37:
99: raise IEM_TAG_PROC_WRONG_SIGNATURE ;
100: end if;
101:
102: --Actual API starts here
103: DBMS_DESCRIBE.DESCRIBE_PROCEDURE(
104: p_ProcName,
105: null,
106: null,
107: v_Overload,