APPS.MRP_RESCHEDULE_CMRO_WO_PS dependencies on AHL_REQ_SUPPLY_SCHEDULE

Line 91: /*If we already have a record in AHL_REQ_SUPPLY_SCHEDULE , for item/org/date

87: log_output(' Item Id Organization Id Requested Date Quantity ');
88: log_output('================== ==================== ==================== =========== ');
89: END IF;
90:
91: /*If we already have a record in AHL_REQ_SUPPLY_SCHEDULE , for item/org/date
92: conbination, we will add quantity to the same record.
93: If not ,we will do a insertion of new record */
94:
95:

Line 101: UPDATE AHL_REQ_SUPPLY_SCHEDULE

97: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
98: ' Processing Job/Org : ' || REL_WO_CUR_TBL(y).WIP_ENTITY_ID ||'/'||
99: REL_WO_CUR_TBL(y).ORGANIZATION_ID );
100:
101: UPDATE AHL_REQ_SUPPLY_SCHEDULE
102: set quantity = quantity + REL_WO_CUR_TBL(y).start_quantity
103: ,object_version_number = object_version_number + 1
104: where
105: inventory_item_id = REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID

Line 115: 'Insert a new record into AHL_REQ_SUPPLY_SCHEDULE');

111:
112: IF(SQL%NOTFOUND) THEN
113:
114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
115: 'Insert a new record into AHL_REQ_SUPPLY_SCHEDULE');
116:
117:
118: INSERT INTO AHL_REQ_SUPPLY_SCHEDULE(
119: inventory_item_id,

Line 118: INSERT INTO AHL_REQ_SUPPLY_SCHEDULE(

114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
115: 'Insert a new record into AHL_REQ_SUPPLY_SCHEDULE');
116:
117:
118: INSERT INTO AHL_REQ_SUPPLY_SCHEDULE(
119: inventory_item_id,
120: organization_id,
121: requested_date,
122: quantity,

Line 158: log_output ('Inserted new record into AHL_REQ_SUPPLY_SCHEDULE');

154: rpad(REL_WO_CUR_TBL(y).organization_id, 22) || ' '||
155: to_char(REL_WO_CUR_TBL(y).first_unit_start_date, 'DD-MON-YYYY hh24:mi:ss') || ' '||
156: rpad(REL_WO_CUR_TBL(y).start_quantity, 9) || ' '||
157: ' Success ');
158: log_output ('Inserted new record into AHL_REQ_SUPPLY_SCHEDULE');
159:
160: ELSE
161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
162: 'Updating existing record in AHL_REQ_SUPPLY_SCHEDULE');

Line 162: 'Updating existing record in AHL_REQ_SUPPLY_SCHEDULE');

158: log_output ('Inserted new record into AHL_REQ_SUPPLY_SCHEDULE');
159:
160: ELSE
161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
162: 'Updating existing record in AHL_REQ_SUPPLY_SCHEDULE');
163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Item_id : '||REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID);
164: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Org_id : '||REL_WO_CUR_TBL(y).organization_id);
165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Requested date : '||REL_WO_CUR_TBL(y).first_unit_start_date);
166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Quantity : '||REL_WO_CUR_TBL(y).start_quantity);

Line 175: log_output ('Updated AHL_REQ_SUPPLY_SCHEDULE, as above combination exists');

171: to_char(REL_WO_CUR_TBL(y).first_unit_start_date, 'DD-MON-YYYY hh24:mi:ss') || ' '||
172: rpad(REL_WO_CUR_TBL(y).start_quantity, 9) || ' '||
173: ' Success ');
174:
175: log_output ('Updated AHL_REQ_SUPPLY_SCHEDULE, as above combination exists');
176: log_output ('Quantity would be added up to the previous records in the table!');
177:
178: END IF;
179: