DBA Data[Home] [Help]

APPS.OKC_PRICE_PUB dependencies on OKC_API

Line 171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

167: --p_calc_flag 'B'(Both -calculate and search),'C'(Calculate Only), 'S' (Search only)
168: ----------------------------------------------------------------------------
169: PROCEDURE CALCULATE_price(
170: p_api_version IN NUMBER DEFAULT 1,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: p_CHR_ID IN NUMBER,
173: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
174: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
175: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

Line 197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

193:
194: ----------------------------------------------------------------------------
195: PROCEDURE Update_CONTRACT_price(
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198: p_commit IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
199: p_CHR_ID IN NUMBER,
200: px_Control_Rec IN OUT NOCOPY PRICE_CONTROL_REC_TYPE,
201: x_CLE_PRICE_TBL OUT NOCOPY CLE_PRICE_TBL_TYPE,

Line 198: p_commit IN VARCHAR2 DEFAULT OKC_API.G_TRUE,

194: ----------------------------------------------------------------------------
195: PROCEDURE Update_CONTRACT_price(
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198: p_commit IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
199: p_CHR_ID IN NUMBER,
200: px_Control_Rec IN OUT NOCOPY PRICE_CONTROL_REC_TYPE,
201: x_CLE_PRICE_TBL OUT NOCOPY CLE_PRICE_TBL_TYPE,
202: x_chr_net_price OUT NOCOPY NUMBER,

Line 227: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

223:
224: ----------------------------------------------------------------------------
225: PROCEDURE Update_LINE_price(
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228: p_commit IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
229: p_CHR_ID IN NUMBER,
230: p_cle_id IN NUMBER DEFAULT null,
231: p_lowest_level IN NUMBER DEFAULT -2,

Line 228: p_commit IN VARCHAR2 DEFAULT OKC_API.G_TRUE,

224: ----------------------------------------------------------------------------
225: PROCEDURE Update_LINE_price(
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228: p_commit IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
229: p_CHR_ID IN NUMBER,
230: p_cle_id IN NUMBER DEFAULT null,
231: p_lowest_level IN NUMBER DEFAULT -2,
232: px_Control_Rec IN OUT NOCOPY PRICE_CONTROL_REC_TYPE,

Line 250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

246: -- To get adjustments for a Header pass p_cle_id as null and p_control_rec.p_level='H'
247: ----------------------------------------------------------------------------
248: PROCEDURE get_manual_adjustments(
249: p_api_version IN NUMBER,
250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
251: p_CHR_ID IN NUMBER,
252: p_cle_id IN number Default Null,
253: p_Control_Rec IN PRICE_CONTROL_REC_TYPE,
254: x_ADJ_tbl OUT NOCOPY MANUAL_Adj_Tbl_Type,

Line 260: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2);
258: --end added smhanda------------------------------------------------------------
259:
260: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
261: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
262: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
263: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
264: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

257: x_msg_data OUT NOCOPY VARCHAR2);
258: --end added smhanda------------------------------------------------------------
259:
260: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
261: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
262: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
263: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
264: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
265: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

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

258: --end added smhanda------------------------------------------------------------
259:
260: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
261: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
262: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
263: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
264: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
265: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
266: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';

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

259:
260: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
261: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
262: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
263: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
264: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
265: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
266: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
267: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';

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

260: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
261: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
262: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
263: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
264: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
265: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
266: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
267: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
268: