APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_DISTRIBUTION_SETS

Line 18749: AP_DISTRIBUTION_SETS.TOTAL_PERCENT_DISTRIBUTION%TYPE;

18745: l_dist_set_id_per_name NUMBER(15);
18746: l_inactive_date DATE;
18747: l_inactive_date_per_name DATE;
18748: l_total_percent_distribution
18749: AP_DISTRIBUTION_SETS.TOTAL_PERCENT_DISTRIBUTION%TYPE;
18750: l_dset_lines_tab AP_IMPORT_VALIDATION_PKG.dset_line_tab_type;
18751: l_expd_item_date ap_invoice_lines.expenditure_item_date%TYPE:= '';
18752: l_error_found VARCHAR2(1);
18753: i BINARY_INTEGER := 0;

Line 18838: FROM ap_distribution_sets

18834: BEGIN
18835: IF (p_invoice_lines_rec.distribution_set_id IS NOT NULL) THEN
18836: SELECT distribution_set_id , inactive_date, total_percent_distribution
18837: INTO l_dist_set_id, l_inactive_date, l_total_percent_distribution
18838: FROM ap_distribution_sets
18839: WHERE distribution_set_id = p_invoice_lines_rec.distribution_set_id;
18840: END IF;
18841:
18842: IF (p_invoice_lines_rec.distribution_set_name IS NOT NULL) THEN

Line 18846: FROM ap_distribution_sets

18842: IF (p_invoice_lines_rec.distribution_set_name IS NOT NULL) THEN
18843: SELECT distribution_set_id , inactive_date, total_percent_distribution
18844: INTO l_dist_set_id_per_name, l_inactive_date_per_name,
18845: l_total_percent_distribution
18846: FROM ap_distribution_sets
18847: WHERE distribution_set_name
18848: = p_invoice_lines_rec.distribution_set_name;
18849: END IF;
18850: