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.BOM_IMPORT_PUB dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 345: BOM_INVENTORY_COMPS_INTERFACE

341: and batch_id = p_batch_id
342: and process_flag = 1;
343:
344: update
345: BOM_INVENTORY_COMPS_INTERFACE
346: set
347: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
348: where
349: transaction_id is null

Line 415: UPDATE bom_inventory_comps_interface

411: WHERE batch_id = p_batch_id
412: AND (process_flag = 1 OR process_flag = 5);
413: -- AND alternate_bom_designator IS NOT NULL;
414:
415: UPDATE bom_inventory_comps_interface
416: SET alternate_bom_designator = pg_batch_options.structure_name
417: WHERE batch_id = p_batch_id
418: AND ( process_flag = 1 OR process_flag = 5);
419: -- AND alternate_bom_designator IS NOT NULL;

Line 457: bom_inventory_comps_interface

453: AND EFFECTIVITY_CONTROL is NULL;
454:
455: IF (pg_batch_options.EFFECTIVITY_DATE IS NOT NULL) THEN
456: UPDATE
457: bom_inventory_comps_interface
458: SET
459: EFFECTIVITY_DATE = pg_batch_options.EFFECTIVITY_DATE
460: WHERE
461: EFFECTIVITY_DATE IS NULL

Line 477: bom_inventory_comps_interface

473: AND (process_flag = 1 OR process_flag = 5)
474: AND EFFECTIVITY_CONTROL is NULL;
475: IF (pg_batch_options.FROM_END_ITEM_UNIT_NUMBER IS NOT NULL) THEN
476: UPDATE
477: bom_inventory_comps_interface
478: SET
479: FROM_END_ITEM_UNIT_NUMBER = pg_batch_options.FROM_END_ITEM_UNIT_NUMBER
480: WHERE
481: FROM_END_ITEM_UNIT_NUMBER IS NULL

Line 622: bom_inventory_comps_interface

618: component_item_id,
619: new_operation_seq_num,
620: new_effectivity_date
621: FROM
622: bom_inventory_comps_interface
623: WHERE
624: batch_id = p_batch_id AND comp_source_system_reference = p_comp_rec_id;*
625: FETCH l_src_attrs INTO l_comp_id,l_op_seq_num,l_effec_date;
626: CLOSE l_src_attrs;*/

Line 631: FROM bom_components_b BCB,bom_inventory_comps_interface BICI

627: BEGIN
628:
629: SELECT BCB.component_sequence_id
630: INTO l_comp_seq_id
631: FROM bom_components_b BCB,bom_inventory_comps_interface BICI
632: WHERE BICI.batch_id = p_batch_id
633: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
634: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
635: AND BCB.bill_sequence_id = p_bill_seq_id

Line 649: FROM bom_inventory_comps_interface

645: NULL;
646: END;
647: ELSIF p_effec_control = 2 THEN
648: /*OPEN l_src_attrs FOR SELECT component_item_id,operation_seq_num,from_end_item_unit_number
649: FROM bom_inventory_comps_interface
650: WHERE batch_id = p_batch_id AND comp_source_system_reference = p_comp_rec_id;
651: FETCH l_src_attrs INTO l_comp_id,l_op_seq_num,l_from_unit_number;
652: CLOSE l_src_attrs;*/
653: BEGIN

Line 656: FROM bom_components_b BCB,bom_inventory_comps_interface BICI

652: CLOSE l_src_attrs;*/
653: BEGIN
654: SELECT BCB.component_sequence_id
655: INTO l_comp_seq_id
656: FROM bom_components_b BCB,bom_inventory_comps_interface BICI
657: WHERE BICI.batch_id = p_batch_id
658: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
659: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
660: AND BCB.bill_sequence_id = p_bill_seq_id

Line 675: FROM bom_components_b BCB,bom_inventory_comps_interface BICI,Mtl_Item_Revisions MIR

671: ELSIF p_effec_control = 4 THEN
672: BEGIN
673: SELECT BCB.component_sequence_id
674: INTO l_comp_seq_id
675: FROM bom_components_b BCB,bom_inventory_comps_interface BICI,Mtl_Item_Revisions MIR
676: WHERE BICI.batch_id = p_batch_id
677: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
678: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
679: AND BCB.bill_sequence_id = p_bill_seq_id

