APPS.MRP_CREATE_SCHEDULE_ISO dependencies on MRP_ORG_TRANSFER_RELEASE

Line 80: Procedure: Create_IR_ISO creates 1 IR + creates 1 ISO for the specific row in mrp_org_transfer_Release

76:
77: END MSC_RELEASE_ISO;
78:
79: /**********************************************************
80: Procedure: Create_IR_ISO creates 1 IR + creates 1 ISO for the specific row in mrp_org_transfer_Release
81: ***********************************************************/
82: PROCEDURE Create_IR_ISO( errbuf OUT NOCOPY VARCHAR2,
83: retcode OUT NOCOPY VARCHAR2,
84: p_Ireq_header_id OUT NOCOPY number,

Line 101: MRP_ORG_TRANSFER_RELEASE

97: uom_code, charge_account_id, group_code, item_revision,
98: project_id, task_id, end_item_number, load_type, firm_demand_flag,
99: ship_method, earliest_ship_date,plan_type,part_condition
100: FROM
101: MRP_ORG_TRANSFER_RELEASE
102: WHERE
103: transaction_id = l_transaction_id
104: ORDER BY src_operating_unit;
105:

Line 831: MRP_ORG_TRANSFER_RELEASE

827: CURSOR c_org_trans_rel(l_batch_id number) IS
828: SELECT
829: batch_id, transaction_id
830: FROM
831: MRP_ORG_TRANSFER_RELEASE
832: WHERE
833: batch_id = l_batch_id
834: ORDER BY src_operating_unit;
835:

Line 866: DELETE from MRP_ORG_TRANSFER_RELEASE

862: commit;
863:
864: END LOOP;
865:
866: DELETE from MRP_ORG_TRANSFER_RELEASE
867: WHERE batch_id = p_batch_id;
868: COMMIT;
869:
870: