DBA Data[Home] [Help]

APPS.OKC_LSQ_PVT dependencies on OKC_K_SEQ_LINES_V

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 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 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 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 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 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 ,