DBA Data[Home] [Help]

APPS.JAI_PA_BILLING_PKG dependencies on JAI_RGM_DEFINITIONS

Line 547: cp_regime_id JAI_RGM_DEFINITIONS.regime_id%type

543:
544: CURSOR c_same_inv_no(
545: cp_organization_id JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
546: cp_location_id JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
547: cp_regime_id JAI_RGM_DEFINITIONS.regime_id%type
548: ) IS
549: SELECT attribute_value
550: FROM jai_rgm_org_regns_v
551: WHERE regime_id = cp_regime_id

Line 557: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

553: AND attribute_code = jai_constants.attr_code_same_inv_no
554: AND organization_id = cp_organization_id
555: AND location_id = cp_location_id;
556:
557: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
558: lv_same_invoice_no_flag jai_rgm_org_regns_v.attribute_value%type;
559: lv_vat_invoice_no VARCHAR2(240);
560: ld_vat_invoice_date DATE;
561:

Line 1557: ln_service_rgm_id JAI_RGM_DEFINITIONS.regime_id%type;

1553: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1554: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1555: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;
1556: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
1557: ln_service_rgm_id JAI_RGM_DEFINITIONS.regime_id%type;
1558: lv_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;
1559: ln_lines_to_insert number;
1560: ln_nrec_tax_amt number;
1561: ln_rec_tax_amt number;

Line 1687: cursor c_get_regime_id (cpv_regime_code JAI_RGM_DEFINITIONS.regime_code%type)

1683: where tax_id = cpn_tax_id;
1684:
1685: r_tax_details c_tax_details%rowtype ;
1686:
1687: cursor c_get_regime_id (cpv_regime_code JAI_RGM_DEFINITIONS.regime_code%type)
1688: is
1689: select regime_id
1690: from JAI_RGM_DEFINITIONS
1691: where regime_code = cpv_regime_code;

Line 1690: from JAI_RGM_DEFINITIONS

1686:
1687: cursor c_get_regime_id (cpv_regime_code JAI_RGM_DEFINITIONS.regime_code%type)
1688: is
1689: select regime_id
1690: from JAI_RGM_DEFINITIONS
1691: where regime_code = cpv_regime_code;
1692:
1693: cursor c_get_rgm_for_tax_type (cpv_tax_type varchar2)
1694: is