APPS.BOM_RTG_OI_UTIL dependencies on BOM_SUB_OP_RESOURCES_INTERFACE

Line 1283: BOM_SUB_OP_RESOURCES_INTERFACE

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

Line 1313: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

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

Line 1334: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

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

Line 1356: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

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

Line 1378: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

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

Line 1397: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

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

Line 1420: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

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

Line 1443: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

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

Line 1457: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI

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

Line 1505: 'BOM_SUB_OP_RESOURCES_INTERFACE',

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

Line 1517: from BOM_SUB_OP_RESOURCES_INTERFACE BSORI

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

Line 1528: Update BOM_SUB_OP_RESOURCES_INTERFACE

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