DBA Data[Home] [Help]

APPS.JAI_AP_TDS_OLD_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 145: FROM JAI_CMN_VENDOR_SITES

141: WHERE Invoice_Id = inv_id;
142:
143: CURSOR Fetch_App_Inv_Flag_Cur( p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER ) IS
144: SELECT NVL( Approved_Invoice_Flag, 'N' ) Approved_Invoice_Flag
145: FROM JAI_CMN_VENDOR_SITES
146: WHERE Vendor_Id = p_vendor_id
147: AND Vendor_Site_Id = p_vendor_site_id;
148:
149: -- start added for bug#3556035

Line 876: FROM JAI_CMN_VENDOR_SITES

872: BEGIN
873:
874: SELECT NVL( Approved_Invoice_Flag, 'N' )
875: INTO v_Approved_Invoice_Flag
876: FROM JAI_CMN_VENDOR_SITES
877: WHERE Vendor_Id = for_std_invoice_rec.vendor_id
878: AND Vendor_Site_Id = for_std_invoice_rec.vendor_site_id;
879:
880: EXCEPTION

Line 888: FROM JAI_CMN_VENDOR_SITES

884: BEGIN
885:
886: SELECT NVL( Approved_Invoice_Flag, 'N' )
887: INTO v_Approved_Invoice_Flag
888: FROM JAI_CMN_VENDOR_SITES
889: WHERE Vendor_Id = for_std_invoice_rec.vendor_id
890: AND Vendor_Site_Id = 0;
891:
892: EXCEPTION

Line 1072: FROM JAI_CMN_VENDOR_SITES

1068: WHERE Invoice_Id = p_invoice_id;
1069:
1070: /* CURSOR Fetch_App_Inv_Flag_Cur( p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER ) IS
1071: SELECT NVL( Approved_Invoice_Flag, 'N' ) Approved_Invoice_Flag
1072: FROM JAI_CMN_VENDOR_SITES
1073: WHERE Vendor_Id = p_vendor_id
1074: AND Vendor_Site_Id = p_vendor_site_id;
1075: */
1076: CURSOR Fetch_App_Inv_Flag_Cur( p_inv_id IN NUMBER) IS

Line 1078: FROM JAI_CMN_VENDOR_SITES

1074: AND Vendor_Site_Id = p_vendor_site_id;
1075: */
1076: CURSOR Fetch_App_Inv_Flag_Cur( p_inv_id IN NUMBER) IS
1077: SELECT NVL( Approved_Invoice_Flag, 'N' ) Approved_Invoice_Flag
1078: FROM JAI_CMN_VENDOR_SITES
1079: WHERE (Vendor_Id, vendor_site_id) =
1080: (SELECT vendor_id, vendor_site_id FROM ap_invoices_all WHERE invoice_id = p_inv_id);
1081:
1082:

Line 1784: FROM JAI_CMN_VENDOR_SITES

1780: BEGIN
1781:
1782: SELECT NVL( Approved_Invoice_Flag, 'N' )
1783: INTO v_Approved_Invoice_Flag
1784: FROM JAI_CMN_VENDOR_SITES
1785: WHERE Vendor_Id = for_std_inv_rec.vendor_id
1786: AND Vendor_Site_Id = for_std_inv_rec.vendor_site_id;
1787:
1788: EXCEPTION

Line 1796: FROM JAI_CMN_VENDOR_SITES

1792: BEGIN
1793:
1794: SELECT NVL( Approved_Invoice_Flag, 'N' )
1795: INTO v_Approved_Invoice_Flag
1796: FROM JAI_CMN_VENDOR_SITES
1797: WHERE Vendor_Id = for_std_inv_rec.vendor_id
1798: AND Vendor_Site_Id = 0;
1799:
1800: EXCEPTION

Line 1959: FROM JAI_CMN_VENDOR_SITES

1955: WHERE Invoice_Id = p_invoice_id;
1956:
1957: CURSOR Fetch_App_Inv_Flag_Cur( p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER ) IS
1958: SELECT NVL( Approved_Invoice_Flag, 'N' ) Approved_Invoice_Flag
1959: FROM JAI_CMN_VENDOR_SITES
1960: WHERE Vendor_Id = p_vendor_id
1961: AND Vendor_Site_Id = p_vendor_site_id;
1962:
1963: /* commented by Aparajita for bug 2364106 on 15-may-2002

Line 3044: FROM JAI_CMN_VENDOR_SITES

3040: BEGIN
3041:
3042: SELECT NVL( Approved_Invoice_Flag, 'N' )
3043: INTO v_Approved_Invoice_Flag
3044: FROM JAI_CMN_VENDOR_SITES
3045: WHERE Vendor_Id = for_std_invoice_rec.vendor_id
3046: AND Vendor_Site_Id = for_std_invoice_rec.vendor_site_id;
3047:
3048: EXCEPTION

Line 3056: FROM JAI_CMN_VENDOR_SITES

3052: BEGIN
3053:
3054: SELECT NVL( Approved_Invoice_Flag, 'N' )
3055: INTO v_Approved_Invoice_Flag
3056: FROM JAI_CMN_VENDOR_SITES
3057: WHERE Vendor_Id = for_std_invoice_rec.vendor_id
3058: AND Vendor_Site_Id = 0;
3059:
3060: EXCEPTION

Line 3476: FROM JAI_CMN_VENDOR_SITES

3472: BEGIN
3473:
3474: SELECT NVL( Approved_Invoice_Flag, 'N' )
3475: INTO v_Approved_Invoice_Flag
3476: FROM JAI_CMN_VENDOR_SITES
3477: WHERE Vendor_Id = for_std_inv_rec_r.vendor_id
3478: AND Vendor_Site_Id = for_std_inv_rec_r.vendor_site_id;
3479:
3480: EXCEPTION

Line 3488: FROM JAI_CMN_VENDOR_SITES

3484: BEGIN
3485:
3486: SELECT NVL( Approved_Invoice_Flag, 'N' )
3487: INTO v_Approved_Invoice_Flag
3488: FROM JAI_CMN_VENDOR_SITES
3489: WHERE Vendor_Id = for_std_inv_rec_r.vendor_id
3490: AND Vendor_Site_Id = 0;
3491:
3492: EXCEPTION

Line 3604: FROM JAI_CMN_VENDOR_SITES

3600: WHERE Invoice_Id = inv_id;
3601:
3602: /*CURSOR Fetch_App_Inv_Flag_Cur IS
3603: SELECT NVL( Approved_Invoice_Flag, 'N' ) Approved_Invoice_Flag
3604: FROM JAI_CMN_VENDOR_SITES
3605: WHERE Vendor_Id = p_vendor_id
3606: AND Vendor_Site_Id = p_vendor_site_id; */
3607:
3608: CURSOR Fetch_Inv_Num_Cur IS