DBA Data[Home] [Help]

APPS.JAI_PO_PROC_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 3360: v_override_flag JAI_CMN_VENDOR_SITES.override_flag%TYPE;

3356: v_rate_type po_headers_all.rate_type%TYPE;
3357: v_rate_date po_headers_all.rate_date%TYPE;
3358:
3359: v_style_id po_headers_all.style_id%TYPE;
3360: v_override_flag JAI_CMN_VENDOR_SITES.override_flag%TYPE;
3361: v_tax_modified_flag JAI_PO_LINE_LOCATIONS.tax_modified_flag%TYPE;
3362: */
3363: CURSOR c_dist IS
3364: SELECT *

Line 3379: FROM JAI_CMN_VENDOR_SITES

3375: WHERE po_header_id = v_po_hdr_id;
3376:
3377: CURSOR tax_override_flag_cur(c_supplier_id number, c_supp_site_id number) IS
3378: SELECT override_flag
3379: FROM JAI_CMN_VENDOR_SITES
3380: WHERE vendor_id = c_supplier_id
3381: AND vendor_site_id = c_supp_site_id;
3382:
3383: Cursor c_get_tax_modified_flag IS

Line 4923: FROM JAI_CMN_VENDOR_SITES

4919: WHERE REQUISITION_LINE_ID = c_req_line_id;
4920:
4921: CURSOR tax_override_flag_cur(c_vendor_id NUMBER, c_vendor_site_id NUMBER) IS
4922: SELECT override_flag
4923: FROM JAI_CMN_VENDOR_SITES
4924: WHERE vendor_id = c_vendor_id
4925: AND vendor_site_id = c_vendor_site_id;
4926:
4927: v_override_flag VARCHAR2(1);

Line 5777: lv_override_flag JAI_CMN_VENDOR_SITES.override_flag%type ;

5773: FROM JAI_PO_LINE_LOCATIONS
5774: WHERE po_line_id = p_po_line_id
5775: AND line_location_id = p_line_location_id;
5776:
5777: lv_override_flag JAI_CMN_VENDOR_SITES.override_flag%type ;
5778: lv_cre_dt DATE;
5779: lv_cre_by NUMBER;
5780: lv_last_upd_dt DATE ;
5781: lv_last_upd_by NUMBER;

Line 5807: FROM JAI_CMN_VENDOR_SITES

5803: WHERE Po_Line_Id = line_id;
5804:
5805: CURSOR tax_override_flag_cur(c_vendor_id NUMBER, c_vendor_site_id NUMBER) IS
5806: SELECT override_flag
5807: FROM JAI_CMN_VENDOR_SITES
5808: WHERE vendor_id = c_vendor_id
5809: AND vendor_site_id = nvl(c_vendor_site_id,0) ;
5810:
5811: cursor fetch_vendor_id_cur(p_po_hdr_id po_headers_all.po_header_id%type ) IS

Line 7191: FROM JAI_CMN_VENDOR_SITES

7187: WHERE Unit_Of_Measure = c_uom;
7188:
7189: CURSOR tax_override_flag_cur(c_supplier_id number, c_supp_site_id number) IS
7190: SELECT override_flag
7191: FROM JAI_CMN_VENDOR_SITES
7192: WHERE vendor_id = c_supplier_id
7193: AND vendor_site_id = c_supp_site_id;
7194:
7195:

Line 7671: FROM JAI_CMN_VENDOR_SITES

7667: WHERE po_header_id = c_po_header_id;
7668:
7669: CURSOR tax_override_flag_cur(c_supplier_id number, c_supp_site_id number) IS
7670: SELECT override_flag
7671: FROM JAI_CMN_VENDOR_SITES
7672: WHERE vendor_id = c_supplier_id
7673: AND vendor_site_id = c_supp_site_id;
7674:
7675: Cursor c_get_tax_modified_flag(c_line_location_id NUMBER) IS

Line 7706: v_override_flag JAI_CMN_VENDOR_SITES.override_flag%TYPE;

7702: v_rate_type po_headers_all.rate_type%TYPE;
7703: v_rate_date po_headers_all.rate_date%TYPE;
7704:
7705: v_style_id po_headers_all.style_id%TYPE;
7706: v_override_flag JAI_CMN_VENDOR_SITES.override_flag%TYPE;
7707: v_tax_modified_flag JAI_PO_LINE_LOCATIONS.tax_modified_flag%TYPE;
7708: v_count NUMBER;
7709: l_api_name CONSTANT VARCHAR2(200) := 'process_distribution_line';
7710: BEGIN

Line 8351: FROM JAI_CMN_VENDOR_SITES

8347: WHERE REQUISITION_LINE_ID = c_req_line_id;
8348:
8349: CURSOR tax_override_flag_cur(c_vendor_id NUMBER, c_vendor_site_id NUMBER) IS
8350: SELECT override_flag
8351: FROM JAI_CMN_VENDOR_SITES
8352: WHERE vendor_id = c_vendor_id
8353: AND vendor_site_id = c_vendor_site_id;
8354:
8355: v_override_flag VARCHAR2(1);