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_CGC_PVT dependencies on OKC_K_GRPINGS_V

Line 93: -- FUNCTION get_rec for: OKC_K_GRPINGS_V

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

Line 112: FROM Okc_K_Grpings_V

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

Line 113: WHERE okc_K_grpings_v.id = p_id;

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;

Line 146: -- FUNCTION null_out_defaults for: OKC_K_GRPINGS_V --

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

Line 264: -- Validate_Attributes for:OKC_K_GRPINGS_V --

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

Line 309: -- Validate_Record for:OKC_K_GRPINGS_V --

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

Line 381: CURSOR okc_chr_csr (p_id IN okc_k_grpings_v.id%TYPE,

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

Line 382: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,

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

Line 383: p_included_chr_id IN okc_k_grpings_v.included_chr_id%TYPE) IS

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

Line 385: FROM Okc_K_Grpings_V

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

Line 386: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id

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));

Line 387: AND okc_K_grpings_v.included_chr_id = p_included_chr_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,

Line 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

Line 392: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,

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

Line 393: p_included_cgp_id IN okc_k_grpings_v.included_cgp_id%TYPE) IS

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

Line 395: FROM Okc_K_Grpings_V

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

Line 396: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id

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));

Line 397: AND okc_K_grpings_v.included_cgp_id = p_included_cgp_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);

Line 547: -- validate_row for:OKC_K_GRPINGS_V --

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 ,

Line 798: -- insert_row for:OKC_K_GRPINGS_V --

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 ,

Line 832: -- Set_Attributes for:OKC_K_GRPINGS_V --

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

Line 1125: -- lock_row for:OKC_K_GRPINGS_V --

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 ,

Line 1438: -- update_row for:OKC_K_GRPINGS_V --

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 ,

Line 1533: -- Set_Attributes for:OKC_K_GRPINGS_V --

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

Line 1784: -- delete_row for:OKC_K_GRPINGS_V --

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 ,