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_TRUEUP_PKG dependencies on FND_GLOBAL

Line 510: ,x_created_by => NVL(fnd_global.user_id,0)

506: ,x_attribute13 => NULL
507: ,x_attribute14 => NULL
508: ,x_attribute15 => NULL
509: ,x_creation_date => SYSDATE
510: ,x_created_by => NVL(fnd_global.user_id,0)
511: ,x_last_update_date => SYSDATE
512: ,x_last_updated_by => NVL(fnd_global.user_id,0)
513: ,x_last_update_login => NVL(fnd_global.login_id,0)
514: ,x_true_up_amount => l_total_period_rent - l_prev_inv_trueup_rent

Line 512: ,x_last_updated_by => NVL(fnd_global.user_id,0)

508: ,x_attribute15 => NULL
509: ,x_creation_date => SYSDATE
510: ,x_created_by => NVL(fnd_global.user_id,0)
511: ,x_last_update_date => SYSDATE
512: ,x_last_updated_by => NVL(fnd_global.user_id,0)
513: ,x_last_update_login => NVL(fnd_global.login_id,0)
514: ,x_true_up_amount => l_total_period_rent - l_prev_inv_trueup_rent
515: ,x_true_up_status => 'N'
516: ,x_true_up_exp_code => 'N'

Line 513: ,x_last_update_login => NVL(fnd_global.login_id,0)

509: ,x_creation_date => SYSDATE
510: ,x_created_by => NVL(fnd_global.user_id,0)
511: ,x_last_update_date => SYSDATE
512: ,x_last_updated_by => NVL(fnd_global.user_id,0)
513: ,x_last_update_login => NVL(fnd_global.login_id,0)
514: ,x_true_up_amount => l_total_period_rent - l_prev_inv_trueup_rent
515: ,x_true_up_status => 'N'
516: ,x_true_up_exp_code => 'N'
517: ,x_org_id => l_org_id );

Line 569: ,x_created_by => NVL(fnd_global.user_id,0)

565: ,x_attribute13 => NULL
566: ,x_attribute14 => NULL
567: ,x_attribute15 => NULL
568: ,x_creation_date => SYSDATE
569: ,x_created_by => NVL(fnd_global.user_id,0)
570: ,x_last_update_date => SYSDATE
571: ,x_last_updated_by => NVL(fnd_global.user_id,0)
572: ,x_last_update_login => NVL(fnd_global.login_id,0)
573: ,x_true_up_amount => (l_total_period_rent - l_prev_inv_trueup_rent)

Line 571: ,x_last_updated_by => NVL(fnd_global.user_id,0)

567: ,x_attribute15 => NULL
568: ,x_creation_date => SYSDATE
569: ,x_created_by => NVL(fnd_global.user_id,0)
570: ,x_last_update_date => SYSDATE
571: ,x_last_updated_by => NVL(fnd_global.user_id,0)
572: ,x_last_update_login => NVL(fnd_global.login_id,0)
573: ,x_true_up_amount => (l_total_period_rent - l_prev_inv_trueup_rent)
574: ,x_true_up_status => 'N'
575: ,x_true_up_exp_code => 'N'

Line 572: ,x_last_update_login => NVL(fnd_global.login_id,0)

568: ,x_creation_date => SYSDATE
569: ,x_created_by => NVL(fnd_global.user_id,0)
570: ,x_last_update_date => SYSDATE
571: ,x_last_updated_by => NVL(fnd_global.user_id,0)
572: ,x_last_update_login => NVL(fnd_global.login_id,0)
573: ,x_true_up_amount => (l_total_period_rent - l_prev_inv_trueup_rent)
574: ,x_true_up_status => 'N'
575: ,x_true_up_exp_code => 'N'
576: ,x_org_id => l_org_id );

Line 605: ,last_updated_by = NVL(fnd_global.user_id,0)

601: ,actual_term_status = 'N'
602: ,abatement_appl = l_allowance
603: ,rec_abatement = l_tot_abatement
604: ,last_update_date = SYSDATE
605: ,last_updated_by = NVL(fnd_global.user_id,0)
606: ,last_update_login = NVL(fnd_global.login_id,0)
607: WHERE
608: var_rent_inv_id = l_var_rent_inv_id;
609:

Line 606: ,last_update_login = NVL(fnd_global.login_id,0)

602: ,abatement_appl = l_allowance
603: ,rec_abatement = l_tot_abatement
604: ,last_update_date = SYSDATE
605: ,last_updated_by = NVL(fnd_global.user_id,0)
606: ,last_update_login = NVL(fnd_global.login_id,0)
607: WHERE
608: var_rent_inv_id = l_var_rent_inv_id;
609:
610: END IF; /* if there a change in rent */

Line 956: ,last_updated_by = NVL(fnd_global.user_id,0)

952: SET
953: actual_invoiced_amount = (round(l_abated_rent,l_precision) - round(l_prev_inv_exp,l_precision))
954: ,actual_term_status = 'N'
955: ,last_update_date = SYSDATE
956: ,last_updated_by = NVL(fnd_global.user_id,0)
957: ,last_update_login = NVL(fnd_global.login_id,0)
958: WHERE
959: var_rent_inv_id = inv_rec.var_rent_inv_id;
960: ELSIF ((l_abated_rent - l_prev_inv_exp)<>0) AND (l_is_inv_exp = 'Y') THEN

