eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_PRICE_PVT dependencies on FND_PROFILE

Line 6: G_ROUNDING_FLAG VARCHAR2(1):= 'Q'; --nvl(Fnd_Profile.value('OE_UNIT_PRICE_ROUNDING'),'N');

2: /* $Header: OEXVOPRB.pls 120.48.12020000.9 2013/03/13 21:21:06 cpati ship $ */
3:
4: G_DEBUG BOOLEAN;
5: --2649821 Changed G_ROUNDING_FLAG to Q
6: G_ROUNDING_FLAG VARCHAR2(1):= 'Q'; --nvl(Fnd_Profile.value('OE_UNIT_PRICE_ROUNDING'),'N');
7: G_SEEDED_GSA_HOLD_ID CONSTANT NUMBER:= 2;
8: G_CHARGES_FOR_INCLUDED_ITEM Varchar2(30)
9: := nvl(fnd_profile.value('ONT_CHARGES_FOR_INCLUDED_ITEM'),'N');
10: G_PASS_ALL_LINES VARCHAR2(30);

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

5: --2649821 Changed G_ROUNDING_FLAG to Q
6: G_ROUNDING_FLAG VARCHAR2(1):= 'Q'; --nvl(Fnd_Profile.value('OE_UNIT_PRICE_ROUNDING'),'N');
7: G_SEEDED_GSA_HOLD_ID CONSTANT NUMBER:= 2;
8: G_CHARGES_FOR_INCLUDED_ITEM Varchar2(30)
9: := nvl(fnd_profile.value('ONT_CHARGES_FOR_INCLUDED_ITEM'),'N');
10: G_PASS_ALL_LINES VARCHAR2(30);
11: --bug4080363 commented the following
12: -- bug 3491752
13: --G_LIST_PRICE_OVERRIDE Varchar2(30)

Line 14: -- := nvl(fnd_profile.value('ONT_LIST_PRICE_OVERRIDE_PRIV'), 'NONE');

10: G_PASS_ALL_LINES VARCHAR2(30);
11: --bug4080363 commented the following
12: -- bug 3491752
13: --G_LIST_PRICE_OVERRIDE Varchar2(30)
14: -- := nvl(fnd_profile.value('ONT_LIST_PRICE_OVERRIDE_PRIV'), 'NONE');
15:
16: g_request_id number := null;
17: G_IPL_ERRORS_TBL OE_GLOBALS.Number_Tbl_Type;
18: -- G_BINARY_LIMIT CONSTANT NUMBER:=2147483647; -- Bug 8631297

Line 2078: /l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');/

2074: procedure Get_item_for_iue(px_line_rec in out nocopy OE_Order_PUB.line_rec_type)
2075: is
2076: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
2077: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2078: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/
2079: l_ordered_item varchar2(300);
2080: cursor adj_cur is
2081: select modified_from from oe_price_adjustments
2082: where line_id=px_line_rec.line_id

Line 2569: AND NVL(FND_PROFILE.VALUE('ONT_3A7_RESPONSE_REQUIRED'), 'N') = 'Y'

