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_RRD_PVT dependencies on OKC_RG_ROLE_DEFS_V

Line 21: OKC_RG_ROLE_DEFS_V

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

Line 154: -- FUNCTION get_rec for: OKC_RG_ROLE_DEFS_V

150: BEGIN
151: RETURN(get_rec(p_rrd_rec, l_row_notfound));
152: END get_rec;
153: ---------------------------------------------------------------------------
154: -- FUNCTION get_rec for: OKC_RG_ROLE_DEFS_V
155: ---------------------------------------------------------------------------
156: FUNCTION get_rec (
157: p_rrdv_rec IN rrdv_rec_type,
158: x_no_data_found OUT NOCOPY BOOLEAN

Line 190: FROM Okc_Rg_Role_Defs_V

186: LAST_UPDATED_BY,
187: LAST_UPDATE_DATE,
188: LAST_UPDATE_LOGIN,
189: ACCESS_LEVEL
190: FROM Okc_Rg_Role_Defs_V
191: WHERE okc_rg_role_defs_v.id = p_id;
192: l_okc_rrdv_pk okc_rrdv_pk_csr%ROWTYPE;
193: l_rrdv_rec rrdv_rec_type;
194: BEGIN

Line 191: WHERE okc_rg_role_defs_v.id = p_id;

187: LAST_UPDATE_DATE,
188: LAST_UPDATE_LOGIN,
189: ACCESS_LEVEL
190: FROM Okc_Rg_Role_Defs_V
191: WHERE okc_rg_role_defs_v.id = p_id;
192: l_okc_rrdv_pk okc_rrdv_pk_csr%ROWTYPE;
193: l_rrdv_rec rrdv_rec_type;
194: BEGIN
195: x_no_data_found := TRUE;

Line 241: -- FUNCTION null_out_defaults for: OKC_RG_ROLE_DEFS_V --

237: RETURN(get_rec(p_rrdv_rec, l_row_notfound));
238: END get_rec;
239:
240: --------------------------------------------------------
241: -- FUNCTION null_out_defaults for: OKC_RG_ROLE_DEFS_V --
242: --------------------------------------------------------
243: FUNCTION null_out_defaults (
244: p_rrdv_rec IN rrdv_rec_type
245: ) RETURN rrdv_rec_type IS

Line 552: -- Validate_Attributes for:OKC_RG_ROLE_DEFS_V --

548: ---------------------------------------------------------------------------
549: -- PROCEDURE Validate_Attributes
550: ---------------------------------------------------------------------------
551: ------------------------------------------------
552: -- Validate_Attributes for:OKC_RG_ROLE_DEFS_V --
553: ------------------------------------------------
554: FUNCTION Validate_Attributes (
555: p_rrdv_rec IN rrdv_rec_type
556: ) RETURN VARCHAR2 IS

Line 645: -- Validate_Record for:OKC_RG_ROLE_DEFS_V --

641: ---------------------------------------------------------------------------
642: -- PROCEDURE Validate_Record
643: ---------------------------------------------------------------------------
644: --------------------------------------------
645: -- Validate_Record for:OKC_RG_ROLE_DEFS_V --
646: --------------------------------------------
647: FUNCTION Validate_Record (
648: p_rrdv_rec IN rrdv_rec_type
649: ) RETURN VARCHAR2 IS

Line 703: CURSOR c1 (p_id IN okc_rg_role_defs_v.id%TYPE,

699: FUNCTION validate_unique_keys (
700: p_rrdv_rec IN rrdv_rec_type
701: ) RETURN VARCHAR2 IS
702: unique_key_error EXCEPTION;
703: CURSOR c1 (p_id IN okc_rg_role_defs_v.id%TYPE,
704: p_srd_id IN okc_rg_role_defs_v.srd_id%TYPE,
705: p_sre_id IN okc_rg_role_defs_v.sre_id%TYPE) IS
706: SELECT 'x'
707: FROM Okc_Rg_Role_Defs_V

Line 704: p_srd_id IN okc_rg_role_defs_v.srd_id%TYPE,

700: p_rrdv_rec IN rrdv_rec_type
701: ) RETURN VARCHAR2 IS
702: unique_key_error EXCEPTION;
703: CURSOR c1 (p_id IN okc_rg_role_defs_v.id%TYPE,
704: p_srd_id IN okc_rg_role_defs_v.srd_id%TYPE,
705: p_sre_id IN okc_rg_role_defs_v.sre_id%TYPE) IS
706: SELECT 'x'
707: FROM Okc_Rg_Role_Defs_V
708: WHERE srd_id = p_srd_id

Line 705: p_sre_id IN okc_rg_role_defs_v.sre_id%TYPE) IS

