APPS.WSH_CUST_MERGE dependencies on WSH_PICKING_RULES

Line 3593: -- WSH_PICKING_RULES

3589: --
3590: --
3591: -- Procedure : Picking_rules
3592: -- Description : New code to merge customer and site information in
3593: -- WSH_PICKING_RULES
3594: -- Usage : Called by WSH_CUST_MERGE.Merge
3595: --
3596: -----------------------------------------------------------------------------------------
3597:

Line 3606: TYPE PICKING_RULE_ID_LIST_TYPE IS TABLE OF WSH_PICKING_RULES.PICKING_RULE_ID%TYPE

3602: TYPE MERGE_HEADER_ID_LIST_TYPE IS TABLE OF RA_CUSTOMER_MERGE_HEADERS.CUSTOMER_MERGE_HEADER_ID%TYPE
3603: INDEX BY BINARY_INTEGER;
3604: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
3605:
3606: TYPE PICKING_RULE_ID_LIST_TYPE IS TABLE OF WSH_PICKING_RULES.PICKING_RULE_ID%TYPE
3607: INDEX BY BINARY_INTEGER;
3608: PRIMARY_KEY_ID_LIST PICKING_RULE_ID_LIST_TYPE;
3609:
3610: TYPE customer_id_LIST_TYPE IS TABLE OF WSH_PICKING_RULES.customer_id%TYPE

Line 3610: TYPE customer_id_LIST_TYPE IS TABLE OF WSH_PICKING_RULES.customer_id%TYPE

3606: TYPE PICKING_RULE_ID_LIST_TYPE IS TABLE OF WSH_PICKING_RULES.PICKING_RULE_ID%TYPE
3607: INDEX BY BINARY_INTEGER;
3608: PRIMARY_KEY_ID_LIST PICKING_RULE_ID_LIST_TYPE;
3609:
3610: TYPE customer_id_LIST_TYPE IS TABLE OF WSH_PICKING_RULES.customer_id%TYPE
3611: INDEX BY BINARY_INTEGER;
3612: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
3613: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
3614:

Line 3620: FROM WSH_PICKING_RULES yt, ra_customer_merges m

3616: CURSOR merged_records IS
3617: SELECT distinct CUSTOMER_MERGE_HEADER_ID
3618: ,PICKING_RULE_ID
3619: ,yt.customer_id
3620: FROM WSH_PICKING_RULES yt, ra_customer_merges m
3621: WHERE (
3622: yt.customer_id = m.DUPLICATE_ID
3623: ) AND m.process_flag = 'N'
3624: AND m.request_id = req_id

Line 3645: setARMessageLockTable('WSH_PICKING_RULES');

3641: arp_message.set_line('WSH_CUST_MERGE.PICKING_RULES()+' || getTimeStamp);
3642: END IF;
3643:
3644: IF process_mode='LOCK' THEN
3645: setARMessageLockTable('WSH_PICKING_RULES');
3646: NULL;
3647: ELSE
3648: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3649: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_PICKING_RULES',FALSE);

Line 3649: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_PICKING_RULES',FALSE);

3645: setARMessageLockTable('WSH_PICKING_RULES');
3646: NULL;
3647: ELSE
3648: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3649: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','WSH_PICKING_RULES',FALSE);
3650: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3651: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3652:
3653: open merged_records;

Line 3686: 'WSH_PICKING_RULES',

3682: LAST_UPDATE_LOGIN,
3683: LAST_UPDATE_DATE,
3684: LAST_UPDATED_BY
3685: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
3686: 'WSH_PICKING_RULES',
3687: MERGE_HEADER_ID_LIST(I),
3688: PRIMARY_KEY_ID_LIST(I),
3689: NUM_COL1_ORIG_LIST(I),
3690: NUM_COL1_NEW_LIST(I),

Line 3701: UPDATE WSH_PICKING_RULES yt SET

3697: hz_utility_pub.LAST_UPDATED_BY
3698: );
3699:
3700: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3701: UPDATE WSH_PICKING_RULES yt SET
3702: customer_id=NUM_COL1_NEW_LIST(I)
3703: , LAST_UPDATE_DATE=SYSDATE
3704: , last_updated_by=arp_standard.profile.user_id
3705: , last_update_login=arp_standard.profile.last_update_login