DBA Data[Home] [Help]

APPS.IBC_DIRECTORY_NODE_GRP dependencies on IBC_DIRECTORY_NODE_GRP

Line 1: PACKAGE BODY Ibc_Directory_Node_Grp AS

1: PACKAGE BODY Ibc_Directory_Node_Grp AS
2: /* $Header: ibcgdndb.pls 115.5 2003/07/29 21:25:35 enunez ship $ */
3:
4: -- Purpose: API to Populate Content Type.
5:

Line 12: -- Package name : Ibc_Directory_Node_Grp

8: -- --------- ------ ------------------------------------------
9: -- Sri Rangarajan 01/06/2002 Created Package
10:
11:
12: -- Package name : Ibc_Directory_Node_Grp
13: -- Purpose :
14: -- History :
15: -- NOTE :
16: -- End of Comments

Line 19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'Ibc_Directory_Node_Grp';

15: -- NOTE :
16: -- End of Comments
17:
18:
19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'Ibc_Directory_Node_Grp';
20: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibcgdndb.pls';
21:
22: FUNCTION Query_Directory_Node_Row (
23: p_Directory_node_id IN NUMBER)

Line 24: RETURN Ibc_Directory_Node_Grp.Directory_Node_Rec_Type;

20: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibcgdndb.pls';
21:
22: FUNCTION Query_Directory_Node_Row (
23: p_Directory_node_id IN NUMBER)
24: RETURN Ibc_Directory_Node_Grp.Directory_Node_Rec_Type;
25:
26:
27: PROCEDURE Create_Directory_Node(
28: P_Api_Version_Number IN NUMBER,

Line 32: P_Directory_Node_Rec IN Ibc_Directory_Node_Grp.Directory_Node_Rec_Type := Ibc_Directory_Node_Grp.G_MISS_Directory_Node_Rec,

28: P_Api_Version_Number IN NUMBER,
29: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
30: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
31: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: P_Directory_Node_Rec IN Ibc_Directory_Node_Grp.Directory_Node_Rec_Type := Ibc_Directory_Node_Grp.G_MISS_Directory_Node_Rec,
33: p_parent_dir_node_id IN NUMBER,
34: x_Directory_Node_Rec OUT NOCOPY Ibc_Directory_Node_Grp.Directory_Node_Rec_Type,
35: X_Return_Status OUT NOCOPY VARCHAR2,
36: X_Msg_Count OUT NOCOPY NUMBER,

Line 34: x_Directory_Node_Rec OUT NOCOPY Ibc_Directory_Node_Grp.Directory_Node_Rec_Type,

30: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
31: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: P_Directory_Node_Rec IN Ibc_Directory_Node_Grp.Directory_Node_Rec_Type := Ibc_Directory_Node_Grp.G_MISS_Directory_Node_Rec,
33: p_parent_dir_node_id IN NUMBER,
34: x_Directory_Node_Rec OUT NOCOPY Ibc_Directory_Node_Grp.Directory_Node_Rec_Type,
35: X_Return_Status OUT NOCOPY VARCHAR2,
36: X_Msg_Count OUT NOCOPY NUMBER,
37: X_Msg_Data OUT NOCOPY VARCHAR2
38: )

Line 59: l_Directory_Node_Rec Ibc_Directory_Node_Grp.Directory_Node_Rec_Type := p_Directory_Node_Rec;

55:
56: lx_DIRECTORY_NODE_REL_ID NUMBER;
57:
58:
59: l_Directory_Node_Rec Ibc_Directory_Node_Grp.Directory_Node_Rec_Type := p_Directory_Node_Rec;
60:
61: BEGIN
62:
63: -- Initialize API return status to SUCCESS

Line 288: l_Directory_Node_Rec Ibc_Directory_Node_Grp.Directory_Node_Rec_Type;

284: l_api_version_number NUMBER := 1.0;
285: l_api_name VARCHAR2(50) := 'MOve_Directory_Node';
286: l_Directory_Node_Code VARCHAR2(100);
287:
288: l_Directory_Node_Rec Ibc_Directory_Node_Grp.Directory_Node_Rec_Type;
289:
290: l_DIRECTORY_NODE_REL_ID NUMBER;
291:
292: CURSOR C_Directory_Node IS

