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: --
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:
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;
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,
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,
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,
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,
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,