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

Line 38: last_updated_by = FND_GLOBAL.user_id,

34: SET description = P_TAX_RATE_CODE,
35: meaning = P_TAX_RATE_CODE,
36: -- end_date_active = P_EFFECTIVE_TO, -- commenting for bug 9705409
37: last_update_date = SYSDATE,
38: last_updated_by = FND_GLOBAL.user_id,
39: last_update_login = FND_GLOBAL.login_id
40: WHERE lookup_type = P_LOOKUP_TYPE
41: AND lookup_code = NVL(TAG,P_TAX_RATE_CODE)
42: AND (source_lang = USERENV('LANG') OR language = USERENV('LANG'));

Line 39: last_update_login = FND_GLOBAL.login_id

35: meaning = P_TAX_RATE_CODE,
36: -- end_date_active = P_EFFECTIVE_TO, -- commenting for bug 9705409
37: last_update_date = SYSDATE,
38: last_updated_by = FND_GLOBAL.user_id,
39: last_update_login = FND_GLOBAL.login_id
40: WHERE lookup_type = P_LOOKUP_TYPE
41: AND lookup_code = NVL(TAG,P_TAX_RATE_CODE)
42: AND (source_lang = USERENV('LANG') OR language = USERENV('LANG'));
43:

Line 134: last_updated_by = fnd_global.user_id,

130:
131: UPDATE ZX_ID_TCC_MAPPING_ALL
132: SET effective_to = l_effective_to,
133: active_flag = p_active_flag,
134: last_updated_by = fnd_global.user_id,
135: last_update_date = SYSDATE,
136: last_update_login = fnd_global.user_id
137: WHERE tax_classification_code = p_tax_rate_code
138: AND org_id = p_org_id

Line 136: last_update_login = fnd_global.user_id

