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 6345: WHERE line_id = oe_line_security.g_record.line_id;

6341:
6342: SELECT item_type_code,header_id, top_model_line_id, line_id
6343: INTO l_item_type_code,l_header_id, l_top_model_line_id, l_line_id
6344: FROM oe_order_lines
6345: WHERE line_id = oe_line_security.g_record.line_id;
6346:
6347: IF l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
6348: l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
6349: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED

Line 6374: WHERE top_model_line_id = oe_line_security.g_record.line_id

6370: THEN
6371: SELECT count(*)
6372: INTO l_count
6373: FROM OE_ORDER_LINES
6374: WHERE top_model_line_id = oe_line_security.g_record.line_id
6375: AND line_id <> oe_line_security.g_record.line_id
6376: AND header_id = l_header_id;
6377:
6378: IF l_count > 0 THEN

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

6371: SELECT count(*)
6372: INTO l_count
6373: FROM OE_ORDER_LINES
6374: WHERE top_model_line_id = oe_line_security.g_record.line_id
6375: AND line_id <> oe_line_security.g_record.line_id
6376: AND header_id = l_header_id;
6377:
6378: IF l_count > 0 THEN
6379: x_result := 1;

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

7829: BEGIN
7830:
7831: IF l_debug_level > 0 THEN
7832: oe_debug_pub.add('ENTERING IS_INCLUDED_ITEM_CONSTRAINED' , 1);
7833: oe_debug_pub.add('OPERATION '|| OE_LINE_SECURITY.G_RECORD.OPERATION , 4 );
7834: oe_debug_pub.add('ITEM TYPE '||OE_LINE_SECURITY.G_RECORD.ITEM_TYPE_CODE,4);
7835: END IF;
7836:
7837: SELECT item_type_code, model_remnant_flag

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

7830:
7831: IF l_debug_level > 0 THEN
7832: oe_debug_pub.add('ENTERING IS_INCLUDED_ITEM_CONSTRAINED' , 1);
7833: oe_debug_pub.add('OPERATION '|| OE_LINE_SECURITY.G_RECORD.OPERATION , 4 );
7834: oe_debug_pub.add('ITEM TYPE '||OE_LINE_SECURITY.G_RECORD.ITEM_TYPE_CODE,4);
7835: END IF;
7836:
7837: SELECT item_type_code, model_remnant_flag
7838: INTO l_item_type_code, l_model_remnant_flag

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

7836:
7837: SELECT item_type_code, model_remnant_flag
7838: INTO l_item_type_code, l_model_remnant_flag
7839: FROM oe_order_lines
7840: WHERE line_id = oe_line_security.g_record.line_id;
7841:
7842: IF nvl(l_item_type_code, 'A') <> 'INCLUDED' THEN
7843: x_result := 0;
7844: RETURN;

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

8129: BEGIN
8130:
8131: x_result := 0;
8132:
8133: IF nvl(oe_line_security.g_record.model_remnant_flag, 'N') = 'N' THEN
8134: RETURN;
8135: END IF;
8136:
8137: IF oe_line_security.g_record.ato_line_id is NULL THEN

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

8133: IF nvl(oe_line_security.g_record.model_remnant_flag, 'N') = 'N' THEN
8134: RETURN;
8135: END IF;
8136:
8137: IF oe_line_security.g_record.ato_line_id is NULL THEN
8138: RETURN;
8139: END IF;
8140:
8141: --IF oe_line_security.g_record.item_type_code = 'STANDARD' OR

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

8137: IF oe_line_security.g_record.ato_line_id is NULL THEN
8138: RETURN;
8139: END IF;
8140:
8141: --IF oe_line_security.g_record.item_type_code = 'STANDARD' OR
8142: -- (oe_line_security.g_record.item_type_code = 'OPTION' AND
8143: --Begin Bug fix for bug#6153528
8144: IF oe_line_security.g_record.item_type_code IN ( 'STANDARD', 'OPTION', 'CONFIG', 'CLASS' ) OR
8145: (oe_line_security.g_record.item_type_code in ( 'OPTION', 'CLASS' ) AND

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

8138: RETURN;
8139: END IF;
8140:
8141: --IF oe_line_security.g_record.item_type_code = 'STANDARD' OR
8142: -- (oe_line_security.g_record.item_type_code = 'OPTION' AND
8143: --Begin Bug fix for bug#6153528
8144: IF oe_line_security.g_record.item_type_code IN ( 'STANDARD', 'OPTION', 'CONFIG', 'CLASS' ) OR
8145: (oe_line_security.g_record.item_type_code in ( 'OPTION', 'CLASS' ) AND
8146: --End Bug fix for bug#6153528

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

8140:
8141: --IF oe_line_security.g_record.item_type_code = 'STANDARD' OR
8142: -- (oe_line_security.g_record.item_type_code = 'OPTION' AND
8143: --Begin Bug fix for bug#6153528
8144: IF oe_line_security.g_record.item_type_code IN ( 'STANDARD', 'OPTION', 'CONFIG', 'CLASS' ) OR
8145: (oe_line_security.g_record.item_type_code in ( 'OPTION', 'CLASS' ) AND
8146: --End Bug fix for bug#6153528
8147: oe_line_security.g_record.line_id =
8148: oe_line_security.g_record.ato_line_id) THEN

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

8141: --IF oe_line_security.g_record.item_type_code = 'STANDARD' OR
8142: -- (oe_line_security.g_record.item_type_code = 'OPTION' AND
8143: --Begin Bug fix for bug#6153528
8144: IF oe_line_security.g_record.item_type_code IN ( 'STANDARD', 'OPTION', 'CONFIG', 'CLASS' ) OR
8145: (oe_line_security.g_record.item_type_code in ( 'OPTION', 'CLASS' ) AND
8146: --End Bug fix for bug#6153528
8147: oe_line_security.g_record.line_id =
8148: oe_line_security.g_record.ato_line_id) THEN
8149: RETURN;

Line 8147: oe_line_security.g_record.line_id =

8143: --Begin Bug fix for bug#6153528
8144: IF oe_line_security.g_record.item_type_code IN ( 'STANDARD', 'OPTION', 'CONFIG', 'CLASS' ) OR
8145: (oe_line_security.g_record.item_type_code in ( 'OPTION', 'CLASS' ) AND
8146: --End Bug fix for bug#6153528
8147: oe_line_security.g_record.line_id =
8148: oe_line_security.g_record.ato_line_id) THEN
8149: RETURN;
8150: END IF;
8151:

Line 8148: oe_line_security.g_record.ato_line_id) THEN

8144: IF oe_line_security.g_record.item_type_code IN ( 'STANDARD', 'OPTION', 'CONFIG', 'CLASS' ) OR
8145: (oe_line_security.g_record.item_type_code in ( 'OPTION', 'CLASS' ) AND
8146: --End Bug fix for bug#6153528
8147: oe_line_security.g_record.line_id =
8148: oe_line_security.g_record.ato_line_id) THEN
8149: RETURN;
8150: END IF;
8151:
8152: IF l_debug_level > 0 THEN