1 PACKAGE Ibc_Directory_Node_Rels_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctdrls.pls 120.1 2005/07/12 01:52:06 appldev ship $*/
3
4 -- Purpose: Table Handler for Ibc_Directory_Node_Rels table.
5
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- Sri Rangarajan 01/06/2002 Created Package
10 -- vicho 11/05/2002 Remove G_MISS defaulting on UPDATE_ROW
11 -- Sharma 07/04/2005 Modified LOAD_ROW and created
12 -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
13
14 PROCEDURE INSERT_ROW (
15 x_ROWID OUT NOCOPY VARCHAR2,
16 px_Directory_Node_Rel_ID IN OUT NOCOPY NUMBER,
17 p_CHILD_DIR_NODE_ID IN NUMBER,
18 p_PARENT_DIR_NODE_ID IN NUMBER,
19 p_OBJECT_VERSION_NUMBER IN NUMBER,
20 p_CREATION_DATE IN DATE DEFAULT NULL,
21 p_CREATED_BY IN NUMBER DEFAULT NULL,
22 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
23 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
24 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
25 );
26
27 PROCEDURE LOCK_ROW (
28 p_Directory_Node_Rel_ID IN NUMBER,
29 p_OBJECT_VERSION_NUMBER IN NUMBER
30 );
31 PROCEDURE UPDATE_ROW (
32 p_Directory_Node_Rel_ID IN NUMBER,
33 p_CHILD_DIR_NODE_ID IN NUMBER DEFAULT NULL,
34 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
35 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
36 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
37 p_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL,
38 p_PARENT_DIR_NODE_ID IN NUMBER DEFAULT NULL
39 );
40 PROCEDURE DELETE_ROW (
41 p_Directory_Node_Rel_ID IN NUMBER
42 );
43
44 PROCEDURE LOAD_ROW (
45 p_UPLOAD_MODE IN VARCHAR2,
46 p_DIRECTORY_NODE_REL_ID IN NUMBER,
47 p_CHILD_DIR_NODE_ID IN NUMBER,
48 p_PARENT_DIR_NODE_ID IN NUMBER,
49 p_OWNER IN VARCHAR2,
50 p_LAST_UPDATE_DATE IN VARCHAR2);
51
52 PROCEDURE LOAD_SEED_ROW (
53 p_UPLOAD_MODE IN VARCHAR2,
54 p_DIRECTORY_NODE_REL_ID IN NUMBER,
55 p_CHILD_DIR_NODE_ID IN NUMBER,
56 p_PARENT_DIR_NODE_ID IN NUMBER,
57 p_OWNER IN VARCHAR2,
58 p_LAST_UPDATE_DATE IN VARCHAR2);
59
60 END Ibc_Directory_Node_Rels_Pkg;
61