Line 957: ,last_update_login = NVL(fnd_global.login_id,0)

953: actual_invoiced_amount = (round(l_abated_rent,l_precision) - round(l_prev_inv_exp,l_precision))
954: ,actual_term_status = 'N'
955: ,last_update_date = SYSDATE
956: ,last_updated_by = NVL(fnd_global.user_id,0)
957: ,last_update_login = NVL(fnd_global.login_id,0)
958: WHERE
959: var_rent_inv_id = inv_rec.var_rent_inv_id;
960: ELSIF ((l_abated_rent - l_prev_inv_exp)<>0) AND (l_is_inv_exp = 'Y') THEN
961: -- Insert a new invoice. This happens only if your rents changes as a result of

Line 1010: x_created_by => NVL(fnd_global.user_id,0),

1006: x_attribute13 => NULL,
1007: x_attribute14 => NULL,
1008: x_attribute15 => NULL,
1009: x_creation_date => SYSDATE,
1010: x_created_by => NVL(fnd_global.user_id,0),
1011: x_last_update_date => SYSDATE,
1012: x_last_updated_by => NVL(fnd_global.user_id,0),
1013: x_last_update_login => NVL(fnd_global.login_id,0),
1014: x_org_id => inv_all_rec.org_id );

Line 1012: x_last_updated_by => NVL(fnd_global.user_id,0),

1008: x_attribute15 => NULL,
1009: x_creation_date => SYSDATE,
1010: x_created_by => NVL(fnd_global.user_id,0),
1011: x_last_update_date => SYSDATE,
1012: x_last_updated_by => NVL(fnd_global.user_id,0),
1013: x_last_update_login => NVL(fnd_global.login_id,0),
1014: x_org_id => inv_all_rec.org_id );
1015: END LOOP;
1016: END IF;

Line 1013: x_last_update_login => NVL(fnd_global.login_id,0),

1009: x_creation_date => SYSDATE,
1010: x_created_by => NVL(fnd_global.user_id,0),
1011: x_last_update_date => SYSDATE,
1012: x_last_updated_by => NVL(fnd_global.user_id,0),
1013: x_last_update_login => NVL(fnd_global.login_id,0),
1014: x_org_id => inv_all_rec.org_id );
1015: END LOOP;
1016: END IF;
1017: ELSE

Line 1038: ,last_updated_by = NVL(fnd_global.user_id,0)

1034: SET
1035: actual_invoiced_amount = (l_abated_rent - l_prev_inv_exp)
1036: ,actual_term_status = 'N'
1037: ,last_update_date = SYSDATE
1038: ,last_updated_by = NVL(fnd_global.user_id,0)
1039: ,last_update_login = NVL(fnd_global.login_id,0)
1040: WHERE
1041: var_rent_inv_id = inv_rec.var_rent_inv_id;
1042: ELSIF ((l_abated_rent - l_prev_inv_exp)<>0) THEN

Line 1039: ,last_update_login = NVL(fnd_global.login_id,0)

1035: actual_invoiced_amount = (l_abated_rent - l_prev_inv_exp)
1036: ,actual_term_status = 'N'
1037: ,last_update_date = SYSDATE
1038: ,last_updated_by = NVL(fnd_global.user_id,0)
1039: ,last_update_login = NVL(fnd_global.login_id,0)
1040: WHERE
1041: var_rent_inv_id = inv_rec.var_rent_inv_id;
1042: ELSIF ((l_abated_rent - l_prev_inv_exp)<>0) THEN
1043: -- Last invoice has been exported and an non zero adjustment terms needs to be created

Line 1091: x_created_by => NVL(fnd_global.user_id,0),

1087: x_attribute13 => NULL,
1088: x_attribute14 => NULL,
1089: x_attribute15 => NULL,
1090: x_creation_date => SYSDATE,
1091: x_created_by => NVL(fnd_global.user_id,0),
1092: x_last_update_date => SYSDATE,
1093: x_last_updated_by => NVL(fnd_global.user_id,0),
1094: x_last_update_login => NVL(fnd_global.login_id,0),
1095: x_org_id => inv_all_rec.org_id );

Line 1093: x_last_updated_by => NVL(fnd_global.user_id,0),

1089: x_attribute15 => NULL,
1090: x_creation_date => SYSDATE,
1091: x_created_by => NVL(fnd_global.user_id,0),
1092: x_last_update_date => SYSDATE,
1093: x_last_updated_by => NVL(fnd_global.user_id,0),
1094: x_last_update_login => NVL(fnd_global.login_id,0),
1095: x_org_id => inv_all_rec.org_id );
1096: END LOOP;
1097: END IF;*/

Line 1094: x_last_update_login => NVL(fnd_global.login_id,0),

1090: x_creation_date => SYSDATE,
1091: x_created_by => NVL(fnd_global.user_id,0),
1092: x_last_update_date => SYSDATE,
1093: x_last_updated_by => NVL(fnd_global.user_id,0),
1094: x_last_update_login => NVL(fnd_global.login_id,0),
1095: x_org_id => inv_all_rec.org_id );
1096: END LOOP;
1097: END IF;*/
1098: G_ABATED_RENT(G_ABATED_RENT.COUNT+1).period_id := p_period_id;