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 327: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

323: END create_request;
324:
325: /*old one*/
326: PROCEDURE validate_request_parameters (
327: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
328: p_line_credit_flag IN VARCHAR2,
329: p_line_amount IN NUMBER,
330: p_tax_amount IN NUMBER,
331: p_freight_amount IN NUMBER,

Line 387: ra_customer_trx

383: -- End SSA change
384: -- ORASHID 26-FEB-2004
385:
386: select count(*) into l_count_trx from
387: ra_customer_trx
388: where customer_trx_id = p_customer_trx_id;
389:
390: -- If customer trx is invalid
391: IF l_count_trx = 0 THEN

Line 439: ra_customer_trx ct

435: -- Checking to see if over application is allowed for transaction type
436: SELECT ctt.allow_overapplication_flag, ctt.credit_memo_type_id
437: INTO l_allow_overapplication, l_credit_memo_type_id
438: FROM ra_cust_trx_types ctt,
439: ra_customer_trx ct
440: WHERE ct.cust_trx_type_id = ctt.cust_trx_type_id
441: AND ct.customer_trx_id = p_customer_trx_id;
442:
443: IF PG_DEBUG in ('Y', 'C') THEN

Line 568: FROM ra_customer_trx_lines

564: FOR i in 1..p_cm_line_tbl.count
565: LOOP
566: SELECT count(*)
567: INTO l_count_trx
568: FROM ra_customer_trx_lines
569: WHERE customer_trx_id = p_customer_trx_id
570: AND customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
571:
572: IF l_count_trx = 0 THEN

Line 606: FROM ra_customer_trx_lines

602: END IF;
603: -- Get the extended amount for the customer_trx_line_id
604: SELECT NVL(extended_amount,0)
605: INTO l_extended_amount
606: FROM ra_customer_trx_lines
607: WHERE customer_trx_id = p_customer_trx_id
608: AND customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
609:
610: -- Get the credited amount, if any, for this customer_trx_line

Line 613: FROM ra_customer_trx_lines

609:
610: -- Get the credited amount, if any, for this customer_trx_line
611: SELECT NVL(extended_amount,0)
612: INTO l_credited_amount
613: FROM ra_customer_trx_lines
614: WHERE previous_customer_trx_id = p_customer_trx_id
615: AND previous_customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
616:
617: IF p_cm_line_tbl(i).extended_amount > (l_extended_amount - l_credited_amount) THEN

Line 640: FROM ra_customer_trx

636: arp_util.debug ('validate_request_parameters: ' || 'Validating the dispute date passed');
637: END IF;
638: IF p_dispute_date IS NOT NULL THEN
639: SELECT trx_date INTO l_trx_date
640: FROM ra_customer_trx
641: WHERE customer_trx_id = p_customer_trx_id;
642:
643: -- If dispute date is less than trxn date
644: IF trunc(l_trx_date) > trunc(p_dispute_date) THEN

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

676: -- CREDIT MEMO REQUEST PARAMETERS
677: p_request_id IN varchar2,
678: x_status_meaning OUT NOCOPY varchar2,
679: x_reason_meaning OUT NOCOPY varchar2,
680: x_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
681: x_cm_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
682: x_line_amount OUT NOCOPY ra_cm_requests.line_amount%type,
683: x_tax_amount OUT NOCOPY ra_cm_requests.tax_amount%type,
684: x_freight_amount OUT NOCOPY ra_cm_requests.freight_amount%type,

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

677: p_request_id IN varchar2,
678: x_status_meaning OUT NOCOPY varchar2,
679: x_reason_meaning OUT NOCOPY varchar2,
680: x_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
681: x_cm_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
682: x_line_amount OUT NOCOPY ra_cm_requests.line_amount%type,
683: x_tax_amount OUT NOCOPY ra_cm_requests.tax_amount%type,
684: x_freight_amount OUT NOCOPY ra_cm_requests.freight_amount%type,
685: x_line_credits_flag OUT NOCOPY varchar2,

Line 1025: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1021: END print_default_page;
1022:
1023: /*NEW ONE OVER LOADED FOR 4606558*/
1024: PROCEDURE validate_request_parameters (
1025: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1026: p_line_credit_flag IN VARCHAR2,
1027: p_line_amount IN NUMBER,
1028: p_tax_amount IN NUMBER,
1029: p_freight_amount IN NUMBER,

Line 1049: l_ct_trx ra_customer_trx%rowtype;

1045: IS
1046:
1047: -- Local Variables
1048: /*4556000*/
1049: l_ct_trx ra_customer_trx%rowtype;
1050: x_return_status VARCHAR2(1);
1051: p_desc_flex_rec arp_util.attribute_rec_type;
1052: l_copy_inv_tidff_flag VARCHAR2(1);
1053: interface_line_rec interface_line_rec_type;

Line 1086: ra_customer_trx

1082: return;
1083: END IF;
1084:
1085: select * into l_ct_trx from
1086: ra_customer_trx
1087: where customer_trx_id = p_customer_trx_id;
1088:
1089: IF p_line_credit_flag = 'Y' AND NVL(p_skip_workflow_flag,'N')='Y' THEN
1090:

Line 1163: p_desc_flex_name => 'RA_CUSTOMER_TRX_LINES',

1159: p_desc_flex_rec.attribute15:=p_cm_line_tbl(i).attribute15;
1160:
1161: arp_util.Validate_Desc_Flexfield(
1162: p_desc_flex_rec => p_desc_flex_rec,
1163: p_desc_flex_name => 'RA_CUSTOMER_TRX_LINES',
1164: p_return_status => x_return_status );
1165:
1166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1167: THEN

Line 1295: p_desc_flex_name => 'RA_CUSTOMER_TRX',

1291: END IF;
1292: IF NVL(p_skip_workflow_flag,'N')='Y' THEN
1293: arp_util.Validate_Desc_Flexfield(
1294: p_desc_flex_rec => p_desc_flex_rec,
1295: p_desc_flex_name => 'RA_CUSTOMER_TRX',
1296: p_return_status => x_return_status );
1297:
1298: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1299: THEN