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_CONFIG_UTIL dependencies on OE_LINE_SECURITY

Line 6352: WHERE line_id = oe_line_security.g_record.line_id;

6348:
6349: SELECT item_type_code,header_id, top_model_line_id, line_id
6350: INTO l_item_type_code,l_header_id, l_top_model_line_id, l_line_id
6351: FROM oe_order_lines
6352: WHERE line_id = oe_line_security.g_record.line_id;
6353:
6354: IF l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
6355: l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
6356: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED

Line 6381: WHERE top_model_line_id = oe_line_security.g_record.line_id

6377: THEN
6378: SELECT count(*)
6379: INTO l_count
6380: FROM OE_ORDER_LINES
6381: WHERE top_model_line_id = oe_line_security.g_record.line_id
6382: AND line_id <> oe_line_security.g_record.line_id
6383: AND header_id = l_header_id;
6384:
6385: IF l_count > 0 THEN

Line 6382: AND line_id <> oe_line_security.g_record.line_id

6378: SELECT count(*)
6379: INTO l_count
6380: FROM OE_ORDER_LINES
6381: WHERE top_model_line_id = oe_line_security.g_record.line_id
6382: AND line_id <> oe_line_security.g_record.line_id
6383: AND header_id = l_header_id;
6384:
6385: IF l_count > 0 THEN
6386: x_result := 1;

Line 7940: oe_debug_pub.add('OPERATION '|| OE_LINE_SECURITY.G_RECORD.OPERATION , 4 );

7936: BEGIN
7937:
7938: IF l_debug_level > 0 THEN
7939: oe_debug_pub.add('ENTERING IS_INCLUDED_ITEM_CONSTRAINED' , 1);
7940: oe_debug_pub.add('OPERATION '|| OE_LINE_SECURITY.G_RECORD.OPERATION , 4 );
7941: oe_debug_pub.add('ITEM TYPE '||OE_LINE_SECURITY.G_RECORD.ITEM_TYPE_CODE,4);
7942: END IF;
7943:
7944: SELECT item_type_code, model_remnant_flag, pre_exploded_flag

Line 7941: oe_debug_pub.add('ITEM TYPE '||OE_LINE_SECURITY.G_RECORD.ITEM_TYPE_CODE,4);

7937:
7938: IF l_debug_level > 0 THEN
7939: oe_debug_pub.add('ENTERING IS_INCLUDED_ITEM_CONSTRAINED' , 1);
7940: oe_debug_pub.add('OPERATION '|| OE_LINE_SECURITY.G_RECORD.OPERATION , 4 );
7941: oe_debug_pub.add('ITEM TYPE '||OE_LINE_SECURITY.G_RECORD.ITEM_TYPE_CODE,4);
7942: END IF;
7943:
7944: SELECT item_type_code, model_remnant_flag, pre_exploded_flag
7945: INTO l_item_type_code, l_model_remnant_flag, l_pre_exploded_flag -- DOO Preexploded Kit ER 9339742

Line 7947: WHERE line_id = oe_line_security.g_record.line_id;

7943:
7944: SELECT item_type_code, model_remnant_flag, pre_exploded_flag
7945: INTO l_item_type_code, l_model_remnant_flag, l_pre_exploded_flag -- DOO Preexploded Kit ER 9339742
7946: FROM oe_order_lines
7947: WHERE line_id = oe_line_security.g_record.line_id;
7948:
7949: IF l_debug_level > 0 THEN -- DOO Preexploded Kit ER 9339742
7950: oe_debug_pub.add('Pre Exploded Flag is : '||l_pre_exploded_flag);
7951: END IF;

Line 8259: IF nvl(oe_line_security.g_record.model_remnant_flag, 'N') = 'N' THEN

8255: BEGIN
8256:
8257: x_result := 0;
8258:
8259: IF nvl(oe_line_security.g_record.model_remnant_flag, 'N') = 'N' THEN
8260: RETURN;
8261: END IF;
8262:
8263: IF oe_line_security.g_record.ato_line_id is NULL THEN

Line 8263: IF oe_line_security.g_record.ato_line_id is NULL THEN

