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.BOMPASGR dependencies on BOM_OP_RESOURCES_INTERFACE

Line 37: BOM_OP_RESOURCES_INTERFACE

33: err_text out buffer to return error message
34: MODIFIES
35: BOM_OP_ROUTINGS_INTERFACE
36: BOM_OP_SEQUENCES_INTERFACE
37: BOM_OP_RESOURCES_INTERFACE
38: MTL_RTG_ITEM_REVS_INTERFACE
39: MTL_INTERFACE_ERRORS
40: RETURNS
41: 0 if successful

Line 91: update bom_op_resources_interface ori

87: end loop;
88:
89: stmt_num := 3;
90: loop
91: update bom_op_resources_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 1276: insert into bom_op_resources_interface (

1272: /*
1273: ** assign resources for standard operation
1274: */
1275: if (c1rec.SOI is not null) then
1276: insert into bom_op_resources_interface (
1277: OPERATION_SEQUENCE_ID,
1278: RESOURCE_SEQ_NUM,
1279: RESOURCE_ID,
1280: ACTIVITY_ID,

Line 1397: BOM_OP_RESOURCES_INTERFACE. If any application error occurs, it

1393: /* NAME
1394: bmasrsd_assign_resource_data - assign resource data
1395: DESCRIPTION
1396: assign defaults and various ids in the interface table
1397: BOM_OP_RESOURCES_INTERFACE. If any application error occurs, it
1398: inserts record into MTL_INTERFACE_ERRORS.
1399:
1400: REQUIRES
1401: err_text out buffer to return error message

Line 1403: BOM_OP_RESOURCES_INTERFACE

1399:
1400: REQUIRES
1401: err_text out buffer to return error message
1402: MODIFIES
1403: BOM_OP_RESOURCES_INTERFACE
1404: MTL_INTERFACE_ERRORS
1405: RETURNS
1406: 0 if successful
1407: SQLCODE if unsuccessful

Line 1442: from bom_op_resources_interface

1438: to_char(effectivity_date, 'YYYY/MM/DD HH24:MI:SS') ED, -- Changed for bug 2647027
1439: -- to_char(effectivity_date, 'YYYY/MM/DD HH24:MI') ED,
1440: routing_sequence_id RSI,
1441: transaction_id TI
1442: from bom_op_resources_interface
1443: where process_flag = 1
1444: and operation_sequence_id is null
1445: and (all_org = 1
1446: or

Line 1457: from bom_op_Resources_interface

1453: operation_sequence_id OSI, resource_id RI, resource_code RC,
1454: activity_id AI, activity A, usage_rate_or_amount URA,
1455: usage_rate_or_amount_inverse URAI, assigned_units AU,
1456: basis_type BT, autocharge_type AUT, standard_rate_flag SRF
1457: from bom_op_Resources_interface
1458: where process_flag = 1
1459: and operation_sequence_id is not null
1460: and (all_org = 1
1461: or

Line 1468: from bom_op_Resources_interface

1464: and rownum < 500;
1465:
1466: CURSOR c3 is
1467: select operation_sequence_id OSI
1468: from bom_op_Resources_interface
1469: where process_flag = 99
1470: and (all_org = 1
1471: or
1472: (all_org = 2 and organization_id = org_id)

Line 1482: insert into bom_op_resources_interface (

1478: /*
1479: ** first load all rows from operations interface into resource interface
1480: */
1481:
1482: insert into bom_op_resources_interface (
1483: OPERATION_SEQUENCE_ID,
1484: RESOURCE_SEQ_NUM,
1485: RESOURCE_ID,
1486: RESOURCE_CODE,

Line 1513: insert into bom_op_resources_interface (

1509: and (resource_id1 is not null or resource_code1 is not null);
1510: commit;
1511:
1512: stmt_num := 1;
1513: insert into bom_op_resources_interface (
1514: OPERATION_SEQUENCE_ID,
1515: RESOURCE_SEQ_NUM,
1516: RESOURCE_ID,
1517: RESOURCE_CODE,

Line 1544: insert into bom_op_resources_interface (

1540: and (resource_id2 is not null or resource_code2 is not null);
1541: commit;
1542:
1543: stmt_num := 2;
1544: insert into bom_op_resources_interface (
1545: OPERATION_SEQUENCE_ID,
1546: RESOURCE_SEQ_NUM,
1547: RESOURCE_ID,
1548: RESOURCE_CODE,

Line 1578: update bom_op_resources_interface

1574: ** assign transaction ids for every row
1575: */
1576: stmt_num := 3;
1577: loop
1578: update bom_op_resources_interface
1579: set transaction_id = mtl_system_items_interface_s.nextval
1580: where transaction_id is null
1581: and process_flag = 1
1582: and rownum < 500;

Line 1605: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1601: prog_id => prog_id,
1602: req_id => req_id,
1603: trans_id => c1rec.TI,
1604: error_text => err_text,
1605: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1606: msg_name => 'BOM_ORG_ID_MISSING',
1607: err_text => err_text);
1608: update bom_op_resources_interface set
1609: process_flag = 3

Line 1608: update bom_op_resources_interface set

1604: error_text => err_text,
1605: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1606: msg_name => 'BOM_ORG_ID_MISSING',
1607: err_text => err_text);
1608: update bom_op_resources_interface set
1609: process_flag = 3
1610: where transaction_id = c1rec.TI;
1611:
1612: if (ret_code <> 0) then

Line 1640: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1636: prog_id => prog_id,
1637: req_id => req_id,
1638: trans_id => c1rec.TI,
1639: error_text => err_text,
1640: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1641: msg_name => 'BOM_ASSY_ITEM_MISSING',
1642: err_text => err_text);
1643: update bom_op_resources_interface set
1644: process_flag = 3

Line 1643: update bom_op_resources_interface set

1639: error_text => err_text,
1640: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1641: msg_name => 'BOM_ASSY_ITEM_MISSING',
1642: err_text => err_text);
1643: update bom_op_resources_interface set
1644: process_flag = 3
1645: where transaction_id = c1rec.TI;
1646:
1647: if (ret_code <> 0) then

Line 1675: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1671: prog_id => prog_id,
1672: req_id => req_id,
1673: trans_id => c1rec.TI,
1674: error_text => err_text,
1675: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1676: msg_name => 'BOM_RTG_SEQ_INVALID',
1677: err_text => err_text);
1678: update bom_op_resources_interface set
1679: process_flag = 3

Line 1678: update bom_op_resources_interface set

1674: error_text => err_text,
1675: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1676: msg_name => 'BOM_RTG_SEQ_INVALID',
1677: err_text => err_text);
1678: update bom_op_resources_interface set
1679: process_flag = 3
1680: where transaction_id = c1rec.TI;
1681:
1682: if (ret_code <> 0) then

Line 1709: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1705: prog_id => prog_id,
1706: req_id => req_id,
1707: trans_id => c1rec.TI,
1708: error_text => err_text,
1709: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1710: msg_name => 'BOM_OP_SEQ_INVALID',
1711: err_text => err_text);
1712: update bom_op_resources_interface set
1713: process_flag = 3

