102: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
103: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :=
104: 'OKL_CONTRACTS_UNEXPECTED_ERROR';
105:
106: G_OKC_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
107: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
110: --akrangan added for bug 5568328 fix begin
103: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :=
104: 'OKL_CONTRACTS_UNEXPECTED_ERROR';
105:
106: G_OKC_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
107: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
110: --akrangan added for bug 5568328 fix begin
111: -- global variable for proration logic - bug 5568328
104: 'OKL_CONTRACTS_UNEXPECTED_ERROR';
105:
106: G_OKC_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
107: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
110: --akrangan added for bug 5568328 fix begin
111: -- global variable for proration logic - bug 5568328
112:
105:
106: G_OKC_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
107: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
110: --akrangan added for bug 5568328 fix begin
111: -- global variable for proration logic - bug 5568328
112:
113: G_AMBCOC NUMBER :=0;
139:
140: -- The main body of the calculate quote process
141: PROCEDURE generate (
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: x_return_status OUT NOCOPY VARCHAR2,
147: p_qtev_rec IN qtev_rec_type,