[Home] [Help]
151: X_Count NUMBER := 0;
152: CURSOR X_All_Dates IS
153: SELECT 'X' date_available FROM sys.dual
154: WHERE EXISTS (
155: SELECT 1 from BOM_Inventory_Components
156: WHERE Component_Item_Id = X_Member_Item_Id
157: AND Bill_Sequence_Id = X_Bill_Sequence_Id
158: AND (( RowId <> X_RowID ) or
159: (X_RowId IS NULL))
206: X_Count NUMBER := 0;
207: CURSOR X_All_Numbers IS
208: SELECT 'X' unit_available FROM sys.dual
209: WHERE EXISTS (
210: SELECT 1 from BOM_Inventory_Components
211: WHERE Component_Item_Id = X_Member_Item_Id
212: AND Bill_Sequence_Id = X_Bill_Sequence_Id
213: AND (RowId <> X_RowID
214: OR X_RowId IS NULL)
1220:
1221: CURSOR c_Op_Seq_Used IS
1222: /* Verify that the same component is not already effective */
1223: SELECT 'Already Used' op_seq_used
1224: FROM bom_inventory_components bic
1225: WHERE bic.bill_sequence_id = g_rev_comp_Unexp_rec.bill_sequence_id
1226: AND bic.component_item_id = g_rev_comp_Unexp_rec.component_item_id
1227: AND bic.operation_seq_num =
1228: decode( g_rev_component_rec.new_operation_sequence_number,
1467:
1468: item_num_for_bill number := 0;
1469: CURSOR c_ItemNum IS
1470: SELECT 'Valid'
1471: FROM BOM_inventory_components
1472: WHERE item_num = p_rev_component_rec.item_sequence_number
1473: AND bill_sequence_id = p_Rev_Comp_Unexp_rec.bill_sequence_id;
1474:
1475: l_bom_ifce_key VARCHAR2(80);
1509:
1510: l_bill_to_end_number VARCHAR2(30);
1511: CURSOR c_To_End_Item_Number IS
1512: SELECT To_End_Item_Unit_Number
1513: FROM BOM_Inventory_Components
1514: WHERE component_sequence_id =
1515: g_rev_comp_unexp_rec.old_component_sequence_id;
1516:
1517: BEGIN
2216: -- to_char(p_rev_comp_Unexp_rec.old_component_sequence_id));
2217: BEGIN
2218: SELECT 'Component Implemented'
2219: INTO l_dummy
2220: FROM bom_inventory_components
2221: WHERE component_sequence_id =
2222: p_rev_comp_Unexp_rec.old_component_sequence_id
2223: AND implementation_date IS NOT NULL;
2224:
2330: THEN
2331: BEGIN
2332: SELECT operation_seq_num
2333: INTO l_result
2334: FROM bom_inventory_components
2335: WHERE component_sequence_id =
2336: p_rev_comp_unexp_rec.old_component_sequence_id
2337: AND operation_seq_num =
2338: p_Rev_Component_rec.old_operation_sequence_number;
3586: SELECT 'Component cancelled'
3587: INTO l_dummy
3588: FROM sys.dual
3589: WHERE NOT EXISTS
3590: (SELECT 1 from bom_inventory_components
3591: WHERE component_sequence_id =
3592: p_rev_comp_Unexp_rec.component_sequence_id
3593: )
3594: AND EXISTS (SELECT 1 from eng_revised_components
3742: )
3743: IS
3744: CURSOR c_GetComponent IS
3745: SELECT revised_item_sequence_id
3746: FROM bom_inventory_components
3747: WHERE component_item_id = p_rev_comp_unexp_rec.component_item_id
3748: AND bill_sequence_id = p_rev_comp_unexp_rec.bill_sequence_id
3749: AND operation_seq_num = p_rev_component_rec.operation_sequence_number
3750: AND effectivity_date = p_rev_component_rec.start_effective_date;
3841: SELECT 1
3842: FROM sys.dual
3843: WHERE NOT EXISTS
3844: ( SELECT component_sequence_id
3845: FROM bom_inventory_components
3846: WHERE component_item_id = p_component_item_id
3847: AND bill_sequence_id = p_bill_sequence_id
3848: AND effectivity_date = p_effectivity_date
3849: AND operation_seq_num = p_operation_seq_num
3858: );
3859:
3860: CURSOR c_CheckDisabled IS
3861: SELECT component_item_id
3862: FROM bom_inventory_components
3863: WHERE component_item_id = p_component_item_id
3864: AND bill_sequence_id = p_bill_sequence_id
3865: AND effectivity_date = p_effectivity_date
3866: AND operation_seq_num = p_operation_seq_num