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_RTV_PVT dependencies on OKC_RESOLVED_TIMEVALUES

Line 38: -- FUNCTION get_rec for: OKC_RESOLVED_TIMEVALUES

34: null;
35: END api_copy;
36:
37: ---------------------------------------------------------------------------
38: -- FUNCTION get_rec for: OKC_RESOLVED_TIMEVALUES
39: ---------------------------------------------------------------------------
40: FUNCTION get_rec (
41: p_rtv_rec IN rtv_rec_type,
42: x_no_data_found OUT NOCOPY BOOLEAN

Line 56: FROM Okc_Resolved_Timevalues

52: CREATION_DATE,
53: LAST_UPDATED_BY,
54: LAST_UPDATE_DATE,
55: LAST_UPDATE_LOGIN
56: FROM Okc_Resolved_Timevalues
57: WHERE okc_resolved_timevalues.id = p_id;
58: l_rtv_pk rtv_pk_csr%ROWTYPE;
59: l_rtv_rec rtv_rec_type;
60: BEGIN

Line 57: WHERE okc_resolved_timevalues.id = p_id;

53: LAST_UPDATED_BY,
54: LAST_UPDATE_DATE,
55: LAST_UPDATE_LOGIN
56: FROM Okc_Resolved_Timevalues
57: WHERE okc_resolved_timevalues.id = p_id;
58: l_rtv_pk rtv_pk_csr%ROWTYPE;
59: l_rtv_rec rtv_rec_type;
60: BEGIN
61: x_no_data_found := TRUE;

Line 88: -- FUNCTION get_rec for: OKC_RESOLVED_TIMEVALUES_V

84: BEGIN
85: RETURN(get_rec(p_rtv_rec, l_row_notfound));
86: END get_rec;
87: ---------------------------------------------------------------------------
88: -- FUNCTION get_rec for: OKC_RESOLVED_TIMEVALUES_V
89: ---------------------------------------------------------------------------
90: FUNCTION get_rec (
91: p_rtvv_rec IN rtvv_rec_type,
92: x_no_data_found OUT NOCOPY BOOLEAN

Line 106: FROM Okc_Resolved_Timevalues_V

102: CREATION_DATE,
103: LAST_UPDATED_BY,
104: LAST_UPDATE_DATE,
105: LAST_UPDATE_LOGIN
106: FROM Okc_Resolved_Timevalues_V
107: WHERE okc_resolved_timevalues_v.id = p_id;
108: l_okc_ttvv_pk okc_ttvv_pk_csr%ROWTYPE;
109: l_rtvv_rec rtvv_rec_type;
110: BEGIN

Line 107: WHERE okc_resolved_timevalues_v.id = p_id;

103: LAST_UPDATED_BY,
104: LAST_UPDATE_DATE,
105: LAST_UPDATE_LOGIN
106: FROM Okc_Resolved_Timevalues_V
107: WHERE okc_resolved_timevalues_v.id = p_id;
108: l_okc_ttvv_pk okc_ttvv_pk_csr%ROWTYPE;
109: l_rtvv_rec rtvv_rec_type;
110: BEGIN
111: x_no_data_found := TRUE;

Line 139: -- FUNCTION null_out_defaults for: OKC_RESOLVED_TIMEVALUES_V --

135: RETURN(get_rec(p_rtvv_rec, l_row_notfound));
136: END get_rec;
137:
138: ---------------------------------------------------------------
139: -- FUNCTION null_out_defaults for: OKC_RESOLVED_TIMEVALUES_V --
140: ---------------------------------------------------------------
141: FUNCTION null_out_defaults (
142: p_rtvv_rec IN rtvv_rec_type
143: ) RETURN rtvv_rec_type IS

Line 183: -- Validate_Attributes for:OKC_RESOLVED_TIMEVALUES_V --

179: -- 1. Moved all column validations (including FK) to Validate_column
180: -- and is called from Validate_Attributes
181: -- 2. Validate_Records will have tuple rule checks.
182: -------------------------------------------------------
183: -- Validate_Attributes for:OKC_RESOLVED_TIMEVALUES_V --
184: -------------------------------------------------------
185: ---------------------------------------------------------------------------
186:
187: PROCEDURE Validate_Tve_Id (

Line 371: -- Validate_Record for:OKC_RESOLVED_TIMEVALUES_V --

367: ---------------------------------------------------------------------------
368: -- PROCEDURE Validate_Record
369: ---------------------------------------------------------------------------
370: ---------------------------------------------------
371: -- Validate_Record for:OKC_RESOLVED_TIMEVALUES_V --
372: ---------------------------------------------------
373: FUNCTION Validate_Record (
374: p_rtvv_rec IN rtvv_rec_type
375: ) RETURN VARCHAR2 IS

Line 425: -- validate_row for:OKC_RESOLVED_TIMEVALUES_V --

421: ---------------------------------------------------------------------------
422: -- PROCEDURE validate_row
423: ---------------------------------------------------------------------------
424: ------------------------------------------------
425: -- validate_row for:OKC_RESOLVED_TIMEVALUES_V --
426: ------------------------------------------------
427: PROCEDURE validate_row(
428: p_api_version IN NUMBER,
429: p_init_msg_list IN VARCHAR2,

Line 569: -- insert_row for:OKC_RESOLVED_TIMEVALUES --

565: ---------------------------------------------------------------------------
566: -- PROCEDURE insert_row
567: ---------------------------------------------------------------------------
568: --------------------------------------------
569: -- insert_row for:OKC_RESOLVED_TIMEVALUES --
570: --------------------------------------------
571: PROCEDURE insert_row(
572: p_init_msg_list IN VARCHAR2,
573: x_return_status OUT NOCOPY VARCHAR2,

Line 585: -- Set_Attributes for:OKC_RESOLVED_TIMEVALUES --

581: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
582: l_rtv_rec rtv_rec_type := p_rtv_rec;
583: l_def_rtv_rec rtv_rec_type;
584: ------------------------------------------------
585: -- Set_Attributes for:OKC_RESOLVED_TIMEVALUES --
586: ------------------------------------------------
587: FUNCTION Set_Attributes (
588: p_rtv_rec IN rtv_rec_type,
589: x_rtv_rec OUT NOCOPY rtv_rec_type

Line 616: INSERT INTO OKC_RESOLVED_TIMEVALUES(

612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
614: RAISE OKC_API.G_EXCEPTION_ERROR;
615: END IF;
616: INSERT INTO OKC_RESOLVED_TIMEVALUES(
617: id,
618: tve_id,
619: coe_id,
620: datetime,

Line 674: -- insert_row for:OKC_RESOLVED_TIMEVALUES_V --

670: '_PVT'
671: );
672: END insert_row;
673: ----------------------------------------------
674: -- insert_row for:OKC_RESOLVED_TIMEVALUES_V --
675: ----------------------------------------------
676: PROCEDURE insert_row(
677: p_api_version IN NUMBER,
678: p_init_msg_list IN VARCHAR2,

Line 708: -- Set_Attributes for:OKC_RESOLVED_TIMEVALUES_V --

704: l_rtvv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
705: RETURN(l_rtvv_rec);
706: END fill_who_columns;
707: --------------------------------------------------
708: -- Set_Attributes for:OKC_RESOLVED_TIMEVALUES_V --
709: --------------------------------------------------
710: FUNCTION Set_Attributes (
711: p_rtvv_rec IN rtvv_rec_type,
712: x_rtvv_rec OUT NOCOPY rtvv_rec_type

Line 888: -- lock_row for:OKC_RESOLVED_TIMEVALUES --

884: ---------------------------------------------------------------------------
885: -- PROCEDURE lock_row
886: ---------------------------------------------------------------------------
887: ------------------------------------------
888: -- lock_row for:OKC_RESOLVED_TIMEVALUES --
889: ------------------------------------------
890: PROCEDURE lock_row(
891: p_init_msg_list IN VARCHAR2,
892: x_return_status OUT NOCOPY VARCHAR2,

Line 901: FROM OKC_RESOLVED_TIMEVALUES

897: E_Resource_Busy EXCEPTION;
898: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
899: CURSOR lock_csr (p_rtv_rec IN rtv_rec_type) IS
900: SELECT OBJECT_VERSION_NUMBER
901: FROM OKC_RESOLVED_TIMEVALUES
902: WHERE ID = p_rtv_rec.id
903: AND OBJECT_VERSION_NUMBER = p_rtv_rec.object_version_number
904: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
905:

Line 908: FROM OKC_RESOLVED_TIMEVALUES

904: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
905:
906: CURSOR lchk_csr (p_rtv_rec IN rtv_rec_type) IS
907: SELECT OBJECT_VERSION_NUMBER
908: FROM OKC_RESOLVED_TIMEVALUES
909: WHERE ID = p_rtv_rec.id;
910: l_api_version CONSTANT NUMBER := 1;
911: l_api_name CONSTANT VARCHAR2(30) := 'TIMEVALUES_lock_row';
912: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 913: l_object_version_number OKC_RESOLVED_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;

909: WHERE ID = p_rtv_rec.id;
910: l_api_version CONSTANT NUMBER := 1;
911: l_api_name CONSTANT VARCHAR2(30) := 'TIMEVALUES_lock_row';
912: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
913: l_object_version_number OKC_RESOLVED_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
914: lc_object_version_number OKC_RESOLVED_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
915: l_row_notfound BOOLEAN := FALSE;
916: lc_row_notfound BOOLEAN := FALSE;
917: BEGIN

Line 914: lc_object_version_number OKC_RESOLVED_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;

910: l_api_version CONSTANT NUMBER := 1;
911: l_api_name CONSTANT VARCHAR2(30) := 'TIMEVALUES_lock_row';
912: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
913: l_object_version_number OKC_RESOLVED_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
914: lc_object_version_number OKC_RESOLVED_TIMEVALUES.OBJECT_VERSION_NUMBER%TYPE;
915: l_row_notfound BOOLEAN := FALSE;
916: lc_row_notfound BOOLEAN := FALSE;
917: BEGIN
918: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 994: -- lock_row for:OKC_RESOLVED_TIMEVALUES_V --

990: '_PVT'
991: );
992: END lock_row;
993: --------------------------------------------
994: -- lock_row for:OKC_RESOLVED_TIMEVALUES_V --
995: --------------------------------------------
996: PROCEDURE lock_row(
997: p_api_version IN NUMBER,
998: p_init_msg_list IN VARCHAR2,

Line 1142: -- update_row for:OKC_RESOLVED_TIMEVALUES --

1138: ---------------------------------------------------------------------------
1139: -- PROCEDURE update_row
1140: ---------------------------------------------------------------------------
1141: --------------------------------------------
1142: -- update_row for:OKC_RESOLVED_TIMEVALUES --
1143: --------------------------------------------
1144: PROCEDURE update_row(
1145: p_init_msg_list IN VARCHAR2,
1146: x_return_status OUT NOCOPY VARCHAR2,

Line 1218: -- Set_Attributes for:OKC_RESOLVED_TIMEVALUES --

1214: END IF;
1215: RETURN(l_return_status);
1216: END populate_new_record;
1217: ------------------------------------------------
1218: -- Set_Attributes for:OKC_RESOLVED_TIMEVALUES --
1219: ------------------------------------------------
1220: FUNCTION Set_Attributes (
1221: p_rtv_rec IN rtv_rec_type,
1222: x_rtv_rec OUT NOCOPY rtv_rec_type

Line 1255: UPDATE OKC_RESOLVED_TIMEVALUES

1251: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1252: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1253: RAISE OKC_API.G_EXCEPTION_ERROR;
1254: END IF;
1255: UPDATE OKC_RESOLVED_TIMEVALUES
1256: SET TVE_ID = l_def_rtv_rec.tve_id,
1257: COE_ID = l_def_rtv_rec.coe_id,
1258: DATETIME = l_def_rtv_rec.datetime,
1259: OBJECT_VERSION_NUMBER = l_def_rtv_rec.object_version_number,

Line 1302: -- update_row for:OKC_RESOLVED_TIMEVALUES_V --

1298: '_PVT'
1299: );
1300: END update_row;
1301: ----------------------------------------------
1302: -- update_row for:OKC_RESOLVED_TIMEVALUES_V --
1303: ----------------------------------------------
1304: PROCEDURE update_row(
1305: p_api_version IN NUMBER,
1306: p_init_msg_list IN VARCHAR2,

Line 1393: -- Set_Attributes for:OKC_RESOLVED_TIMEVALUES_V --

1389: END IF;
1390: RETURN(l_return_status);
1391: END populate_new_record;
1392: --------------------------------------------------
1393: -- Set_Attributes for:OKC_RESOLVED_TIMEVALUES_V --
1394: --------------------------------------------------
1395: FUNCTION Set_Attributes (
1396: p_rtvv_rec IN rtvv_rec_type,
1397: x_rtvv_rec OUT NOCOPY rtvv_rec_type

Line 1576: -- delete_row for:OKC_RESOLVED_TIMEVALUES --

1572: ---------------------------------------------------------------------------
1573: -- PROCEDURE delete_row
1574: ---------------------------------------------------------------------------
1575: --------------------------------------------
1576: -- delete_row for:OKC_RESOLVED_TIMEVALUES --
1577: --------------------------------------------
1578: PROCEDURE delete_row(
1579: p_init_msg_list IN VARCHAR2,
1580: x_return_status OUT NOCOPY VARCHAR2,

Line 1600: DELETE FROM OKC_RESOLVED_TIMEVALUES

1596: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1597: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1598: RAISE OKC_API.G_EXCEPTION_ERROR;
1599: END IF;
1600: DELETE FROM OKC_RESOLVED_TIMEVALUES
1601: WHERE ID = l_rtv_rec.id;
1602:
1603: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1604: EXCEPTION

Line 1637: -- delete_row for:OKC_RESOLVED_TIMEVALUES_V --

1633: '_PVT'
1634: );
1635: END delete_row;
1636: ----------------------------------------------
1637: -- delete_row for:OKC_RESOLVED_TIMEVALUES_V --
1638: ----------------------------------------------
1639: PROCEDURE delete_row(
1640: p_api_version IN NUMBER,
1641: p_init_msg_list IN VARCHAR2,

Line 1787: p_view_name => 'OKC_RESOLVED_TIMEVALUES_V');

1783: -----------------------------------------------------------
1784: BEGIN
1785: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1786: OKC_UTIL.ADD_VIEW(x_return_status => g_return_status,
1787: p_view_name => 'OKC_RESOLVED_TIMEVALUES_V');
1788: END OKC_RTV_PVT;