APPS.WSH_CUST_MERGE dependencies on WSH_CALENDAR_ASSIGNMENTS

Line 3440: -- WSH_CALENDAR_ASSIGNMENTS

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

Line 3456: WSH_CALENDAR_ASSIGNMENTS.CALENDAR_ASSIGNMENT_ID%TYPE

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

Line 3461: WSH_CALENDAR_ASSIGNMENTS.customer_id%TYPE

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

Line 3467: WSH_CALENDAR_ASSIGNMENTS.customer_site_use_id%TYPE

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

Line 3478: FROM WSH_CALENDAR_ASSIGNMENTS yt, ra_customer_merges m

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

Line 3496: setARMessageLockTable('WSH_CALENDAR_ASSIGNMENTS');

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

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

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

Line 3541: 'WSH_CALENDAR_ASSIGNMENTS',

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

Line 3558: UPDATE WSH_CALENDAR_ASSIGNMENTS yt SET

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