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_VRR_PVT dependencies on OKL_VP_CR_REASONS

Line 94: -- FUNCTION get_rec for: OKL_VP_CR_REASONS_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_VP_CR_REASONS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_vrrv_rec IN vrrv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 100: CURSOR okl_vp_cr_reasons_v_pk_csr (p_id IN NUMBER) IS

96: FUNCTION get_rec (
97: p_vrrv_rec IN vrrv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN vrrv_rec_type IS
100: CURSOR okl_vp_cr_reasons_v_pk_csr (p_id IN NUMBER) IS
101: SELECT
102: ID,
103: OBJECT_VERSION_NUMBER,
104: CRS_ID,

Line 133: FROM Okl_Vp_Cr_Reasons_V

129: CREATION_DATE,
130: LAST_UPDATED_BY,
131: LAST_UPDATE_DATE,
132: LAST_UPDATE_LOGIN
133: FROM Okl_Vp_Cr_Reasons_V
134: WHERE okl_vp_cr_reasons_v.id = p_id;
135: l_okl_vp_cr_reasons_v_pk okl_vp_cr_reasons_v_pk_csr%ROWTYPE;
136: l_vrrv_rec vrrv_rec_type;
137: BEGIN

Line 134: WHERE okl_vp_cr_reasons_v.id = p_id;

130: LAST_UPDATED_BY,
131: LAST_UPDATE_DATE,
132: LAST_UPDATE_LOGIN
133: FROM Okl_Vp_Cr_Reasons_V
134: WHERE okl_vp_cr_reasons_v.id = p_id;
135: l_okl_vp_cr_reasons_v_pk okl_vp_cr_reasons_v_pk_csr%ROWTYPE;
136: l_vrrv_rec vrrv_rec_type;
137: BEGIN
138: x_no_data_found := TRUE;

Line 135: l_okl_vp_cr_reasons_v_pk okl_vp_cr_reasons_v_pk_csr%ROWTYPE;

131: LAST_UPDATE_DATE,
132: LAST_UPDATE_LOGIN
133: FROM Okl_Vp_Cr_Reasons_V
134: WHERE okl_vp_cr_reasons_v.id = p_id;
135: l_okl_vp_cr_reasons_v_pk okl_vp_cr_reasons_v_pk_csr%ROWTYPE;
136: l_vrrv_rec vrrv_rec_type;
137: BEGIN
138: x_no_data_found := TRUE;
139: -- Get current database values

Line 140: OPEN okl_vp_cr_reasons_v_pk_csr (p_vrrv_rec.id);

136: l_vrrv_rec vrrv_rec_type;
137: BEGIN
138: x_no_data_found := TRUE;
139: -- Get current database values
140: OPEN okl_vp_cr_reasons_v_pk_csr (p_vrrv_rec.id);
141: FETCH okl_vp_cr_reasons_v_pk_csr INTO
142: l_vrrv_rec.id,
143: l_vrrv_rec.object_version_number,
144: l_vrrv_rec.crs_id,

Line 141: FETCH okl_vp_cr_reasons_v_pk_csr INTO

137: BEGIN
138: x_no_data_found := TRUE;
139: -- Get current database values
140: OPEN okl_vp_cr_reasons_v_pk_csr (p_vrrv_rec.id);
141: FETCH okl_vp_cr_reasons_v_pk_csr INTO
142: l_vrrv_rec.id,
143: l_vrrv_rec.object_version_number,
144: l_vrrv_rec.crs_id,
145: l_vrrv_rec.reason_code,

Line 173: x_no_data_found := okl_vp_cr_reasons_v_pk_csr%NOTFOUND;

169: l_vrrv_rec.creation_date,
170: l_vrrv_rec.last_updated_by,
171: l_vrrv_rec.last_update_date,
172: l_vrrv_rec.last_update_login;
173: x_no_data_found := okl_vp_cr_reasons_v_pk_csr%NOTFOUND;
174: CLOSE okl_vp_cr_reasons_v_pk_csr;
175: RETURN(l_vrrv_rec);
176: END get_rec;
177:

Line 174: CLOSE okl_vp_cr_reasons_v_pk_csr;

170: l_vrrv_rec.last_updated_by,
171: l_vrrv_rec.last_update_date,
172: l_vrrv_rec.last_update_login;
173: x_no_data_found := okl_vp_cr_reasons_v_pk_csr%NOTFOUND;
174: CLOSE okl_vp_cr_reasons_v_pk_csr;
175: RETURN(l_vrrv_rec);
176: END get_rec;
177:
178: ------------------------------------------------------------------

Line 207: -- FUNCTION get_rec for: OKL_VP_CR_REASONS

203: BEGIN
204: RETURN(get_rec(p_vrrv_rec, l_row_not_found));
205: END get_rec;
206: ---------------------------------------------------------------------------
207: -- FUNCTION get_rec for: OKL_VP_CR_REASONS
208: ---------------------------------------------------------------------------
209: FUNCTION get_rec (
210: p_vrr_rec IN vrr_rec_type,
211: x_no_data_found OUT NOCOPY BOOLEAN

Line 213: CURSOR okl_vp_cr_reasons_pk_csr (p_id IN NUMBER) IS

209: FUNCTION get_rec (
210: p_vrr_rec IN vrr_rec_type,
211: x_no_data_found OUT NOCOPY BOOLEAN
212: ) RETURN vrr_rec_type IS
213: CURSOR okl_vp_cr_reasons_pk_csr (p_id IN NUMBER) IS
214: SELECT
215: ID,
216: OBJECT_VERSION_NUMBER,
217: CRS_ID,

Line 246: FROM Okl_Vp_Cr_Reasons

242: CREATION_DATE,
243: LAST_UPDATED_BY,
244: LAST_UPDATE_DATE,
245: LAST_UPDATE_LOGIN
246: FROM Okl_Vp_Cr_Reasons
247: WHERE okl_vp_cr_reasons.id = p_id;
248: l_okl_vp_cr_reasons_pk okl_vp_cr_reasons_pk_csr%ROWTYPE;
249: l_vrr_rec vrr_rec_type;
250: BEGIN

Line 247: WHERE okl_vp_cr_reasons.id = p_id;

243: LAST_UPDATED_BY,
244: LAST_UPDATE_DATE,
245: LAST_UPDATE_LOGIN
246: FROM Okl_Vp_Cr_Reasons
247: WHERE okl_vp_cr_reasons.id = p_id;
248: l_okl_vp_cr_reasons_pk okl_vp_cr_reasons_pk_csr%ROWTYPE;
249: l_vrr_rec vrr_rec_type;
250: BEGIN
251: x_no_data_found := TRUE;

Line 248: l_okl_vp_cr_reasons_pk okl_vp_cr_reasons_pk_csr%ROWTYPE;

244: LAST_UPDATE_DATE,
245: LAST_UPDATE_LOGIN
246: FROM Okl_Vp_Cr_Reasons
247: WHERE okl_vp_cr_reasons.id = p_id;
248: l_okl_vp_cr_reasons_pk okl_vp_cr_reasons_pk_csr%ROWTYPE;
249: l_vrr_rec vrr_rec_type;
250: BEGIN
251: x_no_data_found := TRUE;
252: -- Get current database values

Line 253: OPEN okl_vp_cr_reasons_pk_csr (p_vrr_rec.id);

249: l_vrr_rec vrr_rec_type;
250: BEGIN
251: x_no_data_found := TRUE;
252: -- Get current database values
253: OPEN okl_vp_cr_reasons_pk_csr (p_vrr_rec.id);
254: FETCH okl_vp_cr_reasons_pk_csr INTO
255: l_vrr_rec.id,
256: l_vrr_rec.object_version_number,
257: l_vrr_rec.crs_id,

Line 254: FETCH okl_vp_cr_reasons_pk_csr INTO

250: BEGIN
251: x_no_data_found := TRUE;
252: -- Get current database values
253: OPEN okl_vp_cr_reasons_pk_csr (p_vrr_rec.id);
254: FETCH okl_vp_cr_reasons_pk_csr INTO
255: l_vrr_rec.id,
256: l_vrr_rec.object_version_number,
257: l_vrr_rec.crs_id,
258: l_vrr_rec.reason_code,

Line 286: x_no_data_found := okl_vp_cr_reasons_pk_csr%NOTFOUND;

282: l_vrr_rec.creation_date,
283: l_vrr_rec.last_updated_by,
284: l_vrr_rec.last_update_date,
285: l_vrr_rec.last_update_login;
286: x_no_data_found := okl_vp_cr_reasons_pk_csr%NOTFOUND;
287: CLOSE okl_vp_cr_reasons_pk_csr;
288: RETURN(l_vrr_rec);
289: END get_rec;
290:

Line 287: CLOSE okl_vp_cr_reasons_pk_csr;

283: l_vrr_rec.last_updated_by,
284: l_vrr_rec.last_update_date,
285: l_vrr_rec.last_update_login;
286: x_no_data_found := okl_vp_cr_reasons_pk_csr%NOTFOUND;
287: CLOSE okl_vp_cr_reasons_pk_csr;
288: RETURN(l_vrr_rec);
289: END get_rec;
290:
291: ------------------------------------------------------------------

Line 320: -- FUNCTION null_out_defaults for: OKL_VP_CR_REASONS_V

316: BEGIN
317: RETURN(get_rec(p_vrr_rec, l_row_not_found));
318: END get_rec;
319: ---------------------------------------------------------------------------
320: -- FUNCTION null_out_defaults for: OKL_VP_CR_REASONS_V
321: ---------------------------------------------------------------------------
322: FUNCTION null_out_defaults (
323: p_vrrv_rec IN vrrv_rec_type
324: ) RETURN vrrv_rec_type IS

Line 525: WHERE lookup_type = 'OKL_VP_CR_REASONS'

521: p_reason_code IN VARCHAR2) IS
522: CURSOR c_valid_reason_csr IS
523: SELECT 'X'
524: FROM fnd_lookups
525: WHERE lookup_type = 'OKL_VP_CR_REASONS'
526: AND lookup_code = p_reason_code;
527: lv_dummy VARCHAR2(1);
528: BEGIN
529: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 561: -- Validate_Attributes for:OKL_VP_CR_REASONS_V --

557: ---------------------------------------------------------------------------
558: -- FUNCTION Validate_Attributes
559: ---------------------------------------------------------------------------
560: -------------------------------------------------
561: -- Validate_Attributes for:OKL_VP_CR_REASONS_V --
562: -------------------------------------------------
563: FUNCTION Validate_Attributes (
564: p_vrrv_rec IN vrrv_rec_type
565: ) RETURN VARCHAR2 IS

Line 626: -- Validate Record for:OKL_VP_CR_REASONS_V --

622: ---------------------------------------------------------------------------
623: -- PROCEDURE Validate_Record
624: ---------------------------------------------------------------------------
625: ---------------------------------------------
626: -- Validate Record for:OKL_VP_CR_REASONS_V --
627: ---------------------------------------------
628: FUNCTION Validate_Record (
629: p_vrrv_rec IN vrrv_rec_type,
630: p_db_vrrv_rec IN vrrv_rec_type

Line 741: -- validate_row for:OKL_VP_CR_REASONS_V --

737: ---------------------------------------------------------------------------
738: -- PROCEDURE validate_row
739: ---------------------------------------------------------------------------
740: ------------------------------------------
741: -- validate_row for:OKL_VP_CR_REASONS_V --
742: ------------------------------------------
743: PROCEDURE validate_row(
744: p_api_version IN NUMBER,
745: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 818: -- PL/SQL TBL validate_row for:OKL_VP_CR_REASONS_V --

814: '_PVT'
815: );
816: END validate_row;
817: -----------------------------------------------------
818: -- PL/SQL TBL validate_row for:OKL_VP_CR_REASONS_V --
819: -----------------------------------------------------
820: PROCEDURE validate_row(
821: p_api_version IN NUMBER,
822: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 914: -- PL/SQL TBL validate_row for:OKL_VP_CR_REASONS_V --

910: );
911: END validate_row;
912:
913: -----------------------------------------------------
914: -- PL/SQL TBL validate_row for:OKL_VP_CR_REASONS_V --
915: -----------------------------------------------------
916: PROCEDURE validate_row(
917: p_api_version IN NUMBER,
918: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 979: -- insert_row for:OKL_VP_CR_REASONS --

975: ---------------------------------------------------------------------------
976: -- PROCEDURE insert_row
977: ---------------------------------------------------------------------------
978: --------------------------------------
979: -- insert_row for:OKL_VP_CR_REASONS --
980: --------------------------------------
981: PROCEDURE insert_row(
982: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
983: x_return_status OUT NOCOPY VARCHAR2,

Line 995: -- Set_Attributes for:OKL_VP_CR_REASONS --

991: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
992: l_vrr_rec vrr_rec_type := p_vrr_rec;
993: l_def_vrr_rec vrr_rec_type;
994: ------------------------------------------
995: -- Set_Attributes for:OKL_VP_CR_REASONS --
996: ------------------------------------------
997: FUNCTION Set_Attributes (
998: p_vrr_rec IN vrr_rec_type,
999: x_vrr_rec OUT NOCOPY vrr_rec_type

Line 1026: INSERT INTO OKL_VP_CR_REASONS(

1022: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1024: RAISE OKL_API.G_EXCEPTION_ERROR;
1025: END IF;
1026: INSERT INTO OKL_VP_CR_REASONS(
1027: id,
1028: object_version_number,
1029: crs_id,
1030: reason_code,

Line 1127: -- insert_row for :OKL_VP_CR_REASONS_V --

1123: '_PVT'
1124: );
1125: END insert_row;
1126: -----------------------------------------
1127: -- insert_row for :OKL_VP_CR_REASONS_V --
1128: -----------------------------------------
1129: PROCEDURE insert_row(
1130: p_api_version IN NUMBER,
1131: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1161: -- Set_Attributes for:OKL_VP_CR_REASONS_V --

1157: l_vrrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1158: RETURN(l_vrrv_rec);
1159: END fill_who_columns;
1160: --------------------------------------------
1161: -- Set_Attributes for:OKL_VP_CR_REASONS_V --
1162: --------------------------------------------
1163: FUNCTION Set_Attributes (
1164: p_vrrv_rec IN vrrv_rec_type,
1165: x_vrrv_rec OUT NOCOPY vrrv_rec_type

Line 1437: -- lock_row for:OKL_VP_CR_REASONS --

1433: ---------------------------------------------------------------------------
1434: -- PROCEDURE lock_row
1435: ---------------------------------------------------------------------------
1436: ------------------------------------
1437: -- lock_row for:OKL_VP_CR_REASONS --
1438: ------------------------------------
1439: PROCEDURE lock_row(
1440: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1441: x_return_status OUT NOCOPY VARCHAR2,

Line 1450: FROM OKL_VP_CR_REASONS

1446: E_Resource_Busy EXCEPTION;
1447: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1448: CURSOR lock_csr (p_vrr_rec IN vrr_rec_type) IS
1449: SELECT OBJECT_VERSION_NUMBER
1450: FROM OKL_VP_CR_REASONS
1451: WHERE ID = p_vrr_rec.id
1452: AND OBJECT_VERSION_NUMBER = p_vrr_rec.object_version_number
1453: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1454:

Line 1457: FROM OKL_VP_CR_REASONS

1453: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1454:
1455: CURSOR lchk_csr (p_vrr_rec IN vrr_rec_type) IS
1456: SELECT OBJECT_VERSION_NUMBER
1457: FROM OKL_VP_CR_REASONS
1458: WHERE ID = p_vrr_rec.id;
1459: l_api_version CONSTANT NUMBER := 1;
1460: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1461: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1462: l_object_version_number OKL_VP_CR_REASONS.OBJECT_VERSION_NUMBER%TYPE;

1458: WHERE ID = p_vrr_rec.id;
1459: l_api_version CONSTANT NUMBER := 1;
1460: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1461: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1462: l_object_version_number OKL_VP_CR_REASONS.OBJECT_VERSION_NUMBER%TYPE;
1463: lc_object_version_number OKL_VP_CR_REASONS.OBJECT_VERSION_NUMBER%TYPE;
1464: l_row_notfound BOOLEAN := FALSE;
1465: lc_row_notfound BOOLEAN := FALSE;
1466: BEGIN

Line 1463: lc_object_version_number OKL_VP_CR_REASONS.OBJECT_VERSION_NUMBER%TYPE;

1459: l_api_version CONSTANT NUMBER := 1;
1460: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1461: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1462: l_object_version_number OKL_VP_CR_REASONS.OBJECT_VERSION_NUMBER%TYPE;
1463: lc_object_version_number OKL_VP_CR_REASONS.OBJECT_VERSION_NUMBER%TYPE;
1464: l_row_notfound BOOLEAN := FALSE;
1465: lc_row_notfound BOOLEAN := FALSE;
1466: BEGIN
1467: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1544: -- lock_row for: OKL_VP_CR_REASONS_V --

1540: '_PVT'
1541: );
1542: END lock_row;
1543: ---------------------------------------
1544: -- lock_row for: OKL_VP_CR_REASONS_V --
1545: ---------------------------------------
1546: PROCEDURE lock_row(
1547: p_api_version IN NUMBER,
1548: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1784: -- update_row for:OKL_VP_CR_REASONS --

1780: ---------------------------------------------------------------------------
1781: -- PROCEDURE update_row
1782: ---------------------------------------------------------------------------
1783: --------------------------------------
1784: -- update_row for:OKL_VP_CR_REASONS --
1785: --------------------------------------
1786: PROCEDURE update_row(
1787: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1788: x_return_status OUT NOCOPY VARCHAR2,

Line 1943: -- Set_Attributes for:OKL_VP_CR_REASONS --

1939: END IF;
1940: RETURN(l_return_status);
1941: END populate_new_record;
1942: ------------------------------------------
1943: -- Set_Attributes for:OKL_VP_CR_REASONS --
1944: ------------------------------------------
1945: FUNCTION Set_Attributes (
1946: p_vrr_rec IN vrr_rec_type,
1947: x_vrr_rec OUT NOCOPY vrr_rec_type

Line 1981: UPDATE OKL_VP_CR_REASONS

1977: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1978: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1979: RAISE OKL_API.G_EXCEPTION_ERROR;
1980: END IF;
1981: UPDATE OKL_VP_CR_REASONS
1982: SET OBJECT_VERSION_NUMBER = l_def_vrr_rec.object_version_number,
1983: CRS_ID = l_def_vrr_rec.crs_id,
1984: REASON_CODE = l_def_vrr_rec.reason_code,
1985: NOTE = l_def_vrr_rec.note,

Line 2050: -- update_row for:OKL_VP_CR_REASONS_V --

2046: '_PVT'
2047: );
2048: END update_row;
2049: ----------------------------------------
2050: -- update_row for:OKL_VP_CR_REASONS_V --
2051: ----------------------------------------
2052: PROCEDURE update_row(
2053: p_api_version IN NUMBER,
2054: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2222: -- Set_Attributes for:OKL_VP_CR_REASONS_V --

2218: END IF;
2219: RETURN(l_return_status);
2220: END populate_new_record;
2221: --------------------------------------------
2222: -- Set_Attributes for:OKL_VP_CR_REASONS_V --
2223: --------------------------------------------
2224: FUNCTION Set_Attributes (
2225: p_vrrv_rec IN vrrv_rec_type,
2226: x_vrrv_rec OUT NOCOPY vrrv_rec_type

Line 2515: -- delete_row for:OKL_VP_CR_REASONS --

2511: ---------------------------------------------------------------------------
2512: -- PROCEDURE delete_row
2513: ---------------------------------------------------------------------------
2514: --------------------------------------
2515: -- delete_row for:OKL_VP_CR_REASONS --
2516: --------------------------------------
2517: PROCEDURE delete_row(
2518: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2519: x_return_status OUT NOCOPY VARCHAR2,

Line 2540: DELETE FROM OKL_VP_CR_REASONS

2536: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2537: RAISE OKL_API.G_EXCEPTION_ERROR;
2538: END IF;
2539:
2540: DELETE FROM OKL_VP_CR_REASONS
2541: WHERE ID = p_vrr_rec.id;
2542:
2543: x_return_status := l_return_status;
2544: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2578: -- delete_row for:OKL_VP_CR_REASONS_V --

2574: '_PVT'
2575: );
2576: END delete_row;
2577: ----------------------------------------
2578: -- delete_row for:OKL_VP_CR_REASONS_V --
2579: ----------------------------------------
2580: PROCEDURE delete_row(
2581: p_api_version IN NUMBER,
2582: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2660: -- PL/SQL TBL delete_row for:OKL_VP_CR_REASONS_V --

2656: '_PVT'
2657: );
2658: END delete_row;
2659: ---------------------------------------------------
2660: -- PL/SQL TBL delete_row for:OKL_VP_CR_REASONS_V --
2661: ---------------------------------------------------
2662: PROCEDURE delete_row(
2663: p_api_version IN NUMBER,
2664: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2756: -- PL/SQL TBL delete_row for:OKL_VP_CR_REASONS_V --

2752: );
2753: END delete_row;
2754:
2755: ---------------------------------------------------
2756: -- PL/SQL TBL delete_row for:OKL_VP_CR_REASONS_V --
2757: ---------------------------------------------------
2758: PROCEDURE delete_row(
2759: p_api_version IN NUMBER,
2760: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,