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.GMI_QUANTITY_PUB dependencies on IC_JRNL_MST

Line 85: l_journal_id ic_jrnl_mst.journal_id%TYPE;

81: l_item_id ic_item_mst.item_id%TYPE;
82: l_lot_id ic_lots_mst.lot_id%TYPE DEFAULT 0;
83: l_old_qc_grade qc_grad_mst.qc_grade%TYPE;
84: l_old_lot_status ic_lots_sts.lot_status%TYPE;
85: l_journal_id ic_jrnl_mst.journal_id%TYPE;
86: l_doc_id ic_adjs_jnl.doc_id%TYPE;
87: l_line_id ic_tran_cmp.line_id%TYPE;
88: l_trans_rec trans_rec_typ;
89: l_loop_ctr NUMBER(2);

Line 94: l_ic_jrnl_mst_rec ic_jrnl_mst%ROWTYPE;

90: l_num_rows NUMBER(2);
91: l_msg_count NUMBER :=0;
92: l_msg_data VARCHAR2(2000);
93: l_return_status VARCHAR2(1);
94: l_ic_jrnl_mst_rec ic_jrnl_mst%ROWTYPE;
95: l_ic_adjs_jnl_rec ic_adjs_jnl%ROWTYPE;
96: l_lot_rec GMI_LOTS_PUB.lot_rec_typ;
97: l_cmp_tran_rec GMI_CMP_TRAN_PVT.cmp_tran_typ;
98: l_user_name fnd_user.user_name%TYPE DEFAULT 'OPM';

Line 192: -- Set up PL/SQL record and insert item into ic_jrnl_mst

188: FND_MSG_PUB.Add;
189: RAISE FND_API.G_EXC_ERROR;
190: END IF;
191:
192: -- Set up PL/SQL record and insert item into ic_jrnl_mst
193: l_ic_jrnl_mst_rec.journal_id := l_journal_id;
194: l_ic_jrnl_mst_rec.journal_no := l_trans_rec.journal_no;
195: l_ic_jrnl_mst_rec.journal_comment := NULL;
196: l_ic_jrnl_mst_rec.posting_id := 0;

Line 193: l_ic_jrnl_mst_rec.journal_id := l_journal_id;

189: RAISE FND_API.G_EXC_ERROR;
190: END IF;
191:
192: -- Set up PL/SQL record and insert item into ic_jrnl_mst
193: l_ic_jrnl_mst_rec.journal_id := l_journal_id;
194: l_ic_jrnl_mst_rec.journal_no := l_trans_rec.journal_no;
195: l_ic_jrnl_mst_rec.journal_comment := NULL;
196: l_ic_jrnl_mst_rec.posting_id := 0;
197: l_ic_jrnl_mst_rec.print_cnt := 0;

Line 194: l_ic_jrnl_mst_rec.journal_no := l_trans_rec.journal_no;

190: END IF;
191:
192: -- Set up PL/SQL record and insert item into ic_jrnl_mst
193: l_ic_jrnl_mst_rec.journal_id := l_journal_id;
194: l_ic_jrnl_mst_rec.journal_no := l_trans_rec.journal_no;
195: l_ic_jrnl_mst_rec.journal_comment := NULL;
196: l_ic_jrnl_mst_rec.posting_id := 0;
197: l_ic_jrnl_mst_rec.print_cnt := 0;
198: l_ic_jrnl_mst_rec.posted_ind := 1;

Line 195: l_ic_jrnl_mst_rec.journal_comment := NULL;

191:
192: -- Set up PL/SQL record and insert item into ic_jrnl_mst
193: l_ic_jrnl_mst_rec.journal_id := l_journal_id;
194: l_ic_jrnl_mst_rec.journal_no := l_trans_rec.journal_no;
195: l_ic_jrnl_mst_rec.journal_comment := NULL;
196: l_ic_jrnl_mst_rec.posting_id := 0;
197: l_ic_jrnl_mst_rec.print_cnt := 0;
198: l_ic_jrnl_mst_rec.posted_ind := 1;
199: l_ic_jrnl_mst_rec.orgn_code := l_trans_rec.orgn_code;

Line 196: l_ic_jrnl_mst_rec.posting_id := 0;

