APPS.GMIVDBL dependencies on DUAL

Line 88: SELECT gem5_item_id_s.nextval INTO x_ic_item_mst_row.item_id FROM dual;

84:
85: /* Fill in any missing surrogates; */
86: IF x_ic_item_mst_row.item_id IS NULL
87: THEN
88: SELECT gem5_item_id_s.nextval INTO x_ic_item_mst_row.item_id FROM dual;
89: END IF;
90:
91: IF x_ic_item_mst_row.whse_item_id IS NULL
92: THEN

Line 106: , dualum_ind

102: , item_desc2
103: , alt_itema
104: , alt_itemb
105: , item_um
106: , dualum_ind
107: , item_um2
108: , deviation_lo
109: , deviation_hi
110: , level_code

Line 204: , x_ic_item_mst_row.dualum_ind

200: , x_ic_item_mst_row.item_desc2
201: , x_ic_item_mst_row.alt_itema
202: , x_ic_item_mst_row.alt_itemb
203: , x_ic_item_mst_row.item_um
204: , x_ic_item_mst_row.dualum_ind
205: , x_ic_item_mst_row.item_um2
206: , x_ic_item_mst_row.deviation_lo
207: , x_ic_item_mst_row.deviation_hi
208: , x_ic_item_mst_row.level_code

Line 860: SELECT gem5_lot_id_s.nextval INTO x_ic_lots_mst_row.lot_id FROM dual;

856: x_ic_lots_mst_row := p_ic_lots_mst_row;
857:
858: IF x_ic_lots_mst_row.lot_id IS NULL
859: THEN
860: SELECT gem5_lot_id_s.nextval INTO x_ic_lots_mst_row.lot_id FROM dual;
861: END IF;
862:
863: INSERT INTO ic_lots_mst
864: ( item_id

Line 1236: SELECT gem5_journal_id_s.nextval INTO x_ic_jrnl_mst_row.journal_id FROM DUAL;

1232: x_ic_jrnl_mst_row := p_ic_jrnl_mst_row;
1233:
1234: IF x_ic_jrnl_mst_row.journal_id IS NULL
1235: THEN
1236: SELECT gem5_journal_id_s.nextval INTO x_ic_jrnl_mst_row.journal_id FROM DUAL;
1237: END IF;
1238:
1239: INSERT INTO ic_jrnl_mst
1240: ( journal_id

Line 1402: SELECT gem5_doc_id_s.nextval INTO x_ic_adjs_jnl_row.doc_id FROM dual;

1398: x_ic_adjs_jnl_row := p_ic_adjs_jnl_row;
1399:
1400: IF x_ic_adjs_jnl_row.doc_id IS NULL
1401: THEN
1402: SELECT gem5_doc_id_s.nextval INTO x_ic_adjs_jnl_row.doc_id FROM dual;
1403: END IF;
1404:
1405: IF x_ic_adjs_jnl_row.line_id IS NULL
1406: THEN

Line 1407: SELECT gem5_line_id_s.nextval INTO x_ic_adjs_jnl_row.line_id FROM dual;

1403: END IF;
1404:
1405: IF x_ic_adjs_jnl_row.line_id IS NULL
1406: THEN
1407: SELECT gem5_line_id_s.nextval INTO x_ic_adjs_jnl_row.line_id FROM dual;
1408: END IF;
1409:
1410: INSERT INTO ic_adjs_jnl
1411: ( trans_type

Line 1547: x_ic_item_cnv_row.conversion_id from dual;

1543: x_ic_item_cnv_row := p_ic_item_cnv_row;
1544:
1545: IF (x_ic_item_cnv_row.conversion_id IS NULL) THEN
1546: select gmi_conversion_id_s.nextval into
1547: x_ic_item_cnv_row.conversion_id from dual;
1548: END IF;
1549: INSERT INTO ic_item_cnv
1550: ( item_id
1551: , lot_id

Line 1586: x_conv_audit_id from dual;

1582: /* 15-Apr-2003 Joe DiIorio Bug 2880585 11.5.1K - */
1583:
1584: /* 24-June-2003 Joe DiIorio Bug 3022564 11.5.10K - */
1585: select gmi_conv_audit_id_s.nextval into
1586: x_conv_audit_id from dual;
1587:
1588: INSERT INTO gmi_item_conv_audit
1589: ( conv_audit_id
1590: , conversion_id

Line 1920: FROM dual;

1916: x_ic_xfer_mst_row := p_ic_xfer_mst_row;
1917: IF x_ic_xfer_mst_row.transfer_id IS NULL
1918: THEN
1919: SELECT gem5_transfer_id.nextval INTO x_ic_xfer_mst_row.transfer_id
1920: FROM dual;
1921: END IF;
1922:
1923: INSERT INTO ic_xfer_mst
1924: (transfer_id,