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_OPEX_TERMS_PKG dependencies on FND_PROFILE

Line 252: --dbms_output.put_line('x_last_update_login' || NVL(fnd_profile.value('LOGIN_ID'),0));

248:
249: --dbms_output.put_line('tttttt'||agreement_rec.est_pay_freq_code);
250:
251: --dbms_output.put_line('inserting row 1');
252: --dbms_output.put_line('x_last_update_login' || NVL(fnd_profile.value('LOGIN_ID'),0));
253: --dbms_output.put_line('x_last_updated_by '|| NVL (fnd_profile.VALUE ('USER_ID'), 0));
254: --dbms_output.put_line('x_payment_purpose_code' || NVL(agreement_rec.payment_purpose_code ,template_rec.payment_purpose_code) );
255: --dbms_output.put_line('x_payment_term_type_code' || NVL(agreement_rec.payment_type_code , template_rec.payment_term_type_code));
256: --dbms_output.put_line('x_frequency_code' || NVL(agreement_rec.est_pay_freq_code , l_frequency));

Line 253: --dbms_output.put_line('x_last_updated_by '|| NVL (fnd_profile.VALUE ('USER_ID'), 0));

249: --dbms_output.put_line('tttttt'||agreement_rec.est_pay_freq_code);
250:
251: --dbms_output.put_line('inserting row 1');
252: --dbms_output.put_line('x_last_update_login' || NVL(fnd_profile.value('LOGIN_ID'),0));
253: --dbms_output.put_line('x_last_updated_by '|| NVL (fnd_profile.VALUE ('USER_ID'), 0));
254: --dbms_output.put_line('x_payment_purpose_code' || NVL(agreement_rec.payment_purpose_code ,template_rec.payment_purpose_code) );
255: --dbms_output.put_line('x_payment_term_type_code' || NVL(agreement_rec.payment_type_code , template_rec.payment_term_type_code));
256: --dbms_output.put_line('x_frequency_code' || NVL(agreement_rec.est_pay_freq_code , l_frequency));
257: --dbms_output.put_line('x_lease_id' || p_lease_id);

Line 266: pnp_debug_pkg.put_log_msg('x_last_update_login' || NVL(fnd_profile.value('LOGIN_ID'),0));

262: --dbms_output.put_line('x_set_of_books_id' || NVL(template_rec.set_of_books_id,l_set_of_books_id));
263:
264: pnp_debug_pkg.put_log_msg ('opex_create_payment_term');
265: pnp_debug_pkg.put_log_msg('inserting row 1');
266: pnp_debug_pkg.put_log_msg('x_last_update_login' || NVL(fnd_profile.value('LOGIN_ID'),0));
267: pnp_debug_pkg.put_log_msg('x_last_updated_by '|| NVL (fnd_profile.VALUE ('USER_ID'), 0));
268: pnp_debug_pkg.put_log_msg('x_payment_purpose_code' || NVL(agreement_rec.payment_purpose_code ,template_rec.payment_purpose_code) );
269: pnp_debug_pkg.put_log_msg('x_payment_term_type_code' || NVL(agreement_rec.payment_type_code , template_rec.payment_term_type_code));
270: pnp_debug_pkg.put_log_msg('x_frequency_code' || NVL(agreement_rec.est_pay_freq_code , l_frequency));

Line 267: pnp_debug_pkg.put_log_msg('x_last_updated_by '|| NVL (fnd_profile.VALUE ('USER_ID'), 0));

263:
264: pnp_debug_pkg.put_log_msg ('opex_create_payment_term');
265: pnp_debug_pkg.put_log_msg('inserting row 1');
266: pnp_debug_pkg.put_log_msg('x_last_update_login' || NVL(fnd_profile.value('LOGIN_ID'),0));
267: pnp_debug_pkg.put_log_msg('x_last_updated_by '|| NVL (fnd_profile.VALUE ('USER_ID'), 0));
268: pnp_debug_pkg.put_log_msg('x_payment_purpose_code' || NVL(agreement_rec.payment_purpose_code ,template_rec.payment_purpose_code) );
269: pnp_debug_pkg.put_log_msg('x_payment_term_type_code' || NVL(agreement_rec.payment_type_code , template_rec.payment_term_type_code));
270: pnp_debug_pkg.put_log_msg('x_frequency_code' || NVL(agreement_rec.est_pay_freq_code , l_frequency));
271: pnp_debug_pkg.put_log_msg('x_lease_id' || agreement_rec.lease_id);

Line 292: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

