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_ASV_PVT dependencies on OKL_ANSR_SET_CN_VLS

Line 95: p_token3_value => 'OKL_ANSR_SET_CN_VLS_V');

91: p_token1_value => 'ASR_ID_FOR',
92: p_token2 => G_CHILD_TABLE_TOKEN,
93: p_token2_value => G_VIEW,
94: p_token3 => G_PARENT_TABLE_TOKEN,
95: p_token3_value => 'OKL_ANSR_SET_CN_VLS_V');
96:
97: RAISE G_EXCEPTION_HALT_VALIDATION;
98: END IF;
99: END validate_asr_id;

Line 144: p_token3_value => 'OKL_ANSR_SET_CN_VLS_V');

140: p_token1_value => 'CRN_ID_FOR',
141: p_token2 => G_CHILD_TABLE_TOKEN,
142: p_token2_value => G_VIEW,
143: p_token3 => G_PARENT_TABLE_TOKEN,
144: p_token3_value => 'OKL_ANSR_SET_CN_VLS_V');
145:
146: RAISE G_EXCEPTION_HALT_VALIDATION;
147: END IF;
148: END validate_crn_id;

Line 246: -- FUNCTION get_rec for: OKL_ANSR_SET_CN_VLS

242: NULL;
243: END api_copy;
244:
245: ---------------------------------------------------------------------------
246: -- FUNCTION get_rec for: OKL_ANSR_SET_CN_VLS
247: ---------------------------------------------------------------------------
248: FUNCTION get_rec (
249: p_asv_rec IN asv_rec_type,
250: x_no_data_found OUT NOCOPY BOOLEAN

Line 287: FROM Okl_Ansr_Set_Cn_Vls

283: CREATION_DATE,
284: LAST_UPDATED_BY,
285: LAST_UPDATE_DATE,
286: LAST_UPDATE_LOGIN
287: FROM Okl_Ansr_Set_Cn_Vls
288: WHERE okl_ansr_set_cn_vls.id = p_id;
289: l_asv_pk asv_pk_csr%ROWTYPE;
290: l_asv_rec asv_rec_type;
291: BEGIN

Line 288: WHERE okl_ansr_set_cn_vls.id = p_id;

284: LAST_UPDATED_BY,
285: LAST_UPDATE_DATE,
286: LAST_UPDATE_LOGIN
287: FROM Okl_Ansr_Set_Cn_Vls
288: WHERE okl_ansr_set_cn_vls.id = p_id;
289: l_asv_pk asv_pk_csr%ROWTYPE;
290: l_asv_rec asv_rec_type;
291: BEGIN
292: x_no_data_found := TRUE;

Line 342: -- FUNCTION get_rec for: OKL_ANSR_SET_CN_VLS_V

338: BEGIN
339: RETURN(get_rec(p_asv_rec, l_row_notfound));
340: END get_rec;
341: ---------------------------------------------------------------------------
342: -- FUNCTION get_rec for: OKL_ANSR_SET_CN_VLS_V
343: ---------------------------------------------------------------------------
344: FUNCTION get_rec (
345: p_asvv_rec IN asvv_rec_type,
346: x_no_data_found OUT NOCOPY BOOLEAN

Line 383: FROM Okl_Ansr_Set_Cn_Vls_V

379: CREATION_DATE,
380: LAST_UPDATED_BY,
381: LAST_UPDATE_DATE,
382: LAST_UPDATE_LOGIN
383: FROM Okl_Ansr_Set_Cn_Vls_V
384: WHERE okl_ansr_set_cn_vls_v.id = p_id;
385: l_okl_asvv_pk okl_asvv_pk_csr%ROWTYPE;
386: l_asvv_rec asvv_rec_type;
387: BEGIN

Line 384: WHERE okl_ansr_set_cn_vls_v.id = p_id;

380: LAST_UPDATED_BY,
381: LAST_UPDATE_DATE,
382: LAST_UPDATE_LOGIN
383: FROM Okl_Ansr_Set_Cn_Vls_V
384: WHERE okl_ansr_set_cn_vls_v.id = p_id;
385: l_okl_asvv_pk okl_asvv_pk_csr%ROWTYPE;
386: l_asvv_rec asvv_rec_type;
387: BEGIN
388: x_no_data_found := TRUE;

Line 439: -- FUNCTION null_out_defaults for: OKL_ANSR_SET_CN_VLS_V --

435: RETURN(get_rec(p_asvv_rec, l_row_notfound));
436: END get_rec;
437:
438: -----------------------------------------------------------
439: -- FUNCTION null_out_defaults for: OKL_ANSR_SET_CN_VLS_V --
440: -----------------------------------------------------------
441: FUNCTION null_out_defaults (
442: p_asvv_rec IN asvv_rec_type
443: ) RETURN asvv_rec_type IS

Line 548: -- Validate_Attributes for:OKL_ANSR_SET_CN_VLS_V --

544: ---------------------------------------------------------------------------
545: -- PROCEDURE Validate_Attributes
546: ---------------------------------------------------------------------------
547: ---------------------------------------------------
548: -- Validate_Attributes for:OKL_ANSR_SET_CN_VLS_V --
549: ---------------------------------------------------
550: FUNCTION Validate_Attributes (
551: p_asvv_rec IN asvv_rec_type
552: ) RETURN VARCHAR2 IS

Line 627: -- Validate_Record for:OKL_ANSR_SET_CN_VLS_V --

623: ---------------------------------------------------------------------------
624: -- PROCEDURE Validate_Record
625: ---------------------------------------------------------------------------
626: -----------------------------------------------
627: -- Validate_Record for:OKL_ANSR_SET_CN_VLS_V --
628: -----------------------------------------------
629: FUNCTION Validate_Record (
630: p_asvv_rec IN asvv_rec_type
631: ) RETURN VARCHAR2 IS

Line 723: -- validate_row for:OKL_ANSR_SET_CN_VLS_V --

719: ---------------------------------------------------------------------------
720: -- PROCEDURE validate_row
721: ---------------------------------------------------------------------------
722: --------------------------------------------
723: -- validate_row for:OKL_ANSR_SET_CN_VLS_V --
724: --------------------------------------------
725: PROCEDURE validate_row(
726: p_api_version IN NUMBER,
727: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 867: -- insert_row for:OKL_ANSR_SET_CN_VLS --

863: ---------------------------------------------------------------------------
864: -- PROCEDURE insert_row
865: ---------------------------------------------------------------------------
866: ----------------------------------------
867: -- insert_row for:OKL_ANSR_SET_CN_VLS --
868: ----------------------------------------
869: PROCEDURE insert_row(
870: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
871: x_return_status OUT NOCOPY VARCHAR2,

Line 883: -- Set_Attributes for:OKL_ANSR_SET_CN_VLS --

879: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
880: l_asv_rec asv_rec_type := p_asv_rec;
881: l_def_asv_rec asv_rec_type;
882: --------------------------------------------
883: -- Set_Attributes for:OKL_ANSR_SET_CN_VLS --
884: --------------------------------------------
885: FUNCTION Set_Attributes (
886: p_asv_rec IN asv_rec_type,
887: x_asv_rec OUT NOCOPY asv_rec_type

Line 914: INSERT INTO OKL_ANSR_SET_CN_VLS(

910: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
911: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
912: RAISE okl_api.G_EXCEPTION_ERROR;
913: END IF;
914: INSERT INTO OKL_ANSR_SET_CN_VLS(
915: id,
916: asr_id,
917: sequence_number,
918: crn_id,

Line 1018: -- insert_row for:OKL_ANSR_SET_CN_VLS_V --

1014: '_PVT'
1015: );
1016: END insert_row;
1017: ------------------------------------------
1018: -- insert_row for:OKL_ANSR_SET_CN_VLS_V --
1019: ------------------------------------------
1020: PROCEDURE insert_row(
1021: p_api_version IN NUMBER,
1022: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1052: -- Set_Attributes for:OKL_ANSR_SET_CN_VLS_V --

1048: l_asvv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1049: RETURN(l_asvv_rec);
1050: END fill_who_columns;
1051: ----------------------------------------------
1052: -- Set_Attributes for:OKL_ANSR_SET_CN_VLS_V --
1053: ----------------------------------------------
1054: FUNCTION Set_Attributes (
1055: p_asvv_rec IN asvv_rec_type,
1056: x_asvv_rec OUT NOCOPY asvv_rec_type

Line 1232: -- lock_row for:OKL_ANSR_SET_CN_VLS --

1228: ---------------------------------------------------------------------------
1229: -- PROCEDURE lock_row
1230: ---------------------------------------------------------------------------
1231: --------------------------------------
1232: -- lock_row for:OKL_ANSR_SET_CN_VLS --
1233: --------------------------------------
1234: PROCEDURE lock_row(
1235: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1236: x_return_status OUT NOCOPY VARCHAR2,

Line 1245: FROM OKL_ANSR_SET_CN_VLS

1241: E_Resource_Busy EXCEPTION;
1242: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1243: CURSOR lock_csr (p_asv_rec IN asv_rec_type) IS
1244: SELECT OBJECT_VERSION_NUMBER
1245: FROM OKL_ANSR_SET_CN_VLS
1246: WHERE ID = p_asv_rec.id
1247: AND OBJECT_VERSION_NUMBER = p_asv_rec.object_version_number
1248: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1249:

Line 1252: FROM OKL_ANSR_SET_CN_VLS

1248: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1249:
1250: CURSOR lchk_csr (p_asv_rec IN asv_rec_type) IS
1251: SELECT OBJECT_VERSION_NUMBER
1252: FROM OKL_ANSR_SET_CN_VLS
1253: WHERE ID = p_asv_rec.id;
1254: l_api_version CONSTANT NUMBER := 1;
1255: l_api_name CONSTANT VARCHAR2(30) := 'VLS_lock_row';
1256: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 1257: l_object_version_number OKL_ANSR_SET_CN_VLS.OBJECT_VERSION_NUMBER%TYPE;

1253: WHERE ID = p_asv_rec.id;
1254: l_api_version CONSTANT NUMBER := 1;
1255: l_api_name CONSTANT VARCHAR2(30) := 'VLS_lock_row';
1256: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1257: l_object_version_number OKL_ANSR_SET_CN_VLS.OBJECT_VERSION_NUMBER%TYPE;
1258: lc_object_version_number OKL_ANSR_SET_CN_VLS.OBJECT_VERSION_NUMBER%TYPE;
1259: l_row_notfound BOOLEAN := FALSE;
1260: lc_row_notfound BOOLEAN := FALSE;
1261: BEGIN

Line 1258: lc_object_version_number OKL_ANSR_SET_CN_VLS.OBJECT_VERSION_NUMBER%TYPE;

1254: l_api_version CONSTANT NUMBER := 1;
1255: l_api_name CONSTANT VARCHAR2(30) := 'VLS_lock_row';
1256: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1257: l_object_version_number OKL_ANSR_SET_CN_VLS.OBJECT_VERSION_NUMBER%TYPE;
1258: lc_object_version_number OKL_ANSR_SET_CN_VLS.OBJECT_VERSION_NUMBER%TYPE;
1259: l_row_notfound BOOLEAN := FALSE;
1260: lc_row_notfound BOOLEAN := FALSE;
1261: BEGIN
1262: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 1338: -- lock_row for:OKL_ANSR_SET_CN_VLS_V --

1334: '_PVT'
1335: );
1336: END lock_row;
1337: ----------------------------------------
1338: -- lock_row for:OKL_ANSR_SET_CN_VLS_V --
1339: ----------------------------------------
1340: PROCEDURE lock_row(
1341: p_api_version IN NUMBER,
1342: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1486: -- update_row for:OKL_ANSR_SET_CN_VLS --

1482: ---------------------------------------------------------------------------
1483: -- PROCEDURE update_row
1484: ---------------------------------------------------------------------------
1485: ----------------------------------------
1486: -- update_row for:OKL_ANSR_SET_CN_VLS --
1487: ----------------------------------------
1488: PROCEDURE update_row(
1489: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1490: x_return_status OUT NOCOPY VARCHAR2,

Line 1654: -- Set_Attributes for:OKL_ANSR_SET_CN_VLS --

1650: END IF;
1651: RETURN(l_return_status);
1652: END populate_new_record;
1653: --------------------------------------------
1654: -- Set_Attributes for:OKL_ANSR_SET_CN_VLS --
1655: --------------------------------------------
1656: FUNCTION Set_Attributes (
1657: p_asv_rec IN asv_rec_type,
1658: x_asv_rec OUT NOCOPY asv_rec_type

Line 1691: UPDATE OKL_ANSR_SET_CN_VLS

1687: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1688: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1689: RAISE okl_api.G_EXCEPTION_ERROR;
1690: END IF;
1691: UPDATE OKL_ANSR_SET_CN_VLS
1692: SET ASR_ID = l_def_asv_rec.asr_id,
1693: SEQUENCE_NUMBER = l_def_asv_rec.sequence_number,
1694: CRN_ID = l_def_asv_rec.crn_id,
1695: ASV_TYPE = l_def_asv_rec.asv_type,

Line 1761: -- update_row for:OKL_ANSR_SET_CN_VLS_V --

1757: '_PVT'
1758: );
1759: END update_row;
1760: ------------------------------------------
1761: -- update_row for:OKL_ANSR_SET_CN_VLS_V --
1762: ------------------------------------------
1763: PROCEDURE update_row(
1764: p_api_version IN NUMBER,
1765: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1944: -- Set_Attributes for:OKL_ANSR_SET_CN_VLS_V --

1940: END IF;
1941: RETURN(l_return_status);
1942: END populate_new_record;
1943: ----------------------------------------------
1944: -- Set_Attributes for:OKL_ANSR_SET_CN_VLS_V --
1945: ----------------------------------------------
1946: FUNCTION Set_Attributes (
1947: p_asvv_rec IN asvv_rec_type,
1948: x_asvv_rec OUT NOCOPY asvv_rec_type

Line 2127: -- delete_row for:OKL_ANSR_SET_CN_VLS --

2123: ---------------------------------------------------------------------------
2124: -- PROCEDURE delete_row
2125: ---------------------------------------------------------------------------
2126: ----------------------------------------
2127: -- delete_row for:OKL_ANSR_SET_CN_VLS --
2128: ----------------------------------------
2129: PROCEDURE delete_row(
2130: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2131: x_return_status OUT NOCOPY VARCHAR2,

Line 2151: DELETE FROM OKL_ANSR_SET_CN_VLS

2147: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
2148: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2149: RAISE okl_api.G_EXCEPTION_ERROR;
2150: END IF;
2151: DELETE FROM OKL_ANSR_SET_CN_VLS
2152: WHERE ID = l_asv_rec.id;
2153:
2154: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2155: EXCEPTION

Line 2188: -- delete_row for:OKL_ANSR_SET_CN_VLS_V --

2184: '_PVT'
2185: );
2186: END delete_row;
2187: ------------------------------------------
2188: -- delete_row for:OKL_ANSR_SET_CN_VLS_V --
2189: ------------------------------------------
2190: PROCEDURE delete_row(
2191: p_api_version IN NUMBER,
2192: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,