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.BOMPASGB dependencies on BOM_REF_DESGS_INTERFACE

Line 37: BOM_REF_DESGS_INTERFACE

33: err_text out buffer to return error message
34: MODIFIES
35: BOM_BILL_OF_MTLS_INTERFACE
36: BOM_INVENTORY_COMPS_INTERFACE
37: BOM_REF_DESGS_INTERFACE
38: BOM_SUB_COMPS_INTERFACE
39: MTL_INTERFACE_ERRORS
40: RETURNS
41: 0 if successful

Line 91: update bom_ref_desgs_interface ori

87: end loop;
88:
89: stmt_num := 4;
90: loop
91: update bom_ref_desgs_interface ori
92: set organization_id = (select organization_id from
93: mtl_parameters a
94: where a.organization_code = ori.organization_code)
95: where process_flag = 1

Line 1363: BOM_REF_DESGS_INTERFACE

1359: err_text out buffer to return error message
1360: MODIFIES
1361: BOM_BILL_OF_MTLS_INTERFACE
1362: BOM_INVENTORY_COMPS_INTERFACE
1363: BOM_REF_DESGS_INTERFACE
1364: BOM_SUB_COMPS_INTERFACE
1365: MTL_INTERFACE_ERRORS
1366: RETURNS
1367: 0 if successful

Line 1390: From bom_ref_desgs_interface brd

1386: and bici.assembly_item_number = item_number
1387: and bici.bill_sequence_id is null;
1388: Cursor GetRefDesgs is
1389: Select brd.rowid row_id
1390: From bom_ref_desgs_interface brd
1391: where brd.process_flag = 1
1392: and brd.assembly_item_id is null
1393: and brd.organization_id = org_id
1394: and brd.assembly_item_number = item_number

Line 1417: update bom_ref_desgs_interface ori

1413: end if; -- commit every 500 rows
1414: end loop;
1415:
1416: For X_Designator in GetRefDesgs loop
1417: update bom_ref_desgs_interface ori
1418: set ori.assembly_item_id = item_id
1419: where ori.rowid = X_Designator.row_id;
1420: If mod(GetRefDesgs%rowcount, 500) = 0 then
1421: commit;

Line 1492: update bom_ref_desgs_interface set

1488: commit;
1489: end loop;
1490:
1491: loop
1492: update bom_ref_desgs_interface set
1493: bill_sequence_id = bom_id
1494: where process_flag = 1
1495: and organization_id = org_id
1496: and assembly_item_id = assy_id

Line 1563: update bom_ref_desgs_interface set

1559: IS
1560: stmt_num NUMBER := 1;
1561: BEGIN
1562: loop
1563: update bom_ref_desgs_interface set
1564: component_sequence_id = cmp_seq_id
1565: where process_flag = 1
1566: and organization_id = org_id
1567: and assembly_item_id = assy_id

Line 1672: BOM_REF_DESGS_INTERFACE

1668: for existing records
1669: REQUIRES
1670: err_text out buffer to return error message
1671: MODIFIES
1672: BOM_REF_DESGS_INTERFACE
1673: MTL_INTERFACE_ERRORS
1674: RETURNS
1675: 0 if successful
1676: SQLCODE if unsuccessful

Line 1705: from bom_ref_desgs_interface

1701: assembly_item_number AIN, alternate_bom_designator ABD,
1702: component_item_id CII, component_item_number CIN,
1703: operation_seq_num OSN,
1704: to_char(effectivity_date,'YYYY/MM/DD HH24:MI') ED
1705: from bom_ref_desgs_interface
1706: where process_flag = 1
1707: and component_sequence_id is null
1708: and (all_org = 1
1709: or

Line 1716: from bom_ref_desgs_interface

1712: and rownum < 500;
1713:
1714: CURSOR c2 is
1715: select transaction_id TI, organization_id OI
1716: from bom_ref_desgs_interface
1717: where process_flag = 1
1718: and component_sequence_id is not null
1719: and (all_org = 1
1720: or

Line 1727: from bom_ref_desgs_interface

1723: and rownum < 500;
1724:
1725: CURSOR c3 is
1726: select component_sequence_id CSI
1727: from bom_ref_desgs_interface
1728: where process_flag = 99
1729: and (all_org = 1
1730: or
1731: (all_org = 2 and organization_id = org_id)

Line 1740: insert into bom_ref_desgs_interface (

1736: BEGIN
1737: /*
1738: ** first load all rows from components interface into ref desg interface
1739: */
1740: insert into bom_ref_desgs_interface (
1741: COMPONENT_REFERENCE_DESIGNATOR,
1742: LAST_UPDATE_DATE,
1743: LAST_UPDATED_BY,
1744: CREATION_DATE,

Line 1775: update bom_ref_desgs_interface

1771: /*
1772: ** assign transaction ids for every row
1773: */
1774: loop
1775: update bom_ref_desgs_interface
1776: set transaction_id = mtl_system_items_interface_s.nextval
1777: where transaction_id is null
1778: and process_flag = 1
1779: and rownum < 500;

Line 1801: tbl_name => 'BOM_REF_DESGS_INTERFACE',

1797: prog_id => prog_id,
1798: req_id => req_id,
1799: trans_id => c1rec.TI,
1800: error_text => err_text,
1801: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1802: msg_name => 'BOM_ORG_ID_MISSING',
1803: err_text => err_text);
1804: update bom_ref_desgs_interface set
1805: process_flag = 3

Line 1804: update bom_ref_desgs_interface set

1800: error_text => err_text,
1801: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1802: msg_name => 'BOM_ORG_ID_MISSING',
1803: err_text => err_text);
1804: update bom_ref_desgs_interface set
1805: process_flag = 3
1806: where transaction_id = c1rec.TI;
1807:
1808: if (ret_code <> 0) then

Line 1835: tbl_name => 'BOM_REF_DESGS_INTERFACE',

1831: prog_id => prog_id,
1832: req_id => req_id,
1833: trans_id => c1rec.TI,
1834: error_text => err_text,
1835: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1836: msg_name => 'BOM_ASSY_ITEM_MISSING',
1837: err_text => err_text);
1838: update bom_ref_desgs_interface set
1839: process_flag = 3

Line 1838: update bom_ref_desgs_interface set

1834: error_text => err_text,
1835: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1836: msg_name => 'BOM_ASSY_ITEM_MISSING',
1837: err_text => err_text);
1838: update bom_ref_desgs_interface set
1839: process_flag = 3
1840: where transaction_id = c1rec.TI;
1841:
1842: if (ret_code <> 0) then

Line 1870: tbl_name => 'BOM_REF_DESGS_INTERFACE',

1866: prog_id => prog_id,
1867: req_id => req_id,
1868: trans_id => c1rec.TI,
1869: error_text => err_text,
1870: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1871: msg_name => 'BOM_BILL_SEQ_MISSING',
1872: err_text => err_text);
1873: update bom_ref_desgs_interface set
1874: process_flag = 3

Line 1873: update bom_ref_desgs_interface set

1869: error_text => err_text,
1870: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1871: msg_name => 'BOM_BILL_SEQ_MISSING',
1872: err_text => err_text);
1873: update bom_ref_desgs_interface set
1874: process_flag = 3
1875: where transaction_id = c1rec.TI;
1876:
1877: if (ret_code <> 0) then

Line 1899: tbl_name => 'BOM_REF_DESGS_INTERFACE',

1895: prog_id => prog_id,
1896: req_id => req_id,
1897: trans_id => c1rec.TI,
1898: error_text => err_text,
1899: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1900: msg_name => 'BOM_BILL_SEQ_MISSING',
1901: err_text => err_text);
1902: update bom_ref_desgs_interface set
1903: process_flag = 3

Line 1902: update bom_ref_desgs_interface set

1898: error_text => err_text,
1899: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1900: msg_name => 'BOM_BILL_SEQ_MISSING',
1901: err_text => err_text);
1902: update bom_ref_desgs_interface set
1903: process_flag = 3
1904: where transaction_id = c1rec.TI;
1905:
1906: if (ret_code <> 0) then

Line 1935: tbl_name => 'BOM_REF_DESGS_INTERFACE',

1931: prog_id => prog_id,
1932: req_id => req_id,
1933: trans_id => c1rec.TI,
1934: error_text => err_text,
1935: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1936: msg_name => 'BOM_COMP_ID_MISSING',
1937: err_text => err_text);
1938: update bom_ref_desgs_interface set
1939: process_flag = 3

Line 1938: update bom_ref_desgs_interface set

1934: error_text => err_text,
1935: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1936: msg_name => 'BOM_COMP_ID_MISSING',
1937: err_text => err_text);
1938: update bom_ref_desgs_interface set
1939: process_flag = 3
1940: where transaction_id = c1rec.TI;
1941:
1942: if (ret_code <> 0) then

Line 1969: tbl_name => 'BOM_REF_DESGS_INTERFACE',

1965: prog_id => prog_id,
1966: req_id => req_id,
1967: trans_id => c1rec.TI,
1968: error_text => err_text,
1969: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1970: msg_name => 'BOM_COMP_SEQ_MISSING',
1971: err_text => err_text);
1972: update bom_ref_desgs_interface set
1973: process_flag = 3

Line 1972: update bom_ref_desgs_interface set

1968: error_text => err_text,
1969: tbl_name => 'BOM_REF_DESGS_INTERFACE',
1970: msg_name => 'BOM_COMP_SEQ_MISSING',
1971: err_text => err_text);
1972: update bom_ref_desgs_interface set
1973: process_flag = 3
1974: where transaction_id = c1rec.TI;
1975:
1976: if (ret_code <> 0) then

Line 1982: update bom_ref_desgs_interface

1978: end if;
1979: goto continue_loop;
1980: end if;
1981:
1982: update bom_ref_desgs_interface
1983: set component_sequence_id = c1rec.CSI,
1984: assembly_item_id = c1rec.AII,
1985: component_item_id = c1rec.CII,
1986: bill_sequence_id = c1rec.BSI,

Line 2009: update bom_ref_desgs_interface

2005: while continue_loop loop
2006: commit_cnt := 0;
2007: for c2rec in c2 loop
2008: commit_cnt := commit_cnt + 1;
2009: update bom_ref_desgs_interface
2010: set process_flag = 99,
2011: last_update_date = nvl(last_update_date,sysdate),
2012: last_updated_by = nvl(last_updated_by,user_id),
2013: creation_date = nvl(creation_date,sysdate),

Line 2037: from bom_ref_desgs_interface

2033: ** for set processing
2034: */
2035: select count(distinct component_sequence_id)
2036: into total_recs
2037: from bom_ref_desgs_interface
2038: where process_flag = 99;
2039:
2040: continue_loop := TRUE;
2041: commit_cnt := 0;

Line 2050: update bom_ref_desgs_interface

2046: select mtl_system_items_interface_s.nextval
2047: into dummy_txn
2048: from sys.dual;
2049:
2050: update bom_ref_desgs_interface
2051: set transaction_id = dummy_txn,
2052: process_flag = 2
2053: where component_sequence_id = c3rec.CSI
2054: and process_flag = 99;