APPS.WSH_CUST_MERGE dependencies on WSH_PICKING_BATCHES

Line 3300: -- WSH_PICKING_BATCHES

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

Line 3316: WSH_PICKING_BATCHES.BATCH_ID%TYPE

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

Line 3321: WSH_PICKING_BATCHES.customer_id%TYPE

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

Line 3331: FROM WSH_PICKING_BATCHES yt, ra_customer_merges m

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

Line 3355: setARMessageLockTable('WSH_PICKING_BATCHES');

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

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

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

Line 3396: 'WSH_PICKING_BATCHES',

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

Line 3411: UPDATE WSH_PICKING_BATCHES yt SET

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