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 747: LAST_UPDATED_BY = fnd_global.user_id,

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

Line 748: LAST_UPDATE_LOGIN = fnd_global.login_id

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

Line 761: last_updated_by = fnd_global.user_id,

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

Line 762: last_update_login = fnd_global.login_id

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

Line 804: LAST_UPDATED_BY = fnd_global.user_id,

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

Line 805: LAST_UPDATE_LOGIN = fnd_global.login_id

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

Line 947: LAST_UPDATED_BY = fnd_global.user_id,

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

Line 948: LAST_UPDATE_LOGIN = fnd_global.login_id

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

Line 961: LAST_UPDATED_BY = fnd_global.user_id,

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

Line 962: LAST_UPDATE_LOGIN = fnd_global.login_id

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