APPS.IBC_CTYPE_GROUP_NODES_PKG dependencies on FND_GLOBAL

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

51: p_DIRECTORY_NODE_ID,
52: p_OBJECT_VERSION_NUMBER,
53: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
54: p_creation_date),
55: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
56: NULL, FND_GLOBAL.user_id, p_created_by),
57: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
58: p_last_update_date),
59: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 56: NULL, FND_GLOBAL.user_id, p_created_by),

52: p_OBJECT_VERSION_NUMBER,
53: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
54: p_creation_date),
55: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
56: NULL, FND_GLOBAL.user_id, p_created_by),
57: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
58: p_last_update_date),
59: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
60: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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

55: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
56: NULL, FND_GLOBAL.user_id, p_created_by),
57: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
58: p_last_update_date),
59: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
60: NULL, FND_GLOBAL.user_id, p_last_updated_by),
61: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
62: NULL, FND_GLOBAL.login_id, p_last_update_login)
63: );

Line 60: NULL, FND_GLOBAL.user_id, p_last_updated_by),

56: NULL, FND_GLOBAL.user_id, p_created_by),
57: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
58: p_last_update_date),
59: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
60: NULL, FND_GLOBAL.user_id, p_last_updated_by),
61: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
62: NULL, FND_GLOBAL.login_id, p_last_update_login)
63: );
64:

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

57: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
58: p_last_update_date),
59: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
60: NULL, FND_GLOBAL.user_id, p_last_updated_by),
61: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
62: NULL, FND_GLOBAL.login_id, p_last_update_login)
63: );
64:
65: OPEN c;

Line 62: NULL, FND_GLOBAL.login_id, p_last_update_login)

58: p_last_update_date),
59: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
60: NULL, FND_GLOBAL.user_id, p_last_updated_by),
61: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
62: NULL, FND_GLOBAL.login_id, p_last_update_login)
63: );
64:
65: OPEN c;
66: FETCH c INTO x_ROWID;

Line 93: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

89: DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID,
90: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
91: NULL, SYSDATE, p_last_update_date),
92: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
93: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
94: p_last_updated_by),
95: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
96: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
97: p_last_update_login)

Line 96: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

92: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
93: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
94: p_last_updated_by),
95: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
96: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
97: p_last_update_login)
98: WHERE CTYPE_GROUP_NODE_ID = p_CTYPE_GROUP_NODE_ID;
99:
100: IF (SQL%NOTFOUND) THEN