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 2269: l_organization_id NUMBER:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

2265: l_control_rec OE_GLOBALS.Control_Rec_Type;
2266: l_return_status VARCHAR2(1);
2267: l_charge_amount NUMBER := 0.0;
2268: l_last_index NUMBER;
2269: l_organization_id NUMBER:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2270: l_set_rec OE_ORDER_CACHE.set_rec_type; -- 2806483
2271: --
2272: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2273: --

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

3411:
3412: --
3413: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3414: --
3415: --7832836 l_cascade_hold_non_smc VARCHAR2(1) := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO'),'N'); --ER#7479609
3416: l_cascade_hold_non_smc VARCHAR2(1); -- 7832836
3417: BEGIN
3418: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',
3419: p_line_rec.org_id);

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

3414: --
3415: --7832836 l_cascade_hold_non_smc VARCHAR2(1) := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO'),'N'); --ER#7479609
3416: l_cascade_hold_non_smc VARCHAR2(1); -- 7832836
3417: BEGIN
3418: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',
3419: p_line_rec.org_id);
3420: l_cascade_hold_non_smc := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO',p_line_rec.org_id),'N'); --7832836
3421: -- Populate Project Number and Task Number
3422: IF p_line_rec.project_id is not Null then

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

3416: l_cascade_hold_non_smc VARCHAR2(1); -- 7832836
3417: BEGIN
3418: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',
3419: p_line_rec.org_id);
3420: l_cascade_hold_non_smc := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO',p_line_rec.org_id),'N'); --7832836
3421: -- Populate Project Number and Task Number
3422: IF p_line_rec.project_id is not Null then
3423: BEGIN
3424: /* Select project_number

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

4800: END If;
4801: --{ recurring charges
4802: /* IF p_line_rec.charge_periodicity_code IS NOT NULL AND
4803: p_line_rec.charge_periodicity_code <> FND_API.G_MISS_CHAR AND
4804: OE_SYS_PARAMETERS.Value('RECURRING_CHARGES',p_line_rec.org_id) = 'Y' THEN
4805:
4806: SELECT unit_of_measure
4807: INTO l_charge_periodicity
4808: FROM MTL_UNITS_OF_MEASURE_VL

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

4825: /* Sql statements to get the vaues of Retrobilled price for original lines
4826: and Retrobilled order and Retrobilled line information for retrobill lines. */
4827:
4828: IF(OE_CODE_CONTROL.Code_Release_Level >= 110510) THEN
4829: IF (p_line_rec.line_id IS NOT NULL AND oe_sys_parameters.value('ENABLE_RETROBILLING',p_line_rec.org_id) = 'Y') THEN
4830: BEGIN
4831: SELECT sum(decode(line_category_code,'RETURN',-1*nvl(unit_selling_price,0),nvl(unit_selling_price,0)))
4832: INTO l_retrobilled_price_diff
4833: FROM oe_order_lines

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

4969: --End OF Macd
4970: --Recurring CHarges
4971: -- Check if recurring Charges is Enabled or not
4972:
4973: IF OE_SYS_PARAMETERS.Value('RECURRING_CHARGES',p_line_rec.org_id)='Y' THEN
4974:
4975: BEGIN
4976:
4977: IF p_line_rec.charge_periodicity_code IS NOT NULL THEN

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

5062: ,p_description IN VARCHAR2
5063: ) RETURN VARCHAR2 IS
5064: /*l_organization_id NUMBER := fnd_profile.value('OE_ORGANIZATION_ID');*/
5065: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5066: l_organization_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5067: l_count NUMBER := 0;
5068: --
5069: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5070: --

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

5200: ,p_ordered_item IN VARCHAR2
5201: ,p_sold_to_org_id IN NUMBER
5202: ,p_inventory_item IN VARCHAR2
5203: ) RETURN VARCHAR2 IS
5204: l_organization_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5205: l_count NUMBER := 0;
5206: --
5207: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5208: --

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

5339: ,p_ordered_item IN VARCHAR2
5340: ,p_sold_to_org_id IN NUMBER
5341: ,p_item IN VARCHAR2
5342: ) RETURN VARCHAR2 IS
5343: l_organization_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5344: l_count NUMBER := 0;
5345: --
5346: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5347: --

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

6147: , p_sold_to_org_id IN Number
6148: , x_ordered_item OUT NOCOPY VARCHAR2
6149: ) IS
6150:
6151: l_organization_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
6152:
6153: --
6154: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6155: --