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.CTO_WORKFLOW_API_PK dependencies on OE_LINE_SECURITY

Line 2170: v_model_id := oe_line_security.g_record.ato_line_id; /* refer to a global record */

2166: -- find the top_model_line_id when given an option line id
2167: --
2168: l_stmt_num := 10;
2169:
2170: v_model_id := oe_line_security.g_record.ato_line_id; /* refer to a global record */
2171: v_header_id := oe_line_security.g_record.header_id;
2172:
2173: --
2174: -- if not an ATO model line, condition is false, return 0

Line 2171: v_header_id := oe_line_security.g_record.header_id;

2167: --
2168: l_stmt_num := 10;
2169:
2170: v_model_id := oe_line_security.g_record.ato_line_id; /* refer to a global record */
2171: v_header_id := oe_line_security.g_record.header_id;
2172:
2173: --
2174: -- if not an ATO model line, condition is false, return 0
2175: --

Line 2268: where line_id = oe_line_security.g_record.line_id

2264: l_stmt_num := 5;
2265: select ato_line_id, header_id
2266: into l_ato_line_id, l_header_id
2267: from oe_order_lines_all
2268: where line_id = oe_line_security.g_record.line_id
2269: and item_type_code <> 'STANDARD'
2270: and ato_line_id is not null;
2271:
2272: -- check if the config item is created

Line 2283: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;

2279: and ato_line_id = l_ato_line_id
2280: and item_type_code = 'CONFIG';
2281:
2282:
2283: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
2284: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
2285: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
2286: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
2287: oe_debug_pub.add( 'LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;

Line 2284: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;

2280: and item_type_code = 'CONFIG';
2281:
2282:
2283: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
2284: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
2285: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
2286: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
2287: oe_debug_pub.add( 'LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
2288:

Line 2285: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;

2281:
2282:
2283: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
2284: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
2285: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
2286: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
2287: oe_debug_pub.add( 'LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
2288:
2289:

Line 2286: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;

2282:
2283: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
2284: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
2285: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
2286: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
2287: oe_debug_pub.add( 'LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
2288:
2289:
2290:

Line 2287: oe_debug_pub.add( 'LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;

2283: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
2284: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
2285: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
2286: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
2287: oe_debug_pub.add( 'LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
2288:
2289:
2290:
2291: x_result := 1; /* the condition is true */

Line 2450: where line_id = oe_line_security.g_record.line_id

2446:
2447: select 1
2448: into l_config_item
2449: from oe_order_lines_all
2450: where line_id = oe_line_security.g_record.line_id
2451: and item_type_code = 'CONFIG';
2452:
2453: IF PG_DEBUG <> 0 THEN
2454: oe_debug_pub.add('configuration_created: ' || 'This is a config item. Check if update is user or system', 5);

Line 2531: where top_model_line_id = oe_line_security.g_record.top_model_line_id

2527:
2528: CURSOR c_config_exists IS
2529: select ato_line_id
2530: from oe_order_lines_all
2531: where top_model_line_id = oe_line_security.g_record.top_model_line_id
2532: and item_type_code = 'CONFIG';
2533:
2534: BEGIN
2535: IF PG_DEBUG <> 0 THEN

Line 2543: IF oe_line_security.g_record.ato_line_id IS NOT NULL THEN

2539: -- Check if the line is not an ATO model, option, option class, or
2540: -- config line
2541:
2542: l_stmt_num := 10;
2543: IF oe_line_security.g_record.ato_line_id IS NOT NULL THEN
2544: IF PG_DEBUG <> 0 THEN
2545: oe_debug_pub.add('configuration_created_for_pto: ' || 'This is not a PTO item, constraint condition is false', 5);
2546: END IF;
2547: x_result := 0;

Line 2555: l_pto_line := oe_line_security.g_record.line_id;

2551: l_stmt_num := 20;
2552: IF PG_DEBUG <> 0 THEN
2553: oe_debug_pub.add('configuration_created_for_pto: ' || 'This is a PTO item', 5);
2554: END IF;
2555: l_pto_line := oe_line_security.g_record.line_id;
2556: IF PG_DEBUG <> 0 THEN
2557: oe_debug_pub.add('configuration_created_for_pto: ' || 'l_pto_line = '||to_char(l_pto_line), 5);
2558: END IF;
2559:

Line 2564: where top_model_line_id = oe_line_security.g_record.top_model_line_id

2560: l_stmt_num := 30;
2561: select 1
2562: into l_config_exists
2563: from oe_order_lines_all
2564: where top_model_line_id = oe_line_security.g_record.top_model_line_id
2565: and item_type_code = 'CONFIG'
2566: and rownum = 1;
2567:
2568: IF PG_DEBUG <> 0 THEN

Line 2682: where line_id = oe_line_security.g_record.line_id

2678:
2679: select 1
2680: into l_top_ato_model
2681: from oe_order_lines_all
2682: where line_id = oe_line_security.g_record.line_id
2683: and ato_line_id = line_id;
2684:
2685: x_result := 1; /* the condition is true */
2686: IF PG_DEBUG <> 0 THEN

Line 2753: where line_id = oe_line_security.g_record.line_id

2749:
2750: select 1
2751: into l_config_item
2752: from oe_order_lines_all
2753: where line_id = oe_line_security.g_record.line_id
2754: and item_type_code = 'CONFIG';
2755:
2756: IF PG_DEBUG <> 0 THEN
2757: oe_debug_pub.add('Config_Line: ' || 'This is a config item.', 5);

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

3267: l_ato_line_id,
3268: l_inv_item_id,
3269: l_ship_org
3270: FROM OE_ORDER_LINES_ALL
3271: WHERE line_id = oe_line_security.g_record.line_id;
3272:
3273:
3274: --Adding INCLUDED item type code for SUN ER#9793792
3275: --IF l_item_type_code in ('STANDARD','OPTION') AND

Line 3277: l_ato_line_id = oe_line_security.g_record.line_id THEN

3273:
3274: --Adding INCLUDED item type code for SUN ER#9793792
3275: --IF l_item_type_code in ('STANDARD','OPTION') AND
3276: IF l_item_type_code in ('STANDARD','OPTION','INCLUDED') AND
3277: l_ato_line_id = oe_line_security.g_record.line_id THEN
3278:
3279: CTO_UTILITY_PK.query_sourcing_org(
3280: p_inventory_item_id => l_inv_item_id,
3281: p_organization_id => l_ship_org,

Line 3380: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;

3376: end if;
3377:
3378:
3379: IF PG_DEBUG <> 0 THEN
3380: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
3381: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
3382: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
3383: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
3384: oe_debug_pub.add( ' LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;

Line 3381: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;

3377:
3378:
3379: IF PG_DEBUG <> 0 THEN
3380: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
3381: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
3382: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
3383: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
3384: oe_debug_pub.add( ' LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
3385: END IF;

Line 3382: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;

3378:
3379: IF PG_DEBUG <> 0 THEN
3380: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
3381: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
3382: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
3383: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
3384: oe_debug_pub.add( ' LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
3385: END IF;
3386: l_stmt_num := 5;

Line 3383: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;

3379: IF PG_DEBUG <> 0 THEN
3380: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
3381: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
3382: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
3383: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
3384: oe_debug_pub.add( ' LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
3385: END IF;
3386: l_stmt_num := 5;
3387: select ato_line_id, header_id , inventory_item_id

Line 3384: oe_debug_pub.add( ' LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;

3380: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
3381: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
3382: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
3383: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
3384: oe_debug_pub.add( ' LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
3385: END IF;
3386: l_stmt_num := 5;
3387: select ato_line_id, header_id , inventory_item_id
3388: into l_ato_line_id, l_header_id , l_cfg_item_id

Line 3390: where line_id = oe_line_security.g_record.line_id

3386: l_stmt_num := 5;
3387: select ato_line_id, header_id , inventory_item_id
3388: into l_ato_line_id, l_header_id , l_cfg_item_id
3389: from oe_order_lines_all
3390: where line_id = oe_line_security.g_record.line_id
3391: and item_type_code <> 'STANDARD'
3392: and ato_line_id is not null;
3393:
3394:

Line 3409: if( oe_line_security.g_record.split_action_code = 'SPLIT' ) then /* bug 3424802 */

3405:
3406:
3407:
3408:
3409: if( oe_line_security.g_record.split_action_code = 'SPLIT' ) then /* bug 3424802 */
3410: IF PG_DEBUG <> 0 THEN
3411: oe_debug_pub.add( 'no need to check for CIB attribute for split scenario ' , 1) ;
3412: END IF;
3413: else