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.CZ_BOM_CONFIG_EXPLOSIONS_PKG dependencies on BOM_CTO_ORDER_LINES

Line 44: | BOM_CTO_ORDER_LINES_S1

Line 135: TYPE bcol_tbl_type is table of bom_cto_order_lines%rowtype INDEX by BINARY_INTEGER ;

131: +=======================================================================
132: */
133:
134:
135: TYPE bcol_tbl_type is table of bom_cto_order_lines%rowtype INDEX by BINARY_INTEGER ;
136:
137: PROCEDURE INSERT_INTO_BCOL (
138: p_bcol_tab bcol_tbl_type
139: );

Line 147: p_bcol_line_id in bom_cto_order_lines.line_id%type );

143: ) ;
144:
145: PROCEDURE populate_parent_ato
146: ( p_t_bcol in out NOCOPY bcol_tbl_type,
147: p_bcol_line_id in bom_cto_order_lines.line_id%type );
148:
149: PROCEDURE populate_plan_level
150: ( p_t_bcol in out NOCOPY bcol_tbl_type );
151:

Line 180: p_top_ato_line_id in bom_cto_order_lines.ato_line_id%type,

176: procedure create_preconfig_item_ml(
177: p_use_matched_item in varchar2,
178: p_match_profile_on in varchar2,
179: p_top_predefined_item_id in number,
180: p_top_ato_line_id in bom_cto_order_lines.ato_line_id%type,
181: x_bill_sequence_id out number,
182: x_mlmo_item_created out varchar2
183: ) ;
184:

Line 188: p_ato_line_id in bom_cto_order_lines.ato_line_id%type ,

184:
185: */
186:
187: procedure perform_match(
188: p_ato_line_id in bom_cto_order_lines.ato_line_id%type ,
189: x_match_found out NOCOPY varchar2,
190: x_matching_config_id out NOCOPY number,
191: x_error_message out NOCOPY VARCHAR2,
192: x_message_name out NOCOPY varchar2

Line 1038: -- Created a new sequence for Bom_cto_order_lines table

1034: bcol_index := bcol_tab.count + 1 ;
1035:
1036: --multiplied by -1 to generate -ve sequnnce 'kkonada'
1037: -- Modified by Renga Kannan on 11/19/01
1038: -- Created a new sequence for Bom_cto_order_lines table
1039: -- Generate the line_id column with this new sequence
1040: -- This seqence will be a -ve sequence by itself.
1041: -- The -ve seq is used to avoid converging with om line_id
1042: -- IN the case of Bcol generation for Sales order

Line 1046: select bom_cto_order_lines_s1.nextval

1042: -- IN the case of Bcol generation for Sales order
1043: -- Line_id is populated with Oe_line_id
1044:
1045:
1046: select bom_cto_order_lines_s1.nextval
1047: into bcol_tab(bcol_index).line_id
1048: from dual ;
1049: /* Temporary Fix, Need a new sequence for bom_cto_order_lines */
1050:

Line 1049: /* Temporary Fix, Need a new sequence for bom_cto_order_lines */

1045:
1046: select bom_cto_order_lines_s1.nextval
1047: into bcol_tab(bcol_index).line_id
1048: from dual ;
1049: /* Temporary Fix, Need a new sequence for bom_cto_order_lines */
1050:
1051: /*
1052: bcol_tab(bcol_index).header_id := config_data_tab(1).parent_config_item_id ;
1053: */

Line 1350: select /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

1346:
1347: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'PROCESS_CONFIGURATOR_DATA' , 'done CTOMCFGB perform_match ' ) ;
1348:
1349:
1350: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1351: perform_match , config_item_id into x_match_found , x_top_matched_item_id
1352: from bom_cto_order_lines_gt
1353: where line_id = v_ato_line_id ;
1354:

Line 1352: from bom_cto_order_lines_gt

