eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CREDIT_MEMO_API_PUB dependencies on RA_CUSTOMER_TRX

Line 24: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,
23: -- credit memo request parameters
24: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
25: p_line_credit_flag IN ra_cm_requests.line_credits_flag%type,
26: p_line_amount IN NUMBER := 0 ,
27: p_tax_amount IN NUMBER := 0 ,
28: p_freight_amount IN NUMBER := 0,

Line 51: p_trx_number IN ra_customer_trx.trx_number%type DEFAULT NULL,

47: p_global_attribute_rec IN arw_cmreq_cover.pq_global_attribute_rec_type DEFAULT
48: global_attribute_rec_const,
49: p_dispute_date IN DATE DEFAULT NULL ,-- Bug 6358930
50: p_internal_comment IN VARCHAR2 DEFAULT NULL,
51: p_trx_number IN ra_customer_trx.trx_number%type DEFAULT NULL,
52: p_gl_date IN DATE DEFAULT NULL /*Bug 9536019*/
53: )
54: IS
55:

Line 70: l_trx_number ra_customer_trx.trx_number%type;

66: l_val_return_status VARCHAR2(1);
67: validation_failed EXCEPTION;
68: creation_failed EXCEPTION;
69: l_status VARCHAR2(100) := null;
70: l_trx_number ra_customer_trx.trx_number%type;
71: l_org_return_status VARCHAR2(1);
72: l_org_id NUMBER;
73:
74: BEGIN

Line 271: temp_customer_trx_id ra_customer_trx_all.customer_trx_id%type;

267:
268: IF jg_zz_ar_trx_pkg.is_reg_loc_enabled THEN
269: arp_util.debug('calling: jg_zz_ar_trx_pkg.is_reg_loc_enabled');
270: DECLARE
271: temp_customer_trx_id ra_customer_trx_all.customer_trx_id%type;
272: p_return_flag boolean;
273: p_return_code number;
274: p_return_message varchar2(1024);
275: BEGIN

Line 370: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

