APPS.WSH_CUST_MERGE dependencies on WSH_PICKING_BATCHES

Line 3297: -- WSH_PICKING_BATCHES

3293: --
3294: --
3295: -- Procedure : Picking_batches
3296: -- Description : New code to merge customer and site information in
3297: -- WSH_PICKING_BATCHES
3298: -- Usage : Called by WSH_CUST_MERGE.Merge
3299:
3300: Procedure Picking_batches
3301: (

Line 3313: WSH_PICKING_BATCHES.BATCH_ID%TYPE

3309: INDEX BY BINARY_INTEGER;
3310: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
3311:
3312: TYPE BATCH_ID_LIST_TYPE IS TABLE OF
3313: WSH_PICKING_BATCHES.BATCH_ID%TYPE
3314: INDEX BY BINARY_INTEGER;
3315: PRIMARY_KEY_ID_LIST BATCH_ID_LIST_TYPE;
3316:
3317: TYPE customer_id_LIST_TYPE IS TABLE OF

Line 3318: WSH_PICKING_BATCHES.customer_id%TYPE

3314: INDEX BY BINARY_INTEGER;
3315: PRIMARY_KEY_ID_LIST BATCH_ID_LIST_TYPE;
3316:
3317: TYPE customer_id_LIST_TYPE IS TABLE OF
3318: WSH_PICKING_BATCHES.customer_id%TYPE
3319: INDEX BY BINARY_INTEGER;
3320: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
3321: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
3322:

Line 3328: FROM WSH_PICKING_BATCHES yt, ra_customer_merges m

3324: CURSOR merged_records IS
3325: SELECT distinct CUSTOMER_MERGE_HEADER_ID
3326: ,BATCH_ID
3327: ,yt.customer_id
3328: FROM WSH_PICKING_BATCHES yt, ra_customer_merges m
3329: WHERE (
3330: yt.customer_id = m.DUPLICATE_ID
3331: ) AND m.process_flag = 'N'
3332: AND m.request_id = req_id

Line 3352: setARMessageLockTable('WSH_PICKING_BATCHES');

3348: IF l_debug_on THEN
3349: arp_message.set_line('WSH_CUST_MERGE.PICKING_BATCHES()+' || getTimeStamp);
3350: END IF;
3351: IF process_mode='LOCK' THEN
3352: setARMessageLockTable('WSH_PICKING_BATCHES');
3353: NULL;
3354: ELSE
3355: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3356: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_PICKING_BATCHES',FALSE);

Line 3356: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_PICKING_BATCHES',FALSE);

3352: setARMessageLockTable('WSH_PICKING_BATCHES');
3353: NULL;
3354: ELSE
3355: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3356: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_PICKING_BATCHES',FALSE);
3357: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3358: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3359:
3360: open merged_records;

Line 3393: 'WSH_PICKING_BATCHES',

3389: LAST_UPDATE_LOGIN,
3390: LAST_UPDATE_DATE,
3391: LAST_UPDATED_BY
3392: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
3393: 'WSH_PICKING_BATCHES',
3394: MERGE_HEADER_ID_LIST(I),
3395: PRIMARY_KEY_ID_LIST(I),
3396: NUM_COL1_ORIG_LIST(I),
3397: NUM_COL1_NEW_LIST(I),

Line 3408: UPDATE WSH_PICKING_BATCHES yt SET

3404: hz_utility_pub.LAST_UPDATED_BY
3405: );
3406:
3407: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3408: UPDATE WSH_PICKING_BATCHES yt SET
3409: customer_id=NUM_COL1_NEW_LIST(I)
3410: , LAST_UPDATE_DATE=SYSDATE
3411: , last_updated_by=arp_standard.profile.user_id
3412: , last_update_login=arp_standard.profile.last_update_login