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

Line 8: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

4: -- This package contains the procedures of calculation engine, some of which will be called from each formula packages
5:
6: -- global variable for this package
7: G_LAST_UPDATE_DATE DATE := sysdate;
8: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
9: G_CREATION_DATE DATE := sysdate;
10: G_CREATED_BY NUMBER := fnd_global.user_id;
11: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
12:

Line 10: G_CREATED_BY NUMBER := fnd_global.user_id;

6: -- global variable for this package
7: G_LAST_UPDATE_DATE DATE := sysdate;
8: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
9: G_CREATION_DATE DATE := sysdate;
10: G_CREATED_BY NUMBER := fnd_global.user_id;
11: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
12:
13: g_intel_calc_flag VARCHAR2(1);
14: g_calc_type VARCHAR2(30);

Line 11: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

7: G_LAST_UPDATE_DATE DATE := sysdate;
8: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
9: G_CREATION_DATE DATE := sysdate;
10: G_CREATED_BY NUMBER := fnd_global.user_id;
11: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
12:
13: g_intel_calc_flag VARCHAR2(1);
14: g_calc_type VARCHAR2(30);
15:

Line 1039: LAST_UPDATED_BY = fnd_global.user_id,

1035: advance_to_rec_itd = l_advance_to_rec_itd,
1036: recovery_amount_itd = l_recovery_amount_itd,
1037: comm_pend_itd = l_comm_pend_itd,
1038: LAST_UPDATE_DATE = sysdate,
1039: LAST_UPDATED_BY = fnd_global.user_id,
1040: LAST_UPDATE_LOGIN = fnd_global.login_id
1041: where rowid = period.rowid;
1042:
1043: for period_ext in periods_ext(period.srp_period_quota_id) loop

Line 1040: LAST_UPDATE_LOGIN = fnd_global.login_id

1036: recovery_amount_itd = l_recovery_amount_itd,
1037: comm_pend_itd = l_comm_pend_itd,
1038: LAST_UPDATE_DATE = sysdate,
1039: LAST_UPDATED_BY = fnd_global.user_id,
1040: LAST_UPDATE_LOGIN = fnd_global.login_id
1041: where rowid = period.rowid;
1042:
1043: for period_ext in periods_ext(period.srp_period_quota_id) loop
1044: l_input_achieved_itd_tbl(period_ext.input_sequence) :=

Line 1050: LAST_UPDATED_BY = fnd_global.user_id,

1046:
1047: update cn_srp_period_quotas_ext_all
1048: set input_achieved_itd = l_input_achieved_itd_tbl(period_ext.input_sequence),
1049: LAST_UPDATE_DATE = sysdate,
1050: LAST_UPDATED_BY = fnd_global.user_id,
1051: LAST_UPDATE_LOGIN = fnd_global.login_id
1052: where srp_period_quota_id = period.srp_period_quota_id
1053: and input_sequence = period_ext.input_sequence;
1054: end loop;

Line 1051: LAST_UPDATE_LOGIN = fnd_global.login_id

1047: update cn_srp_period_quotas_ext_all
1048: set input_achieved_itd = l_input_achieved_itd_tbl(period_ext.input_sequence),
1049: LAST_UPDATE_DATE = sysdate,
1050: LAST_UPDATED_BY = fnd_global.user_id,
1051: LAST_UPDATE_LOGIN = fnd_global.login_id
1052: where srp_period_quota_id = period.srp_period_quota_id
1053: and input_sequence = period_ext.input_sequence;
1054: end loop;
1055:

Line 3137: l_user_id NUMBER(15) := fnd_global.user_id ;

3133:
3134: l_unique_flag VARCHAR2(1) := 'N';
3135: l_org_id NUMBER;
3136:
3137: l_user_id NUMBER(15) := fnd_global.user_id ;
3138: l_resp_id NUMBER(15) := fnd_global.resp_id ;
3139: l_login_id NUMBER(15) := fnd_global.login_id ;
3140: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
3141: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

Line 3138: l_resp_id NUMBER(15) := fnd_global.resp_id ;

3134: l_unique_flag VARCHAR2(1) := 'N';
3135: l_org_id NUMBER;
3136:
3137: l_user_id NUMBER(15) := fnd_global.user_id ;
3138: l_resp_id NUMBER(15) := fnd_global.resp_id ;
3139: l_login_id NUMBER(15) := fnd_global.login_id ;
3140: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
3141: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
3142: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id ;

Line 3139: l_login_id NUMBER(15) := fnd_global.login_id ;

3135: l_org_id NUMBER;
3136:
3137: l_user_id NUMBER(15) := fnd_global.user_id ;
3138: l_resp_id NUMBER(15) := fnd_global.resp_id ;
3139: l_login_id NUMBER(15) := fnd_global.login_id ;
3140: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
3141: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
3142: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id ;
3143:

Line 3140: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;

3136:
3137: l_user_id NUMBER(15) := fnd_global.user_id ;
3138: l_resp_id NUMBER(15) := fnd_global.resp_id ;
3139: l_login_id NUMBER(15) := fnd_global.login_id ;
3140: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
3141: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
3142: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id ;
3143:
3144: BEGIN

Line 3141: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

3137: l_user_id NUMBER(15) := fnd_global.user_id ;
3138: l_resp_id NUMBER(15) := fnd_global.resp_id ;
3139: l_login_id NUMBER(15) := fnd_global.login_id ;
3140: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
3141: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
3142: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id ;
3143:
3144: BEGIN
3145: cn_message_pkg.debug('Reversing transactions in physical batch (ID='||p_batch_id||')');

Line 3142: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id ;

3138: l_resp_id NUMBER(15) := fnd_global.resp_id ;
3139: l_login_id NUMBER(15) := fnd_global.login_id ;
3140: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
3141: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
3142: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id ;
3143:
3144: BEGIN
3145: cn_message_pkg.debug('Reversing transactions in physical batch (ID='||p_batch_id||')');
3146: