eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FLM_COPY_ROUTING dependencies on STANDARD

Line 47: from bom_standard_operations

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;

Line 237: from bom_operation_sequences bos1, bom_standard_operations bso1

233: and (p_tpct_from is NULL or bor.total_product_cycle_time >= p_tpct_from)
234: and (p_tpct_to is NULL or bor.total_product_cycle_time <= p_tpct_to)
235: and (p_lineop_code is NULL or exists (
236: select 1
237: from bom_operation_sequences bos1, bom_standard_operations bso1
238: where bos1.routing_sequence_id = bor.common_routing_sequence_id
239: and p_lineop_code = bso1.operation_code
240: and bos1.standard_operation_id = bso1.standard_operation_id
241: and bso1.organization_id = p_organization_id

Line 240: and bos1.standard_operation_id = bso1.standard_operation_id

236: select 1
237: from bom_operation_sequences bos1, bom_standard_operations bso1
238: where bos1.routing_sequence_id = bor.common_routing_sequence_id
239: and p_lineop_code = bso1.operation_code
240: and bos1.standard_operation_id = bso1.standard_operation_id
241: and bso1.organization_id = p_organization_id
242: and bso1.line_id = p_line_id_from
243: and bos1.operation_type = 3)
244: )

Line 247: from bom_operation_sequences bos1, bom_standard_operations bso1

243: and bos1.operation_type = 3)
244: )
245: and (p_process_code is NULL or exists (
246: select 1
247: from bom_operation_sequences bos1, bom_standard_operations bso1
248: where bos1.routing_sequence_id = bor.common_routing_sequence_id
249: and p_process_code = bso1.operation_code
250: and bos1.standard_operation_id = bso1.standard_operation_id
251: and bso1.organization_id = p_organization_id

Line 250: and bos1.standard_operation_id = bso1.standard_operation_id

246: select 1
247: from bom_operation_sequences bos1, bom_standard_operations bso1
248: where bos1.routing_sequence_id = bor.common_routing_sequence_id
249: and p_process_code = bso1.operation_code
250: and bos1.standard_operation_id = bso1.standard_operation_id
251: and bso1.organization_id = p_organization_id
252: and bso1.line_id = p_line_id_from
253: and bos1.operation_type = 2)
254: )

Line 342: ,bosv.standard_operation_code Standard_Operation_Code

338: ,bosv.operation_type Operation_Type
339: ,bosv.effectivity_date Start_Effective_Date
340: ,bosv.operation_seq_num New_Operation_Sequence_Number
341: ,bosv.effectivity_date New_Start_Effective_Date
342: ,bosv.standard_operation_code Standard_Operation_Code
343: ,bosv.department_code Department_Code
344: ,bosv.operation_lead_time_percent Op_Lead_Time_Percent
345: ,bosv.minimum_transfer_quantity Minimum_Transfer_Quantity
346: ,bosv.count_point_type Count_Point_Type

Line 389: ,bosv.STANDARD_OPERATION_ID STANDARD_OPERATION_ID

385: ,NULL Return_Status
386: ,NULL Delete_Group_Name
387: ,NULL DG_Description
388: ,bosv.OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID
389: ,bosv.STANDARD_OPERATION_ID STANDARD_OPERATION_ID
390: From bom_operation_sequences_v bosv
391: Where bosv.routing_sequence_id = p_routing_sequence_id
392: and ((bosv.effectivity_date <= l_today and nvl(bosv.disable_date,l_today+1) > l_today)
393: or (bosv.effectivity_date > l_today and nvl(bosv.disable_date, bosv.effectivity_date+1) > bosv.effectivity_date))

Line 408: , borv.standard_rate_flag Standard_Rate_Flag

404: , null Op_Start_Effective_Date
405: , borv.resource_seq_num Resource_Sequence_Number
406: , borv.resource_code Resource_Code
407: , borv.activity Activity
408: , borv.standard_rate_flag Standard_Rate_Flag
409: , borv.assigned_units Assigned_Units
410: , borv.usage_rate_or_amount Usage_Rate_Or_Amount
411: , borv.usage_rate_or_amount_inverse Usage_Rate_Or_Amount_Inverse
412: , borv.basis_type Basis_Type

