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_FPR_PVT dependencies on OKL_FNCTN_PRMTRS_V

Line 220: -- FUNCTION get_rec for: OKL_FNCTN_PRMTRS_V

216: BEGIN
217: RETURN(get_rec(p_okl_fnctn_prmtrs_tl_rec, l_row_notfound));
218: END get_rec;
219: ---------------------------------------------------------------------------
220: -- FUNCTION get_rec for: OKL_FNCTN_PRMTRS_V
221: ---------------------------------------------------------------------------
222: FUNCTION get_rec (
223: p_fprv_rec IN fprv_rec_type,
224: x_no_data_found OUT NOCOPY BOOLEAN

Line 242: FROM Okl_Fnctn_Prmtrs_V

238: CREATION_DATE,
239: LAST_UPDATED_BY,
240: LAST_UPDATE_DATE,
241: LAST_UPDATE_LOGIN
242: FROM Okl_Fnctn_Prmtrs_V
243: WHERE okl_fnctn_prmtrs_v.id = p_id;
244: l_okl_fprv_pk okl_fprv_pk_csr%ROWTYPE;
245: l_fprv_rec fprv_rec_type;
246: BEGIN

Line 243: WHERE okl_fnctn_prmtrs_v.id = p_id;

239: LAST_UPDATED_BY,
240: LAST_UPDATE_DATE,
241: LAST_UPDATE_LOGIN
242: FROM Okl_Fnctn_Prmtrs_V
243: WHERE okl_fnctn_prmtrs_v.id = p_id;
244: l_okl_fprv_pk okl_fprv_pk_csr%ROWTYPE;
245: l_fprv_rec fprv_rec_type;
246: BEGIN
247: x_no_data_found := TRUE;

Line 279: -- FUNCTION null_out_defaults for: OKL_FNCTN_PRMTRS_V --

275: RETURN(get_rec(p_fprv_rec, l_row_notfound));
276: END get_rec;
277:
278: --------------------------------------------------------
279: -- FUNCTION null_out_defaults for: OKL_FNCTN_PRMTRS_V --
280: --------------------------------------------------------
281: FUNCTION null_out_defaults (
282: p_fprv_rec IN fprv_rec_type
283: ) RETURN fprv_rec_type IS

Line 335: -- Validate_Attributes for:OKL_FNCTN_PRMTRS_V --

331: ---------------------------------------------------------------------------
332: -- PROCEDURE Validate_Attributes
333: ---------------------------------------------------------------------------
334: ------------------------------------------------
335: -- Validate_Attributes for:OKL_FNCTN_PRMTRS_V --
336: ------------------------------------------------
337: FUNCTION Validate_Attributes (
338: p_fprv_rec IN fprv_rec_type
339: ) RETURN VARCHAR2 IS

Line 375: -- Validate_Record for:OKL_FNCTN_PRMTRS_V --

371: ---------------------------------------------------------------------------
372: -- PROCEDURE Validate_Record
373: ---------------------------------------------------------------------------
374: --------------------------------------------
375: -- Validate_Record for:OKL_FNCTN_PRMTRS_V --
376: --------------------------------------------
377: FUNCTION Validate_Record (
378: p_fprv_rec IN fprv_rec_type
379: ) RETURN VARCHAR2 IS

Line 511: CURSOR okl_dsfv_pk_csr (p_id IN OKL_FNCTN_PRMTRS_V.dsf_id%TYPE) IS

507: l_dummy VARCHAR2(1) := '?';
508: l_row_not_found BOOLEAN := FALSE;
509:
510: -- Cursor For OKL_FPR_DSF_FK;
511: CURSOR okl_dsfv_pk_csr (p_id IN OKL_FNCTN_PRMTRS_V.dsf_id%TYPE) IS
512: SELECT '1'
513: FROM OKL_DATA_SRC_FNCTNS_V
514: WHERE OKL_DATA_SRC_FNCTNS_V.id = p_id;
515:

Line 588: CURSOR okl_dsfv_pk_csr (p_id IN OKL_FNCTN_PRMTRS_V.dsf_id%TYPE) IS

584: l_dummy VARCHAR2(1) := '?';
585: l_row_not_found BOOLEAN := FALSE;
586:
587: -- Cursor For OKL_FPR_DSF_FK;
588: CURSOR okl_dsfv_pk_csr (p_id IN OKL_FNCTN_PRMTRS_V.dsf_id%TYPE) IS
589: SELECT '1'
590: FROM OKL_DATA_SRC_FNCTNS_V
591: WHERE OKL_DATA_SRC_FNCTNS_V.id = p_id
592: AND OKL_DATA_SRC_FNCTNS_V.FNCTN_CODE = 'PLSQL';

Line 713: CURSOR okl_pmrv_pk_csr (p_id IN OKL_FNCTN_PRMTRS_V.pmr_id%TYPE) IS

709: l_dummy VARCHAR2(1) := '?';
710: l_row_not_found BOOLEAN := FALSE;
711:
712: -- Cursor For OKL_FPR_PMR_FK;
713: CURSOR okl_pmrv_pk_csr (p_id IN OKL_FNCTN_PRMTRS_V.pmr_id%TYPE) IS
714: SELECT '1'
715: FROM OKL_PARAMETERS_V
716: WHERE OKL_PARAMETERS_V.id = p_id;
717:

Line 789: CURSOR okl_fprv_fk_csr (p_code IN OKL_FNCTN_PRMTRS_V.fpr_type%TYPE) IS

785: l_row_found VARCHAR2(1) := OKL_API.G_TRUE;
786:
787: -- Cursor For OKL_FMA_FYP_FK - Foreign Key Constraint
788: /*
789: CURSOR okl_fprv_fk_csr (p_code IN OKL_FNCTN_PRMTRS_V.fpr_type%TYPE) IS
790: SELECT '1'
791: FROM fnd_common_lookups
792: WHERE fnd_common_lookups.lookup_code = p_code
793: AND fnd_common_lookups.lookup_type = 'OKL_FUNCTION_PMR_TYPE';

Line 1022: FROM OKL_FNCTN_PRMTRS_V

1018:
1019: -- Cursor for FOD Unique Key
1020: CURSOR okl_fpr_uk_csr(p_rec fprv_rec_type) IS
1021: SELECT '1'
1022: FROM OKL_FNCTN_PRMTRS_V
1023: WHERE dsf_id = p_rec.dsf_id
1024: AND pmr_id = p_rec.pmr_id
1025: AND id <> NVL(p_rec.id,-9999);
1026:

Line 1036: Okc_Api.set_message(G_APP_NAME,G_UNQS, G_TABLE_TOKEN, 'Okl_Fnctn_Prmtrs_V');

1032: FETCH okl_fpr_uk_csr INTO l_dummy;
1033: l_row_found := okl_fpr_uk_csr%FOUND;
1034: CLOSE okl_fpr_uk_csr;
1035: IF l_row_found THEN
1036: Okc_Api.set_message(G_APP_NAME,G_UNQS, G_TABLE_TOKEN, 'Okl_Fnctn_Prmtrs_V');
1037: x_return_status := Okc_Api.G_RET_STS_ERROR;
1038: END IF;
1039: EXCEPTION
1040: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1192: -- validate_row for:OKL_FNCTN_PRMTRS_V --

1188: ---------------------------------------------------------------------------
1189: -- PROCEDURE validate_row
1190: ---------------------------------------------------------------------------
1191: -----------------------------------------
1192: -- validate_row for:OKL_FNCTN_PRMTRS_V --
1193: -----------------------------------------
1194: PROCEDURE validate_row(
1195: p_api_version IN NUMBER,
1196: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1577: -- insert_row for:OKL_FNCTN_PRMTRS_V --

1573: '_PVT'
1574: );
1575: END insert_row;
1576: ---------------------------------------
1577: -- insert_row for:OKL_FNCTN_PRMTRS_V --
1578: ---------------------------------------
1579: PROCEDURE insert_row(
1580: p_api_version IN NUMBER,
1581: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1613: -- Set_Attributes for:OKL_FNCTN_PRMTRS_V --

1609: l_fprv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1610: RETURN(l_fprv_rec);
1611: END fill_who_columns;
1612: -------------------------------------------
1613: -- Set_Attributes for:OKL_FNCTN_PRMTRS_V --
1614: -------------------------------------------
1615: FUNCTION Set_Attributes (
1616: p_fprv_rec IN fprv_rec_type,
1617: x_fprv_rec OUT NOCOPY fprv_rec_type

Line 2016: -- lock_row for:OKL_FNCTN_PRMTRS_V --

2012: '_PVT'
2013: );
2014: END lock_row;
2015: -------------------------------------
2016: -- lock_row for:OKL_FNCTN_PRMTRS_V --
2017: -------------------------------------
2018: PROCEDURE lock_row(
2019: p_api_version IN NUMBER,
2020: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2531: -- update_row for:OKL_FNCTN_PRMTRS_V --

2527: '_PVT'
2528: );
2529: END update_row;
2530: ---------------------------------------
2531: -- update_row for:OKL_FNCTN_PRMTRS_V --
2532: ---------------------------------------
2533: PROCEDURE update_row(
2534: p_api_version IN NUMBER,
2535: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2640: -- Set_Attributes for:OKL_FNCTN_PRMTRS_V --

2636: END IF;
2637: RETURN(l_return_status);
2638: END populate_new_record;
2639: -------------------------------------------
2640: -- Set_Attributes for:OKL_FNCTN_PRMTRS_V --
2641: -------------------------------------------
2642: FUNCTION Set_Attributes (
2643: p_fprv_rec IN fprv_rec_type,
2644: x_fprv_rec OUT NOCOPY fprv_rec_type

Line 2999: -- delete_row for:OKL_FNCTN_PRMTRS_V --

2995: '_PVT'
2996: );
2997: END delete_row;
2998: ---------------------------------------
2999: -- delete_row for:OKL_FNCTN_PRMTRS_V --
3000: ---------------------------------------
3001: PROCEDURE delete_row(
3002: p_api_version IN NUMBER,
3003: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,