APPS.IBC_DIRECTORY_NODES_PKG dependencies on FND_GLOBAL

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 87: NULL, FND_GLOBAL.user_id, p_created_by),

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,
91: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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 91: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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: );
95:

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 93: NULL, FND_GLOBAL.login_id, p_last_update_login)

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 (
97: DIRECTORY_NODE_ID,

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 112: NULL, FND_GLOBAL.user_id, p_created_by),

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,
116: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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 116: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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,
120: NULL, FND_GLOBAL.login_id, p_last_update_login),

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 120: NULL, FND_GLOBAL.login_id, p_last_update_login),

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
124: WHERE L.INSTALLED_FLAG IN ('I', 'B')

Line 394: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

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,
398: p_last_update_login)

Line 397: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

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:
401: -- AND object_version_number = DECODE(p_object_version_number,

Line 416: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

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,
420: p_last_update_login),

Line 419: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

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
423: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);