DBA Data[Home] [Help]

APPS.GMIGUTL dependencies on GMIVDBL

Line 200: IF GMIVDBL.ic_item_mst_select(x_ic_item_mst_row, x_ic_item_mst_row)

196: BEGIN
197:
198: x_ic_item_mst_row.item_no := p_item_no;
199:
200: IF GMIVDBL.ic_item_mst_select(x_ic_item_mst_row, x_ic_item_mst_row)
201: THEN
202: -- Jatinder - B3158806 Removed the CPG install check.
203: x_ic_item_cpg_row.item_id := x_ic_item_mst_row.item_id;
204: IF GMIVDBL.ic_item_cpg_select(x_ic_item_cpg_row, x_ic_item_cpg_row) THEN

Line 204: IF GMIVDBL.ic_item_cpg_select(x_ic_item_cpg_row, x_ic_item_cpg_row) THEN

200: IF GMIVDBL.ic_item_mst_select(x_ic_item_mst_row, x_ic_item_mst_row)
201: THEN
202: -- Jatinder - B3158806 Removed the CPG install check.
203: x_ic_item_cpg_row.item_id := x_ic_item_mst_row.item_id;
204: IF GMIVDBL.ic_item_cpg_select(x_ic_item_cpg_row, x_ic_item_cpg_row) THEN
205: RETURN;
206: END IF;
207: RETURN;
208: END IF;

Line 251: IF GMIVDBL.ic_lots_mst_select(x_ic_lots_mst_row, x_ic_lots_mst_row)

247: x_ic_lots_mst_row.item_id := p_item_id;
248: x_ic_lots_mst_row.lot_no := p_lot_no;
249: x_ic_lots_mst_row.sublot_no := p_sublot_no;
250:
251: IF GMIVDBL.ic_lots_mst_select(x_ic_lots_mst_row, x_ic_lots_mst_row)
252: THEN
253: /* Jalaj Srivastava - Bug 3158806. Remove CPG_INSTALL check. */
254: x_ic_lots_cpg_row.item_id := x_ic_lots_mst_row.item_id;
255: x_ic_lots_cpg_row.lot_id := x_ic_lots_mst_row.lot_id;

Line 256: IF GMIVDBL.ic_lots_cpg_select(x_ic_lots_cpg_row, x_ic_lots_cpg_row)

252: THEN
253: /* Jalaj Srivastava - Bug 3158806. Remove CPG_INSTALL check. */
254: x_ic_lots_cpg_row.item_id := x_ic_lots_mst_row.item_id;
255: x_ic_lots_cpg_row.lot_id := x_ic_lots_mst_row.lot_id;
256: IF GMIVDBL.ic_lots_cpg_select(x_ic_lots_cpg_row, x_ic_lots_cpg_row)
257: THEN
258: RETURN;
259: END IF;
260: RETURN;

Line 294: IF GMIVDBL.ic_whse_mst_select(x_ic_whse_mst_row, x_ic_whse_mst_row)

290: )
291: IS
292: BEGIN
293: x_ic_whse_mst_row.whse_code := p_whse_code;
294: IF GMIVDBL.ic_whse_mst_select(x_ic_whse_mst_row, x_ic_whse_mst_row)
295: THEN
296: RETURN;
297: END IF;
298:

Line 340: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row)

336: x_ic_loct_inv_row.whse_code := p_whse_code;
337: x_ic_loct_inv_row.lot_id := p_lot_id;
338: x_ic_loct_inv_row.location := p_location;
339:
340: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row)
341: THEN
342: RETURN;
343: END IF;
344:

Line 381: IF GMIVDBL.sy_uoms_mst_select(x_sy_uoms_mst_row, x_sy_uoms_mst_row)

377: )
378: IS
379: BEGIN
380: x_sy_uoms_mst_row.um_code := p_um_code;
381: IF GMIVDBL.sy_uoms_mst_select(x_sy_uoms_mst_row, x_sy_uoms_mst_row)
382: THEN
383: x_sy_uoms_typ_row.um_type := x_sy_uoms_mst_row.um_type;
384: IF GMIVDBL.sy_uoms_typ_select (x_sy_uoms_typ_row, x_sy_uoms_typ_row)
385: THEN

Line 384: IF GMIVDBL.sy_uoms_typ_select (x_sy_uoms_typ_row, x_sy_uoms_typ_row)

380: x_sy_uoms_mst_row.um_code := p_um_code;
381: IF GMIVDBL.sy_uoms_mst_select(x_sy_uoms_mst_row, x_sy_uoms_mst_row)
382: THEN
383: x_sy_uoms_typ_row.um_type := x_sy_uoms_mst_row.um_type;
384: IF GMIVDBL.sy_uoms_typ_select (x_sy_uoms_typ_row, x_sy_uoms_typ_row)
385: THEN
386: RETURN;
387: END IF;
388: END IF;

Line 405: IF GMIVDBL.qc_actn_mst_select(x_qc_actn_mst_row, x_qc_actn_mst_row)

401: RETURN BOOLEAN
402: IS
403: BEGIN
404: x_qc_actn_mst_row.action_code := p_action_code;
405: IF GMIVDBL.qc_actn_mst_select(x_qc_actn_mst_row, x_qc_actn_mst_row)
406: THEN
407: IF x_qc_actn_mst_row.delete_mark = 0
408: THEN
409: RETURN TRUE;

Line 431: IF GMIVDBL.qc_grad_mst_select(x_qc_grad_mst_row, x_qc_grad_mst_row)

427: RETURN BOOLEAN
428: IS
429: BEGIN
430: x_qc_grad_mst_row.qc_grade := p_qc_grade;
431: IF GMIVDBL.qc_grad_mst_select(x_qc_grad_mst_row, x_qc_grad_mst_row)
432: THEN
433: IF x_qc_grad_mst_row.delete_mark = 0
434: THEN
435: RETURN TRUE;

Line 455: IF GMIVDBL.sy_reas_cds_select(x_sy_reas_cds_row, x_sy_reas_cds_row)

451: RETURN BOOLEAN
452: IS
453: BEGIN
454: x_sy_reas_cds_row.reason_code := p_reason_code;
455: IF GMIVDBL.sy_reas_cds_select(x_sy_reas_cds_row, x_sy_reas_cds_row)
456: THEN
457: IF x_sy_reas_cds_row.delete_mark = 0
458: THEN
459: RETURN TRUE;

Line 479: IF GMIVDBL.po_vend_mst_select(x_po_vend_mst_row, x_po_vend_mst_row)

475: RETURN BOOLEAN
476: IS
477: BEGIN
478: x_po_vend_mst_row.vendor_no := p_vendor_no;
479: IF GMIVDBL.po_vend_mst_select(x_po_vend_mst_row, x_po_vend_mst_row)
480: THEN
481: IF x_po_vend_mst_row.delete_mark = 0
482: THEN
483: RETURN TRUE;

Line 504: IF GMIVDBL.ic_lots_sts_select(x_ic_lots_sts_row, x_ic_lots_sts_row)

500: RETURN BOOLEAN
501: IS
502: BEGIN
503: x_ic_lots_sts_row.lot_status := p_lot_status;
504: IF GMIVDBL.ic_lots_sts_select(x_ic_lots_sts_row, x_ic_lots_sts_row)
505: THEN
506: IF x_ic_lots_sts_row.delete_mark = 0
507: THEN
508: RETURN TRUE;

Line 531: IF GMIVDBL.ic_xfer_mst_select(x_ic_xfer_mst_row, x_ic_xfer_mst_row)

527: BEGIN
528: x_ic_xfer_mst_row.orgn_code := p_orgn_code;
529: x_ic_xfer_mst_row.transfer_no := p_transfer_no;
530:
531: IF GMIVDBL.ic_xfer_mst_select(x_ic_xfer_mst_row, x_ic_xfer_mst_row)
532: THEN
533: RETURN;
534: END IF;
535: