DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PROD_OPTNS_PVT dependencies on OKC_API

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

4: subtype cspv_rec_type is okl_csp_pvt.cspv_rec_type;
5: subtype cspv_tbl_type is okl_csp_pvt.cspv_tbl_type;
6:
7: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
8: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
9: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
10: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
11: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
12: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

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

5: subtype cspv_tbl_type is okl_csp_pvt.cspv_tbl_type;
6:
7: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
8: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
9: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
10: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
11: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
12: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';

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

6:
7: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
8: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
9: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
10: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
11: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
12: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';

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

7: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
8: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
9: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
10: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
11: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
12: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
15: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_PROD_OPTNS_PVT';

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

12: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
15: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_PROD_OPTNS_PVT';
16: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
17: ----------------------------------------------------------------------------------------------------
18: PROCEDURE create_contract_option(
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 20: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

16: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
17: ----------------------------------------------------------------------------------------------------
18: PROCEDURE create_contract_option(
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
23: x_msg_data OUT NOCOPY VARCHAR2,
24: p_cspv_rec IN cspv_rec_type,

Line 29: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

25: x_cspv_rec OUT NOCOPY cspv_rec_type);
26:
27: PROCEDURE create_contract_option(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2,
33: p_cspv_tbl IN cspv_tbl_type,

Line 39: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

35:
36:
37: PROCEDURE update_contract_option(
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40: x_return_status OUT NOCOPY VARCHAR2,
41: x_msg_count OUT NOCOPY NUMBER,
42: x_msg_data OUT NOCOPY VARCHAR2,
43: p_cspv_rec IN cspv_rec_type,

Line 48: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

44: x_cspv_rec OUT NOCOPY cspv_rec_type);
45:
46: PROCEDURE update_contract_option(
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,
51: x_msg_data OUT NOCOPY VARCHAR2,
52: p_cspv_tbl IN cspv_tbl_type,

Line 57: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

53: x_cspv_tbl OUT NOCOPY cspv_tbl_type);
54:
55: PROCEDURE delete_contract_option(
56: p_api_version IN NUMBER,
57: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,
61: p_cspv_rec IN cspv_rec_type);

Line 65: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

61: p_cspv_rec IN cspv_rec_type);
62:
63: PROCEDURE delete_contract_option(
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_cspv_tbl IN cspv_tbl_type);

Line 73: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

69: p_cspv_tbl IN cspv_tbl_type);
70:
71: PROCEDURE lock_contract_option(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2,
77: p_cspv_rec IN cspv_rec_type);

Line 81: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

77: p_cspv_rec IN cspv_rec_type);
78:
79: procedure lock_contract_option(
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,
85: p_cspv_tbl IN cspv_tbl_type);

Line 89: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

85: p_cspv_tbl IN cspv_tbl_type);
86:
87: PROCEDURE validate_contract_option(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_cspv_rec IN cspv_rec_type);

Line 97: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

93: p_cspv_rec IN cspv_rec_type);
94:
95: procedure validate_contract_option(
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_cspv_tbl IN cspv_tbl_type);