Line 726: FROM bom_components_b BCB,bom_inventory_comps_interface BICI

722: -- we should check if the component with sysdate as effective date exists or not.
723: IF UPPER(p_transaction_type) IN ('ADD','CREATE') THEN
724: SELECT BCB.component_sequence_id
725: INTO l_comp_seq_id
726: FROM bom_components_b BCB,bom_inventory_comps_interface BICI
727: WHERE BICI.batch_id = p_batch_id
728: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
729: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
730: AND BCB.bill_sequence_id = p_bill_seq_id

Line 741: FROM bom_components_b BCB,bom_inventory_comps_interface BICI

737: OR(pg_batch_options.CHANGE_NOTICE IS NOT NULL AND BCB.implementation_date IS NULL AND BCB.change_notice = pg_batch_options.CHANGE_NOTICE));
738: ELSE
739: SELECT BCB.component_sequence_id
740: INTO l_comp_seq_id
741: FROM bom_components_b BCB,bom_inventory_comps_interface BICI
742: WHERE BICI.batch_id = p_batch_id
743: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
744: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
745: AND BCB.bill_sequence_id = p_bill_seq_id

Line 763: FROM bom_components_b BCB,bom_inventory_comps_interface BICI

759: ELSIF p_effec_control = 2 THEN
760: BEGIN
761: SELECT BCB.component_sequence_id
762: INTO l_comp_seq_id
763: FROM bom_components_b BCB,bom_inventory_comps_interface BICI
764: WHERE BICI.batch_id = p_batch_id
765: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
766: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
767: AND BCB.bill_sequence_id = p_bill_seq_id

Line 784: FROM bom_components_b BCB,bom_inventory_comps_interface BICI,Mtl_Item_Revisions MIR

780: ELSIF p_effec_control = 4 THEN
781: BEGIN
782: SELECT BCB.component_sequence_id
783: INTO l_comp_seq_id
784: FROM bom_components_b BCB,bom_inventory_comps_interface BICI,Mtl_Item_Revisions MIR
785: WHERE BICI.batch_id = p_batch_id
786: AND (BICI.comp_source_system_reference = p_comp_rec_id OR BICI.component_item_number = p_comp_rec_id)
787: AND (BICI.process_flag = 1 or BICI.process_flag = 5 )
788: AND BCB.bill_sequence_id = p_bill_seq_id

Line 1029: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

