APPS.IBC_STYLESHEETS_PKG dependencies on FND_GLOBAL

Line 50: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

46: p_default_stylesheet_flag,
47: p_OBJECT_VERSION_NUMBER,
48: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
49: p_creation_date),
50: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
51: NULL, Fnd_Global.user_id, p_created_by),
52: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
53: p_last_update_date),
54: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

Line 51: NULL, Fnd_Global.user_id, p_created_by),

47: p_OBJECT_VERSION_NUMBER,
48: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
49: p_creation_date),
50: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
51: NULL, Fnd_Global.user_id, p_created_by),
52: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
53: p_last_update_date),
54: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
55: NULL, Fnd_Global.user_id, p_last_updated_by),

Line 54: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

50: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
51: NULL, Fnd_Global.user_id, p_created_by),
52: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
53: p_last_update_date),
54: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
55: NULL, Fnd_Global.user_id, p_last_updated_by),
56: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
57: NULL, Fnd_Global.login_id, p_last_update_login)
58: );

Line 55: NULL, Fnd_Global.user_id, p_last_updated_by),

51: NULL, Fnd_Global.user_id, p_created_by),
52: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
53: p_last_update_date),
54: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
55: NULL, Fnd_Global.user_id, p_last_updated_by),
56: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
57: NULL, Fnd_Global.login_id, p_last_update_login)
58: );
59:

Line 56: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,

52: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
53: p_last_update_date),
54: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
55: NULL, Fnd_Global.user_id, p_last_updated_by),
56: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
57: NULL, Fnd_Global.login_id, p_last_update_login)
58: );
59:
60: OPEN c;

Line 57: NULL, Fnd_Global.login_id, p_last_update_login)

53: p_last_update_date),
54: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
55: NULL, Fnd_Global.user_id, p_last_updated_by),
56: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
57: NULL, Fnd_Global.login_id, p_last_update_login)
58: );
59:
60: OPEN c;
61: FETCH c INTO x_ROWID;

Line 120: Fnd_Global.user_id, NULL, Fnd_Global.user_id,

116: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
117: last_update_date = DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE,
118: NULL, SYSDATE, p_last_update_date),
119: last_updated_by = DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM,
120: Fnd_Global.user_id, NULL, Fnd_Global.user_id,
121: p_last_updated_by),
122: last_update_login = DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM,
123: Fnd_Global.login_id, NULL, Fnd_Global.login_id,
124: p_last_update_login)

Line 123: Fnd_Global.login_id, NULL, Fnd_Global.login_id,

119: last_updated_by = DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM,
120: Fnd_Global.user_id, NULL, Fnd_Global.user_id,
121: p_last_updated_by),
122: last_update_login = DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM,
123: Fnd_Global.login_id, NULL, Fnd_Global.login_id,
124: p_last_update_login)
125: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
126: AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
127: AND object_version_number = DECODE(p_object_version_number,