DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on JAI_RGM_TRX_RECORDS_S

Line 832: jai_rgm_trx_records_s.nextval, lv_regime_code, p_tax_type, p_source,

828: trx_reference_context, trx_reference1, trx_reference2, trx_reference3, trx_reference4, trx_reference5
829: , inv_organization_id, regime_primary_regno ,service_type_code /* added by ssawant for bug 5879769 */
830: , invoice_no --Add by Qiong for Advanced Receipts
831: ) VALUES (
832: jai_rgm_trx_records_s.nextval, lv_regime_code, p_tax_type, p_source,
833: p_source_document_id, p_source_table_name, ld_transaction_date, ln_debit, ln_credit,
834: null, null, p_settlement_id, p_organization_type,
835: p_organization_id, p_location_id, lv_account_name,--Modified by Xiao from p_account_name for POT change, reg bug#12533434
836: ln_charge_account_id, ln_balancing_account_id,

Line 1310: lv_source jai_rgm_trx_records.source%TYPE ;

1306: ln_cash_receipt_id NUMBER;
1307: ln_customer_trx_id NUMBER;
1308: --Added by Wenqiong end
1309:
1310: lv_source jai_rgm_trx_records.source%TYPE ;
1311: lv_src_party_id jai_rgm_dis_src_hdrs.party_id%TYPE ;
1312: lv_reference1 gl_interface.reference1%TYPE ;
1313: ln_loop_cnt NUMBER;
1314:

Line 2186: jai_rgm_trx_records_s.nextval, lv_regime_code, pv_tax_type, pv_source,

2182: creation_date, created_by, last_update_date, last_updated_by, last_update_login,
2183: trx_reference_context, trx_reference1, trx_reference2, trx_reference3, trx_reference4, trx_reference5
2184: , inv_organization_id, regime_primary_regno, invoice_no, invoice_date
2185: ) VALUES (
2186: jai_rgm_trx_records_s.nextval, lv_regime_code, pv_tax_type, pv_source,
2187: pn_source_id, pv_source_table_name, ld_transaction_date, pn_debit_amount, pn_credit_amount,
2188: null, null, pn_settlement_id, pv_organization_type, --added pn_settlement_id for bug#9350172
2189: pn_organization_id, pn_location_id, pv_account_name, pn_charge_account_id, pn_balancing_account_id,
2190: pn_reference_id, pv_source_trx_type, pn_tax_rate, pn_assessable_value, pn_batch_id,

Line 2248: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;

2244: ln_accounted_debit NUMBER;
2245: ld_accounting_date DATE;
2246: ld_transaction_date DATE;
2247:
2248: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;
2249: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
2250: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;
2251: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;
2252: ln_repository_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;

Line 2249: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;

2245: ld_accounting_date DATE;
2246: ld_transaction_date DATE;
2247:
2248: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;
2249: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
2250: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;
2251: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;
2252: ln_repository_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
2253: lv_repository_name VARCHAR2(30);

Line 2250: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;

2246: ld_transaction_date DATE;
2247:
2248: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;
2249: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
2250: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;
2251: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;
2252: ln_repository_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
2253: lv_repository_name VARCHAR2(30);
2254:

Line 2251: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;

2247:
2248: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;
2249: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
2250: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;
2251: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;
2252: ln_repository_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
2253: lv_repository_name VARCHAR2(30);
2254:
2255: lv_statement_id VARCHAR2(3);