DBA Data[Home] [Help]

APPS.JAI_JRG_23AC1_TRIGGER_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 46: v_range_no JAI_CMN_VENDOR_SITES.excise_duty_range%type ;

42: --Variable definitions
43: v_vendor_change JAI_RCV_CENVAT_CLAIMS.vendor_changed_flag%type ; /* To hold the Flag value whether vendor is changed or not. */
44: v_vendor_id JAI_RCV_CENVAT_CLAIMS.vendor_id%type ; /* To hold the vendor id of ja_in_receipt_cenvat. */
45: v_vendor_site_id JAI_RCV_CENVAT_CLAIMS.vendor_site_id%type ; /* To hold the vendor site id of ja_in_receipt_cenvat. */
46: v_range_no JAI_CMN_VENDOR_SITES.excise_duty_range%type ;
47: v_division_no JAI_CMN_VENDOR_SITES.excise_duty_division%type ;
48:
49: /*Bug 9122545*/
50: CURSOR c_org_addl_rg_flag(cp_organization_id jai_cmn_inventory_orgs.organization_id%TYPE,

Line 47: v_division_no JAI_CMN_VENDOR_SITES.excise_duty_division%type ;

43: v_vendor_change JAI_RCV_CENVAT_CLAIMS.vendor_changed_flag%type ; /* To hold the Flag value whether vendor is changed or not. */
44: v_vendor_id JAI_RCV_CENVAT_CLAIMS.vendor_id%type ; /* To hold the vendor id of ja_in_receipt_cenvat. */
45: v_vendor_site_id JAI_RCV_CENVAT_CLAIMS.vendor_site_id%type ; /* To hold the vendor site id of ja_in_receipt_cenvat. */
46: v_range_no JAI_CMN_VENDOR_SITES.excise_duty_range%type ;
47: v_division_no JAI_CMN_VENDOR_SITES.excise_duty_division%type ;
48:
49: /*Bug 9122545*/
50: CURSOR c_org_addl_rg_flag(cp_organization_id jai_cmn_inventory_orgs.organization_id%TYPE,
51: cp_location_id jai_cmn_inventory_orgs.location_id%TYPE)