DBA Data[Home] [Help]

APPS.OKC_PRICE_PVT dependencies on QP_PREQ_GRP

Line 102: QP_CONTROL_REC QP_PREQ_GRP.CONTROL_RECORD_TYPE,

98: ----OKC_CONTROL_REC_TYPE holds the control rec to be sent to price_request as well other parameters.
99: ----------------------------------------------------------------------------
100: TYPE OKC_CONTROL_REC_TYPE is Record
101: (
102: QP_CONTROL_REC QP_PREQ_GRP.CONTROL_RECORD_TYPE,
103: p_Request_Type_Code VARCHAR2(3),
104: p_negotiated_changed varchar2(1) DEFAULT 'N', --possible values 'Y','N'
105: p_level VARCHAR2(2) DEFAULT 'L',--possible values 'L' lines only,'QA' From QA, 'H' Header and lines
106: p_calc_flag varchar2(1) DEFAULT 'B', --possible values

Line 201: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

197: p_request_type_code IN VARCHAR2 DEFAULT 'OKC',
198: p_chr_id IN NUMBER ,
199: p_pricing_type IN VARCHAR2 DEFAULT 'H',
200: p_line_index IN NUMBER DEFAULT 1,
201: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
202: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2) ;

Line 202: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

198: p_chr_id IN NUMBER ,
199: p_pricing_type IN VARCHAR2 DEFAULT 'H',
200: p_line_index IN NUMBER DEFAULT 1,
201: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
202: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2) ;
206: ----------------------------------------------------------------------------

Line 222: x_pricing_contexts_Tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

218: p_pricing_type IN VARCHAR2 DEFAULT 'L',
219: p_line_index IN NUMBER DEFAULT 1,
220: p_service_price IN VARCHAR2 DEFAULT 'N',
221: p_service_price_list IN VARCHAR2 DEFAULT NULL,
222: x_pricing_contexts_Tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
223: x_qualifier_contexts_Tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2);

Line 223: x_qualifier_contexts_Tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

219: p_line_index IN NUMBER DEFAULT 1,
220: p_service_price IN VARCHAR2 DEFAULT 'N',
221: p_service_price_list IN VARCHAR2 DEFAULT NULL,
222: x_pricing_contexts_Tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
223: x_qualifier_contexts_Tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2);
227: ---------------------------------------------------------------------------

Line 255: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

251: p_api_version IN NUMBER DEFAULT 1,
252: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
253: p_CHR_ID IN NUMBER,
254: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
255: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
256: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
257: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
258: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
259: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

Line 256: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

252: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
253: p_CHR_ID IN NUMBER,
254: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
255: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
256: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
257: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
258: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
259: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
260: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

Line 257: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

253: p_CHR_ID IN NUMBER,
254: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
255: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
256: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
257: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
258: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
259: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
260: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
261: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

Line 258: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

254: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
255: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
256: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
257: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
258: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
259: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
260: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
261: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
262: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,

Line 259: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

255: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
256: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
257: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
258: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
259: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
260: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
261: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
262: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,
263: x_return_status OUT NOCOPY VARCHAR2,

Line 260: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

256: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
257: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
258: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
259: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
260: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
261: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
262: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,

Line 261: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

257: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
258: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
259: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
260: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
261: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
262: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2);