Line 460: , bsorv.Standard_Rate_Flag Standard_Rate_Flag

456: , bsorv.Schedule_Seq_Num Schedule_Sequence_Number
457: , bsorv.Replacement_Group_Num Replacement_Group_Number
458: , bsorv.Replacement_Group_Num New_Replacement_Group_Number
459: , bsorv.Activity Activity
460: , bsorv.Standard_Rate_Flag Standard_Rate_Flag
461: , bsorv.Assigned_Units Assigned_Units
462: , bsorv.Usage_Rate_Or_Amount Usage_Rate_Or_Amount
463: , bsorv.Usage_Rate_Or_Amount_Inverse Usage_Rate_Or_Amount_Inverse
464: , bsorv.Basis_Type Basis_Type

Line 547: Select distinct standard_operation_id

543: or (bos2.effectivity_date > l_today and nvl(bos2.disable_date, bos2.effectivity_date+1) > bos2.effectivity_date));
544: l_networks_rec c_networks%ROWTYPE;
545:
546: Cursor c_std_ops(p_routing_sequence_id number) Is
547: Select distinct standard_operation_id
548: ,standard_operation_code
549: ,operation_type
550: From bom_operation_sequences_v bosv
551: Where routing_sequence_id = p_routing_sequence_id

Line 548: ,standard_operation_code

544: l_networks_rec c_networks%ROWTYPE;
545:
546: Cursor c_std_ops(p_routing_sequence_id number) Is
547: Select distinct standard_operation_id
548: ,standard_operation_code
549: ,operation_type
550: From bom_operation_sequences_v bosv
551: Where routing_sequence_id = p_routing_sequence_id
552: and ((effectivity_date <= l_today and nvl(disable_date,l_today+1) > l_today)

Line 554: Order by standard_operation_code;

550: From bom_operation_sequences_v bosv
551: Where routing_sequence_id = p_routing_sequence_id
552: and ((effectivity_date <= l_today and nvl(disable_date,l_today+1) > l_today)
553: or (effectivity_date > l_today and nvl(disable_date, effectivity_date+1) > effectivity_date))
554: Order by standard_operation_code;
555:
556: Cursor c_std_op(p_standard_operation_id number) Is
557: Select * From bom_standard_operations
558: Where standard_operation_id = p_standard_operation_id;

Line 556: Cursor c_std_op(p_standard_operation_id number) Is

552: and ((effectivity_date <= l_today and nvl(disable_date,l_today+1) > l_today)
553: or (effectivity_date > l_today and nvl(disable_date, effectivity_date+1) > effectivity_date))
554: Order by standard_operation_code;
555:
556: Cursor c_std_op(p_standard_operation_id number) Is
557: Select * From bom_standard_operations
558: Where standard_operation_id = p_standard_operation_id;
559:
560: Cursor c_std_op_res(p_standard_operation_id number) Is

Line 557: Select * From bom_standard_operations

553: or (effectivity_date > l_today and nvl(disable_date, effectivity_date+1) > effectivity_date))
554: Order by standard_operation_code;
555:
556: Cursor c_std_op(p_standard_operation_id number) Is
557: Select * From bom_standard_operations
558: Where standard_operation_id = p_standard_operation_id;
559:
560: Cursor c_std_op_res(p_standard_operation_id number) Is
561: Select * From bom_std_op_resources

Line 558: Where standard_operation_id = p_standard_operation_id;

554: Order by standard_operation_code;
555:
556: Cursor c_std_op(p_standard_operation_id number) Is
557: Select * From bom_standard_operations
558: Where standard_operation_id = p_standard_operation_id;
559:
560: Cursor c_std_op_res(p_standard_operation_id number) Is
561: Select * From bom_std_op_resources
562: Where standard_operation_id = p_standard_operation_id ;

Line 560: Cursor c_std_op_res(p_standard_operation_id number) Is