1025:
1026: x_retcode := l_ret_code;
1027: x_errbuff := l_err_buff;
1028: -- Bug 10044476 - Add defaulting of component sequence id for delete case
1029: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
1030: SET COMPONENT_SEQUENCE_ID =
1031: (SELECT BIC.COMPONENT_SEQUENCE_ID
1032: FROM BOM_INVENTORY_COMPONENTS BIC
1033: WHERE BIC.BILL_SEQUENCE_ID = BICI.BILL_SEQUENCE_ID

Line 1098: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI

1094:
1095: CURSOR Process_Comp(l_batch_id IN NUMBER)
1096: IS
1097: SELECT MCR.inventory_item_id,MCR.organization_id,BICI.comp_source_system_reference,MSI.segment1
1098: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
1099: WHERE BICI.batch_id = l_batch_id
1100: AND EIBB.batch_id = BICI.batch_id
1101: AND MCR.source_system_id = EIBB.source_system_id
1102: AND MCR.cross_reference = BICI.comp_source_system_reference

Line 1112: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI

1108:
1109: CURSOR Process_Header_For_Comp
1110: IS
1111: SELECT MCR.inventory_item_id,MCR.organization_id,BICI.comp_source_system_reference,MSI.segment1
1112: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
1113: WHERE BICI.batch_id = p_batch_id
1114: AND EIBB.batch_id = BICI.batch_id
1115: AND MCR.source_system_id = EIBB.source_system_id
1116: AND MCR.cross_reference = BICI.parent_source_system_reference

Line 1186: UPDATE bom_inventory_comps_interface

1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: ELSE
1184: write_debug('Updating the component x-refs ');
1185:
1186: UPDATE bom_inventory_comps_interface
1187: SET component_item_id = l_item_id_table(i),
1188: organization_id = l_org_id_table(i),
1189: component_item_number = l_item_num_table(i)
1190: WHERE batch_id = p_batch_id

Line 1203: UPDATE bom_inventory_comps_interface

1199:
1200: l_count := l_ss_record_table.COUNT;
1201:
1202: FOR i in 1..l_count LOOP
1203: UPDATE bom_inventory_comps_interface
1204: SET assembly_item_id = l_item_id_table(i),
1205: organization_id = l_org_id_table(i),
1206: assembly_item_number = l_item_num_table(i)
1207: WHERE batch_id = p_batch_id

Line 1273: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII

1269:
1270: CURSOR Process_Comp
1271: IS
1272: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1273: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII
1274: WHERE BICI.batch_id = p_batch_id
1275: AND (BICI.process_flag = 1 OR BICI.process_flag = 5)
1276: AND MSII.set_process_id = BICI.batch_id
1277: AND MSII.process_flag IN (0,1,7)

Line 1285: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII

1281:
1282: Cursor Process_Header_For_Comp
1283: IS
1284: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1285: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII
1286: WHERE BICI.batch_id = p_batch_id
1287: AND (BICI.process_flag = 1 OR BICI.process_flag = 5)
1288: AND MSII.set_process_id = BICI.batch_id
1289: AND MSII.process_flag IN (0,1,7)

Line 1354: UPDATE bom_inventory_comps_interface

1350: );
1351: x_return_status := FND_API.G_RET_STS_ERROR;
1352: ELSE
1353: write_debug('Updating the Component Matches');
1354: UPDATE bom_inventory_comps_interface
1355: SET component_item_id = l_item_id_table(i),
1356: Organization_id = l_org_id_table(i),
1357: component_item_number = l_item_num_table(i)
1358: WHERE batch_id = p_batch_id

Line 1371: UPDATE bom_inventory_comps_interface

1367:
1368: l_count := l_ss_record_table.COUNT;
1369: FOR i in 1..l_count LOOP
1370: write_debug('Updating the Header matches in Component');
1371: UPDATE bom_inventory_comps_interface
1372: SET assembly_item_id = l_item_id_table(i),
1373: Organization_id = l_org_id_table(i),
1374: assembly_item_number = l_item_num_table(i)
1375: WHERE batch_id = p_batch_id

Line 1414: TYPE bom_comp_intf_type IS TABLE OF bom_inventory_comps_interface%ROWTYPE;

1410: )
1411: IS
1412:
1413:
1414: TYPE bom_comp_intf_type IS TABLE OF bom_inventory_comps_interface%ROWTYPE;
1415: TYPE bom_comp_type IS TABLE OF bom_components_b%ROWTYPE;
1416: TYPE num_type IS TABLE OF NUMBER;
1417: TYPE var_type IS TABLE OF VARCHAR2(1000);
1418:

Line 1466: FROM bom_inventory_comps_interface BICI

1462:
1463: CURSOR Process_Comp(l_batch_id IN NUMBER,p_parent_reference IN VARCHAR2,l_parent_name IN VARCHAR2)
1464: IS
1465: SELECT *
1466: FROM bom_inventory_comps_interface BICI
1467: WHERE batch_id = l_batch_id
1468: AND process_flag NOT IN(3,7,-1)
1469: AND (parent_source_system_reference = p_parent_reference OR assembly_item_number = l_parent_name);
1470:

Line 1675: UPDATE bom_inventory_comps_interface

1671: FOR j IN 1..l_comp_count
1672: LOOP
1673: write_debug('updating comp -'|| l_comp_table(j).comp_source_system_reference);
1674: write_debug('with parent -'|| l_comp_table(j).parent_source_system_reference);
1675: UPDATE bom_inventory_comps_interface
1676: SET bill_sequence_id = l_comp_table(j).bill_sequence_id ,
1677: transaction_type = l_comp_table(j).transaction_type,
1678: component_sequence_id = l_comp_table(j).component_sequence_id,
1679: old_component_sequence_id = l_comp_table(j).old_component_sequence_id,

Line 1771: TYPE bom_intf_comp IS TABLE OF Bom_Inventory_Comps_Interface%ROWTYPE;

1767: TYPE var_type IS TABLE OF VARCHAR2(50);
1768: TYPE num_type IS TABLE OF NUMBER;
1769:
1770: TYPE bom_intf_header IS TABLE OF Bom_Bill_of_Mtls_Interface%ROWTYPE;
1771: TYPE bom_intf_comp IS TABLE OF Bom_Inventory_Comps_Interface%ROWTYPE;
1772: TYPE batch_options IS TABLE OF Ego_Import_Option_Sets%ROWTYPE;
1773:
1774: l_header_table bom_intf_header;
1775: l_comp_table bom_intf_comp;

Line 1870: bom_inventory_comps_interface BICI,

1866: BICI.ORGANIZATION_CODE,
1867: UPPER(BICI.TRANSACTION_TYPE),
1868: BICI.ITEM_DESCRIPTION
1869: FROM
1870: bom_inventory_comps_interface BICI,
1871: ego_import_batches_b EIBB
1872: WHERE
1873: BICI.batch_id = l_batch_id
1874: AND EIBB.batch_id = BICI.batch_id

Line 2351: FROM bom_inventory_comps_interface

2347:
2348: IF p_intf_uniq_id IS NOT NULL THEN
2349: SELECT effectivity_date,new_effectivity_date,disable_date,from_end_item_unit_number,new_from_end_item_unit_number,to_end_item_unit_number,from_end_item_rev_code,to_end_item_rev_code
2350: INTO l_eff_date_intf,l_new_eff_date_intf,l_dis_date_intf,l_from_num_intf ,l_new_from_num_intf,l_to_unit_num_intf,l_from_rev_intf ,l_to_item_rev_intf
2351: FROM bom_inventory_comps_interface
2352: WHERE batch_id = p_batch_id
2353: AND interface_table_unique_id = p_intf_uniq_id;
2354: END IF;
2355:

Line 2621: l_src_query := ' (SELECT * FROM bom_inventory_comps_interface WHERE batch_id = :1 ' ||

2617: END IF;
2618:
2619: IF p_ss_record_id IS NOT NULL
2620: THEN
2621: l_src_query := ' (SELECT * FROM bom_inventory_comps_interface WHERE batch_id = :1 ' ||
2622: ' AND ( (comp_source_system_reference = :2 OR component_item_number = ' || '''' || p_ss_record_id || ''' )' ||
2623: ' AND interface_table_unique_id = ' || p_intf_uniq_id ||
2624: ' AND organization_id = ' || p_org_id ||
2625: ' ) ) src_val ,';

Line 3150: FROM bom_inventory_comps_interface

3146: IF l_comp_seq_id IS NULL THEN
3147:
3148: SELECT component_sequence_id
3149: INTO l_comp_seq_id
3150: FROM bom_inventory_comps_interface
3151: WHERE batch_id = p_batch_id
3152: AND (process_flag = 1 OR process_flag = 5)
3153: AND transaction_id = p_transaction_id;
3154: END IF;

Line 3160: FROM bom_inventory_comps_interface

3156: IF l_bill_seq_id IS NULL THEN
3157:
3158: SELECT bill_sequence_id
3159: INTO l_bill_seq_id
3160: FROM bom_inventory_comps_interface
3161: WHERE batch_id = p_batch_id
3162: AND (process_flag = 1 OR process_flag = 5)
3163: AND transaction_id = p_transaction_id;
3164: END IF;

Line 3170: FROM bom_inventory_comps_interface

3166: IF ( p_transaction_id IS NOT NULL OR p_comp_seq_id IS NOT NULL )THEN
3167:
3168: SELECT component_item_number,assembly_item_number,component_item_id,organization_id,UPPER(transaction_type)
3169: INTO l_comp_name,l_parent_name,l_comp_id,l_org_id,l_txn_type
3170: FROM bom_inventory_comps_interface
3171: WHERE batch_id = p_batch_id
3172: AND (process_flag = 1 or process_flag = 5)
3173: AND (component_sequence_id = p_comp_seq_id OR transaction_id = p_transaction_id);
3174: END IF;

Line 3841: FROM bom_inventory_comps_interface bci

3837: AND bmi.process_flag = 0
3838: AND bmi.source_system_reference =
3839: ( SELECT DISTINCT
3840: bci.parent_source_system_reference
3841: FROM bom_inventory_comps_interface bci
3842: WHERE
3843: bci.batch_id = p_batch_id
3844: AND bci.comp_source_system_reference = iicr.source_system_reference
3845: AND iicr.confirm_status in ('CC','CM','CN'));

Line 3848: bom_inventory_comps_interface

3844: AND bci.comp_source_system_reference = iicr.source_system_reference
3845: AND iicr.confirm_status in ('CC','CM','CN'));
3846: -- Update Components for Unconfirmed and Excluded
3847: UPDATE
3848: bom_inventory_comps_interface
3849: SET
3850: process_flag = 1
3851: WHERE
3852: batch_id = p_batch_id

Line 3883: FROM bom_inventory_comps_interface bci

3879: AND bmi.process_flag = 1
3880: AND bmi.source_system_reference =
3881: ( SELECT DISTINCT
3882: bci.parent_source_system_reference
3883: FROM bom_inventory_comps_interface bci
3884: WHERE
3885: bci.batch_id = p_batch_id
3886: AND bci.comp_source_system_reference = iicr.source_system_reference
3887: AND iicr.confirm_status in ('US','UM','UN'));

Line 3890: bom_inventory_comps_interface

3886: AND bci.comp_source_system_reference = iicr.source_system_reference
3887: AND iicr.confirm_status in ('US','UM','UN'));
3888: -- Update Components for Unconfirmed and Excluded
3889: UPDATE
3890: bom_inventory_comps_interface
3891: SET
3892: process_flag = 0
3893: WHERE
3894: batch_id = p_batch_id

Line 4069: FROM bom_inventory_comps_interface BICI,

4065: IS
4066: SELECT BICI.component_item_id,BICI.organization_id,BICI.bill_sequence_id,BBMI.assembly_item_id,decode(BICI.operation_seq_num,null,
4067: BICI.new_operation_seq_num,BICI.operation_seq_num),decode(BICI.effectivity_date,null,BICI.new_effectivity_date,BICI.effectivity_date),
4068: BICI.component_item_number,BICI.assembly_item_number,BICI.organization_code,BICI.component_sequence_id
4069: FROM bom_inventory_comps_interface BICI,
4070: bom_bill_of_mtls_interface BBMI
4071: WHERE BBMI.batch_id = p_batch_id
4072: AND BICI.batch_id = BBMI.batch_id
4073: --AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5)

Line 4240: UPDATE bom_inventory_comps_interface

4236: Write_Debug('Updating the Comps-- ' ||l_comp_name_table(i) );
4237: Write_Debug('With Parent -- ' || l_head_name_table(i));
4238:
4239: IF pG_batch_options.PDH_BATCH = 'Y' THEN
4240: UPDATE bom_inventory_comps_interface
4241: SET comp_source_system_reference = l_comp_name_table(i),
4242: parent_source_system_reference = l_head_name_table(i),
4243: component_item_number = l_comp_name_table(i),
4244: component_item_id = l_comp_item_id_table(i),

Line 4255: UPDATE bom_inventory_comps_interface

4251: --AND new_operation_seq_num = l_op_seq_table(i)
4252: --AND new_effectivity_date = l_effectivity_table(i)
4253: AND batch_id = p_batch_id;
4254: ELSE
4255: UPDATE bom_inventory_comps_interface
4256: SET component_item_number = l_comp_name_table(i),
4257: component_item_id = l_comp_item_id_table(i),
4258: assembly_item_number = l_head_name_table(i),
4259: assembly_item_id = l_head_item_id_table(i),

Line 4368: UPDATE bom_inventory_comps_interface BICI

