APPS.ARP_CMERGE_ARTRX dependencies on ARP_CMERGE

Line 1: PACKAGE BODY ARP_CMERGE_ARTRX as

1: PACKAGE BODY ARP_CMERGE_ARTRX as
2: /* $Header: ARPLTRXB.pls 120.15.12010000.2 2008/09/19 11:47:01 tthangav ship $ */
3:
4: /*---------------------------- PRIVATE VARIABLES ----------------------------*/
5: g_count NUMBER := 0;

Line 67: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/

63: MERGE_HEADER_ID_LIST
64: , PRIMARY_KEY_ID_LIST
65: , NUM_COL1_ORIG_LIST
66: , NUM_COL2_ORIG_LIST
67: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/
68: IF merged_records%NOTFOUND THEN
69: l_last_fetch := TRUE;
70: END IF;
71: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then

Line 198: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/

194: MERGE_HEADER_ID_LIST
195: , PRIMARY_KEY_ID_LIST
196: , NUM_COL1_ORIG_LIST
197: , NUM_COL2_ORIG_LIST
198: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/
199: IF merged_records%NOTFOUND THEN
200: l_last_fetch := TRUE;
201: END IF;
202: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then

Line 383: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/

379: , NUM_COL5_ORIG_LIST
380: , NUM_COL6_ORIG_LIST
381: , NUM_COL7_ORIG_LIST
382: , NUM_COL8_ORIG_LIST
383: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/
384: IF merged_records%NOTFOUND THEN
385: l_last_fetch := TRUE;
386: END IF;
387: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then

Line 653: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/

649: , VCHAR_COL3_ORIG_LIST
650: , VCHAR_COL4_ORIG_LIST
651: , VCHAR_COL5_ORIG_LIST
652: , VCHAR_COL6_NEW_LIST
653: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/
654: IF merged_records%NOTFOUND THEN
655: l_last_fetch := TRUE;
656: END IF;
657: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then

Line 858: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/

854: MERGE_HEADER_ID_LIST
855: , PRIMARY_KEY_ID_LIST
856: , NUM_COL1_ORIG_LIST
857: , NUM_COL2_ORIG_LIST
858: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/
859: IF merged_records%NOTFOUND THEN
860: l_last_fetch := TRUE;
861: END IF;
862: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then

Line 933: arp_message.set_line( 'ARP_CMERGE_ARTRX.MERGE()+' );

929: /*---------------------------- PUBLIC ROUTINES ------------------------------*/
930: PROCEDURE merge (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
931: BEGIN
932:
933: arp_message.set_line( 'ARP_CMERGE_ARTRX.MERGE()+' );
934:
935: ar_cr( req_id, set_num, process_mode );
936: ar_ps( req_id, set_num, process_mode );
937: ra_ct( req_id, set_num, process_mode );

Line 941: arp_message.set_line( 'ARP_CMERGE_ARTRX.MERGE()-' );

937: ra_ct( req_id, set_num, process_mode );
938: ra_int(req_id, set_num, process_mode );
939: ar_ard(req_id, set_num, process_mode );
940:
941: arp_message.set_line( 'ARP_CMERGE_ARTRX.MERGE()-' );
942:
943: EXCEPTION
944: when others then
945: raise;

Line 949: END ARP_CMERGE_ARTRX;

945: raise;
946:
947: END merge;
948:
949: END ARP_CMERGE_ARTRX;