192: -- Set up PL/SQL record and insert item into ic_jrnl_mst
193: l_ic_jrnl_mst_rec.journal_id := l_journal_id;
194: l_ic_jrnl_mst_rec.journal_no := l_trans_rec.journal_no;
195: l_ic_jrnl_mst_rec.journal_comment := NULL;
196: l_ic_jrnl_mst_rec.posting_id := 0;
197: l_ic_jrnl_mst_rec.print_cnt := 0;
198: l_ic_jrnl_mst_rec.posted_ind := 1;
199: l_ic_jrnl_mst_rec.orgn_code := l_trans_rec.orgn_code;
200: l_ic_jrnl_mst_rec.creation_date := SYSDATE;

Line 197: l_ic_jrnl_mst_rec.print_cnt := 0;

193: l_ic_jrnl_mst_rec.journal_id := l_journal_id;
194: l_ic_jrnl_mst_rec.journal_no := l_trans_rec.journal_no;
195: l_ic_jrnl_mst_rec.journal_comment := NULL;
196: l_ic_jrnl_mst_rec.posting_id := 0;
197: l_ic_jrnl_mst_rec.print_cnt := 0;
198: l_ic_jrnl_mst_rec.posted_ind := 1;
199: l_ic_jrnl_mst_rec.orgn_code := l_trans_rec.orgn_code;
200: l_ic_jrnl_mst_rec.creation_date := SYSDATE;
201: l_ic_jrnl_mst_rec.last_update_date := SYSDATE;

Line 198: l_ic_jrnl_mst_rec.posted_ind := 1;

194: l_ic_jrnl_mst_rec.journal_no := l_trans_rec.journal_no;
195: l_ic_jrnl_mst_rec.journal_comment := NULL;
196: l_ic_jrnl_mst_rec.posting_id := 0;
197: l_ic_jrnl_mst_rec.print_cnt := 0;
198: l_ic_jrnl_mst_rec.posted_ind := 1;
199: l_ic_jrnl_mst_rec.orgn_code := l_trans_rec.orgn_code;
200: l_ic_jrnl_mst_rec.creation_date := SYSDATE;
201: l_ic_jrnl_mst_rec.last_update_date := SYSDATE;
202: l_ic_jrnl_mst_rec.created_by := l_user_id;

Line 199: l_ic_jrnl_mst_rec.orgn_code := l_trans_rec.orgn_code;

195: l_ic_jrnl_mst_rec.journal_comment := NULL;
196: l_ic_jrnl_mst_rec.posting_id := 0;
197: l_ic_jrnl_mst_rec.print_cnt := 0;
198: l_ic_jrnl_mst_rec.posted_ind := 1;
199: l_ic_jrnl_mst_rec.orgn_code := l_trans_rec.orgn_code;
200: l_ic_jrnl_mst_rec.creation_date := SYSDATE;
201: l_ic_jrnl_mst_rec.last_update_date := SYSDATE;
202: l_ic_jrnl_mst_rec.created_by := l_user_id;
203: l_ic_jrnl_mst_rec.last_updated_by := l_user_id;

Line 200: l_ic_jrnl_mst_rec.creation_date := SYSDATE;

196: l_ic_jrnl_mst_rec.posting_id := 0;
197: l_ic_jrnl_mst_rec.print_cnt := 0;
198: l_ic_jrnl_mst_rec.posted_ind := 1;
199: l_ic_jrnl_mst_rec.orgn_code := l_trans_rec.orgn_code;
200: l_ic_jrnl_mst_rec.creation_date := SYSDATE;
201: l_ic_jrnl_mst_rec.last_update_date := SYSDATE;
202: l_ic_jrnl_mst_rec.created_by := l_user_id;
203: l_ic_jrnl_mst_rec.last_updated_by := l_user_id;
204: l_ic_jrnl_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(

Line 201: l_ic_jrnl_mst_rec.last_update_date := SYSDATE;

197: l_ic_jrnl_mst_rec.print_cnt := 0;
198: l_ic_jrnl_mst_rec.posted_ind := 1;
199: l_ic_jrnl_mst_rec.orgn_code := l_trans_rec.orgn_code;
200: l_ic_jrnl_mst_rec.creation_date := SYSDATE;
201: l_ic_jrnl_mst_rec.last_update_date := SYSDATE;
202: l_ic_jrnl_mst_rec.created_by := l_user_id;
203: l_ic_jrnl_mst_rec.last_updated_by := l_user_id;
204: l_ic_jrnl_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(
205: 'LOGIN_ID'));

