eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_PRICE_PUB dependencies on QP_PREQ_GRP

Line 133: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

129: p_api_version IN NUMBER ,
130: p_init_msg_list IN VARCHAR2 ,
131: p_CHR_ID IN NUMBER,
132: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
133: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
134: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
135: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
136: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
137: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

Line 134: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

130: p_init_msg_list IN VARCHAR2 ,
131: p_CHR_ID IN NUMBER,
132: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
133: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
134: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
135: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
136: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
137: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
138: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

Line 135: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

131: p_CHR_ID IN NUMBER,
132: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
133: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
134: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
135: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
136: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
137: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
138: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
139: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

Line 136: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

132: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
133: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
134: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
135: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
136: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
137: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
138: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
139: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
140: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,

Line 137: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

133: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
134: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
135: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
136: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
137: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
138: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
139: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
140: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,
141: x_return_status OUT NOCOPY VARCHAR2,

Line 138: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

134: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
135: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
136: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
137: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
138: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
139: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
140: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,

Line 139: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

135: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
136: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
137: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
138: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
139: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
140: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 874: x_pattr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE) IS

870: Procedure Load_Pattr_Tbl(p_line_index IN NUMBER,
871: p_pricing_context IN VARCHAR2,
872: p_pricing_attribute IN VARCHAR2,
873: p_pricing_attr_value IN VARCHAR2,
874: x_pattr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE) IS
875: i NUMBER;
876: BEGIN
877: i := nvl(x_pattr_tbl.last,0) +1;
878: x_pattr_tbl(i).Line_Index := p_Line_Index;

Line 889: x_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE) IS

885: Procedure Load_Qual_Tbl(p_line_index IN NUMBER,
886: p_qualifier_context IN VARCHAR2,
887: p_qualifier_attribute IN VARCHAR2,
888: p_qualifier_attr_value IN VARCHAR2,
889: x_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE) IS
890: i NUMBER;
891: BEGIN
892: i := nvl(x_qual_tbl.last,0) +1;
893: x_qual_tbl(i).Line_Index := p_Line_Index;

Line 906: px_Req_line_attr_tbl IN OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE) IS

902: -- This Procedure will return the attributes sourced using QP dimension mapping
903:
904: Procedure Load_Sourced_Pattrs(p_service_line_index IN NUMBER,
905: p_pricing_contexts_tbl IN QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
906: px_Req_line_attr_tbl IN OUT nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE) IS
907:
908: BEGIN
909: --- Load the pricing attributes of service item
910: If p_pricing_contexts_tbl.exists(1)Then

Line 926: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE) IS

922: -- This Procedure will return the user enterable pricing attributes in contracts
923:
924: Procedure Load_User_Defined_Pattrs(p_contract_line_id NUMBER,
925: p_service_line_index NUMBER,
926: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE) IS
927: cursor okc_pattr_cur is
928: select pricing_context,
929: pricing_attribute1, pricing_attribute2, pricing_attribute3, pricing_attribute4,
930: pricing_attribute5, pricing_attribute6, pricing_attribute7, pricing_attribute8,

Line 1093: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

1089: p_get_pb_tbl_flag IN Varchar2,
1090: p_price_list_id IN Number,
1091: p_modifier_list_id IN Number,
1092: p_pricing_contexts_tbl IN QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE,
1093: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
1094: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1095: px_req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
1096: px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE) IS
1097: l_line_index NUMBER := 0;

Line 1094: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

1090: p_price_list_id IN Number,
1091: p_modifier_list_id IN Number,
1092: p_pricing_contexts_tbl IN QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE,
1093: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
1094: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1095: px_req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
1096: px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE) IS
1097: l_line_index NUMBER := 0;
1098: l_related_lines_Index NUMBER := 0;

Line 1095: px_req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

1091: p_modifier_list_id IN Number,
1092: p_pricing_contexts_tbl IN QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE,
1093: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
1094: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1095: px_req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
1096: px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE) IS
1097: l_line_index NUMBER := 0;
1098: l_related_lines_Index NUMBER := 0;
1099: l_attr_index NUMBER := 0;

