APPS.EAM_DIRECT_ITEMS_UTILITY_PVT dependencies on WIP_EAM_DIRECT_ITEMS

Line 126: FROM wip_eam_direct_items wedi

122: ,l_eam_direct_items_rec.ATTRIBUTE12
123: ,l_eam_direct_items_rec.ATTRIBUTE13
124: ,l_eam_direct_items_rec.ATTRIBUTE14
125: ,l_eam_direct_items_rec.ATTRIBUTE15
126: FROM wip_eam_direct_items wedi
127: WHERE wedi.wip_entity_id = p_wip_entity_id
128: AND wedi.organization_id = p_organization_id
129: AND wedi.operation_seq_num = p_operation_seq_num
130: AND wedi.direct_item_sequence_id = p_direct_item_sequence_id;

Line 153: * wip_eam_direct_items table.

149: * Parameters IN : Direct Items column record
150: * Parameters OUT NOCOPY: Message Token Table
151: * Return Status
152: * Purpose : Procedure will perfrom an insert into the
153: * wip_eam_direct_items table.
154: *********************************************************************/
155:
156: PROCEDURE Insert_Row
157: ( p_eam_direct_items_rec IN EAM_PROCESS_WO_PUB.eam_direct_items_rec_type

Line 170: INSERT INTO WIP_EAM_DIRECT_ITEMS

166: BEGIN
167:
168: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Direct Items rec for ' || p_eam_direct_items_rec.direct_item_sequence_id); END IF;
169:
170: INSERT INTO WIP_EAM_DIRECT_ITEMS
171: (
172: DESCRIPTION
173: ,PURCHASING_CATEGORY_ID
174: ,DIRECT_ITEM_SEQUENCE_ID

Line 303: * wip_eam_direct_items

299: * Parameters IN : Direct Items column record
300: * Parameters OUT NOCOPY: Message Token Table
301: * Return Status
302: * Purpose : Procedure will perfrom an Update on the
303: * wip_eam_direct_items
304: *********************************************************************/
305:
306: PROCEDURE Update_Row
307: ( p_eam_direct_items_rec IN EAM_PROCESS_WO_PUB.eam_direct_items_rec_type

Line 323: FROM WIP_EAM_DIRECT_ITEMS

319: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Direct Items '|| p_eam_direct_items_rec.direct_item_sequence_id); END IF;
320:
321: SELECT required_quantity
322: INTO l_req_qty
323: FROM WIP_EAM_DIRECT_ITEMS
324: WHERE organization_id = p_eam_direct_items_rec.organization_id
325: AND wip_entity_id = p_eam_direct_items_rec.wip_entity_id
326: AND ( operation_seq_num = p_eam_direct_items_rec.operation_seq_num
327: OR operation_seq_num = 1 ) /* Added the check operation_seq_num = 1 so that op seq num can be changed if it is 1 */

Line 330: UPDATE WIP_EAM_DIRECT_ITEMS

326: AND ( operation_seq_num = p_eam_direct_items_rec.operation_seq_num
327: OR operation_seq_num = 1 ) /* Added the check operation_seq_num = 1 so that op seq num can be changed if it is 1 */
328: AND direct_item_sequence_id = p_eam_direct_items_rec.direct_item_sequence_id;
329:
330: UPDATE WIP_EAM_DIRECT_ITEMS
331: SET
332: DESCRIPTION = p_eam_direct_items_rec.DESCRIPTION
333: ,PURCHASING_CATEGORY_ID = p_eam_direct_items_rec.PURCHASING_CATEGORY_ID
334: ,Direct_Item_Sequence_Id = p_eam_direct_items_rec.Direct_Item_Sequence_Id

Line 414: * wip_eam_direct_items

410: * Parameters IN : Direct Items column record
411: * Parameters OUT NOCOPY: Message Token Table
412: * Return Status
413: * Purpose : Procedure will perfrom an Delete on the
414: * wip_eam_direct_items
415: *********************************************************************/
416:
417: PROCEDURE Delete_Row
418: ( p_eam_direct_items_rec IN EAM_PROCESS_WO_PUB.eam_direct_items_rec_type

Line 430: DELETE FROM WIP_EAM_DIRECT_ITEMS

426: BEGIN
427:
428: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Direct Items '|| p_eam_direct_items_rec.direct_item_sequence_id); END IF;
429:
430: DELETE FROM WIP_EAM_DIRECT_ITEMS
431: WHERE organization_id = p_eam_direct_items_rec.organization_id
432: AND wip_entity_id = p_eam_direct_items_rec.wip_entity_id
433: AND operation_seq_num = p_eam_direct_items_rec.operation_seq_num
434: AND direct_item_sequence_id = p_eam_direct_items_rec.direct_item_sequence_id;

Line 521: FROM wip_eam_direct_items

517: SELECT count(*) into l_count
518: FROM dual
519: WHERE exists (
520: SELECT 1
521: FROM wip_eam_direct_items
522: WHERE operation_seq_num = p_operation_seq_num
523: and wip_entity_id = p_wip_entity_id
524: and organization_id = p_organization_id
525: ) ;