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 324: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' THEN

320:
321:
322: ELSE
323:
324: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' THEN
325: IF pn_variable_term_pkg.find_volume_continuous_for(rec_for_inv.var_rent_id,
326: rec_for_inv.period_id,
327: rec_for_inv.invoice_date,
328: 'FORECASTED'

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

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

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

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

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

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

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

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

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

415: errbuf := l_errmsg;
416:
417: ELSE
418:
419: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' THEN
420: IF pn_variable_term_pkg.find_volume_continuous_for(rec_var_inv.var_rent_id,
421: rec_var_inv.period_id,
422: rec_var_inv.invoice_date,
423: 'ACTUAL'

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

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

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

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

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

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

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

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

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

523:
524:
525: ELSE
526:
527: IF NVL(fnd_profile.value('PN_VAR_VOL_INV_PRD'),'N')='Y' THEN
528: IF pn_variable_term_pkg.find_volume_continuous(rec_act_inv.var_rent_id,
529: rec_act_inv.period_id,
530: rec_act_inv.invoice_date
531: ) = 'N' THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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