Line 1096: px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE) IS

1092: p_pricing_contexts_tbl IN QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE,
1093: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
1094: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1095: px_req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
1096: px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE) IS
1097: l_line_index NUMBER := 0;
1098: l_related_lines_Index NUMBER := 0;
1099: l_attr_index NUMBER := 0;
1100: l_qual_attr_index NUMBER := 0;

Line 1235: px_Req_related_lines_tbl(l_related_lines_Index).Relationship_Type_Code := QP_PREQ_GRP.G_SERVICE_LINE;

1231: px_Req_related_lines_tbl(l_related_lines_Index).Line_Index := l_line_index;
1232: px_Req_related_lines_tbl(l_related_lines_Index).Line_Detail_Index := 0;
1233: px_Req_related_lines_tbl(l_related_lines_Index).Related_Line_Index := l_line_index - 1;
1234: px_Req_related_lines_tbl(l_related_lines_Index).Related_Line_Detail_Index := 0;
1235: px_Req_related_lines_tbl(l_related_lines_Index).Relationship_Type_Code := QP_PREQ_GRP.G_SERVICE_LINE;
1236: --Dbms_Output.Put_Line('RELATED LINE INDEX ' || l_line_index);
1237: --Dbms_Output.Put_Line('RELATED DETAIL LINE INDEX ' || i);
1238: --Dbms_Output.Put_Line('G_SERVICE LINE ' || QP_PREQ_GRP.G_SERVICE_LINE);
1239:

Line 1238: --Dbms_Output.Put_Line('G_SERVICE LINE ' || QP_PREQ_GRP.G_SERVICE_LINE);

1234: px_Req_related_lines_tbl(l_related_lines_Index).Related_Line_Detail_Index := 0;
1235: px_Req_related_lines_tbl(l_related_lines_Index).Relationship_Type_Code := QP_PREQ_GRP.G_SERVICE_LINE;
1236: --Dbms_Output.Put_Line('RELATED LINE INDEX ' || l_line_index);
1237: --Dbms_Output.Put_Line('RELATED DETAIL LINE INDEX ' || i);
1238: --Dbms_Output.Put_Line('G_SERVICE LINE ' || QP_PREQ_GRP.G_SERVICE_LINE);
1239:
1240: End If; */
1241: End Loop;
1242: End If;

Line 1248: x_req_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