1348:
1349:
1350: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1351: perform_match , config_item_id into x_match_found , x_top_matched_item_id
1352: from bom_cto_order_lines_gt
1353: where line_id = v_ato_line_id ;
1354:
1355: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'PROCESS_CONFIGURATOR_DATA' , 'CTOMCFGB perform_match result ' || x_match_found ) ;
1356:

Line 1378: from bom_cto_order_lines

1374:
1375: select line_id, ato_line_id, inventory_item_id, config_item_id , perform_match
1376: into v_ck_line_id, v_ck_ato_line_id, v_ck_inventory_item_id,
1377: v_ck_config_item_id, v_ck_perform_match
1378: from bom_cto_order_lines
1379: where line_id = v_ato_line_id ;
1380:
1381: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' , ' BCOL INFO ' || v_ck_line_id) ;
1382:

Line 1419: p_top_ato_line_id in bom_cto_order_lines.ato_line_id%type,

1415: p_use_matched_item in varchar2,
1416: p_match_profile_on in varchar2,
1417: p_top_predefined_item_id in number,
1418: p_top_matched_item_id in number,
1419: p_top_ato_line_id in bom_cto_order_lines.ato_line_id%type,
1420: p_current_org_id in number ,
1421: x_bill_sequence_id out NOCOPY number,
1422: x_mlmo_item_created out NOCOPY varchar2,
1423: x_routing_exists out NOCOPY varchar2,

Line 1540: p_top_ato_line_id in bom_cto_order_lines.ato_line_id%type,

1536: p_use_matched_item in varchar2,
1537: p_match_profile_on in varchar2,
1538: p_top_predefined_item_id in number,
1539: p_top_matched_item_id in number,
1540: p_top_ato_line_id in bom_cto_order_lines.ato_line_id%type,
1541: p_current_org_id in number ,
1542: x_bill_sequence_id out NOCOPY number,
1543: x_mlmo_item_created out NOCOPY varchar2,
1544: x_routing_exists out NOCOPY varchar2,

Line 1565: from bom_cto_order_lines

1561:
1562: lPerformMatch varchar2(1) ;
1563: cursor c_can_configurations is
1564: select line_id, inventory_item_id , parent_ato_line_id , perform_match
1565: from bom_cto_order_lines
1566: where bom_item_type = '1'
1567: and ato_line_id = p_top_ato_line_id
1568: and nvl(wip_supply_type,0) <> 6
1569: order by plan_level desc;

Line 1615: from bom_cto_order_lines

1611:
1612: select line_id, ato_line_id, inventory_item_id, config_item_id , perform_match
1613: into v_ck_line_id, v_ck_ato_line_id, v_ck_inventory_item_id,
1614: v_ck_config_item_id, v_ck_perform_match
1615: from bom_cto_order_lines
1616: where line_id = p_top_ato_line_id ;
1617:
1618: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' , ' line_id ' || v_ck_line_id) ;
1619: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' , ' ato_line_id ' || v_ck_ato_line_id) ;

Line 1636: update bom_cto_order_lines set config_item_id = p_top_predefined_item_id

1632:
1633: -- insert into my_debug_messages values ( ' user has not opted to use matched item') ;
1634: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' , ' user has not opted to use matched item') ;
1635:
1636: update bom_cto_order_lines set config_item_id = p_top_predefined_item_id
1637: , perform_match = 'U' where line_id = p_top_ato_line_id ;
1638:
1639: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1640: bom_cto_order_lines_gt

Line 1639: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

1635:
1636: update bom_cto_order_lines set config_item_id = p_top_predefined_item_id
1637: , perform_match = 'U' where line_id = p_top_ato_line_id ;
1638:
1639: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1640: bom_cto_order_lines_gt
1641: set config_item_id = p_top_predefined_item_id
1642: , perform_match = 'U'
1643: where line_id = p_top_ato_line_id ;

Line 1640: bom_cto_order_lines_gt

1636: update bom_cto_order_lines set config_item_id = p_top_predefined_item_id
1637: , perform_match = 'U' where line_id = p_top_ato_line_id ;
1638:
1639: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1640: bom_cto_order_lines_gt
1641: set config_item_id = p_top_predefined_item_id
1642: , perform_match = 'U'
1643: where line_id = p_top_ato_line_id ;
1644:

