350: and bos.standard_operation_id = i_std_op_id;
351:
352: select count(*)
353: into l_cnt
354: from flm_exe_operations
355: where wip_entity_id = i_wip_entity_id
356: and operation_sequence_id = l_op_seq_id
357: and organization_id = i_org_id;
358: IF l_cnt > 0 THEN
384: return 'N';
385: end if;
386: -- Check Current op.
387: select count(1) into l_count
388: from flm_exe_operations
389: where wip_entity_id = i_wip_entity_id
390: and next_op_seq_id = i_op_seq_id
391: and organization_id = i_org_id
392: and current_flag = 'Y';
394: return 'Y';
395: end if;
396: -- Check completed op.
397: select count(1) into l_count
398: from flm_exe_operations
399: where wip_entity_id = i_wip_entity_id
400: and operation_sequence_id = i_op_seq_id
401: and organization_id = i_org_id;
402: if l_count > 0 then
409: if (l_count = 0) then
410: return 'Y';
411: else
412: select count(1) into l_count
413: from flm_exe_operations
414: where operation_sequence_id = v_bon_exists.from_op_seq_id
415: and wip_entity_id = i_wip_entity_id
416: and organization_id = i_org_id;
417: if l_count = 0 then
468:
469: --cursor to find out if some operation is current for a schedule and disbaled
470: CURSOR sch_cur_op_csr IS
471: select next_op_seq_id seq_id
472: from flm_exe_operations
473: where wip_entity_id = i_wip_entity_id
474: and flm_execution_util.workstation_enabled(next_op_seq_id) = 'N'
475: order by next_op_seq_id;
476: l_view_all_sch VARCHAR2(1);
515: if(l_view_all_sch = 'Y' ) then
516: -- has this operation been completed?
517: select count(*)
518: into l_cnt
519: from flm_exe_operations
520: where wip_entity_id = i_wip_entity_id
521: and operation_sequence_id = l_op_seq_id
522: and organization_id = i_org_id;
523: IF l_cnt > 0 THEN
531:
532: -- Is this operation current?
533: select count(*)
534: into l_cnt
535: from flm_exe_operations
536: where wip_entity_id = i_wip_entity_id
537: and next_op_seq_id = l_op_seq_id
538: and organization_id = i_org_id
539: and current_flag = 'Y';
544:
545: -- has this operation been completed?
546: select count(*)
547: into l_cnt
548: from flm_exe_operations
549: where wip_entity_id = i_wip_entity_id
550: and operation_sequence_id = l_op_seq_id
551: and organization_id = i_org_id;
552: IF l_cnt > 0 THEN
621: i_wip_entity_id number,
622: i_op_seq_id number,
623: i_next_op_id number) IS
624: BEGIN
625: insert into flm_exe_operations (
626: wip_entity_id,
627: organization_id,
628: operation_sequence_id,
629: next_op_seq_id,
647: 1111,
648: 1
649: );
650:
651: update flm_exe_operations
652: set current_flag = 'N',
653: object_version_number = object_version_number + 1
654: where next_op_seq_id = i_op_seq_id
655: and wip_entity_id = i_wip_entity_id;
1147:
1148: CURSOR completed_ops(p_org_id NUMBER,
1149: p_wip_ent_id NUMBER) IS
1150: select distinct operation_sequence_id
1151: from flm_exe_operations
1152: where wip_entity_id = p_wip_ent_id
1153: and organization_id = p_org_id
1154: order by operation_sequence_id;
1155:
1155:
1156: CURSOR completed_operations(p_org_id NUMBER,
1157: p_wip_ent_id NUMBER) IS
1158: select distinct operation_sequence_id, next_op_seq_id
1159: from flm_exe_operations
1160: where wip_entity_id = p_wip_ent_id
1161: and organization_id = p_org_id
1162: order by operation_sequence_id;
1163:
1177: and operation_type = 1;
1178:
1179: CURSOR next_op_count(p_org_id NUMBER, p_wip_ent_id NUMBER, p_from_op_seq NUMBER) IS
1180: select count(operation_sequence_id) opcount
1181: from flm_exe_operations
1182: where wip_entity_id = p_wip_ent_id
1183: and organization_id = p_org_id
1184: and operation_sequence_id = p_from_op_seq;
1185:
1828: FUNCTION scheduleRecordedDetailsExist(orgId Number, wipEntId Number)
1829: return VARCHAR2 IS
1830: CURSOR recordedOperation(p_orgId Number, p_wipEntId Number ) IS
1831: select count(wip_entity_id) count
1832: from flm_exe_operations
1833: where organization_id = p_orgId
1834: and wip_entity_id = p_wipEntId;
1835:
1836: CURSOR recordedDetails(p_orgId Number, p_wipEntId Number) IS