DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on JAI_RGM_TRX_RECORDS_S

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

515: creation_date, created_by, last_update_date, last_updated_by, last_update_login,
516: attribute_context, attribute1, attribute2, attribute3, attribute4, attribute5
517: , inv_organization_id, regime_primary_regno ,service_type_code /* added by ssawant for bug 5879769 */
518: ) VALUES (
519: jai_rgm_trx_records_s.nextval, lv_regime_code, p_tax_type, p_source,
520: p_source_document_id, p_source_table_name, ld_transaction_date, ln_debit, ln_credit,
521: null, null, p_settlement_id, p_organization_type,
522: p_organization_id, p_location_id, p_account_name, ln_charge_account_id, ln_balancing_account_id,
523: p_reference_id, p_source_trx_type, p_tax_rate, p_assessable_value, p_batch_id,

Line 924: lv_source jai_rgm_trx_records.source%TYPE ;

920: from jai_rgm_trx_records
921: where repository_id = cp_repository_id ;
922:
923:
924: lv_source jai_rgm_trx_records.source%TYPE ;
925: lv_src_party_id jai_rgm_dis_src_hdrs.party_id%TYPE ;
926: lv_reference1 gl_interface.reference1%TYPE ;
927: ln_loop_cnt NUMBER;
928:

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

1725: creation_date, created_by, last_update_date, last_updated_by, last_update_login,
1726: attribute_context, attribute1, attribute2, attribute3, attribute4, attribute5
1727: , inv_organization_id, regime_primary_regno, invoice_no, invoice_date
1728: ) VALUES (
1729: jai_rgm_trx_records_s.nextval, lv_regime_code, pv_tax_type, pv_source,
1730: pn_source_id, pv_source_table_name, ld_transaction_date, pn_debit_amount, pn_credit_amount,
1731: null, null, null, pv_organization_type,
1732: pn_organization_id, pn_location_id, pv_account_name, pn_charge_account_id, pn_balancing_account_id,
1733: pn_reference_id, pv_source_trx_type, pn_tax_rate, pn_assessable_value, pn_batch_id,

Line 1791: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;

1787: ln_accounted_debit NUMBER;
1788: ld_accounting_date DATE;
1789: ld_transaction_date DATE;
1790:
1791: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;
1792: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
1793: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;
1794: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;
1795: ln_repository_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;

Line 1792: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;

1788: ld_accounting_date DATE;
1789: ld_transaction_date DATE;
1790:
1791: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;
1792: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
1793: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;
1794: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;
1795: ln_repository_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
1796: lv_repository_name VARCHAR2(30);

Line 1793: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;

1789: ld_transaction_date DATE;
1790:
1791: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;
1792: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
1793: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;
1794: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;
1795: ln_repository_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
1796: lv_repository_name VARCHAR2(30);
1797:

Line 1794: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;

1790:
1791: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;
1792: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
1793: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;
1794: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;
1795: ln_repository_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
1796: lv_repository_name VARCHAR2(30);
1797:
1798: lv_statement_id VARCHAR2(3);