556: Cursor c_std_op(p_standard_operation_id number) Is
557: Select * From bom_standard_operations
558: Where standard_operation_id = p_standard_operation_id;
559:
560: Cursor c_std_op_res(p_standard_operation_id number) Is
561: Select * From bom_std_op_resources
562: Where standard_operation_id = p_standard_operation_id ;
563:
564: Cursor c_new_rtg_seq_id(p_item_id number, p_org_id number, p_alternate varchar2) Is

Line 562: Where standard_operation_id = p_standard_operation_id ;

558: Where standard_operation_id = p_standard_operation_id;
559:
560: Cursor c_std_op_res(p_standard_operation_id number) Is
561: Select * From bom_std_op_resources
562: Where standard_operation_id = p_standard_operation_id ;
563:
564: Cursor c_new_rtg_seq_id(p_item_id number, p_org_id number, p_alternate varchar2) Is
565: Select routing_sequence_id
566: From bom_operational_routings

Line 727: -- copy standard operations and their resources

723: -- routing revisions
724: l_rtg_revision_tbl := t_rtg_revision_tbl;
725: o_rtg_revision_tbl := l_rtg_revision_tbl;
726:
727: -- copy standard operations and their resources
728: SAVEPOINT copy_std;
729:
730: l_2_ids := t_2_ids;
731: l_2_seq_ids := t_2_ids;

Line 737: if (not std_op_exists( p_organization_id, p_line_id_to,stdop.standard_operation_code,stdop.operation_type)) then

733: LOOP
734: -- insert std_op for p_line_id_to
735: -- cp std_op_res from old_op_id to new_op_id
736:
737: if (not std_op_exists( p_organization_id, p_line_id_to,stdop.standard_operation_code,stdop.operation_type)) then
738: l_std_op_exist := true;
739: OPEN c_std_op(stdop.standard_operation_id);
740: FETCH c_std_op into std_op_rec;
741: IF c_std_op%NOTFOUND THEN

Line 739: OPEN c_std_op(stdop.standard_operation_id);

735: -- cp std_op_res from old_op_id to new_op_id
736:
737: if (not std_op_exists( p_organization_id, p_line_id_to,stdop.standard_operation_code,stdop.operation_type)) then
738: l_std_op_exist := true;
739: OPEN c_std_op(stdop.standard_operation_id);
740: FETCH c_std_op into std_op_rec;
741: IF c_std_op%NOTFOUND THEN
742: l_std_op_exist := false;
743: END IF;

Line 750: ,x_standard_operation_id =>new_std_op_id

746: if (l_std_op_exist) then
747: new_row_id := NULL;
748: new_std_op_id := NULL;
749: b_std_op_pkg.Insert_Row( x_rowid =>new_row_id
750: ,x_standard_operation_id =>new_std_op_id
751: ,x_operation_code =>std_op_rec.operation_code
752: ,x_operation_type =>std_op_rec.operation_type
753: ,x_line_id =>p_line_id_to
754: ,x_sequence_num =>std_op_rec.sequence_num

Line 787: l_2_ids(stdop.standard_operation_id).old_id := stdop.standard_operation_id;

783: ,x_wms_task_type =>std_op_rec.wms_task_type
784: ,x_yield =>std_op_rec.yield
785: ,x_operation_yield_enabled =>std_op_rec.operation_yield_enabled);
786:
787: l_2_ids(stdop.standard_operation_id).old_id := stdop.standard_operation_id;
788: l_2_ids(stdop.standard_operation_id).new_id := new_std_op_id;
789:
790: FOR std_op_res_rec in c_std_op_res(stdop.standard_operation_id)
791: LOOP

Line 788: l_2_ids(stdop.standard_operation_id).new_id := new_std_op_id;

784: ,x_yield =>std_op_rec.yield
785: ,x_operation_yield_enabled =>std_op_rec.operation_yield_enabled);
786:
787: l_2_ids(stdop.standard_operation_id).old_id := stdop.standard_operation_id;
788: l_2_ids(stdop.standard_operation_id).new_id := new_std_op_id;
789:
790: FOR std_op_res_rec in c_std_op_res(stdop.standard_operation_id)
791: LOOP
792: new_row_id := null;

Line 790: FOR std_op_res_rec in c_std_op_res(stdop.standard_operation_id)

786:
787: l_2_ids(stdop.standard_operation_id).old_id := stdop.standard_operation_id;
788: l_2_ids(stdop.standard_operation_id).new_id := new_std_op_id;
789:
790: FOR std_op_res_rec in c_std_op_res(stdop.standard_operation_id)
791: LOOP
792: new_row_id := null;
793: b_std_op_res_pkg.Insert_Row( x_rowid =>new_row_id
794: ,x_standard_operation_id =>new_std_op_id

Line 794: ,x_standard_operation_id =>new_std_op_id

790: FOR std_op_res_rec in c_std_op_res(stdop.standard_operation_id)
791: LOOP
792: new_row_id := null;
793: b_std_op_res_pkg.Insert_Row( x_rowid =>new_row_id
794: ,x_standard_operation_id =>new_std_op_id
795: ,x_resource_id =>std_op_res_rec.resource_id
796: ,x_activity_id =>std_op_res_rec.activity_id
797: ,x_last_update_date =>sysdate
798: ,x_last_updated_by =>fnd_global.user_id

Line 807: ,x_standard_rate_flag =>std_op_res_rec.standard_rate_flag

803: ,x_usage_rate_or_amount =>std_op_res_rec.usage_rate_or_amount
804: ,x_usage_rate_or_amount_inverse =>std_op_res_rec.usage_rate_or_amount_inverse
805: ,x_basis_type =>std_op_res_rec.basis_type
806: ,x_autocharge_type =>std_op_res_rec.autocharge_type
807: ,x_standard_rate_flag =>std_op_res_rec.standard_rate_flag
808: ,x_assigned_units =>std_op_res_rec.assigned_units
809: ,x_schedule_flag =>std_op_res_rec.schedule_flag
810: ,x_attribute_category =>std_op_res_rec.attribute_category
811: ,x_attribute1 =>std_op_res_rec.attribute1

Line 838: from (select department_id from bom_standard_operations where standard_operation_id = stdop.standard_operation_id) a,

834:
835: BEGIN
836: l_diff_count := 0;
837: select count(*) into l_diff_count
838: from (select department_id from bom_standard_operations where standard_operation_id = stdop.standard_operation_id) a,
839: (select department_id from bom_standard_operations where organization_id = p_organization_id and line_id = p_line_id_to
840: and operation_code = stdop.standard_operation_code and operation_type = stdop.operation_type) b
841: where a.department_id <> b.department_id;
842: if (l_diff_count = 1) then

Line 839: (select department_id from bom_standard_operations where organization_id = p_organization_id and line_id = p_line_id_to

835: BEGIN
836: l_diff_count := 0;
837: select count(*) into l_diff_count
838: from (select department_id from bom_standard_operations where standard_operation_id = stdop.standard_operation_id) a,
839: (select department_id from bom_standard_operations where organization_id = p_organization_id and line_id = p_line_id_to
840: and operation_code = stdop.standard_operation_code and operation_type = stdop.operation_type) b
841: where a.department_id <> b.department_id;
842: if (l_diff_count = 1) then
843: l_dept_diff := 1;

Line 840: and operation_code = stdop.standard_operation_code and operation_type = stdop.operation_type) b

836: l_diff_count := 0;
837: select count(*) into l_diff_count
838: from (select department_id from bom_standard_operations where standard_operation_id = stdop.standard_operation_id) a,
839: (select department_id from bom_standard_operations where organization_id = p_organization_id and line_id = p_line_id_to
840: and operation_code = stdop.standard_operation_code and operation_type = stdop.operation_type) b
841: where a.department_id <> b.department_id;
842: if (l_diff_count = 1) then
843: l_dept_diff := 1;
844: retcode := 1;

Line 847: l_assembly_item_name||' as department of Event '||stdop.standard_operation_code||' on source line '||l_line_code_from||

843: l_dept_diff := 1;
844: retcode := 1;
845: if (stdop.operation_type = 1) then
846: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||
847: l_assembly_item_name||' as department of Event '||stdop.standard_operation_code||' on source line '||l_line_code_from||
848: ' is different from that on the destination line '||l_line_code||'.');
849: elsif (stdop.operation_type = 2) then
850: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||
851: l_assembly_item_name||' as department of Process '||stdop.standard_operation_code||' on source line '||l_line_code_from||

Line 851: l_assembly_item_name||' as department of Process '||stdop.standard_operation_code||' on source line '||l_line_code_from||

847: l_assembly_item_name||' as department of Event '||stdop.standard_operation_code||' on source line '||l_line_code_from||
848: ' is different from that on the destination line '||l_line_code||'.');
849: elsif (stdop.operation_type = 2) then
850: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||
851: l_assembly_item_name||' as department of Process '||stdop.standard_operation_code||' on source line '||l_line_code_from||
852: ' is different from that on the destination line '||l_line_code||'.');
853: else
854: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||
855: l_assembly_item_name||' as department of Line Operation '||stdop.standard_operation_code||' on source line '||l_line_code_from||

Line 855: l_assembly_item_name||' as department of Line Operation '||stdop.standard_operation_code||' on source line '||l_line_code_from||

851: l_assembly_item_name||' as department of Process '||stdop.standard_operation_code||' on source line '||l_line_code_from||
852: ' is different from that on the destination line '||l_line_code||'.');
853: else
854: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||
855: l_assembly_item_name||' as department of Line Operation '||stdop.standard_operation_code||' on source line '||l_line_code_from||
856: ' is different from that on the destination line '||l_line_code||'.');
857: end if;
858: end if;
859: Exception

Line 902: l_operation_tbl(j).Standard_Operation_Code := null;

898: l_operation_tbl(j).Operation_Type := null;
899: l_operation_tbl(j).Start_Effective_Date := null;
900: l_operation_tbl(j).New_Operation_Sequence_Number := null;
901: l_operation_tbl(j).New_Start_Effective_Date := null;
902: l_operation_tbl(j).Standard_Operation_Code := null;
903: l_operation_tbl(j).Department_Code := null;
904: l_operation_tbl(j).Op_Lead_Time_Percent := null;
905: l_operation_tbl(j).Minimum_Transfer_Quantity := null;
906: l_operation_tbl(j).Count_Point_Type := null;

Line 956: l_operation_tbl(j).Standard_Operation_Code := l_operations_rec.Standard_Operation_Code;

952: l_operation_tbl(j).Operation_Type := l_operations_rec.Operation_Type;
953: l_operation_tbl(j).Start_Effective_Date := l_operations_rec.Start_Effective_Date;
954: l_operation_tbl(j).New_Operation_Sequence_Number := l_operations_rec.New_Operation_Sequence_Number;
955: l_operation_tbl(j).New_Start_Effective_Date := l_operations_rec.New_Start_Effective_Date;
956: l_operation_tbl(j).Standard_Operation_Code := l_operations_rec.Standard_Operation_Code;
957: l_operation_tbl(j).Department_Code := l_operations_rec.Department_Code;
958: l_operation_tbl(j).Op_Lead_Time_Percent := l_operations_rec.Op_Lead_Time_Percent;
959: l_operation_tbl(j).Minimum_Transfer_Quantity := l_operations_rec.Minimum_Transfer_Quantity;
960: l_operation_tbl(j).Count_Point_Type := l_operations_rec.Count_Point_Type;

Line 1014: l_operation_tbl(ii).standard_operation_code = l_operation_tbl(j).process_code then

1010: jj := l_operation_tbl.LAST;
1011: LOOP
1012: if l_operation_tbl(ii).operation_type = 2 and
1013: l_operation_tbl(ii).operation_sequence_number = l_operation_tbl(j).process_seq_number and
1014: l_operation_tbl(ii).standard_operation_code = l_operation_tbl(j).process_code then
1015: process_in_list := true;
1016: end if;
1017: if l_operation_tbl(ii).operation_type = 3 and
1018: l_operation_tbl(ii).operation_sequence_number = l_operation_tbl(j).line_op_seq_number and

Line 1019: l_operation_tbl(ii).standard_operation_code = l_operation_tbl(j).line_op_code then

1015: process_in_list := true;
1016: end if;
1017: if l_operation_tbl(ii).operation_type = 3 and
1018: l_operation_tbl(ii).operation_sequence_number = l_operation_tbl(j).line_op_seq_number and
1019: l_operation_tbl(ii).standard_operation_code = l_operation_tbl(j).line_op_code then
1020: lineop_in_list := true;
1021: end if;
1022: exit when ii = jj;
1023: ii := l_operation_tbl.NEXT(ii);

Line 1050: l_op_resource_tbl(k).Standard_Rate_Flag := null;

1046: l_op_resource_tbl(k).Op_Start_Effective_Date := null;
1047: l_op_resource_tbl(k).Resource_Sequence_Number := null;
1048: l_op_resource_tbl(k).Resource_Code := null;
1049: l_op_resource_tbl(k).Activity := null;
1050: l_op_resource_tbl(k).Standard_Rate_Flag := null;
1051: l_op_resource_tbl(k).Assigned_Units := null;
1052: l_op_resource_tbl(k).Usage_Rate_Or_Amount := null;
1053: l_op_resource_tbl(k).Usage_Rate_Or_Amount_Inverse := null;
1054: l_op_resource_tbl(k).Basis_Type := null;

Line 1093: l_op_resource_tbl(k).Standard_Rate_Flag := l_op_res_rec.Standard_Rate_Flag ;

1089: l_op_resource_tbl(k).Op_Start_Effective_Date := l_operation_tbl(j).Start_Effective_Date;
1090: l_op_resource_tbl(k).Resource_Sequence_Number := l_op_res_rec.Resource_Sequence_Number;
1091: l_op_resource_tbl(k).Resource_Code := l_op_res_rec.Resource_Code ;
1092: l_op_resource_tbl(k).Activity := l_op_res_rec.Activity ;
1093: l_op_resource_tbl(k).Standard_Rate_Flag := l_op_res_rec.Standard_Rate_Flag ;
1094: l_op_resource_tbl(k).Assigned_Units := l_op_res_rec.Assigned_Units ;
1095: l_op_resource_tbl(k).Usage_Rate_Or_Amount := l_op_res_rec.Usage_Rate_Or_Amount;
1096: l_op_resource_tbl(k).Usage_Rate_Or_Amount_Inverse := l_op_res_rec.Usage_Rate_Or_Amount_Inverse;
1097: l_op_resource_tbl(k).Basis_Type := l_op_res_rec.Basis_Type;

Line 1126: if l_operations_rec.Standard_Operation_id is not null then

1122: l_op_resource_tbl(k).Return_status := l_op_res_rec.Return_status ;
1123: l_op_resource_tbl(k).Setup_type := l_op_res_rec.Setup_type ;
1124: l_op_resource_tbl(k).Row_identifier := l_op_res_rec.Row_identifier;
1125: l_op_res_cnt := 0;
1126: if l_operations_rec.Standard_Operation_id is not null then
1127: select count(1) into l_op_res_cnt
1128: from bom_std_op_resources bsor
1129: where bsor.Standard_Operation_id = l_operations_rec.Standard_Operation_id
1130: and bsor.resource_seq_num = l_op_res_rec.Resource_Sequence_Number;

Line 1129: where bsor.Standard_Operation_id = l_operations_rec.Standard_Operation_id

1125: l_op_res_cnt := 0;
1126: if l_operations_rec.Standard_Operation_id is not null then
1127: select count(1) into l_op_res_cnt
1128: from bom_std_op_resources bsor
1129: where bsor.Standard_Operation_id = l_operations_rec.Standard_Operation_id
1130: and bsor.resource_seq_num = l_op_res_rec.Resource_Sequence_Number;
1131: if l_op_res_cnt > 0 then
1132: l_op_resource_tbl(k).Transaction_type := 'UPDATE';
1133: else

Line 1162: l_sub_resource_tbl(l).Standard_Rate_Flag := null ;

