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.

[Home] [Help]

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 1041: -- Created a new sequence for Bom_cto_order_lines table

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

Line 1049: select bom_cto_order_lines_s1.nextval

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

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

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

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

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

Line 1355: from bom_cto_order_lines_gt

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

Line 1381: from bom_cto_order_lines

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

Line 1422: p_top_ato_line_id in bom_cto_order_lines.ato_line_id%type,

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

Line 1543: p_top_ato_line_id in bom_cto_order_lines.ato_line_id%type,

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

Line 1568: from bom_cto_order_lines

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

Line 1618: from bom_cto_order_lines

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

Line 1639: update bom_cto_order_lines set config_item_id = p_top_predefined_item_id

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

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

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

Line 1643: bom_cto_order_lines_gt

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

Line 1653: update bom_cto_order_lines set config_item_id = p_top_predefined_item_id

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

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

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

Line 1657: bom_cto_order_lines_gt

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

Line 1731: from bom_cto_order_lines

1727: -- as SELECT statement instead of using a CURSOR for multi-row
1728:
1729: select inventory_item_id , nvl(program_id,0) ,config_item_id
1730: into l_top_model_id,lprogram_id,lconfig_item_id
1731: from bom_cto_order_lines
1732: where line_id=p_top_ato_line_id ;
1733:
1734: 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);
1735:

Line 1787: from bom_cto_order_lines

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

Line 1961: from bom_cto_order_lines

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

Line 2080: delete from bom_cto_order_lines

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

Line 2239: p_bcol_line_id in bom_cto_order_lines.line_id%type )

2235:
2236:
2237: PROCEDURE populate_parent_ato
2238: ( p_t_bcol in out NOCOPY bcol_tbl_type,
2239: p_bcol_line_id in bom_cto_order_lines.line_id%type )
2240: is
2241: TYPE TABNUM is TABLE of NUMBER index by binary_integer ;
2242: v_raw_line_id TABNUM ;
2243: v_src_point number ;

Line 2473: Insert into bom_cto_order_lines_gt(

2469: ' parent line_id ' || p_bcol_tab(i).parent_ato_line_id ||
2470: ' parent qty ' || p_bcol_tab(p_bcol_tab(i).parent_ato_line_id ).ordered_quantity , 1) ;
2471: v_step := i ;
2472:
2473: Insert into bom_cto_order_lines_gt(
2474: HEADER_ID ,
2475: LINE_ID ,
2476: LINK_TO_LINE_ID ,
2477: ATO_LINE_ID ,

Line 2615: p_ato_line_id in bom_cto_order_lines.ato_line_id%type ,

2611:
2612:
2613:
2614: procedure perform_match(
2615: p_ato_line_id in bom_cto_order_lines.ato_line_id%type ,
2616: x_match_found out NOCOPY varchar2,
2617: x_matching_config_id out NOCOPY number,
2618: x_error_message out NOCOPY VARCHAR2,
2619: x_message_name out NOCOPY varchar2

Line 2658: from bom_cto_order_lines

2654:
2655:
2656: cursor c_model_lines is
2657: select line_id, parent_ato_line_id
2658: from bom_cto_order_lines
2659: where bom_item_type = '1'
2660: and ato_line_id = p_ato_line_id
2661: and nvl(wip_supply_type,0) <> 6
2662: order by plan_level desc;

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

2680: l_x_config_id := NULL;
2681:
2682:
2683:
2684: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2685: perform_match into l_perform_match
2686: from bom_cto_order_lines_gt
2687: where line_id = l_next_rec.line_id ;
2688:

Line 2686: from bom_cto_order_lines_gt

2682:
2683:
2684: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2685: perform_match into l_perform_match
2686: from bom_cto_order_lines_gt
2687: where line_id = l_next_rec.line_id ;
2688:
2689:
2690:

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

2691: if( l_perform_match = 'N' ) then
2692:
2693: begin
2694:
2695: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2696: bom_cto_order_lines_gt set perform_match = 'N'
2697: where perform_match = 'Y'
2698: and line_id = l_next_rec.parent_ato_line_id ;
2699:

Line 2696: bom_cto_order_lines_gt set perform_match = 'N'

2692:
2693: begin
2694:
2695: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2696: bom_cto_order_lines_gt set perform_match = 'N'
2697: where perform_match = 'Y'
2698: and line_id = l_next_rec.parent_ato_line_id ;
2699:
2700: exception

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

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

Line 2769: bom_cto_order_lines_gt

2765:
2766: /* update the perform match column to 'N' so that this item is canned */
2767: begin
2768: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2769: bom_cto_order_lines_gt
2770: set perform_match = 'N'
2771: where line_id = l_next_rec.line_id
2772: and perform_match = 'Y';
2773:

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

2783: is attempted against its parent and it is canned
2784: */
2785:
2786: begin
2787: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2788: bom_cto_order_lines_gt
2789: set perform_match = 'N'
2790: where line_id = l_next_rec.parent_ato_line_id
2791: and perform_match = 'Y';

Line 2788: bom_cto_order_lines_gt

2784: */
2785:
2786: begin
2787: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2788: bom_cto_order_lines_gt
2789: set perform_match = 'N'
2790: where line_id = l_next_rec.parent_ato_line_id
2791: and perform_match = 'Y';
2792:

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

2808: || to_char(l_next_rec.line_id)
2809: || ' is ' || to_char(l_x_config_id) ,1);
2810: */
2811:
2812: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2813: bom_cto_order_lines_gt
2814: set config_item_id = l_x_config_id
2815: where line_id = l_next_rec.line_id;
2816:

Line 2813: bom_cto_order_lines_gt

2809: || ' is ' || to_char(l_x_config_id) ,1);
2810: */
2811:
2812: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2813: bom_cto_order_lines_gt
2814: set config_item_id = l_x_config_id
2815: where line_id = l_next_rec.line_id;
2816:
2817: l_stmt_num := 40 ;