4364: AND source_system_reference = p_ssRef_varray(i);
4365:
4366: -- Update the comps
4367:
4368: UPDATE bom_inventory_comps_interface BICI
4369: SET component_item_id = l_item_id
4370: WHERE batch_id = p_batch_id
4371: AND comp_source_system_reference = p_ssRef_varray(i);
4372:

Line 4460: UPDATE Bom_Inventory_Comps_Interface

4456: WHERE batch_id = p_batch_id
4457: AND bill_sequence_id = l_bill_seq_table(i);
4458:
4459: -- Update the direct Component rows with process Flag = 5
4460: UPDATE Bom_Inventory_Comps_Interface
4461: SET Process_Flag = 5
4462: WHERE batch_id = p_batch_id
4463: AND bill_sequence_id = l_bill_seq_table(i);
4464: END IF;

Line 4476: TYPE bom_comp_intf_type IS TABLE OF bom_inventory_comps_interface%ROWTYPE;

4472: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4473: , x_Return_Status IN OUT NOCOPY VARCHAR2
4474: )
4475: IS
4476: TYPE bom_comp_intf_type IS TABLE OF bom_inventory_comps_interface%ROWTYPE;
4477: TYPE bom_comp_type IS TABLE OF bom_components_b%ROWTYPE;
4478: TYPE num_type IS TABLE OF NUMBER;
4479: TYPE var_type IS TABLE OF VARCHAR2(1000);
4480: l_err_text VARCHAR2(1000);

Line 4534: FROM bom_inventory_comps_interface BICI

4530:
4531: CURSOR Process_Comp(l_batch_id IN NUMBER,p_parent_reference IN VARCHAR2)
4532: IS
4533: SELECT *
4534: FROM bom_inventory_comps_interface BICI
4535: WHERE batch_id = l_batch_id
4536: AND process_flag NOT IN(3,7,0,-1)
4537: AND parent_source_system_reference = p_parent_reference;
4538:

Line 4680: bom_inventory_comps_interface

