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_VARIABLE_TERM_PKG dependencies on PN_DISTRIBUTIONS

Line 662: -- 21-JUN-05 hareesha o Bug 4284035 - Replaced pn_var_rents, pn_distributions,

658: -- payment DFF of new VR term and not in AR Projects DFF
659: -- Bug # 3841542
660: -- 21-APR-05 ftanudja o Added area_type_code, area defaulting. #4324777
661: -- 15-JUL-05 ftanudja o R12 changes: add logic for tax_clsfctn_code. #4495054
662: -- 21-JUN-05 hareesha o Bug 4284035 - Replaced pn_var_rents, pn_distributions,
663: -- pn_term_templates, pn_leases with _ALL table.
664: -- 23-NOV-05 pikhar o Passed org_id in pn_mo_cache_utils.get_profile_value
665: -- 13-DEC-05 rdonthul o Changed the l_payment_term_date for bug 5700403
666: -- 15-MAR-07 pikhar o Bug 5930387. Added include_in_var_rent

Line 682: l_distribution_id pn_distributions.distribution_id%TYPE;

678: ,p_org_id IN NUMBER
679: ) IS
680:
681: l_lease_class_code pn_leases.lease_class_code%TYPE;
682: l_distribution_id pn_distributions.distribution_id%TYPE;
683: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;
684: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
685: l_rowid ROWID;
686: l_distribution_count NUMBER := 0;

Line 704: FROM pn_distributions_all

700:
701: CURSOR csr_distributions (p_var_rent_id IN NUMBER)
702: IS
703: SELECT *
704: FROM pn_distributions_all
705: WHERE term_template_id = (SELECT term_template_id
706: FROM pn_var_rents_all
707: WHERE var_rent_id = p_var_rent_id);
708:

Line 984: /* Create a record in pn_distributions */

980: );
981:
982:
983:
984: /* Create a record in pn_distributions */
985:
986: l_distribution_count := 0;
987:
988: l_context :='opening cursor csr_distributions';

Line 997: l_context := 'Inserting into pn_distributions';

993: pn_variable_amount_pkg.put_log(' account_id '||rec_distributions.account_id);
994: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);
995:
996:
997: l_context := 'Inserting into pn_distributions';
998: pn_distributions_pkg.insert_row (
999: x_rowid => l_rowid
1000: ,x_distribution_id => l_distribution_id
1001: ,x_account_id => rec_distributions.account_id

Line 998: pn_distributions_pkg.insert_row (

994: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);
995:
996:
997: l_context := 'Inserting into pn_distributions';
998: pn_distributions_pkg.insert_row (
999: x_rowid => l_rowid
1000: ,x_distribution_id => l_distribution_id
1001: ,x_account_id => rec_distributions.account_id
1002: ,x_payment_term_id => l_payment_term_id

Line 1816: l_distribution_id pn_distributions.distribution_id%TYPE;

1812: ,p_var_rent_type IN VARCHAR2
1813: ) IS
1814:
1815:
1816: l_distribution_id pn_distributions.distribution_id%TYPE;
1817: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;
1818: l_rowid ROWID;
1819: l_distribution_count NUMBER := 0;
1820: l_context varchar2(2000);

Line 1825: FROM pn_distributions_all

1821:
1822: CURSOR csr_distributions
1823: IS
1824: SELECT *
1825: FROM pn_distributions_all
1826: WHERE payment_term_id = p_payment_term_id;
1827:
1828: CURSOR payment_term_cur
1829: IS

Line 1937: /* Create a record in pn_distributions */

1933: );
1934:
1935: END LOOP;
1936:
1937: /* Create a record in pn_distributions */
1938:
1939: l_distribution_count := 0;
1940:
1941: FOR rec_distributions IN csr_distributions LOOP

Line 1947: l_context := 'Inserting into pn_distributions';

1943: pn_variable_amount_pkg.put_log(' account_id '||rec_distributions.account_id);
1944: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);
1945:
1946:
1947: l_context := 'Inserting into pn_distributions';
1948: pn_distributions_pkg.insert_row (
1949: x_rowid => l_rowid
1950: ,x_distribution_id => l_distribution_id
1951: ,x_account_id => rec_distributions.account_id

Line 1948: pn_distributions_pkg.insert_row (

1944: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);
1945:
1946:
1947: l_context := 'Inserting into pn_distributions';
1948: pn_distributions_pkg.insert_row (
1949: x_rowid => l_rowid
1950: ,x_distribution_id => l_distribution_id
1951: ,x_account_id => rec_distributions.account_id
1952: ,x_payment_term_id => l_payment_term_id