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.OKS_INTERACTION_HIST_PVT dependencies on OKS_INTERACTION_HISTORY

Line 179: -- FUNCTION get_rec for: OKS_INTERACTION_HISTORY

175: BEGIN
176: RETURN(get_rec(p_inhv_rec, l_row_not_found));
177: END get_rec;
178: ---------------------------------------------------------------------------
179: -- FUNCTION get_rec for: OKS_INTERACTION_HISTORY
180: ---------------------------------------------------------------------------
181: FUNCTION get_rec (
182: p_inh_rec IN inh_rec_type,
183: x_no_data_found OUT NOCOPY BOOLEAN

Line 185: CURSOR oks_interaction_history_pk_csr (p_id IN NUMBER) IS

181: FUNCTION get_rec (
182: p_inh_rec IN inh_rec_type,
183: x_no_data_found OUT NOCOPY BOOLEAN
184: ) RETURN inh_rec_type IS
185: CURSOR oks_interaction_history_pk_csr (p_id IN NUMBER) IS
186: SELECT
187: ID,
188: CHR_ID,
189: CONTRACT_NUMBER,

Line 204: FROM Oks_Interaction_History

200: LAST_UPDATE_DATE,
201: LAST_UPDATED_BY,
202: LAST_UPDATE_LOGIN,
203: OBJECT_VERSION_NUMBER
204: FROM Oks_Interaction_History
205: WHERE oks_interaction_history.id = p_id;
206: l_oks_interaction_history_pk oks_interaction_history_pk_csr%ROWTYPE;
207: l_inh_rec inh_rec_type;
208: BEGIN

Line 205: WHERE oks_interaction_history.id = p_id;

201: LAST_UPDATED_BY,
202: LAST_UPDATE_LOGIN,
203: OBJECT_VERSION_NUMBER
204: FROM Oks_Interaction_History
205: WHERE oks_interaction_history.id = p_id;
206: l_oks_interaction_history_pk oks_interaction_history_pk_csr%ROWTYPE;
207: l_inh_rec inh_rec_type;
208: BEGIN
209: x_no_data_found := TRUE;

Line 206: l_oks_interaction_history_pk oks_interaction_history_pk_csr%ROWTYPE;

202: LAST_UPDATE_LOGIN,
203: OBJECT_VERSION_NUMBER
204: FROM Oks_Interaction_History
205: WHERE oks_interaction_history.id = p_id;
206: l_oks_interaction_history_pk oks_interaction_history_pk_csr%ROWTYPE;
207: l_inh_rec inh_rec_type;
208: BEGIN
209: x_no_data_found := TRUE;
210: -- Get current database values

Line 211: OPEN oks_interaction_history_pk_csr (p_inh_rec.id);

207: l_inh_rec inh_rec_type;
208: BEGIN
209: x_no_data_found := TRUE;
210: -- Get current database values
211: OPEN oks_interaction_history_pk_csr (p_inh_rec.id);
212: FETCH oks_interaction_history_pk_csr INTO
213: l_inh_rec.id,
214: l_inh_rec.chr_id,
215: l_inh_rec.contract_number,

Line 212: FETCH oks_interaction_history_pk_csr INTO

208: BEGIN
209: x_no_data_found := TRUE;
210: -- Get current database values
211: OPEN oks_interaction_history_pk_csr (p_inh_rec.id);
212: FETCH oks_interaction_history_pk_csr INTO
213: l_inh_rec.id,
214: l_inh_rec.chr_id,
215: l_inh_rec.contract_number,
216: l_inh_rec.contract_number_modifier,

Line 230: x_no_data_found := oks_interaction_history_pk_csr%NOTFOUND;

226: l_inh_rec.last_update_date,
227: l_inh_rec.last_updated_by,
228: l_inh_rec.last_update_login,
229: l_inh_rec.object_version_number;
230: x_no_data_found := oks_interaction_history_pk_csr%NOTFOUND;
231: CLOSE oks_interaction_history_pk_csr;
232: RETURN(l_inh_rec);
233: END get_rec;
234:

Line 231: CLOSE oks_interaction_history_pk_csr;

227: l_inh_rec.last_updated_by,
228: l_inh_rec.last_update_login,
229: l_inh_rec.object_version_number;
230: x_no_data_found := oks_interaction_history_pk_csr%NOTFOUND;
231: CLOSE oks_interaction_history_pk_csr;
232: RETURN(l_inh_rec);
233: END get_rec;
234:
235: ------------------------------------------------------------------

Line 705: -- insert_row for:OKS_INTERACTION_HISTORY --

701: ---------------------------------------------------------------------------
702: -- PROCEDURE insert_row
703: ---------------------------------------------------------------------------
704: --------------------------------------------
705: -- insert_row for:OKS_INTERACTION_HISTORY --
706: --------------------------------------------
707: PROCEDURE insert_row(
708: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
709: x_return_status OUT NOCOPY VARCHAR2,

Line 721: -- Set_Attributes for:OKS_INTERACTION_HISTORY --

717: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
718: l_inh_rec inh_rec_type := p_inh_rec;
719: l_def_inh_rec inh_rec_type;
720: ------------------------------------------------
721: -- Set_Attributes for:OKS_INTERACTION_HISTORY --
722: ------------------------------------------------
723: FUNCTION Set_Attributes (
724: p_inh_rec IN inh_rec_type,
725: x_inh_rec OUT NOCOPY inh_rec_type

Line 752: INSERT INTO OKS_INTERACTION_HISTORY(

748: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
749: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
750: RAISE OKC_API.G_EXCEPTION_ERROR;
751: END IF;
752: INSERT INTO OKS_INTERACTION_HISTORY(
753: id,
754: chr_id,
755: contract_number,
756: contract_number_modifier,

Line 1135: -- lock_row for:OKS_INTERACTION_HISTORY --

1131: ---------------------------------------------------------------------------
1132: -- PROCEDURE lock_row
1133: ---------------------------------------------------------------------------
1134: ------------------------------------------
1135: -- lock_row for:OKS_INTERACTION_HISTORY --
1136: ------------------------------------------
1137: PROCEDURE lock_row(
1138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1139: x_return_status OUT NOCOPY VARCHAR2,

Line 1148: FROM OKS_INTERACTION_HISTORY

1144: E_Resource_Busy EXCEPTION;
1145: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1146: CURSOR lock_csr (p_inh_rec IN inh_rec_type) IS
1147: SELECT OBJECT_VERSION_NUMBER
1148: FROM OKS_INTERACTION_HISTORY
1149: WHERE ID = p_inh_rec.id
1150: AND OBJECT_VERSION_NUMBER = p_inh_rec.object_version_number
1151: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1152:

Line 1155: FROM OKS_INTERACTION_HISTORY

1151: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1152:
1153: CURSOR lchk_csr (p_inh_rec IN inh_rec_type) IS
1154: SELECT OBJECT_VERSION_NUMBER
1155: FROM OKS_INTERACTION_HISTORY
1156: WHERE ID = p_inh_rec.id;
1157: l_api_version CONSTANT NUMBER := 1;
1158: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1159: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1160: l_object_version_number OKS_INTERACTION_HISTORY.OBJECT_VERSION_NUMBER%TYPE;

1156: WHERE ID = p_inh_rec.id;
1157: l_api_version CONSTANT NUMBER := 1;
1158: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1159: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1160: l_object_version_number OKS_INTERACTION_HISTORY.OBJECT_VERSION_NUMBER%TYPE;
1161: lc_object_version_number OKS_INTERACTION_HISTORY.OBJECT_VERSION_NUMBER%TYPE;
1162: l_row_notfound BOOLEAN := FALSE;
1163: lc_row_notfound BOOLEAN := FALSE;
1164: BEGIN

Line 1161: lc_object_version_number OKS_INTERACTION_HISTORY.OBJECT_VERSION_NUMBER%TYPE;

1157: l_api_version CONSTANT NUMBER := 1;
1158: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1159: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1160: l_object_version_number OKS_INTERACTION_HISTORY.OBJECT_VERSION_NUMBER%TYPE;
1161: lc_object_version_number OKS_INTERACTION_HISTORY.OBJECT_VERSION_NUMBER%TYPE;
1162: l_row_notfound BOOLEAN := FALSE;
1163: lc_row_notfound BOOLEAN := FALSE;
1164: BEGIN
1165: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1482: -- update_row for:OKS_INTERACTION_HISTORY --

1478: ---------------------------------------------------------------------------
1479: -- PROCEDURE update_row
1480: ---------------------------------------------------------------------------
1481: --------------------------------------------
1482: -- update_row for:OKS_INTERACTION_HISTORY --
1483: --------------------------------------------
1484: PROCEDURE update_row(
1485: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1486: x_return_status OUT NOCOPY VARCHAR2,

Line 1585: -- Set_Attributes for:OKS_INTERACTION_HISTORY --

1581: END IF;
1582: RETURN(l_return_status);
1583: END populate_new_record;
1584: ------------------------------------------------
1585: -- Set_Attributes for:OKS_INTERACTION_HISTORY --
1586: ------------------------------------------------
1587: FUNCTION Set_Attributes (
1588: p_inh_rec IN inh_rec_type,
1589: x_inh_rec OUT NOCOPY inh_rec_type

Line 1623: UPDATE OKS_INTERACTION_HISTORY

1619: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1620: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1621: RAISE OKC_API.G_EXCEPTION_ERROR;
1622: END IF;
1623: UPDATE OKS_INTERACTION_HISTORY
1624: SET CHR_ID = l_def_inh_rec.chr_id,
1625: CONTRACT_NUMBER = l_def_inh_rec.contract_number,
1626: CONTRACT_NUMBER_MODIFIER = l_def_inh_rec.contract_number_modifier,
1627: RENEWAL_STATUS = l_def_inh_rec.renewal_status,

Line 2086: -- delete_row for:OKS_INTERACTION_HISTORY --

2082: ---------------------------------------------------------------------------
2083: -- PROCEDURE delete_row
2084: ---------------------------------------------------------------------------
2085: --------------------------------------------
2086: -- delete_row for:OKS_INTERACTION_HISTORY --
2087: --------------------------------------------
2088: PROCEDURE delete_row(
2089: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2090: x_return_status OUT NOCOPY VARCHAR2,

Line 2111: DELETE FROM OKS_INTERACTION_HISTORY

2107: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2108: RAISE OKC_API.G_EXCEPTION_ERROR;
2109: END IF;
2110:
2111: DELETE FROM OKS_INTERACTION_HISTORY
2112: WHERE ID = p_inh_rec.id;
2113:
2114: x_return_status := l_return_status;
2115: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);