89: BEGIN
90: RETURN(get_rec(p_cgc_rec, l_row_notfound));
91: END get_rec;
92: ---------------------------------------------------------------------------
93: -- FUNCTION get_rec for: OKC_K_GRPINGS_V
94: ---------------------------------------------------------------------------
95: FUNCTION get_rec (
96: p_cgcv_rec IN cgcv_rec_type,
97: x_no_data_found OUT NOCOPY BOOLEAN
108: CREATION_DATE,
109: LAST_UPDATED_BY,
110: LAST_UPDATE_DATE,
111: LAST_UPDATE_LOGIN
112: FROM Okc_K_Grpings_V
113: WHERE okc_K_grpings_v.id = p_id;
114: l_okc_cgcv_pk okc_cgcv_pk_csr%ROWTYPE;
115: l_cgcv_rec cgcv_rec_type;
116: BEGIN
109: LAST_UPDATED_BY,
110: LAST_UPDATE_DATE,
111: LAST_UPDATE_LOGIN
112: FROM Okc_K_Grpings_V
113: WHERE okc_K_grpings_v.id = p_id;
114: l_okc_cgcv_pk okc_cgcv_pk_csr%ROWTYPE;
115: l_cgcv_rec cgcv_rec_type;
116: BEGIN
117: x_no_data_found := TRUE;
142: RETURN(get_rec(p_cgcv_rec, l_row_notfound));
143: END get_rec;
144:
145: ------------------------------------------------------------
146: -- FUNCTION null_out_defaults for: OKC_K_GRPINGS_V --
147: ------------------------------------------------------------
148: FUNCTION null_out_defaults (
149: p_cgcv_rec IN cgcv_rec_type
150: ) RETURN cgcv_rec_type IS
260: ---------------------------------------------------------------------------
261: -- PROCEDURE Validate_Attributes
262: ---------------------------------------------------------------------------
263: ----------------------------------------------------
264: -- Validate_Attributes for:OKC_K_GRPINGS_V --
265: ----------------------------------------------------
266: FUNCTION Validate_Attributes (
267: p_cgcv_rec IN cgcv_rec_type
268: ) RETURN VARCHAR2 IS
305: ---------------------------------------------------------------------------
306: -- PROCEDURE Validate_Record
307: ---------------------------------------------------------------------------
308: ------------------------------------------------
309: -- Validate_Record for:OKC_K_GRPINGS_V --
310: ------------------------------------------------
311: FUNCTION Validate_Record (
312: p_cgcv_rec IN cgcv_rec_type
313: ) RETURN VARCHAR2 IS
377: FUNCTION validate_unique_keys (
378: p_cgcv_rec IN cgcv_rec_type
379: ) RETURN VARCHAR2 IS
380: unique_key_error EXCEPTION;
381: CURSOR okc_chr_csr (p_id IN okc_k_grpings_v.id%TYPE,
382: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
383: p_included_chr_id IN okc_k_grpings_v.included_chr_id%TYPE) IS
384: SELECT 'x'
385: FROM Okc_K_Grpings_V
378: p_cgcv_rec IN cgcv_rec_type
379: ) RETURN VARCHAR2 IS
380: unique_key_error EXCEPTION;
381: CURSOR okc_chr_csr (p_id IN okc_k_grpings_v.id%TYPE,
382: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
383: p_included_chr_id IN okc_k_grpings_v.included_chr_id%TYPE) IS
384: SELECT 'x'
385: FROM Okc_K_Grpings_V
386: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
379: ) RETURN VARCHAR2 IS
380: unique_key_error EXCEPTION;
381: CURSOR okc_chr_csr (p_id IN okc_k_grpings_v.id%TYPE,
382: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
383: p_included_chr_id IN okc_k_grpings_v.included_chr_id%TYPE) IS
384: SELECT 'x'
385: FROM Okc_K_Grpings_V
386: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
387: AND okc_K_grpings_v.included_chr_id = p_included_chr_id
381: CURSOR okc_chr_csr (p_id IN okc_k_grpings_v.id%TYPE,
382: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
383: p_included_chr_id IN okc_k_grpings_v.included_chr_id%TYPE) IS
384: SELECT 'x'
385: FROM Okc_K_Grpings_V
386: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
387: AND okc_K_grpings_v.included_chr_id = p_included_chr_id
388: AND ((p_id IS NULL)
389: OR (p_id IS NOT NULL
382: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
383: p_included_chr_id IN okc_k_grpings_v.included_chr_id%TYPE) IS
384: SELECT 'x'
385: FROM Okc_K_Grpings_V
386: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
387: AND okc_K_grpings_v.included_chr_id = p_included_chr_id
388: AND ((p_id IS NULL)
389: OR (p_id IS NOT NULL
390: AND id <> p_id));
383: p_included_chr_id IN okc_k_grpings_v.included_chr_id%TYPE) IS
384: SELECT 'x'
385: FROM Okc_K_Grpings_V
386: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
387: AND okc_K_grpings_v.included_chr_id = p_included_chr_id
388: AND ((p_id IS NULL)
389: OR (p_id IS NOT NULL
390: AND id <> p_id));
391: CURSOR okc_cgp_csr (p_id IN okc_k_grpings_v.id%TYPE,
387: AND okc_K_grpings_v.included_chr_id = p_included_chr_id
388: AND ((p_id IS NULL)
389: OR (p_id IS NOT NULL
390: AND id <> p_id));
391: CURSOR okc_cgp_csr (p_id IN okc_k_grpings_v.id%TYPE,
392: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
393: p_included_cgp_id IN okc_k_grpings_v.included_cgp_id%TYPE) IS
394: SELECT 'x'
395: FROM Okc_K_Grpings_V
388: AND ((p_id IS NULL)
389: OR (p_id IS NOT NULL
390: AND id <> p_id));
391: CURSOR okc_cgp_csr (p_id IN okc_k_grpings_v.id%TYPE,
392: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
393: p_included_cgp_id IN okc_k_grpings_v.included_cgp_id%TYPE) IS
394: SELECT 'x'
395: FROM Okc_K_Grpings_V
396: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
389: OR (p_id IS NOT NULL
390: AND id <> p_id));
391: CURSOR okc_cgp_csr (p_id IN okc_k_grpings_v.id%TYPE,
392: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
393: p_included_cgp_id IN okc_k_grpings_v.included_cgp_id%TYPE) IS
394: SELECT 'x'
395: FROM Okc_K_Grpings_V
396: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
397: AND okc_K_grpings_v.included_cgp_id = p_included_cgp_id
391: CURSOR okc_cgp_csr (p_id IN okc_k_grpings_v.id%TYPE,
392: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
393: p_included_cgp_id IN okc_k_grpings_v.included_cgp_id%TYPE) IS
394: SELECT 'x'
395: FROM Okc_K_Grpings_V
396: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
397: AND okc_K_grpings_v.included_cgp_id = p_included_cgp_id
398: AND ((p_id IS NULL)
399: OR (p_id IS NOT NULL
392: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
393: p_included_cgp_id IN okc_k_grpings_v.included_cgp_id%TYPE) IS
394: SELECT 'x'
395: FROM Okc_K_Grpings_V
396: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
397: AND okc_K_grpings_v.included_cgp_id = p_included_cgp_id
398: AND ((p_id IS NULL)
399: OR (p_id IS NOT NULL
400: AND id <> p_id));
393: p_included_cgp_id IN okc_k_grpings_v.included_cgp_id%TYPE) IS
394: SELECT 'x'
395: FROM Okc_K_Grpings_V
396: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
397: AND okc_K_grpings_v.included_cgp_id = p_included_cgp_id
398: AND ((p_id IS NULL)
399: OR (p_id IS NOT NULL
400: AND id <> p_id));
401: l_okc_cgp_dummy VARCHAR2(1);
543: ---------------------------------------------------------------------------
544: -- PROCEDURE validate_row
545: ---------------------------------------------------------------------------
546: ---------------------------------------------
547: -- validate_row for:OKC_K_GRPINGS_V --
548: ---------------------------------------------
549: PROCEDURE validate_row(
550: p_api_version IN NUMBER,
551: p_init_msg_list IN VARCHAR2 ,
794: '_PVT'
795: );
796: END insert_row;
797: -------------------------------------------
798: -- insert_row for:OKC_K_GRPINGS_V --
799: -------------------------------------------
800: PROCEDURE insert_row(
801: p_api_version IN NUMBER,
802: p_init_msg_list IN VARCHAR2 ,
828: l_cgcv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
829: RETURN(l_cgcv_rec);
830: END fill_who_columns;
831: -----------------------------------------------
832: -- Set_Attributes for:OKC_K_GRPINGS_V --
833: -----------------------------------------------
834: FUNCTION Set_Attributes (
835: p_cgcv_rec IN cgcv_rec_type,
836: x_cgcv_rec OUT NOCOPY cgcv_rec_type
1121: '_PVT'
1122: );
1123: END lock_row;
1124: -----------------------------------------
1125: -- lock_row for:OKC_K_GRPINGS_V --
1126: -----------------------------------------
1127: PROCEDURE lock_row(
1128: p_api_version IN NUMBER,
1129: p_init_msg_list IN VARCHAR2 ,
1434: '_PVT'
1435: );
1436: END update_row;
1437: -------------------------------------------
1438: -- update_row for:OKC_K_GRPINGS_V --
1439: -------------------------------------------
1440: PROCEDURE update_row(
1441: p_api_version IN NUMBER,
1442: p_init_msg_list IN VARCHAR2 ,
1529: END IF;
1530: RETURN(l_return_status);
1531: END populate_new_record;
1532: -----------------------------------------------
1533: -- Set_Attributes for:OKC_K_GRPINGS_V --
1534: -----------------------------------------------
1535: FUNCTION Set_Attributes (
1536: p_cgcv_rec IN cgcv_rec_type,
1537: x_cgcv_rec OUT NOCOPY cgcv_rec_type
1780: '_PVT'
1781: );
1782: END delete_row;
1783: -------------------------------------------
1784: -- delete_row for:OKC_K_GRPINGS_V --
1785: -------------------------------------------
1786: PROCEDURE delete_row(
1787: p_api_version IN NUMBER,
1788: p_init_msg_list IN VARCHAR2 ,