DBA Data[Home] [Help]

APPS.OZF_OFFR_QUAL_PVT dependencies on FND_GLOBAL

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

23:
24: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Offr_Qual_PVT';
25: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvoqfb.pls';
26:
27: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
28: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
29: --
30: -- Foreward Procedure Declarations
31: --

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

24: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Offr_Qual_PVT';
25: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvoqfb.pls';
26:
27: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
28: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
29: --
30: -- Foreward Procedure Declarations
31: --
32:

Line 139: IF FND_GLOBAL.USER_ID IS NULL

135: -- =========================================================================
136: -- Validate Environment
137: -- =========================================================================
138:
139: IF FND_GLOBAL.USER_ID IS NULL
140: THEN
141: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
142: RAISE FND_API.G_EXC_ERROR;
143: END IF;

Line 199: p_created_by => FND_GLOBAL.USER_ID,

195: -- Invoke table handler(Ozf_Offr_Qual_Pkg.Insert_Row)
196: Ozf_Offr_Qual_Pkg.Insert_Row(
197: px_qualifier_id => l_qualifier_id,
198: p_creation_date => SYSDATE,
199: p_created_by => FND_GLOBAL.USER_ID,
200: p_last_update_date => SYSDATE,
201: p_last_updated_by => FND_GLOBAL.USER_ID,
202: p_last_update_login => FND_GLOBAL.conc_login_id,
203: p_qualifier_grouping_no => p_ozf_offr_qual_rec.qualifier_grouping_no,

Line 201: p_last_updated_by => FND_GLOBAL.USER_ID,

197: px_qualifier_id => l_qualifier_id,
198: p_creation_date => SYSDATE,
199: p_created_by => FND_GLOBAL.USER_ID,
200: p_last_update_date => SYSDATE,
201: p_last_updated_by => FND_GLOBAL.USER_ID,
202: p_last_update_login => FND_GLOBAL.conc_login_id,
203: p_qualifier_grouping_no => p_ozf_offr_qual_rec.qualifier_grouping_no,
204: p_qualifier_context => p_ozf_offr_qual_rec.qualifier_context,
205: p_qualifier_attribute => p_ozf_offr_qual_rec.qualifier_attribute,

Line 202: p_last_update_login => FND_GLOBAL.conc_login_id,

198: p_creation_date => SYSDATE,
199: p_created_by => FND_GLOBAL.USER_ID,
200: p_last_update_date => SYSDATE,
201: p_last_updated_by => FND_GLOBAL.USER_ID,
202: p_last_update_login => FND_GLOBAL.conc_login_id,
203: p_qualifier_grouping_no => p_ozf_offr_qual_rec.qualifier_grouping_no,
204: p_qualifier_context => p_ozf_offr_qual_rec.qualifier_context,
205: p_qualifier_attribute => p_ozf_offr_qual_rec.qualifier_attribute,
206: p_qualifier_attr_value => p_ozf_offr_qual_rec.qualifier_attr_value,

Line 454: p_last_updated_by => FND_GLOBAL.USER_ID,

450: -- Invoke table handler(Ozf_Offr_Qual_Pkg.Update_Row)
451: Ozf_Offr_Qual_Pkg.Update_Row(
452: p_qualifier_id => p_ozf_offr_qual_rec.qualifier_id,
453: p_last_update_date => SYSDATE,
454: p_last_updated_by => FND_GLOBAL.USER_ID,
455: p_last_update_login => FND_GLOBAL.conc_login_id,
456: p_qualifier_grouping_no => p_ozf_offr_qual_rec.qualifier_grouping_no,
457: p_qualifier_context => p_ozf_offr_qual_rec.qualifier_context,
458: p_qualifier_attribute => p_ozf_offr_qual_rec.qualifier_attribute,

Line 455: p_last_update_login => FND_GLOBAL.conc_login_id,

451: Ozf_Offr_Qual_Pkg.Update_Row(
452: p_qualifier_id => p_ozf_offr_qual_rec.qualifier_id,
453: p_last_update_date => SYSDATE,
454: p_last_updated_by => FND_GLOBAL.USER_ID,
455: p_last_update_login => FND_GLOBAL.conc_login_id,
456: p_qualifier_grouping_no => p_ozf_offr_qual_rec.qualifier_grouping_no,
457: p_qualifier_context => p_ozf_offr_qual_rec.qualifier_context,
458: p_qualifier_attribute => p_ozf_offr_qual_rec.qualifier_attribute,
459: p_qualifier_attr_value => p_ozf_offr_qual_rec.qualifier_attr_value,