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 FND_PROFILE

Line 328: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' THEN

324:
325:
326: ELSE
327:
328: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' THEN
329: IF pn_variable_term_pkg.find_volume_continuous_for(rec_for_inv.var_rent_id,
330: rec_for_inv.period_id,
331: rec_for_inv.invoice_date,
332: 'FORECASTED'

Line 373: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),

369: IF term_count > 0 THEN
370: UPDATE pn_var_rent_inv_all
371: SET forecasted_term_status='Y',
372: last_update_date = SYSDATE,
373: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
374: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
375: WHERE var_rent_inv_id = rec_for_inv.var_rent_inv_id;
376: ELSE
377: pn_variable_amount_pkg.put_log('term not found ...');

Line 374: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

370: UPDATE pn_var_rent_inv_all
371: SET forecasted_term_status='Y',
372: last_update_date = SYSDATE,
373: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
374: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
375: WHERE var_rent_inv_id = rec_for_inv.var_rent_inv_id;
376: ELSE
377: pn_variable_amount_pkg.put_log('term not found ...');
378: UPDATE pn_var_rent_inv_all

Line 381: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),

377: pn_variable_amount_pkg.put_log('term not found ...');
378: UPDATE pn_var_rent_inv_all
379: SET forecasted_term_status='N',
380: last_update_date = SYSDATE,
381: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
382: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
383: WHERE var_rent_inv_id = rec_for_inv.var_rent_inv_id;
384: END IF;
385:

Line 382: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

378: UPDATE pn_var_rent_inv_all
379: SET forecasted_term_status='N',
380: last_update_date = SYSDATE,
381: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
382: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
383: WHERE var_rent_inv_id = rec_for_inv.var_rent_inv_id;
384: END IF;
385:
386: END IF;

Line 423: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' THEN

419: errbuf := l_errmsg;
420:
421: ELSE
422:
423: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' THEN
424: IF pn_variable_term_pkg.find_volume_continuous_for(rec_var_inv.var_rent_id,
425: rec_var_inv.period_id,
426: rec_var_inv.invoice_date,
427: 'ACTUAL'

Line 471: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),

467: IF term_count > 0 THEN
468: UPDATE pn_var_rent_inv_all
469: SET variance_term_status='Y',
470: last_update_date = SYSDATE,
471: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
472: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
473: WHERE var_rent_inv_id = rec_var_inv.var_rent_inv_id;
474:
475: UPDATE pn_var_rent_inv_all

Line 472: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

468: UPDATE pn_var_rent_inv_all
469: SET variance_term_status='Y',
470: last_update_date = SYSDATE,
471: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
472: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
473: WHERE var_rent_inv_id = rec_var_inv.var_rent_inv_id;
474:
475: UPDATE pn_var_rent_inv_all
476: SET true_up_status = 'Y'

Line 485: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),

481: pn_variable_amount_pkg.put_log('term not found ...');
482: UPDATE pn_var_rent_inv_all
483: SET variance_term_status='N',
484: last_update_date = SYSDATE,
485: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
486: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
487: WHERE var_rent_inv_id = rec_var_inv.var_rent_inv_id;
488:
489: UPDATE pn_var_rent_inv_all

Line 486: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

482: UPDATE pn_var_rent_inv_all
483: SET variance_term_status='N',
484: last_update_date = SYSDATE,
485: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
486: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
487: WHERE var_rent_inv_id = rec_var_inv.var_rent_inv_id;
488:
489: UPDATE pn_var_rent_inv_all
490: SET true_up_status = 'N'

Line 531: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' and (l_trmn_dt >= rec_act_inv.invoice_date) THEN /* 9094493 */

527:
528:
529: ELSE
530:
531: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' and (l_trmn_dt >= rec_act_inv.invoice_date) THEN /* 9094493 */
532: IF pn_variable_term_pkg.find_volume_continuous(rec_act_inv.var_rent_id,
533: rec_act_inv.period_id,
534: rec_act_inv.invoice_date
535: ) = 'N' THEN

