DBA Data[Home] [Help]

APPS.ARP_RUN dependencies on AR_REV_REC_TYP

Line 34: arp_queue.enqueue(system.ar_rev_rec_typ(c01_rec.customer_trx_id,

30: arp_util.print_fcn_label('arp_run.enq_trans()+');
31: --
32: FOR c01_rec IN c01 LOOP
33: -- Put the message in the queue
34: arp_queue.enqueue(system.ar_rev_rec_typ(c01_rec.customer_trx_id,
35: NVL(arp_global.sysparam.org_id, 0), 'ARTERRPB', c01_rec.trx_number));
36: --
37: END LOOP;
38: --

Line 53: l_msg SYSTEM.AR_REV_REC_TYP;

49: retcode OUT NOCOPY NUMBER,
50: p_worker_number IN NUMBER,
51: p_report_mode IN VARCHAR2,
52: p_org_id IN NUMBER) AS
53: l_msg SYSTEM.AR_REV_REC_TYP;
54: l_reqid NUMBER := 0;
55: l_req_data VARCHAR2(2000);
56: --
57: l_nq_opts DBMS_AQ.ENQUEUE_OPTIONS_T;

Line 233: l_msg system.AR_REV_REC_TYP;

229: -- Variables
230:
231: l_total_workers NUMBER := LEAST(p_max_workers, MAX_WORKERS); -- total number of workers
232: l_req_data VARCHAR2(2000);
233: l_msg system.AR_REV_REC_TYP;
234: worker_error EXCEPTION;
235: l_org_id NUMBER;
236: l_max_workers NUMBER;
237: -- Functions