8259: IF nvl(oe_line_security.g_record.model_remnant_flag, 'N') = 'N' THEN
8260: RETURN;
8261: END IF;
8262:
8263: IF oe_line_security.g_record.ato_line_id is NULL THEN
8264: RETURN;
8265: END IF;
8266:
8267: --IF oe_line_security.g_record.item_type_code = 'STANDARD' OR

Line 8267: --IF oe_line_security.g_record.item_type_code = 'STANDARD' OR

8263: IF oe_line_security.g_record.ato_line_id is NULL THEN
8264: RETURN;
8265: END IF;
8266:
8267: --IF oe_line_security.g_record.item_type_code = 'STANDARD' OR
8268: -- (oe_line_security.g_record.item_type_code = 'OPTION' AND
8269: --Begin Bug fix for bug#6153528
8270: IF oe_line_security.g_record.item_type_code IN ( 'STANDARD', 'OPTION', 'CONFIG', 'CLASS' ) OR
8271: (oe_line_security.g_record.item_type_code in ( 'OPTION', 'CLASS','INCLUDED' ) AND

Line 8268: -- (oe_line_security.g_record.item_type_code = 'OPTION' AND

8264: RETURN;
8265: END IF;
8266:
8267: --IF oe_line_security.g_record.item_type_code = 'STANDARD' OR
8268: -- (oe_line_security.g_record.item_type_code = 'OPTION' AND
8269: --Begin Bug fix for bug#6153528
8270: IF oe_line_security.g_record.item_type_code IN ( 'STANDARD', 'OPTION', 'CONFIG', 'CLASS' ) OR
8271: (oe_line_security.g_record.item_type_code in ( 'OPTION', 'CLASS','INCLUDED' ) AND
8272: --added 'INCLUDED' above ^^ as a part of bug 13065898 , required after B2B ER.

Line 8270: IF oe_line_security.g_record.item_type_code IN ( 'STANDARD', 'OPTION', 'CONFIG', 'CLASS' ) OR

8266:
8267: --IF oe_line_security.g_record.item_type_code = 'STANDARD' OR
8268: -- (oe_line_security.g_record.item_type_code = 'OPTION' AND
8269: --Begin Bug fix for bug#6153528
8270: IF oe_line_security.g_record.item_type_code IN ( 'STANDARD', 'OPTION', 'CONFIG', 'CLASS' ) OR
8271: (oe_line_security.g_record.item_type_code in ( 'OPTION', 'CLASS','INCLUDED' ) AND
8272: --added 'INCLUDED' above ^^ as a part of bug 13065898 , required after B2B ER.
8273: --End Bug fix for bug#6153528
8274: oe_line_security.g_record.line_id = oe_line_security.g_record.ato_line_id) THEN

Line 8271: (oe_line_security.g_record.item_type_code in ( 'OPTION', 'CLASS','INCLUDED' ) AND

8267: --IF oe_line_security.g_record.item_type_code = 'STANDARD' OR
8268: -- (oe_line_security.g_record.item_type_code = 'OPTION' AND
8269: --Begin Bug fix for bug#6153528
8270: IF oe_line_security.g_record.item_type_code IN ( 'STANDARD', 'OPTION', 'CONFIG', 'CLASS' ) OR
8271: (oe_line_security.g_record.item_type_code in ( 'OPTION', 'CLASS','INCLUDED' ) AND
8272: --added 'INCLUDED' above ^^ as a part of bug 13065898 , required after B2B ER.
8273: --End Bug fix for bug#6153528
8274: oe_line_security.g_record.line_id = oe_line_security.g_record.ato_line_id) THEN
8275: RETURN;

Line 8274: oe_line_security.g_record.line_id = oe_line_security.g_record.ato_line_id) THEN

8270: IF oe_line_security.g_record.item_type_code IN ( 'STANDARD', 'OPTION', 'CONFIG', 'CLASS' ) OR
8271: (oe_line_security.g_record.item_type_code in ( 'OPTION', 'CLASS','INCLUDED' ) AND
8272: --added 'INCLUDED' above ^^ as a part of bug 13065898 , required after B2B ER.
8273: --End Bug fix for bug#6153528
8274: oe_line_security.g_record.line_id = oe_line_security.g_record.ato_line_id) THEN
8275: RETURN;
8276: END IF;
8277:
8278: IF l_debug_level > 0 THEN