APPS.OKS_HZ_MERGE_PUB dependencies on OKS_K_HEADERS_B

Line 315: OKS_K_HEADERS_B.QUOTE_TO_SITE_ID%TYPE

311: --03/15/2004
312: MERGE_HEADER_ID_LIST_QUOTE MERGE_HEADER_ID_LIST_TYPE;
313: PRIMARY_KEY_ID1_LIST_QUOTE ID_LIST_TYPE;
314: TYPE QUOTE_TO_SITE_ID_LIST_TYPE IS TABLE OF
315: OKS_K_HEADERS_B.QUOTE_TO_SITE_ID%TYPE
316: INDEX BY BINARY_INTEGER;
317: NUM_COL1_ORIG_LIST_QUOTE QUOTE_TO_SITE_ID_LIST_TYPE;
318: NUM_COL1_NEW_LIST_QUOTE QUOTE_TO_SITE_ID_LIST_TYPE;
319: TYPE OBJECT_VERSION_NUM_LIST_TYPE_Q IS TABLE OF

Line 320: OKS_K_HEADERS_B.OBJECT_VERSION_NUMBER%TYPE

316: INDEX BY BINARY_INTEGER;
317: NUM_COL1_ORIG_LIST_QUOTE QUOTE_TO_SITE_ID_LIST_TYPE;
318: NUM_COL1_NEW_LIST_QUOTE QUOTE_TO_SITE_ID_LIST_TYPE;
319: TYPE OBJECT_VERSION_NUM_LIST_TYPE_Q IS TABLE OF
320: OKS_K_HEADERS_B.OBJECT_VERSION_NUMBER%TYPE
321: INDEX BY BINARY_INTEGER;
322: NUM_COL2_ORIG_LIST_QUOTE OBJECT_VERSION_NUM_LIST_TYPE_Q;
323: NUM_COL2_NEW_LIST_QUOTE OBJECT_VERSION_NUM_LIST_TYPE_Q;
324:

Line 346: FROM OKS_K_HEADERS_B hdr, ra_customer_merges m

342: SELECT distinct CUSTOMER_MERGE_HEADER_ID
343: ,ID
344: ,QUOTE_TO_SITE_ID
345: ,OBJECT_VERSION_NUMBER
346: FROM OKS_K_HEADERS_B hdr, ra_customer_merges m
347: WHERE (
348: hdr.QUOTE_TO_SITE_ID = m.DUPLICATE_ADDRESS_ID
349: ) AND m.process_flag = 'N'
350: AND m.request_id = req_id

Line 436: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_K_HEADERS_B',FALSE);

432: arp_message.set_token('NUM_ROWS',to_char(l_count));
433:
434: --03/15/2004 added code to update quote_to_site_id
435: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
436: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_K_HEADERS_B',FALSE);
437: open merged_records_quote;
438: LOOP
439: FETCH merged_records_quote BULK COLLECT INTO
440: MERGE_HEADER_ID_LIST_QUOTE

Line 475: 'OKS_K_HEADERS_B',

471: LAST_UPDATE_LOGIN,
472: LAST_UPDATE_DATE,
473: LAST_UPDATED_BY
474: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
475: 'OKS_K_HEADERS_B',
476: MERGE_HEADER_ID_LIST_QUOTE(I),
477: PRIMARY_KEY_ID1_LIST_QUOTE(I),
478: NUM_COL1_ORIG_LIST_QUOTE(I),
479: NUM_COL1_NEW_LIST_QUOTE(I),

Line 494: UPDATE OKS_K_HEADERS_B yt SET

490:
491: END IF;
492:
493: FORALL I in 1..MERGE_HEADER_ID_LIST_QUOTE.COUNT
494: UPDATE OKS_K_HEADERS_B yt SET
495: QUOTE_TO_SITE_ID=NUM_COL1_NEW_LIST_QUOTE(I)
496: ,OBJECT_VERSION_NUMBER=NUM_COL2_NEW_LIST_QUOTE(I)
497: , LAST_UPDATE_DATE=SYSDATE
498: , last_updated_by=arp_standard.profile.user_id