DBA Data[Home] [Help]

APPS.OKL_FE_EO_TERM_OPTIONS_PUB dependencies on OKL_API

Line 40: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;

36: SUBTYPE okl_eto_tbl IS okl_eto_pvt.okl_eto_tbl;
37:
38: SUBTYPE invalid_object_tbl IS okl_fe_eo_term_options_pvt.invalid_object_tbl; -- Global variables
39: g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_FE_EO_TERM_OPTIONS_PUB';
40: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
41:
42: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
43:
44: g_exc_name_error CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';

Line 44: g_exc_name_error CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';

40: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
41:
42: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
43:
44: g_exc_name_error CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
45: g_exc_name_unexp_error CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
46: g_exc_name_others CONSTANT VARCHAR2(6) := 'OTHERS';
47: g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
48: g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';

Line 45: g_exc_name_unexp_error CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';

41:
42: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
43:
44: g_exc_name_error CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
45: g_exc_name_unexp_error CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
46: g_exc_name_others CONSTANT VARCHAR2(6) := 'OTHERS';
47: g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
48: g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
49:

Line 57: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

53:
54: g_exception_halt_validation EXCEPTION;
55:
56: PROCEDURE get_item_lines(p_api_version IN NUMBER
57: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_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_po_id IN NUMBER

Line 66: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

62: ,p_po_version IN VARCHAR2
63: ,x_eto_tbl OUT NOCOPY okl_eto_tbl);
64:
65: PROCEDURE get_eo_term_values(p_api_version IN NUMBER
66: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
67: ,x_return_status OUT NOCOPY VARCHAR2
68: ,x_msg_count OUT NOCOPY NUMBER
69: ,x_msg_data OUT NOCOPY VARCHAR2
70: ,p_po_id IN NUMBER

Line 75: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

71: ,p_po_version IN VARCHAR2
72: ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
73:
74: PROCEDURE get_end_of_term_option(p_api_version IN NUMBER
75: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
76: ,x_return_status OUT NOCOPY VARCHAR2
77: ,x_msg_count OUT NOCOPY NUMBER
78: ,x_msg_data OUT NOCOPY VARCHAR2
79: ,p_po_id IN NUMBER

Line 107: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

103: * @rep:lifecycle active
104: * @rep:category BUSINESS_ENTITY OKL_MARKETING_PROGRAM
105: */
106: PROCEDURE insert_end_of_term_option(p_api_version IN NUMBER
107: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
108: ,x_return_status OUT NOCOPY VARCHAR2
109: ,x_msg_count OUT NOCOPY NUMBER
110: ,x_msg_data OUT NOCOPY VARCHAR2
111: ,p_ethv_rec IN okl_ethv_rec

Line 121: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

117: ,x_eto_tbl OUT NOCOPY okl_eto_tbl
118: ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
119:
120: PROCEDURE update_end_of_term_option(p_api_version IN NUMBER
121: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
122: ,x_return_status OUT NOCOPY VARCHAR2
123: ,x_msg_count OUT NOCOPY NUMBER
124: ,x_msg_data OUT NOCOPY VARCHAR2
125: ,p_eve_rec IN okl_eve_rec

Line 133: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

129: ,x_eto_tbl OUT NOCOPY okl_eto_tbl
130: ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
131:
132: PROCEDURE create_version(p_api_version IN NUMBER
133: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
134: ,x_return_status OUT NOCOPY VARCHAR2
135: ,x_msg_count OUT NOCOPY NUMBER
136: ,x_msg_data OUT NOCOPY VARCHAR2
137: ,p_eve_rec IN okl_eve_rec

Line 145: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

141: ,x_eto_tbl OUT NOCOPY okl_eto_tbl
142: ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
143:
144: PROCEDURE validate_end_of_term_option(p_api_version IN NUMBER
145: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
146: ,x_return_status OUT NOCOPY VARCHAR2
147: ,x_msg_count OUT NOCOPY NUMBER
148: ,x_msg_data OUT NOCOPY VARCHAR2
149: ,p_end_of_ver_id IN NUMBER);

Line 152: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

148: ,x_msg_data OUT NOCOPY VARCHAR2
149: ,p_end_of_ver_id IN NUMBER);
150:
151: PROCEDURE handle_approval(p_api_version IN NUMBER
152: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
153: ,x_return_status OUT NOCOPY VARCHAR2
154: ,x_msg_count OUT NOCOPY NUMBER
155: ,x_msg_data OUT NOCOPY VARCHAR2
156: ,p_end_of_term_ver_id IN NUMBER);

Line 161: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

157:
158: -- to find the list of all the invalid object refernces
159:
160: PROCEDURE invalid_objects(p_api_version IN NUMBER
161: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
162: ,x_return_status OUT NOCOPY VARCHAR2
163: ,x_msg_count OUT NOCOPY NUMBER
164: ,x_msg_data OUT NOCOPY VARCHAR2
165: ,p_version_id IN NUMBER

Line 171: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

167:
168: -- to calculate the start date of the new version
169:
170: PROCEDURE calc_start_date(p_api_version IN NUMBER
171: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
172: ,x_return_status OUT NOCOPY VARCHAR2
173: ,x_msg_count OUT NOCOPY NUMBER
174: ,x_msg_data OUT NOCOPY VARCHAR2
175: ,p_eve_rec IN okl_eve_rec

Line 179: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

175: ,p_eve_rec IN okl_eve_rec
176: ,x_cal_eff_from OUT NOCOPY DATE);
177:
178: PROCEDURE submit_end_of_term(p_api_version IN NUMBER
179: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
180: ,x_return_status OUT NOCOPY VARCHAR2
181: ,x_msg_count OUT NOCOPY NUMBER
182: ,x_msg_data OUT NOCOPY VARCHAR2
183: ,p_end_of_term_ver_id IN NUMBER);