DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_API

Line 8: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

4: ---------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS
6: ---------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_LEASE_TRMNT_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10:
11: -- RMUNJULU 05-MAR-03 Fixed msg constant
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
14: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15:
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
19: G_YES CONSTANT VARCHAR2(1) := 'Y';
20: G_NO CONSTANT VARCHAR2(1) := 'N';

Line 17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
14: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15:
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
19: G_YES CONSTANT VARCHAR2(1) := 'Y';
20: G_NO CONSTANT VARCHAR2(1) := 'N';
21:

Line 18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

14: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15:
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
18: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
19: G_YES CONSTANT VARCHAR2(1) := 'Y';
20: G_NO CONSTANT VARCHAR2(1) := 'N';
21:
22: -- RMUNJULU 05-MAR-03 added constant

Line 43: p_kle_id NUMBER := OKL_API.G_MISS_NUM,

39: SUBTYPE clev_tbl_type IS OKC_CONTRACT_PUB.clev_tbl_type;
40:
41:
42: TYPE klev_rec_type IS RECORD (
43: p_kle_id NUMBER := OKL_API.G_MISS_NUM,
44: p_asset_name VARCHAR2(2000) := OKL_API.G_MISS_CHAR);
45:
46: TYPE klev_tbl_type IS TABLE OF klev_rec_type INDEX BY BINARY_INTEGER;
47:

Line 44: p_asset_name VARCHAR2(2000) := OKL_API.G_MISS_CHAR);

40:
41:
42: TYPE klev_rec_type IS RECORD (
43: p_kle_id NUMBER := OKL_API.G_MISS_NUM,
44: p_asset_name VARCHAR2(2000) := OKL_API.G_MISS_CHAR);
45:
46: TYPE klev_tbl_type IS TABLE OF klev_rec_type INDEX BY BINARY_INTEGER;
47:
48: empty_klev_tbl klev_tbl_type;

Line 73: p_return_status IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,

69: p_return_status IN VARCHAR2,
70: px_overall_status IN OUT NOCOPY VARCHAR2);
71:
72: PROCEDURE set_transaction_rec(
73: p_return_status IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
74: p_overall_status IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
75: p_tmt_flag IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
76: p_tsu_code IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
77: p_ret_val IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,

Line 74: p_overall_status IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,

70: px_overall_status IN OUT NOCOPY VARCHAR2);
71:
72: PROCEDURE set_transaction_rec(
73: p_return_status IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
74: p_overall_status IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
75: p_tmt_flag IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
76: p_tsu_code IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
77: p_ret_val IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
78: px_tcnv_rec IN OUT NOCOPY tcnv_rec_type);

Line 75: p_tmt_flag IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,

71:
72: PROCEDURE set_transaction_rec(
73: p_return_status IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
74: p_overall_status IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
75: p_tmt_flag IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
76: p_tsu_code IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
77: p_ret_val IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
78: px_tcnv_rec IN OUT NOCOPY tcnv_rec_type);
79:

Line 76: p_tsu_code IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,

72: PROCEDURE set_transaction_rec(
73: p_return_status IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
74: p_overall_status IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
75: p_tmt_flag IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
76: p_tsu_code IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
77: p_ret_val IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
78: px_tcnv_rec IN OUT NOCOPY tcnv_rec_type);
79:
80: PROCEDURE initialize_transaction (

Line 77: p_ret_val IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,

73: p_return_status IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
74: p_overall_status IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
75: p_tmt_flag IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
76: p_tsu_code IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
77: p_ret_val IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
78: px_tcnv_rec IN OUT NOCOPY tcnv_rec_type);
79:
80: PROCEDURE initialize_transaction (
81: px_tcnv_rec IN OUT NOCOPY tcnv_rec_type,

Line 92: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

88: x_msg_data OUT NOCOPY VARCHAR2);
89: -- akrangan bug 5354501 fix end
90: PROCEDURE validate_lease(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_sys_date IN DATE,

Line 170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

166: p_trn_already_set IN VARCHAR2);
167:
168: PROCEDURE process_transaction(
169: p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

Line 174: p_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
175: p_term_rec IN term_rec_type,
176: p_tcnv_rec IN tcnv_rec_type,
177: x_id OUT NOCOPY NUMBER,
178: p_trn_mode IN VARCHAR2);

Line 182: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

178: p_trn_mode IN VARCHAR2);
179:
180: PROCEDURE process_amortize_and_return(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_term_rec IN term_rec_type,

Line 211: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

207: p_sys_date IN DATE);
208:
209: PROCEDURE lease_termination(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_term_rec IN term_rec_type,