APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on JAI_RGM_DEFINITIONS

Line 857: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

853: lv_vat_invoice_no VARCHAR2(10);
854: lv_vat_inv_gen_status VARCHAR2(10);
855: ln_tcs_exists number;
856: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
857: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
858: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type;
859: ln_last_line_no number;
860: ln_base_line_no number;
861:

Line 862: CURSOR C_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)

858: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type;
859: ln_last_line_no number;
860: ln_base_line_no number;
861:
862: CURSOR C_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
863: IS
864: SELECT REGIME_ID
865: FROM JAI_RGM_DEFINITIONS
866: WHERE REGIME_CODE = CP_REGIME_CODE;

Line 865: FROM JAI_RGM_DEFINITIONS

861:
862: CURSOR C_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
863: IS
864: SELECT REGIME_ID
865: FROM JAI_RGM_DEFINITIONS
866: WHERE REGIME_CODE = CP_REGIME_CODE;
867:
868: /** Check if taxes with taxType as defined in the regime setup exists for given regime code */
869: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE

Line 869: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE

865: FROM JAI_RGM_DEFINITIONS
866: WHERE REGIME_CODE = CP_REGIME_CODE;
867:
868: /** Check if taxes with taxType as defined in the regime setup exists for given regime code */
869: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
870: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE)
871: IS
872: SELECT COUNT(1)
873: FROM JAI_REGIME_TAX_TYPES_V JRTTV

Line 3017: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

3013: IS
3014: v_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_TCS_TAXES';
3015: v_delivery_detail_id NUMBER;
3016: ln_tcs_exists number;
3017: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
3018: v_organization_id NUMBER;
3019: v_customer_id NUMBER;
3020: v_org_id NUMBER;
3021: v_date_confirmed DATE;

Line 3029: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE

3025: lv_process_flag VARCHAR2(5);
3026: lv_process_message VARCHAR2(1996);
3027:
3028: /** Check if taxes with taxType as defined in the regime setup exists for given regime code */
3029: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
3030: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE)
3031: IS
3032: SELECT COUNT(1)
3033: FROM JAI_REGIME_TAX_TYPES_V JRTTV

Line 3048: CURSOR C_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)

3044: Wsh_New_deliveries A
3045: WHERE B.Delivery_Id = A.Delivery_Id
3046: AND B.Delivery_Detail_id = v_delivery_detail_id;
3047:
3048: CURSOR C_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
3049: IS
3050: SELECT REGIME_ID
3051: FROM JAI_RGM_DEFINITIONS
3052: WHERE REGIME_CODE = CP_REGIME_CODE;

Line 3051: FROM JAI_RGM_DEFINITIONS

3047:
3048: CURSOR C_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
3049: IS
3050: SELECT REGIME_ID
3051: FROM JAI_RGM_DEFINITIONS
3052: WHERE REGIME_CODE = CP_REGIME_CODE;
3053:
3054: BEGIN
3055: pv_return_code := jai_constants.successful;

Line 3822: from JAI_RGM_DEFINITIONS

3818:
3819: cursor c_get_vat_regime
3820: is
3821: select regime_id
3822: from JAI_RGM_DEFINITIONS
3823: where regime_code = jai_constants.vat_regime;
3824:
3825: cursor c_deliver_date(p_delivery_id JAI_RGM_INVOICE_GEN_T.delivery_id%type)
3826: is