APPS.OKL_PARTY_MERGE_PUB dependencies on OKL_SUPP_INVOICE_DTLS_H

Line 5728: | Account merge procedure for the table, OKL_SUPP_INVOICE_DTLS_H

5724: /*-------------------------------------------------------------
5725: | PROCEDURE
5726: | SIDH_ACCOUNT_MERGE
5727: | DESCRIPTION :
5728: | Account merge procedure for the table, OKL_SUPP_INVOICE_DTLS_H
5729: |--------------------------------------------------------------*/
5730: PROCEDURE SIDH_ACCOUNT_MERGE (
5731: req_id NUMBER,
5732: set_num NUMBER,

Line 5741: OKL_SUPP_INVOICE_DTLS_H.ID%TYPE

5737: INDEX BY BINARY_INTEGER;
5738: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
5739:
5740: TYPE ID_LIST_TYPE IS TABLE OF
5741: OKL_SUPP_INVOICE_DTLS_H.ID%TYPE
5742: INDEX BY BINARY_INTEGER;
5743: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
5744:
5745: TYPE SHIPPING_ADDRESS_ID1_LIST_TYPE IS TABLE OF

Line 5746: OKL_SUPP_INVOICE_DTLS_H.SHIPPING_ADDRESS_ID1%TYPE

5742: INDEX BY BINARY_INTEGER;
5743: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
5744:
5745: TYPE SHIPPING_ADDRESS_ID1_LIST_TYPE IS TABLE OF
5746: OKL_SUPP_INVOICE_DTLS_H.SHIPPING_ADDRESS_ID1%TYPE
5747: INDEX BY BINARY_INTEGER;
5748: NUM_COL1_ORIG_LIST SHIPPING_ADDRESS_ID1_LIST_TYPE;
5749: NUM_COL1_NEW_LIST SHIPPING_ADDRESS_ID1_LIST_TYPE;
5750:

Line 5756: FROM OKL_SUPP_INVOICE_DTLS_H yt, ra_customer_merges m

5752: CURSOR merged_records IS
5753: SELECT distinct CUSTOMER_MERGE_HEADER_ID
5754: ,ID
5755: ,SHIPPING_ADDRESS_ID1
5756: FROM OKL_SUPP_INVOICE_DTLS_H yt, ra_customer_merges m
5757: WHERE (
5758: yt.SHIPPING_ADDRESS_ID1 = m.DUPLICATE_SITE_ID
5759: ) AND m.process_flag = 'N'
5760: AND m.request_id = req_id

Line 5769: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_SUPP_INVOICE_DTLS_H',FALSE);

5765: IF process_mode='LOCK' THEN
5766: NULL;
5767: ELSE
5768: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5769: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_SUPP_INVOICE_DTLS_H',FALSE);
5770: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5771: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5772:
5773: open merged_records;

Line 5806: 'OKL_SUPP_INVOICE_DTLS_H',

5802: LAST_UPDATE_LOGIN,
5803: LAST_UPDATE_DATE,
5804: LAST_UPDATED_BY
5805: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
5806: 'OKL_SUPP_INVOICE_DTLS_H',
5807: MERGE_HEADER_ID_LIST(I),
5808: PRIMARY_KEY_ID_LIST(I),
5809: NUM_COL1_ORIG_LIST(I),
5810: NUM_COL1_NEW_LIST(I),

Line 5821: UPDATE OKL_SUPP_INVOICE_DTLS_H yt SET

5817: hz_utility_pub.LAST_UPDATED_BY
5818: );
5819:
5820: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5821: UPDATE OKL_SUPP_INVOICE_DTLS_H yt SET
5822: SHIPPING_ADDRESS_ID1=NUM_COL1_NEW_LIST(I)
5823: , LAST_UPDATE_DATE=SYSDATE
5824: , last_updated_by=arp_standard.profile.user_id
5825: , last_update_login=arp_standard.profile.last_update_login