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.OKL_CGM_PVT dependencies on OKL_CNTX_GRP_PRMTRS_V

Line 84: -- FUNCTION get_rec for: OKL_CNTX_GRP_PRMTRS_V

80: BEGIN
81: RETURN(get_rec(p_cgm_rec, l_row_notfound));
82: END get_rec;
83: ---------------------------------------------------------------------------
84: -- FUNCTION get_rec for: OKL_CNTX_GRP_PRMTRS_V
85: ---------------------------------------------------------------------------
86: FUNCTION get_rec (
87: p_cgmv_rec IN cgmv_rec_type,
88: x_no_data_found OUT NOCOPY BOOLEAN

Line 101: FROM Okl_Cntx_Grp_Prmtrs_V

97: CREATION_DATE,
98: LAST_UPDATED_BY,
99: LAST_UPDATE_DATE,
100: LAST_UPDATE_LOGIN
101: FROM Okl_Cntx_Grp_Prmtrs_V
102: WHERE okl_cntx_grp_prmtrs_v.id = p_id;
103: l_okl_cgmv_pk okl_cgmv_pk_csr%ROWTYPE;
104: l_cgmv_rec cgmv_rec_type;
105: BEGIN

Line 102: WHERE okl_cntx_grp_prmtrs_v.id = p_id;

98: LAST_UPDATED_BY,
99: LAST_UPDATE_DATE,
100: LAST_UPDATE_LOGIN
101: FROM Okl_Cntx_Grp_Prmtrs_V
102: WHERE okl_cntx_grp_prmtrs_v.id = p_id;
103: l_okl_cgmv_pk okl_cgmv_pk_csr%ROWTYPE;
104: l_cgmv_rec cgmv_rec_type;
105: BEGIN
106: x_no_data_found := TRUE;

Line 133: -- FUNCTION null_out_defaults for: OKL_CNTX_GRP_PRMTRS_V --

129: RETURN(get_rec(p_cgmv_rec, l_row_notfound));
130: END get_rec;
131:
132: -----------------------------------------------------------
133: -- FUNCTION null_out_defaults for: OKL_CNTX_GRP_PRMTRS_V --
134: -----------------------------------------------------------
135: FUNCTION null_out_defaults (
136: p_cgmv_rec IN cgmv_rec_type
137: ) RETURN cgmv_rec_type IS

Line 173: -- Validate_Attributes for:OKL_CNTX_GRP_PRMTRS_V --

169: ---------------------------------------------------------------------------
170: -- PROCEDURE Validate_Attributes
171: ---------------------------------------------------------------------------
172: ---------------------------------------------------
173: -- Validate_Attributes for:OKL_CNTX_GRP_PRMTRS_V --
174: ---------------------------------------------------
175: FUNCTION Validate_Attributes (
176: p_cgmv_rec IN cgmv_rec_type
177: ) RETURN VARCHAR2 IS

Line 208: -- Validate_Record for:OKL_CNTX_GRP_PRMTRS_V --

204: ---------------------------------------------------------------------------
205: -- PROCEDURE Validate_Record
206: ---------------------------------------------------------------------------
207: -----------------------------------------------
208: -- Validate_Record for:OKL_CNTX_GRP_PRMTRS_V --
209: -----------------------------------------------
210: FUNCTION Validate_Record (
211: p_cgmv_rec IN cgmv_rec_type
212: ) RETURN VARCHAR2 IS

Line 297: CURSOR okl_pmrv_pk_csr (p_id IN OKL_CNTX_GRP_PRMTRS_V.pmr_id%TYPE) IS

293: l_dummy VARCHAR2(1) := '?';
294: l_row_not_found Boolean := False;
295:
296: -- Cursor For OKL_CGM_PMR_FK - Foreign Key Constraint
297: CURSOR okl_pmrv_pk_csr (p_id IN OKL_CNTX_GRP_PRMTRS_V.pmr_id%TYPE) IS
298: SELECT '1'
299: FROM OKL_PARAMETERS_V
300: WHERE OKL_PARAMETERS_V.id = p_id;
301:

Line 369: CURSOR okl_cgrv_pk_csr (p_id IN OKL_CNTX_GRP_PRMTRS_V.cgr_id%TYPE) IS

365: l_dummy VARCHAR2(1) := '?';
366: l_row_not_found Boolean := False;
367:
368: -- Cursor For OKL_CGM_CGR_FK - Foreign Key Constraint
369: CURSOR okl_cgrv_pk_csr (p_id IN OKL_CNTX_GRP_PRMTRS_V.cgr_id%TYPE) IS
370: SELECT '1'
371: FROM OKL_CONTEXT_GROUPS_V
372: WHERE OKL_CONTEXT_GROUPS_V.id = p_id;
373:

Line 555: CURSOR c1( p_cgr_id okl_cntx_grp_prmtrs_v.cgr_id%TYPE

551: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
552: l_unq_tbl OKC_UTIL.unq_tbl_type;
553: l_dummy VARCHAR2(1);
554: l_row_found Boolean := False;
555: CURSOR c1( p_cgr_id okl_cntx_grp_prmtrs_v.cgr_id%TYPE
556: , p_pmr_id okl_cntx_grp_prmtrs_v.pmr_id%TYPE
557: , p_id okl_cntx_grp_prmtrs_v.id%TYPE ) is
558: SELECT 1
559: FROM okl_cntx_grp_prmtrs_v

Line 556: , p_pmr_id okl_cntx_grp_prmtrs_v.pmr_id%TYPE

552: l_unq_tbl OKC_UTIL.unq_tbl_type;
553: l_dummy VARCHAR2(1);
554: l_row_found Boolean := False;
555: CURSOR c1( p_cgr_id okl_cntx_grp_prmtrs_v.cgr_id%TYPE
556: , p_pmr_id okl_cntx_grp_prmtrs_v.pmr_id%TYPE
557: , p_id okl_cntx_grp_prmtrs_v.id%TYPE ) is
558: SELECT 1
559: FROM okl_cntx_grp_prmtrs_v
560: WHERE p_cgr_id = cgr_id

Line 557: , p_id okl_cntx_grp_prmtrs_v.id%TYPE ) is

553: l_dummy VARCHAR2(1);
554: l_row_found Boolean := False;
555: CURSOR c1( p_cgr_id okl_cntx_grp_prmtrs_v.cgr_id%TYPE
556: , p_pmr_id okl_cntx_grp_prmtrs_v.pmr_id%TYPE
557: , p_id okl_cntx_grp_prmtrs_v.id%TYPE ) is
558: SELECT 1
559: FROM okl_cntx_grp_prmtrs_v
560: WHERE p_cgr_id = cgr_id
561: and p_pmr_id = pmr_id

Line 559: FROM okl_cntx_grp_prmtrs_v

555: CURSOR c1( p_cgr_id okl_cntx_grp_prmtrs_v.cgr_id%TYPE
556: , p_pmr_id okl_cntx_grp_prmtrs_v.pmr_id%TYPE
557: , p_id okl_cntx_grp_prmtrs_v.id%TYPE ) is
558: SELECT 1
559: FROM okl_cntx_grp_prmtrs_v
560: WHERE p_cgr_id = cgr_id
561: and p_pmr_id = pmr_id
562: and id <> nvl( p_cgmv_rec.id, -9999 );
563:

Line 574: OKC_API.set_message( G_APP_NAME, G_UNQS, G_TABLE_TOKEN, 'Okl_Cntx_Grp_Prmtrs_V' );

570: FETCH c1 into l_dummy;
571: l_row_found := c1%FOUND;
572: CLOSE c1;
573: IF l_row_found then
574: OKC_API.set_message( G_APP_NAME, G_UNQS, G_TABLE_TOKEN, 'Okl_Cntx_Grp_Prmtrs_V' );
575: x_return_status := OKC_API.G_RET_STS_ERROR;
576: END IF;
577:
578: EXCEPTION

Line 696: -- validate_row for:OKL_CNTX_GRP_PRMTRS_V --

692: ---------------------------------------------------------------------------
693: -- PROCEDURE validate_row
694: ---------------------------------------------------------------------------
695: --------------------------------------------
696: -- validate_row for:OKL_CNTX_GRP_PRMTRS_V --
697: --------------------------------------------
698: PROCEDURE validate_row(
699: p_api_version IN NUMBER,
700: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 954: -- insert_row for:OKL_CNTX_GRP_PRMTRS_V --

950: '_PVT'
951: );
952: END insert_row;
953: ------------------------------------------
954: -- insert_row for:OKL_CNTX_GRP_PRMTRS_V --
955: ------------------------------------------
956: PROCEDURE insert_row(
957: p_api_version IN NUMBER,
958: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 988: -- Set_Attributes for:OKL_CNTX_GRP_PRMTRS_V --

984: l_cgmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
985: RETURN(l_cgmv_rec);
986: END fill_who_columns;
987: ----------------------------------------------
988: -- Set_Attributes for:OKL_CNTX_GRP_PRMTRS_V --
989: ----------------------------------------------
990: FUNCTION Set_Attributes (
991: p_cgmv_rec IN cgmv_rec_type,
992: x_cgmv_rec OUT NOCOPY cgmv_rec_type

Line 1285: -- lock_row for:OKL_CNTX_GRP_PRMTRS_V --

1281: '_PVT'
1282: );
1283: END lock_row;
1284: ----------------------------------------
1285: -- lock_row for:OKL_CNTX_GRP_PRMTRS_V --
1286: ----------------------------------------
1287: PROCEDURE lock_row(
1288: p_api_version IN NUMBER,
1289: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1599: -- update_row for:OKL_CNTX_GRP_PRMTRS_V --

1595: '_PVT'
1596: );
1597: END update_row;
1598: ------------------------------------------
1599: -- update_row for:OKL_CNTX_GRP_PRMTRS_V --
1600: ------------------------------------------
1601: PROCEDURE update_row(
1602: p_api_version IN NUMBER,
1603: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1686: -- Set_Attributes for:OKL_CNTX_GRP_PRMTRS_V --

1682: END IF;
1683: RETURN(l_return_status);
1684: END populate_new_record;
1685: ----------------------------------------------
1686: -- Set_Attributes for:OKL_CNTX_GRP_PRMTRS_V --
1687: ----------------------------------------------
1688: FUNCTION Set_Attributes (
1689: p_cgmv_rec IN cgmv_rec_type,
1690: x_cgmv_rec OUT NOCOPY cgmv_rec_type

Line 1941: -- delete_row for:OKL_CNTX_GRP_PRMTRS_V --

1937: '_PVT'
1938: );
1939: END delete_row;
1940: ------------------------------------------
1941: -- delete_row for:OKL_CNTX_GRP_PRMTRS_V --
1942: ------------------------------------------
1943: PROCEDURE delete_row(
1944: p_api_version IN NUMBER,
1945: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,