APPS.JL_ZZ_AP_MONOTRIB_AWT_PKG dependencies on JL_ZZ_AP_SUP_AWT_CD_S

Line 546: SELECT jl_zz_ap_sup_awt_cd_s.nextval

542: IF v_flag = 0 THEN
543: SELECT jl_zz_ap_supp_awt_types_s.nextval
544: INTO v_supp_awt_type_id
545: FROM dual;
546: SELECT jl_zz_ap_sup_awt_cd_s.nextval
547: INTO v_supp_awt_code_id
548: FROM dual;
549:
550: ---- Inserting into Supplier Applicability table

Line 612: UPDATE JL_ZZ_AP_SUP_AWT_CD SET PRIMARY_TAX_FLAG = 'N'

608: WHERE awt_type_code = c_rec.awt_type_code
609: AND vendor_id = P_Supplier_Id
610: AND ROWNUM = 1;
611:
612: UPDATE JL_ZZ_AP_SUP_AWT_CD SET PRIMARY_TAX_FLAG = 'N'
613: WHERE SUPP_AWT_TYPE_ID = v_temp1;
614:
615: SELECT count(*) INTO v_temp2
616: FROM JL_ZZ_AP_SUP_AWT_CD

Line 621: UPDATE JL_ZZ_AP_SUP_AWT_CD SET PRIMARY_TAX_FLAG = 'Y'

617: WHERE TAX_ID = v_tax_id
618: AND SUPP_AWT_TYPE_ID = v_temp1;
619:
620: IF v_temp2 > 0 THEN
621: UPDATE JL_ZZ_AP_SUP_AWT_CD SET PRIMARY_TAX_FLAG = 'Y'
622: WHERE TAX_ID = v_tax_id
623: AND SUPP_AWT_TYPE_ID = v_temp1;
624: ELSE
625: SELECT jl_zz_ap_sup_awt_cd_s.nextval

Line 625: SELECT jl_zz_ap_sup_awt_cd_s.nextval

621: UPDATE JL_ZZ_AP_SUP_AWT_CD SET PRIMARY_TAX_FLAG = 'Y'
622: WHERE TAX_ID = v_tax_id
623: AND SUPP_AWT_TYPE_ID = v_temp1;
624: ELSE
625: SELECT jl_zz_ap_sup_awt_cd_s.nextval
626: INTO v_supp_awt_code_id
627: FROM dual;
628: INSERT INTO JL_ZZ_AP_SUP_AWT_CD_ALL(SUPP_AWT_CODE_ID,
629: SUPP_AWT_TYPE_ID,