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.CN_CALC_SUBLEDGER_PVT dependencies on FND_GLOBAL

Line 745: LAST_UPDATED_BY = fnd_global.user_id,

741: + Nvl(comm_bonus.comm_pending_ptd, 0)),
742:
743: rollover = Decode(period_id, l_max_period_id, p_srp_pe_subledger.rollover, NULL),
744: LAST_UPDATE_DATE = sysdate,
745: LAST_UPDATED_BY = fnd_global.user_id,
746: LAST_UPDATE_LOGIN = fnd_global.login_id
747:
748: WHERE salesrep_id = p_srp_pe_subledger.salesrep_id
749: AND period_id = p_srp_pe_subledger.accu_period_id

Line 746: LAST_UPDATE_LOGIN = fnd_global.login_id

742:
743: rollover = Decode(period_id, l_max_period_id, p_srp_pe_subledger.rollover, NULL),
744: LAST_UPDATE_DATE = sysdate,
745: LAST_UPDATED_BY = fnd_global.user_id,
746: LAST_UPDATE_LOGIN = fnd_global.login_id
747:
748: WHERE salesrep_id = p_srp_pe_subledger.salesrep_id
749: AND period_id = p_srp_pe_subledger.accu_period_id
750: AND quota_id = p_srp_pe_subledger.quota_id

Line 759: last_updated_by = fnd_global.user_id,

755: UPDATE cn_srp_period_quotas_ext_all
756: SET input_achieved_ptd = p_srp_pe_subledger.input_ptd(i) ,
757: input_achieved_itd = p_srp_pe_subledger.input_itd(i) ,
758: last_update_date = Sysdate,
759: last_updated_by = fnd_global.user_id,
760: last_update_login = fnd_global.login_id
761: WHERE srp_period_quota_id = l_srp_period_quota_id
762: AND input_sequence = i;
763: END LOOP;

Line 760: last_update_login = fnd_global.login_id

756: SET input_achieved_ptd = p_srp_pe_subledger.input_ptd(i) ,
757: input_achieved_itd = p_srp_pe_subledger.input_itd(i) ,
758: last_update_date = Sysdate,
759: last_updated_by = fnd_global.user_id,
760: last_update_login = fnd_global.login_id
761: WHERE srp_period_quota_id = l_srp_period_quota_id
762: AND input_sequence = i;
763: END LOOP;
764:

Line 802: LAST_UPDATED_BY = fnd_global.user_id,

798: Nvl(comm_pend_itd,0) - Nvl(comm_pend_ptd,0)
799: + Nvl(comm_bonus.comm_pending_ptd, 0)),
800:
801: LAST_UPDATE_DATE = sysdate,
802: LAST_UPDATED_BY = fnd_global.user_id,
803: LAST_UPDATE_LOGIN = fnd_global.login_id
804:
805: WHERE salesrep_id = p_srp_pe_subledger.salesrep_id
806: AND period_id = p_srp_pe_subledger.accu_period_id

Line 803: LAST_UPDATE_LOGIN = fnd_global.login_id

799: + Nvl(comm_bonus.comm_pending_ptd, 0)),
800:
801: LAST_UPDATE_DATE = sysdate,
802: LAST_UPDATED_BY = fnd_global.user_id,
803: LAST_UPDATE_LOGIN = fnd_global.login_id
804:
805: WHERE salesrep_id = p_srp_pe_subledger.salesrep_id
806: AND period_id = p_srp_pe_subledger.accu_period_id
807: AND quota_id = p_srp_pe_subledger.quota_id

Line 945: LAST_UPDATED_BY = fnd_global.user_id,

941: advance_to_rec_itd = l_advance_to_rec_itd,
942: recovery_amount_itd = l_recovery_amount_itd,
943: comm_pend_itd = l_comm_pend_itd,
944: LAST_UPDATE_DATE = sysdate,
945: LAST_UPDATED_BY = fnd_global.user_id,
946: LAST_UPDATE_LOGIN = fnd_global.login_id
947: WHERE salesrep_id = p_srp_pe_subledger.salesrep_id
948: AND period_id = period.period_id
949: AND quota_id = p_srp_pe_subledger.quota_id

Line 946: LAST_UPDATE_LOGIN = fnd_global.login_id

942: recovery_amount_itd = l_recovery_amount_itd,
943: comm_pend_itd = l_comm_pend_itd,
944: LAST_UPDATE_DATE = sysdate,
945: LAST_UPDATED_BY = fnd_global.user_id,
946: LAST_UPDATE_LOGIN = fnd_global.login_id
947: WHERE salesrep_id = p_srp_pe_subledger.salesrep_id
948: AND period_id = period.period_id
949: AND quota_id = p_srp_pe_subledger.quota_id
950: AND srp_plan_assign_id = p_srp_pe_subledger.srp_plan_assign_id;

Line 959: LAST_UPDATED_BY = fnd_global.user_id,

955:
956: UPDATE cn_srp_period_quotas_ext_all
957: SET input_achieved_itd = l_input_achieved_itd_tbl(period_ext.input_sequence),
958: LAST_UPDATE_DATE = sysdate,
959: LAST_UPDATED_BY = fnd_global.user_id,
960: LAST_UPDATE_LOGIN = fnd_global.login_id
961: WHERE srp_period_quota_id = period.srp_period_quota_id
962: AND input_sequence = period_ext.input_sequence;
963: END LOOP;

Line 960: LAST_UPDATE_LOGIN = fnd_global.login_id

956: UPDATE cn_srp_period_quotas_ext_all
957: SET input_achieved_itd = l_input_achieved_itd_tbl(period_ext.input_sequence),
958: LAST_UPDATE_DATE = sysdate,
959: LAST_UPDATED_BY = fnd_global.user_id,
960: LAST_UPDATE_LOGIN = fnd_global.login_id
961: WHERE srp_period_quota_id = period.srp_period_quota_id
962: AND input_sequence = period_ext.input_sequence;
963: END LOOP;
964: END IF;