DBA Data[Home] [Help]

APPS.OKC_OPER_INST_PVT dependencies on OKC_API

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

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

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

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

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

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

Line 17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

13: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
14: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
15: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
16: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
21: G_EXCEPTION_HALT_VALIDATION exception;

Line 18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

14: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
15: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
16: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
21: G_EXCEPTION_HALT_VALIDATION exception;
22: NO_CONTRACT_FOUND exception;

Line 19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

15: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
16: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
21: G_EXCEPTION_HALT_VALIDATION exception;
22: NO_CONTRACT_FOUND exception;
23: G_NO_UPDATE_ALLOWED_EXCEPTION exception;

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

16: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
21: G_EXCEPTION_HALT_VALIDATION exception;
22: NO_CONTRACT_FOUND exception;
23: G_NO_UPDATE_ALLOWED_EXCEPTION exception;
24: G_NO_UPDATE_ALLOWED CONSTANT VARCHAR2(200) := 'OKC_NO_UPDATE_ALLOWED';

Line 41: x_return_status := OKC_API.G_RET_STS_SUCCESS;

37:
38: l_copv_rec OKC_COP_PVT.copv_rec_type := p_copv_rec;
39: BEGIN
40: -- initialize return status
41: x_return_status := OKC_API.G_RET_STS_SUCCESS;
42:
43: OKC_COP_PVT.Insert_Row(
44: p_api_version => p_api_version,
45: p_init_msg_list => p_init_msg_list,

Line 251: x_return_status := OKC_API.G_RET_STS_SUCCESS;

247:
248: l_oiev_rec OKC_OIE_PVT.oiev_rec_type := p_oiev_rec;
249: BEGIN
250: -- initialize return status
251: x_return_status := OKC_API.G_RET_STS_SUCCESS;
252:
253: OKC_OIE_PVT.Insert_Row(
254: p_api_version => p_api_version,
255: p_init_msg_list => p_init_msg_list,

Line 353: x_return_status := OKC_API.G_RET_STS_SUCCESS;

349: SELECT id
350: FROM okc_masschange_req_dtls
351: WHERE oie_id = p_oiev_rec.id;
352: BEGIN
353: x_return_status := OKC_API.G_RET_STS_SUCCESS;
354: --
355: -- Delete all children (operation lines) before deleting instance
356: --
357: FOR ole_rec IN ole_csr

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

374: --
375: -- Delete all children (masschange) before deleting instance
376: --
377:
378: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
379: FOR oie_rec IN ole1_csr
380: LOOP
381: j := j + 1;
382: l_mrdv_tbl(j).ID := oie_rec.ID;

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

395: End if;
396: End If;
397:
398:
399: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
400: OKC_OIE_PVT.Delete_Row(
401: p_api_version => p_api_version,
402: p_init_msg_list => p_init_msg_list,
403: x_return_status => x_return_status,

Line 522: x_return_status := OKC_API.G_RET_STS_SUCCESS;

518:
519: l_olev_rec OKC_OLE_PVT.olev_rec_type := p_olev_rec;
520: BEGIN
521: -- initialize return status
522: x_return_status := OKC_API.G_RET_STS_SUCCESS;
523:
524: OKC_OLE_PVT.Insert_Row(
525: p_api_version => p_api_version,
526: p_init_msg_list => p_init_msg_list,

Line 643: x_return_status := OKC_API.G_RET_STS_SUCCESS;

639: WHERE id = ole_rec.object_chr_id;
640: End If;
641: END LOOP;
642:
643: x_return_status := OKC_API.G_RET_STS_SUCCESS;
644:
645: --
646: -- Delete all children (masschange) before deleting operation line
647: --

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

663: x_msg_data => x_msg_data,
664: p_mrdv_tbl => l_mrdv_tbl);
665: End if;
666:
667: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
668:
669: OKC_OLE_PVT.Delete_Row(
670: p_api_version => p_api_version,
671: p_init_msg_list => p_init_msg_list,

Line 791: x_return_status := OKC_API.G_RET_STS_SUCCESS;

787:
788: l_mrdv_rec OKC_MRD_PVT.mrdv_rec_type := p_mrdv_rec;
789: BEGIN
790: -- initialize return status
791: x_return_status := OKC_API.G_RET_STS_SUCCESS;
792:
793: OKC_MRD_PVT.Insert_Row(
794: p_api_version => p_api_version,
795: p_init_msg_list => p_init_msg_list,