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.

[Home] [Help]

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 871: p_created_by NUMBER := NVL (fnd_profile.VALUE ('USER_ID'), 0);

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

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

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

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

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

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

6930: x_actual_exp_code => 'N',
6931: x_forecasted_exp_code => 'N',
6932: x_variance_exp_code => 'N',
6933: x_creation_date => SYSDATE,
6934: x_created_by => NVL(FND_PROFILE.VALUE('USER_ID'),1),
6935: x_last_update_date => SYSDATE,
6936: x_last_updated_by => NVL(FND_PROFILE.VALUE('USER_ID'),1),
6937: x_last_update_login => NVL(FND_PROFILE.VALUE('USER_ID'),1));
6938:

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

6932: x_variance_exp_code => 'N',
6933: x_creation_date => SYSDATE,
6934: x_created_by => NVL(FND_PROFILE.VALUE('USER_ID'),1),
6935: x_last_update_date => SYSDATE,
6936: x_last_updated_by => NVL(FND_PROFILE.VALUE('USER_ID'),1),
6937: x_last_update_login => NVL(FND_PROFILE.VALUE('USER_ID'),1));
6938:
6939: l_rowId := NULL;
6940: l_grpDateId := NULL;

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

6933: x_creation_date => SYSDATE,
6934: x_created_by => NVL(FND_PROFILE.VALUE('USER_ID'),1),
6935: x_last_update_date => SYSDATE,
6936: x_last_updated_by => NVL(FND_PROFILE.VALUE('USER_ID'),1),
6937: x_last_update_login => NVL(FND_PROFILE.VALUE('USER_ID'),1));
6938:
6939: l_rowId := NULL;
6940: l_grpDateId := NULL;
6941: END IF;

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

8218: x_attribute13 => rent_inv_rec.attribute13,
8219: x_attribute14 => rent_inv_rec.attribute14,
8220: x_attribute15 => rent_inv_rec.attribute15,
8221: x_creation_date => l_date,
8222: x_created_by => nvl(fnd_profile.value('user_id'),1),
8223: x_last_update_date => l_date,
8224: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
8225: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
8226: x_true_up_amount => rent_inv_rec.true_up_amt,

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

8220: x_attribute15 => rent_inv_rec.attribute15,
8221: x_creation_date => l_date,
8222: x_created_by => nvl(fnd_profile.value('user_id'),1),
8223: x_last_update_date => l_date,
8224: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
8225: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
8226: x_true_up_amount => rent_inv_rec.true_up_amt,
8227: x_true_up_status => rent_inv_rec.true_up_status,
8228: x_true_up_exp_code => rent_inv_rec.true_up_exp_code,

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

8221: x_creation_date => l_date,
8222: x_created_by => nvl(fnd_profile.value('user_id'),1),
8223: x_last_update_date => l_date,
8224: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
8225: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
8226: x_true_up_amount => rent_inv_rec.true_up_amt,
8227: x_true_up_status => rent_inv_rec.true_up_status,
8228: x_true_up_exp_code => rent_inv_rec.true_up_exp_code,
8229: x_org_id => rent_inv_rec.org_id);

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

8733: x_attribute13 => invoice_rec.attribute13,
8734: x_attribute14 => invoice_rec.attribute14,
8735: x_attribute15 => invoice_rec.attribute15,
8736: x_creation_date => l_date,
8737: x_created_by => nvl(fnd_profile.value('user_id'),1),
8738: x_last_update_date => l_date,
8739: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
8740: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
8741: x_true_up_amount => invoice_rec.true_up_amt,

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

8735: x_attribute15 => invoice_rec.attribute15,
8736: x_creation_date => l_date,
8737: x_created_by => nvl(fnd_profile.value('user_id'),1),
8738: x_last_update_date => l_date,
8739: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
8740: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
8741: x_true_up_amount => invoice_rec.true_up_amt,
8742: x_true_up_status => invoice_rec.true_up_status,
8743: x_true_up_exp_code => invoice_rec.true_up_exp_code,

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

8736: x_creation_date => l_date,
8737: x_created_by => nvl(fnd_profile.value('user_id'),1),
8738: x_last_update_date => l_date,
8739: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
8740: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
8741: x_true_up_amount => invoice_rec.true_up_amt,
8742: x_true_up_status => invoice_rec.true_up_status,
8743: x_true_up_exp_code => invoice_rec.true_up_exp_code,
8744: x_org_id => invoice_rec.org_id);

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

9440: x_attribute14 => line_rec.attribute14,
9441: x_attribute15 => line_rec.attribute15,
9442: x_org_id => line_rec.org_id,
9443: x_creation_date => sysdate,
9444: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
9445: x_last_update_date => sysdate,
9446: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
9447: x_last_update_login => NVL(fnd_profile.value('USER_ID'),0),
9448: x_line_template_id => line_rec.line_template_id,

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

9442: x_org_id => line_rec.org_id,
9443: x_creation_date => sysdate,
9444: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
9445: x_last_update_date => sysdate,
9446: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
9447: x_last_update_login => NVL(fnd_profile.value('USER_ID'),0),
9448: x_line_template_id => line_rec.line_template_id,
9449: x_agreement_template_id => line_rec.agreement_template_id,
9450: x_line_default_id => line_rec.line_default_id,

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

9443: x_creation_date => sysdate,
9444: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
9445: x_last_update_date => sysdate,
9446: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
9447: x_last_update_login => NVL(fnd_profile.value('USER_ID'),0),
9448: x_line_template_id => line_rec.line_template_id,
9449: x_agreement_template_id => line_rec.agreement_template_id,
9450: x_line_default_id => line_rec.line_default_id,
9451: x_var_rent_id => p_var_rent_id);

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

9485: x_attribute14 => bkpt_head_rec.attribute14,
9486: x_attribute15 => bkpt_head_rec.attribute15,
9487: x_org_id => bkpt_head_rec.org_id,
9488: x_creation_date => sysdate,
9489: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
9490: x_last_update_date => sysdate,
9491: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
9492: x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0));
9493:

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

9487: x_org_id => bkpt_head_rec.org_id,
9488: x_creation_date => sysdate,
9489: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
9490: x_last_update_date => sysdate,
9491: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
9492: x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0));
9493:
9494: pnp_debug_pkg.debug ('breakpoint header inserted is l_bkpt_header_id ..'||l_bkpt_header_id);
9495:

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

9488: x_creation_date => sysdate,
9489: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
9490: x_last_update_date => sysdate,
9491: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
9492: x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0));
9493:
9494: pnp_debug_pkg.debug ('breakpoint header inserted is l_bkpt_header_id ..'||l_bkpt_header_id);
9495:
9496: /* Generate the breakpoint details associated with this breakpoint header */

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

9530: x_attribute14 => bkpt_detail_rec.attribute14,
9531: x_attribute15 => bkpt_detail_rec.attribute15,
9532: x_org_id => bkpt_detail_rec.org_id,
9533: x_creation_date => sysdate,
9534: x_created_by => nvl(fnd_profile.value('user_id'),0),
9535: x_last_update_date => sysdate,
9536: x_last_updated_by => nvl(fnd_profile.value('user_id'),0),
9537: x_last_update_login => nvl(fnd_profile.value('user_id'),0),
9538: x_annual_basis_amount => bkpt_detail_rec.annual_basis_amount

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

9532: x_org_id => bkpt_detail_rec.org_id,
9533: x_creation_date => sysdate,
9534: x_created_by => nvl(fnd_profile.value('user_id'),0),
9535: x_last_update_date => sysdate,
9536: x_last_updated_by => nvl(fnd_profile.value('user_id'),0),
9537: x_last_update_login => nvl(fnd_profile.value('user_id'),0),
9538: x_annual_basis_amount => bkpt_detail_rec.annual_basis_amount
9539: );
9540:

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

9533: x_creation_date => sysdate,
9534: x_created_by => nvl(fnd_profile.value('user_id'),0),
9535: x_last_update_date => sysdate,
9536: x_last_updated_by => nvl(fnd_profile.value('user_id'),0),
9537: x_last_update_login => nvl(fnd_profile.value('user_id'),0),
9538: x_annual_basis_amount => bkpt_detail_rec.annual_basis_amount
9539: );
9540:
9541: pnp_debug_pkg.debug ('breakpoint detail inserted is l_bkpt_detail_id ..'||l_bkpt_detail_id);

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

9586: x_attribute14 => constraint_rec.attribute14,
9587: x_attribute15 => constraint_rec.attribute15,
9588: x_org_id => constraint_rec.org_id,
9589: x_creation_date => sysdate,
9590: x_created_by => nvl(fnd_profile.value('user_id'),0),
9591: x_last_update_date => sysdate,
9592: x_last_updated_by => nvl(fnd_profile.value('user_id'),0),
9593: x_last_update_login => nvl(fnd_profile.value('user_id'),0),
9594: x_constr_start_date => period_rec.start_date,

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

9588: x_org_id => constraint_rec.org_id,
9589: x_creation_date => sysdate,
9590: x_created_by => nvl(fnd_profile.value('user_id'),0),
9591: x_last_update_date => sysdate,
9592: x_last_updated_by => nvl(fnd_profile.value('user_id'),0),
9593: x_last_update_login => nvl(fnd_profile.value('user_id'),0),
9594: x_constr_start_date => period_rec.start_date,
9595: x_constr_end_date => period_rec.end_date);
9596: END LOOP;

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

9589: x_creation_date => sysdate,
9590: x_created_by => nvl(fnd_profile.value('user_id'),0),
9591: x_last_update_date => sysdate,
9592: x_last_updated_by => nvl(fnd_profile.value('user_id'),0),
9593: x_last_update_login => nvl(fnd_profile.value('user_id'),0),
9594: x_constr_start_date => period_rec.start_date,
9595: x_constr_end_date => period_rec.end_date);
9596: END LOOP;
9597:

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

9809: x_attribute13 => invoice_rec.attribute13,
9810: x_attribute14 => invoice_rec.attribute14,
9811: x_attribute15 => invoice_rec.attribute15,
9812: x_creation_date => SYSDATE,
9813: x_created_by => nvl(fnd_profile.value('user_id'),1),
9814: x_last_update_date => SYSDATE,
9815: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
9816: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
9817: x_true_up_amount => invoice_rec.true_up_amt,

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

9811: x_attribute15 => invoice_rec.attribute15,
9812: x_creation_date => SYSDATE,
9813: x_created_by => nvl(fnd_profile.value('user_id'),1),
9814: x_last_update_date => SYSDATE,
9815: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
9816: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
9817: x_true_up_amount => invoice_rec.true_up_amt,
9818: x_true_up_status => invoice_rec.true_up_status,
9819: x_true_up_exp_code => invoice_rec.true_up_exp_code,

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

9812: x_creation_date => SYSDATE,
9813: x_created_by => nvl(fnd_profile.value('user_id'),1),
9814: x_last_update_date => SYSDATE,
9815: x_last_updated_by => nvl(fnd_profile.value('user_id'),1),
9816: x_last_update_login => nvl(fnd_profile.value('user_id'),1),
9817: x_true_up_amount => invoice_rec.true_up_amt,
9818: x_true_up_status => invoice_rec.true_up_status,
9819: x_true_up_exp_code => invoice_rec.true_up_exp_code,
9820: x_org_id => invoice_rec.org_id);