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

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

Line 1041: LAST_UPDATE_LOGIN = fnd_global.login_id

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

Line 1051: LAST_UPDATED_BY = fnd_global.user_id,

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

Line 1052: LAST_UPDATE_LOGIN = fnd_global.login_id

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

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

3149:
3150: l_unique_flag VARCHAR2(1) := 'N';
3151: l_org_id NUMBER;
3152:
3153: l_user_id NUMBER(15) := fnd_global.user_id ;
3154: l_resp_id NUMBER(15) := fnd_global.resp_id ;
3155: l_login_id NUMBER(15) := fnd_global.login_id ;
3156: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
3157: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

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

3150: l_unique_flag VARCHAR2(1) := 'N';
3151: l_org_id NUMBER;
3152:
3153: l_user_id NUMBER(15) := fnd_global.user_id ;
3154: l_resp_id NUMBER(15) := fnd_global.resp_id ;
3155: l_login_id NUMBER(15) := fnd_global.login_id ;
3156: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
3157: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
3158: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id ;

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

3151: l_org_id NUMBER;
3152:
3153: l_user_id NUMBER(15) := fnd_global.user_id ;
3154: l_resp_id NUMBER(15) := fnd_global.resp_id ;
3155: l_login_id NUMBER(15) := fnd_global.login_id ;
3156: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
3157: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
3158: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id ;
3159:

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

3152:
3153: l_user_id NUMBER(15) := fnd_global.user_id ;
3154: l_resp_id NUMBER(15) := fnd_global.resp_id ;
3155: l_login_id NUMBER(15) := fnd_global.login_id ;
3156: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
3157: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
3158: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id ;
3159:
3160: BEGIN

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

3153: l_user_id NUMBER(15) := fnd_global.user_id ;
3154: l_resp_id NUMBER(15) := fnd_global.resp_id ;
3155: l_login_id NUMBER(15) := fnd_global.login_id ;
3156: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
3157: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
3158: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id ;
3159:
3160: BEGIN
3161: cn_message_pkg.debug('Reversing transactions in physical batch (ID='||p_batch_id||')');

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

3154: l_resp_id NUMBER(15) := fnd_global.resp_id ;
3155: l_login_id NUMBER(15) := fnd_global.login_id ;
3156: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
3157: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
3158: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id ;
3159:
3160: BEGIN
3161: cn_message_pkg.debug('Reversing transactions in physical batch (ID='||p_batch_id||')');
3162: