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_OPD_PVT dependencies on OKL_OPERANDS_V

Line 222: -- FUNCTION get_rec for: OKL_OPERANDS_V

218: BEGIN
219: RETURN(get_rec(p_okl_operands_tl_rec, l_row_notfound));
220: END get_rec;
221: ---------------------------------------------------------------------------
222: -- FUNCTION get_rec for: OKL_OPERANDS_V
223: ---------------------------------------------------------------------------
224: FUNCTION get_rec (
225: p_opdv_rec IN opdv_rec_type,
226: x_no_data_found OUT NOCOPY BOOLEAN

Line 248: FROM Okl_Operands_V

244: CREATION_DATE,
245: LAST_UPDATED_BY,
246: LAST_UPDATE_DATE,
247: LAST_UPDATE_LOGIN
248: FROM Okl_Operands_V
249: WHERE okl_operands_v.id = p_id;
250: l_okl_opdv_pk okl_opdv_pk_csr%ROWTYPE;
251: l_opdv_rec opdv_rec_type;
252: BEGIN

Line 249: WHERE okl_operands_v.id = p_id;

245: LAST_UPDATED_BY,
246: LAST_UPDATE_DATE,
247: LAST_UPDATE_LOGIN
248: FROM Okl_Operands_V
249: WHERE okl_operands_v.id = p_id;
250: l_okl_opdv_pk okl_opdv_pk_csr%ROWTYPE;
251: l_opdv_rec opdv_rec_type;
252: BEGIN
253: x_no_data_found := TRUE;

Line 289: -- FUNCTION null_out_defaults for: OKL_OPERANDS_V --

285: RETURN(get_rec(p_opdv_rec, l_row_notfound));
286: END get_rec;
287:
288: ----------------------------------------------------
289: -- FUNCTION null_out_defaults for: OKL_OPERANDS_V --
290: ----------------------------------------------------
291: FUNCTION null_out_defaults (
292: p_opdv_rec IN opdv_rec_type
293: ) RETURN opdv_rec_type IS

Line 354: -- Validate_Attributes for:OKL_OPERANDS_V --

350: ---------------------------------------------------------------------------
351: -- PROCEDURE Validate_Attributes
352: ---------------------------------------------------------------------------
353: --------------------------------------------
354: -- Validate_Attributes for:OKL_OPERANDS_V --
355: --------------------------------------------
356: FUNCTION Validate_Attributes (
357: p_opdv_rec IN opdv_rec_type
358: ) RETURN VARCHAR2 IS

Line 399: -- Validate_Record for:OKL_OPERANDS_V --

395: ---------------------------------------------------------------------------
396: -- PROCEDURE Validate_Record
397: ---------------------------------------------------------------------------
398: ----------------------------------------
399: -- Validate_Record for:OKL_OPERANDS_V --
400: ----------------------------------------
401: FUNCTION Validate_Record (
402: p_opdv_rec IN opdv_rec_type
403: ) RETURN VARCHAR2 IS

Line 641: CURSOR okl_fclv_code_csr (p_code IN OKL_OPERANDS_V.opd_type%TYPE) IS

637: l_row_found VARCHAR2(1) := OKL_API.G_TRUE;
638:
639: -- Cursor For OKL_OPD_FCL_FK;
640: /*
641: CURSOR okl_fclv_code_csr (p_code IN OKL_OPERANDS_V.opd_type%TYPE) IS
642: SELECT '1'
643: FROM FND_COMMON_LOOKUPS
644: WHERE FND_COMMON_LOOKUPS.LOOKUP_CODE = p_code
645: AND FND_COMMON_LOOKUPS.LOOKUP_TYPE = 'OKL_OPERAND_TYPE';

Line 755: CURSOR okl_opd_name_csr(p_name OKL_OPERANDS_V.name%TYPE)

751: l_dummy VARCHAR2(1) := '?';
752: l_row_found BOOLEAN := FALSE;
753:
754: -- Cursor for Name Attribute
755: CURSOR okl_opd_name_csr(p_name OKL_OPERANDS_V.name%TYPE)
756: IS
757: SELECT '1'
758: FROM OKL_OPERANDS_V
759: WHERE name = p_opdv_rec.name

Line 758: FROM OKL_OPERANDS_V

754: -- Cursor for Name Attribute
755: CURSOR okl_opd_name_csr(p_name OKL_OPERANDS_V.name%TYPE)
756: IS
757: SELECT '1'
758: FROM OKL_OPERANDS_V
759: WHERE name = p_opdv_rec.name
760: AND id <> p_opdv_rec.id;
761:
762:

Line 869: CURSOR okl_dsfv_pk_csr (p_id IN OKL_OPERANDS_V.dsf_id%TYPE) IS

865: l_dummy VARCHAR2(1) := '?';
866: l_row_not_found BOOLEAN := FALSE;
867:
868: -- Cursor For OKL_OPD_DSF_FK;
869: CURSOR okl_dsfv_pk_csr (p_id IN OKL_OPERANDS_V.dsf_id%TYPE) IS
870: SELECT '1'
871: FROM OKL_DATA_SRC_FNCTNS_V
872: WHERE OKL_DATA_SRC_FNCTNS_V.id = p_id;
873:

Line 946: CURSOR okl_dsfv_pk_csr (p_id IN OKL_OPERANDS_V.dsf_id%TYPE) IS

942: l_dummy VARCHAR2(1) := '?';
943: l_row_not_found BOOLEAN := FALSE;
944:
945: -- Cursor For OKL_OPD_DSF_FK;
946: CURSOR okl_dsfv_pk_csr (p_id IN OKL_OPERANDS_V.dsf_id%TYPE) IS
947: SELECT '1'
948: FROM OKL_DATA_SRC_FNCTNS_V
949: WHERE OKL_DATA_SRC_FNCTNS_V.id = p_id
950: AND OKL_DATA_SRC_FNCTNS_V.fnctn_code = 'PLSQL';

Line 1015: CURSOR okl_fmav_pk_csr (p_id IN OKL_OPERANDS_V.fma_id%TYPE) IS

1011: l_row_not_found BOOLEAN := FALSE;
1012:
1013: -- Cursor For OKL_OPD_FMA_FK;
1014: -- RPOONUGA001: Correcting the cursor to the correct view
1015: CURSOR okl_fmav_pk_csr (p_id IN OKL_OPERANDS_V.fma_id%TYPE) IS
1016: SELECT '1'
1017: FROM OKL_FORMULAE_V
1018: WHERE OKL_FORMULAE_V.id = p_id;
1019:

Line 1367: FROM OKL_OPERANDS_V

1363:
1364: -- Cursor for OPD Unique Key
1365: CURSOR okl_opd_uk_csr(p_rec opdv_rec_type) IS
1366: SELECT '1'
1367: FROM OKL_OPERANDS_V
1368: WHERE name = p_rec.name
1369: AND version = p_rec.version
1370: AND id <> NVL(p_rec.id,-9999);
1371:

Line 1381: Okc_Api.set_message('OKL',G_UNQS, G_TABLE_TOKEN, 'Okl_Operands_V');

1377: FETCH okl_opd_uk_csr INTO l_dummy;
1378: l_row_found := okl_opd_uk_csr%FOUND;
1379: CLOSE okl_opd_uk_csr;
1380: IF l_row_found THEN
1381: Okc_Api.set_message('OKL',G_UNQS, G_TABLE_TOKEN, 'Okl_Operands_V');
1382: x_return_status := Okc_Api.G_RET_STS_ERROR;
1383: END IF;
1384: EXCEPTION
1385: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1556: -- validate_row for:OKL_OPERANDS_V --

1552: ---------------------------------------------------------------------------
1553: -- PROCEDURE validate_row
1554: ---------------------------------------------------------------------------
1555: -------------------------------------
1556: -- validate_row for:OKL_OPERANDS_V --
1557: -------------------------------------
1558: PROCEDURE validate_row(
1559: p_api_version IN NUMBER,
1560: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1943: -- insert_row for:OKL_OPERANDS_V --

1939: '_PVT'
1940: );
1941: END insert_row;
1942: -----------------------------------
1943: -- insert_row for:OKL_OPERANDS_V --
1944: -----------------------------------
1945: PROCEDURE insert_row(
1946: p_api_version IN NUMBER,
1947: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1979: -- Set_Attributes for:OKL_OPERANDS_V --

1975: l_opdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1976: RETURN(l_opdv_rec);
1977: END fill_who_columns;
1978: ---------------------------------------
1979: -- Set_Attributes for:OKL_OPERANDS_V --
1980: ---------------------------------------
1981: FUNCTION Set_Attributes (
1982: p_opdv_rec IN opdv_rec_type,
1983: x_opdv_rec OUT NOCOPY opdv_rec_type

Line 2377: -- lock_row for:OKL_OPERANDS_V --

2373: '_PVT'
2374: );
2375: END lock_row;
2376: ---------------------------------
2377: -- lock_row for:OKL_OPERANDS_V --
2378: ---------------------------------
2379: PROCEDURE lock_row(
2380: p_api_version IN NUMBER,
2381: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2906: -- update_row for:OKL_OPERANDS_V --

2902: '_PVT'
2903: );
2904: END update_row;
2905: -----------------------------------
2906: -- update_row for:OKL_OPERANDS_V --
2907: -----------------------------------
2908: PROCEDURE update_row(
2909: p_api_version IN NUMBER,
2910: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3031: -- Set_Attributes for:OKL_OPERANDS_V --

3027: END IF;
3028: RETURN(l_return_status);
3029: END populate_new_record;
3030: ---------------------------------------
3031: -- Set_Attributes for:OKL_OPERANDS_V --
3032: ---------------------------------------
3033: FUNCTION Set_Attributes (
3034: p_opdv_rec IN opdv_rec_type,
3035: x_opdv_rec OUT NOCOPY opdv_rec_type

Line 3384: -- delete_row for:OKL_OPERANDS_V --

3380: '_PVT'
3381: );
3382: END delete_row;
3383: -----------------------------------
3384: -- delete_row for:OKL_OPERANDS_V --
3385: -----------------------------------
3386: PROCEDURE delete_row(
3387: p_api_version IN NUMBER,
3388: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,