9: -- This information will be used in calculating the variances such as TIPV , TV , TERV
10:
11: TYPE Inv_ret_dists IS RECORD(
12:
13: amount ap_invoice_distributions_all.amount%TYPE,
14: retainage_rate po_lines_all.retainage_rate%TYPE,
15: retained_amount ap_invoice_distributions_all.amount%TYPE,
16: retained_invoice_dist_id ap_invoice_distributions_all.retained_invoice_dist_id%TYPE,
17: related_retainage_dist_id ap_invoice_distributions_all.related_retainage_dist_id%TYPE,
11: TYPE Inv_ret_dists IS RECORD(
12:
13: amount ap_invoice_distributions_all.amount%TYPE,
14: retainage_rate po_lines_all.retainage_rate%TYPE,
15: retained_amount ap_invoice_distributions_all.amount%TYPE,
16: retained_invoice_dist_id ap_invoice_distributions_all.retained_invoice_dist_id%TYPE,
17: related_retainage_dist_id ap_invoice_distributions_all.related_retainage_dist_id%TYPE,
18: quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE,
19: unit_price ap_invoice_distributions_all.unit_price%TYPE
12:
13: amount ap_invoice_distributions_all.amount%TYPE,
14: retainage_rate po_lines_all.retainage_rate%TYPE,
15: retained_amount ap_invoice_distributions_all.amount%TYPE,
16: retained_invoice_dist_id ap_invoice_distributions_all.retained_invoice_dist_id%TYPE,
17: related_retainage_dist_id ap_invoice_distributions_all.related_retainage_dist_id%TYPE,
18: quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE,
19: unit_price ap_invoice_distributions_all.unit_price%TYPE
20: );
13: amount ap_invoice_distributions_all.amount%TYPE,
14: retainage_rate po_lines_all.retainage_rate%TYPE,
15: retained_amount ap_invoice_distributions_all.amount%TYPE,
16: retained_invoice_dist_id ap_invoice_distributions_all.retained_invoice_dist_id%TYPE,
17: related_retainage_dist_id ap_invoice_distributions_all.related_retainage_dist_id%TYPE,
18: quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE,
19: unit_price ap_invoice_distributions_all.unit_price%TYPE
20: );
21:
14: retainage_rate po_lines_all.retainage_rate%TYPE,
15: retained_amount ap_invoice_distributions_all.amount%TYPE,
16: retained_invoice_dist_id ap_invoice_distributions_all.retained_invoice_dist_id%TYPE,
17: related_retainage_dist_id ap_invoice_distributions_all.related_retainage_dist_id%TYPE,
18: quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE,
19: unit_price ap_invoice_distributions_all.unit_price%TYPE
20: );
21:
22: TYPE ret_dists_tab IS TABLE OF Inv_ret_dists INDEX BY VARCHAR2(200); --bug14155552, changed to INDEX BY VARCHAR2 from PLS_INTEGER
15: retained_amount ap_invoice_distributions_all.amount%TYPE,
16: retained_invoice_dist_id ap_invoice_distributions_all.retained_invoice_dist_id%TYPE,
17: related_retainage_dist_id ap_invoice_distributions_all.related_retainage_dist_id%TYPE,
18: quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE,
19: unit_price ap_invoice_distributions_all.unit_price%TYPE
20: );
21:
22: TYPE ret_dists_tab IS TABLE OF Inv_ret_dists INDEX BY VARCHAR2(200); --bug14155552, changed to INDEX BY VARCHAR2 from PLS_INTEGER
23:
842: |
843: *============================================================================*/
844:
845: FUNCTION Delete_Tax_Distributions
846: (p_invoice_id IN ap_invoice_distributions_all.invoice_id%Type,
847: p_calling_mode IN VARCHAR2,
848: p_all_error_messages IN VARCHAR2,
849: p_error_code OUT NOCOPY VARCHAR2,
850: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;