1158: l_sub_resource_tbl(l).Schedule_Sequence_Number := null ;
1159: l_sub_resource_tbl(l).Replacement_Group_Number := null ;
1160: l_sub_resource_tbl(l).New_Replacement_Group_Number := null ;
1161: l_sub_resource_tbl(l).Activity := null ;
1162: l_sub_resource_tbl(l).Standard_Rate_Flag := null ;
1163: l_sub_resource_tbl(l).Assigned_Units := null ;
1164: l_sub_resource_tbl(l).Usage_Rate_Or_Amount := null ;
1165: l_sub_resource_tbl(l).Usage_Rate_Or_Amount_Inverse := null ;
1166: l_sub_resource_tbl(l).Basis_Type := null ;

Line 1208: l_sub_resource_tbl(l).Standard_Rate_Flag := l_op_sub_res_rec.Standard_Rate_Flag ;

1204: l_sub_resource_tbl(l).Schedule_Sequence_Number := l_op_sub_res_rec.Schedule_Sequence_Number;
1205: l_sub_resource_tbl(l).Replacement_Group_Number := l_op_sub_res_rec.Replacement_Group_Number;
1206: l_sub_resource_tbl(l).New_Replacement_Group_Number := l_op_sub_res_rec.New_Replacement_Group_Number;
1207: l_sub_resource_tbl(l).Activity := l_op_sub_res_rec.Activity ;
1208: l_sub_resource_tbl(l).Standard_Rate_Flag := l_op_sub_res_rec.Standard_Rate_Flag ;
1209: l_sub_resource_tbl(l).Assigned_Units := l_op_sub_res_rec.Assigned_Units ;
1210: l_sub_resource_tbl(l).Usage_Rate_Or_Amount := l_op_sub_res_rec.Usage_Rate_Or_Amount;
1211: l_sub_resource_tbl(l).Usage_Rate_Or_Amount_Inverse := l_op_sub_res_rec.Usage_Rate_Or_Amount_Inverse;
1212: l_sub_resource_tbl(l).Basis_Type := l_op_sub_res_rec.Basis_Type ;

Line 1240: if l_operations_rec.Standard_Operation_id is not null then

1236: l_sub_resource_tbl(l).Return_Status := l_op_sub_res_rec.Return_Status ;
1237: l_sub_resource_tbl(l).Setup_Type := l_op_sub_res_rec.Setup_Type ;
1238:
1239: l_op_res_cnt := 0;
1240: if l_operations_rec.Standard_Operation_id is not null then
1241: select count(1) into l_op_res_cnt
1242: from BOM_STD_SUB_OP_RESOURCES bsor
1243: where bsor.Standard_Operation_id = l_operations_rec.Standard_Operation_id
1244: and bsor.resource_id = l_op_sub_res_rec.resource_id

Line 1243: where bsor.Standard_Operation_id = l_operations_rec.Standard_Operation_id

1239: l_op_res_cnt := 0;
1240: if l_operations_rec.Standard_Operation_id is not null then
1241: select count(1) into l_op_res_cnt
1242: from BOM_STD_SUB_OP_RESOURCES bsor
1243: where bsor.Standard_Operation_id = l_operations_rec.Standard_Operation_id
1244: and bsor.resource_id = l_op_sub_res_rec.resource_id
1245: and bsor.substitute_group_num = l_op_sub_res_rec.Substitute_Group_Number
1246: and bsor.replacement_group_num = l_op_sub_res_rec.Replacement_Group_Number
1247: and bsor.basis_type = l_op_sub_res_rec.Basis_Type;

Line 1489: copy_attach('BOM_STANDARD_OPERATIONS','BOM_STANDARD_OPERATIONS',l_2_ids);

1485:
1486: -- both RTG and/or BOM copied, then copy attachments
1487: if (o_return_status = 'S') then
1488: if l_2_ids.COUNT > 0 then
1489: copy_attach('BOM_STANDARD_OPERATIONS','BOM_STANDARD_OPERATIONS',l_2_ids);
1490: end if;
1491: if a_operation_tbl.COUNT > 0 then
1492: l_new_rtg_seq_id := null;
1493: OPEN c_new_rtg_seq_id(l_rtg_tbl(i).assembly_item_id,p_organization_id,p_alternate_code_to);