APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 1937: -- l_dist_line_num ap_invoice_distributions.invoice_distribution_id%TYPE;

1933: ------------------------------
1934: l_parent_dist_num Varchar2(100);
1935:
1936: -- Bug 4559478
1937: -- l_dist_line_num ap_invoice_distributions.invoice_distribution_id%TYPE;
1938: l_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1939:
1940: l_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
1941: l_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;

Line 1938: l_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;

1934: l_parent_dist_num Varchar2(100);
1935:
1936: -- Bug 4559478
1937: -- l_dist_line_num ap_invoice_distributions.invoice_distribution_id%TYPE;
1938: l_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1939:
1940: l_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
1941: l_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1942: l_debug_info Varchar2(300);

Line 1940: l_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;

1936: -- Bug 4559478
1937: -- l_dist_line_num ap_invoice_distributions.invoice_distribution_id%TYPE;
1938: l_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1939:
1940: l_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
1941: l_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1942: l_debug_info Varchar2(300);
1943: l_calling_sequence Varchar2(2000);
1944: v_country_code Varchar2(100);

Line 1968: FROM ap_invoice_distributions apid

1964: IS
1965: SELECT apid.invoice_distribution_id,
1966: apid.po_distribution_id,
1967: apid.global_attribute20 -- What is gdf20?
1968: FROM ap_invoice_distributions apid
1969: WHERE apid.invoice_id = P_Credit_Id
1970: AND apid.invoice_line_number = P_Inv_Line_Num;
1971: */
1972:

Line 2012: -- distribution lines created in ap_invoice_distributions

2008: EXIT WHEN c_distributions%NOTFOUND;
2009: */
2010: ---------------------------------------------------------------
2011: -- Creates lines in JL_ZZ_AP_INV_DIS_WH_ALL table for the
2012: -- distribution lines created in ap_invoice_distributions
2013: ---------------------------------------------------------------
2014: IF (P_Parent_Dist_ID IS NOT NULL) THEN
2015:
2016: ----------------------------------------------------------

Line 2075: UPDATE ap_invoice_distributions

2071: -----------------------------------------------------------
2072: -- Updates the distribution line to hold ship to location
2073: -- for defaulting the tax names
2074: -----------------------------------------------------------
2075: UPDATE ap_invoice_distributions
2076: SET
2077: -- global_attribute3 = l_ship_to_location_id,
2078: global_attribute_category = decode(v_country_code,'AR','JL.AR.APXINWKB.DISTRIBUTIONS',
2079: 'CO','JL.CO.APXINWKB.DISTRIBUTIONS','')

Line 2757: -- Cursor to get CCID from AP_Invoice_Distributions_ID

2753: counter number :=1 ;
2754:
2755:
2756: ----------------------------------------------------------------------
2757: -- Cursor to get CCID from AP_Invoice_Distributions_ID
2758: ----------------------------------------------------------------------
2759: CURSOR Bal_Seg IS
2760: SELECT dist_code_combination_id
2761: FROM ap_invoice_distributions

Line 2761: FROM ap_invoice_distributions

2757: -- Cursor to get CCID from AP_Invoice_Distributions_ID
2758: ----------------------------------------------------------------------
2759: CURSOR Bal_Seg IS
2760: SELECT dist_code_combination_id
2761: FROM ap_invoice_distributions
2762: WHERE invoice_id = P_Invoice_id;
2763:
2764: ----------------------------------------------------------------------
2765: -- Cursor to get the distinct tax codes for the given invoice

Line 2846: -- Cursor to get CCID from AP_Invoice_Distributions_ID

2842: Pre_Bal varchar2(200);
2843: counter number :=1 ;
2844:
2845: ----------------------------------------------------------------------
2846: -- Cursor to get CCID from AP_Invoice_Distributions_ID
2847: ----------------------------------------------------------------------
2848: CURSOR Bal_Seg IS
2849: SELECT dist_code_combination_id
2850: FROM ap_invoice_lines_interface

Line 3069: ap_invoice_distributions aid

3065: --------------------------------------------------------------------------
3066: SELECT NVL(sum(to_number(aid.global_attribute5)),0)
3067: INTO l_exemption_amount
3068: FROM ap_invoices ai,
3069: ap_invoice_distributions aid
3070: WHERE ai.vendor_id = P_Vendor_Id
3071: AND ai.invoice_id = aid.invoice_id
3072: AND trunc(aid.accounting_date) >= l_start_date
3073: AND trunc(aid.accounting_date) <= l_end_date