1244:
1245: Procedure Call_QP(p_contract_line_rec IN OKC_PRICE_PUB.G_LINE_REC_TYPE,
1246: p_contract_cp_tbl IN OUT NOCOPY OKC_PRICE_PUB.G_SLINE_TBL_TYPE,
1247: p_get_pb_tbl_flag IN VARCHAR2,
1248: x_req_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
1249: x_Req_qual_tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
1250: x_Req_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1251: x_Req_LINE_DETAIL_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
1252: x_Req_LINE_DETAIL_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

Line 1249: x_Req_qual_tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

1245: Procedure Call_QP(p_contract_line_rec IN OKC_PRICE_PUB.G_LINE_REC_TYPE,
1246: p_contract_cp_tbl IN OUT NOCOPY OKC_PRICE_PUB.G_SLINE_TBL_TYPE,
1247: p_get_pb_tbl_flag IN VARCHAR2,
1248: x_req_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
1249: x_Req_qual_tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
1250: x_Req_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1251: x_Req_LINE_DETAIL_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
1252: x_Req_LINE_DETAIL_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
1253: x_Req_LINE_DETAIL_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

Line 1250: x_Req_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

1246: p_contract_cp_tbl IN OUT NOCOPY OKC_PRICE_PUB.G_SLINE_TBL_TYPE,
1247: p_get_pb_tbl_flag IN VARCHAR2,
1248: x_req_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
1249: x_Req_qual_tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
1250: x_Req_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1251: x_Req_LINE_DETAIL_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
1252: x_Req_LINE_DETAIL_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
1253: x_Req_LINE_DETAIL_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
1254: x_Req_related_lines_tbl OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

Line 1251: x_Req_LINE_DETAIL_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

1247: p_get_pb_tbl_flag IN VARCHAR2,
1248: x_req_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
1249: x_Req_qual_tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
1250: x_Req_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1251: x_Req_LINE_DETAIL_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
1252: x_Req_LINE_DETAIL_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
1253: x_Req_LINE_DETAIL_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
1254: x_Req_related_lines_tbl OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
1255: x_return_status OUT NOCOPY Varchar2,

Line 1252: x_Req_LINE_DETAIL_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

1248: x_req_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
1249: x_Req_qual_tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
1250: x_Req_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1251: x_Req_LINE_DETAIL_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
1252: x_Req_LINE_DETAIL_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
1253: x_Req_LINE_DETAIL_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
1254: x_Req_related_lines_tbl OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
1255: x_return_status OUT NOCOPY Varchar2,
1256: x_return_status_text OUT NOCOPY Varchar2) IS

Line 1253: x_Req_LINE_DETAIL_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

1249: x_Req_qual_tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
1250: x_Req_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1251: x_Req_LINE_DETAIL_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
1252: x_Req_LINE_DETAIL_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
1253: x_Req_LINE_DETAIL_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
1254: x_Req_related_lines_tbl OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
1255: x_return_status OUT NOCOPY Varchar2,
1256: x_return_status_text OUT NOCOPY Varchar2) IS
1257: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1254: x_Req_related_lines_tbl OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

1250: x_Req_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1251: x_Req_LINE_DETAIL_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
1252: x_Req_LINE_DETAIL_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
1253: x_Req_LINE_DETAIL_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
1254: x_Req_related_lines_tbl OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
1255: x_return_status OUT NOCOPY Varchar2,
1256: x_return_status_text OUT NOCOPY Varchar2) IS
1257: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1258: l_return_status_text Varchar2(240);

Line 1259: l_Req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

1255: x_return_status OUT NOCOPY Varchar2,
1256: x_return_status_text OUT NOCOPY Varchar2) IS
1257: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1258: l_return_status_text Varchar2(240);
1259: l_Req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1260: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1261: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1262: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1263: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 1260: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

1256: x_return_status_text OUT NOCOPY Varchar2) IS
1257: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1258: l_return_status_text Varchar2(240);
1259: l_Req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1260: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1261: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1262: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1263: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1264: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 1261: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

1257: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1258: l_return_status_text Varchar2(240);
1259: l_Req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1260: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1261: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1262: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1263: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1264: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1265: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 1262: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

1258: l_return_status_text Varchar2(240);
1259: l_Req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1260: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1261: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1262: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1263: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1264: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1265: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1266: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 1263: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

1259: l_Req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1260: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1261: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1262: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1263: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1264: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1265: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1266: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1267: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 1264: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

1260: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1261: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1262: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1263: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1264: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1265: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1266: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1267: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1268: i Number;

Line 1265: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

1261: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1262: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1263: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1264: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1265: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1266: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1267: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1268: i Number;
1269:

Line 1417: QP_PREQ_GRP.PRICE_REQUEST(p_control_rec => G_CONTROL_REC,

1413: Dbms_Output.Put_Line(' Status Code '||l_req_line_detail_qual_tbl(I).status_code);
1414: Dbms_Output.Put_Line('---------------------------------------------------');
1415: End Loop;
1416: End If; */
1417: QP_PREQ_GRP.PRICE_REQUEST(p_control_rec => G_CONTROL_REC,
1418: p_line_tbl => l_Req_line_tbl,
1419: p_qual_tbl => l_Req_qual_tbl,
1420: p_line_attr_tbl => l_Req_line_attr_tbl,
1421: p_line_detail_tbl => l_req_line_detail_tbl,

Line 1593: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

1589: x_msg_count OUT NOCOPY NUMBER,
1590: x_msg_data OUT NOCOPY VARCHAR2) IS
1591: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1592: l_return_status_text Varchar2(240) := NULL;
1593: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1594: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1595: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1596: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1597: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 1594: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

1590: x_msg_data OUT NOCOPY VARCHAR2) IS
1591: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1592: l_return_status_text Varchar2(240) := NULL;
1593: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1594: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1595: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1596: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1597: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1598: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 1595: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

