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_CGP_PVT dependencies on OKC_K_GROUPS_V

Line 21: OKC_K_GROUPS_V

17: cursor seed_c is
18: select
19: nvl(max(id), 11000) + 1
20: from
21: OKC_K_GROUPS_V
22: where
23: id >= 11000 AND id < 50000;
24: BEGIN
25: if fnd_global.user_id = 1 then

Line 272: -- FUNCTION get_rec for: OKC_K_GROUPS_V

268: BEGIN
269: RETURN(get_rec(p_okc_K_groups_tl_rec, l_row_notfound));
270: END get_rec;
271: ---------------------------------------------------------------------------
272: -- FUNCTION get_rec for: OKC_K_GROUPS_V
273: ---------------------------------------------------------------------------
274: FUNCTION get_rec (
275: p_cgpv_rec IN cgpv_rec_type,
276: x_no_data_found OUT NOCOPY BOOLEAN

Line 308: FROM Okc_K_Groups_V

304: LAST_UPDATED_BY,
305: LAST_UPDATE_DATE,
306: USER_ID,
307: LAST_UPDATE_LOGIN
308: FROM Okc_K_Groups_V
309: WHERE okc_K_groups_v.id = p_id;
310: l_okc_cgpv_pk okc_cgpv_pk_csr%ROWTYPE;
311: l_cgpv_rec cgpv_rec_type;
312: BEGIN

Line 309: WHERE okc_K_groups_v.id = p_id;

305: LAST_UPDATE_DATE,
306: USER_ID,
307: LAST_UPDATE_LOGIN
308: FROM Okc_K_Groups_V
309: WHERE okc_K_groups_v.id = p_id;
310: l_okc_cgpv_pk okc_cgpv_pk_csr%ROWTYPE;
311: l_cgpv_rec cgpv_rec_type;
312: BEGIN
313: x_no_data_found := TRUE;

Line 359: -- FUNCTION null_out_defaults for: OKC_K_GROUPS_V --

355: RETURN(get_rec(p_cgpv_rec, l_row_notfound));
356: END get_rec;
357:
358: -----------------------------------------------------------
359: -- FUNCTION null_out_defaults for: OKC_K_GROUPS_V --
360: -----------------------------------------------------------
361: FUNCTION null_out_defaults (
362: p_cgpv_rec IN cgpv_rec_type
363: ) RETURN cgpv_rec_type IS

Line 623: from okc_k_groups_v a,

619: l_dummy VARCHAR2(1);
620: l_row_found BOOLEAN;
621: cursor c1 (p_cgp_parent_id okc_k_grpings_v.cgp_parent_id%TYPE) is
622: select 'x'
623: from okc_k_groups_v a,
624: okc_k_grpings_v b
625: where a.public_yn = 'N'
626: and a.id = b.included_cgp_id
627: and b.cgp_parent_id = p_cgp_parent_id;

Line 630: from okc_k_groups_v a,

626: and a.id = b.included_cgp_id
627: and b.cgp_parent_id = p_cgp_parent_id;
628: cursor c2 (p_included_cgp_id okc_k_grpings_v.included_cgp_id%TYPE) is
629: select 'x'
630: from okc_k_groups_v a,
631: okc_k_grpings_v b
632: where a.public_yn = 'Y'
633: and a.id = b.cgp_parent_id
634: and b.included_cgp_id = p_included_cgp_id;

Line 726: -- Validate_Attributes for:OKC_K_GROUPS_V --

722: ---------------------------------------------------------------------------
723: -- PROCEDURE Validate_Attributes
724: ---------------------------------------------------------------------------
725: ---------------------------------------------------
726: -- Validate_Attributes for:OKC_K_GROUPS_V --
727: ---------------------------------------------------
728: FUNCTION Validate_Attributes (
729: p_cgpv_rec IN cgpv_rec_type
730: ) RETURN VARCHAR2 IS

Line 806: -- Validate_Record for:OKC_K_GROUPS_V --

802: ---------------------------------------------------------------------------
803: -- PROCEDURE Validate_Record
804: ---------------------------------------------------------------------------
805: -----------------------------------------------
806: -- Validate_Record for:OKC_K_GROUPS_V --
807: -----------------------------------------------
808: FUNCTION Validate_Record (
809: p_cgpv_rec IN cgpv_rec_type
810: ) RETURN VARCHAR2 IS

Line 861: CURSOR c1 (p_id IN okc_k_groups_v.id%TYPE,

857: FUNCTION validate_unique_keys (
858: p_cgpv_rec IN cgpv_rec_type
859: ) RETURN VARCHAR2 IS
860: unique_key_error EXCEPTION;
861: CURSOR c1 (p_id IN okc_k_groups_v.id%TYPE,
862: p_name IN okc_k_groups_v.name%TYPE,
863: p_user_id IN okc_k_groups_v.user_id%TYPE,
864: p_public_yn IN okc_k_groups_v.public_yn%TYPE) IS
865: SELECT 'x'

Line 862: p_name IN okc_k_groups_v.name%TYPE,

858: p_cgpv_rec IN cgpv_rec_type
859: ) RETURN VARCHAR2 IS
860: unique_key_error EXCEPTION;
861: CURSOR c1 (p_id IN okc_k_groups_v.id%TYPE,
862: p_name IN okc_k_groups_v.name%TYPE,
863: p_user_id IN okc_k_groups_v.user_id%TYPE,
864: p_public_yn IN okc_k_groups_v.public_yn%TYPE) IS
865: SELECT 'x'
866: FROM Okc_K_Groups_V

Line 863: p_user_id IN okc_k_groups_v.user_id%TYPE,

859: ) RETURN VARCHAR2 IS
860: unique_key_error EXCEPTION;
861: CURSOR c1 (p_id IN okc_k_groups_v.id%TYPE,
862: p_name IN okc_k_groups_v.name%TYPE,
863: p_user_id IN okc_k_groups_v.user_id%TYPE,
864: p_public_yn IN okc_k_groups_v.public_yn%TYPE) IS
865: SELECT 'x'
866: FROM Okc_K_Groups_V
867: WHERE ((p_id IS NULL)

Line 864: p_public_yn IN okc_k_groups_v.public_yn%TYPE) IS

