DBA Data[Home] [Help]

APPS.PV_GQ_ELEMENTS_PVT dependencies on FND_GLOBAL

Line 34: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

30:
31: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Gq_Elements_PVT';
32: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvgqeb.pls';
33:
34: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
35: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
36: --
37: -- Foreward Procedure Declarations
38: --

Line 35: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

31: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_Gq_Elements_PVT';
32: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvgqeb.pls';
33:
34: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
35: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
36: --
37: -- Foreward Procedure Declarations
38: --
39:

Line 173: IF FND_GLOBAL.USER_ID IS NULL

169: -- =========================================================================
170: -- Validate Environment
171: -- =========================================================================
172:
173: IF FND_GLOBAL.USER_ID IS NULL
174: THEN
175: PVX_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;

Line 191: l_qsnr_element_rec.last_updated_by := FND_GLOBAL.user_id;

187: END IF;
188:
189: -- Populate the default required items
190: l_qsnr_element_rec.last_update_date := SYSDATE;
191: l_qsnr_element_rec.last_updated_by := FND_GLOBAL.user_id;
192: l_qsnr_element_rec.creation_date := SYSDATE;
193: l_qsnr_element_rec.created_by := FND_GLOBAL.user_id;
194: l_qsnr_element_rec.last_update_login := FND_GLOBAL.conc_login_id;
195: l_qsnr_element_rec.object_version_number := l_object_version_number;

Line 193: l_qsnr_element_rec.created_by := FND_GLOBAL.user_id;

189: -- Populate the default required items
190: l_qsnr_element_rec.last_update_date := SYSDATE;
191: l_qsnr_element_rec.last_updated_by := FND_GLOBAL.user_id;
192: l_qsnr_element_rec.creation_date := SYSDATE;
193: l_qsnr_element_rec.created_by := FND_GLOBAL.user_id;
194: l_qsnr_element_rec.last_update_login := FND_GLOBAL.conc_login_id;
195: l_qsnr_element_rec.object_version_number := l_object_version_number;
196:
197: -- Invoke validation procedures

Line 194: l_qsnr_element_rec.last_update_login := FND_GLOBAL.conc_login_id;

190: l_qsnr_element_rec.last_update_date := SYSDATE;
191: l_qsnr_element_rec.last_updated_by := FND_GLOBAL.user_id;
192: l_qsnr_element_rec.creation_date := SYSDATE;
193: l_qsnr_element_rec.created_by := FND_GLOBAL.user_id;
194: l_qsnr_element_rec.last_update_login := FND_GLOBAL.conc_login_id;
195: l_qsnr_element_rec.object_version_number := l_object_version_number;
196:
197: -- Invoke validation procedures
198: Validate_gq_elements(

Line 232: p_created_by => FND_GLOBAL.USER_ID,

228: p_qsnr_elmt_type => l_qsnr_element_rec.qsnr_elmt_type,
229: p_entity_attr_id => l_qsnr_element_rec.entity_attr_id,
230: p_qsnr_elmt_page_num => l_qsnr_element_rec.qsnr_elmt_page_num,
231: p_is_required_flag => l_qsnr_element_rec.is_required_flag,
232: p_created_by => FND_GLOBAL.USER_ID,
233: p_creation_date => SYSDATE,
234: p_last_updated_by => FND_GLOBAL.USER_ID,
235: p_last_update_date => SYSDATE,
236: p_last_update_login => FND_GLOBAL.conc_login_id,

Line 234: p_last_updated_by => FND_GLOBAL.USER_ID,

230: p_qsnr_elmt_page_num => l_qsnr_element_rec.qsnr_elmt_page_num,
231: p_is_required_flag => l_qsnr_element_rec.is_required_flag,
232: p_created_by => FND_GLOBAL.USER_ID,
233: p_creation_date => SYSDATE,
234: p_last_updated_by => FND_GLOBAL.USER_ID,
235: p_last_update_date => SYSDATE,
236: p_last_update_login => FND_GLOBAL.conc_login_id,
237: p_elmt_content => l_qsnr_element_rec.elmt_content
238: );

Line 236: p_last_update_login => FND_GLOBAL.conc_login_id,

232: p_created_by => FND_GLOBAL.USER_ID,
233: p_creation_date => SYSDATE,
234: p_last_updated_by => FND_GLOBAL.USER_ID,
235: p_last_update_date => SYSDATE,
236: p_last_update_login => FND_GLOBAL.conc_login_id,
237: p_elmt_content => l_qsnr_element_rec.elmt_content
238: );
239:
240: x_qsnr_element_id := l_qsnr_element_id;

Line 490: FND_GLOBAL.USER_ID,