Line 1650: update bom_cto_order_lines set config_item_id = p_top_predefined_item_id

1646:
1647: elsif( p_use_matched_item = 'N' ) then
1648:
1649:
1650: update bom_cto_order_lines set config_item_id = p_top_predefined_item_id
1651: , perform_match = 'N' where line_id = p_top_ato_line_id ;
1652:
1653: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1654: bom_cto_order_lines_gt

Line 1653: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

1649:
1650: update bom_cto_order_lines set config_item_id = p_top_predefined_item_id
1651: , perform_match = 'N' where line_id = p_top_ato_line_id ;
1652:
1653: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1654: bom_cto_order_lines_gt
1655: set config_item_id = p_top_predefined_item_id
1656: , perform_match = 'N'
1657: where line_id = p_top_ato_line_id ;

Line 1654: bom_cto_order_lines_gt

1650: update bom_cto_order_lines set config_item_id = p_top_predefined_item_id
1651: , perform_match = 'N' where line_id = p_top_ato_line_id ;
1652:
1653: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1654: bom_cto_order_lines_gt
1655: set config_item_id = p_top_predefined_item_id
1656: , perform_match = 'N'
1657: where line_id = p_top_ato_line_id ;
1658:

Line 1728: from bom_cto_order_lines

1724: -- as SELECT statement instead of using a CURSOR for multi-row
1725:
1726: select inventory_item_id , nvl(program_id,0) ,config_item_id
1727: into l_top_model_id,lprogram_id,lconfig_item_id
1728: from bom_cto_order_lines
1729: where line_id=p_top_ato_line_id ;
1730:
1731: oe_debug_pub.add ('Top Model Id : '||to_char(l_top_model_id)||' Program_id : '||to_char(lprogram_id)||' Config Item Id : '||to_char(lconfig_item_id), 2);
1732:

Line 1784: from bom_cto_order_lines

1780:
1781: select line_id, ato_line_id, inventory_item_id, config_item_id , perform_match
1782: into v_ck_line_id, v_ck_ato_line_id, v_ck_inventory_item_id,
1783: v_ck_config_item_id, v_ck_perform_match
1784: from bom_cto_order_lines
1785: where line_id = p_top_ato_line_id ;
1786:
1787: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' , ' BEFORE ITEM CHECK BCOL ' || v_ck_line_id) ;
1788: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' , ' line_id ' || v_ck_line_id) ;

Line 1958: from bom_cto_order_lines

1954: v_step := 'Step 34b ' ;
1955:
1956: select perform_match
1957: into lPerformMatch
1958: from bom_cto_order_lines
1959: where line_id = lNextRec.line_id;
1960:
1961:
1962: if( lPerformMatch = 'N' ) then

Line 2077: delete from bom_cto_order_lines

2073:
2074:
2075: v_step := 'Step 60 ' ;
2076:
2077: delete from bom_cto_order_lines
2078: where ato_line_id = p_top_ato_line_id ;
2079:
2080: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' , ' deleted bcol ' || to_char(sql%rowcount)) ;
2081:

Line 2234: p_bcol_line_id in bom_cto_order_lines.line_id%type )

2230:
2231:
2232: PROCEDURE populate_parent_ato
2233: ( p_t_bcol in out NOCOPY bcol_tbl_type,
2234: p_bcol_line_id in bom_cto_order_lines.line_id%type )
2235: is
2236: TYPE TABNUM is TABLE of NUMBER index by binary_integer ;
2237: v_raw_line_id TABNUM ;
2238: v_src_point number ;