1591: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1592: l_return_status_text Varchar2(240) := NULL;
1593: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1594: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1595: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1596: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1597: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1598: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1599: lx_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 1596: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

1592: l_return_status_text Varchar2(240) := NULL;
1593: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1594: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1595: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1596: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1597: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1598: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1599: lx_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1600: l_idx NUMBER := 0;

Line 1597: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

1593: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1594: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1595: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1596: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1597: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1598: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1599: lx_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1600: l_idx NUMBER := 0;
1601: l_contract_line_rec OKC_PRICE_PUB.G_LINE_REC_TYPE := p_contract_line_rec;

Line 1598: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

1594: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1595: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1596: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1597: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1598: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1599: lx_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1600: l_idx NUMBER := 0;
1601: l_contract_line_rec OKC_PRICE_PUB.G_LINE_REC_TYPE := p_contract_line_rec;
1602: Begin

Line 1599: lx_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

1595: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1596: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1597: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1598: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1599: lx_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1600: l_idx NUMBER := 0;
1601: l_contract_line_rec OKC_PRICE_PUB.G_LINE_REC_TYPE := p_contract_line_rec;
1602: Begin
1603: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1947: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

1943: l_contract_cp_tbl OKC_PRICE_PUB.G_SLINE_TBL_TYPE;
1944: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1945: l_return_status_text varchar2(240) := NULL;
1946:
1947: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1948: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1949: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1950: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1951: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 1948: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

1944: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1945: l_return_status_text varchar2(240) := NULL;
1946:
1947: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1948: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1949: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1950: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1951: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1952: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 1949: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

1945: l_return_status_text varchar2(240) := NULL;
1946:
1947: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1948: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1949: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1950: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1951: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1952: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1953: lx_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 1950: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

1946:
1947: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1948: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1949: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1950: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1951: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1952: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1953: lx_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1954: l_price_break_tbl OKC_PRICE_PUB.G_PRICE_BREAK_TBL_TYPE;

Line 1951: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

1947: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1948: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1949: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1950: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1951: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1952: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1953: lx_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1954: l_price_break_tbl OKC_PRICE_PUB.G_PRICE_BREAK_TBL_TYPE;
1955: l_rel_index NUMBER;

Line 1952: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

1948: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1949: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1950: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1951: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1952: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1953: lx_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1954: l_price_break_tbl OKC_PRICE_PUB.G_PRICE_BREAK_TBL_TYPE;
1955: l_rel_index NUMBER;
1956:

Line 1953: lx_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

1949: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1950: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1951: lx_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1952: lx_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1953: lx_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1954: l_price_break_tbl OKC_PRICE_PUB.G_PRICE_BREAK_TBL_TYPE;
1955: l_rel_index NUMBER;
1956:
1957: CURSOR puom_cur(p_inv_id NUMBER) IS

Line 2013: If lx_req_related_lines_tbl(i).relationship_type_code = QP_PREQ_GRP.G_PBH_LINE Then

2009: End If;
2010:
2011: For i in lx_req_related_lines_tbl.first .. lx_req_related_lines_tbl.last
2012: Loop
2013: If lx_req_related_lines_tbl(i).relationship_type_code = QP_PREQ_GRP.G_PBH_LINE Then
2014: l_rel_index := lx_req_related_lines_tbl(i).related_line_detail_index;
2015: ---Dbms_Output.Put_Line('REL INDEX ' || l_rel_index);
2016: For j in lx_req_line_detail_attr_tbl.first .. lx_req_line_detail_attr_tbl.last
2017: Loop