DBA Data[Home] [Help]

APPS.OKS_QP_PKG dependencies on QP_PREQ_GRP

Line 49: G_CONTROL_REC QP_PREQ_GRP.CONTROL_RECORD_TYPE;

45: --9/25 Changed to
46: G_PRICING_EVENT CONSTANT VARCHAR2(30) := 'LINE';
47:
48: G_LINE_TYPE CONSTANT VARCHAR2(30) := 'SERVICE CONTRACT LINE';
49: G_CONTROL_REC QP_PREQ_GRP.CONTROL_RECORD_TYPE;
50:
51:
52: G_JTF_Party CONSTANT VARCHAR2(30) := 'OKX_PARTY';
53: G_JTF_Covlvl CONSTANT VARCHAR2(30) := 'OKX_COVSYST';

Line 141: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

137: PROCEDURE CALC_PRICE
138: (
139: p_detail_rec IN Input_details,
140: x_price_details OUT NOCOPY Price_Details,
141: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
142: x_price_break_details OUT NOCOPY g_price_break_tbl_type,
143: x_return_status OUT NOCOPY Varchar2,
144: x_msg_count OUT NOCOPY Number,
145: x_msg_data OUT NOCOPY Varchar2

Line 160: l_control_rec OUT NOCOPY qp_preq_grp.control_record_type,

156:
157: /*skuchima For Repricing in bulk mode Bug: 7539977 */
158: PROCEDURE calc_price_pre (
159: p_detail_rec IN input_details,
160: l_control_rec OUT NOCOPY qp_preq_grp.control_record_type,
161: l_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
162: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
163: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
164: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

Line 161: l_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,

157: /*skuchima For Repricing in bulk mode Bug: 7539977 */
158: PROCEDURE calc_price_pre (
159: p_detail_rec IN input_details,
160: l_control_rec OUT NOCOPY qp_preq_grp.control_record_type,
161: l_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
162: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
163: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
164: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
165: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,

Line 162: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,

158: PROCEDURE calc_price_pre (
159: p_detail_rec IN input_details,
160: l_control_rec OUT NOCOPY qp_preq_grp.control_record_type,
161: l_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
162: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
163: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
164: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
165: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
166: l_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,

Line 163: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,

159: p_detail_rec IN input_details,
160: l_control_rec OUT NOCOPY qp_preq_grp.control_record_type,
161: l_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
162: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
163: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
164: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
165: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
166: l_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
167: l_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type,

Line 164: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

160: l_control_rec OUT NOCOPY qp_preq_grp.control_record_type,
161: l_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
162: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
163: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
164: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
165: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
166: l_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
167: l_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type,
168: x_return_status OUT NOCOPY VARCHAR2

Line 165: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,

161: l_req_line_tbl OUT NOCOPY qp_preq_grp.line_tbl_type,
162: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
163: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
164: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
165: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
166: l_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
167: l_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type,
168: x_return_status OUT NOCOPY VARCHAR2
169: ) ;

Line 166: l_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,

162: l_req_qual_tbl OUT NOCOPY qp_preq_grp.qual_tbl_type,
163: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
164: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
165: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
166: l_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
167: l_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type,
168: x_return_status OUT NOCOPY VARCHAR2
169: ) ;
170:

Line 167: l_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type,

163: l_req_line_attr_tbl OUT NOCOPY qp_preq_grp.line_attr_tbl_type,
164: l_req_line_detail_tbl OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
165: l_req_line_detail_qual_tbl OUT NOCOPY qp_preq_grp.line_detail_qual_tbl_type,
166: l_req_line_detail_attr_tbl OUT NOCOPY qp_preq_grp.line_detail_attr_tbl_type,
167: l_req_related_lines_tbl OUT NOCOPY qp_preq_grp.related_lines_tbl_type,
168: x_return_status OUT NOCOPY VARCHAR2
169: ) ;
170:
171: /*skuchima For Repricing in bulk mode Bug: 7539977 */

Line 174: lx_req_line_tbl IN qp_preq_grp.line_tbl_type,

170:
171: /*skuchima For Repricing in bulk mode Bug: 7539977 */
172: PROCEDURE calc_price_post(
173: p_detail_rec IN input_details,
174: lx_req_line_tbl IN qp_preq_grp.line_tbl_type,
175: lx_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
176: lx_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
177: lx_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
178: lx_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,

Line 175: lx_req_qual_tbl IN qp_preq_grp.qual_tbl_type,

171: /*skuchima For Repricing in bulk mode Bug: 7539977 */
172: PROCEDURE calc_price_post(
173: p_detail_rec IN input_details,
174: lx_req_line_tbl IN qp_preq_grp.line_tbl_type,
175: lx_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
176: lx_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
177: lx_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
178: lx_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
179: lx_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,

Line 176: lx_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,

172: PROCEDURE calc_price_post(
173: p_detail_rec IN input_details,
174: lx_req_line_tbl IN qp_preq_grp.line_tbl_type,
175: lx_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
176: lx_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
177: lx_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
178: lx_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
179: lx_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
180: lx_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type,

Line 177: lx_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,

173: p_detail_rec IN input_details,
174: lx_req_line_tbl IN qp_preq_grp.line_tbl_type,
175: lx_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
176: lx_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
177: lx_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
178: lx_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
179: lx_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
180: lx_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type,
181: x_price_details OUT NOCOPY price_details,

Line 178: lx_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,

174: lx_req_line_tbl IN qp_preq_grp.line_tbl_type,
175: lx_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
176: lx_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
177: lx_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
178: lx_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
179: lx_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
180: lx_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type,
181: x_price_details OUT NOCOPY price_details,
182: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

Line 179: lx_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,

175: lx_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
176: lx_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
177: lx_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
178: lx_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
179: lx_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
180: lx_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type,
181: x_price_details OUT NOCOPY price_details,
182: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
183: x_price_break_details OUT NOCOPY g_price_break_tbl_type,

Line 180: lx_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type,

176: lx_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
177: lx_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
178: lx_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
179: lx_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
180: lx_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type,
181: x_price_details OUT NOCOPY price_details,
182: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
183: x_price_break_details OUT NOCOPY g_price_break_tbl_type,
184: x_return_status OUT NOCOPY VARCHAR2,

Line 182: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,

178: lx_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
179: lx_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
180: lx_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type,
181: x_price_details OUT NOCOPY price_details,
182: x_modifier_details OUT NOCOPY qp_preq_grp.line_detail_tbl_type,
183: x_price_break_details OUT NOCOPY g_price_break_tbl_type,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2