DBA Data[Home] [Help]

APPS.OE_RELATED_ITEMS_PVT dependencies on QP_PREQ_GRP

Line 86: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE

82:
83: PROCEDURE copy_Header_to_request(
84: p_request_type_code in varchar2
85: ,p_calculate_price_flag in varchar2
86: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
87: );
88:
89: PROCEDURE copy_Line_to_request(
90: px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE

Line 90: px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE

86: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
87: );
88:
89: PROCEDURE copy_Line_to_request(
90: px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
91: ,p_pricing_event in varchar2
92: ,p_Request_Type_Code in varchar2
93: ,p_honor_price_flag in VARCHAR2 Default 'Y'
94: );

Line 98: l_Control_Rec in out nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE

94: );
95:
96:
97: PROCEDURE set_pricing_control_record (
98: l_Control_Rec in out nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE
99: ,in_pricing_event in varchar2);
100:
101: PROCEDURE build_context_for_line(
102: p_req_line_tbl_count in number,

Line 105: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

101: PROCEDURE build_context_for_line(
102: p_req_line_tbl_count in number,
103: p_price_request_code in varchar2,
104: p_item_type_code in varchar2,
105: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
106: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
107: );
108:
109: PROCEDURE copy_attribs_to_Req(

Line 106: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

102: p_req_line_tbl_count in number,
103: p_price_request_code in varchar2,
104: p_item_type_code in varchar2,
105: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
106: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
107: );
108:
109: PROCEDURE copy_attribs_to_Req(
110: p_line_index number

Line 111: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

107: );
108:
109: PROCEDURE copy_attribs_to_Req(
110: p_line_index number
111: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
112: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
113: ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
114: ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
115: );

Line 112: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

108:
109: PROCEDURE copy_attribs_to_Req(
110: p_line_index number
111: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
112: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
113: ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
114: ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
115: );
116:

Line 121: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

117: PROCEDURE Append_attributes(
118: p_header_id number default null
119: ,p_Line_id number default null
120: ,p_line_index number
121: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
122: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
123: );
124:
125: PROCEDURE build_context_for_header(

Line 122: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

118: p_header_id number default null
119: ,p_Line_id number default null
120: ,p_line_index number
121: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
122: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
123: );
124:
125: PROCEDURE build_context_for_header(
126: p_req_line_tbl_count in number,

Line 129: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

125: PROCEDURE build_context_for_header(
126: p_req_line_tbl_count in number,
127: p_price_request_code in varchar2,
128: p_item_type_code in varchar2,
129: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
130: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
131: );
132:
133: PROCEDURE price_item(

Line 130: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

126: p_req_line_tbl_count in number,
127: p_price_request_code in varchar2,
128: p_item_type_code in varchar2,
129: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
130: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
131: );
132:
133: PROCEDURE price_item(
134: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,

Line 134: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,

130: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
131: );
132:
133: PROCEDURE price_item(
134: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
135: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
136: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
137: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
138: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

Line 135: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

131: );
132:
133: PROCEDURE price_item(
134: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
135: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
136: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
137: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
138: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
139: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,

Line 136: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

132:
133: PROCEDURE price_item(
134: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
135: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
136: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
137: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
138: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
139: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
140: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

Line 137: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

133: PROCEDURE price_item(
134: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
135: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
136: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
137: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
138: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
139: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
140: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
141: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,

Line 138: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

134: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
135: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
136: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
137: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
138: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
139: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
140: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
141: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,
142: in_related_item_id in number,

Line 139: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,

135: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
136: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
137: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
138: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
139: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
140: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
141: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,
142: in_related_item_id in number,
143: in_qty in number,

Line 140: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

136: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
137: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
138: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
139: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
140: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
141: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,
142: in_related_item_id in number,
143: in_qty in number,
144: in_uom in varchar2,