[Home] [Help]
1355:
1356: /*
1357: ||Get the sign of the Cash receipt document
1358: */
1359: CURSOR cur_get_cr_sign (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
1360: IS
1361: SELECT
1362: sign (nvl(amount,0)) app_fr_sign
1363: FROM
1381:
1382: /*
1383: || Check that the Cash receipt has got TCS type of confirmed taxes
1384: */
1385: CURSOR cur_chk_crtcs_applicable ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
1386: IS
1387: SELECT
1388: jcra.item_classification,
1389: acra.amount
1388: jcra.item_classification,
1389: acra.amount
1390: FROM
1391: ar_cash_receipts_all acra ,
1392: jai_ar_cash_receipts_all jcra ,
1393: jai_cmn_document_taxes jdt ,
1394: jai_regime_tax_types_v jrttv
1395: WHERE
1396: jcra.cash_receipt_id = acra.cash_receipt_id
1395: WHERE
1396: jcra.cash_receipt_id = acra.cash_receipt_id
1397: AND jcra.cash_receipt_id = cp_cash_receipt_id
1398: AND jcra.cash_receipt_id = jdt.source_doc_id
1399: AND jdt.source_table_name = jai_constants.jai_cash_rcpts /* 'JAI_AR_CASH_RECEIPTS_ALL' */
1400: AND jcra.confirm_flag = jai_constants.yes
1401: AND jdt.tax_type = jrttv.tax_type /* Applied to doc has got TCS type of tax*/
1402: AND jrttv.regime_code = jai_constants.tcs_regime
1403: AND jdt.source_doc_type = JAI_CONSTANTS.ar_cash; --added by eric for a bug
1421:
1422: ln_sign_of_app_fr_doc NUMBER(3) ;
1423: ln_sign_of_app NUMBER(3) ;
1424: lv_exists VARCHAR2(1) ;
1425: ln_app_fr_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1426: ln_app_fr_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1427: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1428: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1429:
1427: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1428: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1429:
1430: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1431: ln_app_to_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1432: ln_app_to_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1433: ln_app_to_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1434:
1435: lv_app_doc_type VARCHAR2(100) ;
1865:
1866: /*
1867: || Check that the document has has TCS type of tax.
1868: */
1869: CURSOR cur_chk_tcs_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
1870: IS
1871: SELECT
1872: 1
1873: FROM
1870: IS
1871: SELECT
1872: 1
1873: FROM
1874: jai_ar_cash_receipts_all jcra ,
1875: jai_cmn_document_taxes jdt ,
1876: jai_regime_tax_types_v jrttv
1877: WHERE
1878: jcra.cash_receipt_id = cp_cash_receipt_id
2327: ln_reg_id NUMBER;
2328: /*****
2329: || Get the details of the cash_receipts
2330: *****/
2331: CURSOR cur_get_cr_details ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
2332: IS
2333: SELECT
2334: jcra.customer_id ,
2335: jcra.organization_id ,
2335: jcra.organization_id ,
2336: jcra.gl_date ,
2337: jcra.item_classification
2338: FROM
2339: jai_ar_cash_receipts_all jcra
2340: WHERE
2341: jcra.cash_receipt_id = cp_cash_receipt_id ;
2342:
2343: /*****
2372: SELECT
2373: ra.*
2374: FROM
2375: ar_receivable_applications_all ra ,
2376: jai_ar_cash_receipts_all jcra
2377: WHERE
2378: ra.cash_receipt_id = jcra.cash_receipt_id
2379: AND ra.cash_receipt_id = cp_cash_receipt_id
2380: AND ra.status = 'APP'
2387: jai_cmn_document_taxes jdt ,
2388: jai_regime_tax_types_v jrttv
2389: WHERE
2390: jdt.source_doc_id = jcra.cash_receipt_id
2391: AND jdt.source_table_name = jai_constants.jai_cash_rcpts /* 'JAI_AR_CASH_RECEIPTS_ALL' */
2392: AND jdt.tax_type = jrttv.tax_type
2393: AND jrttv.regime_code = jai_constants.tcs_regime
2394: AND jdt.source_doc_type = JAI_CONSTANTS.ar_cash --added by eric for a bug
2395: )
2821: acra.org_id
2822: FROM
2823: ar_cash_receipts_all acra ,
2824: ar_payment_schedules_all arps ,
2825: jai_ar_cash_receipts_all jcra ,
2826: jai_cmn_document_taxes jdt ,
2827: jai_regime_tax_types_v jrttv
2828: WHERE
2829: acra.cash_receipt_id = arps.cash_receipt_id
2991: ln_exchange_rate := rec_cur_get_cr_details.exchange_rate ;
2992:
2993: ln_app_fr_doc_id := p_araa.cash_receipt_id ;
2994: ln_app_fr_doc_type := jai_constants.ar_cash_tax_confirmed ; /* Receipt confirmation */
2995: ln_app_fr_doc_table := jai_constants.jai_cash_rcpts ; /* table JAI_AR_CASH_RECEIPTS_ALL */
2996:
2997: ln_fr_organization_id := rec_cur_get_cr_details.app_fr_organization_id ;
2998: ln_fr_party_id := rec_cur_get_cr_details.pay_from_customer ;
2999: ln_fr_party_site_id := rec_cur_get_cr_details.customer_site_use_id ;
3015: ln_exchange_rate := rec_cur_get_cm_details.exchange_rate ;
3016:
3017: ln_app_fr_doc_id := p_araa.customer_trx_id ;
3018: ln_app_fr_doc_type := jai_constants.ar_invoice_type_cm ; /* 'CM' */
3019: ln_app_fr_doc_table := jai_constants.ar_inv_lines_table ; /* table JAI_AR_CASH_RECEIPTS_ALL */
3020:
3021: ln_fr_organization_id := rec_cur_get_cm_details.app_to_organization_id ;
3022: ln_fr_party_id := rec_cur_get_cm_details.app_to_customer_id ;
3023: ln_fr_party_site_id := rec_cur_get_cm_details.app_to_customer_site_use_id ;