APPS.JTF_IH_MERGE_PKG dependencies on JTF_IH_ACTIVITIES

Line 29: JTF_IH_ACTIVITIES.ACTIVITY_ID%TYPE

25: INDEX BY BINARY_INTEGER;
26: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
27:
28: TYPE ACTIVITY_ID_LIST_TYPE IS TABLE OF
29: JTF_IH_ACTIVITIES.ACTIVITY_ID%TYPE
30: INDEX BY BINARY_INTEGER;
31: PRIMARY_KEY_ID_LIST ACTIVITY_ID_LIST_TYPE;
32:
33: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 34: JTF_IH_ACTIVITIES.CUST_ACCOUNT_ID%TYPE

30: INDEX BY BINARY_INTEGER;
31: PRIMARY_KEY_ID_LIST ACTIVITY_ID_LIST_TYPE;
32:
33: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
34: JTF_IH_ACTIVITIES.CUST_ACCOUNT_ID%TYPE
35: INDEX BY BINARY_INTEGER;
36: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
37: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
38:

Line 44: FROM JTF_IH_ACTIVITIES yt, ra_customer_merges m

40: CURSOR merged_records IS
41: SELECT distinct CUSTOMER_MERGE_HEADER_ID
42: ,ACTIVITY_ID
43: ,CUST_ACCOUNT_ID
44: FROM JTF_IH_ACTIVITIES yt, ra_customer_merges m
45: WHERE (
46: yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
47: ) AND m.process_flag = 'N'
48: AND m.request_id = req_id

Line 57: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_IH_ACTIVITIES',FALSE);

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

Line 98: 'JTF_IH_ACTIVITIES',

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

Line 113: UPDATE JTF_IH_ACTIVITIES 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 JTF_IH_ACTIVITIES yt SET
114: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
115: , LAST_UPDATE_DATE=SYSDATE
116: , last_updated_by=arp_standard.profile.user_id
117: , last_update_login=arp_standard.profile.last_update_login