Line 474: P_Directory_Node_Rec IN Ibc_Directory_Node_Grp.Directory_Node_Rec_Type := Ibc_Directory_Node_Grp.G_MISS_Directory_Node_Rec,

470: P_Api_Version_Number IN NUMBER,
471: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
472: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
473: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
474: P_Directory_Node_Rec IN Ibc_Directory_Node_Grp.Directory_Node_Rec_Type := Ibc_Directory_Node_Grp.G_MISS_Directory_Node_Rec,
475: p_parent_dir_node_id IN NUMBER,
476: x_Directory_Node_Rec OUT NOCOPY Ibc_Directory_Node_Grp.Directory_Node_Rec_Type,
477: X_Return_Status OUT NOCOPY VARCHAR2,
478: X_Msg_Count OUT NOCOPY NUMBER,

Line 476: x_Directory_Node_Rec OUT NOCOPY Ibc_Directory_Node_Grp.Directory_Node_Rec_Type,

472: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
473: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
474: P_Directory_Node_Rec IN Ibc_Directory_Node_Grp.Directory_Node_Rec_Type := Ibc_Directory_Node_Grp.G_MISS_Directory_Node_Rec,
475: p_parent_dir_node_id IN NUMBER,
476: x_Directory_Node_Rec OUT NOCOPY Ibc_Directory_Node_Grp.Directory_Node_Rec_Type,
477: X_Return_Status OUT NOCOPY VARCHAR2,
478: X_Msg_Count OUT NOCOPY NUMBER,
479: X_Msg_Data OUT NOCOPY VARCHAR2
480: )

Line 501: l_Directory_Node_Rec Ibc_Directory_Node_Grp.Directory_Node_Rec_Type := p_Directory_Node_Rec;

497: l_api_name VARCHAR2(50) := 'Update_Directory_Node';
498: l_Directory_Node_Code VARCHAR2(100);
499: lx_rowid VARCHAR2(240);
500:
501: l_Directory_Node_Rec Ibc_Directory_Node_Grp.Directory_Node_Rec_Type := p_Directory_Node_Rec;
502: lx_DIRECTORY_NODE_REL_ID NUMBER;
503:
504: BEGIN
505:

Line 865: RETURN Ibc_Directory_Node_Grp.Directory_Node_Rec_Type

861: END delete_Directory_Node;
862:
863: FUNCTION Query_Directory_Node_Row (
864: p_Directory_node_id IN NUMBER)
865: RETURN Ibc_Directory_Node_Grp.Directory_Node_Rec_Type
866: IS
867: l_Directory_node_Rec Ibc_Directory_Node_Grp.Directory_Node_Rec_Type;
868: BEGIN
869:

Line 867: l_Directory_node_Rec Ibc_Directory_Node_Grp.Directory_Node_Rec_Type;

863: FUNCTION Query_Directory_Node_Row (
864: p_Directory_node_id IN NUMBER)
865: RETURN Ibc_Directory_Node_Grp.Directory_Node_Rec_Type
866: IS
867: l_Directory_node_Rec Ibc_Directory_Node_Grp.Directory_Node_Rec_Type;
868: BEGIN
869:
870: SELECT
871: DIRECTORY_NODE_ID ,

Line 910: FUNCTION get_directory_node_rec RETURN Ibc_Directory_Node_Grp.Directory_Node_rec_type

906: END IF;
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: END Query_Directory_Node_Row;
909:
910: FUNCTION get_directory_node_rec RETURN Ibc_Directory_Node_Grp.Directory_Node_rec_type
911: IS
912: TMP_REC Ibc_Directory_Node_Grp.Directory_Node_rec_type;
913: BEGIN
914: RETURN TMP_REC;

Line 912: TMP_REC Ibc_Directory_Node_Grp.Directory_Node_rec_type;

908: END Query_Directory_Node_Row;
909:
910: FUNCTION get_directory_node_rec RETURN Ibc_Directory_Node_Grp.Directory_Node_rec_type
911: IS
912: TMP_REC Ibc_Directory_Node_Grp.Directory_Node_rec_type;
913: BEGIN
914: RETURN TMP_REC;
915: END get_directory_node_rec;
916:

Line 917: END Ibc_Directory_Node_Grp;

913: BEGIN
914: RETURN TMP_REC;
915: END get_directory_node_rec;
916:
917: END Ibc_Directory_Node_Grp;