DBA Data[Home] [Help]

APPS.GMI_PICK_CONFIRM_PUB dependencies on IC_WHSE_MST

Line 101: l_ic_whse_mst_rec ic_whse_mst%ROWTYPE;

97: l_inventory_item_id NUMBER;
98: l_default_lot VARCHAR2(32);
99: l_default_loct VARCHAR2(32);
100: l_ic_item_mst_rec ic_item_mst_b%ROWTYPE;
101: l_ic_whse_mst_rec ic_whse_mst%ROWTYPE;
102:
103: l_loct_ctl NUMBER;
104:
105: -- Exceptions

Line 123: FROM ic_whse_mst

119:
120: -- Bug 3274586
121: CURSOR get_whse_code_dtl (p_organization_id IN NUMBER) IS
122: SELECT *
123: FROM ic_whse_mst
124: WHERE mtl_organization_id= p_organization_id;
125:
126: CURSOR trans_with_no_default_cur(p_line_id NUMBER
127: ,p_mo_line_id NUMBER) IS

Line 287: FETCH get_whse_code_dtl into l_ic_whse_mst_rec;

283: PrintMsg(' ');
284:
285: -- Bug 3274586
286: OPEN get_whse_code_dtl (l_mo_line_row.organization_id);
287: FETCH get_whse_code_dtl into l_ic_whse_mst_rec;
288: IF( get_whse_code_dtl%NOTFOUND )
289: THEN
290: CLOSE get_whse_code_dtl;
291: PrintMsg('ERROR - Warehouse does not exist ');

Line 298: PrintMsg(' whse_code : '||l_ic_whse_mst_rec.whse_code);

294: CLOSE get_whse_code_dtl;
295:
296: PrintMsg('The Warehouse Details : ' );
297: PrintMsg('========================= ');
298: PrintMsg(' whse_code : '||l_ic_whse_mst_rec.whse_code);
299: PrintMsg(' loct_ctl : '||l_ic_whse_mst_rec.loct_ctl);
300: PrintMsg('========================= ');
301: PrintMsg(' ');
302:

Line 299: PrintMsg(' loct_ctl : '||l_ic_whse_mst_rec.loct_ctl);

295:
296: PrintMsg('The Warehouse Details : ' );
297: PrintMsg('========================= ');
298: PrintMsg(' whse_code : '||l_ic_whse_mst_rec.whse_code);
299: PrintMsg(' loct_ctl : '||l_ic_whse_mst_rec.loct_ctl);
300: PrintMsg('========================= ');
301: PrintMsg(' ');
302:
303: l_loct_ctl := nvl(l_ic_item_mst_rec.loct_ctl,0) * nvl(l_ic_whse_mst_rec.loct_ctl,0);

Line 303: l_loct_ctl := nvl(l_ic_item_mst_rec.loct_ctl,0) * nvl(l_ic_whse_mst_rec.loct_ctl,0);

299: PrintMsg(' loct_ctl : '||l_ic_whse_mst_rec.loct_ctl);
300: PrintMsg('========================= ');
301: PrintMsg(' ');
302:
303: l_loct_ctl := nvl(l_ic_item_mst_rec.loct_ctl,0) * nvl(l_ic_whse_mst_rec.loct_ctl,0);
304:
305: PrintMsg('Lot ctl: '|| l_ic_item_mst_rec.lot_ctl ||' Effective location ctl: '||l_loct_ctl);
306:
307: IF (l_ic_item_mst_rec.lot_ctl = 0 AND l_loct_ctl = 0)