APPS.JAI_AR_TCS_REP_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 1318: p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,

1314:
1315:
1316:
1317: PROCEDURE validate_app_unapp (
1318: p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,
1319: p_document_type OUT NOCOPY VARCHAR2 ,
1320: p_item_classification OUT NOCOPY JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,
1321: p_process_flag OUT NOCOPY VARCHAR2 ,
1322: p_process_message OUT NOCOPY VARCHAR2

Line 2370: CURSOR cur_get_ar_rec_app_all (cp_cash_receipt_id AR_RECEIVABLE_APPLICATIONS_ALL.CASH_RECEIPT_ID%TYPE)

2366: || Get all the applications for which Cash Receipt has got TCS type of taxes
2367: || and the corresponding invoice also have got TCS type of tax.
2368: || Unapplications needs not be considered as there applications also would not have gone
2369: *****/
2370: CURSOR cur_get_ar_rec_app_all (cp_cash_receipt_id AR_RECEIVABLE_APPLICATIONS_ALL.CASH_RECEIPT_ID%TYPE)
2371: IS
2372: SELECT
2373: ra.*
2374: FROM

Line 2375: ar_receivable_applications_all ra ,

2371: IS
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

Line 2437: p_araa AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ;

2433: jai_rgm_taxes
2434: WHERE
2435: trx_ref_id = cp_trx_ref_id;
2436:
2437: p_araa AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ;
2438: rec_cur_get_cr_details CUR_GET_CR_DETAILS%ROWTYPE ;
2439: rec_cur_copy_src_rcpt CUR_COPY_SRC_RCPT%ROWTYPE ;
2440: ln_rcpt_amount JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_AMT%TYPE ;
2441: lv_process_flag VARCHAR2(2) ;

Line 2726: PROCEDURE process_applications ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,

2722: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2723: END process_receipts;
2724:
2725:
2726: PROCEDURE process_applications ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,
2727: p_document_type IN VARCHAR2 ,
2728: p_item_classification IN JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,
2729: p_process_flag OUT NOCOPY VARCHAR2 ,
2730: p_process_message OUT NOCOPY VARCHAR2

Line 2737: CURSOR cur_get_app_to_det (cp_applied_customer_trx_id AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_CUSTOMER_TRX_ID%TYPE )

2733: ln_reg_id NUMBER;
2734: /*
2735: ||Get the application and applied to document details
2736: */
2737: CURSOR cur_get_app_to_det (cp_applied_customer_trx_id AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_CUSTOMER_TRX_ID%TYPE )
2738: IS
2739: SELECT
2740: trx_types.type app_to_doc_type ,
2741: --nvl(gl_dist.acctd_amount,0) app_to_doc_amt ,--Deleted by eric for inclusive tax

Line 3268: PROCEDURE process_unapp_rcpt_rev ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE DEFAULT NULL ,

3264: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3265: END process_applications;
3266:
3267:
3268: PROCEDURE process_unapp_rcpt_rev ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE DEFAULT NULL ,
3269: p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE DEFAULT NULL ,
3270: p_document_type IN VARCHAR2 ,
3271: p_process_flag OUT NOCOPY VARCHAR2 ,
3272: p_process_message OUT NOCOPY VARCHAR2

Line 5220: p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE Default Null ,

5216: p_document_type IN VARCHAR2 Default Null ,
5217: p_ooh IN OE_ORDER_HEADERS_ALL%ROWTYPE Default Null ,
5218: p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE Default Null ,
5219: p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE Default Null ,
5220: p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE Default Null ,
5221: p_process_flag OUT NOCOPY VARCHAR2 ,
5222: p_process_message OUT NOCOPY VARCHAR2
5223: )
5224: IS