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

Line 101: last_updated_by = Fnd_Global.USER_ID,

97: UPDATE okl_cnsld_ar_hdrs_b
98: SET trx_status_code = 'PROCESSED',
99: amount = l_cnr_amount,
100: last_update_date = sysdate,
101: last_updated_by = Fnd_Global.USER_ID,
102: last_update_login = Fnd_Global.LOGIN_ID
103: WHERE id = l_update_tbl(m).cnr_id;
104:
105: l_old_cnr_id := l_update_tbl(m).cnr_id;

Line 102: last_update_login = Fnd_Global.LOGIN_ID

98: SET trx_status_code = 'PROCESSED',
99: amount = l_cnr_amount,
100: last_update_date = sysdate,
101: last_updated_by = Fnd_Global.USER_ID,
102: last_update_login = Fnd_Global.LOGIN_ID
103: WHERE id = l_update_tbl(m).cnr_id;
104:
105: l_old_cnr_id := l_update_tbl(m).cnr_id;
106: END IF;

Line 126: last_updated_by = Fnd_Global.USER_ID,

122:
123: UPDATE okl_cnsld_ar_lines_b
124: SET amount = l_lln_amount,
125: last_update_date = sysdate,
126: last_updated_by = Fnd_Global.USER_ID,
127: last_update_login = Fnd_Global.LOGIN_ID
128: WHERE id = l_update_tbl(m).lln_id;
129:
130: l_old_lln_id := l_update_tbl(m).lln_id;

Line 127: last_update_login = Fnd_Global.LOGIN_ID

123: UPDATE okl_cnsld_ar_lines_b
124: SET amount = l_lln_amount,
125: last_update_date = sysdate,
126: last_updated_by = Fnd_Global.USER_ID,
127: last_update_login = Fnd_Global.LOGIN_ID
128: WHERE id = l_update_tbl(m).lln_id;
129:
130: l_old_lln_id := l_update_tbl(m).lln_id;
131: END IF;

Line 146: last_updated_by = Fnd_Global.USER_ID,

142: UPDATE Okl_Ext_Sell_Invs_b
143: SET TRX_STATUS_CODE = 'WORKING',
144: XTRX_INVOICE_PULL_YN = 'Y',
145: last_update_date = sysdate,
146: last_updated_by = Fnd_Global.USER_ID,
147: last_update_login = Fnd_Global.LOGIN_ID
148: WHERE id = l_update_tbl(m).xsi_id;
149: END LOOP;
150: ELSE

Line 147: last_update_login = Fnd_Global.LOGIN_ID

143: SET TRX_STATUS_CODE = 'WORKING',
144: XTRX_INVOICE_PULL_YN = 'Y',
145: last_update_date = sysdate,
146: last_updated_by = Fnd_Global.USER_ID,
147: last_update_login = Fnd_Global.LOGIN_ID
148: WHERE id = l_update_tbl(m).xsi_id;
149: END LOOP;
150: ELSE
151: FOR m in l_update_tbl.FIRST..l_update_tbl.LAST LOOP

Line 156: last_updated_by = Fnd_Global.USER_ID,

152: UPDATE Okl_Ext_Sell_Invs_b
153: SET TRX_STATUS_CODE = 'ENTERED',
154: XTRX_INVOICE_PULL_YN = 'Y',
155: last_update_date = sysdate,
156: last_updated_by = Fnd_Global.USER_ID,
157: last_update_login = Fnd_Global.LOGIN_ID
158: WHERE id = l_update_tbl(m).xsi_id;
159: END LOOP;
160: END IF;

Line 157: last_update_login = Fnd_Global.LOGIN_ID

153: SET TRX_STATUS_CODE = 'ENTERED',
154: XTRX_INVOICE_PULL_YN = 'Y',
155: last_update_date = sysdate,
156: last_updated_by = Fnd_Global.USER_ID,
157: last_update_login = Fnd_Global.LOGIN_ID
158: WHERE id = l_update_tbl(m).xsi_id;
159: END LOOP;
160: END IF;
161: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 174: last_updated_by = Fnd_Global.USER_ID,

170: SET XTRX_CONS_INVOICE_NUMBER = l_update_tbl(m).cons_inv_number,
171: XTRX_FORMAT_TYPE = l_update_tbl(m).invoice_format,
172: XTRX_PRIVATE_LABEL = l_update_tbl(m).private_label,
173: last_update_date = sysdate,
174: last_updated_by = Fnd_Global.USER_ID,
175: last_update_login = Fnd_Global.LOGIN_ID
176: WHERE id = l_update_tbl(m).xsi_id;
177:
178: UPDATE Okl_Xtl_Sell_Invs_b

Line 175: last_update_login = Fnd_Global.LOGIN_ID

171: XTRX_FORMAT_TYPE = l_update_tbl(m).invoice_format,
172: XTRX_PRIVATE_LABEL = l_update_tbl(m).private_label,
173: last_update_date = sysdate,
174: last_updated_by = Fnd_Global.USER_ID,
175: last_update_login = Fnd_Global.LOGIN_ID
176: WHERE id = l_update_tbl(m).xsi_id;
177:
178: UPDATE Okl_Xtl_Sell_Invs_b
179: SET LSM_ID = l_update_tbl(m).LSM_ID,

Line 183: last_updated_by = Fnd_Global.USER_ID,

179: SET LSM_ID = l_update_tbl(m).LSM_ID,
180: -- XTRX_CONS_LINE_NUMBER = l_update_tbl(m).line_number,
181: XTRX_CONS_STREAM_ID = l_update_tbl(m).lsm_id,
182: last_update_date = sysdate,
183: last_updated_by = Fnd_Global.USER_ID,
184: last_update_login = Fnd_Global.LOGIN_ID
185: WHERE id = l_update_tbl(m).xls_id;
186:
187: UPDATE Okl_Xtl_Sell_Invs_tl

Line 184: last_update_login = Fnd_Global.LOGIN_ID

180: -- XTRX_CONS_LINE_NUMBER = l_update_tbl(m).line_number,
181: XTRX_CONS_STREAM_ID = l_update_tbl(m).lsm_id,
182: last_update_date = sysdate,
183: last_updated_by = Fnd_Global.USER_ID,
184: last_update_login = Fnd_Global.LOGIN_ID
185: WHERE id = l_update_tbl(m).xls_id;
186:
187: UPDATE Okl_Xtl_Sell_Invs_tl
188: SET XTRX_CONTRACT = l_update_tbl(m).contract_number,

Line 193: last_updated_by = Fnd_Global.USER_ID,

189: XTRX_ASSET = l_update_tbl(m).asset_number,
190: XTRX_STREAM_TYPE = l_update_tbl(m).sty_name,
191: XTRX_STREAM_GROUP = l_update_tbl(m).line_type,
192: last_update_date = sysdate,
193: last_updated_by = Fnd_Global.USER_ID,
194: last_update_login = Fnd_Global.LOGIN_ID
195: WHERE id = l_update_tbl(m).xls_id;
196: END LOOP;
197: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 194: last_update_login = Fnd_Global.LOGIN_ID

190: XTRX_STREAM_TYPE = l_update_tbl(m).sty_name,
191: XTRX_STREAM_GROUP = l_update_tbl(m).line_type,
192: last_update_date = sysdate,
193: last_updated_by = Fnd_Global.USER_ID,
194: last_update_login = Fnd_Global.LOGIN_ID
195: WHERE id = l_update_tbl(m).xls_id;
196: END LOOP;
197: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
198: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Done updating External Transaction Line');

Line 213: last_updated_by = Fnd_Global.USER_ID,

209: UPDATE okl_cnsld_ar_hdrs_b
210: SET trx_status_code = 'ERROR',
211: amount = l_cnr_amount,
212: last_update_date = sysdate,
213: last_updated_by = Fnd_Global.USER_ID,
214: last_update_login = Fnd_Global.LOGIN_ID
215: WHERE id = l_update_tbl(m).cnr_id;
216:
217: l_old_cnr_id := l_update_tbl(m).cnr_id;

Line 214: last_update_login = Fnd_Global.LOGIN_ID

210: SET trx_status_code = 'ERROR',
211: amount = l_cnr_amount,
212: last_update_date = sysdate,
213: last_updated_by = Fnd_Global.USER_ID,
214: last_update_login = Fnd_Global.LOGIN_ID
215: WHERE id = l_update_tbl(m).cnr_id;
216:
217: l_old_cnr_id := l_update_tbl(m).cnr_id;
218: END IF;

Line 2066: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)

2062: l_request_id NUMBER;
2063:
2064: CURSOR req_id_csr IS
2065: SELECT
2066: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
2067: FROM dual;
2068:
2069: ------------------------------------------------------------
2070: -- Operating Unit