APPS.MRPP_CMERGE_FCST dependencies on MRP_FORECAST_UPDATES

Line 343: | Account merge procedure for the table, MRP_FORECAST_UPDATES

339: |
340: | PROCEDURE
341: | MRP_FU
342: | DESCRIPTION :
343: | Account merge procedure for the table, MRP_FORECAST_UPDATES
344: |
345: | NOTES:
346: |
347: |--------------------------------------------------------------*/

Line 360: MRP_FORECAST_UPDATES.TRANSACTION_ID%TYPE

356: INDEX BY BINARY_INTEGER;
357: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
358:
359: TYPE TRANSACTION_ID_LIST_TYPE IS TABLE OF
360: MRP_FORECAST_UPDATES.TRANSACTION_ID%TYPE
361: INDEX BY BINARY_INTEGER;
362: PRIMARY_KEY_ID_LIST TRANSACTION_ID_LIST_TYPE;
363:
364: TYPE customer_id_LIST_TYPE IS TABLE OF

Line 365: MRP_FORECAST_UPDATES.customer_id%TYPE

361: INDEX BY BINARY_INTEGER;
362: PRIMARY_KEY_ID_LIST TRANSACTION_ID_LIST_TYPE;
363:
364: TYPE customer_id_LIST_TYPE IS TABLE OF
365: MRP_FORECAST_UPDATES.customer_id%TYPE
366: INDEX BY BINARY_INTEGER;
367: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
368: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
369:

Line 371: MRP_FORECAST_UPDATES.ship_id%TYPE

367: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
368: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
369:
370: TYPE ship_id_LIST_TYPE IS TABLE OF
371: MRP_FORECAST_UPDATES.ship_id%TYPE
372: INDEX BY BINARY_INTEGER;
373: NUM_COL2_ORIG_LIST ship_id_LIST_TYPE;
374: NUM_COL2_NEW_LIST ship_id_LIST_TYPE;
375:

Line 377: MRP_FORECAST_UPDATES.bill_id%TYPE

373: NUM_COL2_ORIG_LIST ship_id_LIST_TYPE;
374: NUM_COL2_NEW_LIST ship_id_LIST_TYPE;
375:
376: TYPE bill_id_LIST_TYPE IS TABLE OF
377: MRP_FORECAST_UPDATES.bill_id%TYPE
378: INDEX BY BINARY_INTEGER;
379: NUM_COL3_ORIG_LIST bill_id_LIST_TYPE;
380: NUM_COL3_NEW_LIST bill_id_LIST_TYPE;
381:

Line 389: FROM MRP_FORECAST_UPDATES yt, ra_customer_merges m

385: ,yt.TRANSACTION_ID
386: ,yt.customer_id
387: ,yt.ship_id
388: ,yt.bill_id
389: FROM MRP_FORECAST_UPDATES yt, ra_customer_merges m
390: WHERE (
391: yt.customer_id = m.DUPLICATE_ID
392: OR yt.ship_id = m.DUPLICATE_SITE_ID
393: OR yt.bill_id = m.DUPLICATE_SITE_ID

Line 404: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_UPDATES',FALSE);

400: IF process_mode='LOCK' THEN
401: NULL;
402: ELSE
403: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
404: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_UPDATES',FALSE);
405: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
406: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
407:
408: open merged_records;

Line 450: 'MRP_FORECAST_UPDATES',

446: LAST_UPDATE_LOGIN,
447: LAST_UPDATE_DATE,
448: LAST_UPDATED_BY
449: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
450: 'MRP_FORECAST_UPDATES',
451: MERGE_HEADER_ID_LIST(I),
452: PRIMARY_KEY_ID_LIST(I),
453: NUM_COL1_ORIG_LIST(I),
454: NUM_COL1_NEW_LIST(I),

Line 470: UPDATE MRP_FORECAST_UPDATES yt SET

466: );
467:
468: END IF;
469: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
470: UPDATE MRP_FORECAST_UPDATES yt SET
471: customer_id=NUM_COL1_NEW_LIST(I)
472: ,ship_id=NUM_COL2_NEW_LIST(I)
473: ,bill_id=NUM_COL3_NEW_LIST(I)
474: , LAST_UPDATE_DATE=SYSDATE