APPS.WSH_CUST_MERGE dependencies on WSH_CALENDAR_ASSIGNMENTS

Line 3443: -- WSH_CALENDAR_ASSIGNMENTS

3439: --
3440: --
3441: -- Procedure : Calendar_Assignments
3442: -- Description : New code to merge customer and site information in
3443: -- WSH_CALENDAR_ASSIGNMENTS
3444: -- Usage : Called by WSH_CUST_MERGE.Merge
3445:
3446: Procedure Calendar_Assignments
3447: (

Line 3459: WSH_CALENDAR_ASSIGNMENTS.CALENDAR_ASSIGNMENT_ID%TYPE

3455: INDEX BY BINARY_INTEGER;
3456: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
3457:
3458: TYPE CALENDAR_ASSIGNMENT_ID_LIST_TY IS TABLE OF
3459: WSH_CALENDAR_ASSIGNMENTS.CALENDAR_ASSIGNMENT_ID%TYPE
3460: INDEX BY BINARY_INTEGER;
3461: PRIMARY_KEY_ID_LIST CALENDAR_ASSIGNMENT_ID_LIST_TY;
3462:
3463: TYPE customer_id_LIST_TYPE IS TABLE OF

Line 3464: WSH_CALENDAR_ASSIGNMENTS.customer_id%TYPE

3460: INDEX BY BINARY_INTEGER;
3461: PRIMARY_KEY_ID_LIST CALENDAR_ASSIGNMENT_ID_LIST_TY;
3462:
3463: TYPE customer_id_LIST_TYPE IS TABLE OF
3464: WSH_CALENDAR_ASSIGNMENTS.customer_id%TYPE
3465: INDEX BY BINARY_INTEGER;
3466: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
3467: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
3468:

Line 3470: WSH_CALENDAR_ASSIGNMENTS.customer_site_use_id%TYPE

3466: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
3467: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
3468:
3469: TYPE customer_site_use_id_LIST_TYPE IS TABLE OF
3470: WSH_CALENDAR_ASSIGNMENTS.customer_site_use_id%TYPE
3471: INDEX BY BINARY_INTEGER;
3472: NUM_COL2_ORIG_LIST customer_site_use_id_LIST_TYPE;
3473: NUM_COL2_NEW_LIST customer_site_use_id_LIST_TYPE;
3474:

Line 3481: FROM WSH_CALENDAR_ASSIGNMENTS yt, ra_customer_merges m

3477: SELECT distinct CUSTOMER_MERGE_HEADER_ID
3478: ,CALENDAR_ASSIGNMENT_ID
3479: ,yt.customer_id
3480: ,yt.customer_site_use_id
3481: FROM WSH_CALENDAR_ASSIGNMENTS yt, ra_customer_merges m
3482: WHERE (
3483: yt.customer_id = m.DUPLICATE_ID
3484: OR yt.customer_site_use_id = m.DUPLICATE_SITE_ID
3485: ) AND m.process_flag = 'N'

Line 3499: setARMessageLockTable('WSH_CALENDAR_ASSIGNMENTS');

3495: arp_message.set_line('WSH_CUST_MERGE.CALENDAR_ASSIGNMENTS()+' || getTimeStamp);
3496: END IF;
3497:
3498: IF process_mode='LOCK' THEN
3499: setARMessageLockTable('WSH_CALENDAR_ASSIGNMENTS');
3500: NULL;
3501: ELSE
3502: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3503: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_CALENDAR_ASSIGNMENTS',FALSE);

Line 3503: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_CALENDAR_ASSIGNMENTS',FALSE);

3499: setARMessageLockTable('WSH_CALENDAR_ASSIGNMENTS');
3500: NULL;
3501: ELSE
3502: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3503: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_CALENDAR_ASSIGNMENTS',FALSE);
3504: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3505: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3506:
3507: open merged_records;

Line 3544: 'WSH_CALENDAR_ASSIGNMENTS',

3540: LAST_UPDATE_LOGIN,
3541: LAST_UPDATE_DATE,
3542: LAST_UPDATED_BY
3543: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
3544: 'WSH_CALENDAR_ASSIGNMENTS',
3545: MERGE_HEADER_ID_LIST(I),
3546: PRIMARY_KEY_ID_LIST(I),
3547: NUM_COL1_ORIG_LIST(I),
3548: NUM_COL1_NEW_LIST(I),

Line 3561: UPDATE WSH_CALENDAR_ASSIGNMENTS yt SET

3557: hz_utility_pub.LAST_UPDATED_BY
3558: );
3559:
3560: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3561: UPDATE WSH_CALENDAR_ASSIGNMENTS yt SET
3562: customer_id=NUM_COL1_NEW_LIST(I)
3563: ,customer_site_use_id=NUM_COL2_NEW_LIST(I)
3564: , LAST_UPDATE_DATE=SYSDATE
3565: , last_updated_by=arp_standard.profile.user_id