eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_LSQ_PVT dependencies on OKC_K_SEQ_LINES

Line 58: /* cursor c (p_line_code okc_k_seq_lines.line_code%TYPE) is

54: -- End of comments
55: PROCEDURE validate_doc_sequence_id(x_return_status OUT NOCOPY VARCHAR2,
56: p_lsqv_rec IN lsqv_rec_type) is
57:
58: /* cursor c (p_line_code okc_k_seq_lines.line_code%TYPE) is
59: select 'x'
60: from okc_k_seq_header
61: where line_code = p_line_code;
62: This cursor will be replaced by the fnd_document */

Line 126: cursor c (p_cls_code okc_k_seq_lines.cls_code%TYPE) is

122: PROCEDURE validate_cls_code(x_return_status OUT NOCOPY VARCHAR2,
123: p_lsqv_rec IN lsqv_rec_type) is
124:
125: -- Cursor to make sure it is a valid class
126: cursor c (p_cls_code okc_k_seq_lines.cls_code%TYPE) is
127: select 'x'
128: from okc_classes_b
129: where code = p_cls_code;
130:

Line 183: cursor c (p_scs_code okc_k_seq_lines.scs_code%TYPE) is

179: PROCEDURE validate_scs_code(x_return_status OUT NOCOPY VARCHAR2,
180: p_lsqv_rec IN lsqv_rec_type) is
181:
182: -- Cursor to make sure the category is a valid one
183: cursor c (p_scs_code okc_k_seq_lines.scs_code%TYPE) is
184: select 'x'
185: from okc_subclasses_b
186: where code = p_scs_code;
187:

Line 352: -- FUNCTION get_rec for: OKC_K_SEQ_LINES

348: null;
349: END api_copy;
350:
351: ---------------------------------------------------------------------------
352: -- FUNCTION get_rec for: OKC_K_SEQ_LINES
353: ---------------------------------------------------------------------------
354: FUNCTION get_rec (
355: p_lsq_rec IN lsq_rec_type,
356: x_no_data_found OUT NOCOPY BOOLEAN

Line 358: CURSOR lsq_pk_csr (p_id IN OKC_K_SEQ_LINES.ID%TYPE) IS

354: FUNCTION get_rec (
355: p_lsq_rec IN lsq_rec_type,
356: x_no_data_found OUT NOCOPY BOOLEAN
357: ) RETURN lsq_rec_type IS
358: CURSOR lsq_pk_csr (p_id IN OKC_K_SEQ_LINES.ID%TYPE) IS
359: SELECT ID,
360: LINE_CODE,
361: DOC_SEQUENCE_ID,
362: BUSINESS_GROUP_ID,

Line 378: FROM OKC_K_SEQ_LINES

374: CREATION_DATE,
375: LAST_UPDATED_BY,
376: LAST_UPDATE_DATE,
377: LAST_UPDATE_LOGIN
378: FROM OKC_K_SEQ_LINES
379: WHERE OKC_K_SEQ_LINES.ID = p_id;
380: l_lsq_pk lsq_pk_csr%ROWTYPE;
381: l_lsq_rec lsq_rec_type;
382: BEGIN

Line 379: WHERE OKC_K_SEQ_LINES.ID = p_id;

375: LAST_UPDATED_BY,
376: LAST_UPDATE_DATE,
377: LAST_UPDATE_LOGIN
378: FROM OKC_K_SEQ_LINES
379: WHERE OKC_K_SEQ_LINES.ID = p_id;
380: l_lsq_pk lsq_pk_csr%ROWTYPE;
381: l_lsq_rec lsq_rec_type;
382: BEGIN
383: x_no_data_found := TRUE;

Line 419: -- FUNCTION get_rec for: OKC_K_SEQ_LINES_V

415: BEGIN
416: RETURN(get_rec(p_lsq_rec, l_row_notfound));
417: END get_rec;
418: ---------------------------------------------------------------------------
419: -- FUNCTION get_rec for: OKC_K_SEQ_LINES_V
420: ---------------------------------------------------------------------------
421: FUNCTION get_rec (
422: p_lsqv_rec IN lsqv_rec_type,
423: x_no_data_found OUT NOCOPY BOOLEAN

Line 425: CURSOR okc_lsqv_pk_csr (p_id IN OKC_K_SEQ_LINES_V.ID%TYPE) IS

421: FUNCTION get_rec (
422: p_lsqv_rec IN lsqv_rec_type,
423: x_no_data_found OUT NOCOPY BOOLEAN
424: ) RETURN lsqv_rec_type IS
425: CURSOR okc_lsqv_pk_csr (p_id IN OKC_K_SEQ_LINES_V.ID%TYPE) IS
426: SELECT
427: ID,
428: LINE_CODE,
429: DOC_SEQUENCE_ID,

Line 446: FROM OKC_K_SEQ_LINES_V

442: CREATION_DATE,
443: LAST_UPDATED_BY,
444: LAST_UPDATE_DATE,
445: LAST_UPDATE_LOGIN
446: FROM OKC_K_SEQ_LINES_V
447: WHERE OKC_K_SEQ_LINES_V.ID = p_id;
448: l_okc_lsqv_pk okc_lsqv_pk_csr%ROWTYPE;
449: l_lsqv_rec lsqv_rec_type;
450: BEGIN

Line 447: WHERE OKC_K_SEQ_LINES_V.ID = p_id;

443: LAST_UPDATED_BY,
444: LAST_UPDATE_DATE,
445: LAST_UPDATE_LOGIN
446: FROM OKC_K_SEQ_LINES_V
447: WHERE OKC_K_SEQ_LINES_V.ID = p_id;
448: l_okc_lsqv_pk okc_lsqv_pk_csr%ROWTYPE;
449: l_lsqv_rec lsqv_rec_type;
450: BEGIN
451: x_no_data_found := TRUE;

Line 488: -- FUNCTION null_out_defaults for: OKC_K_SEQ_LINES_V --

484: RETURN(get_rec(p_lsqv_rec, l_row_notfound));
485: END get_rec;
486:
487: ------------------------------------------------------
488: -- FUNCTION null_out_defaults for: OKC_K_SEQ_LINES_V --
489: ------------------------------------------------------
490: FUNCTION null_out_defaults (
491: p_lsqv_rec IN lsqv_rec_type
492: ) RETURN lsqv_rec_type IS

Line 558: -- Validate_Attributes for:OKC_K_SEQ_LINES_V --

554: ---------------------------------------------------------------------------
555: -- PROCEDURE Validate_Attributes
556: ---------------------------------------------------------------------------
557: ----------------------------------------------
558: -- Validate_Attributes for:OKC_K_SEQ_LINES_V --
559: ----------------------------------------------
560: FUNCTION Validate_Attributes (
561: p_lsqv_rec IN lsqv_rec_type
562: ) RETURN VARCHAR2 IS

Line 651: -- Validate_Record for:OKC_K_SEQ_LINES_V --

647: ---------------------------------------------------------------------------
648: -- PROCEDURE Validate_Record
649: ---------------------------------------------------------------------------
650: ------------------------------------------
651: -- Validate_Record for:OKC_K_SEQ_LINES_V --
652: ------------------------------------------
653: FUNCTION Validate_Record (
654: p_lsqv_rec IN lsqv_rec_type
655: ) RETURN VARCHAR2 IS

Line 670: FROM OKC_K_SEQ_LINES

666:
667: -- Cursor to make sure there is only 1 detail for site
668: CURSOR cur_lsq is
669: SELECT count(*)
670: FROM OKC_K_SEQ_LINES
671: WHERE id <> p_lsqv_rec.id
672: AND line_code = 'SITE';
673:
674: -- Depending on what has been selected in the header,

Line 682: CURSOR c1(p_business_group_id OKC_K_SEQ_LINES.BUSINESS_GROUP_ID%TYPE,

678: -- The following cursors are one each for the above combinations, to
679: -- make sure that there is no duplicate combination already existing
680: -- in the database.
681:
682: CURSOR c1(p_business_group_id OKC_K_SEQ_LINES.BUSINESS_GROUP_ID%TYPE,
683: p_cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE) IS
684: SELECT 'x'
685: FROM OKC_K_SEQ_LINES
686: WHERE business_group_id = p_business_group_id

Line 683: p_cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE) IS

679: -- make sure that there is no duplicate combination already existing
680: -- in the database.
681:
682: CURSOR c1(p_business_group_id OKC_K_SEQ_LINES.BUSINESS_GROUP_ID%TYPE,
683: p_cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE) IS
684: SELECT 'x'
685: FROM OKC_K_SEQ_LINES
686: WHERE business_group_id = p_business_group_id
687: AND cls_code = p_cls_code

Line 685: FROM OKC_K_SEQ_LINES

681:
682: CURSOR c1(p_business_group_id OKC_K_SEQ_LINES.BUSINESS_GROUP_ID%TYPE,
683: p_cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE) IS
684: SELECT 'x'
685: FROM OKC_K_SEQ_LINES
686: WHERE business_group_id = p_business_group_id
687: AND cls_code = p_cls_code
688: AND id <> p_lsqv_rec.id;
689:

Line 690: CURSOR c2(p_business_group_id OKC_K_SEQ_LINES.BUSINESS_GROUP_ID%TYPE,

686: WHERE business_group_id = p_business_group_id
687: AND cls_code = p_cls_code
688: AND id <> p_lsqv_rec.id;
689:
690: CURSOR c2(p_business_group_id OKC_K_SEQ_LINES.BUSINESS_GROUP_ID%TYPE,
691: p_scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE) IS
692: SELECT 'x'
693: FROM OKC_K_SEQ_LINES
694: WHERE business_group_id = p_business_group_id

Line 691: p_scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE) IS

687: AND cls_code = p_cls_code
688: AND id <> p_lsqv_rec.id;
689:
690: CURSOR c2(p_business_group_id OKC_K_SEQ_LINES.BUSINESS_GROUP_ID%TYPE,
691: p_scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE) IS
692: SELECT 'x'
693: FROM OKC_K_SEQ_LINES
694: WHERE business_group_id = p_business_group_id
695: AND scs_code = p_scs_code

Line 693: FROM OKC_K_SEQ_LINES

689:
690: CURSOR c2(p_business_group_id OKC_K_SEQ_LINES.BUSINESS_GROUP_ID%TYPE,
691: p_scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE) IS
692: SELECT 'x'
693: FROM OKC_K_SEQ_LINES
694: WHERE business_group_id = p_business_group_id
695: AND scs_code = p_scs_code
696: AND id <> p_lsqv_rec.id;
697:

Line 698: CURSOR c3(p_business_group_id OKC_K_SEQ_LINES.BUSINESS_GROUP_ID%TYPE) IS

694: WHERE business_group_id = p_business_group_id
695: AND scs_code = p_scs_code
696: AND id <> p_lsqv_rec.id;
697:
698: CURSOR c3(p_business_group_id OKC_K_SEQ_LINES.BUSINESS_GROUP_ID%TYPE) IS
699: SELECT 'x'
700: FROM OKC_K_SEQ_LINES
701: WHERE business_group_id = p_business_group_id
702: AND cls_code is null

Line 700: FROM OKC_K_SEQ_LINES

696: AND id <> p_lsqv_rec.id;
697:
698: CURSOR c3(p_business_group_id OKC_K_SEQ_LINES.BUSINESS_GROUP_ID%TYPE) IS
699: SELECT 'x'
700: FROM OKC_K_SEQ_LINES
701: WHERE business_group_id = p_business_group_id
702: AND cls_code is null
703: AND scs_code is null
704: AND id <> p_lsqv_rec.id;

Line 706: CURSOR c4(p_operating_unit_id OKC_K_SEQ_LINES.OPERATING_UNIT_ID%TYPE,

702: AND cls_code is null
703: AND scs_code is null
704: AND id <> p_lsqv_rec.id;
705:
706: CURSOR c4(p_operating_unit_id OKC_K_SEQ_LINES.OPERATING_UNIT_ID%TYPE,
707: p_cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE) IS
708: SELECT 'x'
709: FROM OKC_K_SEQ_LINES
710: WHERE operating_unit_id = p_operating_unit_id

Line 707: p_cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE) IS

703: AND scs_code is null
704: AND id <> p_lsqv_rec.id;
705:
706: CURSOR c4(p_operating_unit_id OKC_K_SEQ_LINES.OPERATING_UNIT_ID%TYPE,
707: p_cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE) IS
708: SELECT 'x'
709: FROM OKC_K_SEQ_LINES
710: WHERE operating_unit_id = p_operating_unit_id
711: AND cls_code = p_cls_code

Line 709: FROM OKC_K_SEQ_LINES

705:
706: CURSOR c4(p_operating_unit_id OKC_K_SEQ_LINES.OPERATING_UNIT_ID%TYPE,
707: p_cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE) IS
708: SELECT 'x'
709: FROM OKC_K_SEQ_LINES
710: WHERE operating_unit_id = p_operating_unit_id
711: AND cls_code = p_cls_code
712: AND id <> p_lsqv_rec.id;
713:

Line 714: CURSOR c5(p_operating_unit_id OKC_K_SEQ_LINES.OPERATING_UNIT_ID%TYPE,

710: WHERE operating_unit_id = p_operating_unit_id
711: AND cls_code = p_cls_code
712: AND id <> p_lsqv_rec.id;
713:
714: CURSOR c5(p_operating_unit_id OKC_K_SEQ_LINES.OPERATING_UNIT_ID%TYPE,
715: p_scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE) IS
716: SELECT 'x'
717: FROM OKC_K_SEQ_LINES
718: WHERE operating_unit_id = p_operating_unit_id

Line 715: p_scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE) IS

711: AND cls_code = p_cls_code
712: AND id <> p_lsqv_rec.id;
713:
714: CURSOR c5(p_operating_unit_id OKC_K_SEQ_LINES.OPERATING_UNIT_ID%TYPE,
715: p_scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE) IS
716: SELECT 'x'
717: FROM OKC_K_SEQ_LINES
718: WHERE operating_unit_id = p_operating_unit_id
719: AND scs_code = p_scs_code

Line 717: FROM OKC_K_SEQ_LINES

713:
714: CURSOR c5(p_operating_unit_id OKC_K_SEQ_LINES.OPERATING_UNIT_ID%TYPE,
715: p_scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE) IS
716: SELECT 'x'
717: FROM OKC_K_SEQ_LINES
718: WHERE operating_unit_id = p_operating_unit_id
719: AND scs_code = p_scs_code
720: AND id <> p_lsqv_rec.id;
721:

Line 722: CURSOR c6(p_operating_unit_id OKC_K_SEQ_LINES.OPERATING_UNIT_ID%TYPE) IS

718: WHERE operating_unit_id = p_operating_unit_id
719: AND scs_code = p_scs_code
720: AND id <> p_lsqv_rec.id;
721:
722: CURSOR c6(p_operating_unit_id OKC_K_SEQ_LINES.OPERATING_UNIT_ID%TYPE) IS
723: SELECT 'x'
724: FROM OKC_K_SEQ_LINES
725: WHERE operating_unit_id = p_operating_unit_id
726: AND cls_code is null

Line 724: FROM OKC_K_SEQ_LINES

720: AND id <> p_lsqv_rec.id;
721:
722: CURSOR c6(p_operating_unit_id OKC_K_SEQ_LINES.OPERATING_UNIT_ID%TYPE) IS
723: SELECT 'x'
724: FROM OKC_K_SEQ_LINES
725: WHERE operating_unit_id = p_operating_unit_id
726: AND cls_code is null
727: AND scs_code is null
728: AND id <> p_lsqv_rec.id;

Line 730: CURSOR c7(p_cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE) IS

726: AND cls_code is null
727: AND scs_code is null
728: AND id <> p_lsqv_rec.id;
729:
730: CURSOR c7(p_cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE) IS
731: SELECT 'x'
732: FROM OKC_K_SEQ_LINES
733: WHERE cls_code = p_cls_code
734: AND business_group_id is null

Line 732: FROM OKC_K_SEQ_LINES

728: AND id <> p_lsqv_rec.id;
729:
730: CURSOR c7(p_cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE) IS
731: SELECT 'x'
732: FROM OKC_K_SEQ_LINES
733: WHERE cls_code = p_cls_code
734: AND business_group_id is null
735: AND operating_unit_id is null
736: AND id <> p_lsqv_rec.id;

Line 738: CURSOR c8(p_scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE) IS

734: AND business_group_id is null
735: AND operating_unit_id is null
736: AND id <> p_lsqv_rec.id;
737:
738: CURSOR c8(p_scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE) IS
739: SELECT 'x'
740: FROM OKC_K_SEQ_LINES
741: WHERE scs_code = p_scs_code
742: AND business_group_id is null

Line 740: FROM OKC_K_SEQ_LINES

736: AND id <> p_lsqv_rec.id;
737:
738: CURSOR c8(p_scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE) IS
739: SELECT 'x'
740: FROM OKC_K_SEQ_LINES
741: WHERE scs_code = p_scs_code
742: AND business_group_id is null
743: AND operating_unit_id is null
744: AND id <> p_lsqv_rec.id;

Line 985: -- validate_row for:OKC_K_SEQ_LINES_V --

981: ---------------------------------------------------------------------------
982: -- PROCEDURE validate_row
983: ---------------------------------------------------------------------------
984: ---------------------------------------
985: -- validate_row for:OKC_K_SEQ_LINES_V --
986: ---------------------------------------
987: PROCEDURE validate_row(
988: p_api_version IN NUMBER,
989: p_init_msg_list IN VARCHAR2 ,

Line 1140: -- insert_row for:OKC_K_SEQ_LINES --

1136: ---------------------------------------------------------------------------
1137: -- PROCEDURE insert_row
1138: ---------------------------------------------------------------------------
1139: -----------------------------------
1140: -- insert_row for:OKC_K_SEQ_LINES --
1141: -----------------------------------
1142: PROCEDURE insert_row(
1143: p_init_msg_list IN VARCHAR2 ,
1144: x_return_status OUT NOCOPY VARCHAR2,

Line 1156: -- Set_Attributes for:OKC_K_SEQ_LINES --

1152: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1153: l_lsq_rec lsq_rec_type := p_lsq_rec;
1154: l_def_lsq_rec lsq_rec_type;
1155: ---------------------------------------
1156: -- Set_Attributes for:OKC_K_SEQ_LINES --
1157: ---------------------------------------
1158: FUNCTION Set_Attributes (
1159: p_lsq_rec IN lsq_rec_type,
1160: x_lsq_rec OUT NOCOPY lsq_rec_type

Line 1187: INSERT INTO OKC_K_SEQ_LINES(

1183: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1185: RAISE OKC_API.G_EXCEPTION_ERROR;
1186: END IF;
1187: INSERT INTO OKC_K_SEQ_LINES(
1188: id,
1189: line_code,
1190: doc_sequence_id,
1191: business_group_id,

Line 1263: -- insert_row for:OKC_K_SEQ_LINES_V --

1259: '_PVT'
1260: );
1261: END insert_row;
1262: -------------------------------------
1263: -- insert_row for:OKC_K_SEQ_LINES_V --
1264: -------------------------------------
1265: PROCEDURE insert_row(
1266: p_api_version IN NUMBER,
1267: p_init_msg_list IN VARCHAR2 ,

Line 1297: -- Set_Attributes for:OKC_K_SEQ_LINES_V --

1293: l_lsqv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1294: RETURN(l_lsqv_rec);
1295: END fill_who_columns;
1296: -----------------------------------------
1297: -- Set_Attributes for:OKC_K_SEQ_LINES_V --
1298: -----------------------------------------
1299: FUNCTION Set_Attributes (
1300: p_lsqv_rec IN lsqv_rec_type,
1301: x_lsqv_rec OUT NOCOPY lsqv_rec_type

Line 1489: -- lock_row for:OKC_K_SEQ_LINES --

1485: ---------------------------------------------------------------------------
1486: -- PROCEDURE lock_row
1487: ---------------------------------------------------------------------------
1488: ---------------------------------
1489: -- lock_row for:OKC_K_SEQ_LINES --
1490: ---------------------------------
1491: PROCEDURE lock_row(
1492: p_init_msg_list IN VARCHAR2 ,
1493: x_return_status OUT NOCOPY VARCHAR2,

Line 1502: FROM OKC_K_SEQ_LINES

1498: E_Resource_Busy EXCEPTION;
1499: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1500: CURSOR lock_csr (p_lsq_rec IN lsq_rec_type) IS
1501: SELECT OBJECT_VERSION_NUMBER
1502: FROM OKC_K_SEQ_LINES
1503: WHERE ID = p_lsq_rec.id
1504: AND OBJECT_VERSION_NUMBER = p_lsq_rec.object_version_number
1505: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1506:

Line 1509: FROM OKC_K_SEQ_LINES

1505: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1506:
1507: CURSOR lchk_csr (p_lsq_rec IN lsq_rec_type) IS
1508: SELECT OBJECT_VERSION_NUMBER
1509: FROM OKC_K_SEQ_LINES
1510: WHERE ID = p_lsq_rec.id;
1511: l_api_version CONSTANT NUMBER := 1;
1512: l_api_name CONSTANT VARCHAR2(30) := 'L_SEQ_lock_row';
1513: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1514: l_object_version_number OKC_K_SEQ_LINES.OBJECT_VERSION_NUMBER%TYPE;

1510: WHERE ID = p_lsq_rec.id;
1511: l_api_version CONSTANT NUMBER := 1;
1512: l_api_name CONSTANT VARCHAR2(30) := 'L_SEQ_lock_row';
1513: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1514: l_object_version_number OKC_K_SEQ_LINES.OBJECT_VERSION_NUMBER%TYPE;
1515: lc_object_version_number OKC_K_SEQ_LINES.OBJECT_VERSION_NUMBER%TYPE;
1516: l_row_notfound BOOLEAN := FALSE;
1517: lc_row_notfound BOOLEAN := FALSE;
1518: BEGIN

Line 1515: lc_object_version_number OKC_K_SEQ_LINES.OBJECT_VERSION_NUMBER%TYPE;

1511: l_api_version CONSTANT NUMBER := 1;
1512: l_api_name CONSTANT VARCHAR2(30) := 'L_SEQ_lock_row';
1513: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1514: l_object_version_number OKC_K_SEQ_LINES.OBJECT_VERSION_NUMBER%TYPE;
1515: lc_object_version_number OKC_K_SEQ_LINES.OBJECT_VERSION_NUMBER%TYPE;
1516: l_row_notfound BOOLEAN := FALSE;
1517: lc_row_notfound BOOLEAN := FALSE;
1518: BEGIN
1519: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1595: -- lock_row for:OKC_K_SEQ_LINES_V --

1591: '_PVT'
1592: );
1593: END lock_row;
1594: -----------------------------------
1595: -- lock_row for:OKC_K_SEQ_LINES_V --
1596: -----------------------------------
1597: PROCEDURE lock_row(
1598: p_api_version IN NUMBER,
1599: p_init_msg_list IN VARCHAR2 ,

Line 1754: -- update_row for:OKC_K_SEQ_LINES --

1750: ---------------------------------------------------------------------------
1751: -- PROCEDURE update_row
1752: ---------------------------------------------------------------------------
1753: -----------------------------------
1754: -- update_row for:OKC_K_SEQ_LINES --
1755: -----------------------------------
1756: PROCEDURE update_row(
1757: p_init_msg_list IN VARCHAR2 ,
1758: x_return_status OUT NOCOPY VARCHAR2,

Line 1863: -- Set_Attributes for:OKC_K_SEQ_LINES --

1859: END IF;
1860: RETURN(l_return_status);
1861: END populate_new_record;
1862: ---------------------------------------
1863: -- Set_Attributes for:OKC_K_SEQ_LINES --
1864: ---------------------------------------
1865: FUNCTION Set_Attributes (
1866: p_lsq_rec IN lsq_rec_type,
1867: x_lsq_rec OUT NOCOPY lsq_rec_type

Line 1900: UPDATE OKC_K_SEQ_LINES

1896: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1897: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1898: RAISE OKC_API.G_EXCEPTION_ERROR;
1899: END IF;
1900: UPDATE OKC_K_SEQ_LINES
1901: SET LINE_CODE = l_def_lsq_rec.line_code,
1902: DOC_SEQUENCE_ID = l_def_lsq_rec.doc_sequence_id,
1903: BUSINESS_GROUP_ID = l_def_lsq_rec.business_group_id,
1904: OPERATING_UNIT_ID = l_def_lsq_rec.operating_unit_id,

Line 1956: -- update_row for:OKC_K_SEQ_LINES_V --

1952: '_PVT'
1953: );
1954: END update_row;
1955: -------------------------------------
1956: -- update_row for:OKC_K_SEQ_LINES_V --
1957: -------------------------------------
1958: PROCEDURE update_row(
1959: p_api_version IN NUMBER,
1960: p_init_msg_list IN VARCHAR2 ,

Line 2079: -- Set_Attributes for:OKC_K_SEQ_LINES_V --

2075: END IF;
2076: RETURN(l_return_status);
2077: END populate_new_record;
2078: -----------------------------------------
2079: -- Set_Attributes for:OKC_K_SEQ_LINES_V --
2080: -----------------------------------------
2081: FUNCTION Set_Attributes (
2082: p_lsqv_rec IN lsqv_rec_type,
2083: x_lsqv_rec OUT NOCOPY lsqv_rec_type

Line 2262: -- delete_row for:OKC_K_SEQ_LINES --

2258: ---------------------------------------------------------------------------
2259: -- PROCEDURE delete_row
2260: ---------------------------------------------------------------------------
2261: -----------------------------------
2262: -- delete_row for:OKC_K_SEQ_LINES --
2263: -----------------------------------
2264: PROCEDURE delete_row(
2265: p_init_msg_list IN VARCHAR2 ,
2266: x_return_status OUT NOCOPY VARCHAR2,

Line 2286: DELETE FROM OKC_K_SEQ_LINES

2282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2283: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2284: RAISE OKC_API.G_EXCEPTION_ERROR;
2285: END IF;
2286: DELETE FROM OKC_K_SEQ_LINES
2287: WHERE ID = l_lsq_rec.id;
2288:
2289: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2290: EXCEPTION

Line 2323: -- delete_row for:OKC_K_SEQ_LINES_V --

2319: '_PVT'
2320: );
2321: END delete_row;
2322: -------------------------------------
2323: -- delete_row for:OKC_K_SEQ_LINES_V --
2324: -------------------------------------
2325: PROCEDURE delete_row(
2326: p_api_version IN NUMBER,
2327: p_init_msg_list IN VARCHAR2 ,