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.JAI_AR_MATCH_TAX_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 42: from ra_customer_trx_all

38: */ -- Ended comments to redo the Project changes, 6012570
39: --Added by JMEENA for bug#8232976
40: cursor c_get_context(cp_customer_trx_id in number) is
41: select interface_header_context
42: from ra_customer_trx_all
43: where customer_trx_id = cp_customer_trx_id;
44: --End bug#8232976
45: lv_invoice_context ra_customer_trx_all.interface_header_context%type;
46: lv_projects_flag varchar2(1);

Line 45: lv_invoice_context ra_customer_trx_all.interface_header_context%type;

41: select interface_header_context
42: from ra_customer_trx_all
43: where customer_trx_id = cp_customer_trx_id;
44: --End bug#8232976
45: lv_invoice_context ra_customer_trx_all.interface_header_context%type;
46: lv_projects_flag varchar2(1);
47: lv_called_from varchar2(30);
48:
49: -- Added by Jia Li for Tax Inclusive Computations on 2007/11/30

Line 52: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;

48:
49: -- Added by Jia Li for Tax Inclusive Computations on 2007/11/30
50: ---------------------------------------------------------------
51: lv_inclu_tax_flag jai_ap_tds_years.inclusive_tax_flag%TYPE;
52: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
53:
54: CURSOR cur_separate_flag(pn_org_id IN NUMBER) IS
55: SELECT
56: nvl(ja.inclusive_tax_flag, 'N') inclusive_tax_flag

Line 66: ra_customer_trx_all

