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_SECTIONS_PVT dependencies on OKC_API

Line 9: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

5:
6: ---------------------------------------------------------------------------
7: -- GLOBAL VARIABLES
8: ---------------------------------------------------------------------------
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

8: ---------------------------------------------------------------------------
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

9: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
17: G_EXCEPTION_HALT_VALIDATION exception;

Line 16: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
17: G_EXCEPTION_HALT_VALIDATION exception;
18: NO_CONTRACT_FOUND exception;
19: G_NO_UPDATE_ALLOWED_EXCEPTION exception;
20: G_NO_UPDATE_ALLOWED CONSTANT VARCHAR2(200) := 'OKC_NO_UPDATE_ALLOWED';

Line 35: x_return_status := OKC_API.G_RET_STS_SUCCESS;

31: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
32: BEGIN
33:
34: -- initialize return status
35: x_return_status := OKC_API.G_RET_STS_SUCCESS;
36:
37: -- assign/populate contract header id
38: l_cvmv_rec.chr_id := p_chr_id;
39:

Line 55: x_return_status := OKC_API.G_RET_STS_ERROR;

51: return (x_return_status);
52: EXCEPTION
53: when OTHERS then
54: -- notify caller of an error
55: x_return_status := OKC_API.G_RET_STS_ERROR;
56:
57: -- store SQL error message on message stack
58: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
59: p_msg_name => g_unexpected_error,

Line 58: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

54: -- notify caller of an error
55: x_return_status := OKC_API.G_RET_STS_ERROR;
56:
57: -- store SQL error message on message stack
58: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
59: p_msg_name => g_unexpected_error,
60: p_token1 => g_sqlcode_token,
61: p_token1_value => sqlcode,
62: p_token2 => g_sqlerrm_token,

Line 79: x_return_status := OKC_API.G_RET_STS_SUCCESS;

75:
76: l_scnv_rec OKC_SCN_PVT.scnv_rec_type := p_scnv_rec;
77: BEGIN
78: -- initialize return status
79: x_return_status := OKC_API.G_RET_STS_SUCCESS;
80:
81: OKC_SCN_PVT.Insert_Row(
82: p_api_version => p_api_version,
83: p_init_msg_list => p_init_msg_list,

Line 91: If (x_return_status = OKC_API.G_RET_STS_SUCCESS AND

87: p_scnv_rec => l_scnv_rec,
88: x_scnv_rec => x_scnv_rec);
89:
90: -- Update minor version
91: If (x_return_status = OKC_API.G_RET_STS_SUCCESS AND
92: p_scnv_rec.chr_id > 0)
93: Then
94: x_return_status := Update_Minor_Version(p_scnv_rec.chr_id);
95: End If;

Line 140: If (x_return_status = OKC_API.G_RET_STS_SUCCESS AND

136: p_scnv_rec => p_scnv_rec,
137: x_scnv_rec => x_scnv_rec);
138:
139: -- Update minor version
140: If (x_return_status = OKC_API.G_RET_STS_SUCCESS AND
141: p_scnv_rec.chr_id > 0)
142: Then
143: x_return_status := Update_Minor_Version(p_scnv_rec.chr_id);
144: End If;

Line 148: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

144: End If;
145: exception
146: when OTHERS then
147: -- store SQL error message on message stack
148: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
149: p_msg_name => g_unexpected_error,
150: p_token1 => g_sqlcode_token,
151: p_token1_value => sqlcode,
152: p_token2 => g_sqlerrm_token,

Line 156: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

152: p_token2 => g_sqlerrm_token,
153: p_token2_value => sqlerrm);
154:
155: -- notify caller of an UNEXPETED error
156: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
157: END update_section;
158:
159: PROCEDURE update_section(
160: p_api_version IN NUMBER,

Line 207: If (x_return_status = OKC_API.G_RET_STS_SUCCESS AND

203: x_msg_data => x_msg_data,
204: p_scnv_rec => p_scnv_rec);
205:
206: -- Update minor version
207: If (x_return_status = OKC_API.G_RET_STS_SUCCESS AND
208: l_chr_id > 0)
209: Then
210: x_return_status := Update_Minor_Version(l_chr_id);
211: End If;

Line 216: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

212:
213: exception
214: when OTHERS then
215: -- store SQL error message on message stack
216: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
217: p_msg_name => g_unexpected_error,
218: p_token1 => g_sqlcode_token,
219: p_token1_value => sqlcode,
220: p_token2 => g_sqlerrm_token,

Line 224: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

220: p_token2 => g_sqlerrm_token,
221: p_token2_value => sqlerrm);
222:
223: -- notify caller of an UNEXPETED error
224: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
225: END delete_section;
226:
227: PROCEDURE delete_section(
228: p_api_version IN NUMBER,

Line 347: x_return_status := OKC_API.G_RET_STS_SUCCESS;

343: l_sccv_rec OKC_SCC_PVT.sccv_rec_type := p_sccv_rec;
344: l_chr_id NUMBER;
345: BEGIN
346: -- initialize return status
347: x_return_status := OKC_API.G_RET_STS_SUCCESS;
348:
349: OKC_SCC_PVT.Insert_Row(
350: p_api_version => p_api_version,
351: p_init_msg_list => p_init_msg_list,

Line 360: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then

356: x_sccv_rec => x_sccv_rec);
357:
358:
359: -- Update minor version
360: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
361: l_chr_id := Get_CHR_ID_For_Section(p_sccv_rec.SCN_ID);
362: If (l_chr_id > 0) Then
363: x_return_status := Update_Minor_Version(l_chr_id);
364: End If;

Line 410: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then

406: p_sccv_rec => p_sccv_rec,
407: x_sccv_rec => x_sccv_rec);
408:
409: -- Update minor version
410: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
411: l_chr_id := Get_CHR_ID_For_Section(p_sccv_rec.SCN_ID);
412: If (l_chr_id > 0) Then
413: x_return_status := Update_Minor_Version(l_chr_id);
414: End If;

Line 419: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

415: End If;
416: exception
417: when OTHERS then
418: -- store SQL error message on message stack
419: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
420: p_msg_name => g_unexpected_error,
421: p_token1 => g_sqlcode_token,
422: p_token1_value => sqlcode,
423: p_token2 => g_sqlerrm_token,

Line 427: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

423: p_token2 => g_sqlerrm_token,
424: p_token2_value => sqlerrm);
425:
426: -- notify caller of an UNEXPETED error
427: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
428: END update_section_content;
429:
430: PROCEDURE update_section_content(
431: p_api_version IN NUMBER,

Line 470: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then

466: x_msg_data => x_msg_data,
467: p_sccv_rec => p_sccv_rec);
468:
469: -- Update minor version
470: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
471: l_chr_id := Get_CHR_ID_For_Section(p_sccv_rec.SCN_ID);
472: If (l_chr_id > 0) Then
473: x_return_status := Update_Minor_Version(l_chr_id);
474: End If;

Line 479: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

475: End If;
476: exception
477: when OTHERS then
478: -- store SQL error message on message stack
479: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
480: p_msg_name => g_unexpected_error,
481: p_token1 => g_sqlcode_token,
482: p_token1_value => sqlcode,
483: p_token2 => g_sqlerrm_token,

Line 487: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

483: p_token2 => g_sqlerrm_token,
484: p_token2_value => sqlerrm);
485:
486: -- notify caller of an UNEXPETED error
487: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
488: END delete_section_content;
489:
490: PROCEDURE delete_section_content(
491: p_api_version IN NUMBER,