APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on WIP_OP_RESOURCE_INSTANCES

Line 1318: -- Procedure for inserting the instances into WIP_OP_RESOURCE_INSTANCES

1314: END insert_into_wcti;
1315:
1316:
1317:
1318: -- Procedure for inserting the instances into WIP_OP_RESOURCE_INSTANCES
1319:
1320: PROCEDURE insert_into_wori(
1321: p_api_version IN NUMBER
1322: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

Line 1346: from wip_op_resource_instances

1342: l_stmt_num NUMBER := 0;
1343:
1344: CURSOR c_cur_wori IS --rhshriva
1345: select instance_id
1346: from wip_op_resource_instances
1347: where wip_entity_id = p_wip_entity_id and
1348: organization_id = p_organization_id and
1349: operation_seq_num = p_operation_seq_num and
1350: resource_seq_num = p_resource_seq_num and

Line 1383: -- already exists in the table WIP_OP_RESOURCE_INSTANCES

1379: l_stmt_num := 50;
1380: -- API body
1381:
1382: -- Cursor to check whether the entry for the particular instance
1383: -- already exists in the table WIP_OP_RESOURCE_INSTANCES
1384:
1385: open c_cur_wori;
1386:
1387: LOOP

Line 1393: -- Check whether the entry for instance_id exists in WIP_OP_RESOURCE_INSTANCES

1389: EXIT WHEN c_cur_wori%NOTFOUND;
1390:
1391: l_stmt_num := 60;
1392:
1393: -- Check whether the entry for instance_id exists in WIP_OP_RESOURCE_INSTANCES
1394:
1395: if (l_instance_id = p_instance_id) then
1396: row_exists := 1;
1397: end if;

Line 1404: -- If the entry does not exist in the WIP_OP_RESOURCE_INSTANCES

1400:
1401:
1402: l_stmt_num := 70;
1403:
1404: -- If the entry does not exist in the WIP_OP_RESOURCE_INSTANCES
1405: -- Insert into the table
1406:
1407:
1408:

Line 1412: insert into wip_op_resource_instances (

1408:
1409: if (row_exists = 0) then
1410:
1411:
1412: insert into wip_op_resource_instances (
1413: wip_entity_id,
1414: operation_seq_num,
1415: resource_seq_num,
1416: organization_id,