19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Offer_Adj_Tier_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'offvadjb.pls';
22:
23: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
24: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
25: --
26: -- Foreward Procedure Declarations
27: --
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Offer_Adj_Tier_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'offvadjb.pls';
22:
23: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
24: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
25: --
26: -- Foreward Procedure Declarations
27: --
28:
130: -- =========================================================================
131: -- Validate Environment
132: -- =========================================================================
133:
134: IF FND_GLOBAL.USER_ID IS NULL
135: THEN
136: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
137: RAISE FND_API.G_EXC_ERROR;
138: END IF;
191: p_original_discount => p_offadj_tier_rec.original_discount,
192: p_modified_discount => p_offadj_tier_rec.modified_discount,
193: p_offer_discount_line_id => p_offadj_tier_rec.offer_discount_line_id,
194: p_last_update_date => SYSDATE,
195: p_last_updated_by => FND_GLOBAL.USER_ID,
196: p_creation_date => SYSDATE,
197: p_created_by => FND_GLOBAL.USER_ID,
198: p_last_update_login => FND_GLOBAL.conc_login_id,
199: px_object_version_number => l_object_version_number
193: p_offer_discount_line_id => p_offadj_tier_rec.offer_discount_line_id,
194: p_last_update_date => SYSDATE,
195: p_last_updated_by => FND_GLOBAL.USER_ID,
196: p_creation_date => SYSDATE,
197: p_created_by => FND_GLOBAL.USER_ID,
198: p_last_update_login => FND_GLOBAL.conc_login_id,
199: px_object_version_number => l_object_version_number
200: );
201:
194: p_last_update_date => SYSDATE,
195: p_last_updated_by => FND_GLOBAL.USER_ID,
196: p_creation_date => SYSDATE,
197: p_created_by => FND_GLOBAL.USER_ID,
198: p_last_update_login => FND_GLOBAL.conc_login_id,
199: px_object_version_number => l_object_version_number
200: );
201:
202: x_offer_adjst_tier_id := l_offer_adjst_tier_id;
432: p_original_discount => p_offadj_tier_rec.original_discount,
433: p_modified_discount => p_offadj_tier_rec.modified_discount,
434: p_offer_discount_line_id => p_offadj_tier_rec.offer_discount_line_id,
435: p_last_update_date => SYSDATE,
436: p_last_updated_by => FND_GLOBAL.USER_ID,
437: p_last_update_login => FND_GLOBAL.conc_login_id,
438: px_object_version_number => l_object_version_number
439: );
440: x_object_version_number := l_object_version_number;
433: p_modified_discount => p_offadj_tier_rec.modified_discount,
434: p_offer_discount_line_id => p_offadj_tier_rec.offer_discount_line_id,
435: p_last_update_date => SYSDATE,
436: p_last_updated_by => FND_GLOBAL.USER_ID,
437: p_last_update_login => FND_GLOBAL.conc_login_id,
438: px_object_version_number => l_object_version_number
439: );
440: x_object_version_number := l_object_version_number;
441: --