APPS.WSH_CUST_MERGE dependencies on WSH_PICKING_RULES

Line 3596: -- WSH_PICKING_RULES

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

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

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

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

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

Line 3623: FROM WSH_PICKING_RULES yt, ra_customer_merges m

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

Line 3648: setARMessageLockTable('WSH_PICKING_RULES');

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

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

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

Line 3689: 'WSH_PICKING_RULES',

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

Line 3704: UPDATE WSH_PICKING_RULES yt SET

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