APPS.ARP_CMERGE_ARTAX dependencies on RA_TAX_EXEMPTIONS

Line 20: RA_TAX_EXEMPTIONS.TAX_EXEMPTION_ID%TYPE

16: INDEX BY BINARY_INTEGER;
17: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
18:
19: TYPE TAX_EXEMPTION_ID_LIST_TYPE IS TABLE OF
20: RA_TAX_EXEMPTIONS.TAX_EXEMPTION_ID%TYPE
21: INDEX BY BINARY_INTEGER;
22: PRIMARY_KEY_ID_LIST TAX_EXEMPTION_ID_LIST_TYPE;
23:
24: TYPE customer_id_LIST_TYPE IS TABLE OF

Line 25: RA_TAX_EXEMPTIONS.customer_id%TYPE

21: INDEX BY BINARY_INTEGER;
22: PRIMARY_KEY_ID_LIST TAX_EXEMPTION_ID_LIST_TYPE;
23:
24: TYPE customer_id_LIST_TYPE IS TABLE OF
25: RA_TAX_EXEMPTIONS.customer_id%TYPE
26: INDEX BY BINARY_INTEGER;
27: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
28: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
29:

Line 31: RA_TAX_EXEMPTIONS.site_use_id%TYPE

27: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
28: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
29:
30: TYPE site_use_id_LIST_TYPE IS TABLE OF
31: RA_TAX_EXEMPTIONS.site_use_id%TYPE
32: INDEX BY BINARY_INTEGER;
33: NUM_COL2_ORIG_LIST site_use_id_LIST_TYPE;
34: NUM_COL2_NEW_LIST site_use_id_LIST_TYPE;
35:

Line 42: FROM RA_TAX_EXEMPTIONS yt, ra_customer_merges m

38: SELECT distinct CUSTOMER_MERGE_HEADER_ID
39: ,TAX_EXEMPTION_ID
40: ,yt.customer_id
41: ,site_use_id
42: FROM RA_TAX_EXEMPTIONS yt, ra_customer_merges m
43: WHERE ( yt.customer_id = m.DUPLICATE_ID AND
44: nvl(yt.site_use_id,m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID)
45: AND m.process_flag = 'N'
46: AND m.request_id = req_id

Line 55: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_TAX_EXEMPTIONS',FALSE);

51: IF process_mode='LOCK' THEN
52: NULL;
53: ELSE
54: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
55: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_TAX_EXEMPTIONS',FALSE);
56: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
57: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
58:
59: open merged_records;

Line 96: 'RA_TAX_EXEMPTIONS',

92: LAST_UPDATE_LOGIN,
93: LAST_UPDATE_DATE,
94: LAST_UPDATED_BY
95: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
96: 'RA_TAX_EXEMPTIONS',
97: MERGE_HEADER_ID_LIST(I),
98: PRIMARY_KEY_ID_LIST(I),
99: NUM_COL1_ORIG_LIST(I),
100: NUM_COL1_NEW_LIST(I),

Line 113: UPDATE RA_TAX_EXEMPTIONS yt SET

109: hz_utility_pub.LAST_UPDATED_BY
110: );
111:
112: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
113: UPDATE RA_TAX_EXEMPTIONS yt SET
114: customer_id=NUM_COL1_NEW_LIST(I)
115: ,site_use_id=NUM_COL2_NEW_LIST(I)
116: , LAST_UPDATE_DATE=SYSDATE
117: , REQUEST_ID=req_id