APPS.FLM_EXECUTION_UTIL dependencies on FLM_EXE_OPERATIONS

Line 288: from flm_exe_operations

284:
285: --cursor to find out if some operation is current for a schedule and disbaled
286: CURSOR sch_cur_op_csr IS
287: select next_op_seq_id seq_id
288: from flm_exe_operations
289: where wip_entity_id = i_wip_entity_id
290: and flm_execution_util.workstation_enabled(next_op_seq_id) = 'N'
291: order by next_op_seq_id;
292: l_view_all_sch VARCHAR2(1);

Line 314: from flm_exe_operations

310: if(l_view_all_sch = 'Y' ) then
311: -- has this operation been completed?
312: select count(*)
313: into l_cnt
314: from flm_exe_operations
315: where wip_entity_id = i_wip_entity_id
316: and operation_sequence_id = l_op_seq_id
317: and organization_id = i_org_id;
318: IF l_cnt > 0 THEN

Line 328: from flm_exe_operations

324:
325: -- Is this operation current?
326: select count(*)
327: into l_cnt
328: from flm_exe_operations
329: where wip_entity_id = i_wip_entity_id
330: and next_op_seq_id = l_op_seq_id
331: and organization_id = i_org_id
332: and current_flag = 'Y';

Line 340: from flm_exe_operations

336:
337: -- has this operation been completed?
338: select count(*)
339: into l_cnt
340: from flm_exe_operations
341: where wip_entity_id = i_wip_entity_id
342: and operation_sequence_id = l_op_seq_id
343: and organization_id = i_org_id;
344: IF l_cnt > 0 THEN

Line 408: insert into flm_exe_operations (

404: i_wip_entity_id number,
405: i_op_seq_id number,
406: i_next_op_id number) IS
407: BEGIN
408: insert into flm_exe_operations (
409: wip_entity_id,
410: organization_id,
411: operation_sequence_id,
412: next_op_seq_id,

Line 434: update flm_exe_operations

430: 1111,
431: 1
432: );
433:
434: update flm_exe_operations
435: set current_flag = 'N',
436: object_version_number = object_version_number + 1
437: where next_op_seq_id = i_op_seq_id
438: and wip_entity_id = i_wip_entity_id;

Line 934: from flm_exe_operations

930:
931: CURSOR completed_ops(p_org_id NUMBER,
932: p_wip_ent_id NUMBER) IS
933: select distinct operation_sequence_id
934: from flm_exe_operations
935: where wip_entity_id = p_wip_ent_id
936: and organization_id = p_org_id
937: order by operation_sequence_id;
938:

Line 942: from flm_exe_operations

938:
939: CURSOR completed_operations(p_org_id NUMBER,
940: p_wip_ent_id NUMBER) IS
941: select distinct operation_sequence_id, next_op_seq_id
942: from flm_exe_operations
943: where wip_entity_id = p_wip_ent_id
944: and organization_id = p_org_id
945: order by operation_sequence_id;
946:

Line 964: from flm_exe_operations

960: and operation_type = 1;
961:
962: CURSOR next_op_count(p_org_id NUMBER, p_wip_ent_id NUMBER, p_from_op_seq NUMBER) IS
963: select count(operation_sequence_id) opcount
964: from flm_exe_operations
965: where wip_entity_id = p_wip_ent_id
966: and organization_id = p_org_id
967: and operation_sequence_id = p_from_op_seq;
968:

Line 1612: from flm_exe_operations

1608: FUNCTION scheduleRecordedDetailsExist(orgId Number, wipEntId Number)
1609: return VARCHAR2 IS
1610: CURSOR recordedOperation(p_orgId Number, p_wipEntId Number ) IS
1611: select count(wip_entity_id) count
1612: from flm_exe_operations
1613: where organization_id = p_orgId
1614: and wip_entity_id = p_wipEntId;
1615:
1616: CURSOR recordedDetails(p_orgId Number, p_wipEntId Number) IS