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.19.12020000.2 2012/07/26 03:26:31 riqi 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 403: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/

399: , NUM_COL7_ORIG_LIST
400: , NUM_COL8_ORIG_LIST
401: , NUM_COL9_ORIG_LIST
402: , NUM_COL10_ORIG_LIST
403: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/
404: IF merged_records%NOTFOUND THEN
405: l_last_fetch := TRUE;
406: END IF;
407: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then

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

584: , PRIMARY_KEY_ID_LIST
585: , NUM_COL1_ORIG_LIST
586: , NUM_COL2_ORIG_LIST
587:
588: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/
589: IF merged_records%NOTFOUND THEN
590: l_last_fetch := TRUE;
591: END IF;
592: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then

Line 725: LIMIT ARP_CMERGE.max_array_size;

721: MERGE_HEADER_ID_LIST
722: , PRIMARY_KEY_ID_LIST
723: , NUM_COL1_ORIG_LIST
724: , NUM_COL2_ORIG_LIST
725: LIMIT ARP_CMERGE.max_array_size;
726: IF merged_records%NOTFOUND THEN
727: l_last_fetch := TRUE;
728: END IF;
729: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then

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

1135: , VCHAR_COL3_ORIG_LIST
1136: , VCHAR_COL4_ORIG_LIST
1137: , VCHAR_COL5_ORIG_LIST
1138: , VCHAR_COL6_NEW_LIST
1139: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/
1140: IF merged_records%NOTFOUND THEN
1141: l_last_fetch := TRUE;
1142: END IF;
1143: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then

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

1340: MERGE_HEADER_ID_LIST
1341: , PRIMARY_KEY_ID_LIST
1342: , NUM_COL1_ORIG_LIST
1343: , NUM_COL2_ORIG_LIST
1344: LIMIT ARP_CMERGE.max_array_size;/*Additional changes for 2447449*/
1345: IF merged_records%NOTFOUND THEN
1346: l_last_fetch := TRUE;
1347: END IF;
1348: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then

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

1415: /*---------------------------- PUBLIC ROUTINES ------------------------------*/
1416: PROCEDURE merge (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
1417: BEGIN
1418:
1419: arp_message.set_line( 'ARP_CMERGE_ARTRX.MERGE()+' );
1420:
1421: ar_cr( req_id, set_num, process_mode );
1422: ar_ps( req_id, set_num, process_mode );
1423: ra_ct( req_id, set_num, process_mode );

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

1425: ra_int(req_id, set_num, process_mode );
1426: ar_ard(req_id, set_num, process_mode );
1427: ar_ra(req_id, set_num, process_mode ); -- Bug 9155869
1428:
1429: arp_message.set_line( 'ARP_CMERGE_ARTRX.MERGE()-' );
1430:
1431: EXCEPTION
1432: when others then
1433: raise;

Line 1437: END ARP_CMERGE_ARTRX;

1433: raise;
1434:
1435: END merge;
1436:
1437: END ARP_CMERGE_ARTRX;