Line 2468: Insert into bom_cto_order_lines_gt(

2464: ' parent line_id ' || p_bcol_tab(i).parent_ato_line_id ||
2465: ' parent qty ' || p_bcol_tab(p_bcol_tab(i).parent_ato_line_id ).ordered_quantity , 1) ;
2466: v_step := i ;
2467:
2468: Insert into bom_cto_order_lines_gt(
2469: HEADER_ID ,
2470: LINE_ID ,
2471: LINK_TO_LINE_ID ,
2472: ATO_LINE_ID ,

Line 2610: p_ato_line_id in bom_cto_order_lines.ato_line_id%type ,

2606:
2607:
2608:
2609: procedure perform_match(
2610: p_ato_line_id in bom_cto_order_lines.ato_line_id%type ,
2611: x_match_found out NOCOPY varchar2,
2612: x_matching_config_id out NOCOPY number,
2613: x_error_message out NOCOPY VARCHAR2,
2614: x_message_name out NOCOPY varchar2

Line 2653: from bom_cto_order_lines

2649:
2650:
2651: cursor c_model_lines is
2652: select line_id, parent_ato_line_id
2653: from bom_cto_order_lines
2654: where bom_item_type = '1'
2655: and ato_line_id = p_ato_line_id
2656: and nvl(wip_supply_type,0) <> 6
2657: order by plan_level desc;

Line 2679: select /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

2675: l_x_config_id := NULL;
2676:
2677:
2678:
2679: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2680: perform_match into l_perform_match
2681: from bom_cto_order_lines_gt
2682: where line_id = l_next_rec.line_id ;
2683:

Line 2681: from bom_cto_order_lines_gt

2677:
2678:
2679: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2680: perform_match into l_perform_match
2681: from bom_cto_order_lines_gt
2682: where line_id = l_next_rec.line_id ;
2683:
2684:
2685:

Line 2690: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

2686: if( l_perform_match = 'N' ) then
2687:
2688: begin
2689:
2690: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2691: bom_cto_order_lines_gt set perform_match = 'N'
2692: where perform_match = 'Y'
2693: and line_id = l_next_rec.parent_ato_line_id ;
2694:

Line 2691: bom_cto_order_lines_gt set perform_match = 'N'

2687:
2688: begin
2689:
2690: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2691: bom_cto_order_lines_gt set perform_match = 'N'
2692: where perform_match = 'Y'
2693: and line_id = l_next_rec.parent_ato_line_id ;
2694:
2695: exception

Line 2763: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

2759:
2760:
2761: /* update the perform match column to 'N' so that this item is canned */
2762: begin
2763: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2764: bom_cto_order_lines_gt
2765: set perform_match = 'N'
2766: where line_id = l_next_rec.line_id
2767: and perform_match = 'Y';

Line 2764: bom_cto_order_lines_gt

2760:
2761: /* update the perform match column to 'N' so that this item is canned */
2762: begin
2763: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2764: bom_cto_order_lines_gt
2765: set perform_match = 'N'
2766: where line_id = l_next_rec.line_id
2767: and perform_match = 'Y';
2768:

Line 2782: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

2778: is attempted against its parent and it is canned
2779: */
2780:
2781: begin
2782: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2783: bom_cto_order_lines_gt
2784: set perform_match = 'N'
2785: where line_id = l_next_rec.parent_ato_line_id
2786: and perform_match = 'Y';

Line 2783: bom_cto_order_lines_gt

2779: */
2780:
2781: begin
2782: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2783: bom_cto_order_lines_gt
2784: set perform_match = 'N'
2785: where line_id = l_next_rec.parent_ato_line_id
2786: and perform_match = 'Y';
2787:

Line 2807: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

2803: || to_char(l_next_rec.line_id)
2804: || ' is ' || to_char(l_x_config_id) ,1);
2805: */
2806:
2807: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2808: bom_cto_order_lines_gt
2809: set config_item_id = l_x_config_id
2810: where line_id = l_next_rec.line_id;
2811:

Line 2808: bom_cto_order_lines_gt

2804: || ' is ' || to_char(l_x_config_id) ,1);
2805: */
2806:
2807: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2808: bom_cto_order_lines_gt
2809: set config_item_id = l_x_config_id
2810: where line_id = l_next_rec.line_id;
2811:
2812: l_stmt_num := 40 ;