132: SET effective_to = l_effective_to,
133: active_flag = p_active_flag,
134: last_updated_by = fnd_global.user_id,
135: last_update_date = SYSDATE,
136: last_update_login = fnd_global.user_id
137: WHERE tax_classification_code = p_tax_rate_code
138: AND org_id = p_org_id
139: AND ( tax_rate_code_id = NVL(p_source_id,p_tax_rate_id)
140: OR

Line 178: fnd_global.user_id , --created_by

174: p_tax_type , --tax_type
175: l_effective_from , --effective_from
176: l_effective_to , --effective_to
177: p_source , --source
178: fnd_global.user_id , --created_by
179: SYSDATE , --creation_date
180: fnd_global.user_id , --last_updated_by
181: SYSDATE , --last_update_date
182: fnd_global.user_id , --last_update_login

Line 180: fnd_global.user_id , --last_updated_by

176: l_effective_to , --effective_to
177: p_source , --source
178: fnd_global.user_id , --created_by
179: SYSDATE , --creation_date
180: fnd_global.user_id , --last_updated_by
181: SYSDATE , --last_update_date
182: fnd_global.user_id , --last_update_login
183: fnd_global.conc_request_id , --request_id
184: fnd_global.prog_appl_id , --program_application_id

Line 182: fnd_global.user_id , --last_update_login

178: fnd_global.user_id , --created_by
179: SYSDATE , --creation_date
180: fnd_global.user_id , --last_updated_by
181: SYSDATE , --last_update_date
182: fnd_global.user_id , --last_update_login
183: fnd_global.conc_request_id , --request_id
184: fnd_global.prog_appl_id , --program_application_id
185: fnd_global.conc_program_id , --program_id
186: fnd_global.conc_login_id , --program_login_id

Line 183: fnd_global.conc_request_id , --request_id

179: SYSDATE , --creation_date
180: fnd_global.user_id , --last_updated_by
181: SYSDATE , --last_update_date
182: fnd_global.user_id , --last_update_login
183: fnd_global.conc_request_id , --request_id
184: fnd_global.prog_appl_id , --program_application_id
185: fnd_global.conc_program_id , --program_id
186: fnd_global.conc_login_id , --program_login_id
187: p_ledger_id , --ledger_id

Line 184: fnd_global.prog_appl_id , --program_application_id

180: fnd_global.user_id , --last_updated_by
181: SYSDATE , --last_update_date
182: fnd_global.user_id , --last_update_login
183: fnd_global.conc_request_id , --request_id
184: fnd_global.prog_appl_id , --program_application_id
185: fnd_global.conc_program_id , --program_id
186: fnd_global.conc_login_id , --program_login_id
187: p_ledger_id , --ledger_id
188: p_active_flag --active_flag

Line 185: fnd_global.conc_program_id , --program_id

181: SYSDATE , --last_update_date
182: fnd_global.user_id , --last_update_login
183: fnd_global.conc_request_id , --request_id
184: fnd_global.prog_appl_id , --program_application_id
185: fnd_global.conc_program_id , --program_id
186: fnd_global.conc_login_id , --program_login_id
187: p_ledger_id , --ledger_id
188: p_active_flag --active_flag
189: FROM DUAL

Line 186: fnd_global.conc_login_id , --program_login_id

182: fnd_global.user_id , --last_update_login
183: fnd_global.conc_request_id , --request_id
184: fnd_global.prog_appl_id , --program_application_id
185: fnd_global.conc_program_id , --program_id
186: fnd_global.conc_login_id , --program_login_id
187: p_ledger_id , --ledger_id
188: p_active_flag --active_flag
189: FROM DUAL
190: WHERE NOT EXISTS (SELECT 1

Line 1170: ,x_last_updated_by => FND_GLOBAL.user_id

1166: ,x_attribute15 => l_fnd_lookup_values_rec.attribute15
1167: ,x_meaning => l_fnd_lookup_values_rec.meaning
1168: ,x_description => l_fnd_lookup_values_rec.description
1169: ,x_last_update_date => SYSDATE
1170: ,x_last_updated_by => FND_GLOBAL.user_id
1171: ,x_last_update_login => FND_GLOBAL.login_id
1172: );
1173: ELSE
1174: CLOSE cur_fnd_lookup_values;

Line 1171: ,x_last_update_login => FND_GLOBAL.login_id

1167: ,x_meaning => l_fnd_lookup_values_rec.meaning
1168: ,x_description => l_fnd_lookup_values_rec.description
1169: ,x_last_update_date => SYSDATE
1170: ,x_last_updated_by => FND_GLOBAL.user_id
1171: ,x_last_update_login => FND_GLOBAL.login_id
1172: );
1173: ELSE
1174: CLOSE cur_fnd_lookup_values;
1175: IF LENGTHB(X_TAX_RATE_CODE) > 30 THEN

Line 1212: ,x_created_by => FND_GLOBAL.user_id

1208: ,x_attribute15 => NULL
1209: ,x_meaning => x_tax_rate_code
1210: ,x_description => x_tax_rate_code
1211: ,x_creation_date => SYSDATE
1212: ,x_created_by => FND_GLOBAL.user_id
1213: ,x_last_update_date => SYSDATE
1214: ,x_last_updated_by => FND_GLOBAL.user_id
1215: ,x_last_update_login => FND_GLOBAL.login_id
1216: );

Line 1214: ,x_last_updated_by => FND_GLOBAL.user_id

1210: ,x_description => x_tax_rate_code
1211: ,x_creation_date => SYSDATE
1212: ,x_created_by => FND_GLOBAL.user_id
1213: ,x_last_update_date => SYSDATE
1214: ,x_last_updated_by => FND_GLOBAL.user_id
1215: ,x_last_update_login => FND_GLOBAL.login_id
1216: );
1217:
1218: END IF;

Line 1215: ,x_last_update_login => FND_GLOBAL.login_id

1211: ,x_creation_date => SYSDATE
1212: ,x_created_by => FND_GLOBAL.user_id
1213: ,x_last_update_date => SYSDATE
1214: ,x_last_updated_by => FND_GLOBAL.user_id
1215: ,x_last_update_login => FND_GLOBAL.login_id
1216: );
1217:
1218: END IF;
1219: