APPS.IBC_DIRECTORY_NODES_PKG dependencies on FND_API

Line 52: (px_DIRECTORY_NODE_ID = FND_API.G_MISS_NUM))

48:
49: -- Primary key validation check
50:
51: IF ((px_DIRECTORY_NODE_ID IS NULL) OR
52: (px_DIRECTORY_NODE_ID = FND_API.G_MISS_NUM))
53: THEN
54: OPEN c2;
55: FETCH c2 INTO px_DIRECTORY_NODE_ID;
56: CLOSE c2;

Line 77: DECODE(p_NODE_STATUS,FND_API.G_MISS_CHAR,NULL,p_NODE_STATUS),

73: LAST_UPDATE_LOGIN
74: ) VALUES (
75: px_DIRECTORY_NODE_ID,
76: p_DIRECTORY_NODE_CODE,
77: DECODE(p_NODE_STATUS,FND_API.G_MISS_CHAR,NULL,p_NODE_STATUS),
78: DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,p_DIRECTORY_PATH),
79: DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),
80: DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
81: DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,p_HIDDEN_FLAG),

Line 78: DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,p_DIRECTORY_PATH),

74: ) VALUES (
75: px_DIRECTORY_NODE_ID,
76: p_DIRECTORY_NODE_CODE,
77: DECODE(p_NODE_STATUS,FND_API.G_MISS_CHAR,NULL,p_NODE_STATUS),
78: DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,p_DIRECTORY_PATH),
79: DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),
80: DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
81: DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,p_HIDDEN_FLAG),
82: DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,p_NODE_TYPE),

Line 79: DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),

75: px_DIRECTORY_NODE_ID,
76: p_DIRECTORY_NODE_CODE,
77: DECODE(p_NODE_STATUS,FND_API.G_MISS_CHAR,NULL,p_NODE_STATUS),
78: DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,p_DIRECTORY_PATH),
79: DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),
80: DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
81: DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,p_HIDDEN_FLAG),
82: DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,p_NODE_TYPE),
83: DECODE(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,1,p_object_version_number),

Line 80: DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),

76: p_DIRECTORY_NODE_CODE,
77: DECODE(p_NODE_STATUS,FND_API.G_MISS_CHAR,NULL,p_NODE_STATUS),
78: DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,p_DIRECTORY_PATH),
79: DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),
80: DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
81: DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,p_HIDDEN_FLAG),
82: DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,p_NODE_TYPE),
83: DECODE(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,1,p_object_version_number),
84: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

Line 81: DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,p_HIDDEN_FLAG),

77: DECODE(p_NODE_STATUS,FND_API.G_MISS_CHAR,NULL,p_NODE_STATUS),
78: DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,p_DIRECTORY_PATH),
79: DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),
80: DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
81: DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,p_HIDDEN_FLAG),
82: DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,p_NODE_TYPE),
83: DECODE(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,1,p_object_version_number),
84: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_creation_date),

Line 82: DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,p_NODE_TYPE),

78: DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,p_DIRECTORY_PATH),
79: DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),
80: DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
81: DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,p_HIDDEN_FLAG),
82: DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,p_NODE_TYPE),
83: DECODE(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,1,p_object_version_number),
84: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_creation_date),
86: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 83: DECODE(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,1,p_object_version_number),

79: DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),
80: DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
81: DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,p_HIDDEN_FLAG),
82: DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,p_NODE_TYPE),
83: DECODE(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,1,p_object_version_number),
84: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_creation_date),
86: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
87: NULL, FND_GLOBAL.user_id, p_created_by),

Line 84: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

80: DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
81: DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,p_HIDDEN_FLAG),
82: DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,p_NODE_TYPE),
83: DECODE(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,1,p_object_version_number),
84: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_creation_date),
86: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
87: NULL, FND_GLOBAL.user_id, p_created_by),
88: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

Line 86: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

82: DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,p_NODE_TYPE),
83: DECODE(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,1,p_object_version_number),
84: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_creation_date),
86: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
87: NULL, FND_GLOBAL.user_id, p_created_by),
88: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
89: p_last_update_date),
90: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 88: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

84: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_creation_date),
86: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
87: NULL, FND_GLOBAL.user_id, p_created_by),
88: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
89: p_last_update_date),
90: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
91: NULL, FND_GLOBAL.user_id, p_last_updated_by),
92: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

Line 90: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

86: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
87: NULL, FND_GLOBAL.user_id, p_created_by),
88: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
89: p_last_update_date),
90: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
91: NULL, FND_GLOBAL.user_id, p_last_updated_by),
92: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
93: NULL, FND_GLOBAL.login_id, p_last_update_login)
94: );

Line 92: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

88: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
89: p_last_update_date),
90: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
91: NULL, FND_GLOBAL.user_id, p_last_updated_by),
92: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
93: NULL, FND_GLOBAL.login_id, p_last_update_login)
94: );
95:
96: INSERT INTO IBC_DIRECTORY_NODES_TL (

Line 110: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),

106: SOURCE_LANG
107: ) SELECT
108: px_DIRECTORY_NODE_ID,
109: p_DIRECTORY_NODE_NAME,
110: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
111: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
112: NULL, FND_GLOBAL.user_id, p_created_by),
113: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
114: p_creation_date) ,

Line 111: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

107: ) SELECT
108: px_DIRECTORY_NODE_ID,
109: p_DIRECTORY_NODE_NAME,
110: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
111: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
112: NULL, FND_GLOBAL.user_id, p_created_by),
113: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
114: p_creation_date) ,
115: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 113: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

109: p_DIRECTORY_NODE_NAME,
110: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
111: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
112: NULL, FND_GLOBAL.user_id, p_created_by),
113: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
114: p_creation_date) ,
115: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
116: NULL, FND_GLOBAL.user_id, p_last_updated_by),
117: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

Line 115: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

111: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
112: NULL, FND_GLOBAL.user_id, p_created_by),
113: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
114: p_creation_date) ,
115: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
116: NULL, FND_GLOBAL.user_id, p_last_updated_by),
117: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
118: p_last_update_date),
119: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

Line 117: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

113: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
114: p_creation_date) ,
115: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
116: NULL, FND_GLOBAL.user_id, p_last_updated_by),
117: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
118: p_last_update_date),
119: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
120: NULL, FND_GLOBAL.login_id, p_last_update_login),
121: L.LANGUAGE_CODE,

Line 119: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

115: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
116: NULL, FND_GLOBAL.user_id, p_last_updated_by),
117: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
118: p_last_update_date),
119: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
120: NULL, FND_GLOBAL.login_id, p_last_update_login),
121: L.LANGUAGE_CODE,
122: USERENV('LANG')
123: FROM FND_LANGUAGES L

Line 378: RAISE Fnd_Api.G_EXC_ERROR;

374: x_object_id => l_object_id)
375: THEN
376: Fnd_Message.Set_Name('IBC', 'IBC_INVALID_FOLDER_NAME');
377: Fnd_Msg_Pub.ADD;
378: RAISE Fnd_Api.G_EXC_ERROR;
379: END IF;
380: END LOOP;
381:
382: UPDATE IBC_DIRECTORY_NODES_B SET

Line 383: DIRECTORY_NODE_CODE = DECODE(p_DIRECTORY_NODE_CODE,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_NODE_CODE,p_DIRECTORY_NODE_CODE),

379: END IF;
380: END LOOP;
381:
382: UPDATE IBC_DIRECTORY_NODES_B SET
383: DIRECTORY_NODE_CODE = DECODE(p_DIRECTORY_NODE_CODE,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_NODE_CODE,p_DIRECTORY_NODE_CODE),
384: NODE_STATUS = DECODE(p_NODE_STATUS,FND_API.G_MISS_CHAR,NULL,NULL,NODE_STATUS,p_NODE_STATUS),
385: DIRECTORY_PATH = DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_PATH,p_DIRECTORY_PATH),
386: AVAILABLE_DATE = DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),
387: EXPIRATION_DATE = DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),

Line 384: NODE_STATUS = DECODE(p_NODE_STATUS,FND_API.G_MISS_CHAR,NULL,NULL,NODE_STATUS,p_NODE_STATUS),

380: END LOOP;
381:
382: UPDATE IBC_DIRECTORY_NODES_B SET
383: DIRECTORY_NODE_CODE = DECODE(p_DIRECTORY_NODE_CODE,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_NODE_CODE,p_DIRECTORY_NODE_CODE),
384: NODE_STATUS = DECODE(p_NODE_STATUS,FND_API.G_MISS_CHAR,NULL,NULL,NODE_STATUS,p_NODE_STATUS),
385: DIRECTORY_PATH = DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_PATH,p_DIRECTORY_PATH),
386: AVAILABLE_DATE = DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),
387: EXPIRATION_DATE = DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
388: HIDDEN_FLAG = DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,NULL,HIDDEN_FLAG,p_HIDDEN_FLAG),

Line 385: DIRECTORY_PATH = DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_PATH,p_DIRECTORY_PATH),

381:
382: UPDATE IBC_DIRECTORY_NODES_B SET
383: DIRECTORY_NODE_CODE = DECODE(p_DIRECTORY_NODE_CODE,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_NODE_CODE,p_DIRECTORY_NODE_CODE),
384: NODE_STATUS = DECODE(p_NODE_STATUS,FND_API.G_MISS_CHAR,NULL,NULL,NODE_STATUS,p_NODE_STATUS),
385: DIRECTORY_PATH = DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_PATH,p_DIRECTORY_PATH),
386: AVAILABLE_DATE = DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),
387: EXPIRATION_DATE = DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
388: HIDDEN_FLAG = DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,NULL,HIDDEN_FLAG,p_HIDDEN_FLAG),
389: NODE_TYPE = DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,NULL,NODE_TYPE,p_NODE_TYPE),

Line 386: AVAILABLE_DATE = DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),

382: UPDATE IBC_DIRECTORY_NODES_B SET
383: DIRECTORY_NODE_CODE = DECODE(p_DIRECTORY_NODE_CODE,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_NODE_CODE,p_DIRECTORY_NODE_CODE),
384: NODE_STATUS = DECODE(p_NODE_STATUS,FND_API.G_MISS_CHAR,NULL,NULL,NODE_STATUS,p_NODE_STATUS),
385: DIRECTORY_PATH = DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_PATH,p_DIRECTORY_PATH),
386: AVAILABLE_DATE = DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),
387: EXPIRATION_DATE = DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
388: HIDDEN_FLAG = DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,NULL,HIDDEN_FLAG,p_HIDDEN_FLAG),
389: NODE_TYPE = DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,NULL,NODE_TYPE,p_NODE_TYPE),
390: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,

Line 387: EXPIRATION_DATE = DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),

383: DIRECTORY_NODE_CODE = DECODE(p_DIRECTORY_NODE_CODE,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_NODE_CODE,p_DIRECTORY_NODE_CODE),
384: NODE_STATUS = DECODE(p_NODE_STATUS,FND_API.G_MISS_CHAR,NULL,NULL,NODE_STATUS,p_NODE_STATUS),
385: DIRECTORY_PATH = DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_PATH,p_DIRECTORY_PATH),
386: AVAILABLE_DATE = DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),
387: EXPIRATION_DATE = DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
388: HIDDEN_FLAG = DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,NULL,HIDDEN_FLAG,p_HIDDEN_FLAG),
389: NODE_TYPE = DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,NULL,NODE_TYPE,p_NODE_TYPE),
390: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
391: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,

Line 388: HIDDEN_FLAG = DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,NULL,HIDDEN_FLAG,p_HIDDEN_FLAG),

384: NODE_STATUS = DECODE(p_NODE_STATUS,FND_API.G_MISS_CHAR,NULL,NULL,NODE_STATUS,p_NODE_STATUS),
385: DIRECTORY_PATH = DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_PATH,p_DIRECTORY_PATH),
386: AVAILABLE_DATE = DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),
387: EXPIRATION_DATE = DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
388: HIDDEN_FLAG = DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,NULL,HIDDEN_FLAG,p_HIDDEN_FLAG),
389: NODE_TYPE = DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,NULL,NODE_TYPE,p_NODE_TYPE),
390: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
391: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
392: NULL, SYSDATE, p_last_update_date),

Line 389: NODE_TYPE = DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,NULL,NODE_TYPE,p_NODE_TYPE),

385: DIRECTORY_PATH = DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_PATH,p_DIRECTORY_PATH),
386: AVAILABLE_DATE = DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),
387: EXPIRATION_DATE = DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
388: HIDDEN_FLAG = DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,NULL,HIDDEN_FLAG,p_HIDDEN_FLAG),
389: NODE_TYPE = DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,NULL,NODE_TYPE,p_NODE_TYPE),
390: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
391: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
392: NULL, SYSDATE, p_last_update_date),
393: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,

Line 391: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,

387: EXPIRATION_DATE = DECODE(p_EXPIRATION_DATE,FND_API.G_MISS_DATE,NULL,p_EXPIRATION_DATE),
388: HIDDEN_FLAG = DECODE(p_HIDDEN_FLAG,FND_API.G_MISS_CHAR,NULL,NULL,HIDDEN_FLAG,p_HIDDEN_FLAG),
389: NODE_TYPE = DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,NULL,NODE_TYPE,p_NODE_TYPE),
390: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
391: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
392: NULL, SYSDATE, p_last_update_date),
393: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
394: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
395: p_last_updated_by),

Line 393: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,

389: NODE_TYPE = DECODE(p_NODE_TYPE,FND_API.G_MISS_CHAR,NULL,NULL,NODE_TYPE,p_NODE_TYPE),
390: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
391: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
392: NULL, SYSDATE, p_last_update_date),
393: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
394: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
395: p_last_updated_by),
396: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
397: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

Line 396: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,

392: NULL, SYSDATE, p_last_update_date),
393: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
394: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
395: p_last_updated_by),
396: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
397: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
398: p_last_update_login)
399: WHERE DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID;
400:

Line 402: -- FND_API.G_MISS_NUM, object_version_number,

398: p_last_update_login)
399: WHERE DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID;
400:
401: -- AND object_version_number = DECODE(p_object_version_number,
402: -- FND_API.G_MISS_NUM, object_version_number,
403: -- NULL, object_version_number,
404: -- p_object_version_number);
405:
406: IF (SQL%NOTFOUND) THEN

Line 411: DIRECTORY_NODE_NAME = DECODE(p_DIRECTORY_NODE_NAME,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_NODE_NAME,p_DIRECTORY_NODE_NAME),

407: RAISE NO_DATA_FOUND;
408: END IF;
409:
410: UPDATE IBC_DIRECTORY_NODES_TL SET
411: DIRECTORY_NODE_NAME = DECODE(p_DIRECTORY_NODE_NAME,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_NODE_NAME,p_DIRECTORY_NODE_NAME),
412: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
413: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
414: NULL, SYSDATE, p_last_update_date),
415: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,

Line 412: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),

408: END IF;
409:
410: UPDATE IBC_DIRECTORY_NODES_TL SET
411: DIRECTORY_NODE_NAME = DECODE(p_DIRECTORY_NODE_NAME,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_NODE_NAME,p_DIRECTORY_NODE_NAME),
412: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
413: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
414: NULL, SYSDATE, p_last_update_date),
415: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
416: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

Line 413: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,

409:
410: UPDATE IBC_DIRECTORY_NODES_TL SET
411: DIRECTORY_NODE_NAME = DECODE(p_DIRECTORY_NODE_NAME,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_NODE_NAME,p_DIRECTORY_NODE_NAME),
412: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
413: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
414: NULL, SYSDATE, p_last_update_date),
415: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
416: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
417: p_last_updated_by),

Line 415: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,

411: DIRECTORY_NODE_NAME = DECODE(p_DIRECTORY_NODE_NAME,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_NODE_NAME,p_DIRECTORY_NODE_NAME),
412: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
413: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
414: NULL, SYSDATE, p_last_update_date),
415: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
416: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
417: p_last_updated_by),
418: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
419: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

Line 418: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,

414: NULL, SYSDATE, p_last_update_date),
415: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
416: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
417: p_last_updated_by),
418: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
419: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
420: p_last_update_login),
421: SOURCE_LANG = USERENV('LANG')
422: WHERE DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID

Line 601: p_NODE_TYPE => nvl(p_NODE_TYPE,FND_API.G_MISS_CHAR),

597: db_user_id, db_last_update_date, p_upload_mode )) THEN
598:
599: Ibc_Directory_Nodes_Pkg.UPDATE_ROW (
600: p_DIRECTORY_NODE_ID => p_DIRECTORY_NODE_ID,
601: p_NODE_TYPE => nvl(p_NODE_TYPE,FND_API.G_MISS_CHAR),
602: p_NODE_STATUS => nvl(p_NODE_STATUS,FND_API.G_MISS_CHAR),
603: p_DIRECTORY_PATH => nvl(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR),
604: p_AVAILABLE_DATE => nvl(p_AVAILABLE_DATE, FND_API.G_MISS_DATE),
605: p_EXPIRATION_DATE => nvl(p_EXPIRATION_DATE, FND_API.G_MISS_DATE),

Line 602: p_NODE_STATUS => nvl(p_NODE_STATUS,FND_API.G_MISS_CHAR),

598:
599: Ibc_Directory_Nodes_Pkg.UPDATE_ROW (
600: p_DIRECTORY_NODE_ID => p_DIRECTORY_NODE_ID,
601: p_NODE_TYPE => nvl(p_NODE_TYPE,FND_API.G_MISS_CHAR),
602: p_NODE_STATUS => nvl(p_NODE_STATUS,FND_API.G_MISS_CHAR),
603: p_DIRECTORY_PATH => nvl(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR),
604: p_AVAILABLE_DATE => nvl(p_AVAILABLE_DATE, FND_API.G_MISS_DATE),
605: p_EXPIRATION_DATE => nvl(p_EXPIRATION_DATE, FND_API.G_MISS_DATE),
606: p_HIDDEN_FLAG => nvl(p_HIDDEN_FLAG, FND_API.g_MISS_CHAR),

Line 603: p_DIRECTORY_PATH => nvl(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR),

599: Ibc_Directory_Nodes_Pkg.UPDATE_ROW (
600: p_DIRECTORY_NODE_ID => p_DIRECTORY_NODE_ID,
601: p_NODE_TYPE => nvl(p_NODE_TYPE,FND_API.G_MISS_CHAR),
602: p_NODE_STATUS => nvl(p_NODE_STATUS,FND_API.G_MISS_CHAR),
603: p_DIRECTORY_PATH => nvl(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR),
604: p_AVAILABLE_DATE => nvl(p_AVAILABLE_DATE, FND_API.G_MISS_DATE),
605: p_EXPIRATION_DATE => nvl(p_EXPIRATION_DATE, FND_API.G_MISS_DATE),
606: p_HIDDEN_FLAG => nvl(p_HIDDEN_FLAG, FND_API.g_MISS_CHAR),
607: p_DIRECTORY_NODE_CODE => p_DIRECTORY_NODE_CODE,

Line 604: p_AVAILABLE_DATE => nvl(p_AVAILABLE_DATE, FND_API.G_MISS_DATE),

600: p_DIRECTORY_NODE_ID => p_DIRECTORY_NODE_ID,
601: p_NODE_TYPE => nvl(p_NODE_TYPE,FND_API.G_MISS_CHAR),
602: p_NODE_STATUS => nvl(p_NODE_STATUS,FND_API.G_MISS_CHAR),
603: p_DIRECTORY_PATH => nvl(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR),
604: p_AVAILABLE_DATE => nvl(p_AVAILABLE_DATE, FND_API.G_MISS_DATE),
605: p_EXPIRATION_DATE => nvl(p_EXPIRATION_DATE, FND_API.G_MISS_DATE),
606: p_HIDDEN_FLAG => nvl(p_HIDDEN_FLAG, FND_API.g_MISS_CHAR),
607: p_DIRECTORY_NODE_CODE => p_DIRECTORY_NODE_CODE,
608: p_DIRECTORY_NODE_NAME => nvl(p_DIRECTORY_NODE_NAME,FND_API.G_MISS_CHAR),

Line 605: p_EXPIRATION_DATE => nvl(p_EXPIRATION_DATE, FND_API.G_MISS_DATE),

601: p_NODE_TYPE => nvl(p_NODE_TYPE,FND_API.G_MISS_CHAR),
602: p_NODE_STATUS => nvl(p_NODE_STATUS,FND_API.G_MISS_CHAR),
603: p_DIRECTORY_PATH => nvl(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR),
604: p_AVAILABLE_DATE => nvl(p_AVAILABLE_DATE, FND_API.G_MISS_DATE),
605: p_EXPIRATION_DATE => nvl(p_EXPIRATION_DATE, FND_API.G_MISS_DATE),
606: p_HIDDEN_FLAG => nvl(p_HIDDEN_FLAG, FND_API.g_MISS_CHAR),
607: p_DIRECTORY_NODE_CODE => p_DIRECTORY_NODE_CODE,
608: p_DIRECTORY_NODE_NAME => nvl(p_DIRECTORY_NODE_NAME,FND_API.G_MISS_CHAR),
609: p_DESCRIPTION => nvl(p_DESCRIPTION,FND_API.G_MISS_CHAR),

Line 606: p_HIDDEN_FLAG => nvl(p_HIDDEN_FLAG, FND_API.g_MISS_CHAR),

602: p_NODE_STATUS => nvl(p_NODE_STATUS,FND_API.G_MISS_CHAR),
603: p_DIRECTORY_PATH => nvl(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR),
604: p_AVAILABLE_DATE => nvl(p_AVAILABLE_DATE, FND_API.G_MISS_DATE),
605: p_EXPIRATION_DATE => nvl(p_EXPIRATION_DATE, FND_API.G_MISS_DATE),
606: p_HIDDEN_FLAG => nvl(p_HIDDEN_FLAG, FND_API.g_MISS_CHAR),
607: p_DIRECTORY_NODE_CODE => p_DIRECTORY_NODE_CODE,
608: p_DIRECTORY_NODE_NAME => nvl(p_DIRECTORY_NODE_NAME,FND_API.G_MISS_CHAR),
609: p_DESCRIPTION => nvl(p_DESCRIPTION,FND_API.G_MISS_CHAR),
610: p_LAST_UPDATED_BY => l_user_id,

Line 608: p_DIRECTORY_NODE_NAME => nvl(p_DIRECTORY_NODE_NAME,FND_API.G_MISS_CHAR),

604: p_AVAILABLE_DATE => nvl(p_AVAILABLE_DATE, FND_API.G_MISS_DATE),
605: p_EXPIRATION_DATE => nvl(p_EXPIRATION_DATE, FND_API.G_MISS_DATE),
606: p_HIDDEN_FLAG => nvl(p_HIDDEN_FLAG, FND_API.g_MISS_CHAR),
607: p_DIRECTORY_NODE_CODE => p_DIRECTORY_NODE_CODE,
608: p_DIRECTORY_NODE_NAME => nvl(p_DIRECTORY_NODE_NAME,FND_API.G_MISS_CHAR),
609: p_DESCRIPTION => nvl(p_DESCRIPTION,FND_API.G_MISS_CHAR),
610: p_LAST_UPDATED_BY => l_user_id,
611: p_LAST_UPDATE_DATE => l_last_update_date,
612: p_LAST_UPDATE_LOGIN => 0,

Line 609: p_DESCRIPTION => nvl(p_DESCRIPTION,FND_API.G_MISS_CHAR),

605: p_EXPIRATION_DATE => nvl(p_EXPIRATION_DATE, FND_API.G_MISS_DATE),
606: p_HIDDEN_FLAG => nvl(p_HIDDEN_FLAG, FND_API.g_MISS_CHAR),
607: p_DIRECTORY_NODE_CODE => p_DIRECTORY_NODE_CODE,
608: p_DIRECTORY_NODE_NAME => nvl(p_DIRECTORY_NODE_NAME,FND_API.G_MISS_CHAR),
609: p_DESCRIPTION => nvl(p_DESCRIPTION,FND_API.G_MISS_CHAR),
610: p_LAST_UPDATED_BY => l_user_id,
611: p_LAST_UPDATE_DATE => l_last_update_date,
612: p_LAST_UPDATE_LOGIN => 0,
613: p_OBJECT_VERSION_NUMBER => NULL