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

Line 947: ,NVL(fnd_profile.value('USER_ID'),0)

943: ,round(L_FOR_VAR_RENT,g_precision)
944: ,P_GRP_DATE_ID
945: ,P_GROUP_DATE
946: ,SYSDATE
947: ,NVL(fnd_profile.value('USER_ID'),0)
948: ,SYSDATE
949: ,NVL(fnd_profile.value('USER_ID'),0)
950: ,NVL(fnd_profile.value('LOGIN_ID'),0)
951: ,g_org_id);

Line 949: ,NVL(fnd_profile.value('USER_ID'),0)

945: ,P_GROUP_DATE
946: ,SYSDATE
947: ,NVL(fnd_profile.value('USER_ID'),0)
948: ,SYSDATE
949: ,NVL(fnd_profile.value('USER_ID'),0)
950: ,NVL(fnd_profile.value('LOGIN_ID'),0)
951: ,g_org_id);
952:
953: ELSE

Line 950: ,NVL(fnd_profile.value('LOGIN_ID'),0)

946: ,SYSDATE
947: ,NVL(fnd_profile.value('USER_ID'),0)
948: ,SYSDATE
949: ,NVL(fnd_profile.value('USER_ID'),0)
950: ,NVL(fnd_profile.value('LOGIN_ID'),0)
951: ,g_org_id);
952:
953: ELSE
954:

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

962: tot_for_vol = decode(g_rent_TYPE,'FORECASTED',p_tot_vol,tot_for_vol),
963: for_var_rent = decode(g_rent_TYPE,'FORECASTED',round(l_var_rent,g_precision),
964: round(act_var_rent,g_precision)),
965: last_update_date = SYSDATE,
966: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
967: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
968: WHERE line_item_id = p_line_item_id
969: AND grp_date_id = p_grp_date_id;
970:

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

963: for_var_rent = decode(g_rent_TYPE,'FORECASTED',round(l_var_rent,g_precision),
964: round(act_var_rent,g_precision)),
965: last_update_date = SYSDATE,
966: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
967: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
968: WHERE line_item_id = p_line_item_id
969: AND grp_date_id = p_grp_date_id;
970:
971: END IF;

Line 1188: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),

1184: X_ATTRIBUTE13 => null,
1185: X_ATTRIBUTE14 => null,
1186: X_ATTRIBUTE15 => null,
1187: X_CREATION_DATE => SYSDATE,
1188: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1189: X_LAST_UPDATE_DATE => SYSDATE,
1190: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1191: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
1192: X_ORG_ID => g_org_id );

Line 1190: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),

1186: X_ATTRIBUTE15 => null,
1187: X_CREATION_DATE => SYSDATE,
1188: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1189: X_LAST_UPDATE_DATE => SYSDATE,
1190: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1191: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
1192: X_ORG_ID => g_org_id );
1193:
1194: l_rent_inv_id := null;

Line 1191: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),

1187: X_CREATION_DATE => SYSDATE,
1188: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1189: X_LAST_UPDATE_DATE => SYSDATE,
1190: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1191: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
1192: X_ORG_ID => g_org_id );
1193:
1194: l_rent_inv_id := null;
1195: l_rowid_out := null;

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

1216: forecasted_term_status = decode(l_rent_TYPE,'FORECASTED','N',forecasted_term_status),
1217: variance_term_status = decode(l_rent_TYPE,'VARIANCE','N',variance_term_status),
1218: actual_term_status = decode(l_rent_TYPE,'ACTUAL','N',actual_term_status),
1219: last_update_date = SYSDATE,
1220: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
1221: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
1222: WHERE rowid = l_rowid;
1223:
1224: END IF;

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

1217: variance_term_status = decode(l_rent_TYPE,'VARIANCE','N',variance_term_status),
1218: actual_term_status = decode(l_rent_TYPE,'ACTUAL','N',actual_term_status),
1219: last_update_date = SYSDATE,
1220: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
1221: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
1222: WHERE rowid = l_rowid;
1223:
1224: END IF;
1225:

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

1505: negative_rent = l_negative_rent,
1506: actual_term_status = 'N',
1507: variance_term_status = 'N',
1508: last_update_date = SYSDATE,
1509: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
1510: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
1511: WHERE rowid = rec_get_inv.rowid;
1512:
1513: END IF;

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

1506: actual_term_status = 'N',
1507: variance_term_status = 'N',
1508: last_update_date = SYSDATE,
1509: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
1510: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
1511: WHERE rowid = rec_get_inv.rowid;
1512:
1513: END IF;
1514: