DBA Data[Home] [Help]

APPS.JAI_AP_DVA_TRIGGER_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 53: FROM JAI_CMN_VENDOR_SITES

49: SELECT Excise_Duty_Region, Excise_Duty_Zone, Excise_Duty_Reg_No,
50: Excise_Duty_Range, Excise_Duty_Division, Excise_Duty_Circle,
51: Excise_Duty_Comm, St_Reg_No, Cst_Reg_No, Ec_Code,
52: Tax_Category_List
53: FROM JAI_CMN_VENDOR_SITES
54: WHERE Vendor_Id = v_dup_vendor_id
55: AND Vendor_Site_Id = v_n_vendor_site_id;
56:
57: ------------------------------>

Line 113: UPDATE JAI_CMN_VENDOR_SITES

109: -- p_org_id => pr_new.org_id) = FALSE THEN
110: -- RETURN;
111: --END IF;
112:
113: UPDATE JAI_CMN_VENDOR_SITES
114: SET Inactive_Flag = 'Y',
115: Last_Updated_By = v_last_upd_by,
116: Last_Update_Date = v_last_upd_dt,
117: Last_Update_Login = v_last_upd_login

Line 122: UPDATE JAI_CMN_VENDOR_SITES --Ja_In_Po_Vendor_Sites

118: WHERE Vendor_id = v_dup_vendor_id
119: AND Vendor_Site_Id = v_dup_vendor_site_id;
120:
121: /* copied the below update from ja_in_po_tds_ins_supp_merg as part of its obsoletion */
122: UPDATE JAI_CMN_VENDOR_SITES --Ja_In_Po_Vendor_Sites
123: SET Inactive_Flag = 'Y',
124: Last_Updated_By = v_last_upd_by,
125: Last_Update_Date = v_last_upd_dt,
126: Last_Update_Login = v_last_upd_login

Line 143: INSERT INTO JAI_CMN_VENDOR_SITES( VENDOR_ID,

139: OPEN Fetch_Excise_Dtl_Cur( v_n_vendor_site_id);
140: FETCH Fetch_Excise_Dtl_Cur INTO Excise_Rec;
141: CLOSE Fetch_Excise_Dtl_Cur;
142:
143: INSERT INTO JAI_CMN_VENDOR_SITES( VENDOR_ID,
144: VENDOR_SITE_ID,
145: EXCISE_DUTY_REGION,
146: EXCISE_DUTY_ZONE,
147: EXCISE_DUTY_REG_NO,