DBA Data[Home] [Help]

APPS.ARW_CMREQ_COVER dependencies on ARP_GLOBAL

Line 103: -- Bug 2105483 : rather then calling arp_global at the start

99: -- with the url. We need to append the req_id before the url is stored in
100: -- the db
101: l_url := replace (p_url,'req_id=', 'req_id='||l_request_id);
102:
103: -- Bug 2105483 : rather then calling arp_global at the start
104: -- of the package, where it can error out NOCOPY since org_id is not yet set,
105: -- do the call right before it is needed
106: arp_global.init_global;
107:

Line 106: arp_global.init_global;

102:
103: -- Bug 2105483 : rather then calling arp_global at the start
104: -- of the package, where it can error out NOCOPY since org_id is not yet set,
105: -- do the call right before it is needed
106: arp_global.init_global;
107:
108: /*-----------------------------------------+
109: | Insert Record into Request Table |
110: +-----------------------------------------*/

Line 216: arp_global.last_update_date,

212: p_cm_reason_code,
213: p_comments,
214: 'PENDING_APPROVAL',
215: NULL,
216: arp_global.last_update_date,
217: arp_global.last_updated_by,
218: arp_global.creation_date,
219: arp_global.created_by,
220: arp_global.last_update_login,

Line 217: arp_global.last_updated_by,

213: p_comments,
214: 'PENDING_APPROVAL',
215: NULL,
216: arp_global.last_update_date,
217: arp_global.last_updated_by,
218: arp_global.creation_date,
219: arp_global.created_by,
220: arp_global.last_update_login,
221: p_transaction_url,

Line 218: arp_global.creation_date,

214: 'PENDING_APPROVAL',
215: NULL,
216: arp_global.last_update_date,
217: arp_global.last_updated_by,
218: arp_global.creation_date,
219: arp_global.created_by,
220: arp_global.last_update_login,
221: p_transaction_url,
222: p_trans_act_url,

Line 219: arp_global.created_by,

215: NULL,
216: arp_global.last_update_date,
217: arp_global.last_updated_by,
218: arp_global.creation_date,
219: arp_global.created_by,
220: arp_global.last_update_login,
221: p_transaction_url,
222: p_trans_act_url,
223: p_orig_trx_number,

Line 220: arp_global.last_update_login,

216: arp_global.last_update_date,
217: arp_global.last_updated_by,
218: arp_global.creation_date,
219: arp_global.created_by,
220: arp_global.last_update_login,
221: p_transaction_url,
222: p_trans_act_url,
223: p_orig_trx_number,
224: p_tax_ex_cert_num,

Line 371: arp_global.last_update_date,

367: VALUES
368: (l_request_id,
369: p_cm_lines_tbl(i).customer_trx_line_id,
370: p_cm_lines_tbl(i).extended_amount,
371: arp_global.last_update_date,
372: arp_global.last_updated_by,
373: arp_global.creation_date,
374: arp_global.created_by,
375: arp_global.last_update_login,

Line 372: arp_global.last_updated_by,

368: (l_request_id,
369: p_cm_lines_tbl(i).customer_trx_line_id,
370: p_cm_lines_tbl(i).extended_amount,
371: arp_global.last_update_date,
372: arp_global.last_updated_by,
373: arp_global.creation_date,
374: arp_global.created_by,
375: arp_global.last_update_login,
376: p_cm_lines_tbl(i).quantity_credited,

Line 373: arp_global.creation_date,

369: p_cm_lines_tbl(i).customer_trx_line_id,
370: p_cm_lines_tbl(i).extended_amount,
371: arp_global.last_update_date,
372: arp_global.last_updated_by,
373: arp_global.creation_date,
374: arp_global.created_by,
375: arp_global.last_update_login,
376: p_cm_lines_tbl(i).quantity_credited,
377: p_cm_lines_tbl(i).price,

Line 374: arp_global.created_by,

370: p_cm_lines_tbl(i).extended_amount,
371: arp_global.last_update_date,
372: arp_global.last_updated_by,
373: arp_global.creation_date,
374: arp_global.created_by,
375: arp_global.last_update_login,
376: p_cm_lines_tbl(i).quantity_credited,
377: p_cm_lines_tbl(i).price,
378: arp_standard.sysparm.org_id,

Line 375: arp_global.last_update_login,

371: arp_global.last_update_date,
372: arp_global.last_updated_by,
373: arp_global.creation_date,
374: arp_global.created_by,
375: arp_global.last_update_login,
376: p_cm_lines_tbl(i).quantity_credited,
377: p_cm_lines_tbl(i).price,
378: arp_standard.sysparm.org_id,
379: p_cm_lines_tbl(i).INTERFACE_LINE_CONTEXT,

Line 471: ps_rec.dispute_date := arp_global.last_update_date;

467: ELSIF p_dispute_date IS NULL AND
468: (ps_rec.dispute_date IS NULL OR
469: NVL(ps_rec.dispute_date,trunc(sysdate)) <= trunc(sysdate))
470: THEN
471: ps_rec.dispute_date := arp_global.last_update_date;
472: END IF;
473: arp_process_cutil.update_ps
474: (p_ps_id=> ps_rec.payment_schedule_id,
475: p_due_date=> ps_rec.due_date,

Line 530: last_updated_by = arp_global.last_updated_by,

526:
527: update ra_cm_requests
528: set status= DECODE(nvl(l_credit_memo_id,-99),-99,'APPROVED_PEND_COMP','COMPLETE'),
529: approval_date = SYSDATE,
530: last_updated_by = arp_global.last_updated_by,
531: last_update_date = arp_global.last_update_date,
532: last_update_login = arp_global.last_update_login
533: where request_id = l_request_id;
534:

Line 531: last_update_date = arp_global.last_update_date,

527: update ra_cm_requests
528: set status= DECODE(nvl(l_credit_memo_id,-99),-99,'APPROVED_PEND_COMP','COMPLETE'),
529: approval_date = SYSDATE,
530: last_updated_by = arp_global.last_updated_by,
531: last_update_date = arp_global.last_update_date,
532: last_update_login = arp_global.last_update_login
533: where request_id = l_request_id;
534:
535: if l_status is not null then

Line 532: last_update_login = arp_global.last_update_login

528: set status= DECODE(nvl(l_credit_memo_id,-99),-99,'APPROVED_PEND_COMP','COMPLETE'),
529: approval_date = SYSDATE,
530: last_updated_by = arp_global.last_updated_by,
531: last_update_date = arp_global.last_update_date,
532: last_update_login = arp_global.last_update_login
533: where request_id = l_request_id;
534:
535: if l_status is not null then
536: IF PG_DEBUG in ('Y', 'C') THEN

Line 656: arp_global.init_global(mo_global.GET_CURRENT_ORG_ID);

652: arp_util.debug( 'p_credit_method_installments = ' || p_credit_method_installments);
653: END IF;
654:
655: /* 5885313 - Initialize cached values in pls packages */
656: arp_global.init_global(mo_global.GET_CURRENT_ORG_ID);
657: ARP_STANDARD.INIT_STANDARD(mo_global.GET_CURRENT_ORG_ID);
658: arp_cache_util.refresh_cache;
659: /*----------------------------------------------+
660: |Get request information from CM request table|