62: CURSOR cur_cust_trx_type(pn_customer_trx_id IN NUMBER) IS
63: SELECT
64: cust_trx_type_id
65: FROM
66: ra_customer_trx_all
67: WHERE customer_trx_id = pn_customer_trx_id;
68: ---------------------------------------------------------------
69:
70: /* Start, bug#6012570 (5876390)

Line 447: PROCEDURE maintain_mrc( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

443: --This procedure updates the MRC data for ra_cust_trx_line_gl_dist_all, ar_payment_schedules_all,
444: --ar_receivable_applications_all
445: --=========================================================================================--
446:
447: PROCEDURE maintain_mrc( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
448: p_previous_cust_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
449: p_called_from IN VARCHAR2,
450: p_process_status OUT NOCOPY VARCHAR2,
451: p_process_message OUT NOCOPY VARCHAR2)

Line 448: p_previous_cust_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,

444: --ar_receivable_applications_all
445: --=========================================================================================--
446:
447: PROCEDURE maintain_mrc( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
448: p_previous_cust_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
449: p_called_from IN VARCHAR2,
450: p_process_status OUT NOCOPY VARCHAR2,
451: p_process_message OUT NOCOPY VARCHAR2)
452: IS

Line 465: CURSOR cur_payment_schedule_mrc(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)

461: FROM user_procedures
462: WHERE object_name = cp_object_name
463: AND procedure_name = cp_procedure_name ;
464:
465: CURSOR cur_payment_schedule_mrc(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
466: IS
467: SELECT payment_schedule_id
468: FROM ar_payment_schedules_all
469: WHERE customer_trx_id = cp_customer_trx_id;

Line 472: CURSOR cur_gl_dist(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)

468: FROM ar_payment_schedules_all
469: WHERE customer_trx_id = cp_customer_trx_id;
470:
471: --get the cust_trx_line_gl_dist_id for the REC row from ra_cust_trx_line_gl_dist_all
472: CURSOR cur_gl_dist(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
473: IS
474: SELECT cust_trx_line_gl_dist_id
475: FROM ra_cust_trx_line_gl_dist_all
476: WHERE customer_trx_id = cp_customer_trx_id

Line 588: PROCEDURE maintain_applications(p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

584: --=========================================================================================--
585: --This procedure maintains the history of ar_receivable_applications_all in jai_ar_rec_appl_audits
586: --=========================================================================================--
587:
588: PROCEDURE maintain_applications(p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
589: p_receivable_application_id IN jai_ar_rec_appl_audits.receivable_application_id%TYPE,
590: p_concurrent_req_num IN NUMBER,
591: p_request_id IN NUMBER,
592: p_operation_type IN VARCHAR2,

Line 701: PROCEDURE maintain_schedules( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

697: --=========================================================================================--
698: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
699: --=========================================================================================--
700:
701: PROCEDURE maintain_schedules( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
702: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,
703: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
704: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
705: p_concurrent_req_num IN NUMBER,

Line 703: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,

699: --=========================================================================================--
700:
701: PROCEDURE maintain_schedules( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
702: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,
703: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
704: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
705: p_concurrent_req_num IN NUMBER,
706: p_request_id IN NUMBER,
707: p_operation_type IN VARCHAR2,

Line 704: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

700:
701: PROCEDURE maintain_schedules( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
702: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,
703: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
704: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
705: p_concurrent_req_num IN NUMBER,
706: p_request_id IN NUMBER,
707: p_operation_type IN VARCHAR2,
708: p_payment_audit_id IN OUT NOCOPY jai_ar_payment_audits.payment_audit_id%TYPE,

Line 1045: PROCEDURE delete_trx_data(p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

1041: p_process_message := SUBSTR(SQLERRM,1,300);
1042: END insert_trx_lines;
1043:
1044:
1045: PROCEDURE delete_trx_data(p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1046: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,
1047: p_process_status OUT NOCOPY VARCHAR2,
1048: p_process_message OUT NOCOPY VARCHAR2)
1049: IS

Line 1060: CURSOR cur_total_amt_gl_dist( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)

1056: lv_account_class_freight VARCHAR2(10) := 'FREIGHT';
1057:
1058: --get the sum of amount, acctd_amount and max of acctd_amount from ra_cust_trx_line_gl_dist_all for cp_customer_trx_id
1059: --and account_class in ('TAX','FREIGHT')
1060: CURSOR cur_total_amt_gl_dist( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1061: IS
1062: SELECT NVL(SUM(amount),0) amount,
1063: NVL(SUM(acctd_amount),0) acctd_amount,
1064: MAX(acctd_amount) max_acctd_amount

Line 1070: CURSOR cur_temp_lines_insert( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,

1066: WHERE customer_trx_id = cp_customer_trx_id
1067: AND account_class IN (lv_account_class_tax,lv_account_class_freight);
1068:
1069: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id
1070: CURSOR cur_temp_lines_insert( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1071: cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL)
1072: IS
1073: SELECT *
1074: FROM JAI_AR_TRX_INS_LINES_T

Line 1194: CURSOR cur_payment_schedule(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,

1190: FROM ra_cust_trx_types_all
1191: WHERE cust_trx_type_id = cp_cust_trx_type_id;
1192:
1193: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id
1194: CURSOR cur_payment_schedule(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1195: cp_payment_Schedule_id ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL)
1196: IS
1197: SELECT payment_schedule_id,
1198: term_id,

Line 1211: CURSOR cur_total_amt_trx_lines( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,

1207: WHERE customer_trx_id = cp_customer_trx_id
1208: AND payment_schedule_id = NVL(cp_payment_schedule_id, payment_schedule_id);
1209:
1210: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type
1211: CURSOR cur_total_amt_trx_lines( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1212: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,
1213: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)
1214: IS
1215: SELECT NVL(SUM(extended_amount),0) extended_amount,

Line 1249: CURSOR cur_total_amt_gl_dist( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)

1245:
1246: --get the sum of amount, acctd_amount and max of acctd_amount from ra_cust_trx_line_gl_dist_all for cp_customer_trx_id
1247: --and account_class in ('TAX','FREIGHT')
1248:
1249: CURSOR cur_total_amt_gl_dist( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1250: IS
1251: SELECT NVL(SUM(amount),0) amount,
1252: NVL(SUM(acctd_amount),0) acctd_amount,
1253: MAX(acctd_amount) max_acctd_amount

Line 1259: CURSOR cur_temp_lines_insert( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,

1255: WHERE customer_trx_id = cp_customer_trx_id
1256: AND account_class IN (lv_account_class_tax,lv_account_class_freight);
1257:
1258: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id
1259: CURSOR cur_temp_lines_insert( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1260: cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL)
1261: IS
1262: SELECT *
1263: FROM JAI_AR_TRX_INS_LINES_T

Line 1270: CURSOR cur_gl_date(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)

1266: ORDER BY link_to_cust_trx_line_id,
1267: customer_trx_line_id;
1268:
1269: --get the data from ra_cust_trx_line_gl_dist_all for customer_trx_id and account_class = 'REC'
1270: CURSOR cur_gl_date(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1271: IS
1272: SELECT gl_date
1273: FROM ra_cust_trx_line_gl_dist_all
1274: WHERE customer_trx_id = cp_customer_trx_id

Line 1291: CURSOR cur_customer_trx_lines(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,

1287: WHERE set_of_books_id = cp_set_of_books_id
1288: );
1289:
1290: --get the data from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type = 'LINE'
1291: CURSOR cur_customer_trx_lines(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1292: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
1293: IS
1294: SELECT interface_line_attribute6,
1295: interface_line_attribute3,

Line 1306: CURSOR cur_min_payment_schedule(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)

1302: AND line_type = lv_line_type_line; --'LINE'
1303:
1304:
1305: --get the min(payment_schedule_id) and term_id from ar_payment_schedules_all for customer_trx_id
1306: CURSOR cur_min_payment_schedule(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1307: IS
1308: SELECT MIN(payment_schedule_id) payment_schedule_id,
1309: MIN(term_id) term_id
1310: FROM ar_payment_schedules_all

Line 1314: --get the data from ra_customer_trx_all for a customer_trx_id

1310: FROM ar_payment_schedules_all
1311: WHERE customer_trx_id = cp_customer_trx_id;
1312:
1313:
1314: --get the data from ra_customer_trx_all for a customer_trx_id
1315: CURSOR cur_customer_trx(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1316: IS
1317: SELECT org_id,
1318: NVL(exchange_rate,1) exchange_rate,

Line 1315: CURSOR cur_customer_trx(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)

1311: WHERE customer_trx_id = cp_customer_trx_id;
1312:
1313:
1314: --get the data from ra_customer_trx_all for a customer_trx_id
1315: CURSOR cur_customer_trx(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1316: IS
1317: SELECT org_id,
1318: NVL(exchange_rate,1) exchange_rate,
1319: trx_number,

Line 1324: FROM ra_customer_trx_all

1320: cust_trx_type_id,
1321: created_from,
1322: set_of_books_id,
1323: previous_customer_trx_id
1324: FROM ra_customer_trx_all
1325: WHERE customer_trx_id = cp_customer_trx_id;
1326:
1327:
1328: --Lock all the rows from JAI_AR_TRX_INS_LINES_T for a customer_trx_id, which are to be processed

Line 1414: CURSOR cur_prev_payment_schedule( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,

1410: and status = 'APP'
1411: AND applied_payment_Schedule_id = cp_applied_payment_Schedule_id;
1412:
1413: --Get the data from ar_payment_schedules_all for customer_trx_id
1414: CURSOR cur_prev_payment_schedule( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1415: cp_payment_Schedule_id ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL)
1416: IS
1417: SELECT amount_line_items_original,
1418: amount_line_items_remaining,

Line 1429: FROM RA_CUSTOMER_TRX_ALL

1425: AND payment_schedule_id = NVL(cp_payment_schedule_id, payment_schedule_id);
1426:
1427: CURSOR ORG_CUR IS
1428: SELECT ORG_ID, CREATED_FROM
1429: FROM RA_CUSTOMER_TRX_ALL
1430: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
1431:
1432: --added the cursor for bug#7645588
1433: CURSOR cur_event_id (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)

Line 1433: CURSOR cur_event_id (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)

1429: FROM RA_CUSTOMER_TRX_ALL
1430: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
1431:
1432: --added the cursor for bug#7645588
1433: CURSOR cur_event_id (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1434: IS
1435: SELECT event_id
1436: FROM ra_cust_trx_line_gl_dist_all
1437: WHERE customer_trx_id = cp_customer_trx_id

Line 1464: ln_inv_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;

1460: rec_term_details cur_term_details%ROWTYPE;
1461: rec_prev_payment_schedule cur_prev_payment_schedule%ROWTYPE;
1462:
1463: ln_previous_customer_trx_id ra_customer_trx_lines_all.previous_customer_trx_id%TYPE;
1464: ln_inv_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
1465: ln_cm_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
1466: ld_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE;
1467: ln_vat_tax_id ar_vat_tax_all.vat_tax_id%TYPE;
1468: lv_amount_includes_tax_flag ar_vat_tax_all.amount_includes_tax_flag%TYPE;

Line 1465: ln_cm_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;

1461: rec_prev_payment_schedule cur_prev_payment_schedule%ROWTYPE;
1462:
1463: ln_previous_customer_trx_id ra_customer_trx_lines_all.previous_customer_trx_id%TYPE;
1464: ln_inv_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
1465: ln_cm_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
1466: ld_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE;
1467: ln_vat_tax_id ar_vat_tax_all.vat_tax_id%TYPE;
1468: lv_amount_includes_tax_flag ar_vat_tax_all.amount_includes_tax_flag%TYPE;
1469: lv_account_Set_flag ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE;

Line 1510: --get the data from ra_customer_trx_all for a customer_trx_id

1506: LOOP
1507: EXIT;
1508: END LOOP;
1509:
1510: --get the data from ra_customer_trx_all for a customer_trx_id
1511: OPEN cur_customer_trx(p_customer_trx_id);
1512: FETCH cur_customer_trx INTO rec_customer_trx;
1513: CLOSE cur_customer_trx;
1514:

Line 1544: --get the data from ra_customer_trx_all for the Invoice

1540: END IF;
1541:
1542: --If it is CM
1543: IF ln_previous_customer_trx_id IS NOT NULL THEN
1544: --get the data from ra_customer_trx_all for the Invoice
1545: OPEN cur_customer_trx(ln_previous_customer_trx_id);
1546: FETCH cur_customer_trx INTO rec_inv_customer_trx;
1547: CLOSE cur_customer_trx;
1548:

Line 2369: FROM RA_CUSTOMER_TRX_ALL

2365: WHERE customer_trx_id = P_CUSTOMER_TRX_ID;
2366:
2367: CURSOR ORG_CUR IS
2368: SELECT ORG_ID, CREATED_FROM
2369: FROM RA_CUSTOMER_TRX_ALL
2370: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
2371:
2372: CURSOR TEMP_CUR IS
2373: SELECT EXTENDED_AMOUNT,CUSTOMER_TRX_LINE_ID,CUSTOMER_TRX_ID ,SET_OF_BOOKS_ID,

Line 2477: FROM RA_CUSTOMER_TRX_ALL

2473: v_temp_cust_trx_id Number;
2474:
2475: CURSOR ORG_CUR_UPD IS
2476: SELECT CREATED_FROM
2477: FROM RA_CUSTOMER_TRX_ALL
2478: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
2479:
2480: CURSOR check_rma_ref IS
2481: SELECT 1 from JAI_OM_OE_RMA_LINES

Line 2482: WHERE TO_CHAR(RMA_NUMBER) IN (SELECT INTERFACE_HEADER_ATTRIBUTE1 FROM RA_CUSTOMER_TRX_ALL

2478: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
2479:
2480: CURSOR check_rma_ref IS
2481: SELECT 1 from JAI_OM_OE_RMA_LINES
2482: WHERE TO_CHAR(RMA_NUMBER) IN (SELECT INTERFACE_HEADER_ATTRIBUTE1 FROM RA_CUSTOMER_TRX_ALL
2483: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID)
2484: AND Rma_line_id in ( Select RMA_LINE_ID from JAI_OM_OE_RMA_TAXES a,JAI_CMN_TAXES_ALL b
2485: Where a.tax_id = b.tax_id
2486: AND b.tax_type = jai_constants.tax_type_freight );

Line 2496: RA_CUSTOMER_TRX_ALL WHERE

2492: and A.tax_id = B.tax_id;
2493:
2494: CURSOR get_reason IS
2495: SELECT reason_code FROM
2496: RA_CUSTOMER_TRX_ALL WHERE
2497: CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
2498: v_reason_code ra_customer_trx_all.reason_code%TYPE;
2499: --end 12-Mar-2002
2500: v_tax_amt Number;

Line 2498: v_reason_code ra_customer_trx_all.reason_code%TYPE;

2494: CURSOR get_reason IS
2495: SELECT reason_code FROM
2496: RA_CUSTOMER_TRX_ALL WHERE
2497: CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
2498: v_reason_code ra_customer_trx_all.reason_code%TYPE;
2499: --end 12-Mar-2002
2500: v_tax_amt Number;
2501: v_err_mesg VARCHAR2(250);
2502: l_retcode NUMBER(1);

Line 2507: ra_customer_trx_all WHERE

2503: l_errbuf VARCHAR2(1996);
2504:
2505: CURSOR get_trx_num IS SELECT --21-Mar-2002 for ar tax and freight
2506: trx_number FROM
2507: ra_customer_trx_all WHERE
2508: customer_trx_id = p_customer_trx_id;
2509: v_trx_num ra_customer_trx_all.trx_number%TYPE;
2510: v_count_trx NUMBER;
2511: V_sum_amt NUMBER;

Line 2509: v_trx_num ra_customer_trx_all.trx_number%TYPE;

2505: CURSOR get_trx_num IS SELECT --21-Mar-2002 for ar tax and freight
2506: trx_number FROM
2507: ra_customer_trx_all WHERE
2508: customer_trx_id = p_customer_trx_id;
2509: v_trx_num ra_customer_trx_all.trx_number%TYPE;
2510: v_count_trx NUMBER;
2511: V_sum_amt NUMBER;
2512:
2513: ------------------------------------------------------------------------------------------------

Line 3470: ln_org_id ra_customer_trx_all.org_id%TYPE;

3466: , xv_process_flag OUT NOCOPY VARCHAR2
3467: , xv_process_message OUT NOCOPY VARCHAR2
3468: )
3469: IS
3470: ln_org_id ra_customer_trx_all.org_id%TYPE;
3471: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
3472: lv_inv_num ra_customer_trx_all.trx_number%TYPE;
3473: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
3474: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;

Line 3471: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;

3467: , xv_process_message OUT NOCOPY VARCHAR2
3468: )
3469: IS
3470: ln_org_id ra_customer_trx_all.org_id%TYPE;
3471: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
3472: lv_inv_num ra_customer_trx_all.trx_number%TYPE;
3473: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
3474: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
3475: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%TYPE;

Line 3472: lv_inv_num ra_customer_trx_all.trx_number%TYPE;

3468: )
3469: IS
3470: ln_org_id ra_customer_trx_all.org_id%TYPE;
3471: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
3472: lv_inv_num ra_customer_trx_all.trx_number%TYPE;
3473: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
3474: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
3475: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%TYPE;
3476: lv_currency_code jai_ar_trxs.invoice_currency_code%TYPE;

Line 3644: , 'RA_CUSTOMER_TRX_ALL' -- hard code string

3640: , lv_inv_org_code -- inventory organization code
3641: , 'India Localization Entry for accounting inclusive taxes for invoice'||lv_inv_num
3642: , 'India Localization Entry' -- hard code string
3643: , 'acct_inclu_taxes' -- procedure name that makes the insert into gl_interface hard code string
3644: , 'RA_CUSTOMER_TRX_ALL' -- hard code string
3645: , 'CUSTOMER_TRX_ID' -- hard code string
3646: , pn_customer_trx_id -- value of customer_trx_id
3647: , ln_inv_org_id -- organization id of the inventory organization id
3648: );

Line 3706: , 'RA_CUSTOMER_TRX_ALL' -- hard code string

3702: , lv_inv_org_code -- inventory organization code
3703: , 'India Localization Entry for accounting inclusive taxes for invoice'||lv_inv_num
3704: , 'India Localization Entry' -- hard code string
3705: , 'acct_inclu_taxes' -- procedure name that makes the insert into gl_interface hard code string
3706: , 'RA_CUSTOMER_TRX_ALL' -- hard code string
3707: , 'CUSTOMER_TRX_ID' -- hard code string
3708: , pn_customer_trx_id -- value of customer_trx_id
3709: , ln_inv_org_id -- organization id of the inventory organization id
3710: );