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 212: from ra_customer_trx_all

208: */ -- Ended comments to redo the Project changes, 6012570
209: --Added by JMEENA for bug#8232976
210: cursor c_get_context(cp_customer_trx_id in number) is
211: select interface_header_context
212: from ra_customer_trx_all
213: where customer_trx_id = cp_customer_trx_id;
214: --End bug#8232976
215: lv_invoice_context ra_customer_trx_all.interface_header_context%type;
216: lv_projects_flag varchar2(1);

Line 215: lv_invoice_context ra_customer_trx_all.interface_header_context%type;

211: select interface_header_context
212: from ra_customer_trx_all
213: where customer_trx_id = cp_customer_trx_id;
214: --End bug#8232976
215: lv_invoice_context ra_customer_trx_all.interface_header_context%type;
216: lv_projects_flag varchar2(1);
217: lv_called_from varchar2(30);
218:
219: -- Added by Jia Li for Tax Inclusive Computations on 2007/11/30

Line 222: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;

218:
219: -- Added by Jia Li for Tax Inclusive Computations on 2007/11/30
220: ---------------------------------------------------------------
221: lv_inclu_tax_flag jai_ap_tds_years.inclusive_tax_flag%TYPE;
222: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
223:
224: CURSOR cur_separate_flag(pn_org_id IN NUMBER) IS
225: SELECT
226: nvl(ja.inclusive_tax_flag, 'N') inclusive_tax_flag

Line 236: ra_customer_trx_all

232: CURSOR cur_cust_trx_type(pn_customer_trx_id IN NUMBER) IS
233: SELECT
234: cust_trx_type_id
235: FROM
236: ra_customer_trx_all
237: WHERE customer_trx_id = pn_customer_trx_id;
238: ---------------------------------------------------------------
239:
240: /* Start, bug#6012570 (5876390)

Line 248: FROM ra_customer_trx_all trx,

244: -----------------------------------------------------------------------------------------------
245: CURSOR c_delivery(pn_customer_trx_id IN NUMBER, pn_org_id IN NUMBER)
246: IS
247: SELECT rctl.interface_line_attribute3, rctl.interface_line_attribute6
248: FROM ra_customer_trx_all trx,
249: ra_customer_trx_lines_all rctl,
250: jai_ar_trx_lines jrctl,
251: JAI_AR_TRXS jrct
252: WHERE trx.customer_trx_id = rctl.customer_trx_id

Line 371: FROM ra_customer_trx_all rcta

367: rcta.SHIP_TO_SITE_USE_ID,
368: rcta.bill_to_customer_id,
369: rcta.bill_to_site_use_id,
370: rcta.TRX_DATE
371: FROM ra_customer_trx_all rcta
372: WHERE rcta.CUSTOMER_TRX_ID = pn_customer_trx_id;
373:
374: CURSOR get_excise_inv_no_cur(pn_customer_trx_id NUMBER) IS
375: SELECT l.excise_invoice_no

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

1005: --This procedure updates the MRC data for ra_cust_trx_line_gl_dist_all, ar_payment_schedules_all,
1006: --ar_receivable_applications_all
1007: --=========================================================================================--
1008:
1009: PROCEDURE maintain_mrc( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1010: p_previous_cust_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
1011: p_called_from IN VARCHAR2,
1012: p_process_status OUT NOCOPY VARCHAR2,
1013: p_process_message OUT NOCOPY VARCHAR2)

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

1006: --ar_receivable_applications_all
1007: --=========================================================================================--
1008:
1009: PROCEDURE maintain_mrc( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1010: p_previous_cust_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
1011: p_called_from IN VARCHAR2,
1012: p_process_status OUT NOCOPY VARCHAR2,
1013: p_process_message OUT NOCOPY VARCHAR2)
1014: IS

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

1023: FROM user_procedures
1024: WHERE object_name = cp_object_name
1025: AND procedure_name = cp_procedure_name ;
1026:
1027: CURSOR cur_payment_schedule_mrc(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1028: IS
1029: SELECT payment_schedule_id
1030: FROM ar_payment_schedules_all
1031: WHERE customer_trx_id = cp_customer_trx_id;

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

1030: FROM ar_payment_schedules_all
1031: WHERE customer_trx_id = cp_customer_trx_id;
1032:
1033: --get the cust_trx_line_gl_dist_id for the REC row from ra_cust_trx_line_gl_dist_all
1034: CURSOR cur_gl_dist(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1035: IS
1036: SELECT cust_trx_line_gl_dist_id
1037: FROM ra_cust_trx_line_gl_dist_all
1038: WHERE customer_trx_id = cp_customer_trx_id

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

1146: --=========================================================================================--
1147: --This procedure maintains the history of ar_receivable_applications_all in jai_ar_rec_appl_audits
1148: --=========================================================================================--
1149:
1150: PROCEDURE maintain_applications(p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1151: p_receivable_application_id IN jai_ar_rec_appl_audits.receivable_application_id%TYPE,
1152: p_concurrent_req_num IN NUMBER,
1153: p_request_id IN NUMBER,
1154: p_operation_type IN VARCHAR2,

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

1259: --=========================================================================================--
1260: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
1261: --=========================================================================================--
1262:
1263: PROCEDURE maintain_schedules( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1264: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,
1265: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
1266: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1267: p_concurrent_req_num IN NUMBER,

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

1261: --=========================================================================================--
1262:
1263: PROCEDURE maintain_schedules( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1264: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,
1265: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
1266: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1267: p_concurrent_req_num IN NUMBER,
1268: p_request_id IN NUMBER,
1269: p_operation_type IN VARCHAR2,

Line 1266: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

1262:
1263: PROCEDURE maintain_schedules( p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1264: p_payment_schedule_id IN ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL,
1265: p_cm_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE DEFAULT NULL,
1266: p_invoice_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1267: p_concurrent_req_num IN NUMBER,
1268: p_request_id IN NUMBER,
1269: p_operation_type IN VARCHAR2,
1270: p_payment_audit_id IN OUT NOCOPY jai_ar_payment_audits.payment_audit_id%TYPE,

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

1642: END insert_ar_dist_entries;
1643:
1644:
1645:
1646: PROCEDURE delete_trx_data(p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1647: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,
1648: p_process_status OUT NOCOPY VARCHAR2,
1649: p_process_message OUT NOCOPY VARCHAR2)
1650: IS

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

1657: lv_account_class_freight VARCHAR2(10) := 'FREIGHT';
1658:
1659: --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
1660: --and account_class in ('TAX','FREIGHT')
1661: CURSOR cur_total_amt_gl_dist( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1662: IS
1663: SELECT NVL(SUM(amount),0) amount,
1664: NVL(SUM(acctd_amount),0) acctd_amount,
1665: MAX(acctd_amount) max_acctd_amount

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

1667: WHERE customer_trx_id = cp_customer_trx_id
1668: AND account_class IN (lv_account_class_tax,lv_account_class_freight);
1669:
1670: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id
1671: CURSOR cur_temp_lines_insert( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1672: cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL)
1673: IS
1674: SELECT *
1675: FROM JAI_AR_TRX_INS_LINES_T

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

1791: FROM ra_cust_trx_types_all
1792: WHERE cust_trx_type_id = cp_cust_trx_type_id;
1793:
1794: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id
1795: CURSOR cur_payment_schedule(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1796: cp_payment_Schedule_id ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL)
1797: IS
1798: SELECT payment_schedule_id,
1799: term_id,

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

1808: WHERE customer_trx_id = cp_customer_trx_id
1809: AND payment_schedule_id = NVL(cp_payment_schedule_id, payment_schedule_id);
1810:
1811: --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
1812: CURSOR cur_total_amt_trx_lines( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1813: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,
1814: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)
1815: IS
1816: SELECT NVL(SUM(extended_amount),0) extended_amount,

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

1846:
1847: --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
1848: --and account_class in ('TAX','FREIGHT')
1849:
1850: CURSOR cur_total_amt_gl_dist( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1851: IS
1852: SELECT NVL(SUM(amount),0) amount,
1853: NVL(SUM(acctd_amount),0) acctd_amount,
1854: MAX(acctd_amount) max_acctd_amount

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

1857: AND account_class IN (lv_account_class_tax,lv_account_class_freight);
1858:
1859: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id
1860: /*Bug 11936630 - Ensure only Exclusive Tax lines get interfaced to AR*/
1861: CURSOR cur_temp_lines_insert( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1862: cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL)
1863: IS
1864: SELECT *
1865: FROM JAI_AR_TRX_INS_LINES_T jatilt

Line 1880: --CURSOR cur_gl_date(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE) --Comment by Chong.Lei for POT code port

1876: ORDER BY link_to_cust_trx_line_id,
1877: customer_trx_line_id;
1878:
1879: --get the data from ra_cust_trx_line_gl_dist_all for customer_trx_id and account_class = 'REC'
1880: --CURSOR cur_gl_date(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE) --Comment by Chong.Lei for POT code port
1881: -- Added by Chong.Lei for POT code port begin
1882: CURSOR cur_gl_date(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE
1883: , cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)--Add by Xiao for POT change, reg bug#12533434
1884: -- Added by Chong.Lei for POT code port end

Line 1882: CURSOR cur_gl_date(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE

1878:
1879: --get the data from ra_cust_trx_line_gl_dist_all for customer_trx_id and account_class = 'REC'
1880: --CURSOR cur_gl_date(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE) --Comment by Chong.Lei for POT code port
1881: -- Added by Chong.Lei for POT code port begin
1882: CURSOR cur_gl_date(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE
1883: , cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)--Add by Xiao for POT change, reg bug#12533434
1884: -- Added by Chong.Lei for POT code port end
1885: IS
1886: SELECT gl_date

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

1909: WHERE set_of_books_id = cp_set_of_books_id
1910: );
1911:
1912: --get the data from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type = 'LINE'
1913: CURSOR cur_customer_trx_lines(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1914: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
1915: IS
1916: SELECT interface_line_attribute6,
1917: interface_line_attribute3,

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

1924: AND line_type = lv_line_type_line; --'LINE'
1925:
1926:
1927: --get the min(payment_schedule_id) and term_id from ar_payment_schedules_all for customer_trx_id
1928: CURSOR cur_min_payment_schedule(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1929: IS
1930: SELECT MIN(payment_schedule_id) payment_schedule_id,
1931: MIN(term_id) term_id
1932: FROM ar_payment_schedules_all

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

1932: FROM ar_payment_schedules_all
1933: WHERE customer_trx_id = cp_customer_trx_id;
1934:
1935:
1936: --get the data from ra_customer_trx_all for a customer_trx_id
1937: CURSOR cur_customer_trx(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1938: IS
1939: SELECT org_id,
1940: NVL(exchange_rate,1) exchange_rate,

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

1933: WHERE customer_trx_id = cp_customer_trx_id;
1934:
1935:
1936: --get the data from ra_customer_trx_all for a customer_trx_id
1937: CURSOR cur_customer_trx(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
1938: IS
1939: SELECT org_id,
1940: NVL(exchange_rate,1) exchange_rate,
1941: trx_number,

Line 1946: FROM ra_customer_trx_all

1942: cust_trx_type_id,
1943: created_from,
1944: set_of_books_id,
1945: previous_customer_trx_id
1946: FROM ra_customer_trx_all
1947: WHERE customer_trx_id = cp_customer_trx_id;
1948:
1949:
1950: --Lock all the rows from JAI_AR_TRX_INS_LINES_T for a customer_trx_id, which are to be processed

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

2032: and status = 'APP'
2033: AND applied_payment_Schedule_id = cp_applied_payment_Schedule_id;
2034:
2035: --Get the data from ar_payment_schedules_all for customer_trx_id
2036: CURSOR cur_prev_payment_schedule( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
2037: cp_payment_Schedule_id ar_payment_schedules_all.payment_schedule_id%TYPE DEFAULT NULL)
2038: IS
2039: SELECT amount_line_items_original,
2040: amount_line_items_remaining,

Line 2051: FROM RA_CUSTOMER_TRX_ALL

2047: AND payment_schedule_id = NVL(cp_payment_schedule_id, payment_schedule_id);
2048:
2049: CURSOR ORG_CUR IS
2050: SELECT ORG_ID, CREATED_FROM
2051: FROM RA_CUSTOMER_TRX_ALL
2052: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
2053:
2054: --added the cursor for bug#7645588
2055: CURSOR cur_event_id (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)

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

2051: FROM RA_CUSTOMER_TRX_ALL
2052: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
2053:
2054: --added the cursor for bug#7645588
2055: CURSOR cur_event_id (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
2056: IS
2057: SELECT event_id
2058: FROM ra_cust_trx_line_gl_dist_all
2059: WHERE customer_trx_id = cp_customer_trx_id

Line 2145: ln_inv_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;

2141: rec_term_details cur_term_details%ROWTYPE;
2142: rec_prev_payment_schedule cur_prev_payment_schedule%ROWTYPE;
2143:
2144: ln_previous_customer_trx_id ra_customer_trx_lines_all.previous_customer_trx_id%TYPE;
2145: ln_inv_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
2146: ln_cm_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
2147: ld_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE;
2148: ln_vat_tax_id ar_vat_tax_all.vat_tax_id%TYPE;
2149: lv_amount_includes_tax_flag ar_vat_tax_all.amount_includes_tax_flag%TYPE;

Line 2146: ln_cm_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;

2142: rec_prev_payment_schedule cur_prev_payment_schedule%ROWTYPE;
2143:
2144: ln_previous_customer_trx_id ra_customer_trx_lines_all.previous_customer_trx_id%TYPE;
2145: ln_inv_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
2146: ln_cm_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
2147: ld_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE;
2148: ln_vat_tax_id ar_vat_tax_all.vat_tax_id%TYPE;
2149: lv_amount_includes_tax_flag ar_vat_tax_all.amount_includes_tax_flag%TYPE;
2150: lv_account_Set_flag ra_cust_trx_line_gl_dist_all.account_set_flag%TYPE;

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

2187: LOOP
2188: EXIT;
2189: END LOOP;
2190:
2191: --get the data from ra_customer_trx_all for a customer_trx_id
2192: OPEN cur_customer_trx(p_customer_trx_id);
2193: FETCH cur_customer_trx INTO rec_customer_trx;
2194: CLOSE cur_customer_trx;
2195:

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

2221: END IF;
2222:
2223: --If it is CM
2224: IF ln_previous_customer_trx_id IS NOT NULL THEN
2225: --get the data from ra_customer_trx_all for the Invoice
2226: OPEN cur_customer_trx(ln_previous_customer_trx_id);
2227: FETCH cur_customer_trx INTO rec_inv_customer_trx;
2228: CLOSE cur_customer_trx;
2229:

Line 3245: FROM RA_CUSTOMER_TRX_ALL

3241: and NVL(inclusive_tax_flag,'N') = 'N'));
3242:
3243: CURSOR ORG_CUR IS
3244: SELECT ORG_ID, CREATED_FROM
3245: FROM RA_CUSTOMER_TRX_ALL
3246: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
3247:
3248:
3249: /*Bug 11936630*/

Line 3388: FROM RA_CUSTOMER_TRX_ALL

3384:
3385: CURSOR ORG_CUR_UPD IS
3386: SELECT created_from,
3387: NVL(exchange_rate,1) exchange_rate --9177024
3388: FROM RA_CUSTOMER_TRX_ALL
3389: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
3390:
3391: CURSOR check_rma_ref IS
3392: SELECT 1 from JAI_OM_OE_RMA_LINES

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

3389: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
3390:
3391: CURSOR check_rma_ref IS
3392: SELECT 1 from JAI_OM_OE_RMA_LINES
3393: WHERE TO_CHAR(RMA_NUMBER) IN (SELECT INTERFACE_HEADER_ATTRIBUTE1 FROM RA_CUSTOMER_TRX_ALL
3394: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID)
3395: AND Rma_line_id in ( Select RMA_LINE_ID from JAI_OM_OE_RMA_TAXES a,JAI_CMN_TAXES_ALL b
3396: Where a.tax_id = b.tax_id
3397: AND b.tax_type = jai_constants.tax_type_freight );

Line 3407: RA_CUSTOMER_TRX_ALL WHERE

3403: and A.tax_id = B.tax_id;
3404:
3405: CURSOR get_reason IS
3406: SELECT reason_code FROM
3407: RA_CUSTOMER_TRX_ALL WHERE
3408: CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
3409: v_reason_code ra_customer_trx_all.reason_code%TYPE;
3410: --end 12-Mar-2002
3411: v_tax_amt Number;

Line 3409: v_reason_code ra_customer_trx_all.reason_code%TYPE;

3405: CURSOR get_reason IS
3406: SELECT reason_code FROM
3407: RA_CUSTOMER_TRX_ALL WHERE
3408: CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
3409: v_reason_code ra_customer_trx_all.reason_code%TYPE;
3410: --end 12-Mar-2002
3411: v_tax_amt Number;
3412: v_err_mesg VARCHAR2(250);
3413: l_retcode NUMBER(1);

Line 3418: ra_customer_trx_all WHERE

3414: l_errbuf VARCHAR2(1996);
3415:
3416: CURSOR get_trx_num IS SELECT --21-Mar-2002 for ar tax and freight
3417: trx_number FROM
3418: ra_customer_trx_all WHERE
3419: customer_trx_id = p_customer_trx_id;
3420:
3421: --added the following cursor for bug#8476512
3422: CURSOR cur_chk_jai_tax_dtls ( cp_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,

Line 3432: v_trx_num ra_customer_trx_all.trx_number%TYPE;

3428: AND link_to_cust_trx_line_id = cp_link_to_cust_trx_line_id;
3429: ln_tax_line_exists NUMBER; --added for bug#8476512
3430:
3431:
3432: v_trx_num ra_customer_trx_all.trx_number%TYPE;
3433: v_count_trx NUMBER;
3434: V_sum_amt NUMBER;
3435:
3436: ------------------------------------------------------------------------------------------------

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

3504: ln_tax_amt NUMBER;
3505: ln_tax_acctd_amount NUMBER;
3506:
3507:
3508: CURSOR cur_total_amt_trx_lines( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
3509: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,
3510: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)
3511: IS
3512: SELECT NVL(SUM(extended_amount),0) extended_amount

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

3515: AND customer_trx_line_id = NVL(cp_customer_trx_line_id, customer_trx_line_id)
3516: AND line_type = cp_line_type;
3517:
3518:
3519: CURSOR cur_total_amt_gl_dist( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
3520: IS
3521: SELECT NVL(SUM(amount),0) amount,
3522: NVL(SUM(acctd_amount),0) acctd_amount
3523: FROM ra_cust_trx_line_gl_dist_all

Line 4564: FROM ra_customer_trx_all

4560: IS
4561: --Commented by Chong.Lei for POT code port begin
4562: /*
4563: SELECT trx_date
4564: FROM ra_customer_trx_all
4565: WHERE customer_trx_id = pn_customer_trx_id;
4566: */
4567: --Commented by Chong.Lei for POT code port end
4568: --Added by Chong.Lei for POT code port begin

Line 4657: ln_org_id ra_customer_trx_all.org_id%TYPE;

4653: , xv_process_flag OUT NOCOPY VARCHAR2
4654: , xv_process_message OUT NOCOPY VARCHAR2
4655: )
4656: IS
4657: ln_org_id ra_customer_trx_all.org_id%TYPE;
4658: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
4659: lv_inv_num ra_customer_trx_all.trx_number%TYPE;
4660: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
4661: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;

Line 4658: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;

4654: , xv_process_message OUT NOCOPY VARCHAR2
4655: )
4656: IS
4657: ln_org_id ra_customer_trx_all.org_id%TYPE;
4658: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
4659: lv_inv_num ra_customer_trx_all.trx_number%TYPE;
4660: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
4661: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
4662: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%TYPE;

Line 4659: lv_inv_num ra_customer_trx_all.trx_number%TYPE;

4655: )
4656: IS
4657: ln_org_id ra_customer_trx_all.org_id%TYPE;
4658: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
4659: lv_inv_num ra_customer_trx_all.trx_number%TYPE;
4660: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
4661: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
4662: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%TYPE;
4663: lv_currency_code jai_ar_trxs.invoice_currency_code%TYPE;

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

5108: , lv_inv_org_code -- inventory organization code
5109: , 'India Localization Entry for accounting inclusive taxes for invoice'||lv_inv_num
5110: , 'India Localization Entry' -- hard code string
5111: , 'acct_inclu_taxes' -- procedure name that makes the insert into gl_interface hard code string
5112: , 'RA_CUSTOMER_TRX_ALL' -- hard code string
5113: , 'CUSTOMER_TRX_ID' -- hard code string
5114: , pn_customer_trx_id -- value of customer_trx_id
5115: , ln_inv_org_id -- organization id of the inventory organization id
5116: );

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

5341: , lv_inv_org_code -- inventory organization code
5342: , 'India Localization Entry for accounting inclusive taxes for invoice'||lv_inv_num
5343: , 'India Localization Entry' -- hard code string
5344: , 'acct_inclu_taxes' -- procedure name that makes the insert into gl_interface hard code string
5345: , 'RA_CUSTOMER_TRX_ALL' -- hard code string
5346: , 'CUSTOMER_TRX_ID' -- hard code string
5347: , pn_customer_trx_id -- value of customer_trx_id
5348: , ln_inv_org_id -- organization id of the inventory organization id
5349: );

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

5421: , lv_inv_org_code -- inventory organization code
5422: , 'India Localization Entry for accounting inclusive taxes for invoice'||lv_inv_num
5423: , 'India Localization Entry' -- hard code string
5424: , 'acct_inclu_taxes' -- procedure name that makes the insert into gl_interface hard code string
5425: , 'RA_CUSTOMER_TRX_ALL' -- hard code string
5426: , 'CUSTOMER_TRX_ID' -- hard code string
5427: , pn_customer_trx_id -- value of customer_trx_id
5428: , ln_inv_org_id -- organization id of the inventory organization id
5429: );

Line 5473: -- This procedure is written that update the ra_customer_trx_all ct_reference column

5469: -- PROCEDURE NAME:
5470: -- update_All_Invoice_Num Private
5471: --
5472: -- DESCRIPTION:
5473: -- This procedure is written that update the ra_customer_trx_all ct_reference column
5474: -- to display the VAT/Excise/Service Invoice Number in AR
5475: --
5476: --
5477: -- ER NAME/BUG#

Line 5513: lv_reference ra_customer_trx_all.ct_reference%TYPE;

5509: )
5510: IS
5511:
5512: cv_seperator CONSTANT VARCHAR2(30) := ';';
5513: lv_reference ra_customer_trx_all.ct_reference%TYPE;
5514: lv_reference_check ra_customer_trx_all.ct_reference%TYPE;
5515: lv_procedure_name VARCHAR2(40):='display_all_invoice_num';
5516: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5517: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 5514: lv_reference_check ra_customer_trx_all.ct_reference%TYPE;

