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 847: l_created_by NUMBER := NVL(fnd_profile.value('USER_ID'), 0);

843: l_reconciled_amount pn_rec_period_lines_all.reconciled_amount%TYPE:=0;
844: l_rowId ROWID:= NULL;
845: l_rec_period_lines_id pn_rec_period_lines_all.rec_period_lines_id%TYPE := NULL;
846: l_creation_date DATE := SYSDATE;
847: l_created_by NUMBER := NVL(fnd_profile.value('USER_ID'), 0);
848: l_BUDGET_PCT NUMBER:=0;
849: l_TENANCY_START_DATE DATE;
850: l_TENANCY_END_DATE DATE;
851: l_STATUS VARCHAR2(30):=NULL;

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

4029: l_is_r12 BOOLEAN := pn_r12_util_pkg.is_r12;
4030: l_dummy VARCHAR2(30);
4031:
4032: l_creation_date DATE := SYSDATE;
4033: l_created_by NUMBER := NVL(fnd_profile.value('USER_ID'), 0);
4034: l_term_date DATE; --Bug#6370014
4035:
4036: CURSOR csr_temp_dist(p_term_template_id IN NUMBER)
4037: IS

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

4374: ,x_index_term_indicator => null
4375: ,x_var_rent_inv_id => null
4376: ,x_var_rent_type => null
4377: ,x_last_update_date => SYSDATE
4378: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4379: ,x_creation_date => SYSDATE
4380: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4381: ,x_payment_purpose_code => nvl(p_billing_purpose,rec_template.payment_purpose_code)
4382: ,x_payment_term_type_code => nvl(p_billing_type,rec_template.payment_term_type_code)

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

4376: ,x_var_rent_type => null
4377: ,x_last_update_date => SYSDATE
4378: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4379: ,x_creation_date => SYSDATE
4380: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4381: ,x_payment_purpose_code => nvl(p_billing_purpose,rec_template.payment_purpose_code)
4382: ,x_payment_term_type_code => nvl(p_billing_type,rec_template.payment_term_type_code)
4383: ,x_frequency_code => l_frequency
4384: ,x_lease_id => p_lease_id

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

4388: ,x_set_of_books_id => NVL(rec_template.set_of_books_id,l_set_of_books_id)
4389: --,x_currency_code => NVL(rec_template.currency_code, l_currency_code)
4390: ,x_currency_code => g_currency_code
4391: ,x_rate => 1 -- not used in application
4392: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
4393: ,x_vendor_id => nvl(rec_template.vendor_id,rec_lease_term.vendor_id)
4394: ,x_vendor_site_id => nvl(rec_template.vendor_site_id,rec_lease_term.vendor_site_id)
4395: ,x_target_date => NULL
4396: ,x_actual_amount => l_payment_amount

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

4509: ,x_account_class => rec_distributions.account_class
4510: ,x_percentage => rec_distributions.percentage
4511: ,x_line_number => rec_distributions.line_number
4512: ,x_last_update_date => SYSDATE
4513: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4514: ,x_creation_date => SYSDATE
4515: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4516: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
4517: ,x_attribute_category => rec_distributions.attribute_category

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

4511: ,x_line_number => rec_distributions.line_number
4512: ,x_last_update_date => SYSDATE
4513: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4514: ,x_creation_date => SYSDATE
4515: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4516: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
4517: ,x_attribute_category => rec_distributions.attribute_category
4518: ,x_attribute1 => rec_distributions.attribute1
4519: ,x_attribute2 => rec_distributions.attribute2

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

4512: ,x_last_update_date => SYSDATE
4513: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4514: ,x_creation_date => SYSDATE
4515: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
4516: ,x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0)
4517: ,x_attribute_category => rec_distributions.attribute_category
4518: ,x_attribute1 => rec_distributions.attribute1
4519: ,x_attribute2 => rec_distributions.attribute2
4520: ,x_attribute3 => rec_distributions.attribute3

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

5211: LOOP
5212: update pn_rec_expcl_dtl_all
5213: set status = 'LOCKED',
5214: last_update_date = sysdate,
5215: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
5216: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
5217: where
5218: expense_class_dtl_id = l_exp_class_detail_rec.expense_class_dtl_id;
5219:

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

5212: update pn_rec_expcl_dtl_all
5213: set status = 'LOCKED',
5214: last_update_date = sysdate,
5215: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
5216: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
5217: where
5218: expense_class_dtl_id = l_exp_class_detail_rec.expense_class_dtl_id;
5219:
5220: END LOOP;

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

5230: LOOP
5231: update pn_rec_arcl_dtl_all
5232: set status = 'LOCKED' ,
5233: last_update_date = sysdate,
5234: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
5235: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
5236: where
5237: area_class_dtl_id = l_area_class_detail_rec.area_class_dtl_id;
5238: END LOOP;

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

5231: update pn_rec_arcl_dtl_all
5232: set status = 'LOCKED' ,
5233: last_update_date = sysdate,
5234: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
5235: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
5236: where
5237: area_class_dtl_id = l_area_class_detail_rec.area_class_dtl_id;
5238: END LOOP;
5239:

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

5331: values
5332: (l_rec_calc_period_id,
5333: p_rec_agreement_id,
5334: sysdate,
5335: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
5336: sysdate,
5337: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
5338: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
5339: p_start_date,

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

5333: p_rec_agreement_id,
5334: sysdate,
5335: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
5336: sysdate,
5337: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
5338: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
5339: p_start_date,
5340: p_end_date,
5341: p_as_of_date,

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

5334: sysdate,
5335: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
5336: sysdate,
5337: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
5338: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
5339: p_start_date,
5340: p_end_date,
5341: p_as_of_date,
5342: l_org_id