APPS.QP_CUST_MERGE dependencies on QP_QUALIFIERS

Line 160: | Account merge procedure for the table, QP_QUALIFIERS

156: |
157: | PROCEDURE
158: | Qualifier_Merge
159: | DESCRIPTION :
160: | Account merge procedure for the table, QP_QUALIFIERS
161: |
162: | NOTES:
163: | ******* Please delete these lines after modifications *******
164: | This account merge procedure was generated using a perl script.

Line 186: QP_QUALIFIERS.qualifier_id%TYPE

182: INDEX BY BINARY_INTEGER;
183: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
184:
185: TYPE qualifier_id_LIST_TYPE IS TABLE OF
186: QP_QUALIFIERS.qualifier_id%TYPE
187: INDEX BY BINARY_INTEGER;
188: PRIMARY_KEY_ID_LIST qualifier_id_LIST_TYPE;
189:
190: TYPE qualifier_attr_value_LIST_TYPE IS TABLE OF

Line 191: QP_QUALIFIERS.qualifier_attr_value%TYPE

187: INDEX BY BINARY_INTEGER;
188: PRIMARY_KEY_ID_LIST qualifier_id_LIST_TYPE;
189:
190: TYPE qualifier_attr_value_LIST_TYPE IS TABLE OF
191: QP_QUALIFIERS.qualifier_attr_value%TYPE
192: INDEX BY BINARY_INTEGER;
193: VCHAR_COL1_ORIG_LIST qualifier_attr_value_LIST_TYPE;
194: VCHAR_COL1_NEW_LIST qualifier_attr_value_LIST_TYPE;
195:

Line 201: QP_QUALIFIERS.qualifier_context%TYPE

197: VCHAR_COL2_ORIG_LIST qualifier_attr_value_LIST_TYPE;
198: VCHAR_COL2_NEW_LIST qualifier_attr_value_LIST_TYPE;
199:
200: TYPE qualifier_context_LIST_TYPE IS TABLE OF
201: QP_QUALIFIERS.qualifier_context%TYPE
202: INDEX BY BINARY_INTEGER;
203: QUALIFIER_CONTEXT_LIST qualifier_context_LIST_TYPE;
204:
205: TYPE qualifier_attribute_LIST_TYPE IS TABLE OF

Line 206: QP_QUALIFIERS.qualifier_attribute%TYPE

202: INDEX BY BINARY_INTEGER;
203: QUALIFIER_CONTEXT_LIST qualifier_context_LIST_TYPE;
204:
205: TYPE qualifier_attribute_LIST_TYPE IS TABLE OF
206: QP_QUALIFIERS.qualifier_attribute%TYPE
207: INDEX BY BINARY_INTEGER;
208: QUALIFIER_ATTRIBUTE_LIST qualifier_attribute_LIST_TYPE;
209: --End code added for bug fix 3649761
210:

Line 220: FROM QP_QUALIFIERS yt, ra_customer_merges m

216: --Added following 3 select list columns for bug fix 3649761
217: ,qualifier_attr_value
218: ,qualifier_context
219: ,qualifier_attribute
220: FROM QP_QUALIFIERS yt, ra_customer_merges m
221: WHERE
222: /* (
223: yt.qualifier_attr_value = to_char(m.DUPLICATE_SITE_ID)
224: )*/

Line 253: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','QP_QUALIFIERS',FALSE);

249: IF process_mode='LOCK' THEN
250: NULL;
251: ELSE
252: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
253: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','QP_QUALIFIERS',FALSE);
254: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
255: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
256:
257: open merged_records;

Line 317: 'QP_QUALIFIERS',

313: LAST_UPDATE_LOGIN,
314: LAST_UPDATE_DATE,
315: LAST_UPDATED_BY
316: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
317: 'QP_QUALIFIERS',
318: MERGE_HEADER_ID_LIST(I),
319: PRIMARY_KEY_ID_LIST(I),
320: VCHAR_COL1_ORIG_LIST(I),
321: VCHAR_COL1_NEW_LIST(I),

Line 335: UPDATE QP_QUALIFIERS yt SET

331: hz_utility_pub.LAST_UPDATED_BY
332: );
333:
334: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
335: UPDATE QP_QUALIFIERS yt SET
336: --Modified code for bug fix 3649761
337: qualifier_attr_value=decode(nvl(VCHAR_COL1_NEW_LIST(I),'x'), 'x',
338: VCHAR_COL2_NEW_LIST(I),
339: VCHAR_COL1_NEW_LIST(I))