DBA Data[Home] [Help]

APPS.OE_BULK_PRICEORDER_PVT dependencies on FND_PROFILE

Line 8: := nvl(fnd_profile.value('ONT_CHARGES_FOR_INCLUDED_ITEM'),'N');

4:
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_BULK_PRICEORDER_PVT';
7: G_CHARGES_FOR_INCLUDED_ITEM Varchar2(30)
8: := nvl(fnd_profile.value('ONT_CHARGES_FOR_INCLUDED_ITEM'),'N');
9: G_FUNCTION_CURRENCY VARCHAR2(30) default NULL;
10: G_PRICE_FLAG_TBL_EXTENDED BOOLEAN default null;
11:
12:

Line 892: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');

888: OUTPUT:
889: ***********************************************************************/
890:
891: Procedure Check_Errors As
892: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');
893: l_has_errors Boolean := False;
894: --l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
895: --l_gsa_violation_action Varchar2(30) := nvl(fnd_profile.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING');
896: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 894: --l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');

890:
891: Procedure Check_Errors As
892: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');
893: l_has_errors Boolean := False;
894: --l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
895: --l_gsa_violation_action Varchar2(30) := nvl(fnd_profile.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING');
896: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
897: l_invalid_line varchar2(1);
898: l_request_id number;

Line 895: --l_gsa_violation_action Varchar2(30) := nvl(fnd_profile.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING');

891: Procedure Check_Errors As
892: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');
893: l_has_errors Boolean := False;
894: --l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
895: --l_gsa_violation_action Varchar2(30) := nvl(fnd_profile.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING');
896: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
897: l_invalid_line varchar2(1);
898: l_request_id number;
899: l_price_list Varchar2(240);

Line 1253: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');

1249: --bug 3716296
1250: PROCEDURE Check_Gsa
1251: IS
1252:
1253: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
1254: --l_gsa_violation_action Varchar2(30) := nvl(fnd_profile.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING');
1255: l_gsa_violation_action Varchar2(30) := nvl(oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING'); --moac
1256: l_ordered_item Varchar2(2000);
1257: l_inventory_item_id Number;

Line 1254: --l_gsa_violation_action Varchar2(30) := nvl(fnd_profile.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING');

1250: PROCEDURE Check_Gsa
1251: IS
1252:
1253: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
1254: --l_gsa_violation_action Varchar2(30) := nvl(fnd_profile.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING');
1255: l_gsa_violation_action Varchar2(30) := nvl(oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING'); --moac
1256: l_ordered_item Varchar2(2000);
1257: l_inventory_item_id Number;
1258: l_msg_text Varchar2(200);