[Home] [Help]
43: p_op_type number) Return Boolean Is
44: l_total number := 0;
45: Begin
46: select count(*) into l_total
47: from bom_standard_operations
48: where organization_id = p_org_id
49: and line_id = p_line_id
50: and operation_code = p_std_op_code
51: and operation_type = p_op_type;
269: and (p_tpct_from is NULL or bor.total_product_cycle_time >= p_tpct_from)
270: and (p_tpct_to is NULL or bor.total_product_cycle_time <= p_tpct_to)
271: and (p_lineop_code is NULL or exists (
272: select 1
273: from bom_operation_sequences bos1, bom_standard_operations bso1
274: where bos1.routing_sequence_id = bor.common_routing_sequence_id
275: and p_lineop_code = bso1.operation_code
276: and bos1.standard_operation_id = bso1.standard_operation_id
277: and bso1.organization_id = p_organization_id
279: and bos1.operation_type = 3)
280: )
281: and (p_process_code is NULL or exists (
282: select 1
283: from bom_operation_sequences bos1, bom_standard_operations bso1
284: where bos1.routing_sequence_id = bor.common_routing_sequence_id
285: and p_process_code = bso1.operation_code
286: and bos1.standard_operation_id = bso1.standard_operation_id
287: and bso1.organization_id = p_organization_id
522: Cursor c_std_op(p_standard_operation_id number) Is
523: Select
524: *
525: From
526: bom_standard_operations
527: Where
528: standard_operation_id = p_standard_operation_id
529: ;
530:
1211:
1212: -- both RTG and/or BOM copied, then copy attachments
1213: if (o_return_status = 'S') then
1214: if l_2_ids.COUNT > 0 then
1215: copy_attach('BOM_STANDARD_OPERATIONS','BOM_STANDARD_OPERATIONS',l_2_ids);
1216: end if;
1217: if a_operation_tbl.COUNT > 0 then
1218:
1219: l_new_rtg_seq_id := null;