APPS.CN_CUST_MERGE_PVT dependencies on CN_CUST_MERGE_INTERFACE

Line 449: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_CUST_MERGE_INTERFACE',FALSE);

445: NULL;
446: ELSE
447:
448: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
449: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_CUST_MERGE_INTERFACE',FALSE);
450:
451: Insert into CN_CUST_MERGE_INTERFACE
452: (
453: request_id

Line 451: Insert into CN_CUST_MERGE_INTERFACE

447:
448: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
449: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_CUST_MERGE_INTERFACE',FALSE);
450:
451: Insert into CN_CUST_MERGE_INTERFACE
452: (
453: request_id
454: ,set_number
455: ,process_mode

Line 501: FROM CN_CUST_MERGE_INTERFACE

497: retcode OUT nocopy NUMBER) IS
498:
499: CURSOR mergerecords IS
500: SELECT request_id,set_number,process_mode
501: FROM CN_CUST_MERGE_INTERFACE
502: WHERE STATUS='I';
503:
504: l_custmerge_profile_value VARCHAR2(1);
505: BEGIN

Line 509: UPDATE CN_CUST_MERGE_INTERFACE

505: BEGIN
506: for c1 in mergerecords loop
507: merge_customer_in_header(c1.request_id, c1.set_number, c1.process_mode);
508: merge_customer_in_api(c1.request_id, c1.set_number, c1.process_mode);
509: UPDATE CN_CUST_MERGE_INTERFACE
510: SET STATUS='C'
511: WHERE request_id=c1.request_id;
512: end loop;
513: EXCEPTION