Line 202: l_ic_jrnl_mst_rec.created_by := l_user_id;

198: l_ic_jrnl_mst_rec.posted_ind := 1;
199: l_ic_jrnl_mst_rec.orgn_code := l_trans_rec.orgn_code;
200: l_ic_jrnl_mst_rec.creation_date := SYSDATE;
201: l_ic_jrnl_mst_rec.last_update_date := SYSDATE;
202: l_ic_jrnl_mst_rec.created_by := l_user_id;
203: l_ic_jrnl_mst_rec.last_updated_by := l_user_id;
204: l_ic_jrnl_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(
205: 'LOGIN_ID'));
206: l_ic_jrnl_mst_rec.delete_mark := 0;

Line 203: l_ic_jrnl_mst_rec.last_updated_by := l_user_id;

199: l_ic_jrnl_mst_rec.orgn_code := l_trans_rec.orgn_code;
200: l_ic_jrnl_mst_rec.creation_date := SYSDATE;
201: l_ic_jrnl_mst_rec.last_update_date := SYSDATE;
202: l_ic_jrnl_mst_rec.created_by := l_user_id;
203: l_ic_jrnl_mst_rec.last_updated_by := l_user_id;
204: l_ic_jrnl_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(
205: 'LOGIN_ID'));
206: l_ic_jrnl_mst_rec.delete_mark := 0;
207: l_ic_jrnl_mst_rec.text_code := NULL;

Line 204: l_ic_jrnl_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(

200: l_ic_jrnl_mst_rec.creation_date := SYSDATE;
201: l_ic_jrnl_mst_rec.last_update_date := SYSDATE;
202: l_ic_jrnl_mst_rec.created_by := l_user_id;
203: l_ic_jrnl_mst_rec.last_updated_by := l_user_id;
204: l_ic_jrnl_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(
205: 'LOGIN_ID'));
206: l_ic_jrnl_mst_rec.delete_mark := 0;
207: l_ic_jrnl_mst_rec.text_code := NULL;
208: l_ic_jrnl_mst_rec.in_use := 0;

Line 206: l_ic_jrnl_mst_rec.delete_mark := 0;

202: l_ic_jrnl_mst_rec.created_by := l_user_id;
203: l_ic_jrnl_mst_rec.last_updated_by := l_user_id;
204: l_ic_jrnl_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(
205: 'LOGIN_ID'));
206: l_ic_jrnl_mst_rec.delete_mark := 0;
207: l_ic_jrnl_mst_rec.text_code := NULL;
208: l_ic_jrnl_mst_rec.in_use := 0;
209: l_ic_jrnl_mst_rec.program_application_id :=NULL;
210: l_ic_jrnl_mst_rec.program_id := NULL;

Line 207: l_ic_jrnl_mst_rec.text_code := NULL;

203: l_ic_jrnl_mst_rec.last_updated_by := l_user_id;
204: l_ic_jrnl_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(
205: 'LOGIN_ID'));
206: l_ic_jrnl_mst_rec.delete_mark := 0;
207: l_ic_jrnl_mst_rec.text_code := NULL;
208: l_ic_jrnl_mst_rec.in_use := 0;
209: l_ic_jrnl_mst_rec.program_application_id :=NULL;
210: l_ic_jrnl_mst_rec.program_id := NULL;
211: l_ic_jrnl_mst_rec.program_update_date := SYSDATE;

Line 208: l_ic_jrnl_mst_rec.in_use := 0;

204: l_ic_jrnl_mst_rec.last_update_login := TO_NUMBER(FND_PROFILE.Value(
205: 'LOGIN_ID'));
206: l_ic_jrnl_mst_rec.delete_mark := 0;
207: l_ic_jrnl_mst_rec.text_code := NULL;
208: l_ic_jrnl_mst_rec.in_use := 0;
209: l_ic_jrnl_mst_rec.program_application_id :=NULL;
210: l_ic_jrnl_mst_rec.program_id := NULL;
211: l_ic_jrnl_mst_rec.program_update_date := SYSDATE;
212: l_ic_jrnl_mst_rec.request_id := NULL;

