APPS.GMIVDBX dependencies on DUAL

Line 95: SELECT gmi_dxfr_transfer_id_s.nextval INTO x_hdr_row.transfer_id FROM DUAL;

91:
92: x_return_status :=FND_API.G_RET_STS_SUCCESS;
93:
94: --assign the transfer id.
95: SELECT gmi_dxfr_transfer_id_s.nextval INTO x_hdr_row.transfer_id FROM DUAL;
96:
97: x_hdr_row.orgn_code := p_hdr_rec.orgn_code;
98: x_hdr_row.co_code := p_hdr_rec.co_code;
99: x_hdr_row.transfer_number := p_hdr_rec.transfer_number;

Line 329: SELECT gmi_dxfr_line_id_s.nextval INTO x_line_row.line_id FROM DUAL;

325:
326: x_line_row.transfer_id := p_hdr_row.transfer_id;
327:
328: --get the line id
329: SELECT gmi_dxfr_line_id_s.nextval INTO x_line_row.line_id FROM DUAL;
330:
331: x_line_row.line_no := p_line_rec.line_no;
332: x_line_row.opm_item_id := p_line_rec.opm_item_id;
333: x_line_row.opm_whse_code := p_line_rec.opm_whse_code;

Line 634: SELECT gmi_dxfr_line_detail_id_s.nextval INTO x_lot_row.line_detail_id FROM DUAL;

630: x_lot_row.transfer_id := p_line_row.transfer_id;
631: x_lot_row.line_id := p_line_row.line_id;
632:
633: --get the line detail id
634: SELECT gmi_dxfr_line_detail_id_s.nextval INTO x_lot_row.line_detail_id FROM DUAL;
635:
636: x_lot_row.opm_lot_id := p_lot_rec.opm_lot_id;
637: x_lot_row.opm_lot_expiration_date := p_lot_rec.opm_lot_expiration_date;
638: x_lot_row.opm_lot_status := p_lot_rec.opm_lot_status;