APPS.BOM_RTG_OI_UTIL dependencies on BOM_SUB_OP_RESOURCES_INTERFACE

Line 1285: BOM_SUB_OP_RESOURCES_INTERFACE

1281: in the interface table
1282: REQUIRES
1283:
1284: MODIFIES
1285: BOM_SUB_OP_RESOURCES_INTERFACE
1286: MTL_INTERFACE_ERRORS
1287: RETURNS
1288: 0 if successful
1289: SQLCODE if unsuccessful

Line 1315: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

1311: BEGIN
1312: stmt_num := 1;
1313: /* Resolve the operation_sequence_id for all the records */
1314:
1315: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1316: SET(routing_sequence_id, effectivity_date, operation_seq_num)
1317: = (select routing_sequence_id, EFFECTIVITY_DATE, OPERATION_SEQ_NUM
1318: FROM BOM_OPERATION_SEQUENCES BOS1
1319: WHERE BOS1.OPERATION_SEQUENCE_ID = BSORI.operation_sequence_id)

Line 1336: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

1332:
1333: stmt_num := 2;
1334: /* Resolve the routing sequence ids */
1335:
1336: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1337: SET(assembly_item_id, organization_id, alternate_routing_designator)
1338: = (SELECT assembly_item_id, organization_id , alternate_routing_designator
1339: FROM BOM_OPERATIONAL_ROUTINGS BOR1
1340: WHERE BOR1.routing_sequence_id = BSORI.routing_sequence_id)

Line 1358: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

1354: stmt_num := 3;
1355: /* Update Organization Code using Organization_id
1356: this also needed if Organization_id is given and code is not given*/
1357:
1358: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1359: SET organization_code = (SELECT organization_code
1360: FROM MTL_PARAMETERS mp1
1361: WHERE mp1.organization_id = BSORI.organization_id)
1362: WHERE process_flag = 1

Line 1380: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

1376: stmt_num := 4;
1377: /* Update Organization_ids if organization_code is given org id is null.
1378: Orgnaization_id information is needed in the next steps */
1379:
1380: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1381: SET organization_id = (SELECT organization_id
1382: FROM MTL_PARAMETERS mp1
1383: WHERE mp1.organization_code = BSORI.organization_code)
1384: WHERE process_flag = 1

Line 1399: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

1395:
1396: stmt_num := 5;
1397: /* Update Assembly Item name */
1398:
1399: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1400: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1401: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1402: WHERE mvl1.inventory_item_id = BSORI.assembly_item_id
1403: and mvl1.organization_id = BSORI.organization_id)

Line 1422: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

1418:
1419: stmt_num := 6;
1420: /* Update resource code */
1421:
1422: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1423: SET sub_resource_code = (SELECT resource_code
1424: FROM BOM_RESOURCES br
1425: WHERE br.resource_id = BSORI.resource_id
1426: and br.organization_id = BSORI.organization_id)

Line 1445: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

1441:
1442: stmt_num := 7;
1443: /* Assign transaction ids */
1444:
1445: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1446: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1447: WHERE transaction_id is null
1448: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1449: AND process_flag = 1

Line 1459: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

1455: AND (all_org = 1
1456: OR
1457: (all_org = 2 AND organization_id = org_id));
1458:
1459: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1460: SET transaction_type = upper(transaction_type)
1461: WHERE upper(transaction_type) in (G_Create, G_Update, G_Delete)
1462: AND process_flag = 1
1463: AND

Line 1507: 'BOM_SUB_OP_RESOURCES_INTERFACE',

1503: BSORI.transaction_id,
1504: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1505: Null,
1506: null,
1507: 'BOM_SUB_OP_RESOURCES_INTERFACE',
1508: decode ( BSORI.Organization_code, null, msg_name1,msg_name2),
1509: decode ( BSORI.Organization_code, null, msg_text1,msg_text2),
1510: NVL(LAST_UPDATE_DATE, SYSDATE),
1511: NVL(LAST_UPDATED_BY, user_id),

Line 1519: from BOM_SUB_OP_RESOURCES_INTERFACE BSORI

1515: NVL(REQUEST_ID, req_id),
1516: NVL(PROGRAM_APPLICATION_ID, prog_appid),
1517: NVL(PROGRAM_ID, prog_id),
1518: NVL(PROGRAM_UPDATE_DATE, sysdate)
1519: from BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1520: where (organization_code is null or ASSEMBLY_ITEM_NUMBER is null)
1521: and transaction_id is not null
1522: and process_flag =1
1523: and

Line 1530: Update BOM_SUB_OP_RESOURCES_INTERFACE

1526: OR ( p_batch_id = batch_id )
1527: )
1528: and (all_org = 1 OR (all_org = 2 AND organization_id = org_id)) ;
1529:
1530: Update BOM_SUB_OP_RESOURCES_INTERFACE
1531: set process_flag = 3
1532: where (ASSEMBLY_ITEM_NUMBER is null or Organization_code is null)
1533: and transaction_id is not null
1534: and process_flag =1