Line 209: l_ic_jrnl_mst_rec.program_application_id :=NULL;

205: 'LOGIN_ID'));
206: l_ic_jrnl_mst_rec.delete_mark := 0;
207: l_ic_jrnl_mst_rec.text_code := NULL;
208: l_ic_jrnl_mst_rec.in_use := 0;
209: l_ic_jrnl_mst_rec.program_application_id :=NULL;
210: l_ic_jrnl_mst_rec.program_id := NULL;
211: l_ic_jrnl_mst_rec.program_update_date := SYSDATE;
212: l_ic_jrnl_mst_rec.request_id := NULL;
213: l_ic_jrnl_mst_rec.last_update_login := l_user_id;

Line 210: l_ic_jrnl_mst_rec.program_id := NULL;

206: l_ic_jrnl_mst_rec.delete_mark := 0;
207: l_ic_jrnl_mst_rec.text_code := NULL;
208: l_ic_jrnl_mst_rec.in_use := 0;
209: l_ic_jrnl_mst_rec.program_application_id :=NULL;
210: l_ic_jrnl_mst_rec.program_id := NULL;
211: l_ic_jrnl_mst_rec.program_update_date := SYSDATE;
212: l_ic_jrnl_mst_rec.request_id := NULL;
213: l_ic_jrnl_mst_rec.last_update_login := l_user_id;
214:

Line 211: l_ic_jrnl_mst_rec.program_update_date := SYSDATE;

207: l_ic_jrnl_mst_rec.text_code := NULL;
208: l_ic_jrnl_mst_rec.in_use := 0;
209: l_ic_jrnl_mst_rec.program_application_id :=NULL;
210: l_ic_jrnl_mst_rec.program_id := NULL;
211: l_ic_jrnl_mst_rec.program_update_date := SYSDATE;
212: l_ic_jrnl_mst_rec.request_id := NULL;
213: l_ic_jrnl_mst_rec.last_update_login := l_user_id;
214:
215: IF NOT GMI_QUANTITY_PVT.insert_ic_jrnl_mst(l_ic_jrnl_mst_rec)

Line 212: l_ic_jrnl_mst_rec.request_id := NULL;

208: l_ic_jrnl_mst_rec.in_use := 0;
209: l_ic_jrnl_mst_rec.program_application_id :=NULL;
210: l_ic_jrnl_mst_rec.program_id := NULL;
211: l_ic_jrnl_mst_rec.program_update_date := SYSDATE;
212: l_ic_jrnl_mst_rec.request_id := NULL;
213: l_ic_jrnl_mst_rec.last_update_login := l_user_id;
214:
215: IF NOT GMI_QUANTITY_PVT.insert_ic_jrnl_mst(l_ic_jrnl_mst_rec)
216: THEN

Line 213: l_ic_jrnl_mst_rec.last_update_login := l_user_id;

209: l_ic_jrnl_mst_rec.program_application_id :=NULL;
210: l_ic_jrnl_mst_rec.program_id := NULL;
211: l_ic_jrnl_mst_rec.program_update_date := SYSDATE;
212: l_ic_jrnl_mst_rec.request_id := NULL;
213: l_ic_jrnl_mst_rec.last_update_login := l_user_id;
214:
215: IF NOT GMI_QUANTITY_PVT.insert_ic_jrnl_mst(l_ic_jrnl_mst_rec)
216: THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 215: IF NOT GMI_QUANTITY_PVT.insert_ic_jrnl_mst(l_ic_jrnl_mst_rec)

211: l_ic_jrnl_mst_rec.program_update_date := SYSDATE;
212: l_ic_jrnl_mst_rec.request_id := NULL;
213: l_ic_jrnl_mst_rec.last_update_login := l_user_id;
214:
215: IF NOT GMI_QUANTITY_PVT.insert_ic_jrnl_mst(l_ic_jrnl_mst_rec)
216: THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219: