APPS.JAI_AR_TCS_REP_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 1833: p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,

1829:
1830:
1831:
1832: PROCEDURE validate_app_unapp (
1833: p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,
1834: p_document_type OUT NOCOPY VARCHAR2 ,
1835: p_item_classification OUT NOCOPY JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,
1836: p_process_flag OUT NOCOPY VARCHAR2 ,
1837: p_process_message OUT NOCOPY VARCHAR2

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

2881: || Get all the applications for which Cash Receipt has got TCS type of taxes
2882: || and the corresponding invoice also have got TCS type of tax.
2883: || Unapplications needs not be considered as there applications also would not have gone
2884: *****/
2885: CURSOR cur_get_ar_rec_app_all (cp_cash_receipt_id AR_RECEIVABLE_APPLICATIONS_ALL.CASH_RECEIPT_ID%TYPE)
2886: IS
2887: SELECT
2888: ra.*
2889: FROM

Line 2890: ar_receivable_applications_all ra ,

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

Line 2952: p_araa AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ;

2948: jai_rgm_taxes
2949: WHERE
2950: trx_ref_id = cp_trx_ref_id;
2951:
2952: p_araa AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ;
2953: rec_cur_get_cr_details CUR_GET_CR_DETAILS%ROWTYPE ;
2954: rec_cur_copy_src_rcpt CUR_COPY_SRC_RCPT%ROWTYPE ;
2955: ln_rcpt_amount JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_AMT%TYPE ;
2956: lv_process_flag VARCHAR2(2) ;

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

3237: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3238: END process_receipts;
3239:
3240:
3241: PROCEDURE process_applications ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,
3242: p_document_type IN VARCHAR2 ,
3243: p_item_classification IN JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,
3244: p_process_flag OUT NOCOPY VARCHAR2 ,
3245: p_process_message OUT NOCOPY VARCHAR2

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

3248: ln_reg_id NUMBER;
3249: /*
3250: ||Get the application and applied to document details
3251: */
3252: CURSOR cur_get_app_to_det (cp_applied_customer_trx_id AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_CUSTOMER_TRX_ID%TYPE )
3253: IS
3254: SELECT
3255: trx_types.type app_to_doc_type ,
3256: --nvl(gl_dist.acctd_amount,0) app_to_doc_amt ,--Deleted by eric for inclusive tax

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

3800: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3801: END process_applications;
3802:
3803:
3804: PROCEDURE process_unapp_rcpt_rev ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE DEFAULT NULL ,
3805: p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE DEFAULT NULL ,
3806: p_document_type IN VARCHAR2 ,
3807: p_process_flag OUT NOCOPY VARCHAR2 ,
3808: p_process_message OUT NOCOPY VARCHAR2

Line 5832: p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE Default Null ,

5828: p_document_type IN VARCHAR2 Default Null ,
5829: p_ooh IN OE_ORDER_HEADERS_ALL%ROWTYPE Default Null ,
5830: p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE Default Null ,
5831: p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE Default Null ,
5832: p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE Default Null ,
5833: p_process_flag OUT NOCOPY VARCHAR2 ,
5834: p_process_message OUT NOCOPY VARCHAR2
5835: )
5836: IS