1 PACKAGE qltninrb AUTHID CURRENT_USER as
2 /* $Header: qltninrb.pls 120.1.12020000.1 2012/06/27 08:47:46 appldev ship $ */
3 -- A Server Side Name In
4 -- By Kevin Wiggen
5
6 -- Changed the signature of INIT_CURSOR. Added X_PLAN_ID and X_OCCURRENCE
7 -- for bug 1843356. kabalakr 22 feb 02.
8
9 PROCEDURE INIT_CURSOR(X_PLAN_ID NUMBER DEFAULT NULL, X_TXN_HEADER_ID NUMBER,
10 X_COLLECTION_ID NUMBER DEFAULT NULL, X_OCCURRENCE NUMBER DEFAULT NULL );
11
12 FUNCTION NAME_IN(X_COL_NAME VARCHAR2)
13 RETURN VARCHAR2;
14
15
16 FUNCTION NEXT_ROW
17 RETURN BOOLEAN;
18
19
20 PROCEDURE CLOSE_CURSOR;
21
22 -- return the maximum number of result characteristic columns
23 FUNCTION RES_CHAR_COLUMNS RETURN NUMBER;
24
25 -- Bug 7491253. 12.1.1 FP for Bug 6599571
26 -- Adding a new procedure to set the value fields for
27 -- record in session for collection import
28 -- skolluku
29 PROCEDURE set_value(X_COL_NAME VARCHAR2,return_value VARCHAR2);
30
31 END qltninrb;
32