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

Line 872: l_created_by NUMBER := NVL(fnd_profile.value('USER_ID'), 0);

868: l_reconciled_amount pn_rec_period_lines_all.reconciled_amount%TYPE:=0;
869: l_rowId ROWID:= NULL;
870: l_rec_period_lines_id pn_rec_period_lines_all.rec_period_lines_id%TYPE := NULL;
871: l_creation_date DATE := SYSDATE;
872: l_created_by NUMBER := NVL(fnd_profile.value('USER_ID'), 0);
873: l_BUDGET_PCT NUMBER:=0;
874: l_TENANCY_START_DATE DATE;
875: l_TENANCY_END_DATE DATE;
876: l_STATUS VARCHAR2(30):=NULL;

Line 4118: l_created_by NUMBER := NVL(fnd_profile.value('USER_ID'), 0);

4114: l_is_r12 BOOLEAN := pn_r12_util_pkg.is_r12;
4115: l_dummy VARCHAR2(30);
4116:
4117: l_creation_date DATE := SYSDATE;
4118: l_created_by NUMBER := NVL(fnd_profile.value('USER_ID'), 0);
4119: l_term_date DATE; --Bug#6370014
4120:
4121: CURSOR csr_temp_dist(p_term_template_id IN NUMBER)
4122: IS

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

4459: ,x_index_term_indicator => null
4460: ,x_var_rent_inv_id => null
4461: ,x_var_rent_type => null
4462: ,x_last_update_date => SYSDATE
4463: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4464: ,x_creation_date => SYSDATE
4465: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4466: ,x_payment_purpose_code => nvl(p_billing_purpose,rec_template.payment_purpose_code)
4467: ,x_payment_term_type_code => nvl(p_billing_type,rec_template.payment_term_type_code)

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

4461: ,x_var_rent_type => null
4462: ,x_last_update_date => SYSDATE
4463: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4464: ,x_creation_date => SYSDATE
4465: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4466: ,x_payment_purpose_code => nvl(p_billing_purpose,rec_template.payment_purpose_code)
4467: ,x_payment_term_type_code => nvl(p_billing_type,rec_template.payment_term_type_code)
4468: ,x_frequency_code => l_frequency
4469: ,x_lease_id => p_lease_id

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

4473: ,x_set_of_books_id => NVL(rec_template.set_of_books_id,l_set_of_books_id)
4474: --,x_currency_code => NVL(rec_template.currency_code, l_currency_code)
4475: ,x_currency_code => g_currency_code
4476: ,x_rate => 1 -- not used in application
4477: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
4478: ,x_vendor_id => nvl(rec_template.vendor_id,rec_lease_term.vendor_id)
4479: ,x_vendor_site_id => nvl(rec_template.vendor_site_id,rec_lease_term.vendor_site_id)
4480: ,x_target_date => NULL
4481: ,x_actual_amount => l_payment_amount

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

4594: ,x_account_class => rec_distributions.account_class
4595: ,x_percentage => rec_distributions.percentage
4596: ,x_line_number => rec_distributions.line_number
4597: ,x_last_update_date => SYSDATE
4598: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4599: ,x_creation_date => SYSDATE
4600: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4601: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
4602: ,x_attribute_category => rec_distributions.attribute_category

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

4596: ,x_line_number => rec_distributions.line_number
4597: ,x_last_update_date => SYSDATE
4598: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4599: ,x_creation_date => SYSDATE
4600: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4601: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
4602: ,x_attribute_category => rec_distributions.attribute_category
4603: ,x_attribute1 => rec_distributions.attribute1
4604: ,x_attribute2 => rec_distributions.attribute2

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

4597: ,x_last_update_date => SYSDATE
4598: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4599: ,x_creation_date => SYSDATE
4600: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4601: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
4602: ,x_attribute_category => rec_distributions.attribute_category
4603: ,x_attribute1 => rec_distributions.attribute1
4604: ,x_attribute2 => rec_distributions.attribute2
4605: ,x_attribute3 => rec_distributions.attribute3

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

5296: LOOP
5297: update pn_rec_expcl_dtl_all
5298: set status = 'LOCKED',
5299: last_update_date = sysdate,
5300: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
5301: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
5302: where
5303: expense_class_dtl_id = l_exp_class_detail_rec.expense_class_dtl_id;
5304:

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

5297: update pn_rec_expcl_dtl_all
5298: set status = 'LOCKED',
5299: last_update_date = sysdate,
5300: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
5301: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
5302: where
5303: expense_class_dtl_id = l_exp_class_detail_rec.expense_class_dtl_id;
5304:
5305: END LOOP;

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

5315: LOOP
5316: update pn_rec_arcl_dtl_all
5317: set status = 'LOCKED' ,
5318: last_update_date = sysdate,
5319: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
5320: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
5321: where
5322: area_class_dtl_id = l_area_class_detail_rec.area_class_dtl_id;
5323: END LOOP;

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

5316: update pn_rec_arcl_dtl_all
5317: set status = 'LOCKED' ,
5318: last_update_date = sysdate,
5319: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
5320: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
5321: where
5322: area_class_dtl_id = l_area_class_detail_rec.area_class_dtl_id;
5323: END LOOP;
5324:

Line 5420: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),

5416: values
5417: (l_rec_calc_period_id,
5418: p_rec_agreement_id,
5419: sysdate,
5420: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
5421: sysdate,
5422: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
5423: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
5424: p_start_date,

Line 5422: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),

5418: p_rec_agreement_id,
5419: sysdate,
5420: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
5421: sysdate,
5422: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
5423: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
5424: p_start_date,
5425: p_end_date,
5426: p_as_of_date,

Line 5423: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

5419: sysdate,
5420: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
5421: sysdate,
5422: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
5423: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
5424: p_start_date,
5425: p_end_date,
5426: p_as_of_date,
5427: l_org_id