eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_DISTRIBUTIONS

Line 126: FROM pn_distributions_all pd

122: SELECT pd.payment_term_id
123: ,pd.account_class
124: ,pd.account_id
125: ,pd.percentage
126: FROM pn_distributions_all pd
127: WHERE pd.payment_term_id = ip_payment_term_id
128: ORDER BY pd.account_class,
129: pd.account_id,
130: pd.percentage;

Line 5126: v_distribution_id pn_distributions.distribution_id%TYPE;

5122: v_attribute15 pn_term_templates.attribute15%TYPE;
5123: v_lease_termination_date pn_lease_details.lease_termination_date%TYPE;
5124: v_lease_change_id pn_lease_details.lease_change_id%TYPE;
5125: v_lease_class_code pn_leases.lease_class_code%TYPE;
5126: v_distribution_id pn_distributions.distribution_id%TYPE;
5127: v_rowid VARCHAR2 (100);
5128: v_payment_term_id pn_payment_terms.payment_term_id%TYPE;
5129: v_freq_divisor NUMBER;
5130: v_converted_amount NUMBER;

Line 5135: v_account_class pn_distributions.account_class%TYPE;

5131: v_actual_amount pn_payment_terms.actual_amount%TYPE;
5132: v_gl_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
5133: v_expense_account_id pn_lease_details.expense_account_id%TYPE;
5134: v_receivable_account_id pn_lease_details.receivable_account_id%TYPE;
5135: v_account_class pn_distributions.account_class%TYPE;
5136: v_payment_end_date DATE;
5137: v_num_years NUMBER;
5138: rec_payment_details pn_payment_terms%ROWTYPE;
5139: c_rec pn_distributions%ROWTYPE;

Line 5139: c_rec pn_distributions%ROWTYPE;

5135: v_account_class pn_distributions.account_class%TYPE;
5136: v_payment_end_date DATE;
5137: v_num_years NUMBER;
5138: rec_payment_details pn_payment_terms%ROWTYPE;
5139: c_rec pn_distributions%ROWTYPE;
5140: v_frequency_code pn_payment_terms.frequency_code%type;
5141: v_location_id pn_payment_terms.location_id%type;
5142: v_payment_start_date DATE := null;
5143: v_term_end_date DATE := null;

Line 5155: FROM pn_distributions_all

5151:
5152: CURSOR distributions (ip_term_template_id IN NUMBER)
5153: IS
5154: SELECT *
5155: FROM pn_distributions_all
5156: WHERE term_template_id = ip_term_template_id;
5157:
5158: CURSOR distributions_aggr (ip_payment_term_id IN NUMBER )
5159: IS

Line 5161: FROM pn_distributions_all

5157:
5158: CURSOR distributions_aggr (ip_payment_term_id IN NUMBER )
5159: IS
5160: SELECT *
5161: FROM pn_distributions_all
5162: WHERE payment_term_id = ip_payment_term_id;
5163:
5164: CURSOR get_location_id IS
5165: SELECT location_id

Line 5764: /* Create a record in PN_DISTRIBUTIONS table */

5760: END IF;
5761:
5762: put_log('create_payment_term_record - account_class :'||c_rec.account_class);
5763:
5764: /* Create a record in PN_DISTRIBUTIONS table */
5765:
5766: pn_distributions_pkg.insert_row (
5767: x_rowid => v_rowid
5768: ,x_distribution_id => v_distribution_id

Line 5766: pn_distributions_pkg.insert_row (

5762: put_log('create_payment_term_record - account_class :'||c_rec.account_class);
5763:
5764: /* Create a record in PN_DISTRIBUTIONS table */
5765:
5766: pn_distributions_pkg.insert_row (
5767: x_rowid => v_rowid
5768: ,x_distribution_id => v_distribution_id
5769: ,x_account_id => c_rec.account_id
5770: ,x_payment_term_id => v_payment_term_id

Line 6239: DELETE FROM pn_distributions_all

6235: DELETE FROM pn_index_lease_terms_all ilt
6236: WHERE ilt.index_period_id = c_rec.index_period_id
6237: AND ilt.approved_flag <> c_payment_term_status_approved ;
6238:
6239: DELETE FROM pn_distributions_all
6240: WHERE payment_term_id IN (SELECT payment_term_id
6241: FROM pn_payment_terms_all ppt
6242: WHERE ppt.index_period_id = c_rec.index_period_id
6243: AND ppt.status <> c_payment_term_status_approved);