PACKAGE: APPS.QLTSTORB

Source

1 PACKAGE QLTSTORB AUTHID CURRENT_USER as
2 /* $Header: qltstorb.pls 115.2 2002/11/27 19:34:50 jezheng ship $ */
3 
4 -- 3/8/95 - CREATED
5 -- Kevin Wiggen
6 
7 --  This is a storage unit used for creating the FK Lookups in the
8 --  Selection Criteria Engine, and in the Dynamic View Creation
9 --
10 
11 
12    PROCEDURE MAKE_REC_GROUP;
13 
14    PROCEDURE ADD_ROW_TO_REC_GROUP (NUM NUMBER,
15 				   HARD_COLUMN VARCHAR2,
16 				   RES_COL_NAME VARCHAR2,
17  			  	   DATA NUMBER,
18 				   OPER VARCHAR2,
19 				   LOW_VAL VARCHAR2,
20 				   HIGH_VAL VARCHAR2,
21                                    SELE NUMBER,
22 				   DISP_LENGTH NUMBER,
23 				   PROMPT VARCHAR2,
24 				   ORDER_SEQ NUMBER,
25 				   TOTAL NUMBER,
26 				   FUNCTION NUMBER,
27 				   FXN_PROMPT VARCHAR2,
28 				   PRECISION NUMBER,
29 				   FK_LOOK_TYPE NUMBER,
30 				   FK_TABL_NAME VARCHAR2,
31 				   FK_TABL_SH_NAME VARCHAR2,
32 				   PK_ID VARCHAR2,
33 			           PK_ID2 VARCHAR2,
34   				   PK_ID3 VARCHAR2,
35 				   FK_ID VARCHAR2,
36 				   FK_ID2 VARCHAR2,
37 				   FK_ID3 VARCHAR2,
38 				   FK_MEANING VARCHAR2,
39 				   FK_DESC VARCHAR2,
40 				   FK_ADD_WHERE VARCHAR2,
41 				   TABLE_NAME VARCHAR2,
42 				   PARENT_BLOCK_NAME VARCHAR2,
43 				   LIST_ID NUMBER);
44 
45 
46   FUNCTION ROWS_IN_REC_GROUP
47 	RETURN NUMBER;
48 
49   FUNCTION GET_NUMBER(X_COLUMN VARCHAR2, X_ROW NUMBER)
50 	RETURN NUMBER;
51 
52   FUNCTION GET_CHAR(X_COLUMN VARCHAR2, X_ROW NUMBER)
53 	RETURN VARCHAR2;
54 
55   PROCEDURE KILL_REC_GROUP;
56 
57 
58   PROCEDURE Make_FROM_Rec_grp;
59 
60   Procedure ADD_ROW_TO_FROM_REC_GROUP (table_name VARCHAR2);
61 
62   Function Create_From_Clause
63  	Return VARCHAR2;
64 
65   PROCEDURE Make_WHERE_Rec_grp;
66 
67   Procedure ADD_ROW_TO_WHERE_REC_GROUP (X_WHERE_PORTION VARCHAR2);
68 
69   Function Create_WHERE_Clause
70  	Return VARCHAR2;
71 
72   Procedure KILL_FROM_REC_GRP;
73 
74   Procedure KILL_WHERE_REC_GRP;
75 
76 
77 
78 END QLTSTORB;
79