366: END create_request;
367:
368: /*old one*/
369: PROCEDURE validate_request_parameters (
370: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
371: p_line_credit_flag IN VARCHAR2,
372: p_line_amount IN NUMBER,
373: p_tax_amount IN NUMBER,
374: p_freight_amount IN NUMBER,

Line 430: ra_customer_trx

426: -- End SSA change
427: -- ORASHID 26-FEB-2004
428:
429: select count(*) into l_count_trx from
430: ra_customer_trx
431: where customer_trx_id = p_customer_trx_id;
432:
433: -- If customer trx is invalid
434: IF l_count_trx = 0 THEN

Line 482: ra_customer_trx ct

478: -- Checking to see if over application is allowed for transaction type
479: SELECT ctt.allow_overapplication_flag, ctt.credit_memo_type_id
480: INTO l_allow_overapplication, l_credit_memo_type_id
481: FROM ra_cust_trx_types ctt,
482: ra_customer_trx ct
483: WHERE ct.cust_trx_type_id = ctt.cust_trx_type_id
484: AND ct.customer_trx_id = p_customer_trx_id;
485:
486: IF PG_DEBUG in ('Y', 'C') THEN

Line 611: FROM ra_customer_trx_lines

607: FOR i in 1..p_cm_line_tbl.count
608: LOOP
609: SELECT count(*)
610: INTO l_count_trx
611: FROM ra_customer_trx_lines
612: WHERE customer_trx_id = p_customer_trx_id
613: AND customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
614:
615: IF l_count_trx = 0 THEN

Line 649: FROM ra_customer_trx_lines

645: END IF;
646: -- Get the extended amount for the customer_trx_line_id
647: SELECT NVL(extended_amount,0)
648: INTO l_extended_amount
649: FROM ra_customer_trx_lines
650: WHERE customer_trx_id = p_customer_trx_id
651: AND customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
652:
653: -- Get the credited amount, if any, for this customer_trx_line

Line 656: FROM ra_customer_trx_lines

652:
653: -- Get the credited amount, if any, for this customer_trx_line
654: SELECT NVL(extended_amount,0)
655: INTO l_credited_amount
656: FROM ra_customer_trx_lines
657: WHERE previous_customer_trx_id = p_customer_trx_id
658: AND previous_customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
659:
660: IF p_cm_line_tbl(i).extended_amount > (l_extended_amount - l_credited_amount) THEN

Line 683: FROM ra_customer_trx

679: arp_util.debug ( 'Validating the dispute date passed');
680: END IF;
681: IF p_dispute_date IS NOT NULL THEN
682: SELECT trx_date INTO l_trx_date
683: FROM ra_customer_trx
684: WHERE customer_trx_id = p_customer_trx_id;
685:
686: -- If dispute date is less than trxn date
687: IF trunc(l_trx_date) > trunc(p_dispute_date) THEN

Line 723: x_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,

719: -- CREDIT MEMO REQUEST PARAMETERS
720: p_request_id IN varchar2,
721: x_status_meaning OUT NOCOPY varchar2,
722: x_reason_meaning OUT NOCOPY varchar2,
723: x_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
724: x_cm_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
725: x_line_amount OUT NOCOPY ra_cm_requests.line_amount%type,
726: x_tax_amount OUT NOCOPY ra_cm_requests.tax_amount%type,
727: x_freight_amount OUT NOCOPY ra_cm_requests.freight_amount%type,

Line 724: x_cm_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,

720: p_request_id IN varchar2,
721: x_status_meaning OUT NOCOPY varchar2,
722: x_reason_meaning OUT NOCOPY varchar2,
723: x_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
724: x_cm_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
725: x_line_amount OUT NOCOPY ra_cm_requests.line_amount%type,
726: x_tax_amount OUT NOCOPY ra_cm_requests.tax_amount%type,
727: x_freight_amount OUT NOCOPY ra_cm_requests.freight_amount%type,
728: x_line_credits_flag OUT NOCOPY varchar2,

Line 1068: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1064: END print_default_page;
1065:
1066: /*NEW ONE OVER LOADED FOR 4606558*/
1067: PROCEDURE validate_request_parameters (
1068: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1069: p_line_credit_flag IN VARCHAR2,
1070: p_line_amount IN NUMBER,
1071: p_tax_amount IN NUMBER,
1072: p_freight_amount IN NUMBER,

Line 1084: p_trx_number IN ra_customer_trx.trx_number%type DEFAULT NULL,

1080: l_val_return_status OUT NOCOPY VARCHAR2,
1081: /*4556000*/
1082: p_skip_workflow_flag IN VARCHAR2,
1083: p_batch_source_name IN VARCHAR2,
1084: p_trx_number IN ra_customer_trx.trx_number%type DEFAULT NULL,
1085: p_attribute_rec IN OUT NOCOPY arw_cmreq_cover.pq_attribute_rec_type,
1086: p_interface_attribute_rec IN OUT NOCOPY arw_cmreq_cover.pq_interface_rec_type,
1087: p_global_attribute_rec IN OUT NOCOPY arw_cmreq_cover.pq_global_attribute_rec_type,
1088: p_dispute_date IN DATE DEFAULT NULL) -- Bug 6358930

Line 1093: l_ct_trx ra_customer_trx%rowtype;

1089: IS
1090:
1091: -- Local Variables
1092: /*4556000*/
1093: l_ct_trx ra_customer_trx%rowtype;
1094: x_return_status VARCHAR2(1);
1095: p_desc_flex_rec arp_util.attribute_rec_type;
1096: l_copy_inv_tidff_flag VARCHAR2(1);
1097: interface_line_rec interface_line_rec_type;

Line 1160: ra_customer_trx

1156: return;
1157: END IF;
1158:
1159: select * into l_ct_trx from
1160: ra_customer_trx
1161: where customer_trx_id = p_customer_trx_id;
1162:
1163: IF p_line_credit_flag = 'Y' AND NVL(p_skip_workflow_flag,'N')='Y' THEN
1164:

Line 1237: p_desc_flex_name => 'RA_CUSTOMER_TRX_LINES',

1233: p_desc_flex_rec.attribute15:=p_cm_line_tbl(i).attribute15;
1234:
1235: arp_util.Validate_Desc_Flexfield(
1236: p_desc_flex_rec => p_desc_flex_rec,
1237: p_desc_flex_name => 'RA_CUSTOMER_TRX_LINES',
1238: p_return_status => x_return_status );
1239:
1240: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1241: THEN

Line 1369: p_desc_flex_name => 'RA_CUSTOMER_TRX',

1365: END IF;
1366: IF NVL(p_skip_workflow_flag,'N')='Y' THEN
1367: arp_util.Validate_Desc_Flexfield(
1368: p_desc_flex_rec => p_desc_flex_rec,
1369: p_desc_flex_name => 'RA_CUSTOMER_TRX',
1370: p_return_status => x_return_status );
1371:
1372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1373: THEN