APPS.MRPP_CMERGE_FCST dependencies on MRP_FORECAST_DESIGNATORS

Line 173: | Account merge procedure for the table, MRP_FORECAST_DESIGNATORS

169: |
170: | PROCEDURE
171: | MRP_FDE
172: | DESCRIPTION :
173: | Account merge procedure for the table, MRP_FORECAST_DESIGNATORS
174: |
175: | NOTES:
176: |--------------------------------------------------------------*/
177:

Line 189: MRP_FORECAST_DESIGNATORS.ORGANIZATION_ID%TYPE

185: INDEX BY BINARY_INTEGER;
186: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
187:
188: TYPE ORGANIZATION_ID_LIST_TYPE IS TABLE OF
189: MRP_FORECAST_DESIGNATORS.ORGANIZATION_ID%TYPE
190: INDEX BY BINARY_INTEGER;
191: PRIMARY_KEY1_LIST ORGANIZATION_ID_LIST_TYPE;
192:
193: TYPE FORECAST_DESIGNATOR_LIST_TYPE IS TABLE OF

Line 194: MRP_FORECAST_DESIGNATORS.FORECAST_DESIGNATOR%TYPE

190: INDEX BY BINARY_INTEGER;
191: PRIMARY_KEY1_LIST ORGANIZATION_ID_LIST_TYPE;
192:
193: TYPE FORECAST_DESIGNATOR_LIST_TYPE IS TABLE OF
194: MRP_FORECAST_DESIGNATORS.FORECAST_DESIGNATOR%TYPE
195: INDEX BY BINARY_INTEGER;
196: PRIMARY_KEY2_LIST FORECAST_DESIGNATOR_LIST_TYPE;
197:
198: TYPE customer_id_LIST_TYPE IS TABLE OF

Line 199: MRP_FORECAST_DESIGNATORS.customer_id%TYPE

195: INDEX BY BINARY_INTEGER;
196: PRIMARY_KEY2_LIST FORECAST_DESIGNATOR_LIST_TYPE;
197:
198: TYPE customer_id_LIST_TYPE IS TABLE OF
199: MRP_FORECAST_DESIGNATORS.customer_id%TYPE
200: INDEX BY BINARY_INTEGER;
201: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
202: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
203:

Line 205: MRP_FORECAST_DESIGNATORS.ship_id%TYPE

201: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
202: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
203:
204: TYPE ship_id_LIST_TYPE IS TABLE OF
205: MRP_FORECAST_DESIGNATORS.ship_id%TYPE
206: INDEX BY BINARY_INTEGER;
207: NUM_COL2_ORIG_LIST ship_id_LIST_TYPE;
208: NUM_COL2_NEW_LIST ship_id_LIST_TYPE;
209:

Line 211: MRP_FORECAST_DESIGNATORS.bill_id%TYPE

207: NUM_COL2_ORIG_LIST ship_id_LIST_TYPE;
208: NUM_COL2_NEW_LIST ship_id_LIST_TYPE;
209:
210: TYPE bill_id_LIST_TYPE IS TABLE OF
211: MRP_FORECAST_DESIGNATORS.bill_id%TYPE
212: INDEX BY BINARY_INTEGER;
213: NUM_COL3_ORIG_LIST bill_id_LIST_TYPE;
214: NUM_COL3_NEW_LIST bill_id_LIST_TYPE;
215:

Line 224: FROM MRP_FORECAST_DESIGNATORS yt, ra_customer_merges m

220: ,yt.FORECAST_DESIGNATOR
221: ,yt.customer_id
222: ,yt.ship_id
223: ,yt.bill_id
224: FROM MRP_FORECAST_DESIGNATORS yt, ra_customer_merges m
225: WHERE (
226: yt.customer_id = m.DUPLICATE_ID
227: OR yt.ship_id = m.DUPLICATE_SITE_ID
228: OR yt.bill_id = m.DUPLICATE_SITE_ID

Line 239: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_DESIGNATORS',FALSE);

235: IF process_mode='LOCK' THEN
236: NULL;
237: ELSE
238: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
239: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_DESIGNATORS',FALSE);
240: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
241: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
242:
243: open merged_records;

Line 287: 'MRP_FORECAST_DESIGNATORS',

283: LAST_UPDATE_LOGIN,
284: LAST_UPDATE_DATE,
285: LAST_UPDATED_BY
286: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
287: 'MRP_FORECAST_DESIGNATORS',
288: MERGE_HEADER_ID_LIST(I),
289: PRIMARY_KEY1_LIST(I),
290: PRIMARY_KEY2_LIST(I),
291: NUM_COL1_ORIG_LIST(I),

Line 308: UPDATE MRP_FORECAST_DESIGNATORS yt SET

304: );
305:
306: END IF;
307: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
308: UPDATE MRP_FORECAST_DESIGNATORS yt SET
309: customer_id=NUM_COL1_NEW_LIST(I)
310: ,ship_id=NUM_COL2_NEW_LIST(I)
311: ,bill_id=NUM_COL3_NEW_LIST(I)
312: , LAST_UPDATE_DATE=SYSDATE