[Home] [Help]
1870:
1871: /*
1872: ||Get the sign of the Cash receipt document
1873: */
1874: CURSOR cur_get_cr_sign (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
1875: IS
1876: SELECT
1877: sign (nvl(amount,0)) app_fr_sign
1878: FROM
1896:
1897: /*
1898: || Check that the Cash receipt has got TCS type of confirmed taxes
1899: */
1900: CURSOR cur_chk_crtcs_applicable ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
1901: IS
1902: SELECT
1903: jcra.item_classification,
1904: acra.amount
1903: jcra.item_classification,
1904: acra.amount
1905: FROM
1906: ar_cash_receipts_all acra ,
1907: jai_ar_cash_receipts_all jcra ,
1908: jai_cmn_document_taxes jdt ,
1909: jai_regime_tax_types_v jrttv
1910: WHERE
1911: jcra.cash_receipt_id = acra.cash_receipt_id
1910: WHERE
1911: jcra.cash_receipt_id = acra.cash_receipt_id
1912: AND jcra.cash_receipt_id = cp_cash_receipt_id
1913: AND jcra.cash_receipt_id = jdt.source_doc_id
1914: AND jdt.source_table_name = jai_constants.jai_cash_rcpts /* 'JAI_AR_CASH_RECEIPTS_ALL' */
1915: AND jcra.confirm_flag = jai_constants.yes
1916: AND jdt.tax_type = jrttv.tax_type /* Applied to doc has got TCS type of tax*/
1917: AND jrttv.regime_code = jai_constants.tcs_regime
1918: AND jdt.source_doc_type = JAI_CONSTANTS.ar_cash; --added by eric for a bug
1936:
1937: ln_sign_of_app_fr_doc NUMBER(3) ;
1938: ln_sign_of_app NUMBER(3) ;
1939: lv_exists VARCHAR2(1) ;
1940: ln_app_fr_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1941: ln_app_fr_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1942: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1943: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1944:
1942: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1943: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1944:
1945: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1946: ln_app_to_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1947: ln_app_to_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1948: ln_app_to_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1949:
1950: lv_app_doc_type VARCHAR2(100) ;
2380:
2381: /*
2382: || Check that the document has has TCS type of tax.
2383: */
2384: CURSOR cur_chk_tcs_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
2385: IS
2386: SELECT
2387: 1
2388: FROM
2385: IS
2386: SELECT
2387: 1
2388: FROM
2389: jai_ar_cash_receipts_all jcra ,
2390: jai_cmn_document_taxes jdt ,
2391: jai_regime_tax_types_v jrttv
2392: WHERE
2393: jcra.cash_receipt_id = cp_cash_receipt_id
2842: ln_reg_id NUMBER;
2843: /*****
2844: || Get the details of the cash_receipts
2845: *****/
2846: CURSOR cur_get_cr_details ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
2847: IS
2848: SELECT
2849: jcra.customer_id ,
2850: jcra.organization_id ,
2850: jcra.organization_id ,
2851: jcra.gl_date ,
2852: jcra.item_classification
2853: FROM
2854: jai_ar_cash_receipts_all jcra
2855: WHERE
2856: jcra.cash_receipt_id = cp_cash_receipt_id ;
2857:
2858: /*****
2887: SELECT
2888: ra.*
2889: FROM
2890: ar_receivable_applications_all ra ,
2891: jai_ar_cash_receipts_all jcra
2892: WHERE
2893: ra.cash_receipt_id = jcra.cash_receipt_id
2894: AND ra.cash_receipt_id = cp_cash_receipt_id
2895: AND ra.status = 'APP'
2902: jai_cmn_document_taxes jdt ,
2903: jai_regime_tax_types_v jrttv
2904: WHERE
2905: jdt.source_doc_id = jcra.cash_receipt_id
2906: AND jdt.source_table_name = jai_constants.jai_cash_rcpts /* 'JAI_AR_CASH_RECEIPTS_ALL' */
2907: AND jdt.tax_type = jrttv.tax_type
2908: AND jrttv.regime_code = jai_constants.tcs_regime
2909: AND jdt.source_doc_type = JAI_CONSTANTS.ar_cash --added by eric for a bug
2910: )
3342: acra.org_id
3343: FROM
3344: ar_cash_receipts_all acra ,
3345: ar_payment_schedules_all arps ,
3346: jai_ar_cash_receipts_all jcra ,
3347: jai_cmn_document_taxes jdt ,
3348: jai_regime_tax_types_v jrttv
3349: WHERE
3350: acra.cash_receipt_id = arps.cash_receipt_id
3516: ln_exchange_rate := rec_cur_get_cr_details.exchange_rate ;
3517:
3518: ln_app_fr_doc_id := p_araa.cash_receipt_id ;
3519: ln_app_fr_doc_type := jai_constants.ar_cash_tax_confirmed ; /* Receipt confirmation */
3520: ln_app_fr_doc_table := jai_constants.jai_cash_rcpts ; /* table JAI_AR_CASH_RECEIPTS_ALL */
3521:
3522: ln_fr_organization_id := rec_cur_get_cr_details.app_fr_organization_id ;
3523: ln_fr_party_id := rec_cur_get_cr_details.pay_from_customer ;
3524: ln_fr_party_site_id := rec_cur_get_cr_details.customer_site_use_id ;
3540: ln_exchange_rate := rec_cur_get_cm_details.exchange_rate ;
3541:
3542: ln_app_fr_doc_id := p_araa.customer_trx_id ;
3543: ln_app_fr_doc_type := jai_constants.ar_invoice_type_cm ; /* 'CM' */
3544: ln_app_fr_doc_table := jai_constants.ar_inv_lines_table ; /* table JAI_AR_CASH_RECEIPTS_ALL */
3545:
3546: ln_fr_organization_id := rec_cur_get_cm_details.app_to_organization_id ;
3547: ln_fr_party_id := rec_cur_get_cm_details.app_to_customer_id ;
3548: ln_fr_party_site_id := rec_cur_get_cm_details.app_to_customer_site_use_id ;