DBA Data[Home] [Help]

APPS.OKL_FE_EO_TERM_OPTIONS_PVT dependencies on OKL_API

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

36: INDEX BY BINARY_INTEGER;
37:
38: SUBTYPE okl_lrs_id_tbl IS okl_lease_rate_Sets_pvt.okl_number_table; -- Global variables
39: g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_FE_EO_TERM_OPTIONS_PVT';
40: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
41: g_unexpected_error CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
42: g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
43: g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
44:

Line 52: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

48:
49: g_exception_halt_validation EXCEPTION;
50:
51: PROCEDURE get_item_lines(p_api_version IN NUMBER
52: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_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_end_of_term_id IN NUMBER

Line 63: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

59:
60: -- Get the values of the Purchase Options
61:
62: PROCEDURE get_eo_term_values(p_api_version IN NUMBER
63: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
64: ,x_return_status OUT NOCOPY VARCHAR2
65: ,x_msg_count OUT NOCOPY NUMBER
66: ,x_msg_data OUT NOCOPY VARCHAR2
67: ,p_end_of_term_id IN NUMBER

Line 74: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

70:
71: -- Get the Purchase Option Header, Version, values and Values
72:
73: PROCEDURE get_end_of_term_option(p_api_version IN NUMBER
74: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
75: ,x_return_status OUT NOCOPY VARCHAR2
76: ,x_msg_count OUT NOCOPY NUMBER
77: ,x_msg_data OUT NOCOPY VARCHAR2
78: ,p_eot_id IN NUMBER

Line 86: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

82: ,x_eto_tbl OUT NOCOPY okl_eto_tbl
83: ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
84:
85: PROCEDURE insert_end_of_term_option(p_api_version IN NUMBER
86: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
87: ,x_return_status OUT NOCOPY VARCHAR2
88: ,x_msg_count OUT NOCOPY NUMBER
89: ,x_msg_data OUT NOCOPY VARCHAR2
90: ,p_ethv_rec IN okl_ethv_rec

Line 100: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

96: ,x_eto_tbl OUT NOCOPY okl_eto_tbl
97: ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
98:
99: PROCEDURE update_end_of_term_option(p_api_version IN NUMBER
100: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
101: ,x_return_status OUT NOCOPY VARCHAR2
102: ,x_msg_count OUT NOCOPY NUMBER
103: ,x_msg_data OUT NOCOPY VARCHAR2
104: ,p_eve_rec IN okl_eve_rec

Line 112: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

108: ,x_eto_tbl OUT NOCOPY okl_eto_tbl
109: ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
110:
111: PROCEDURE create_version(p_api_version IN NUMBER
112: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
113: ,x_return_status OUT NOCOPY VARCHAR2
114: ,x_msg_count OUT NOCOPY NUMBER
115: ,x_msg_data OUT NOCOPY VARCHAR2
116: ,p_eve_rec IN okl_eve_rec

Line 124: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

120: ,x_eto_tbl OUT NOCOPY okl_eto_tbl
121: ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
122:
123: PROCEDURE validate_end_of_term_option(p_api_version IN NUMBER
124: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
125: ,x_return_status OUT NOCOPY VARCHAR2
126: ,x_msg_count OUT NOCOPY NUMBER
127: ,x_msg_data OUT NOCOPY VARCHAR2
128: ,p_end_of_ver_id IN NUMBER);

Line 131: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

127: ,x_msg_data OUT NOCOPY VARCHAR2
128: ,p_end_of_ver_id IN NUMBER);
129:
130: PROCEDURE handle_approval(p_api_version IN NUMBER
131: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
132: ,x_return_status OUT NOCOPY VARCHAR2
133: ,x_msg_count OUT NOCOPY NUMBER
134: ,x_msg_data OUT NOCOPY VARCHAR2
135: ,p_end_of_term_ver_id IN NUMBER);

Line 140: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

136:
137: -- to find the list of all the invalid object refernces
138:
139: PROCEDURE invalid_objects(p_api_version IN NUMBER
140: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
141: ,x_return_status OUT NOCOPY VARCHAR2
142: ,x_msg_count OUT NOCOPY NUMBER
143: ,x_msg_data OUT NOCOPY VARCHAR2
144: ,p_version_id IN NUMBER

Line 150: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

146:
147: -- to calculate the start date of the new version
148:
149: PROCEDURE calculate_start_date(p_api_version IN NUMBER
150: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
151: ,x_return_status OUT NOCOPY VARCHAR2
152: ,x_msg_count OUT NOCOPY NUMBER
153: ,x_msg_data OUT NOCOPY VARCHAR2
154: ,p_eve_rec IN okl_eve_rec

Line 158: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

154: ,p_eve_rec IN okl_eve_rec
155: ,x_cal_eff_from OUT NOCOPY DATE);
156:
157: PROCEDURE submit_end_of_term(p_api_version IN NUMBER
158: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
159: ,x_return_status OUT NOCOPY VARCHAR2
160: ,x_msg_count OUT NOCOPY NUMBER
161: ,x_msg_data OUT NOCOPY VARCHAR2
162: ,p_end_of_term_ver_id IN NUMBER);