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_FEP_PVT dependencies on OKC_FUNCTION_EXPR_PARAMS_V

Line 96: -- FUNCTION get_rec for: OKC_FUNCTION_EXPR_PARAMS_V

92: BEGIN
93: RETURN(get_rec(p_fep_rec, l_row_notfound));
94: END get_rec;
95: ---------------------------------------------------------------------------
96: -- FUNCTION get_rec for: OKC_FUNCTION_EXPR_PARAMS_V
97: ---------------------------------------------------------------------------
98: FUNCTION get_rec (
99: p_fepv_rec IN fepv_rec_type,
100: x_no_data_found OUT NOCOPY BOOLEAN

Line 118: FROM Okc_Function_Expr_Params_V

114: CREATION_DATE,
115: LAST_UPDATED_BY,
116: LAST_UPDATE_DATE,
117: LAST_UPDATE_LOGIN
118: FROM Okc_Function_Expr_Params_V
119: WHERE okc_function_expr_params_v.id = p_id;
120: l_okc_fepv_pk okc_fepv_pk_csr%ROWTYPE;
121: l_fepv_rec fepv_rec_type;
122: BEGIN

Line 119: WHERE okc_function_expr_params_v.id = p_id;

115: LAST_UPDATED_BY,
116: LAST_UPDATE_DATE,
117: LAST_UPDATE_LOGIN
118: FROM Okc_Function_Expr_Params_V
119: WHERE okc_function_expr_params_v.id = p_id;
120: l_okc_fepv_pk okc_fepv_pk_csr%ROWTYPE;
121: l_fepv_rec fepv_rec_type;
122: BEGIN
123: x_no_data_found := TRUE;

Line 155: -- FUNCTION null_out_defaults for: OKC_FUNCTION_EXPR_PARAMS_V --

151: RETURN(get_rec(p_fepv_rec, l_row_notfound));
152: END get_rec;
153:
154: ----------------------------------------------------------------
155: -- FUNCTION null_out_defaults for: OKC_FUNCTION_EXPR_PARAMS_V --
156: ----------------------------------------------------------------
157: FUNCTION null_out_defaults (
158: p_fepv_rec IN fepv_rec_type
159: ) RETURN fepv_rec_type IS

Line 209: -- Validate_Attributes for:OKC_FUNCTION_EXPR_PARAMS_V --

205: ---------------------------------------------------------------------------
206: -- PROCEDURE Validate_Attributes
207: ---------------------------------------------------------------------------
208: --------------------------------------------------------
209: -- Validate_Attributes for:OKC_FUNCTION_EXPR_PARAMS_V --
210: --------------------------------------------------------
211: FUNCTION Validate_Attributes (
212: p_fepv_rec IN fepv_rec_type
213: ) RETURN VARCHAR2 IS

Line 244: -- Validate_Record for:OKC_FUNCTION_EXPR_PARAMS_V --

240: ---------------------------------------------------------------------------
241: -- PROCEDURE Validate_Record
242: ---------------------------------------------------------------------------
243: ----------------------------------------------------
244: -- Validate_Record for:OKC_FUNCTION_EXPR_PARAMS_V --
245: ----------------------------------------------------
246: FUNCTION Validate_Record (
247: p_fepv_rec IN fepv_rec_type
248: ) RETURN VARCHAR2 IS

Line 957: CURSOR c1(p_cnl_id okc_function_expr_params_v.cnl_id%TYPE,

953: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
954: --l_unq_tbl OKC_UTIL.unq_tbl_type;
955: l_dummy VARCHAR2(1);
956: l_row_found Boolean := False;
957: CURSOR c1(p_cnl_id okc_function_expr_params_v.cnl_id%TYPE,
958: p_pdp_id okc_function_expr_params_v.pdp_id%TYPE) is
959: SELECT 1
960: FROM okc_function_expr_params
961: WHERE cnl_id = p_cnl_id

Line 958: p_pdp_id okc_function_expr_params_v.pdp_id%TYPE) is

954: --l_unq_tbl OKC_UTIL.unq_tbl_type;
955: l_dummy VARCHAR2(1);
956: l_row_found Boolean := False;
957: CURSOR c1(p_cnl_id okc_function_expr_params_v.cnl_id%TYPE,
958: p_pdp_id okc_function_expr_params_v.pdp_id%TYPE) is
959: SELECT 1
960: FROM okc_function_expr_params
961: WHERE cnl_id = p_cnl_id
962: AND pdp_id = p_pdp_id

Line 985: OKC_UTIL.CHECK_COMP_UNIQUE(p_view_name => 'OKC_FUNCTION_EXPR_PARAMS_V'

981: -- initialize return status
982: x_return_status := OKC_API.G_RET_STS_SUCCESS;
983:
984: -- call check_comp_unique utility
985: OKC_UTIL.CHECK_COMP_UNIQUE(p_view_name => 'OKC_FUNCTION_EXPR_PARAMS_V'
986: ,p_col_tbl => l_unq_tbl
987: ,p_id => p_fepv_rec.id
988: ,x_return_status => l_return_status);
989:

Line 1315: -- validate_row for:OKC_FUNCTION_EXPR_PARAMS_V --

1311: ---------------------------------------------------------------------------
1312: -- PROCEDURE validate_row
1313: ---------------------------------------------------------------------------
1314: -------------------------------------------------
1315: -- validate_row for:OKC_FUNCTION_EXPR_PARAMS_V --
1316: -------------------------------------------------
1317: PROCEDURE validate_row(
1318: p_api_version IN NUMBER,
1319: p_init_msg_list IN VARCHAR2 ,

Line 1572: -- insert_row for:OKC_FUNCTION_EXPR_PARAMS_V --

1568: '_PVT'
1569: );
1570: END insert_row;
1571: -----------------------------------------------
1572: -- insert_row for:OKC_FUNCTION_EXPR_PARAMS_V --
1573: -----------------------------------------------
1574: PROCEDURE insert_row(
1575: p_api_version IN NUMBER,
1576: p_init_msg_list IN VARCHAR2 ,

Line 1607: -- Set_Attributes for:OKC_FUNCTION_EXPR_PARAMS_V --

1603: l_fepv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1604: RETURN(l_fepv_rec);
1605: END fill_who_columns;
1606: ---------------------------------------------------
1607: -- Set_Attributes for:OKC_FUNCTION_EXPR_PARAMS_V --
1608: ---------------------------------------------------
1609: FUNCTION Set_Attributes (
1610: p_fepv_rec IN fepv_rec_type,
1611: x_fepv_rec OUT NOCOPY fepv_rec_type

Line 1919: -- lock_row for:OKC_FUNCTION_EXPR_PARAMS_V --

1915: '_PVT'
1916: );
1917: END lock_row;
1918: ---------------------------------------------
1919: -- lock_row for:OKC_FUNCTION_EXPR_PARAMS_V --
1920: ---------------------------------------------
1921: PROCEDURE lock_row(
1922: p_api_version IN NUMBER,
1923: p_init_msg_list IN VARCHAR2 ,

Line 2247: -- update_row for:OKC_FUNCTION_EXPR_PARAMS_V --

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

Line 2354: -- Set_Attributes for:OKC_FUNCTION_EXPR_PARAMS_V --

2350: END IF;
2351: RETURN(l_return_status);
2352: END populate_new_record;
2353: ---------------------------------------------------
2354: -- Set_Attributes for:OKC_FUNCTION_EXPR_PARAMS_V --
2355: ---------------------------------------------------
2356: FUNCTION Set_Attributes (
2357: p_fepv_rec IN fepv_rec_type,
2358: x_fepv_rec OUT NOCOPY fepv_rec_type

Line 2606: -- delete_row for:OKC_FUNCTION_EXPR_PARAMS_V --

2602: '_PVT'
2603: );
2604: END delete_row;
2605: -----------------------------------------------
2606: -- delete_row for:OKC_FUNCTION_EXPR_PARAMS_V --
2607: -----------------------------------------------
2608: PROCEDURE delete_row(
2609: p_api_version IN NUMBER,
2610: p_init_msg_list IN VARCHAR2 ,