APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_RGM_DEFINITIONS

Line 682: ld_rgm_effective_from JAI_RGM_DEFINITIONS.effective_date_from%TYPE;

678: AND attribute_value = cp_registration_num
679: AND a.organization_id = nvl(cp_organization_id,a.organization_id) /*5694855*/;
680:
681:
682: ld_rgm_effective_from JAI_RGM_DEFINITIONS.effective_date_from%TYPE;
683: CURSOR c_rgm_effective_from_date(cp_regime_id IN NUMBER) IS
684: SELECT trunc(creation_date) effective_date_from /* effective_date_from. Commneted this as part of VAT Impl. Vijay Shankar for Bug#425023(4245089) */
685: FROM JAI_RGM_DEFINITIONS
686: WHERE regime_id = cp_regime_id;

Line 685: FROM JAI_RGM_DEFINITIONS

681:
682: ld_rgm_effective_from JAI_RGM_DEFINITIONS.effective_date_from%TYPE;
683: CURSOR c_rgm_effective_from_date(cp_regime_id IN NUMBER) IS
684: SELECT trunc(creation_date) effective_date_from /* effective_date_from. Commneted this as part of VAT Impl. Vijay Shankar for Bug#425023(4245089) */
685: FROM JAI_RGM_DEFINITIONS
686: WHERE regime_id = cp_regime_id;
687: /*Bug 5879769 bduvarag start*/
688: CURSOR cur_fetch_ou(cp_organization_id NUMBER)
689: IS

Line 1572: p_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE,

1568:
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,

Line 1697: lv_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

1693: lv_debug VARCHAR2(5); -- := jai_constants.no /* This should be either 'Y' or 'N' */ File.Sql.35 by Brathod
1694: ln_order_type_id JAI_OM_WSH_LINES_ALL.ORDER_TYPE_ID%TYPE;
1695: lv_inv_num_already_generated VARCHAR2(10); --:= jai_constants.value_false File.Sql.35 by Brathod
1696: ln_batch_id NUMBER;
1697: lv_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1698: ln_current_party_id NUMBER;
1699: ln_current_party_site_id NUMBER;
1700: lv_party_has_changed VARCHAR2(10);
1701: ln_conc_progam_id NUMBER;

Line 1712: FROM JAI_RGM_DEFINITIONS

1708: ld_override_invoice_date DATE; /* aiyer for the bug 5369250 */
1709: lv_doc_type_class varchar2(2); /*kunkumar for bug #5233925*/
1710: CURSOR c_regime_cur(cp_trx_Date DATE) IS
1711: SELECT regime_id
1712: FROM JAI_RGM_DEFINITIONS
1713: WHERE regime_code = jai_constants.vat_regime;
1714:
1715:
1716: CURSOR c_shipment_info(cp_Delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS