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

Line 295: p_created_by NUMBER := NVL (fnd_profile.VALUE ('USER_ID'), 0);

291: WHERE var_rent_id = p_var_rent_id;
292:
293:
294: p_creation_date DATE := SYSDATE;
295: p_created_by NUMBER := NVL (fnd_profile.VALUE ('USER_ID'), 0);
296: l_group_frequency NUMBER := NULL;
297: l_report_frequency NUMBER := NULL;
298: l_report_date_id NUMBER := NULL;
299: l_row_id VARCHAR2(18) := NULL;

Line 870: p_created_by NUMBER := NVL (fnd_profile.VALUE ('USER_ID'), 0);

866: p_create_flag IN VARCHAR2 DEFAULT 'Y' )
867: IS
868:
869: p_creation_date DATE := SYSDATE;
870: p_created_by NUMBER := NVL (fnd_profile.VALUE ('USER_ID'), 0);
871: p_cal_start_date DATE := TO_DATE('01/01/1776','mm/dd/yyyy'); --dates from calendar
872: p_cal_end_date DATE := TO_DATE('01/01/1776','mm/dd/yyyy'); --dates from calendar
873: p_cal_start_date_orig DATE := TO_DATE('01/01/1776','mm/dd/yyyy');
874: -- to later update start date if date set up in calendar is different from

Line 2180: l_created_by NUMBER := NVL (fnd_profile.VALUE ('USER_ID'), 0);

2176: l_periodId NUMBER := NULL;
2177: l_grpDateId NUMBER := NULL;
2178: l_periodNum NUMBER := NULL;
2179: l_creation_date DATE := sysdate;
2180: l_created_by NUMBER := NVL (fnd_profile.VALUE ('USER_ID'), 0);
2181: l_partial_period VARCHAR2(1) := NULL;
2182: l_period_exists VARCHAR2(1) := 'N';
2183: l_proration_factor NUMBER;
2184:

Line 2837: p_last_updated_by NUMBER := NVL (fnd_profile.VALUE ('USER_ID'), 0);

2833: PROCEDURE UPDATE_VAR_RENT_PERIODS(p_var_rent_id IN NUMBER,
2834: p_term_date IN DATE ) IS
2835:
2836: p_last_update_date DATE := SYSDATE;
2837: p_last_updated_by NUMBER := NVL (fnd_profile.VALUE ('USER_ID'), 0);
2838: p_per_start_date DATE := TO_DATE('01/01/1776','mm/dd/yyyy');
2839: p_per_end_date DATE := TO_DATE('01/01/1776','mm/dd/yyyy');
2840: p_grp_start_date DATE := TO_DATE('01/01/1776','mm/dd/yyyy');
2841: p_grp_end_date DATE := TO_DATE('01/01/1776','mm/dd/yyyy');

Line 6930: x_created_by => NVL(FND_PROFILE.VALUE('USER_ID'),1),

6926: x_actual_exp_code => 'N',
6927: x_forecasted_exp_code => 'N',
6928: x_variance_exp_code => 'N',
6929: x_creation_date => SYSDATE,
6930: x_created_by => NVL(FND_PROFILE.VALUE('USER_ID'),1),
6931: x_last_update_date => SYSDATE,
6932: x_last_updated_by => NVL(FND_PROFILE.VALUE('USER_ID'),1),
6933: x_last_update_login => NVL(FND_PROFILE.VALUE('USER_ID'),1));
6934:

Line 6932: x_last_updated_by => NVL(FND_PROFILE.VALUE('USER_ID'),1),

6928: x_variance_exp_code => 'N',
6929: x_creation_date => SYSDATE,
6930: x_created_by => NVL(FND_PROFILE.VALUE('USER_ID'),1),
6931: x_last_update_date => SYSDATE,
6932: x_last_updated_by => NVL(FND_PROFILE.VALUE('USER_ID'),1),
6933: x_last_update_login => NVL(FND_PROFILE.VALUE('USER_ID'),1));
6934:
6935: l_rowId := NULL;
6936: l_grpDateId := NULL;

