DBA Data[Home] [Help]

APPS.OZF_DISC_LINE_PVT dependencies on FND_GLOBAL

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

29: -- Thu Apr 06 2006:4/41 PM RSSHARMA Fixed bug # 5142859. Added Null Currency validation. DOnt allow amount discount if currency is null
30: -- ===============================================================
31: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Disc_Line_PVT';
32: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvodlb.pls';
33: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
34: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
35: --
36: --======================Discount Line Methods ========================================
37: -- Hint: Primary key needs to be returned.

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

30: -- ===============================================================
31: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Disc_Line_PVT';
32: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvodlb.pls';
33: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
34: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
35: --
36: --======================Discount Line Methods ========================================
37: -- Hint: Primary key needs to be returned.
38: -- ==============================================================================

Line 1002: IF FND_GLOBAL.USER_ID IS NULL

998: -- =========================================================================
999: -- Validate Environment
1000: -- =========================================================================
1001:
1002: IF FND_GLOBAL.USER_ID IS NULL
1003: THEN
1004: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1005: RAISE FND_API.G_EXC_ERROR;
1006: END IF;

Line 1079: p_created_by => FND_GLOBAL.USER_ID,

1075: p_start_date_active => l_ozf_offer_line_rec.start_date_active,
1076: p_end_date_active => l_ozf_offer_line_rec.end_date_active,
1077: p_uom_code => l_ozf_offer_line_rec.uom_code,
1078: p_creation_date => SYSDATE,
1079: p_created_by => FND_GLOBAL.USER_ID,
1080: p_last_update_date => SYSDATE,
1081: p_last_updated_by => FND_GLOBAL.USER_ID,
1082: p_last_update_login => FND_GLOBAL.conc_login_id,
1083: px_object_version_number => l_object_version_number,

Line 1081: p_last_updated_by => FND_GLOBAL.USER_ID,

1077: p_uom_code => l_ozf_offer_line_rec.uom_code,
1078: p_creation_date => SYSDATE,
1079: p_created_by => FND_GLOBAL.USER_ID,
1080: p_last_update_date => SYSDATE,
1081: p_last_updated_by => FND_GLOBAL.USER_ID,
1082: p_last_update_login => FND_GLOBAL.conc_login_id,
1083: px_object_version_number => l_object_version_number,
1084: p_context => l_ozf_offer_line_rec.context,
1085: p_attribute1 => l_ozf_offer_line_rec.attribute1,

Line 1082: p_last_update_login => FND_GLOBAL.conc_login_id,

1078: p_creation_date => SYSDATE,
1079: p_created_by => FND_GLOBAL.USER_ID,
1080: p_last_update_date => SYSDATE,
1081: p_last_updated_by => FND_GLOBAL.USER_ID,
1082: p_last_update_login => FND_GLOBAL.conc_login_id,
1083: px_object_version_number => l_object_version_number,
1084: p_context => l_ozf_offer_line_rec.context,
1085: p_attribute1 => l_ozf_offer_line_rec.attribute1,
1086: p_attribute2 => l_ozf_offer_line_rec.attribute2,

Line 1342: p_last_updated_by => FND_GLOBAL.USER_ID,

1338: p_start_date_active => p_ozf_offer_line_rec.start_date_active,
1339: p_end_date_active => p_ozf_offer_line_rec.end_date_active,
1340: p_uom_code => p_ozf_offer_line_rec.uom_code,
1341: p_last_update_date => SYSDATE,
1342: p_last_updated_by => FND_GLOBAL.USER_ID,
1343: p_last_update_login => FND_GLOBAL.conc_login_id,
1344: p_object_version_number => p_ozf_offer_line_rec.object_version_number,
1345: p_context => p_ozf_offer_line_rec.context,
1346: p_attribute1 => p_ozf_offer_line_rec.attribute1,

Line 1343: p_last_update_login => FND_GLOBAL.conc_login_id,

1339: p_end_date_active => p_ozf_offer_line_rec.end_date_active,
1340: p_uom_code => p_ozf_offer_line_rec.uom_code,
1341: p_last_update_date => SYSDATE,
1342: p_last_updated_by => FND_GLOBAL.USER_ID,
1343: p_last_update_login => FND_GLOBAL.conc_login_id,
1344: p_object_version_number => p_ozf_offer_line_rec.object_version_number,
1345: p_context => p_ozf_offer_line_rec.context,
1346: p_attribute1 => p_ozf_offer_line_rec.attribute1,
1347: p_attribute2 => p_ozf_offer_line_rec.attribute2,

Line 2365: IF FND_GLOBAL.USER_ID IS NULL

2361: -- =========================================================================
2362: -- Validate Environment
2363: -- =========================================================================
2364:
2365: IF FND_GLOBAL.USER_ID IS NULL
2366: THEN
2367: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2368: RAISE FND_API.G_EXC_ERROR;
2369: END IF;

Line 2435: p_created_by => FND_GLOBAL.USER_ID,

2431: p_end_date_active => l_ozf_prod_rec.end_date_active,
2432: p_offer_discount_line_id => l_ozf_prod_rec.offer_discount_line_id,
2433: p_offer_id => l_ozf_prod_rec.offer_id,
2434: p_creation_date => SYSDATE,
2435: p_created_by => FND_GLOBAL.USER_ID,
2436: p_last_update_date => SYSDATE,
2437: p_last_updated_by => FND_GLOBAL.USER_ID,
2438: p_last_update_login => FND_GLOBAL.conc_login_id,
2439: px_object_version_number => l_object_version_number