Line 1712: update bom_op_resources_interface set

1708: error_text => err_text,
1709: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1710: msg_name => 'BOM_OP_SEQ_INVALID',
1711: err_text => err_text);
1712: update bom_op_resources_interface set
1713: process_flag = 3
1714: where transaction_id = c1rec.TI;
1715:
1716: if (ret_code <> 0) then

Line 1723: update bom_op_resources_interface

1719: goto continue_loop;
1720: end if;
1721:
1722: stmt_num := 8;
1723: update bom_op_resources_interface
1724: set operation_sequence_id = c1rec.OSI,
1725: assembly_item_id = c1rec.AII,
1726: routing_sequence_id = c1rec.RSI
1727: where transaction_id = c1rec.TI;

Line 1800: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1796: prog_id => prog_id,
1797: req_id => req_id,
1798: trans_id => c2rec.TI,
1799: error_text => err_text,
1800: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1801: msg_name => 'BOM_OP_SEQ_INVALID',
1802: err_text => err_text);
1803: update bom_op_resources_interface set
1804: process_flag = 3

Line 1803: update bom_op_resources_interface set

1799: error_text => err_text,
1800: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1801: msg_name => 'BOM_OP_SEQ_INVALID',
1802: err_text => err_text);
1803: update bom_op_resources_interface set
1804: process_flag = 3
1805: where transaction_id = c2rec.TI;
1806:
1807: if (ret_code <> 0) then

Line 1839: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1835: prog_id => prog_id,
1836: req_id => req_id,
1837: trans_id => c2rec.TI,
1838: error_text => err_text,
1839: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1840: msg_name => 'BOM_RESOURCE_ID_MISSING',
1841: err_text => err_text);
1842: update bom_op_resources_interface set
1843: process_flag = 3

Line 1842: update bom_op_resources_interface set

1838: error_text => err_text,
1839: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1840: msg_name => 'BOM_RESOURCE_ID_MISSING',
1841: err_text => err_text);
1842: update bom_op_resources_interface set
1843: process_flag = 3
1844: where transaction_id = c2rec.TI;
1845:
1846: if (ret_code <> 0) then

Line 1874: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1870: prog_id => prog_id,
1871: req_id => req_id,
1872: trans_id => c2rec.TI,
1873: error_text => err_text,
1874: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1875: msg_name => 'BOM_ACTIVITY_INVALID',
1876: err_text => err_text);
1877: update bom_op_resources_interface set
1878: process_flag = 3