288: ,x_index_term_indicator => null
289: ,x_var_rent_inv_id => null
290: ,x_var_rent_type => null
291: ,x_last_update_date => SYSDATE
292: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
293: ,x_creation_date => SYSDATE
294: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
295: ,x_payment_purpose_code => NVL(agreement_rec.payment_purpose_code ,template_rec.payment_purpose_code)
296: ,x_payment_term_type_code => NVL(agreement_rec.payment_type_code , template_rec.payment_term_type_code)

Line 294: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

290: ,x_var_rent_type => null
291: ,x_last_update_date => SYSDATE
292: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
293: ,x_creation_date => SYSDATE
294: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
295: ,x_payment_purpose_code => NVL(agreement_rec.payment_purpose_code ,template_rec.payment_purpose_code)
296: ,x_payment_term_type_code => NVL(agreement_rec.payment_type_code , template_rec.payment_term_type_code)
297: ,x_frequency_code => NVL(agreement_rec.est_pay_freq_code , l_frequency)
298: ,x_lease_id => p_lease_id

Line 305: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)

301: ,x_end_date => l_payment_end_date
302: ,x_set_of_books_id => NVL(template_rec.set_of_books_id,l_set_of_books_id)
303: ,x_currency_code => l_currency_code
304: ,x_rate => 1 -- not used in application
305: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
306: ,x_vendor_id => CASE WHEN pay_term_rec.payment_term_id IS NULL THEN template_rec.vendor_id ELSE pay_term_rec.vendor_id END
307: ,x_vendor_site_id => CASE WHEN pay_term_rec.payment_term_id IS NULL THEN template_rec.vendor_site_id ELSE pay_term_rec.vendor_site_id END
308: ,x_target_date => NULL
309: ,x_actual_amount => opex_est_pay_rec.est_pmt_amount

Line 400: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

396: ,x_index_term_indicator => null
397: ,x_var_rent_inv_id => null
398: ,x_var_rent_type => null
399: ,x_last_update_date => SYSDATE
400: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
401: ,x_creation_date => SYSDATE
402: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
403: ,x_payment_purpose_code => NVL(agreement_rec.payment_purpose_code ,template_rec.payment_purpose_code)
404: ,x_payment_term_type_code => NVL(agreement_rec.payment_type_code , template_rec.payment_term_type_code)

Line 402: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

398: ,x_var_rent_type => null
399: ,x_last_update_date => SYSDATE
400: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
401: ,x_creation_date => SYSDATE
402: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
403: ,x_payment_purpose_code => NVL(agreement_rec.payment_purpose_code ,template_rec.payment_purpose_code)
404: ,x_payment_term_type_code => NVL(agreement_rec.payment_type_code , template_rec.payment_term_type_code)
405: ,x_frequency_code => 'OT'
406: ,x_lease_id => p_lease_id

Line 413: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)

409: ,x_end_date => SYSDATE -- Defaulted to sysdate for catchup terms
410: ,x_set_of_books_id => NVL(template_rec.set_of_books_id,l_set_of_books_id)
411: ,x_currency_code => l_currency_code
412: ,x_rate => 1 -- not used in application
413: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
414: ,x_vendor_id => CASE WHEN pay_term_rec.payment_term_id IS NULL THEN template_rec.vendor_id ELSE pay_term_rec.vendor_id END
415: ,x_vendor_site_id => CASE WHEN pay_term_rec.payment_term_id IS NULL THEN template_rec.vendor_site_id ELSE pay_term_rec.vendor_site_id END
416: ,x_target_date => NULL
417: ,x_actual_amount => opex_est_pay_rec.catch_up_amount

Line 514: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

510: ,x_account_class => rec_distributions.account_class
511: ,x_percentage => rec_distributions.percentage
512: ,x_line_number => rec_distributions.line_number
513: ,x_last_update_date => SYSDATE
514: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
515: ,x_creation_date => SYSDATE
516: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
517: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
518: ,x_attribute_category => rec_distributions.attribute_category

Line 516: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

512: ,x_line_number => rec_distributions.line_number
513: ,x_last_update_date => SYSDATE
514: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
515: ,x_creation_date => SYSDATE
516: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
517: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
518: ,x_attribute_category => rec_distributions.attribute_category
519: ,x_attribute1 => rec_distributions.attribute1
520: ,x_attribute2 => rec_distributions.attribute2

Line 517: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)

513: ,x_last_update_date => SYSDATE
514: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
515: ,x_creation_date => SYSDATE
516: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
517: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
518: ,x_attribute_category => rec_distributions.attribute_category
519: ,x_attribute1 => rec_distributions.attribute1
520: ,x_attribute2 => rec_distributions.attribute2
521: ,x_attribute3 => rec_distributions.attribute3

