DBA Data[Home] [Help]

APPS.OE_RELATED_ITEMS_PVT dependencies on QP_PREQ_GRP

Line 88: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE

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

Line 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: );

Line 100: l_Control_Rec in out nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE

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,

Line 107: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

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(

Line 108: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

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

Line 113: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

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: );

Line 114: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

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:

Line 123: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

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(

Line 124: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

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,

Line 131: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

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(

Line 132: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

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,

Line 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,

Line 137: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_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,

Line 138: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_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,

Line 139: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_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,

Line 140: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

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,

Line 141: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_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,
145: in_qty in number,

Line 142: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_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,
146: in_uom in varchar2,