2565:
2566: -- Moved to OE_ACKNOWLEDGMENT_PUB as part of 3417899 and 3412458
2567: /* IF l_line_rec.unit_selling_price <> l_old_line_rec.unit_selling_price
2568: AND OE_Code_Control.code_release_level >= '110510'
2569: AND NVL(FND_PROFILE.VALUE('ONT_3A7_RESPONSE_REQUIRED'), 'N') = 'Y'
2570: AND l_line_rec.order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID
2571: AND nvl(l_line_rec.xml_transaction_type_code, OE_Acknowledgment_Pub.G_TRANSACTION_CSO) = OE_Acknowledgment_Pub.G_TRANSACTION_CSO
2572: AND nvl(l_line_rec.booked_flag, 'X') = 'Y'
2573: AND l_line_rec.ordered_quantity <> 0 THEN

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

2607: END SECURITY_AND_GLOBAL_PICTURE;
2608:
2609: PROCEDURE CHECK_GSA
2610: IS
2611: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
2612: --l_gsa_violation_action Varchar2(30) := nvl(fnd_profile.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING');
2613: l_gsa_violation_action Varchar2(30) := nvl(oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING'); --moac
2614: l_hold_source_rec OE_Holds_Pvt.hold_source_rec_type;
2615: l_hold_release_rec OE_Holds_Pvt.Hold_Release_REC_Type;

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

2608:
2609: PROCEDURE CHECK_GSA
2610: IS
2611: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
2612: --l_gsa_violation_action Varchar2(30) := nvl(fnd_profile.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING');
2613: l_gsa_violation_action Varchar2(30) := nvl(oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING'); --moac
2614: l_hold_source_rec OE_Holds_Pvt.hold_source_rec_type;
2615: l_hold_release_rec OE_Holds_Pvt.Hold_Release_REC_Type;
2616: l_return_status varchar2(30);

Line 3092: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN --TaxER

3088: END IF;
3089: l_commt_tax_flag := 'N' ; --bug 2505961
3090: -- lkxu, make changes for bug 1581188
3091: IF (OE_GLOBALS.G_UI_FLAG)
3092: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN --TaxER
3093: OE_delayed_requests_Pvt.log_request(
3094: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3095: p_entity_id => update_line.line_id,
3096: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

Line 5478: --fnd_profile.get('ONT_DISCOUNTING_PRIVILEGE', v_discounting_privilege);

5474: END IF;
5475:
5476: -- end of modification made by lkxu
5477:
5478: --fnd_profile.get('ONT_DISCOUNTING_PRIVILEGE', v_discounting_privilege);
5479:
5480: -- If the profile is set to UNLIMITED, then even if the Order Type
5481: -- restrict price changes, the user can change the price
5482:

Line 5840: /nvl(fnd_profile.value('ONT_LIST_PRICE_OVERRIDE_PRIV'), 'NONE')/ -- G_LIST_PRICE_OVERRIDE = 'UNLIMITED' THEN --bug4080363

5836: IF p_line_rec.original_list_price IS NOT NULL AND
5837: p_line_rec.unit_list_price IS NOT NULL THEN --AND --bug4080363
5838: -- p_line_rec.unit_list_price <> p_line_rec.original_list_price AND
5839: -- bug 3491752
5840: /*nvl(fnd_profile.value('ONT_LIST_PRICE_OVERRIDE_PRIV'), 'NONE')*/ -- G_LIST_PRICE_OVERRIDE = 'UNLIMITED' THEN --bug4080363
5841: l_req_line_rec.list_price_override_flag := 'Y';
5842: l_req_line_rec.line_unit_price := p_line_rec.unit_list_price;
5843: IF (l_req_line_rec.price_flag = 'N') THEN
5844: l_req_line_rec.price_flag := 'C';

Line 6218: l_bypass_pricing varchar2(30) := nvl(FND_PROFILE.VALUE('QP_BYPASS_PRICING'),'N');

6214: l_line_index NUMBER := 0;
6215: line_tbl_index pls_integer;
6216: i pls_integer;
6217: j pls_integer;
6218: l_bypass_pricing varchar2(30) := nvl(FND_PROFILE.VALUE('QP_BYPASS_PRICING'),'N');
6219: l_dummy Varchar2(1);
6220: l_header_id NUMBER;
6221: l_any_frozen_line BOOLEAN:=FALSE;
6222: l_calculate_price_flag varchar2(1);

Line 6233: G_INT_CHANGED_LINE_ON Varchar2(3):= nvl(FND_PROFILE.VALUE('ONT_INTERNAL_CHANGED_LINE'),'Y');

6229: l_completely_frozen BOOLEAN := TRUE;
6230: l_line_attr_index number:=0;
6231: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
6232: l_total_lines NUMBER;
6233: G_INT_CHANGED_LINE_ON Varchar2(3):= nvl(FND_PROFILE.VALUE('ONT_INTERNAL_CHANGED_LINE'),'Y');
6234: l_header_id2 NUMBER;
6235: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6236: l_check_line_flag varchar2(1);
6237: l_pass_line varchar2(1);

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

7146: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7147: i pls_Integer;
7148: j pls_Integer:=0;
7149: l_price_list Varchar2(240);
7150: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');
7151: l_invalid_line Varchar2(1):='N';
7152: l_temp_line_rec oe_order_pub.line_rec_type;
7153: l_request_id NUMBER;
7154: vmsg Varchar2(2000);

Line 7826: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGAT

7822: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7823: i pls_Integer;
7824: j pls_Integer;
7825: l_price_list Varchar2(240);
7826: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGAT
7827: IVE_PRICING'),'N');
7828: l_sec_result NUMBER;
7829: l_adjustment_count NUMBER:=0;
7830: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 8265: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N'

8261:
8262: IF l_current_event >= l_tax_calculation_event_code THEN
8263:
8264: IF (OE_GLOBALS.G_UI_FLAG)
8265: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N'
8266: THEN
8267: OE_delayed_requests_Pvt.log_request(
8268: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8269: p_entity_id => px_Line_Tbl(1).header_id,

Line 8320: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N'

8316:
8317: IF l_current_event >= l_tax_calculation_event_code THEN
8318:
8319: IF (OE_GLOBALS.G_UI_FLAG)
8320: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N'
8321: THEN
8322: OE_delayed_requests_Pvt.log_request(
8323: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
8324: p_entity_id => l_line_rec.line_id,