4676:
4677: FOR m in 1..l_unmatch_count LOOP
4678: IF l_unmatch_comp(m).disable_date IS NULL OR (l_unmatch_comp(m).disable_date IS NOT NULL AND l_unmatch_comp(m).disable_date > sysdate) THEN
4679: INSERT INTO
4680: bom_inventory_comps_interface
4681: (
4682: component_item_id,
4683: organization_id,
4684: component_sequence_id,

Line 4817: bom_inventory_comps_interface

4813: LOOP
4814: IF l_comp_pdh_table(k).bill_sequence_id <> 0 THEN
4815: write_debug('inserting delete for comp --' ||l_comp_pdh_table(k).component_item_id );
4816: INSERT INTO
4817: bom_inventory_comps_interface
4818: (
4819: component_item_id,
4820: organization_id,
4821: component_sequence_id,

Line 4879: bom_inventory_comps_interface

4875:
4876: FOR m in 1..l_unmatch_count LOOP
4877: IF l_unmatch_comp(m).disable_date IS NULL OR (l_unmatch_comp(m).disable_date IS NOT NULL AND l_unmatch_comp(m).disable_date > sysdate) THEN
4878: INSERT INTO
4879: bom_inventory_comps_interface
4880: (
4881: component_item_id,
4882: organization_id,
4883: component_sequence_id,

Line 5004: bom_inventory_comps_interface

5000: write_debug('before inserting the delete rows second');
5001: IF l_not_exist AND (l_comp_pdh_table(j).disable_date IS NULL OR (l_comp_pdh_table(j).disable_date IS NOT NULL AND l_comp_pdh_table(j).disable_date > sysdate)) THEN
5002: write_debug('inserting delete for comp --' ||l_comp_pdh_table(j).component_item_id );
5003: INSERT INTO
5004: bom_inventory_comps_interface
5005: (
5006: component_item_id,
5007: organization_id,
5008: component_sequence_id,

Line 5054: UPDATE bom_inventory_comps_interface

5050: END IF;
5051:
5052: l_comp_count := l_comp_table.COUNT;
5053: FOR i in 1..l_comp_count LOOP
5054: UPDATE bom_inventory_comps_interface
5055: SET component_sequence_id = l_comp_table(i).component_sequence_id,
5056: transaction_type = UPPER(l_comp_table(i).transaction_type)
5057: WHERE batch_id = p_batch_id
5058: AND (process_flag = 1 OR process_flag = 5)

Line 5144: Delete bom_inventory_comps_interface

5140:
5141: stmt_num := 2;
5142: Write_Debug('Deleting the component rows');
5143:
5144: Delete bom_inventory_comps_interface
5145: WHERE batch_id = p_batch_id;
5146:
5147: stmt_num := 3;
5148: Write_Debug('Deleting the Ref Desgs interface');

Line 5221: TYPE bom_comp_intf_type IS TABLE OF bom_inventory_comps_interface%ROWTYPE;

5217: x_Ret_Status IN OUT NOCOPY VARCHAR2,
5218: x_Error_Mesg IN OUT NOCOPY VARCHAR2
5219: )
5220: IS
5221: TYPE bom_comp_intf_type IS TABLE OF bom_inventory_comps_interface%ROWTYPE;
5222: l_comp_table bom_comp_intf_type;
5223: l_merge_comp bom_comp_intf_type;
5224: l_count NUMBER;
5225: l_merge_count NUMBER;

Line 5246: FROM bom_inventory_comps_interface

5242: l_txn_type IN VARCHAR2
5243: )
5244: IS
5245: SELECT *
5246: FROM bom_inventory_comps_interface
5247: WHERE batch_id = p_batch_id
5248: AND ( component_sequence_id = l_comp_seq
5249: OR (component_sequence_id is NULL
5250: AND ( (component_item_number = l_comp_name OR comp_source_system_reference = l_comp_ref)

Line 5267: FROM bom_inventory_comps_interface

5263:
5264: CURSOR Get_Comp
5265: IS
5266: SELECT *
5267: FROM bom_inventory_comps_interface
5268: WHERE batch_id = p_batch_id
5269: AND process_flag = 1;
5270:
5271: BEGIN

Line 5424: UPDATE bom_inventory_comps_interface

5420:
5421: l_merge_comp(j).process_flag := -1;
5422: END LOOP; -- merge table loop
5423:
5424: UPDATE bom_inventory_comps_interface
5425: SET operation_seq_num = l_merge_comp(1).operation_seq_num,
5426: new_operation_seq_num = l_merge_comp(1).new_operation_seq_num,
5427: basis_type = l_merge_comp(1).basis_type,
5428: component_quantity = l_merge_comp(1).component_quantity,

Line 5463: UPDATE bom_inventory_comps_interface

5459: unit_price = l_merge_comp(1).unit_price
5460: WHERE batch_id = p_batch_id
5461: AND interface_table_unique_id = l_merge_comp(1).interface_table_unique_id;
5462:
5463: UPDATE bom_inventory_comps_interface
5464: SET process_flag = -1
5465: WHERE batch_id = p_batch_id
5466: AND ( component_sequence_id = l_merge_comp(1).component_sequence_id
5467: OR ( component_sequence_id IS NULL

Line 5781: UPDATE bom_inventory_comps_interface

5777: --pending_from_ecn = nvl(pending_from_ecn,pG_batch_options.CHANGE_NOTICE) we need not do this
5778: WHERE batch_id = p_batch_id
5779: AND (process_flag = 1 OR process_flag = 7);
5780:
5781: UPDATE bom_inventory_comps_interface
5782: SET process_flag = 5
5783: --change_notice = nvl(change_notice,pG_batch_options.CHANGE_NOTICE) we need not do this
5784: WHERE batch_id = p_batch_id
5785: AND process_flag = 1;

Line 5841: UPDATE bom_inventory_comps_interface

5837: AND (process_flag = 1 OR process_flag = 7)
5838: AND interface_table_unique_id = l_header_table(i).interface_table_unique_id;
5839:
5840:
5841: UPDATE bom_inventory_comps_interface
5842: SET process_flag = 5
5843: WHERE batch_id = p_batch_id
5844: AND process_flag = 1
5845: AND ( bill_sequence_id = l_header_table(i).bill_sequence_id