84:
85: PROCEDURE copy_Header_to_request(
86: p_request_type_code in varchar2
87: ,p_calculate_price_flag in varchar2
88: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
89: );
90:
91: PROCEDURE copy_Line_to_request(
92: px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
88: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
89: );
90:
91: PROCEDURE copy_Line_to_request(
92: px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
93: ,p_pricing_event in varchar2
94: ,p_Request_Type_Code in varchar2
95: ,p_honor_price_flag in VARCHAR2 Default 'Y'
96: );
96: );
97:
98:
99: PROCEDURE set_pricing_control_record (
100: l_Control_Rec in out nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE
101: ,in_pricing_event in varchar2);
102:
103: PROCEDURE build_context_for_line(
104: p_req_line_tbl_count in number,
103: PROCEDURE build_context_for_line(
104: p_req_line_tbl_count in number,
105: p_price_request_code in varchar2,
106: p_item_type_code in varchar2,
107: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
108: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
109: );
110:
111: PROCEDURE copy_attribs_to_Req(
104: p_req_line_tbl_count in number,
105: p_price_request_code in varchar2,
106: p_item_type_code in varchar2,
107: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
108: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
109: );
110:
111: PROCEDURE copy_attribs_to_Req(
112: p_line_index number
109: );
110:
111: PROCEDURE copy_attribs_to_Req(
112: p_line_index number
113: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
114: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
115: ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
116: ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
117: );
110:
111: PROCEDURE copy_attribs_to_Req(
112: p_line_index number
113: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
114: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
115: ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
116: ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
117: );
118:
119: PROCEDURE Append_attributes(
120: p_header_id number default null
121: ,p_Line_id number default null
122: ,p_line_index number
123: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
124: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
125: );
126:
127: PROCEDURE build_context_for_header(
120: p_header_id number default null
121: ,p_Line_id number default null
122: ,p_line_index number
123: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
124: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
125: );
126:
127: PROCEDURE build_context_for_header(
128: p_req_line_tbl_count in number,
127: PROCEDURE build_context_for_header(
128: p_req_line_tbl_count in number,
129: p_price_request_code in varchar2,
130: p_item_type_code in varchar2,
131: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
132: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
133: );
134:
135: PROCEDURE price_item(
128: p_req_line_tbl_count in number,
129: p_price_request_code in varchar2,
130: p_item_type_code in varchar2,
131: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
132: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
133: );
134:
135: PROCEDURE price_item(
136: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
132: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
133: );
134:
135: PROCEDURE price_item(
136: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
137: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
138: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
139: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
140: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
133: );
134:
135: PROCEDURE price_item(
136: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
137: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
138: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
139: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
140: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
141: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
134:
135: PROCEDURE price_item(
136: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
137: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
138: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
139: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
140: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
141: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
142: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
135: PROCEDURE price_item(
136: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
137: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
138: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
139: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
140: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
141: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
142: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
143: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,
136: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
137: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
138: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
139: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
140: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
141: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
142: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
143: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,
144: in_related_item_id in number,
137: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
138: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
139: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
140: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
141: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
142: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
143: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,
144: in_related_item_id in number,
145: in_qty in number,
138: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
139: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
140: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
141: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
142: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
143: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,
144: in_related_item_id in number,
145: in_qty in number,
146: in_uom in varchar2,