486: qsnr_elmt_type_array(i),
487: entity_attr_id_array(i),
488: qsnr_elmt_page_num_array(i),
489: is_required_flag_array(i),
490: FND_GLOBAL.USER_ID,
491: SYSDATE,
492: FND_GLOBAL.USER_ID,
493: SYSDATE,
494: FND_GLOBAL.CONC_LOGIN_ID

Line 492: FND_GLOBAL.USER_ID,

488: qsnr_elmt_page_num_array(i),
489: is_required_flag_array(i),
490: FND_GLOBAL.USER_ID,
491: SYSDATE,
492: FND_GLOBAL.USER_ID,
493: SYSDATE,
494: FND_GLOBAL.CONC_LOGIN_ID
495: );
496:

Line 494: FND_GLOBAL.CONC_LOGIN_ID

490: FND_GLOBAL.USER_ID,
491: SYSDATE,
492: FND_GLOBAL.USER_ID,
493: SYSDATE,
494: FND_GLOBAL.CONC_LOGIN_ID
495: );
496:
497:
498: exit when c_get_qsnr_element_rec%notfound;

Line 538: FND_GLOBAL.USER_ID,

534: (
535: new_qsnr_element_id_array(j),
536: language_array(j),
537: SYSDATE,
538: FND_GLOBAL.USER_ID,
539: SYSDATE,
540: FND_GLOBAL.USER_ID,
541: FND_GLOBAL.CONC_LOGIN_ID,
542: source_lang_array(j),

Line 540: FND_GLOBAL.USER_ID,

536: language_array(j),
537: SYSDATE,
538: FND_GLOBAL.USER_ID,
539: SYSDATE,
540: FND_GLOBAL.USER_ID,
541: FND_GLOBAL.CONC_LOGIN_ID,
542: source_lang_array(j),
543: elmt_content_array(j)
544: );

Line 541: FND_GLOBAL.CONC_LOGIN_ID,

537: SYSDATE,
538: FND_GLOBAL.USER_ID,
539: SYSDATE,
540: FND_GLOBAL.USER_ID,
541: FND_GLOBAL.CONC_LOGIN_ID,
542: source_lang_array(j),
543: elmt_content_array(j)
544: );
545:

Line 568: LAST_UPDATED_BY = FND_GLOBAL.user_id,

564: set
565: QSNR_TITLE = QSNR_TITLE_ARRAY(i),
566: QSNR_HEADER = QSNR_HEADER_ARRAY(i),
567: QSNR_FOOTER = QSNR_FOOTER_ARRAY(i),
568: LAST_UPDATED_BY = FND_GLOBAL.user_id,
569: LAST_UPDATE_DATE = sysdate,
570: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
571: where program_id = p_tar_object_id
572: and LANGUAGE = PRGM_LANGUAGE_ARRAY(i);

Line 570: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id

566: QSNR_HEADER = QSNR_HEADER_ARRAY(i),
567: QSNR_FOOTER = QSNR_FOOTER_ARRAY(i),
568: LAST_UPDATED_BY = FND_GLOBAL.user_id,
569: LAST_UPDATE_DATE = sysdate,
570: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
571: where program_id = p_tar_object_id
572: and LANGUAGE = PRGM_LANGUAGE_ARRAY(i);
573:
574: exit when c_get_additional_tl_info%notfound;

Line 855: p_last_updated_by => FND_GLOBAL.USER_ID,

851: p_qsnr_elmt_type => p_qsnr_element_rec.qsnr_elmt_type,
852: p_entity_attr_id => p_qsnr_element_rec.entity_attr_id,
853: p_qsnr_elmt_page_num => p_qsnr_element_rec.qsnr_elmt_page_num,
854: p_is_required_flag => p_qsnr_element_rec.is_required_flag,
855: p_last_updated_by => FND_GLOBAL.USER_ID,
856: p_last_update_date => SYSDATE,
857: p_last_update_login => FND_GLOBAL.conc_login_id,
858: p_elmt_content => p_qsnr_element_rec.elmt_content
859: );

Line 857: p_last_update_login => FND_GLOBAL.conc_login_id,

853: p_qsnr_elmt_page_num => p_qsnr_element_rec.qsnr_elmt_page_num,
854: p_is_required_flag => p_qsnr_element_rec.is_required_flag,
855: p_last_updated_by => FND_GLOBAL.USER_ID,
856: p_last_update_date => SYSDATE,
857: p_last_update_login => FND_GLOBAL.conc_login_id,
858: p_elmt_content => p_qsnr_element_rec.elmt_content
859: );
860: x_object_version_number := l_object_version_number;
861: --