APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on WIP_OP_RESOURCE_INSTANCES

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

1245: END insert_into_wcti;
1246:
1247:
1248:
1249: -- Procedure for inserting the instances into WIP_OP_RESOURCE_INSTANCES
1250:
1251: PROCEDURE insert_into_wori(
1252: p_api_version IN NUMBER
1253: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

Line 1277: from wip_op_resource_instances

1273: l_stmt_num NUMBER := 0;
1274:
1275: CURSOR c_cur_wori IS --rhshriva
1276: select instance_id
1277: from wip_op_resource_instances
1278: where wip_entity_id = p_wip_entity_id and
1279: organization_id = p_organization_id and
1280: operation_seq_num = p_operation_seq_num and
1281: resource_seq_num = p_resource_seq_num and

Line 1314: -- already exists in the table WIP_OP_RESOURCE_INSTANCES

1310: l_stmt_num := 50;
1311: -- API body
1312:
1313: -- Cursor to check whether the entry for the particular instance
1314: -- already exists in the table WIP_OP_RESOURCE_INSTANCES
1315:
1316: open c_cur_wori;
1317:
1318: LOOP

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

1320: EXIT WHEN c_cur_wori%NOTFOUND;
1321:
1322: l_stmt_num := 60;
1323:
1324: -- Check whether the entry for instance_id exists in WIP_OP_RESOURCE_INSTANCES
1325:
1326: if (l_instance_id = p_instance_id) then
1327: row_exists := 1;
1328: end if;

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

1331:
1332:
1333: l_stmt_num := 70;
1334:
1335: -- If the entry does not exist in the WIP_OP_RESOURCE_INSTANCES
1336: -- Insert into the table
1337:
1338:
1339:

Line 1343: insert into wip_op_resource_instances (

1339:
1340: if (row_exists = 0) then
1341:
1342:
1343: insert into wip_op_resource_instances (
1344: wip_entity_id,
1345: operation_seq_num,
1346: resource_seq_num,
1347: organization_id,