860: unique_key_error EXCEPTION;
861: CURSOR c1 (p_id IN okc_k_groups_v.id%TYPE,
862: p_name IN okc_k_groups_v.name%TYPE,
863: p_user_id IN okc_k_groups_v.user_id%TYPE,
864: p_public_yn IN okc_k_groups_v.public_yn%TYPE) IS
865: SELECT 'x'
866: FROM Okc_K_Groups_V
867: WHERE ((p_id IS NULL)
868: OR (p_id IS NOT NULL

Line 866: FROM Okc_K_Groups_V

862: p_name IN okc_k_groups_v.name%TYPE,
863: p_user_id IN okc_k_groups_v.user_id%TYPE,
864: p_public_yn IN okc_k_groups_v.public_yn%TYPE) IS
865: SELECT 'x'
866: FROM Okc_K_Groups_V
867: WHERE ((p_id IS NULL)
868: OR (p_id IS NOT NULL
869: AND Okc_K_Groups_V.id <> p_id))
870: AND Okc_K_Groups_V.name = p_name

Line 869: AND Okc_K_Groups_V.id <> p_id))

865: SELECT 'x'
866: FROM Okc_K_Groups_V
867: WHERE ((p_id IS NULL)
868: OR (p_id IS NOT NULL
869: AND Okc_K_Groups_V.id <> p_id))
870: AND Okc_K_Groups_V.name = p_name
871: AND Okc_K_Groups_V.public_yn = p_public_yn
872: AND ((p_user_id IS NULL)
873: OR (p_user_id IS NOT NULL

Line 870: AND Okc_K_Groups_V.name = p_name

866: FROM Okc_K_Groups_V
867: WHERE ((p_id IS NULL)
868: OR (p_id IS NOT NULL
869: AND Okc_K_Groups_V.id <> p_id))
870: AND Okc_K_Groups_V.name = p_name
871: AND Okc_K_Groups_V.public_yn = p_public_yn
872: AND ((p_user_id IS NULL)
873: OR (p_user_id IS NOT NULL
874: AND Okc_K_Groups_V.user_id = p_user_id));

Line 871: AND Okc_K_Groups_V.public_yn = p_public_yn

867: WHERE ((p_id IS NULL)
868: OR (p_id IS NOT NULL
869: AND Okc_K_Groups_V.id <> p_id))
870: AND Okc_K_Groups_V.name = p_name
871: AND Okc_K_Groups_V.public_yn = p_public_yn
872: AND ((p_user_id IS NULL)
873: OR (p_user_id IS NOT NULL
874: AND Okc_K_Groups_V.user_id = p_user_id));
875: l_dummy VARCHAR2(1);

Line 874: AND Okc_K_Groups_V.user_id = p_user_id));

870: AND Okc_K_Groups_V.name = p_name
871: AND Okc_K_Groups_V.public_yn = p_public_yn
872: AND ((p_user_id IS NULL)
873: OR (p_user_id IS NOT NULL
874: AND Okc_K_Groups_V.user_id = p_user_id));
875: l_dummy VARCHAR2(1);
876: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
877: l_row_found BOOLEAN := FALSE;
878: BEGIN

Line 1026: -- validate_row for:OKC_K_GROUPS_V --

1022: ---------------------------------------------------------------------------
1023: -- PROCEDURE validate_row
1024: ---------------------------------------------------------------------------
1025: --------------------------------------------
1026: -- validate_row for:OKC_K_GROUPS_V --
1027: --------------------------------------------
1028: PROCEDURE validate_row(
1029: p_api_version IN NUMBER,
1030: p_init_msg_list IN VARCHAR2 ,

Line 1421: -- insert_row for:OKC_K_GROUPS_V --

1417: '_PVT'
1418: );
1419: END insert_row;
1420: ------------------------------------------
1421: -- insert_row for:OKC_K_GROUPS_V --
1422: ------------------------------------------
1423: PROCEDURE insert_row(
1424: p_api_version IN NUMBER,
1425: p_init_msg_list IN VARCHAR2 ,

Line 1457: -- Set_Attributes for:OKC_K_GROUPS_V --

1453: l_cgpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1454: RETURN(l_cgpv_rec);
1455: END fill_who_columns;
1456: ----------------------------------------------
1457: -- Set_Attributes for:OKC_K_GROUPS_V --
1458: ----------------------------------------------
1459: FUNCTION Set_Attributes (
1460: p_cgpv_rec IN cgpv_rec_type,
1461: x_cgpv_rec OUT NOCOPY cgpv_rec_type

Line 1850: -- lock_row for:OKC_K_GROUPS_V --

1846: '_PVT'
1847: );
1848: END lock_row;
1849: ----------------------------------------
1850: -- lock_row for:OKC_K_GROUPS_V --
1851: ----------------------------------------
1852: PROCEDURE lock_row(
1853: p_api_version IN NUMBER,
1854: p_init_msg_list IN VARCHAR2 ,

Line 2416: -- update_row for:OKC_K_GROUPS_V --

2412: '_PVT'
2413: );
2414: END update_row;
2415: ------------------------------------------
2416: -- update_row for:OKC_K_GROUPS_V --
2417: ------------------------------------------
2418: PROCEDURE update_row(
2419: p_api_version IN NUMBER,
2420: p_init_msg_list IN VARCHAR2 ,

Line 2581: -- Set_Attributes for:OKC_K_GROUPS_V --

2577: END IF;
2578: RETURN(l_return_status);
2579: END populate_new_record;
2580: ----------------------------------------------
2581: -- Set_Attributes for:OKC_K_GROUPS_V --
2582: ----------------------------------------------
2583: FUNCTION Set_Attributes (
2584: p_cgpv_rec IN cgpv_rec_type,
2585: x_cgpv_rec OUT NOCOPY cgpv_rec_type

Line 2937: -- delete_row for:OKC_K_GROUPS_V --

2933: '_PVT'
2934: );
2935: END delete_row;
2936: ------------------------------------------
2937: -- delete_row for:OKC_K_GROUPS_V --
2938: ------------------------------------------
2939: PROCEDURE delete_row(
2940: p_api_version IN NUMBER,
2941: p_init_msg_list IN VARCHAR2 ,

Line 3116: FROM OKC_K_GROUPS_V

3112: x_return_status OUT NOCOPY Varchar2) IS
3113: l_user_id Number := TO_NUMBER(fnd_profile.value('USER_ID'));
3114: CURSOR c1 IS
3115: SELECT id, public_yn, name
3116: FROM OKC_K_GROUPS_V
3117: WHERE ((public_yn = 'Y')
3118: OR (public_yn = 'N'
3119: AND user_id = l_user_id))
3120: ORDER BY public_yn, name;