DBA Data[Home] [Help]

APPS.OKL_XMP_PVT dependencies on DUAL

Line 915: SELECT okl_xmp_seq.nextval INTO l_xmp_rec.id FROM DUAL;

911: l_prog_name := G_PKG_NAME||'.insert_row (REC)';
912: OKL_API.init_msg_list(p_init_msg_list);
913:
914: -- Generate the id
915: SELECT okl_xmp_seq.nextval INTO l_xmp_rec.id FROM DUAL;
916:
917: IF l_xmp_rec.batch_id IS NULL THEN
918: -- Generate the batch id
919: SELECT okl_xmp_batch_seq.nextval INTO l_xmp_rec.batch_id FROM DUAL;

Line 919: SELECT okl_xmp_batch_seq.nextval INTO l_xmp_rec.batch_id FROM DUAL;

915: SELECT okl_xmp_seq.nextval INTO l_xmp_rec.id FROM DUAL;
916:
917: IF l_xmp_rec.batch_id IS NULL THEN
918: -- Generate the batch id
919: SELECT okl_xmp_batch_seq.nextval INTO l_xmp_rec.batch_id FROM DUAL;
920: END IF;
921:
922: l_xmp_rec.object_version_number := 1;
923: l_xmp_rec := null_out_defaults(l_xmp_rec);

Line 999: SELECT okl_xmp_batch_seq.nextval INTO l_batch_id FROM DUAL;

995: BEGIN
996: l_prog_name := G_PKG_NAME||'.insert_row (TBL)';
997: OKL_API.init_msg_list(p_init_msg_list);
998: -- Generate the batch id
999: SELECT okl_xmp_batch_seq.nextval INTO l_batch_id FROM DUAL;
1000:
1001: -- Make sure PL/SQL table has records in it before passing
1002: IF (p_xmp_tbl.COUNT > 0) THEN
1003: i := p_xmp_tbl.FIRST;