701: ) RETURN VARCHAR2 IS
702: unique_key_error EXCEPTION;
703: CURSOR c1 (p_id IN okc_rg_role_defs_v.id%TYPE,
704: p_srd_id IN okc_rg_role_defs_v.srd_id%TYPE,
705: p_sre_id IN okc_rg_role_defs_v.sre_id%TYPE) IS
706: SELECT 'x'
707: FROM Okc_Rg_Role_Defs_V
708: WHERE srd_id = p_srd_id
709: AND sre_id = p_sre_id

Line 707: FROM Okc_Rg_Role_Defs_V

703: CURSOR c1 (p_id IN okc_rg_role_defs_v.id%TYPE,
704: p_srd_id IN okc_rg_role_defs_v.srd_id%TYPE,
705: p_sre_id IN okc_rg_role_defs_v.sre_id%TYPE) IS
706: SELECT 'x'
707: FROM Okc_Rg_Role_Defs_V
708: WHERE srd_id = p_srd_id
709: AND sre_id = p_sre_id
710: AND ((p_id IS NULL)
711: OR (p_id IS NOT NULL

Line 837: -- validate_row for:OKC_RG_ROLE_DEFS_V --

833: ---------------------------------------------------------------------------
834: -- PROCEDURE validate_row
835: ---------------------------------------------------------------------------
836: -----------------------------------------
837: -- validate_row for:OKC_RG_ROLE_DEFS_V --
838: -----------------------------------------
839: PROCEDURE validate_row(
840: p_api_version IN NUMBER,
841: p_init_msg_list IN VARCHAR2,

Line 1122: -- insert_row for:OKC_RG_ROLE_DEFS_V --

1118: '_PVT'
1119: );
1120: END insert_row;
1121: ---------------------------------------
1122: -- insert_row for:OKC_RG_ROLE_DEFS_V --
1123: ---------------------------------------
1124: PROCEDURE insert_row(
1125: p_api_version IN NUMBER,
1126: p_init_msg_list IN VARCHAR2,

Line 1156: -- Set_Attributes for:OKC_RG_ROLE_DEFS_V --

1152: l_rrdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1153: RETURN(l_rrdv_rec);
1154: END fill_who_columns;
1155: -------------------------------------------
1156: -- Set_Attributes for:OKC_RG_ROLE_DEFS_V --
1157: -------------------------------------------
1158: FUNCTION Set_Attributes (
1159: p_rrdv_rec IN rrdv_rec_type,
1160: x_rrdv_rec OUT NOCOPY rrdv_rec_type

Line 1442: -- lock_row for:OKC_RG_ROLE_DEFS_V --

1438: '_PVT'
1439: );
1440: END lock_row;
1441: -------------------------------------
1442: -- lock_row for:OKC_RG_ROLE_DEFS_V --
1443: -------------------------------------
1444: PROCEDURE lock_row(
1445: p_api_version IN NUMBER,
1446: p_init_msg_list IN VARCHAR2,

Line 1840: -- update_row for:OKC_RG_ROLE_DEFS_V --

1836: '_PVT'
1837: );
1838: END update_row;
1839: ---------------------------------------
1840: -- update_row for:OKC_RG_ROLE_DEFS_V --
1841: ---------------------------------------
1842: PROCEDURE update_row(
1843: p_api_version IN NUMBER,
1844: p_init_msg_list IN VARCHAR2,

Line 2003: -- Set_Attributes for:OKC_RG_ROLE_DEFS_V --

1999: END IF;
2000: RETURN(l_return_status);
2001: END populate_new_record;
2002: -------------------------------------------
2003: -- Set_Attributes for:OKC_RG_ROLE_DEFS_V --
2004: -------------------------------------------
2005: FUNCTION Set_Attributes (
2006: p_rrdv_rec IN rrdv_rec_type,
2007: x_rrdv_rec OUT NOCOPY rrdv_rec_type

Line 2247: -- delete_row for:OKC_RG_ROLE_DEFS_V --

2243: '_PVT'
2244: );
2245: END delete_row;
2246: ---------------------------------------
2247: -- delete_row for:OKC_RG_ROLE_DEFS_V --
2248: ---------------------------------------
2249: PROCEDURE delete_row(
2250: p_api_version IN NUMBER,
2251: p_init_msg_list IN VARCHAR2,