APPS.EAM_REQUIREMENTS_PKG dependencies on WIP_REQUIREMENT_OPERATIONS

Line 104: FROM WIP_REQUIREMENT_OPERATIONS

100: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
101:
102: CURSOR C IS
103: SELECT rowid
104: FROM WIP_REQUIREMENT_OPERATIONS
105: WHERE inventory_item_id = X_inventory_item_id
106: AND organization_id = X_organization_id
107: AND wip_entity_id = X_wip_entity_id
108: AND operation_seq_num = X_operation_seq_num;

Line 389: from WIP_REQUIREMENT_OPERATIONS

385: ,l_prev_attribute12
386: ,l_prev_attribute13
387: ,l_prev_attribute14
388: ,l_prev_attribute15
389: from WIP_REQUIREMENT_OPERATIONS
390: where wip_entity_id =X_wip_Entity_Id
391: and organization_id = X_organization_id
392: and operation_seq_num= X_Operation_Seq_Num
393: and INVENTORY_ITEM_ID = X_inventory_item_id;

Line 635: FROM WIP_REQUIREMENT_OPERATIONS

631: X_attribute15 IN VARCHAR2,
632: X_auto_request_material IN VARCHAR2) IS
633: CURSOR C IS
634: SELECT *
635: FROM WIP_REQUIREMENT_OPERATIONS
636: WHERE rowid = X_row_id
637: FOR UPDATE of Wip_Entity_Id NOWAIT;
638: Recinfo C%ROWTYPE;
639: BEGIN

Line 778: FROM WIP_REQUIREMENT_OPERATIONS

774:
775:
776: SELECT wip_entity_id, organization_id, operation_seq_num, inventory_item_id
777: INTO l_wip_entity_id, l_org_id, l_operation_seq_num, l_inventory_item_id
778: FROM WIP_REQUIREMENT_OPERATIONS
779: WHERE rowid = X_row_id;
780:
781: l_eam_mat_req_rec.header_id := l_wip_entity_id;
782: l_eam_mat_req_rec.batch_id := 1;

Line 1015: DELETE FROM WIP_REQUIREMENT_OPERATIONS

1011:
1012:
1013: /* Commented out for implementing the WO API */
1014: /*
1015: DELETE FROM WIP_REQUIREMENT_OPERATIONS
1016: WHERE wip_entity_id = p_wip_entity_id
1017: and organization_id = p_organization_id
1018: and inventory_item_id = p_inventory_item_id
1019: and operation_seq_num = p_operation_seq_num; */