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 658: -- 21-JUN-05 hareesha o Bug 4284035 - Replaced pn_var_rents, pn_distributions,

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

Line 678: l_distribution_id pn_distributions.distribution_id%TYPE;

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

Line 700: FROM pn_distributions_all

696:
697: CURSOR csr_distributions (p_var_rent_id IN NUMBER)
698: IS
699: SELECT *
700: FROM pn_distributions_all
701: WHERE term_template_id = (SELECT term_template_id
702: FROM pn_var_rents_all
703: WHERE var_rent_id = p_var_rent_id);
704:

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

976: );
977:
978:
979:
980: /* Create a record in pn_distributions */
981:
982: l_distribution_count := 0;
983:
984: l_context :='opening cursor csr_distributions';

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

989: pn_variable_amount_pkg.put_log(' account_id '||rec_distributions.account_id);
990: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);
991:
992:
993: l_context := 'Inserting into pn_distributions';
994: pn_distributions_pkg.insert_row (
995: x_rowid => l_rowid
996: ,x_distribution_id => l_distribution_id
997: ,x_account_id => rec_distributions.account_id

Line 994: pn_distributions_pkg.insert_row (

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

Line 1812: l_distribution_id pn_distributions.distribution_id%TYPE;

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

Line 1821: FROM pn_distributions_all

1817:
1818: CURSOR csr_distributions
1819: IS
1820: SELECT *
1821: FROM pn_distributions_all
1822: WHERE payment_term_id = p_payment_term_id;
1823:
1824: CURSOR payment_term_cur
1825: IS

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

1929: );
1930:
1931: END LOOP;
1932:
1933: /* Create a record in pn_distributions */
1934:
1935: l_distribution_count := 0;
1936:
1937: FOR rec_distributions IN csr_distributions LOOP

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

1939: pn_variable_amount_pkg.put_log(' account_id '||rec_distributions.account_id);
1940: pn_variable_amount_pkg.put_log(' account_class '||rec_distributions.account_id);
1941:
1942:
1943: l_context := 'Inserting into pn_distributions';
1944: pn_distributions_pkg.insert_row (
1945: x_rowid => l_rowid
1946: ,x_distribution_id => l_distribution_id
1947: ,x_account_id => rec_distributions.account_id

Line 1944: pn_distributions_pkg.insert_row (

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