Line 6933: x_last_update_login => NVL(FND_PROFILE.VALUE('USER_ID'),1));

6929: x_creation_date => SYSDATE,
6930: x_created_by => NVL(FND_PROFILE.VALUE('USER_ID'),1),
6931: x_last_update_date => SYSDATE,
6932: x_last_updated_by => NVL(FND_PROFILE.VALUE('USER_ID'),1),
6933: x_last_update_login => NVL(FND_PROFILE.VALUE('USER_ID'),1));
6934:
6935: l_rowId := NULL;
6936: l_grpDateId := NULL;
6937: END IF;

Line 8216: x_created_by => nvl(fnd_profile.value('user_id'),1),

8212: x_attribute13 => rent_inv_rec.attribute13,
8213: x_attribute14 => rent_inv_rec.attribute14,
8214: x_attribute15 => rent_inv_rec.attribute15,
8215: x_creation_date => l_date,
8216: x_created_by => nvl(fnd_profile.value('user_id'),1),
8217: x_last_update_date => l_date,
8218: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
8219: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
8220: x_true_up_amount => rent_inv_rec.true_up_amt,

Line 8218: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),

8214: x_attribute15 => rent_inv_rec.attribute15,
8215: x_creation_date => l_date,
8216: x_created_by => nvl(fnd_profile.value('user_id'),1),
8217: x_last_update_date => l_date,
8218: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
8219: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
8220: x_true_up_amount => rent_inv_rec.true_up_amt,
8221: x_true_up_status => rent_inv_rec.true_up_status,
8222: x_true_up_exp_code => rent_inv_rec.true_up_exp_code,

Line 8219: x_last_update_login => nvl(fnd_profile.value('user_id'),1),

8215: x_creation_date => l_date,
8216: x_created_by => nvl(fnd_profile.value('user_id'),1),
8217: x_last_update_date => l_date,
8218: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
8219: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
8220: x_true_up_amount => rent_inv_rec.true_up_amt,
8221: x_true_up_status => rent_inv_rec.true_up_status,
8222: x_true_up_exp_code => rent_inv_rec.true_up_exp_code,
8223: x_org_id => rent_inv_rec.org_id);

Line 8720: x_created_by => nvl(fnd_profile.value('user_id'),1),

8716: x_attribute13 => invoice_rec.attribute13,
8717: x_attribute14 => invoice_rec.attribute14,
8718: x_attribute15 => invoice_rec.attribute15,
8719: x_creation_date => l_date,
8720: x_created_by => nvl(fnd_profile.value('user_id'),1),
8721: x_last_update_date => l_date,
8722: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
8723: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
8724: x_true_up_amount => invoice_rec.true_up_amt,

Line 8722: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),

8718: x_attribute15 => invoice_rec.attribute15,
8719: x_creation_date => l_date,
8720: x_created_by => nvl(fnd_profile.value('user_id'),1),
8721: x_last_update_date => l_date,
8722: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
8723: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
8724: x_true_up_amount => invoice_rec.true_up_amt,
8725: x_true_up_status => invoice_rec.true_up_status,
8726: x_true_up_exp_code => invoice_rec.true_up_exp_code,

Line 8723: x_last_update_login => nvl(fnd_profile.value('user_id'),1),

8719: x_creation_date => l_date,
8720: x_created_by => nvl(fnd_profile.value('user_id'),1),
8721: x_last_update_date => l_date,
8722: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
8723: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
8724: x_true_up_amount => invoice_rec.true_up_amt,
8725: x_true_up_status => invoice_rec.true_up_status,
8726: x_true_up_exp_code => invoice_rec.true_up_exp_code,
8727: x_org_id => invoice_rec.org_id);

Line 9427: x_created_by => NVL(fnd_profile.value('USER_ID'),0),

9423: x_attribute14 => line_rec.attribute14,
9424: x_attribute15 => line_rec.attribute15,
9425: x_org_id => line_rec.org_id,
9426: x_creation_date => sysdate,
9427: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
9428: x_last_update_date => sysdate,
9429: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
9430: x_last_update_login => NVL(fnd_profile.value('USER_ID'),0),
9431: x_line_template_id => line_rec.line_template_id,

Line 9429: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),

9425: x_org_id => line_rec.org_id,
9426: x_creation_date => sysdate,
9427: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
9428: x_last_update_date => sysdate,
9429: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
9430: x_last_update_login => NVL(fnd_profile.value('USER_ID'),0),
9431: x_line_template_id => line_rec.line_template_id,
9432: x_agreement_template_id => line_rec.agreement_template_id,
9433: x_line_default_id => line_rec.line_default_id,

Line 9430: x_last_update_login => NVL(fnd_profile.value('USER_ID'),0),

9426: x_creation_date => sysdate,
9427: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
9428: x_last_update_date => sysdate,
9429: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
9430: x_last_update_login => NVL(fnd_profile.value('USER_ID'),0),
9431: x_line_template_id => line_rec.line_template_id,
9432: x_agreement_template_id => line_rec.agreement_template_id,
9433: x_line_default_id => line_rec.line_default_id,
9434: x_var_rent_id => p_var_rent_id);

Line 9472: x_created_by => NVL(fnd_profile.value('USER_ID'),0),

9468: x_attribute14 => bkpt_head_rec.attribute14,
9469: x_attribute15 => bkpt_head_rec.attribute15,
9470: x_org_id => bkpt_head_rec.org_id,
9471: x_creation_date => sysdate,
9472: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
9473: x_last_update_date => sysdate,
9474: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
9475: x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0));
9476:

Line 9474: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),

9470: x_org_id => bkpt_head_rec.org_id,
9471: x_creation_date => sysdate,
9472: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
9473: x_last_update_date => sysdate,
9474: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
9475: x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0));
9476:
9477: pnp_debug_pkg.debug ('breakpoint header inserted is l_bkpt_header_id ..'||l_bkpt_header_id);
9478:

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

9471: x_creation_date => sysdate,
9472: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
9473: x_last_update_date => sysdate,
9474: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
9475: x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0));
9476:
9477: pnp_debug_pkg.debug ('breakpoint header inserted is l_bkpt_header_id ..'||l_bkpt_header_id);
9478:
9479: /* Generate the breakpoint details associated with this breakpoint header */

Line 9517: x_created_by => nvl(fnd_profile.value('user_id'),0),

9513: x_attribute14 => bkpt_detail_rec.attribute14,
9514: x_attribute15 => bkpt_detail_rec.attribute15,
9515: x_org_id => bkpt_detail_rec.org_id,
9516: x_creation_date => sysdate,
9517: x_created_by => nvl(fnd_profile.value('user_id'),0),
9518: x_last_update_date => sysdate,
9519: x_last_updated_by => nvl(fnd_profile.value('user_id'),0),
9520: x_last_update_login => nvl(fnd_profile.value('user_id'),0),
9521: x_annual_basis_amount => bkpt_detail_rec.annual_basis_amount

Line 9519: x_last_updated_by => nvl(fnd_profile.value('user_id'),0),

9515: x_org_id => bkpt_detail_rec.org_id,
9516: x_creation_date => sysdate,
9517: x_created_by => nvl(fnd_profile.value('user_id'),0),
9518: x_last_update_date => sysdate,
9519: x_last_updated_by => nvl(fnd_profile.value('user_id'),0),
9520: x_last_update_login => nvl(fnd_profile.value('user_id'),0),
9521: x_annual_basis_amount => bkpt_detail_rec.annual_basis_amount
9522: );
9523:

Line 9520: x_last_update_login => nvl(fnd_profile.value('user_id'),0),

9516: x_creation_date => sysdate,
9517: x_created_by => nvl(fnd_profile.value('user_id'),0),
9518: x_last_update_date => sysdate,
9519: x_last_updated_by => nvl(fnd_profile.value('user_id'),0),
9520: x_last_update_login => nvl(fnd_profile.value('user_id'),0),
9521: x_annual_basis_amount => bkpt_detail_rec.annual_basis_amount
9522: );
9523:
9524: pnp_debug_pkg.debug ('breakpoint detail inserted is l_bkpt_detail_id ..'||l_bkpt_detail_id);

Line 9573: x_created_by => nvl(fnd_profile.value('user_id'),0),

9569: x_attribute14 => constraint_rec.attribute14,
9570: x_attribute15 => constraint_rec.attribute15,
9571: x_org_id => constraint_rec.org_id,
9572: x_creation_date => sysdate,
9573: x_created_by => nvl(fnd_profile.value('user_id'),0),
9574: x_last_update_date => sysdate,
9575: x_last_updated_by => nvl(fnd_profile.value('user_id'),0),
9576: x_last_update_login => nvl(fnd_profile.value('user_id'),0),
9577: x_constr_start_date => period_rec.start_date,

Line 9575: x_last_updated_by => nvl(fnd_profile.value('user_id'),0),

9571: x_org_id => constraint_rec.org_id,
9572: x_creation_date => sysdate,
9573: x_created_by => nvl(fnd_profile.value('user_id'),0),
9574: x_last_update_date => sysdate,
9575: x_last_updated_by => nvl(fnd_profile.value('user_id'),0),
9576: x_last_update_login => nvl(fnd_profile.value('user_id'),0),
9577: x_constr_start_date => period_rec.start_date,
9578: x_constr_end_date => period_rec.end_date);
9579: END LOOP;

Line 9576: x_last_update_login => nvl(fnd_profile.value('user_id'),0),

9572: x_creation_date => sysdate,
9573: x_created_by => nvl(fnd_profile.value('user_id'),0),
9574: x_last_update_date => sysdate,
9575: x_last_updated_by => nvl(fnd_profile.value('user_id'),0),
9576: x_last_update_login => nvl(fnd_profile.value('user_id'),0),
9577: x_constr_start_date => period_rec.start_date,
9578: x_constr_end_date => period_rec.end_date);
9579: END LOOP;
9580:

Line 9796: x_created_by => nvl(fnd_profile.value('user_id'),1),

9792: x_attribute13 => invoice_rec.attribute13,
9793: x_attribute14 => invoice_rec.attribute14,
9794: x_attribute15 => invoice_rec.attribute15,
9795: x_creation_date => SYSDATE,
9796: x_created_by => nvl(fnd_profile.value('user_id'),1),
9797: x_last_update_date => SYSDATE,
9798: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
9799: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
9800: x_true_up_amount => invoice_rec.true_up_amt,

Line 9798: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),

9794: x_attribute15 => invoice_rec.attribute15,
9795: x_creation_date => SYSDATE,
9796: x_created_by => nvl(fnd_profile.value('user_id'),1),
9797: x_last_update_date => SYSDATE,
9798: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
9799: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
9800: x_true_up_amount => invoice_rec.true_up_amt,
9801: x_true_up_status => invoice_rec.true_up_status,
9802: x_true_up_exp_code => invoice_rec.true_up_exp_code,

Line 9799: x_last_update_login => nvl(fnd_profile.value('user_id'),1),

9795: x_creation_date => SYSDATE,
9796: x_created_by => nvl(fnd_profile.value('user_id'),1),
9797: x_last_update_date => SYSDATE,
9798: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
9799: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
9800: x_true_up_amount => invoice_rec.true_up_amt,
9801: x_true_up_status => invoice_rec.true_up_status,
9802: x_true_up_exp_code => invoice_rec.true_up_exp_code,
9803: x_org_id => invoice_rec.org_id);