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_OPEN_API_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 1210: FROM RA_CUSTOMER_TRX_ALL

1206: CURSOR get_ar_status_cur
1207: IS
1208: SELECT
1209: COMPLETE_FLAG
1210: FROM RA_CUSTOMER_TRX_ALL
1211: WHERE CUSTOMER_TRX_ID = pn_trx_id;
1212:
1213: CURSOR get_ap_info_cur
1214: IS

Line 1429: FROM RA_CUSTOMER_TRX_ALL trx,

1425: IS
1426: SELECT
1427: trx.set_of_books_id ,
1428: dis.gl_date
1429: FROM RA_CUSTOMER_TRX_ALL trx,
1430: RA_CUST_TRX_LINE_GL_DIST_ALL dis
1431: WHERE trx.customer_trx_id = dis.customer_trx_id
1432: AND trx.CUSTOMER_TRX_ID = pn_trx_id
1433: AND dis.ACCOUNT_CLASS = 'REC'

Line 3435: FROM ra_customer_trx_all head, ra_customer_trx_lines_all line

3431: SELECT 'Y'
3432: INTO lv_import_flag
3433: FROM dual
3434: WHERE EXISTS (SELECT 1
3435: FROM ra_customer_trx_all head, ra_customer_trx_lines_all line
3436: WHERE line.customer_trx_id = pn_trx_id
3437: AND line.customer_trx_line_id = pn_trx_line_id
3438: AND head.customer_trx_id = line.customer_trx_id
3439: AND head.createD_from = 'RAXTRX'

Line 3812: CURSOR bind_cur(cn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE)

3808: pn_internal_trx_line_id IN JAI_INTERFACE_LINES_ALL.INTERNAL_TRX_LINE_ID%TYPE,
3809: xn_tax_category_id OUT NOCOPY NUMBER
3810: )IS
3811: --Cursor define here
3812: CURSOR bind_cur(cn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE)
3813: IS
3814: SELECT A.org_id,A.bill_to_customer_id,NVL(A.bill_to_site_use_id,0)
3815: FROM RA_CUSTOMER_TRX_ALL A
3816: WHERE customer_trx_id = cn_customer_trx_id;

Line 3815: FROM RA_CUSTOMER_TRX_ALL A

3811: --Cursor define here
3812: CURSOR bind_cur(cn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE)
3813: IS
3814: SELECT A.org_id,A.bill_to_customer_id,NVL(A.bill_to_site_use_id,0)
3815: FROM RA_CUSTOMER_TRX_ALL A
3816: WHERE customer_trx_id = cn_customer_trx_id;
3817:
3818: CURSOR organization_cur(cn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE)
3819: IS

Line 3818: CURSOR organization_cur(cn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE)

3814: SELECT A.org_id,A.bill_to_customer_id,NVL(A.bill_to_site_use_id,0)
3815: FROM RA_CUSTOMER_TRX_ALL A
3816: WHERE customer_trx_id = cn_customer_trx_id;
3817:
3818: CURSOR organization_cur(cn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE)
3819: IS
3820: SELECT organization_id, location_id
3821: FROM JAI_AR_TRXS
3822: WHERE customer_trx_id = cn_customer_trx_id;

Line 3829: CURSOR CREATED_FROM_CUR(cn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE)

3825: SELECT cust_acct_site_id address_id
3826: FROM hz_cust_site_uses_all A
3827: WHERE A.site_use_id = cn_ship_to_site_use_id;
3828:
3829: CURSOR CREATED_FROM_CUR(cn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE)
3830: IS
3831: SELECT created_from , trx_date
3832: FROM ra_customer_trx_all
3833: WHERE customer_trx_id = cn_customer_trx_id;

Line 3832: FROM ra_customer_trx_all

3828:
3829: CURSOR CREATED_FROM_CUR(cn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE)
3830: IS
3831: SELECT created_from , trx_date
3832: FROM ra_customer_trx_all
3833: WHERE customer_trx_id = cn_customer_trx_id;
3834:
3835: CURSOR get_inventory_item_id(cn_customer_trx_line_id IN RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE)
3836: IS

Line 3853: ld_trx_date RA_CUSTOMER_TRX_ALL.TRX_DATE%TYPE;

3849: ln_location_id NUMBER;
3850: ln_address_id NUMBER;
3851: ln_inventory_item_id NUMBER;
3852: lv_created_from Varchar2(30);
3853: ld_trx_date RA_CUSTOMER_TRX_ALL.TRX_DATE%TYPE;
3854:
3855:
3856: --FOR AP
3857: ln_vendor_id NUMBER;

Line 4030: from ra_customer_trx_all

4026: AND global_attribute20 = TO_CHAR(pn_transaction_line_num)
4027: AND customer_trx_id in
4028: (
4029: select customer_trx_id
4030: from ra_customer_trx_all
4031: where bill_to_customer_id = pn_party_id
4032: and bill_to_site_use_id = pn_party_site_id
4033: )
4034: order by 1,2

Line 5510: pn_customer_trx_id IN ra_customer_trx_all.customer_trx_id%type,

5506: ||Populate temporary table JAI_AR_TRX_INS_LINES_T
5507: */
5508: PROCEDURE populate_temp_table(
5509: pn_interface_line_id IN JAI_INTERFACE_LINES_ALL.INTERFACE_LINE_ID%TYPE,
5510: pn_customer_trx_id IN ra_customer_trx_all.customer_trx_id%type,
5511: pn_customer_trx_line_id IN jai_ar_trx_lines.customer_trx_line_id%type,
5512: pv_return_code OUT NOCOPY VARCHAR2,
5513: pv_return_message OUT NOCOPY VARCHAR2)
5514: IS

Line 5538: v_org_id ra_customer_trx_all.org_id%type;

5534: v_location_id NUMBER;
5535: v_batch_source_id NUMBER;
5536: v_register_code VARCHAR2(50);
5537:
5538: v_org_id ra_customer_trx_all.org_id%type;
5539:
5540: v_line_amount NUMBER := 0;
5541: v_quantity NUMBER;
5542: v_trans_type VARCHAR2(30);

Line 5567: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

5563: WHERE REGIME_CODE = CP_REGIME_CODE;
5564:
5565: Cursor transaction_type_cur IS
5566: Select a.type
5567: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
5568: Where a.cust_trx_type_id = b.cust_trx_type_id
5569: And b.customer_trx_id = v_customer_trx_id
5570: And NVL(a.org_id, 0) = NVL(b.org_id, 0);
5571:

Line 5577: FROM RA_CUSTOMER_TRX_ALL RCTA

5573: SELECT RCTA.org_id,
5574: RCTA.bill_to_customer_id,
5575: NVL(RCTA.bill_to_site_use_id, 0),
5576: RCTA.trx_date
5577: FROM RA_CUSTOMER_TRX_ALL RCTA
5578: WHERE RCTA.customer_trx_id = v_customer_trx_id;
5579:
5580: lv_intf_hdr_ctx ra_customer_trx_all.interface_header_context%type;
5581:

Line 5580: lv_intf_hdr_ctx ra_customer_trx_all.interface_header_context%type;

5576: RCTA.trx_date
5577: FROM RA_CUSTOMER_TRX_ALL RCTA
5578: WHERE RCTA.customer_trx_id = v_customer_trx_id;
5579:
5580: lv_intf_hdr_ctx ra_customer_trx_all.interface_header_context%type;
5581:
5582:
5583: CURSOR tax_type_cur IS
5584: SELECT a.tax_id taxid,

Line 5632: FROM JAI_AR_TRXS -- table reference was previously RA_CUSTOMER_TRX_ALL - using JA_IN_RA_CUSTOMER_TRX instead - bug# 2728636

5628: WHERE CUSTOMER_TRX_LINE_ID = pn_customer_trx_line_id;
5629:
5630: CURSOR CREATED_FROM_CUR IS
5631: SELECT created_from
5632: FROM JAI_AR_TRXS -- table reference was previously RA_CUSTOMER_TRX_ALL - using JA_IN_RA_CUSTOMER_TRX instead - bug# 2728636
5633: WHERE customer_trx_id = v_customer_trx_id;
5634:
5635: CURSOR Insert_Update_Cur(p_customer_trx_line_id IN NUMBER) IS
5636: SELECT INSERT_UPDATE_FLAG

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

6189:
6190: /*
6191: || Delete TAX OR FREIGHT LINE IN RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIS_ALL
6192: */
6193: PROCEDURE delete_trx_data(p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
6194: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,
6195: p_process_status OUT NOCOPY VARCHAR2,
6196: p_process_message OUT NOCOPY VARCHAR2) IS
6197: lv_object_name user_procedures.object_name%type;

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

6202: lv_account_class_freight VARCHAR2(10) := 'FREIGHT';
6203:
6204: --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
6205: --and account_class in ('TAX','FREIGHT')
6206: CURSOR cur_total_amt_gl_dist(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE) IS
6207: SELECT NVL(SUM(amount), 0) amount,
6208: NVL(SUM(acctd_amount), 0) acctd_amount,
6209: MAX(acctd_amount) max_acctd_amount
6210: FROM ra_cust_trx_line_gl_dist_all

Line 6216: CURSOR cur_temp_lines_insert(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE, cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL) IS

6212: AND account_class IN
6213: (lv_account_class_tax, lv_account_class_freight);
6214:
6215: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id
6216: CURSOR cur_temp_lines_insert(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE, cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL) IS
6217: SELECT *
6218: FROM JAI_AR_TRX_INS_LINES_T
6219: WHERE customer_trx_id = cp_customer_trx_id
6220: AND link_to_cust_trx_line_id =

Line 6305: pn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE,

6301: /*
6302: || Fire jai_ar_rcta_trigger_pkg.aru_t1
6303: */
6304: PROCEDURE fire_aru_t1(
6305: pn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE,
6306: ov_return_code OUT NOCOPY VARCHAR2,
6307: ov_return_message OUT NOCOPY VARCHAR2
6308: )
6309: IS

Line 6314: FROM RA_CUSTOMER_TRX_ALL

6310: --Cursor define here
6311: CURSOR get_ar_detail_cur
6312: IS
6313: SELECT *
6314: FROM RA_CUSTOMER_TRX_ALL
6315: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id;
6316: --Variable define here
6317: lv_action VARCHAR2(20) := jai_constants.updating;
6318: lv_return_message VARCHAR2(2000);

Line 6320: rec_ar_detail RA_CUSTOMER_TRX_ALL%ROWTYPE;

6316: --Variable define here
6317: lv_action VARCHAR2(20) := jai_constants.updating;
6318: lv_return_message VARCHAR2(2000);
6319: lv_return_code VARCHAR2(100) ;
6320: rec_ar_detail RA_CUSTOMER_TRX_ALL%ROWTYPE;
6321: --Main block
6322: BEGIN
6323: FOR rec_ar_detail IN get_ar_detail_cur
6324: LOOP

Line 6346: pn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE,

6342: /*
6343: || Fire jai_ar_rcta_trigger_pkg.aru_t1
6344: */
6345: PROCEDURE fire_aru_t3(
6346: pn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE,
6347: ov_return_code OUT NOCOPY VARCHAR2,
6348: ov_return_message OUT NOCOPY VARCHAR2
6349: )
6350: IS

Line 6354: FROM RA_CUSTOMER_TRX_ALL

6350: IS
6351: CURSOR get_ar_detail_cur
6352: IS
6353: SELECT *
6354: FROM RA_CUSTOMER_TRX_ALL
6355: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id;
6356:
6357: lv_action VARCHAR2(20) := jai_constants.updating;
6358: lv_return_message VARCHAR2(2000);

Line 6360: rec_ar_detail RA_CUSTOMER_TRX_ALL%ROWTYPE;

6356:
6357: lv_action VARCHAR2(20) := jai_constants.updating;
6358: lv_return_message VARCHAR2(2000);
6359: lv_return_code VARCHAR2(100) ;
6360: rec_ar_detail RA_CUSTOMER_TRX_ALL%ROWTYPE;
6361: BEGIN
6362: FOR rec_ar_detail IN get_ar_detail_cur
6363: LOOP
6364: --PROCESS HERE

Line 6386: pn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE,

6382: /*
6383: || Fire jai_ar_rcta_trigger_pkg.aru_t1
6384: */
6385: PROCEDURE fire_aru_t4(
6386: pn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE,
6387: ov_return_code OUT NOCOPY VARCHAR2,
6388: ov_return_message OUT NOCOPY VARCHAR2
6389: )
6390: IS

Line 6394: FROM RA_CUSTOMER_TRX_ALL

6390: IS
6391: CURSOR get_ar_detail_cur
6392: IS
6393: SELECT *
6394: FROM RA_CUSTOMER_TRX_ALL
6395: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id;
6396:
6397: lv_action VARCHAR2(20) := jai_constants.updating;
6398: lv_return_message VARCHAR2(2000);

Line 6400: rec_ar_detail RA_CUSTOMER_TRX_ALL%ROWTYPE;

6396:
6397: lv_action VARCHAR2(20) := jai_constants.updating;
6398: lv_return_message VARCHAR2(2000);
6399: lv_return_code VARCHAR2(100) ;
6400: rec_ar_detail RA_CUSTOMER_TRX_ALL%ROWTYPE;
6401: BEGIN
6402: FOR rec_ar_detail IN get_ar_detail_cur
6403: LOOP
6404: --PROCESS HERE

Line 6427: pn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE,

6423: /*
6424: || Fire jai_ar_rcta_trigger_pkg.aru_t1
6425: */
6426: PROCEDURE fire_aru_t7(
6427: pn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE,
6428: ov_return_code OUT NOCOPY VARCHAR2,
6429: ov_return_message OUT NOCOPY VARCHAR2
6430: )
6431: IS

Line 6435: FROM RA_CUSTOMER_TRX_ALL

6431: IS
6432: CURSOR get_ar_detail_cur
6433: IS
6434: SELECT *
6435: FROM RA_CUSTOMER_TRX_ALL
6436: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id;
6437:
6438: lv_action VARCHAR2(20) := jai_constants.updating;
6439: lv_return_message VARCHAR2(2000);

Line 6441: rec_ar_detail RA_CUSTOMER_TRX_ALL%ROWTYPE;

6437:
6438: lv_action VARCHAR2(20) := jai_constants.updating;
6439: lv_return_message VARCHAR2(2000);
6440: lv_return_code VARCHAR2(100) ;
6441: rec_ar_detail RA_CUSTOMER_TRX_ALL%ROWTYPE;
6442: BEGIN
6443: FOR rec_ar_detail IN get_ar_detail_cur
6444: LOOP
6445: --PROCESS HERE

Line 6467: pn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE,

6463: /*
6464: || Fire jai_jar_trxs_trigger_pkg.aru_t1
6465: */
6466: PROCEDURE fire_jai_aru_t1(
6467: pn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE,
6468: ov_return_code OUT NOCOPY VARCHAR2,
6469: ov_return_message OUT NOCOPY VARCHAR2
6470: )
6471: IS

Line 6546: pn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE,

6542: /*
6543: ||
6544: */
6545: PROCEDURE acc_inclusive_tax(
6546: pn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE,
6547: ov_return_code OUT NOCOPY VARCHAR2,
6548: ov_return_message OUT NOCOPY VARCHAR2
6549: )
6550: IS

Line 6560: FROM RA_CUSTOMER_TRX_ALL

6556:
6557: CURSOR get_ar_org_id_cur
6558: IS
6559: SELECT ORG_ID,cust_trx_type_id
6560: FROM RA_CUSTOMER_TRX_ALL
6561: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id;
6562:
6563: CURSOR inclu_flag_cur(cn_org_id IN NUMBER)
6564: IS

Line 6762: FROM RA_CUSTOMER_TRX_ALL

6758: WHERE Customer_Trx_ID = pn_customer_trx_id;
6759:
6760: CURSOR ORG_CUR IS
6761: SELECT ORG_ID, CREATED_FROM
6762: FROM RA_CUSTOMER_TRX_ALL
6763: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id;
6764:
6765:
6766: CURSOR TEMP_CUR IS

Line 6903: FROM RA_CUSTOMER_TRX_ALL

6899: v_temp_cust_trx_id Number;
6900:
6901: CURSOR ORG_CUR_UPD IS
6902: SELECT created_from, NVL(exchange_rate, 1) exchange_rate --9177024
6903: FROM RA_CUSTOMER_TRX_ALL
6904: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id;
6905:
6906:
6907: CURSOR check_rma_ref IS

Line 6912: FROM RA_CUSTOMER_TRX_ALL

6908: SELECT 1
6909: from JAI_OM_OE_RMA_LINES
6910: WHERE TO_CHAR(RMA_NUMBER) IN
6911: (SELECT INTERFACE_HEADER_ATTRIBUTE1
6912: FROM RA_CUSTOMER_TRX_ALL
6913: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id)
6914: AND Rma_line_id in
6915: (Select RMA_LINE_ID
6916: from JAI_OM_OE_RMA_TAXES a, JAI_CMN_TAXES_ALL b

Line 6931: FROM RA_CUSTOMER_TRX_ALL

6927:
6928:
6929: CURSOR get_reason IS
6930: SELECT reason_code
6931: FROM RA_CUSTOMER_TRX_ALL
6932: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id;
6933:
6934: v_reason_code ra_customer_trx_all.reason_code%TYPE;
6935: --end 12-Mar-2002

Line 6934: v_reason_code ra_customer_trx_all.reason_code%TYPE;

6930: SELECT reason_code
6931: FROM RA_CUSTOMER_TRX_ALL
6932: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id;
6933:
6934: v_reason_code ra_customer_trx_all.reason_code%TYPE;
6935: --end 12-Mar-2002
6936: v_tax_amt Number;
6937: v_err_mesg VARCHAR2(250);
6938: l_retcode NUMBER(1);

Line 6944: FROM ra_customer_trx_all

6940:
6941: CURSOR get_trx_num IS
6942: SELECT --21-Mar-2002 for ar tax and freight
6943: trx_number
6944: FROM ra_customer_trx_all
6945: WHERE customer_trx_id = pn_customer_trx_id;
6946:
6947:
6948: --added the following cursor for bug#8476512

Line 6957: v_trx_num ra_customer_trx_all.trx_number%TYPE;

6953: AND link_to_cust_trx_line_id = cp_link_to_cust_trx_line_id;
6954:
6955: ln_tax_line_exists NUMBER; --added for bug#8476512
6956:
6957: v_trx_num ra_customer_trx_all.trx_number%TYPE;
6958: v_count_trx NUMBER;
6959: V_sum_amt NUMBER;
6960:
6961: ------------------------------------------------------------------------------------------------

Line 7045: CURSOR cur_total_amt_trx_lines(cpn_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE, cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL, cp_line_type ra_customer_trx_lines_all.line_type%TYPE) IS

7041: ln_taxable_amount NUMBER;
7042: ln_tax_amt NUMBER;
7043: ln_tax_acctd_amount NUMBER;
7044:
7045: CURSOR cur_total_amt_trx_lines(cpn_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE, cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL, cp_line_type ra_customer_trx_lines_all.line_type%TYPE) IS
7046: SELECT NVL(SUM(extended_amount), 0) extended_amount
7047: FROM ra_customer_trx_lines_all
7048: WHERE customer_trx_id = cpn_customer_trx_id
7049: AND customer_trx_line_id = NVL(cp_customer_trx_line_id, customer_trx_line_id)

Line 7053: CURSOR cur_total_amt_gl_dist(cpn_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE) IS

7049: AND customer_trx_line_id = NVL(cp_customer_trx_line_id, customer_trx_line_id)
7050: AND line_type = cp_line_type;
7051:
7052:
7053: CURSOR cur_total_amt_gl_dist(cpn_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE) IS
7054: SELECT NVL(SUM(amount), 0) amount,
7055: NVL(SUM(acctd_amount), 0) acctd_amount
7056: FROM ra_cust_trx_line_gl_dist_all
7057: WHERE customer_trx_id = cpn_customer_trx_id

Line 8367: update ra_customer_trx_all

8363: */
8364:
8365: --
8366: /*
8367: update ra_customer_trx_all
8368: set complete_flag = 'Y'
8369: where customer_trx_id = ln_customer_trx_id;
8370: */
8371:

Line 10465: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

10461:
10462: Cursor transaction_type_cur(cn_customer_trx_id number)
10463: IS
10464: Select a.type
10465: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
10466: Where a.cust_trx_type_id = b.cust_trx_type_id
10467: And b.customer_trx_id = cn_customer_trx_id
10468: And NVL(a.org_id, 0) = NVL(b.org_id, 0);
10469:

Line 10522: FROM RA_CUSTOMER_TRX_ALL RCTA

10518: SELECT RCTA.org_id,
10519: RCTA.bill_to_customer_id,
10520: NVL(RCTA.bill_to_site_use_id, 0),
10521: RCTA.trx_date
10522: FROM RA_CUSTOMER_TRX_ALL RCTA
10523: WHERE RCTA.customer_trx_id = cn_customer_trx_id;
10524:
10525: l_max_tax_line_no number;
10526:

Line 11005: FROM ra_customer_trx_all A

11001: SELECT A.ship_to_customer_id,
11002: nvl(A.ship_to_site_use_id,0),
11003: trx_date,
11004: set_of_books_id
11005: FROM ra_customer_trx_all A
11006: WHERE customer_trx_id = pn_customer_trx_id;
11007:
11008: ln_header_id jai_interface_lines_all.internal_trx_id%TYPE;
11009: ln_line_num jai_interface_lines_all.internal_trx_line_id%TYPE;

Line 11023: ln_party_id ra_customer_trx_all.ship_to_customer_id%TYPE ;

11019: ln_quantity NUMBER;
11020: lv_unit_code VARCHAR2(10);
11021: ln_set_of_books_id NUMBER;
11022:
11023: ln_party_id ra_customer_trx_all.ship_to_customer_id%TYPE ;
11024: ln_party_site_id ra_customer_trx_all.ship_to_site_use_id%TYPE ;
11025: ld_trx_date ra_customer_trx_all.trx_date%TYPE ;
11026: ln_unit_selling_price ra_customer_trx_lines_all.unit_selling_price%TYPE;
11027: lv_module VARCHAR2(30);

Line 11024: ln_party_site_id ra_customer_trx_all.ship_to_site_use_id%TYPE ;

11020: lv_unit_code VARCHAR2(10);
11021: ln_set_of_books_id NUMBER;
11022:
11023: ln_party_id ra_customer_trx_all.ship_to_customer_id%TYPE ;
11024: ln_party_site_id ra_customer_trx_all.ship_to_site_use_id%TYPE ;
11025: ld_trx_date ra_customer_trx_all.trx_date%TYPE ;
11026: ln_unit_selling_price ra_customer_trx_lines_all.unit_selling_price%TYPE;
11027: lv_module VARCHAR2(30);
11028:

Line 11025: ld_trx_date ra_customer_trx_all.trx_date%TYPE ;

11021: ln_set_of_books_id NUMBER;
11022:
11023: ln_party_id ra_customer_trx_all.ship_to_customer_id%TYPE ;
11024: ln_party_site_id ra_customer_trx_all.ship_to_site_use_id%TYPE ;
11025: ld_trx_date ra_customer_trx_all.trx_date%TYPE ;
11026: ln_unit_selling_price ra_customer_trx_lines_all.unit_selling_price%TYPE;
11027: lv_module VARCHAR2(30);
11028:
11029: lv_err_mess VARCHAR2(300);

Line 11957: update ra_customer_trx_all

11953: END IF;
11954:
11955: --Fired the trigger jai_ar_rcta_ariud_t1,jai_ar_rcta_trigger_pkg.aru_t4,aru_t7.inclusive_tax_accounting
11956: /*
11957: update ra_customer_trx_all
11958: set complete_flag = 'Y'
11959: where customer_trx_id = rec_trx_id.trx_id;
11960: */
11961: --Update all the lines status of the transaction.