APPS.IBC_CTYPE_GROUP_NODES_PKG dependencies on FND_API

Line 31: (px_CTYPE_GROUP_NODE_ID = FND_API.G_MISS_NUM))

27: BEGIN
28:
29: -- Primary key validation check
30: IF ((px_CTYPE_GROUP_NODE_ID IS NULL) OR
31: (px_CTYPE_GROUP_NODE_ID = FND_API.G_MISS_NUM))
32: THEN
33: OPEN c2;
34: FETCH c2 INTO px_CTYPE_GROUP_NODE_ID;
35: CLOSE c2;

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

49: px_CTYPE_GROUP_NODE_ID,
50: p_CONTENT_TYPE_CODE,
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,

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 57: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

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),
61: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

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 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 90: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,

86: BEGIN
87: UPDATE IBC_CTYPE_GROUP_NODES SET
88: CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE,
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),

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

88: CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE,
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,

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

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)
98: WHERE CTYPE_GROUP_NODE_ID = p_CTYPE_GROUP_NODE_ID;
99: