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_OE_FORM_LINE dependencies on OE_SYS_PARAMETERS

Line 2329: l_organization_id NUMBER:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

2325: l_control_rec OE_GLOBALS.Control_Rec_Type;
2326: l_return_status VARCHAR2(1);
2327: l_charge_amount NUMBER := 0.0;
2328: l_last_index NUMBER;
2329: l_organization_id NUMBER:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2330: l_set_rec OE_ORDER_CACHE.set_rec_type; -- 2806483
2331: --
2332: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2333: --

Line 3482: --7832836 l_cascade_hold_non_smc VARCHAR2(1) := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO'),'N'); --ER#7479609

3478:
3479: --
3480: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3481: --
3482: --7832836 l_cascade_hold_non_smc VARCHAR2(1) := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO'),'N'); --ER#7479609
3483: l_cascade_hold_non_smc VARCHAR2(1); -- 7832836
3484: BEGIN
3485: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',
3486: p_line_rec.org_id);

Line 3485: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',

3481: --
3482: --7832836 l_cascade_hold_non_smc VARCHAR2(1) := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO'),'N'); --ER#7479609
3483: l_cascade_hold_non_smc VARCHAR2(1); -- 7832836
3484: BEGIN
3485: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',
3486: p_line_rec.org_id);
3487: l_cascade_hold_non_smc := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO',p_line_rec.org_id),'N'); --7832836
3488: -- sol_ord_er #16014165, get Billing Profile Display
3489: IF p_line_rec.service_bill_profile_id IS NOT NULL THEN

Line 3487: l_cascade_hold_non_smc := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO',p_line_rec.org_id),'N'); --7832836

3483: l_cascade_hold_non_smc VARCHAR2(1); -- 7832836
3484: BEGIN
3485: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',
3486: p_line_rec.org_id);
3487: l_cascade_hold_non_smc := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO',p_line_rec.org_id),'N'); --7832836
3488: -- sol_ord_er #16014165, get Billing Profile Display
3489: IF p_line_rec.service_bill_profile_id IS NOT NULL THEN
3490: IF l_debug_level > 0 THEN
3491: oe_debug_pub.add('SK OEXFLINB.pls 110 '||p_line_rec.service_bill_profile_id);

Line 5082: OE_SYS_PARAMETERS.Value('RECURRING_CHARGES',p_line_rec.org_id) = 'Y' THEN

5078: END If;
5079: --{ recurring charges
5080: /* IF p_line_rec.charge_periodicity_code IS NOT NULL AND
5081: p_line_rec.charge_periodicity_code <> FND_API.G_MISS_CHAR AND
5082: OE_SYS_PARAMETERS.Value('RECURRING_CHARGES',p_line_rec.org_id) = 'Y' THEN
5083:
5084: SELECT unit_of_measure
5085: INTO l_charge_periodicity
5086: FROM MTL_UNITS_OF_MEASURE_VL

Line 5107: IF (p_line_rec.line_id IS NOT NULL AND oe_sys_parameters.value('ENABLE_RETROBILLING',p_line_rec.org_id) = 'Y') THEN

5103: /* Sql statements to get the vaues of Retrobilled price for original lines
5104: and Retrobilled order and Retrobilled line information for retrobill lines. */
5105:
5106: IF(OE_CODE_CONTROL.Code_Release_Level >= 110510) THEN
5107: IF (p_line_rec.line_id IS NOT NULL AND oe_sys_parameters.value('ENABLE_RETROBILLING',p_line_rec.org_id) = 'Y') THEN
5108: BEGIN
5109: SELECT sum(decode(line_category_code,'RETURN',-1*nvl(unit_selling_price,0),nvl(unit_selling_price,0)))
5110: INTO l_retrobilled_price_diff
5111: FROM oe_order_lines

Line 5251: IF OE_SYS_PARAMETERS.Value('RECURRING_CHARGES',p_line_rec.org_id)='Y' THEN

5247: --End OF Macd
5248: --Recurring CHarges
5249: -- Check if recurring Charges is Enabled or not
5250:
5251: IF OE_SYS_PARAMETERS.Value('RECURRING_CHARGES',p_line_rec.org_id)='Y' THEN
5252:
5253: BEGIN
5254:
5255: IF p_line_rec.charge_periodicity_code IS NOT NULL THEN

Line 5345: l_organization_id Number;/:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');/

5341: ,p_org_id IN NUMBER DEFAULT NULL
5342: ) RETURN VARCHAR2 IS
5343: /*l_organization_id NUMBER := fnd_profile.value('OE_ORGANIZATION_ID');*/
5344: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5345: l_organization_id Number;/*:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');*/
5346: l_count NUMBER := 0;
5347: --
5348: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5349: --

Line 5352: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',

5348: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5349: --
5350: BEGIN
5351: --Bug 9684561
5352: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',
5353: p_org_id);
5354:
5355: IF l_debug_level > 0 THEN
5356: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE:'||P_ITEM_IDENTIFIER_TYPE ) ;

Line 5487: l_organization_id Number;/:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');/

5483: ,p_sold_to_org_id IN NUMBER
5484: ,p_inventory_item IN VARCHAR2
5485: ,p_org_id IN NUMBER DEFAULT NULL
5486: ) RETURN VARCHAR2 IS
5487: l_organization_id Number;/*:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');*/
5488: l_count NUMBER := 0;
5489: --
5490: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5491: --

Line 5494: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',

5490: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5491: --
5492: BEGIN
5493: --Bug 9684561
5494: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',
5495: p_org_id);
5496:
5497: IF l_debug_level > 0 THEN
5498:

Line 5629: l_organization_id Number;/= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');/

5625: ,p_sold_to_org_id IN NUMBER
5626: ,p_item IN VARCHAR2
5627: ,p_org_id IN NUMBER DEFAULT NULL
5628: ) RETURN VARCHAR2 IS
5629: l_organization_id Number;/*= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');*/
5630: l_count NUMBER := 0;
5631: --
5632: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5633: --

Line 5636: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',

5632: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5633: --
5634: BEGIN
5635: --Bug 9684561
5636: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',
5637: p_org_id);
5638: IF l_debug_level > 0 THEN
5639: oe_debug_pub.add( 'P_ITEM_IDENTIFIER_TYPE: '||P_ITEM_IDENTIFIER_TYPE ) ;
5640: oe_debug_pub.add( 'P_ORDERED_ITEM_ID: '||P_ORDERED_ITEM_ID ) ;

Line 6518: l_organization_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

6514: , p_sold_to_org_id IN Number
6515: , x_ordered_item OUT NOCOPY VARCHAR2
6516: ) IS
6517:
6518: l_organization_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
6519: --bug 10047225
6520: l_valid_kff boolean;
6521: --
6522: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;