APPS.BOM_ROUTINGINTERFACE_PUB dependencies on BOM_OP_RESOURCES_INTERFACE

Line 1217: insert into bom_op_resources_interface(

1213: -- insert given operation resources into interface table
1214: If l_return_status = FND_API.G_RET_STS_SUCCESS then
1215: If nvl(l_interface_rec.resource_code1, G_NullChar) <> G_NullChar
1216: or nvl(l_interface_rec.resource_id1, G_NullNum) <> G_NullNum then
1217: insert into bom_op_resources_interface(
1218: OPERATION_SEQUENCE_ID,
1219: ASSEMBLY_ITEM_ID,
1220: ASSEMBLY_ITEM_NUMBER,
1221: ORGANIZATION_ID,

Line 1248: insert into bom_op_resources_interface (

1244: G_Insert);
1245: end if; -- resource 1
1246: If nvl(l_interface_rec.resource_code2, G_NullChar) <> G_NullChar
1247: or nvl(l_interface_rec.resource_id2, G_NullNum) <> G_NullNum then
1248: insert into bom_op_resources_interface (
1249: OPERATION_SEQUENCE_ID,
1250: ASSEMBLY_ITEM_ID,
1251: ASSEMBLY_ITEM_NUMBER,
1252: ORGANIZATION_ID,

Line 1279: insert into bom_op_resources_interface (

1275: G_Insert);
1276: end if; -- resource 2
1277: If nvl(l_interface_rec.resource_code3, G_NullChar) <> G_NullChar
1278: or nvl(l_interface_rec.resource_id3, G_NullNum) <> G_NullNum then
1279: insert into bom_op_resources_interface (
1280: OPERATION_SEQUENCE_ID,
1281: ASSEMBLY_ITEM_ID,
1282: ASSEMBLY_ITEM_NUMBER,
1283: ORGANIZATION_ID,

Line 1477: From bom_op_resources_interface

1473: attribute15,
1474: transaction_type,
1475: principle_flag, -- 2514018
1476: schedule_seq_num -- 2514018
1477: From bom_op_resources_interface
1478: Where process_flag = 1
1479: And (g_AllOrgs = g_yes
1480: or organization_id = g_OrgId
1481: or organization_code = g_OrgCode

Line 1938: Delete from bom_op_resources_interface

1934: End if; -- insert, update and delete
1935:
1936: If l_return_status = Fnd_Api.G_RET_STS_SUCCESS then
1937: If g_DeleteRows then
1938: Delete from bom_op_resources_interface
1939: Where rowid = l_interface_rec.rowid;
1940: Else
1941: Update bom_op_resources_interface
1942: Set process_flag = 7,

Line 1941: Update bom_op_resources_interface

1937: If g_DeleteRows then
1938: Delete from bom_op_resources_interface
1939: Where rowid = l_interface_rec.rowid;
1940: Else
1941: Update bom_op_resources_interface
1942: Set process_flag = 7,
1943: transaction_id = mtl_system_items_interface_s.nextval,
1944: request_id = nvl(request_id,g_RequestId),
1945: program_id = nvl(program_id,g_ProgramId),

Line 1974: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1970: prog_id => g_ProgramId,
1971: req_id => g_RequestId,
1972: trans_id => l_transaction_rec.transaction_id,
1973: error_text => l_msg_data,
1974: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1975: msg_name => l_msg_name,
1976: err_text => l_msg_data);
1977: If l_ret_code <> 0 then
1978: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1980: Update bom_op_resources_interface

1976: err_text => l_msg_data);
1977: If l_ret_code <> 0 then
1978: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1979: end if;
1980: Update bom_op_resources_interface
1981: Set process_flag = 3,
1982: transaction_id = l_transaction_rec.transaction_id
1983: Where rowid = l_interface_rec.rowid;
1984: End loop; -- log error