APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_RGM_TRX_RECORDS

Line 115: FROM jai_rgm_trx_records

111:
112: CURSOR c_rgm_repository_id(cp_source IN VARCHAR2, cp_source_table_name IN VARCHAR2,
113: cp_source_document_id IN NUMBER, cp_reference_id IN NUMBER) IS
114: SELECT repository_id
115: FROM jai_rgm_trx_records
116: WHERE source = cp_source
117: AND source_table_name = cp_source_table_name
118: AND source_document_id = cp_source_document_id
119: AND reference_id = cp_reference_id;

Line 124: FROM jai_rgm_trx_records

120:
121: CURSOR c_repo_recovered_amt(cp_source IN VARCHAR2, cp_source_table_name IN VARCHAR2,
122: cp_source_document_id IN NUMBER, cp_reference_id IN NUMBER) IS
123: SELECT nvl(credit_amount, debit_amount) amount
124: FROM jai_rgm_trx_records
125: WHERE source = cp_source
126: AND source_table_name = cp_source_table_name
127: AND source_document_id = cp_source_document_id
128: AND reference_id = cp_reference_id;

Line 306: ld_transaction_date JAI_RGM_TRX_RECORDS.transaction_date%TYPE;

302: ln_recovered_amount NUMBER;
303: ln_parent_recovered_amt NUMBER;
304:
305: ln_payment_amount NUMBER;
306: ld_transaction_date JAI_RGM_TRX_RECORDS.transaction_date%TYPE;
307: ld_accounting_date DATE;
308: ln_validate_amount NUMBER;
309: ln_discounted_amount NUMBER := 0;
310: ln_payment_discount NUMBER := 0;

Line 994: AND a.invoice_payment_id NOT IN (select source_document_id from jai_rgm_trx_records -- CHK is this required

990: AND a.check_id = b.check_id
991: AND a.creation_date < cp_start_date
992: AND nvl(b.future_pay_due_date, v_today) <= v_today
993: AND a.amount <> 0 /* ssumaith bug# 6104491 */
994: AND a.invoice_payment_id NOT IN (select source_document_id from jai_rgm_trx_records -- CHK is this required
995: where source = jai_constants.source_ap
996: and source_table_name = jai_constants.ap_payments
997: and source_document_id = a.invoice_payment_id
998: )

Line 1091: FROM jai_rgm_trx_records

1087: logic.
1088: */
1089: CURSOR c_payment_chk(cp_source IN VARCHAR2, cp_source_table_name IN VARCHAR2, cp_source_document_id IN NUMBER) IS
1090: SELECT 1
1091: FROM jai_rgm_trx_records
1092: WHERE source = jai_constants.source_ap
1093: AND source_table_name = jai_constants.ap_payments
1094: AND source_document_id = cp_source_document_id;
1095:

Line 1112: ln_rgm_reposotory_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;

1108: ln_reference_id JAI_RGM_TRX_REFS.reference_id%TYPE;
1109: ln_parent_reference_id JAI_RGM_TRX_REFS.parent_reference_id%TYPE;
1110: ln_taxable_basis NUMBER;
1111:
1112: ln_rgm_reposotory_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
1113: ln_recovered_amount JAI_RGM_TRX_REFS.recovered_amount%TYPE;
1114: ln_recoverable_amount JAI_RGM_TRX_REFS.recoverable_amount%TYPE;
1115:
1116: ln_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

Line 1117: lv_src_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;

1113: ln_recovered_amount JAI_RGM_TRX_REFS.recovered_amount%TYPE;
1114: ln_recoverable_amount JAI_RGM_TRX_REFS.recoverable_amount%TYPE;
1115:
1116: ln_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
1117: lv_src_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
1118: lv_process_flag VARCHAR2(2);
1119: lv_process_message VARCHAR2(1000);
1120:
1121: ln_commit_interval NUMBER(5) := 500;

Line 1573: p_registration_num JAI_RGM_TRX_RECORDS.REGIME_PRIMARY_REGNO%TYPE,

1569: PROCEDURE process (
1570: retcode OUT NOCOPY VARCHAR2,
1571: errbuf OUT NOCOPY VARCHAR2,
1572: p_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE,
1573: p_registration_num JAI_RGM_TRX_RECORDS.REGIME_PRIMARY_REGNO%TYPE,
1574: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
1575: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
1576: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
1577: p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,