[Home] [Help]
93: -- inventory_item_id, using_assembly_id, and end_assembly_id
94: --
95: SELECT COUNT(inventory_item_id)
96: INTO check_table
97: FROM mrp_end_assemblies
98: WHERE organization_id = p_org_id
99: AND compile_designator = p_compile_desig
100: AND inventory_item_id = p_item_to_peg
101: AND using_assembly_id = direct_using_assembly
109: if check_table = 0 then
110: --
111: -- No, the row does not exist, so insert the row.
112: --
113: INSERT INTO mrp_end_assemblies (organization_id,
114: compile_designator, inventory_item_id,
115: using_assembly_id, end_assembly_id, usage,
116: set_back_time, end_usage,
117: last_update_date, last_updated_by,
128: -- row with the new set back time and usage.
129: --
130: SELECT set_back_time
131: INTO old_set_back_time
132: FROM mrp_end_assemblies
133: WHERE organization_id = p_org_id
134: AND compile_designator = p_compile_desig
135: AND inventory_item_id = p_item_to_peg
136: AND using_assembly_id = direct_using_assembly
139: if cum_set_back_time > old_set_back_time then
140:
141: SELECT end_usage
142: INTO old_usage
143: FROM mrp_end_assemblies
144: WHERE organization_id = p_org_id
145: AND compile_designator = p_compile_desig
146: AND inventory_item_id = p_item_to_peg
147: AND using_assembly_id = direct_using_assembly
148: AND end_assembly_id = ea.using_assembly_item_id;
149:
150: cum_usage := cum_usage + old_usage;
151:
152: UPDATE mrp_end_assemblies
153: SET end_usage = cum_usage,
154: set_back_time = cum_set_back_time,
155: last_update_date = SYSDATE,
156: last_updated_by = var_user_id
181: -- Has end assembly pegging been previously performed for this item?
182: --
183: SELECT COUNT(*)
184: INTO count_rows
185: FROM mrp_end_assemblies
186: WHERE organization_id = p_org_id
187: AND compile_designator = p_compile_desig
188: AND inventory_item_id = p_item_to_peg
189: AND ROWNUM = 1;