Line 559: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

555: ,x_account_class => rec_distributions.account_class
556: ,x_percentage => rec_distributions.percentage
557: ,x_line_number => rec_distributions.line_number
558: ,x_last_update_date => SYSDATE
559: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
560: ,x_creation_date => SYSDATE
561: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
562: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
563: ,x_attribute_category => rec_distributions.attribute_category

Line 561: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

557: ,x_line_number => rec_distributions.line_number
558: ,x_last_update_date => SYSDATE
559: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
560: ,x_creation_date => SYSDATE
561: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
562: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
563: ,x_attribute_category => rec_distributions.attribute_category
564: ,x_attribute1 => rec_distributions.attribute1
565: ,x_attribute2 => rec_distributions.attribute2

Line 562: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)

558: ,x_last_update_date => SYSDATE
559: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
560: ,x_creation_date => SYSDATE
561: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
562: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
563: ,x_attribute_category => rec_distributions.attribute_category
564: ,x_attribute1 => rec_distributions.attribute1
565: ,x_attribute2 => rec_distributions.attribute2
566: ,x_attribute3 => rec_distributions.attribute3

Line 847: --dbms_output.put_line('x_last_update_login' || NVL(fnd_profile.value('LOGIN_ID'),0));

843:
844: --dbms_output.put_line('tttttt'||agreement_rec.est_pay_freq_code);
845:
846: --dbms_output.put_line('inserting row 1');
847: --dbms_output.put_line('x_last_update_login' || NVL(fnd_profile.value('LOGIN_ID'),0));
848: --dbms_output.put_line('x_last_updated_by '|| NVL (fnd_profile.VALUE ('USER_ID'), 0));
849: --dbms_output.put_line('x_payment_purpose_code' || NVL(agreement_rec.payment_purpose_code ,template_rec.payment_purpose_code) );
850: --dbms_output.put_line('x_payment_term_type_code' || NVL(agreement_rec.payment_type_code , template_rec.payment_term_type_code));
851: --dbms_output.put_line('x_frequency_code' || NVL(agreement_rec.est_pay_freq_code , l_frequency));

Line 848: --dbms_output.put_line('x_last_updated_by '|| NVL (fnd_profile.VALUE ('USER_ID'), 0));

844: --dbms_output.put_line('tttttt'||agreement_rec.est_pay_freq_code);
845:
846: --dbms_output.put_line('inserting row 1');
847: --dbms_output.put_line('x_last_update_login' || NVL(fnd_profile.value('LOGIN_ID'),0));
848: --dbms_output.put_line('x_last_updated_by '|| NVL (fnd_profile.VALUE ('USER_ID'), 0));
849: --dbms_output.put_line('x_payment_purpose_code' || NVL(agreement_rec.payment_purpose_code ,template_rec.payment_purpose_code) );
850: --dbms_output.put_line('x_payment_term_type_code' || NVL(agreement_rec.payment_type_code , template_rec.payment_term_type_code));
851: --dbms_output.put_line('x_frequency_code' || NVL(agreement_rec.est_pay_freq_code , l_frequency));
852: --dbms_output.put_line('x_lease_id' || agreement_rec.lease_id);

Line 861: pnp_debug_pkg.put_log_msg('x_last_update_login' || NVL(fnd_profile.value('LOGIN_ID'),0));

857: --dbms_output.put_line('x_set_of_books_id' || NVL(template_rec.set_of_books_id,l_set_of_books_id));
858:
859: pnp_debug_pkg.put_log_msg ('opex_create_payment_term');
860: pnp_debug_pkg.put_log_msg('inserting row 1');
861: pnp_debug_pkg.put_log_msg('x_last_update_login' || NVL(fnd_profile.value('LOGIN_ID'),0));
862: pnp_debug_pkg.put_log_msg('x_last_updated_by '|| NVL (fnd_profile.VALUE ('USER_ID'), 0));
863: pnp_debug_pkg.put_log_msg('x_payment_purpose_code' || NVL(agreement_rec.payment_purpose_code ,template_rec.payment_purpose_code) );
864: pnp_debug_pkg.put_log_msg('x_payment_term_type_code' || NVL(agreement_rec.payment_type_code , template_rec.payment_term_type_code));
865: pnp_debug_pkg.put_log_msg('x_frequency_code' || NVL(agreement_rec.est_pay_freq_code , l_frequency));

Line 862: pnp_debug_pkg.put_log_msg('x_last_updated_by '|| NVL (fnd_profile.VALUE ('USER_ID'), 0));