Line 2437: p_last_updated_by => FND_GLOBAL.USER_ID,

2433: p_offer_id => l_ozf_prod_rec.offer_id,
2434: p_creation_date => SYSDATE,
2435: p_created_by => FND_GLOBAL.USER_ID,
2436: p_last_update_date => SYSDATE,
2437: p_last_updated_by => FND_GLOBAL.USER_ID,
2438: p_last_update_login => FND_GLOBAL.conc_login_id,
2439: px_object_version_number => l_object_version_number
2440: );
2441:

Line 2438: p_last_update_login => FND_GLOBAL.conc_login_id,

2434: p_creation_date => SYSDATE,
2435: p_created_by => FND_GLOBAL.USER_ID,
2436: p_last_update_date => SYSDATE,
2437: p_last_updated_by => FND_GLOBAL.USER_ID,
2438: p_last_update_login => FND_GLOBAL.conc_login_id,
2439: px_object_version_number => l_object_version_number
2440: );
2441:
2442: x_off_discount_product_id := l_off_discount_product_id;

Line 2675: p_last_updated_by => FND_GLOBAL.USER_ID,

2671: p_end_date_active => p_ozf_prod_rec.end_date_active,
2672: p_offer_discount_line_id => p_ozf_prod_rec.offer_discount_line_id,
2673: p_offer_id => p_ozf_prod_rec.offer_id,
2674: p_last_update_date => SYSDATE,
2675: p_last_updated_by => FND_GLOBAL.USER_ID,
2676: p_last_update_login => FND_GLOBAL.conc_login_id,
2677: p_object_version_number => p_ozf_prod_rec.object_version_number
2678: );
2679: --

Line 2676: p_last_update_login => FND_GLOBAL.conc_login_id,

2672: p_offer_discount_line_id => p_ozf_prod_rec.offer_discount_line_id,
2673: p_offer_id => p_ozf_prod_rec.offer_id,
2674: p_last_update_date => SYSDATE,
2675: p_last_updated_by => FND_GLOBAL.USER_ID,
2676: p_last_update_login => FND_GLOBAL.conc_login_id,
2677: p_object_version_number => p_ozf_prod_rec.object_version_number
2678: );
2679: --
2680: -- End of API body.

Line 3668: IF FND_GLOBAL.USER_ID IS NULL

3664: -- =========================================================================
3665: -- Validate Environment
3666: -- =========================================================================
3667:
3668: IF FND_GLOBAL.USER_ID IS NULL
3669: THEN
3670: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
3671: RAISE FND_API.G_EXC_ERROR;
3672: END IF;

Line 3727: p_created_by => FND_GLOBAL.USER_ID,

3723: px_discount_product_reln_id => l_discount_product_reln_id,
3724: p_offer_discount_line_id => l_prod_reln_rec.offer_discount_line_id,
3725: p_off_discount_product_id => l_prod_reln_rec.off_discount_product_id,
3726: p_creation_date => SYSDATE,
3727: p_created_by => FND_GLOBAL.USER_ID,
3728: p_last_update_date => SYSDATE,
3729: p_last_updated_by => FND_GLOBAL.USER_ID,
3730: p_last_update_login => FND_GLOBAL.conc_login_id,
3731: px_object_version_number => l_object_version_number

Line 3729: p_last_updated_by => FND_GLOBAL.USER_ID,

3725: p_off_discount_product_id => l_prod_reln_rec.off_discount_product_id,
3726: p_creation_date => SYSDATE,
3727: p_created_by => FND_GLOBAL.USER_ID,
3728: p_last_update_date => SYSDATE,
3729: p_last_updated_by => FND_GLOBAL.USER_ID,
3730: p_last_update_login => FND_GLOBAL.conc_login_id,
3731: px_object_version_number => l_object_version_number
3732: );
3733:

Line 3730: p_last_update_login => FND_GLOBAL.conc_login_id,

3726: p_creation_date => SYSDATE,
3727: p_created_by => FND_GLOBAL.USER_ID,
3728: p_last_update_date => SYSDATE,
3729: p_last_updated_by => FND_GLOBAL.USER_ID,
3730: p_last_update_login => FND_GLOBAL.conc_login_id,
3731: px_object_version_number => l_object_version_number
3732: );
3733:
3734: x_discount_product_reln_id := l_discount_product_reln_id;

Line 3960: p_last_updated_by => FND_GLOBAL.USER_ID,

3956: p_discount_product_reln_id => p_prod_reln_rec.discount_product_reln_id,
3957: p_offer_discount_line_id => p_prod_reln_rec.offer_discount_line_id,
3958: p_off_discount_product_id => p_prod_reln_rec.off_discount_product_id,
3959: p_last_update_date => SYSDATE,
3960: p_last_updated_by => FND_GLOBAL.USER_ID,
3961: p_last_update_login => FND_GLOBAL.conc_login_id,
3962: p_object_version_number => p_prod_reln_rec.object_version_number
3963: );
3964: --

Line 3961: p_last_update_login => FND_GLOBAL.conc_login_id,

3957: p_offer_discount_line_id => p_prod_reln_rec.offer_discount_line_id,
3958: p_off_discount_product_id => p_prod_reln_rec.off_discount_product_id,
3959: p_last_update_date => SYSDATE,
3960: p_last_updated_by => FND_GLOBAL.USER_ID,
3961: p_last_update_login => FND_GLOBAL.conc_login_id,
3962: p_object_version_number => p_prod_reln_rec.object_version_number
3963: );
3964: --
3965: -- End of API body.