Line 580: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),

576: IF term_count > 0 THEN
577: UPDATE pn_var_rent_inv_all
578: SET actual_term_status='Y',
579: last_update_date = SYSDATE,
580: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
581: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
582: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id;
583:
584: UPDATE pn_var_rent_inv_all

Line 581: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

577: UPDATE pn_var_rent_inv_all
578: SET actual_term_status='Y',
579: last_update_date = SYSDATE,
580: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
581: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
582: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id;
583:
584: UPDATE pn_var_rent_inv_all
585: SET true_up_status = 'Y'

Line 594: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),

590: pn_variable_amount_pkg.put_log('term not found ...');
591: UPDATE pn_var_rent_inv_all
592: SET actual_term_status='N',
593: last_update_date = SYSDATE,
594: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
595: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
596: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id;
597:
598: UPDATE pn_var_rent_inv_all

Line 595: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

591: UPDATE pn_var_rent_inv_all
592: SET actual_term_status='N',
593: last_update_date = SYSDATE,
594: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
595: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
596: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id;
597:
598: UPDATE pn_var_rent_inv_all
599: SET true_up_status = 'N'

Line 612: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),

608: ,p_var_rent_type => 'ADJUSTMENT');
609: UPDATE pn_var_rent_inv_all
610: SET actual_term_status='Y',
611: last_update_date = SYSDATE,
612: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
613: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
614: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id
615: AND actual_term_status='N' ;
616:

Line 613: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

609: UPDATE pn_var_rent_inv_all
610: SET actual_term_status='Y',
611: last_update_date = SYSDATE,
612: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
613: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
614: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id
615: AND actual_term_status='N' ;
616:
617: END LOOP;

Line 652: -- 18-SEP-02 ftanudja o changed call from fnd_profile.value('PN_SET_OF..')

648: -- 22-Feb-02 o Added parameter x_calling_form in the call to
649: -- pnt_payment_terms_cpg.
650: -- 28-Jun-02 o Added parameter p_org_id for shared serv.
651: -- Enhancement.
652: -- 18-SEP-02 ftanudja o changed call from fnd_profile.value('PN_SET_OF..')
653: -- to pn_mo_cache_utils.get_profile_value('PN_SET_OF..')
654: -- 14-JUN-04 abanerje o Modified call to pnt_payment_terms_pkg.insert_row
655: -- to populate the term_template_id also. Bug#3657130.
656: -- 15-SEP-04 atuppad o In the call pnt_payment_terms_pkg.insert_row,

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

892: ,x_index_term_indicator => null
893: ,x_var_rent_inv_id => p_var_rent_inv_id
894: ,x_var_rent_type => p_var_rent_type
895: ,x_last_update_date => SYSDATE
896: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
897: ,x_creation_date => SYSDATE
898: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
899: ,x_payment_purpose_code => rec_template.payment_purpose_code
900: ,x_payment_term_type_code => rec_template.payment_term_type_code

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

894: ,x_var_rent_type => p_var_rent_type
895: ,x_last_update_date => SYSDATE
896: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
897: ,x_creation_date => SYSDATE
898: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
899: ,x_payment_purpose_code => rec_template.payment_purpose_code
900: ,x_payment_term_type_code => rec_template.payment_term_type_code
901: ,x_frequency_code => l_frequency
902: ,x_lease_id => p_lease_id

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

906: ,x_set_of_books_id => NVL(rec_template.set_of_books_id,l_set_of_books_id)
907: --,x_currency_code => NVL(rec_template.currency_code, l_currency_code)
908: ,x_currency_code => NVl(g_currency_code, l_currency_code)
909: ,x_rate => 1 -- not used in application
910: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
911: ,x_vendor_id => rec_template.vendor_id
912: ,x_vendor_site_id => rec_template.vendor_site_id
913: ,x_target_date => NULL
914: ,x_actual_amount => p_payment_amount

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

1004: ,x_account_class => rec_distributions.account_class
1005: ,x_percentage => rec_distributions.percentage
1006: ,x_line_number => rec_distributions.line_number
1007: ,x_last_update_date => SYSDATE
1008: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1009: ,x_creation_date => SYSDATE
1010: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1011: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
1012: ,x_attribute_category => rec_distributions.attribute_category

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

1006: ,x_line_number => rec_distributions.line_number
1007: ,x_last_update_date => SYSDATE
1008: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1009: ,x_creation_date => SYSDATE
1010: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1011: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
1012: ,x_attribute_category => rec_distributions.attribute_category
1013: ,x_attribute1 => rec_distributions.attribute1
1014: ,x_attribute2 => rec_distributions.attribute2

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

1007: ,x_last_update_date => SYSDATE
1008: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1009: ,x_creation_date => SYSDATE
1010: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1011: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
1012: ,x_attribute_category => rec_distributions.attribute_category
1013: ,x_attribute1 => rec_distributions.attribute1
1014: ,x_attribute2 => rec_distributions.attribute2
1015: ,x_attribute3 => rec_distributions.attribute3

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

1846: ,x_index_term_indicator => payment_term_rec.index_term_indicator
1847: ,x_var_rent_inv_id => p_var_rent_inv_id
1848: ,x_var_rent_type => p_var_rent_type
1849: ,x_last_update_date => SYSDATE
1850: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1851: ,x_creation_date => SYSDATE
1852: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1853: ,x_payment_purpose_code => payment_term_rec.payment_purpose_code
1854: ,x_payment_term_type_code => payment_term_rec.payment_term_type_code

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

1848: ,x_var_rent_type => p_var_rent_type
1849: ,x_last_update_date => SYSDATE
1850: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1851: ,x_creation_date => SYSDATE
1852: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1853: ,x_payment_purpose_code => payment_term_rec.payment_purpose_code
1854: ,x_payment_term_type_code => payment_term_rec.payment_term_type_code
1855: ,x_frequency_code => payment_term_rec.frequency_code
1856: ,x_lease_id => payment_term_rec.lease_id

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

1859: ,x_end_date => payment_term_rec.end_date
1860: ,x_set_of_books_id => payment_term_rec.set_of_books_id
1861: ,x_currency_code => payment_term_rec.currency_code
1862: ,x_rate => payment_term_rec.rate
1863: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
1864: ,x_vendor_id => payment_term_rec.vendor_id
1865: ,x_vendor_site_id => payment_term_rec.vendor_site_id
1866: ,x_target_date => NULL
1867: ,x_actual_amount => -(payment_term_rec.actual_amount)

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

1954: ,x_account_class => rec_distributions.account_class
1955: ,x_percentage => rec_distributions.percentage
1956: ,x_line_number => rec_distributions.line_number
1957: ,x_last_update_date => SYSDATE
1958: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1959: ,x_creation_date => SYSDATE
1960: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1961: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
1962: ,x_attribute_category => rec_distributions.attribute_category

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

1956: ,x_line_number => rec_distributions.line_number
1957: ,x_last_update_date => SYSDATE
1958: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1959: ,x_creation_date => SYSDATE
1960: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1961: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
1962: ,x_attribute_category => rec_distributions.attribute_category
1963: ,x_attribute1 => rec_distributions.attribute1
1964: ,x_attribute2 => rec_distributions.attribute2

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

1957: ,x_last_update_date => SYSDATE
1958: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1959: ,x_creation_date => SYSDATE
1960: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
1961: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
1962: ,x_attribute_category => rec_distributions.attribute_category
1963: ,x_attribute1 => rec_distributions.attribute1
1964: ,x_attribute2 => rec_distributions.attribute2
1965: ,x_attribute3 => rec_distributions.attribute3