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 2143: v_model_id := oe_line_security.g_record.ato_line_id; /* refer to a global record */

2139: -- find the top_model_line_id when given an option line id
2140: --
2141: l_stmt_num := 10;
2142:
2143: v_model_id := oe_line_security.g_record.ato_line_id; /* refer to a global record */
2144: v_header_id := oe_line_security.g_record.header_id;
2145:
2146: --
2147: -- if not an ATO model line, condition is false, return 0

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

2140: --
2141: l_stmt_num := 10;
2142:
2143: v_model_id := oe_line_security.g_record.ato_line_id; /* refer to a global record */
2144: v_header_id := oe_line_security.g_record.header_id;
2145:
2146: --
2147: -- if not an ATO model line, condition is false, return 0
2148: --

Line 2241: where line_id = oe_line_security.g_record.line_id

2237: l_stmt_num := 5;
2238: select ato_line_id, header_id
2239: into l_ato_line_id, l_header_id
2240: from oe_order_lines_all
2241: where line_id = oe_line_security.g_record.line_id
2242: and item_type_code <> 'STANDARD'
2243: and ato_line_id is not null;
2244:
2245: -- check if the config item is created

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

2252: and ato_line_id = l_ato_line_id
2253: and item_type_code = 'CONFIG';
2254:
2255:
2256: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
2257: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
2258: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
2259: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
2260: oe_debug_pub.add( 'LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;

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

2253: and item_type_code = 'CONFIG';
2254:
2255:
2256: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
2257: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
2258: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
2259: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
2260: oe_debug_pub.add( 'LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
2261:

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

2254:
2255:
2256: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
2257: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
2258: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
2259: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
2260: oe_debug_pub.add( 'LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
2261:
2262:

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

2255:
2256: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
2257: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
2258: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
2259: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
2260: oe_debug_pub.add( 'LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
2261:
2262:
2263:

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

2256: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
2257: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
2258: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
2259: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
2260: oe_debug_pub.add( 'LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
2261:
2262:
2263:
2264: x_result := 1; /* the condition is true */

Line 2423: where line_id = oe_line_security.g_record.line_id

2419:
2420: select 1
2421: into l_config_item
2422: from oe_order_lines_all
2423: where line_id = oe_line_security.g_record.line_id
2424: and item_type_code = 'CONFIG';
2425:
2426: IF PG_DEBUG <> 0 THEN
2427: oe_debug_pub.add('configuration_created: ' || 'This is a config item. Check if update is user or system', 5);

Line 2504: where top_model_line_id = oe_line_security.g_record.top_model_line_id

2500:
2501: CURSOR c_config_exists IS
2502: select ato_line_id
2503: from oe_order_lines_all
2504: where top_model_line_id = oe_line_security.g_record.top_model_line_id
2505: and item_type_code = 'CONFIG';
2506:
2507: BEGIN
2508: IF PG_DEBUG <> 0 THEN

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

2512: -- Check if the line is not an ATO model, option, option class, or
2513: -- config line
2514:
2515: l_stmt_num := 10;
2516: IF oe_line_security.g_record.ato_line_id IS NOT NULL THEN
2517: IF PG_DEBUG <> 0 THEN
2518: oe_debug_pub.add('configuration_created_for_pto: ' || 'This is not a PTO item, constraint condition is false', 5);
2519: END IF;
2520: x_result := 0;

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

2524: l_stmt_num := 20;
2525: IF PG_DEBUG <> 0 THEN
2526: oe_debug_pub.add('configuration_created_for_pto: ' || 'This is a PTO item', 5);
2527: END IF;
2528: l_pto_line := oe_line_security.g_record.line_id;
2529: IF PG_DEBUG <> 0 THEN
2530: oe_debug_pub.add('configuration_created_for_pto: ' || 'l_pto_line = '||to_char(l_pto_line), 5);
2531: END IF;
2532:

Line 2537: where top_model_line_id = oe_line_security.g_record.top_model_line_id

2533: l_stmt_num := 30;
2534: select 1
2535: into l_config_exists
2536: from oe_order_lines_all
2537: where top_model_line_id = oe_line_security.g_record.top_model_line_id
2538: and item_type_code = 'CONFIG'
2539: and rownum = 1;
2540:
2541: IF PG_DEBUG <> 0 THEN

Line 2655: where line_id = oe_line_security.g_record.line_id

2651:
2652: select 1
2653: into l_top_ato_model
2654: from oe_order_lines_all
2655: where line_id = oe_line_security.g_record.line_id
2656: and ato_line_id = line_id;
2657:
2658: x_result := 1; /* the condition is true */
2659: IF PG_DEBUG <> 0 THEN

Line 2726: where line_id = oe_line_security.g_record.line_id

2722:
2723: select 1
2724: into l_config_item
2725: from oe_order_lines_all
2726: where line_id = oe_line_security.g_record.line_id
2727: and item_type_code = 'CONFIG';
2728:
2729: IF PG_DEBUG <> 0 THEN
2730: oe_debug_pub.add('Config_Line: ' || 'This is a config item.', 5);

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

3237: l_ato_line_id,
3238: l_inv_item_id,
3239: l_ship_org
3240: FROM OE_ORDER_LINES_ALL
3241: WHERE line_id = oe_line_security.g_record.line_id;
3242:
3243:
3244: IF l_item_type_code in ('STANDARD','OPTION') AND
3245: l_ato_line_id = oe_line_security.g_record.line_id THEN

Line 3245: l_ato_line_id = oe_line_security.g_record.line_id THEN

3241: WHERE line_id = oe_line_security.g_record.line_id;
3242:
3243:
3244: IF l_item_type_code in ('STANDARD','OPTION') AND
3245: l_ato_line_id = oe_line_security.g_record.line_id THEN
3246:
3247: CTO_UTILITY_PK.query_sourcing_org(
3248: p_inventory_item_id => l_inv_item_id,
3249: p_organization_id => l_ship_org,

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

3344: end if;
3345:
3346:
3347: IF PG_DEBUG <> 0 THEN
3348: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
3349: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
3350: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
3351: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
3352: oe_debug_pub.add( ' LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;

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

3345:
3346:
3347: IF PG_DEBUG <> 0 THEN
3348: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
3349: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
3350: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
3351: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
3352: oe_debug_pub.add( ' LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
3353: END IF;

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

3346:
3347: IF PG_DEBUG <> 0 THEN
3348: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
3349: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
3350: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
3351: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
3352: oe_debug_pub.add( ' LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
3353: END IF;
3354: l_stmt_num := 5;

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

3347: IF PG_DEBUG <> 0 THEN
3348: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
3349: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
3350: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
3351: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
3352: oe_debug_pub.add( ' LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
3353: END IF;
3354: l_stmt_num := 5;
3355: select ato_line_id, header_id , inventory_item_id

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

3348: oe_debug_pub.add( 'ACTION CODE: ' || oe_line_security.g_record.split_action_code , 1 ) ;
3349: oe_debug_pub.add( 'OPERATION: ' || oe_line_security.g_record.operation , 1 ) ;
3350: oe_debug_pub.add( 'ATTRIBUTE 1: ' || oe_line_security.g_record.attribute1 , 1 ) ;
3351: oe_debug_pub.add( 'SPLIT FROM LINE ID: ' || oe_line_security.g_record.split_from_line_id , 1 ) ;
3352: oe_debug_pub.add( ' LINE ID: ' || oe_line_security.g_record.line_id , 1 ) ;
3353: END IF;
3354: l_stmt_num := 5;
3355: select ato_line_id, header_id , inventory_item_id
3356: into l_ato_line_id, l_header_id , l_cfg_item_id

Line 3358: where line_id = oe_line_security.g_record.line_id

3354: l_stmt_num := 5;
3355: select ato_line_id, header_id , inventory_item_id
3356: into l_ato_line_id, l_header_id , l_cfg_item_id
3357: from oe_order_lines_all
3358: where line_id = oe_line_security.g_record.line_id
3359: and item_type_code <> 'STANDARD'
3360: and ato_line_id is not null;
3361:
3362:

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

3373:
3374:
3375:
3376:
3377: if( oe_line_security.g_record.split_action_code = 'SPLIT' ) then /* bug 3424802 */
3378: IF PG_DEBUG <> 0 THEN
3379: oe_debug_pub.add( 'no need to check for CIB attribute for split scenario ' , 1) ;
3380: END IF;
3381: else