APPS.JTF_TASK_CUST_MERGE_PKG dependencies on JTF_TASKS_B

Line 79: -- merge_tasks(): merge cust_account_id in jtf_tasks_b table.

75: RETURN p_acct_id;
76: END;
77:
78: ----------------------------------------------------------------------
79: -- merge_tasks(): merge cust_account_id in jtf_tasks_b table.
80: ----------------------------------------------------------------------
81: PROCEDURE merge_tasks (
82: p_request_id IN NUMBER,
83: p_set_number IN NUMBER,

Line 93: JTF_TASKS_B.task_id%TYPE

89: INDEX BY BINARY_INTEGER;
90: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
91:
92: TYPE task_id_LIST_TYPE IS TABLE OF
93: JTF_TASKS_B.task_id%TYPE
94: INDEX BY BINARY_INTEGER;
95: PRIMARY_KEY_ID_LIST task_id_LIST_TYPE;
96:
97: TYPE cust_account_id_LIST_TYPE IS TABLE OF

Line 98: JTF_TASKS_B.cust_account_id%TYPE

94: INDEX BY BINARY_INTEGER;
95: PRIMARY_KEY_ID_LIST task_id_LIST_TYPE;
96:
97: TYPE cust_account_id_LIST_TYPE IS TABLE OF
98: JTF_TASKS_B.cust_account_id%TYPE
99: INDEX BY BINARY_INTEGER;
100: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
101: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
102:

Line 107: FROM JTF_TASKS_B yt, ra_customer_merges m

103: CURSOR merged_records IS
104: SELECT distinct CUSTOMER_MERGE_HEADER_ID
105: ,task_id
106: ,cust_account_id
107: FROM JTF_TASKS_B yt, ra_customer_merges m
108: WHERE (
109: yt.cust_account_id = m.DUPLICATE_ID
110: ) AND m.process_flag = 'N'
111: AND m.request_id = p_request_id

Line 120: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_TASKS_B',FALSE);

116: IF p_process_mode='LOCK' THEN
117: NULL;
118: ELSE
119: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
120: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_TASKS_B',FALSE);
121:
122: HZ_ACCT_MERGE_UTIL.load_set(p_set_number, p_request_id);
123:
124: open merged_records;

Line 163: 'JTF_TASKS_B',

159: LAST_UPDATE_DATE,
160: LAST_UPDATED_BY
161: ) VALUES (
162: HZ_CUSTOMER_MERGE_LOG_s.nextval,
163: 'JTF_TASKS_B',
164: MERGE_HEADER_ID_LIST(I),
165: PRIMARY_KEY_ID_LIST(I),
166: NUM_COL1_ORIG_LIST(I),
167: NUM_COL1_NEW_LIST(I),

Line 180: UPDATE JTF_TASKS_B yt SET

176:
177: END IF;
178:
179: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
180: UPDATE JTF_TASKS_B yt SET
181: cust_account_id=NUM_COL1_NEW_LIST(I)
182: , LAST_UPDATE_DATE=SYSDATE
183: , last_updated_by=arp_standard.profile.user_id
184: , last_update_login=arp_standard.profile.last_update_login