Line 1877: update bom_op_resources_interface set

1873: error_text => err_text,
1874: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1875: msg_name => 'BOM_ACTIVITY_INVALID',
1876: err_text => err_text);
1877: update bom_op_resources_interface set
1878: process_flag = 3
1879: where transaction_id = c2rec.TI;
1880:
1881: if (ret_code <> 0) then

Line 1945: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1941: prog_id => prog_id,
1942: req_id => req_id,
1943: trans_id => c2rec.TI,
1944: error_text => err_text,
1945: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1946: msg_name => 'BOM_OP_SEQ_INVALID',
1947: err_text => err_text);
1948: update bom_op_resources_interface set
1949: process_flag = 3

Line 1948: update bom_op_resources_interface set

1944: error_text => err_text,
1945: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1946: msg_name => 'BOM_OP_SEQ_INVALID',
1947: err_text => err_text);
1948: update bom_op_resources_interface set
1949: process_flag = 3
1950: where transaction_id = c2rec.TI;
1951:
1952: if (ret_code <> 0) then

Line 1984: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1980: prog_id => prog_id,
1981: req_id => req_id,
1982: trans_id => c2rec.TI,
1983: error_text => err_text,
1984: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1985: msg_name => 'BOM_DEPT_RES_INVALID',
1986: err_text => err_text);
1987: update bom_op_resources_interface set
1988: process_flag = 3

Line 1987: update bom_op_resources_interface set

1983: error_text => err_text,
1984: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1985: msg_name => 'BOM_DEPT_RES_INVALID',
1986: err_text => err_text);
1987: update bom_op_resources_interface set
1988: process_flag = 3
1989: where transaction_id = c2rec.TI;
1990:
1991: if (ret_code <> 0) then

Line 2012: update bom_op_resources_interface set

2008: from bom_resources
2009: where resource_id = c2rec.RI;
2010:
2011: stmt_num := 17;
2012: update bom_op_resources_interface set
2013: resource_id = c2rec.RI,
2014: organization_id = c2rec.OI,
2015: BASIS_TYPE = nvl(c2rec.BT,1),
2016: AUTOCHARGE_TYPE = c2rec.AUT,

Line 2053: from bom_op_resources_interface

2049: ** for set processing
2050: */
2051: select count(distinct operation_sequence_id)
2052: into total_recs
2053: from bom_op_resources_interface
2054: where process_flag = 99;
2055:
2056: continue_loop := TRUE;
2057: commit_cnt := 0;

Line 2066: update bom_op_resources_interface

2062: select mtl_system_items_interface_s.nextval
2063: into dummy_txn
2064: from sys.dual;
2065:
2066: update bom_op_resources_interface
2067: set transaction_id = dummy_txn,
2068: process_flag = 2
2069: where operation_sequence_id = c3rec.OSI
2070: and process_flag = 99;

Line 2270: update bom_op_resources_interface set

2266: IS
2267: stmt_num NUMBER := 1;
2268: BEGIN
2269: loop
2270: update bom_op_resources_interface set
2271: operation_sequence_id = op_id
2272: where process_flag = 1
2273: and organization_id = org_id
2274: and assembly_item_id = assy_id

Line 2341: update bom_op_resources_interface set

2337: end loop;
2338:
2339: loop
2340: stmt_num := 2;
2341: update bom_op_resources_interface set
2342: routing_sequence_id = rtg_id
2343: where process_flag = 1
2344: and organization_id = org_id
2345: and assembly_item_id = assy_id

Line 2515: BOM_OP_RESOURCES_INTERFACE

2511: err_text out buffer to return error message
2512: MODIFIES
2513: BOM_OP_ROUTINGS_INTERFACE
2514: BOM_OP_SEQUENCES_INTERFACE
2515: BOM_OP_RESOURCES_INTERFACE
2516: MTL_INTERFACE_ERRORS
2517: RETURNS
2518: 0 if successful
2519: SQLCODE if unsuccessful

Line 2539: From bom_op_resources_interface bor

2535: and bos.assembly_item_number = item_num
2536: and bos.routing_sequence_id is null;
2537: Cursor GetResources is
2538: Select bor.rowid row_id
2539: From bom_op_resources_interface bor
2540: where bor.process_flag = 1
2541: and bor.assembly_item_id is null
2542: and bor.organization_id = org_id
2543: and bor.assembly_item_number = item_num

Line 2560: update bom_op_resources_interface

2556: end loop;
2557: commit;
2558:
2559: For X_Resource in GetResources loop
2560: update bom_op_resources_interface
2561: set assembly_item_id = item_id
2562: where rowid = X_Resource.row_id;
2563: If mod(GetResources%rowcount, 500) = 0 then
2564: commit;