DBA Data[Home] [Help]

APPS.OKL_CREATE_KLE_PUB dependencies on OKC_API

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

23: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
24:
25:
26: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
28: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
29: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

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

24:
25:
26: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
28: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
29: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
32: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';

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

25:
26: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
28: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
29: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
32: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
33: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';

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

26: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
28: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
29: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
32: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
33: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
34:

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

33: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
34:
35: -- Global variables for user hooks
36: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CREATE_KLE_PUB';
37: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
38:
39: g_klev_rec klev_rec_type;
40: g_klev_tbl klev_tbl_type;
41: g_clev_rec clev_rec_type;

Line 95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

91: x_klev_rec OUT NOCOPY klev_rec_type);
92:
93: Procedure Create_add_on_line(
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,
99: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

Line 112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

108: x_cimv_tbl OUT NOCOPY cimv_tbl_type);
109:
110: PROCEDURE update_add_on_line(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

Line 129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

125: x_fin_klev_rec OUT NOCOPY klev_rec_type);
126:
127: PROCEDURE delete_add_on_line(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

Line 142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

138: x_fin_klev_rec OUT NOCOPY klev_rec_type);
139:
140: PROCEDURE Create_party_roles_rec(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_cplv_rec IN cplv_rec_type,

Line 151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

147: x_cplv_rec OUT NOCOPY cplv_rec_type);
148:
149: PROCEDURE Update_party_roles_rec(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_cplv_rec IN cplv_rec_type,

Line 160: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

156: x_cplv_rec OUT NOCOPY cplv_rec_type);
157:
158: PROCEDURE Create_all_line(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

Line 180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

176: x_clev_ib_rec OUT NOCOPY clev_rec_type);
177:
178: PROCEDURE Update_all_line(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

Line 202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

198: x_clev_ib_rec OUT NOCOPY clev_rec_type);
199:
200: PROCEDURE create_ints_ib_line(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

Line 221: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

217: x_talv_fa_rec OUT NOCOPY talv_rec_type);
218:
219: PROCEDURE update_ints_ib_line(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

Line 235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

231: x_itiv_ib_tbl OUT NOCOPY itiv_tbl_type);
232:
233: PROCEDURE delete_ints_ib_line(
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2,
239: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,