37: PROCEDURE create_prepay_lines(p_packet_id IN NUMBER,
38: p_status OUT NOCOPY NUMBER);
39: --------------------------------------------------------------------------------
40: TYPE r_dist_info IS RECORD
41: (invoice_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE
42: ,item_amount ap_invoice_distributions.amount%TYPE);
43:
44: TYPE r_prorate_info IS RECORD
45: (invoice_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE
38: p_status OUT NOCOPY NUMBER);
39: --------------------------------------------------------------------------------
40: TYPE r_dist_info IS RECORD
41: (invoice_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE
42: ,item_amount ap_invoice_distributions.amount%TYPE);
43:
44: TYPE r_prorate_info IS RECORD
45: (invoice_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE
46: ,prorated_amount ap_invoice_distributions.amount%TYPE
41: (invoice_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE
42: ,item_amount ap_invoice_distributions.amount%TYPE);
43:
44: TYPE r_prorate_info IS RECORD
45: (invoice_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE
46: ,prorated_amount ap_invoice_distributions.amount%TYPE
47: ,ussgl_transaction_code ap_invoice_distributions.ussgl_transaction_code%TYPE
48: ,code_combination_id ap_invoice_distributions.dist_code_combination_id%TYPE );
49:
42: ,item_amount ap_invoice_distributions.amount%TYPE);
43:
44: TYPE r_prorate_info IS RECORD
45: (invoice_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE
46: ,prorated_amount ap_invoice_distributions.amount%TYPE
47: ,ussgl_transaction_code ap_invoice_distributions.ussgl_transaction_code%TYPE
48: ,code_combination_id ap_invoice_distributions.dist_code_combination_id%TYPE );
49:
50: TYPE prorate_amt_tab IS TABLE OF r_prorate_info
43:
44: TYPE r_prorate_info IS RECORD
45: (invoice_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE
46: ,prorated_amount ap_invoice_distributions.amount%TYPE
47: ,ussgl_transaction_code ap_invoice_distributions.ussgl_transaction_code%TYPE
48: ,code_combination_id ap_invoice_distributions.dist_code_combination_id%TYPE );
49:
50: TYPE prorate_amt_tab IS TABLE OF r_prorate_info
51: INDEX BY BINARY_INTEGER;
44: TYPE r_prorate_info IS RECORD
45: (invoice_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE
46: ,prorated_amount ap_invoice_distributions.amount%TYPE
47: ,ussgl_transaction_code ap_invoice_distributions.ussgl_transaction_code%TYPE
48: ,code_combination_id ap_invoice_distributions.dist_code_combination_id%TYPE );
49:
50: TYPE prorate_amt_tab IS TABLE OF r_prorate_info
51: INDEX BY BINARY_INTEGER;
52: