DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PROD_OPTNS_PUB 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_CONTRACT_PROD_OPTNS_PVT.cspv_rec_type;
5: subtype cspv_tbl_type is OKL_CONTRACT_PROD_OPTNS_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_CONTRACT_PROD_OPTNS_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:

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

14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
15:
16: -- Global variables for user hooks
17: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_PROD_OPTNS_PUB';
18: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
19: g_cspv_rec cspv_rec_type;
20: g_cspv_tbl cspv_tbl_type;
21:
22:

Line 25: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

21:
22:
23: PROCEDURE create_contract_option(
24: p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
26: x_return_status OUT NOCOPY VARCHAR2,
27: x_msg_count OUT NOCOPY NUMBER,
28: x_msg_data OUT NOCOPY VARCHAR2,
29: p_cspv_rec IN cspv_rec_type,

Line 34: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

30: x_cspv_rec OUT NOCOPY cspv_rec_type);
31:
32: PROCEDURE create_contract_option(
33: p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_count OUT NOCOPY NUMBER,
37: x_msg_data OUT NOCOPY VARCHAR2,
38: p_cspv_tbl IN cspv_tbl_type,

Line 43: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

39: x_cspv_tbl OUT NOCOPY cspv_tbl_type);
40:
41: PROCEDURE update_contract_option(
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_cspv_rec IN cspv_rec_type,

Line 52: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

48: x_cspv_rec OUT NOCOPY cspv_rec_type);
49:
50: PROCEDURE update_contract_option(
51: p_api_version IN NUMBER,
52: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
53: x_return_status OUT NOCOPY VARCHAR2,
54: x_msg_count OUT NOCOPY NUMBER,
55: x_msg_data OUT NOCOPY VARCHAR2,
56: p_cspv_tbl IN cspv_tbl_type,

Line 61: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

57: x_cspv_tbl OUT NOCOPY cspv_tbl_type);
58:
59: PROCEDURE delete_contract_option(
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2,
65: p_cspv_rec IN cspv_rec_type);

Line 69: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

65: p_cspv_rec IN cspv_rec_type);
66:
67: PROCEDURE delete_contract_option(
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_cspv_tbl IN cspv_tbl_type);

Line 77: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

73: p_cspv_tbl IN cspv_tbl_type);
74:
75: PROCEDURE lock_contract_option(
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
80: x_msg_data OUT NOCOPY VARCHAR2,
81: p_cspv_rec IN cspv_rec_type);

Line 85: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

81: p_cspv_rec IN cspv_rec_type);
82:
83: procedure lock_contract_option(
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_cspv_tbl IN cspv_tbl_type);

Line 93: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

89: p_cspv_tbl IN cspv_tbl_type);
90:
91: PROCEDURE validate_contract_option(
92: p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,
96: x_msg_data OUT NOCOPY VARCHAR2,
97: p_cspv_rec IN cspv_rec_type);

Line 101: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

97: p_cspv_rec IN cspv_rec_type);
98:
99: procedure validate_contract_option(
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_cspv_tbl IN cspv_tbl_type);