DBA Data[Home] [Help]

APPS.OKL_AM_CREATE_QUOTE_PVT dependencies on OKC_API

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

4: ---------------------------------------------------------------------------
5: -- GLOBAL VARIABLES
6: ---------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_CREATE_QUOTE_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
11: G_INVALID_VALUE1 CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE'; -- SECHAWLA 2699412 02-DEC-03 Moved from okl_am_util_pvt
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE; -- SECHAWLA 28-FEB-03 Bug # 2757175 : Added

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

6: ---------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_CREATE_QUOTE_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
11: G_INVALID_VALUE1 CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE'; -- SECHAWLA 2699412 02-DEC-03 Moved from okl_am_util_pvt
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE; -- SECHAWLA 28-FEB-03 Bug # 2757175 : Added
13: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE; -- SECHAWLA 28-FEB-03 Bug # 2757175 : Added

8: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
11: G_INVALID_VALUE1 CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE'; -- SECHAWLA 2699412 02-DEC-03 Moved from okl_am_util_pvt
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE; -- SECHAWLA 28-FEB-03 Bug # 2757175 : Added
13: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16:

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

11: G_INVALID_VALUE1 CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE'; -- SECHAWLA 2699412 02-DEC-03 Moved from okl_am_util_pvt
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE; -- SECHAWLA 28-FEB-03 Bug # 2757175 : Added
13: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16:
17: G_YES CONSTANT VARCHAR2(1) := 'Y';
18: G_NO CONSTANT VARCHAR2(1) := 'N';
19:

Line 32: p_asset_id NUMBER := OKC_API.G_MISS_NUM,

28:
29: G_EMPTY_QPYV_TBL qpyv_tbl_type;
30:
31: TYPE assn_rec_type IS RECORD (
32: p_asset_id NUMBER := OKC_API.G_MISS_NUM,
33: p_asset_number VARCHAR2(200) := OKC_API.G_MISS_CHAR,
34: p_asset_qty NUMBER,
35: p_quote_qty NUMBER,
36: p_split_asset_number OKC_K_LINES_V.name%TYPE := OKC_API.G_MISS_CHAR); -- RMUNJULU 2757312 Added

Line 33: p_asset_number VARCHAR2(200) := OKC_API.G_MISS_CHAR,

29: G_EMPTY_QPYV_TBL qpyv_tbl_type;
30:
31: TYPE assn_rec_type IS RECORD (
32: p_asset_id NUMBER := OKC_API.G_MISS_NUM,
33: p_asset_number VARCHAR2(200) := OKC_API.G_MISS_CHAR,
34: p_asset_qty NUMBER,
35: p_quote_qty NUMBER,
36: p_split_asset_number OKC_K_LINES_V.name%TYPE := OKC_API.G_MISS_CHAR); -- RMUNJULU 2757312 Added
37:

Line 36: p_split_asset_number OKC_K_LINES_V.name%TYPE := OKC_API.G_MISS_CHAR); -- RMUNJULU 2757312 Added

32: p_asset_id NUMBER := OKC_API.G_MISS_NUM,
33: p_asset_number VARCHAR2(200) := OKC_API.G_MISS_CHAR,
34: p_asset_qty NUMBER,
35: p_quote_qty NUMBER,
36: p_split_asset_number OKC_K_LINES_V.name%TYPE := OKC_API.G_MISS_CHAR); -- RMUNJULU 2757312 Added
37:
38: TYPE assn_tbl_type IS TABLE OF assn_rec_type INDEX BY BINARY_INTEGER;
39:
40: -- SECHAWLA 02-JAN-03 2699412 Added the following declarations as part of moving procedure advance_contract_search from

Line 70: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

66:
67: -- To do the advance search for a given contract details.
68: PROCEDURE advance_contract_search(
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: p_achr_rec IN achr_rec_type,

Line 87: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

83: x_return_status OUT NOCOPY VARCHAR2);
84:
85: PROCEDURE create_terminate_quote(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2,
91: p_quot_rec IN quot_rec_type,