676: FROM ap_invoice_distributions
677: WHERE invoice_id = P_Invoice_ID;
678: -- The following variables are used to get the information from the invoice
679: -- ditribution lines.
680: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
681: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
682: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;
683:
684: BEGIN
677: WHERE invoice_id = P_Invoice_ID;
678: -- The following variables are used to get the information from the invoice
679: -- ditribution lines.
680: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
681: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
682: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;
683:
684: BEGIN
685:
678: -- The following variables are used to get the information from the invoice
679: -- ditribution lines.
680: v_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE;
681: v_ship_to_loc ap_invoice_distributions_all.global_attribute3%TYPE;
682: v_line_type ap_invoice_distributions_all. line_type_lookup_code%TYPE;
683:
684: BEGIN
685:
686: IF p_debug_log = 'Y' THEN
722:
723: PROCEDURE Monotrib_Wh_Def_Line
724: ( p_invoice_id NUMBER,
725: p_inv_dist_id NUMBER,
726: p_tax_payer_id ap_invoice_distributions_all.global_attribute2%TYPE,
727: p_ship_to_loc VARCHAR2,
728: p_line_type VARCHAR2,
729: p_vendor_id NUMBER
730: ) IS