858:
859: pnp_debug_pkg.put_log_msg ('opex_create_payment_term');
860: pnp_debug_pkg.put_log_msg('inserting row 1');
861: pnp_debug_pkg.put_log_msg('x_last_update_login' || NVL(fnd_profile.value('LOGIN_ID'),0));
862: pnp_debug_pkg.put_log_msg('x_last_updated_by '|| NVL (fnd_profile.VALUE ('USER_ID'), 0));
863: pnp_debug_pkg.put_log_msg('x_payment_purpose_code' || NVL(agreement_rec.payment_purpose_code ,template_rec.payment_purpose_code) );
864: pnp_debug_pkg.put_log_msg('x_payment_term_type_code' || NVL(agreement_rec.payment_type_code , template_rec.payment_term_type_code));
865: pnp_debug_pkg.put_log_msg('x_frequency_code' || NVL(agreement_rec.est_pay_freq_code , l_frequency));
866: pnp_debug_pkg.put_log_msg('x_lease_id' || agreement_rec.lease_id);

Line 883: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

879: ,x_index_term_indicator => null
880: ,x_var_rent_inv_id => null
881: ,x_var_rent_type => null
882: ,x_last_update_date => SYSDATE
883: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
884: ,x_creation_date => SYSDATE
885: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
886: ,x_payment_purpose_code => NVL(agreement_rec.payment_purpose_code ,template_rec.payment_purpose_code)
887: ,x_payment_term_type_code => NVL(agreement_rec.payment_type_code , template_rec.payment_term_type_code)

Line 885: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

881: ,x_var_rent_type => null
882: ,x_last_update_date => SYSDATE
883: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
884: ,x_creation_date => SYSDATE
885: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
886: ,x_payment_purpose_code => NVL(agreement_rec.payment_purpose_code ,template_rec.payment_purpose_code)
887: ,x_payment_term_type_code => NVL(agreement_rec.payment_type_code , template_rec.payment_term_type_code)
888: ,x_frequency_code => l_frequency
889: ,x_lease_id => agreement_rec.lease_id

Line 896: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)

892: ,x_end_date => l_payment_end_date
893: ,x_set_of_books_id => NVL(template_rec.set_of_books_id,l_set_of_books_id)
894: ,x_currency_code => l_currency_code
895: ,x_rate => 1 -- not used in application
896: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
897: ,x_vendor_id => CASE WHEN pay_term_rec.payment_term_id IS NULL THEN template_rec.vendor_id ELSE pay_term_rec.vendor_id END
898: ,x_vendor_site_id => CASE WHEN pay_term_rec.payment_term_id IS NULL THEN template_rec.vendor_site_id ELSE pay_term_rec.vendor_site_id END
899: ,x_target_date => NULL
900: ,x_actual_amount => p_amount

Line 996: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

992: ,x_account_class => rec_distributions.account_class
993: ,x_percentage => rec_distributions.percentage
994: ,x_line_number => rec_distributions.line_number
995: ,x_last_update_date => SYSDATE
996: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
997: ,x_creation_date => SYSDATE
998: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
999: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
1000: ,x_attribute_category => rec_distributions.attribute_category

Line 998: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

994: ,x_line_number => rec_distributions.line_number
995: ,x_last_update_date => SYSDATE
996: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
997: ,x_creation_date => SYSDATE
998: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
999: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
1000: ,x_attribute_category => rec_distributions.attribute_category
1001: ,x_attribute1 => rec_distributions.attribute1
1002: ,x_attribute2 => rec_distributions.attribute2

Line 999: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)

995: ,x_last_update_date => SYSDATE
996: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
997: ,x_creation_date => SYSDATE
998: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
999: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
1000: ,x_attribute_category => rec_distributions.attribute_category
1001: ,x_attribute1 => rec_distributions.attribute1
1002: ,x_attribute2 => rec_distributions.attribute2
1003: ,x_attribute3 => rec_distributions.attribute3

Line 2096: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)

2092:
2093: UPDATE pn_payment_terms_all
2094: SET status = 'APPROVED'
2095: ,last_update_date = SYSDATE
2096: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
2097: ,approved_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
2098: WHERE payment_term_id = ip_opex_pay_term_id;
2099:
2100: END IF;

Line 2097: ,approved_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)

2093: UPDATE pn_payment_terms_all
2094: SET status = 'APPROVED'
2095: ,last_update_date = SYSDATE
2096: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
2097: ,approved_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
2098: WHERE payment_term_id = ip_opex_pay_term_id;
2099:
2100: END IF;
2101: