DBA Data[Home] [Help]

APPS.PV_GQ_ELEMENTS_PKG dependencies on FND_GLOBAL

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

91: DECODE( p_qsnr_elmt_type, FND_API.g_miss_char, NULL, p_qsnr_elmt_type),
92: DECODE( p_entity_attr_id, FND_API.G_MISS_NUM, NULL, p_entity_attr_id),
93: DECODE( p_qsnr_elmt_page_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_page_num),
94: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

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

93: DECODE( p_qsnr_elmt_page_num, FND_API.G_MISS_NUM, NULL, p_qsnr_elmt_page_num),
94: DECODE( p_is_required_flag, FND_API.g_miss_char, NULL, p_is_required_flag),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
100:
101: INSERT INTO pv_ge_qsnr_elements_tl(

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

95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
100:
101: INSERT INTO pv_ge_qsnr_elements_tl(
102: qsnr_element_id ,
103: --object_version_number,

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

114: DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id),
115: --DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
116: l.language_code,
117: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
120: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
121: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
122: USERENV('LANG'),

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

116: l.language_code,
117: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
120: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
121: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
122: USERENV('LANG'),
123: DECODE( p_elmt_content, FND_API.G_MISS_CHAR, NULL, p_elmt_content)
124: FROM fnd_languages l

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

117: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
118: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
119: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
120: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
121: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
122: USERENV('LANG'),
123: DECODE( p_elmt_content, FND_API.G_MISS_CHAR, NULL, p_elmt_content)
124: FROM fnd_languages l
125: WHERE l.installed_flag IN ('I','B')