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 125: FROM pn_distributions_all pd

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

Line 5124: v_distribution_id pn_distributions.distribution_id%TYPE;

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

Line 5133: v_account_class pn_distributions.account_class%TYPE;

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

Line 5137: c_rec pn_distributions%ROWTYPE;

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

Line 5153: FROM pn_distributions_all

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

Line 5159: FROM pn_distributions_all

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

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

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

Line 5764: pn_distributions_pkg.insert_row (

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

Line 6237: DELETE FROM pn_distributions_all

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