APPS.PV_GE_CHKLST_PKG dependencies on FND_GLOBAL

Line 91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

87: DECODE( p_used_by_entity_id, FND_API.G_MISS_NUM, NULL, p_used_by_entity_id),
88: DECODE( p_sequence_num, FND_API.G_MISS_NUM, NULL, p_sequence_num),
89: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
94: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
95: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

Line 93: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

89: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
90: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
94: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
95: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
96:
97: INSERT INTO pv_ge_chklst_items_tl(

Line 95: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
93: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
94: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
95: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
96:
97: INSERT INTO pv_ge_chklst_items_tl(
98: checklist_item_id ,
99: language ,

Line 112: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),

108: SELECT
109: DECODE( px_checklist_item_id, FND_API.G_MISS_NUM, NULL, px_checklist_item_id),
110: l.language_code,
111: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
112: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
113: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
114: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
115: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
116: USERENV('LANG'),

Line 114: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),

110: l.language_code,
111: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
112: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
113: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
114: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
115: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
116: USERENV('LANG'),
117: DECODE( p_checklist_item_name , FND_API.G_MISS_CHAR, NULL, p_checklist_item_name)
118: FROM fnd_languages l

Line 115: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

111: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
112: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
113: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
114: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
115: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
116: USERENV('LANG'),
117: DECODE( p_checklist_item_name , FND_API.G_MISS_CHAR, NULL, p_checklist_item_name)
118: FROM fnd_languages l
119: WHERE l.installed_flag IN ('I','B')