5510: IS
5511:
5512: cv_seperator CONSTANT VARCHAR2(30) := ';';
5513: lv_reference ra_customer_trx_all.ct_reference%TYPE;
5514: lv_reference_check ra_customer_trx_all.ct_reference%TYPE;
5515: lv_procedure_name VARCHAR2(40):='display_all_invoice_num';
5516: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5517: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
5518:

Line 5522: FROM ra_customer_trx_all

5518:
5519: -- check the invoice numbers are in the referece field or not
5520: CURSOR check_reference IS
5521: SELECT ct_reference
5522: FROM ra_customer_trx_all
5523: WHERE customer_trx_id = pn_customer_trx_id;
5524:
5525: BEGIN
5526: --logging for debug

Line 5645: -- update the reference column in the ra_customer_trx_all

5641:
5642:
5643: IF lv_reference IS NOT NULL
5644: THEN
5645: -- update the reference column in the ra_customer_trx_all
5646: UPDATE ra_customer_trx_all
5647: SET ct_reference = lv_reference
5648: WHERE customer_trx_id = pn_customer_trx_id;
5649: END IF; --lv_reference IS NOT NULL

Line 5646: UPDATE ra_customer_trx_all

5642:
5643: IF lv_reference IS NOT NULL
5644: THEN
5645: -- update the reference column in the ra_customer_trx_all
5646: UPDATE ra_customer_trx_all
5647: SET ct_reference = lv_reference
5648: WHERE customer_trx_id = pn_customer_trx_id;
5649: END IF; --lv_reference IS NOT NULL
5650:

Line 5665: -- This procedure is written that update the ra_customer_trx_all ct_reference column

5661: -- PROCEDURE NAME:
5662: -- Display_Vat_Invoice_No Public
5663: --
5664: -- DESCRIPTION:
5665: -- This procedure is written that update the ra_customer_trx_all ct_reference column
5666: -- to display the VAT/Excise Number in AR
5667: --
5668: -- ER NAME/BUG#
5669: -- VAT/Excise Number shown in AR transaction workbench'