DBA Data[Home] [Help]

APPS.XDP_UTILITIES dependencies on DBMS_DESCRIBE

Line 4: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables

1: PACKAGE BODY XDP_UTILITIES AS
2: /* $Header: XDPUTILB.pls 120.1 2005/06/09 00:17:33 appldev $ */
3:
4: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
5: v_Overload DBMS_DESCRIBE.NUMBER_TABLE;
6: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
7: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
8: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;

Line 5: v_Overload DBMS_DESCRIBE.NUMBER_TABLE;

1: PACKAGE BODY XDP_UTILITIES AS
2: /* $Header: XDPUTILB.pls 120.1 2005/06/09 00:17:33 appldev $ */
3:
4: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
5: v_Overload DBMS_DESCRIBE.NUMBER_TABLE;
6: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
7: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
8: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
9: v_Datatype DBMS_DESCRIBE.NUMBER_TABLE;

Line 6: v_Position DBMS_DESCRIBE.NUMBER_TABLE;

2: /* $Header: XDPUTILB.pls 120.1 2005/06/09 00:17:33 appldev $ */
3:
4: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
5: v_Overload DBMS_DESCRIBE.NUMBER_TABLE;
6: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
7: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
8: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
9: v_Datatype DBMS_DESCRIBE.NUMBER_TABLE;
10: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;

Line 7: v_Level DBMS_DESCRIBE.NUMBER_TABLE;

3:
4: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
5: v_Overload DBMS_DESCRIBE.NUMBER_TABLE;
6: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
7: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
8: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
9: v_Datatype DBMS_DESCRIBE.NUMBER_TABLE;
10: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
11: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;

Line 8: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;

4: -- internal DBMS_DESCRIBE.DESCRIBE_PROCEDURE variables
5: v_Overload DBMS_DESCRIBE.NUMBER_TABLE;
6: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
7: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
8: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
9: v_Datatype DBMS_DESCRIBE.NUMBER_TABLE;
10: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
11: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
12: v_Length DBMS_DESCRIBE.NUMBER_TABLE;

Line 9: v_Datatype DBMS_DESCRIBE.NUMBER_TABLE;

5: v_Overload DBMS_DESCRIBE.NUMBER_TABLE;
6: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
7: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
8: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
9: v_Datatype DBMS_DESCRIBE.NUMBER_TABLE;
10: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
11: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
12: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
13: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;

Line 10: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;

6: v_Position DBMS_DESCRIBE.NUMBER_TABLE;
7: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
8: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
9: v_Datatype DBMS_DESCRIBE.NUMBER_TABLE;
10: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
11: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
12: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
13: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
14: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;

Line 11: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;

7: v_Level DBMS_DESCRIBE.NUMBER_TABLE;
8: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
9: v_Datatype DBMS_DESCRIBE.NUMBER_TABLE;
10: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
11: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
12: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
13: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
14: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
15: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;

Line 12: v_Length DBMS_DESCRIBE.NUMBER_TABLE;

8: v_ArgumentName DBMS_DESCRIBE.VARCHAR2_TABLE;
9: v_Datatype DBMS_DESCRIBE.NUMBER_TABLE;
10: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
11: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
12: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
13: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
14: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
15: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
16: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;

Line 13: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;

9: v_Datatype DBMS_DESCRIBE.NUMBER_TABLE;
10: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
11: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
12: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
13: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
14: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
15: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
16: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;
17:

Line 14: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;

10: v_DefaultValue DBMS_DESCRIBE.NUMBER_TABLE;
11: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
12: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
13: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
14: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
15: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
16: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;
17:
18: PROCEDURE DO_COMMIT IS

Line 15: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;

11: v_InOut DBMS_DESCRIBE.NUMBER_TABLE;
12: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
13: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
14: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
15: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
16: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;
17:
18: PROCEDURE DO_COMMIT IS
19: -- PL/SQL Block

Line 16: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;

12: v_Length DBMS_DESCRIBE.NUMBER_TABLE;
13: v_Precision DBMS_DESCRIBE.NUMBER_TABLE;
14: v_Scale DBMS_DESCRIBE.NUMBER_TABLE;
15: v_Radix DBMS_DESCRIBE.NUMBER_TABLE;
16: v_Spare DBMS_DESCRIBE.NUMBER_TABLE;
17:
18: PROCEDURE DO_COMMIT IS
19: -- PL/SQL Block
20: BEGIN

Line 776: DBMS_DESCRIBE.DESCRIBE_PROCEDURE(

772: v_ArgCounter NUMBER := 1;
773: BEGIN
774: -- First call DESCRIBE_PROCEDURE to populate the internal variables
775: -- about the procedure.
776: DBMS_DESCRIBE.DESCRIBE_PROCEDURE(
777: p_ProcName,
778: null,
779: null,
780: v_Overload,

Line 806: lv_InOut DBMS_DESCRIBE.NUMBER_TABLE;

802:
803: -- DBMS_SQL variables
804: v_Cursor NUMBER;
805: v_NumRows NUMBER;
806: lv_InOut DBMS_DESCRIBE.NUMBER_TABLE;
807:
808: v_ProcCall VARCHAR2(32600);
809: v_FirstParam BOOLEAN := TRUE;
810: BEGIN