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_PVT dependencies on QP_PREQ_GRP

Line 172: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

168: x_chr_rec okc_contract_pub.chrv_rec_type;
169: l_cle_tbl okc_contract_pub.clev_tbl_type;
170: x_cle_tbl okc_contract_pub.clev_tbl_type;
171:
172: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
173: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
174: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
175: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
176: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 173: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

169: l_cle_tbl okc_contract_pub.clev_tbl_type;
170: x_cle_tbl okc_contract_pub.clev_tbl_type;
171:
172: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
173: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
174: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
175: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
176: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
177: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 174: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

170: x_cle_tbl okc_contract_pub.clev_tbl_type;
171:
172: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
173: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
174: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
175: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
176: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
177: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
178: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 175: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

171:
172: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
173: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
174: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
175: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
176: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
177: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
178: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
179:

Line 176: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

172: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
173: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
174: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
175: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
176: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
177: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
178: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
179:
180: TYPE char_TBL_TYPE is TABLE of varchar2(3) INDEX BY BINARY_INTEGER;

Line 177: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

173: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
174: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
175: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
176: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
177: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
178: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
179:
180: TYPE char_TBL_TYPE is TABLE of varchar2(3) INDEX BY BINARY_INTEGER;
181:

Line 178: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

174: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
175: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
176: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
177: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
178: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
179:
180: TYPE char_TBL_TYPE is TABLE of varchar2(3) INDEX BY BINARY_INTEGER;
181:
182: l_pat_id_tbl num_tbl_type;

Line 981: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

977: x_chr_rec okc_contract_pub.chrv_rec_type;
978: l_cle_tbl okc_contract_pub.clev_tbl_type;
979: x_cle_tbl okc_contract_pub.clev_tbl_type;
980:
981: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
982: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
983: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
984: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
985: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 982: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

978: l_cle_tbl okc_contract_pub.clev_tbl_type;
979: x_cle_tbl okc_contract_pub.clev_tbl_type;
980:
981: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
982: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
983: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
984: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
985: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
986: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 983: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

979: x_cle_tbl okc_contract_pub.clev_tbl_type;
980:
981: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
982: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
983: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
984: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
985: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
986: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
987: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 984: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

980:
981: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
982: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
983: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
984: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
985: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
986: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
987: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
988: BEGIN

Line 985: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

981: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
982: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
983: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
984: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
985: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
986: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
987: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
988: BEGIN
989: IF (l_debug = 'Y') THEN

Line 986: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

982: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
983: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
984: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
985: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
986: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
987: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
988: BEGIN
989: IF (l_debug = 'Y') THEN
990: okc_debug.Set_Indentation('Update_CONTRACT_price');

Line 987: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

983: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
984: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
985: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
986: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
987: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
988: BEGIN
989: IF (l_debug = 'Y') THEN
990: okc_debug.Set_Indentation('Update_CONTRACT_price');
991: END IF;

Line 2157: p_pricing_attrib_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

2153: --p_context - Context name
2154: --p_attrib_name-Attribute name
2155: ---------------------------------------------------------------------------
2156: FUNCTION IS_ALREADY_THERE(
2157: p_pricing_attrib_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
2158: ,p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE
2159: ,p_line_index number
2160: ,p_context varchar2
2161: ,p_attrib_name varchar2

Line 2158: ,p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE

2154: --p_attrib_name-Attribute name
2155: ---------------------------------------------------------------------------
2156: FUNCTION IS_ALREADY_THERE(
2157: p_pricing_attrib_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
2158: ,p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE
2159: ,p_line_index number
2160: ,p_context varchar2
2161: ,p_attrib_name varchar2
2162: ) Return varchar2 IS

Line 2236: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

2232: procedure copy_attribs_to_Req(
2233: p_line_index number
2234: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
2235: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
2236: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
2237: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
2238: )is
2239: i pls_integer := 0;
2240: l_attr_index pls_integer := nvl(px_Req_line_attr_tbl.last,0);

Line 2237: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

2233: p_line_index number
2234: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
2235: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
2236: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
2237: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
2238: )is
2239: i pls_integer := 0;
2240: l_attr_index pls_integer := nvl(px_Req_line_attr_tbl.last,0);
2241: l_qual_index pls_integer := nvl(px_Req_qual_tbl.last,0);

Line 2334: ,p_pricing_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

2330: ----------------------------------------------------------------------------
2331: procedure copy_attribs(
2332: p_line_index number
2333: ,p_check varchar2
2334: ,p_pricing_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
2335: ,p_qualifier_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE
2336: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
2337: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
2338: )is

Line 2335: ,p_qualifier_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE

2331: procedure copy_attribs(
2332: p_line_index number
2333: ,p_check varchar2
2334: ,p_pricing_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
2335: ,p_qualifier_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE
2336: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
2337: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
2338: )is
2339: i pls_integer := 0;

Line 2336: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

2332: p_line_index number
2333: ,p_check varchar2
2334: ,p_pricing_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
2335: ,p_qualifier_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE
2336: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
2337: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
2338: )is
2339: i pls_integer := 0;
2340: l_attr_index pls_integer := nvl(px_Req_line_attr_tbl.last,0);

Line 2337: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

2333: ,p_check varchar2
2334: ,p_pricing_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
2335: ,p_qualifier_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE
2336: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
2337: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
2338: )is
2339: i pls_integer := 0;
2340: l_attr_index pls_integer := nvl(px_Req_line_attr_tbl.last,0);
2341: l_qual_index pls_integer := nvl(px_Req_qual_tbl.last,0);

Line 2524: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

2520: --px_Req_qual_tbl - Qualifier context table for request line
2521: ----------------------------------------------------------------------------
2522: Procedure Load_User_Defined_Pattrs(p_chr_id NUMBER,
2523: p_line_index NUMBER,
2524: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2525: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
2526: x_return_status IN OUT NOCOPY varchar2,
2527: p_cle_id IN NUMBER DEFAULT NULL
2528: ) IS

Line 2525: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

2521: ----------------------------------------------------------------------------
2522: Procedure Load_User_Defined_Pattrs(p_chr_id NUMBER,
2523: p_line_index NUMBER,
2524: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2525: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
2526: x_return_status IN OUT NOCOPY varchar2,
2527: p_cle_id IN NUMBER DEFAULT NULL
2528: ) IS
2529: cursor okc_pattr_cur(p_chr_id number) is

Line 2953: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

2949: p_request_type_code IN VARCHAR2 ,
2950: p_chr_id IN NUMBER,
2951: p_pricing_type IN VARCHAR2 ,
2952: p_line_index IN NUMBER ,
2953: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2954: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
2955: x_return_status OUT NOCOPY VARCHAR2,
2956: x_msg_count OUT NOCOPY NUMBER,
2957: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 2954: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

2950: p_chr_id IN NUMBER,
2951: p_pricing_type IN VARCHAR2 ,
2952: p_line_index IN NUMBER ,
2953: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2954: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
2955: x_return_status OUT NOCOPY VARCHAR2,
2956: x_msg_count OUT NOCOPY NUMBER,
2957: x_msg_data OUT NOCOPY VARCHAR2) IS
2958:

Line 3477: x_pricing_contexts_Tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

3473: p_pricing_type IN VARCHAR2 ,
3474: p_line_index IN NUMBER ,
3475: p_service_price IN VARCHAR2 ,
3476: p_service_price_list IN VARCHAR2 DEFAULT NULL,
3477: x_pricing_contexts_Tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3478: x_qualifier_contexts_Tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
3479: x_return_status OUT NOCOPY VARCHAR2,
3480: x_msg_count OUT NOCOPY NUMBER,
3481: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 3478: x_qualifier_contexts_Tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

3474: p_line_index IN NUMBER ,
3475: p_service_price IN VARCHAR2 ,
3476: p_service_price_list IN VARCHAR2 DEFAULT NULL,
3477: x_pricing_contexts_Tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3478: x_qualifier_contexts_Tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
3479: x_return_status OUT NOCOPY VARCHAR2,
3480: x_msg_count OUT NOCOPY NUMBER,
3481: x_msg_data OUT NOCOPY VARCHAR2) IS
3482:

Line 3489: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

3485: l_api_name constant VARCHAR2(30) := 'BUILD_CLE_CONTEXT';
3486: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
3487: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
3488: k pls_integer;
3489: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
3490: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
3491:
3492:
3493: l_lse_rec global_lse_rec_type;

Line 3490: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

3486: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
3487: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
3488: k pls_integer;
3489: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
3490: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
3491:
3492:
3493: l_lse_rec global_lse_rec_type;
3494: l_prle_rec global_rprle_rec_type;

Line 4038: p_hdr_prc_contexts_Tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

4034: p_line_tbl IN line_tbl_type,
4035: p_pi_ind IN NUMBER ,
4036: p_bpi_ind IN NUMBER ,
4037: p_pricing_event IN varchar2 ,
4038: p_hdr_prc_contexts_Tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4039: p_hdr_qual_contexts_Tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
4040: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE ,
4041: px_Req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4042: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

Line 4039: p_hdr_qual_contexts_Tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,

4035: p_pi_ind IN NUMBER ,
4036: p_bpi_ind IN NUMBER ,
4037: p_pricing_event IN varchar2 ,
4038: p_hdr_prc_contexts_Tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4039: p_hdr_qual_contexts_Tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
4040: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE ,
4041: px_Req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4042: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4043: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

Line 4040: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE ,

4036: p_bpi_ind IN NUMBER ,
4037: p_pricing_event IN varchar2 ,
4038: p_hdr_prc_contexts_Tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4039: p_hdr_qual_contexts_Tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
4040: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE ,
4041: px_Req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4042: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4043: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
4044: x_return_status OUT NOCOPY varchar2,

Line 4041: px_Req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

4037: p_pricing_event IN varchar2 ,
4038: p_hdr_prc_contexts_Tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4039: p_hdr_qual_contexts_Tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
4040: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE ,
4041: px_Req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4042: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4043: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
4044: x_return_status OUT NOCOPY varchar2,
4045: x_msg_count OUT NOCOPY NUMBER,

Line 4042: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

4038: p_hdr_prc_contexts_Tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4039: p_hdr_qual_contexts_Tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
4040: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE ,
4041: px_Req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4042: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4043: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
4044: x_return_status OUT NOCOPY varchar2,
4045: x_msg_count OUT NOCOPY NUMBER,
4046: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 4043: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

4039: p_hdr_qual_contexts_Tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
4040: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE ,
4041: px_Req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4042: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4043: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
4044: x_return_status OUT NOCOPY varchar2,
4045: x_msg_count OUT NOCOPY NUMBER,
4046: x_msg_data OUT NOCOPY VARCHAR2) IS
4047:

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

4215: l_related_lines_Index := px_Req_related_lines_tbl.count+1;
4216: px_Req_related_lines_tbl(l_related_lines_Index).Line_Index := l_line_index;
4217: px_Req_related_lines_tbl(l_related_lines_Index).Related_Line_Index := l_line_index+1;
4218: -- Right now hardcoding relationship to service
4219: px_Req_related_lines_tbl(l_related_lines_Index).Relationship_Type_Code:= QP_PREQ_GRP.G_SERVICE_LINE;
4220: -- make p_bpi_ind=0 to exit the loop next time around
4221: --l_bpi_ind :=0;
4222: ELSE
4223: l_num_loops:=0;

Line 4268: p_hdr_prc_contexts_Tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

4264: p_line_tbl IN line_tbl_type,
4265: p_pi_ind IN NUMBER ,
4266: p_bpi_ind IN NUMBER ,
4267: p_pricing_event IN varchar2 ,
4268: p_hdr_prc_contexts_Tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4269: p_hdr_qual_contexts_Tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
4270: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE ,
4271: px_Req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4272: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

Line 4269: p_hdr_qual_contexts_Tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,

4265: p_pi_ind IN NUMBER ,
4266: p_bpi_ind IN NUMBER ,
4267: p_pricing_event IN varchar2 ,
4268: p_hdr_prc_contexts_Tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4269: p_hdr_qual_contexts_Tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
4270: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE ,
4271: px_Req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4272: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4273: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

Line 4270: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE ,

4266: p_bpi_ind IN NUMBER ,
4267: p_pricing_event IN varchar2 ,
4268: p_hdr_prc_contexts_Tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4269: p_hdr_qual_contexts_Tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
4270: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE ,
4271: px_Req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4272: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4273: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
4274: x_return_status OUT NOCOPY varchar2,

Line 4271: px_Req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

4267: p_pricing_event IN varchar2 ,
4268: p_hdr_prc_contexts_Tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4269: p_hdr_qual_contexts_Tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
4270: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE ,
4271: px_Req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4272: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4273: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
4274: x_return_status OUT NOCOPY varchar2,
4275: x_msg_count OUT NOCOPY NUMBER,

Line 4272: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

4268: p_hdr_prc_contexts_Tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4269: p_hdr_qual_contexts_Tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
4270: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE ,
4271: px_Req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4272: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4273: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
4274: x_return_status OUT NOCOPY varchar2,
4275: x_msg_count OUT NOCOPY NUMBER,
4276: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 4273: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

4269: p_hdr_qual_contexts_Tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
4270: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE ,
4271: px_Req_related_lines_tbl IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4272: x_pricing_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
4273: x_qualifier_contexts_Tbl OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
4274: x_return_status OUT NOCOPY varchar2,
4275: x_msg_count OUT NOCOPY NUMBER,
4276: x_msg_data OUT NOCOPY VARCHAR2) IS
4277:

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

4424: l_related_lines_Index := px_Req_related_lines_tbl.count+1;
4425: px_Req_related_lines_tbl(l_related_lines_Index).Line_Index := l_line_index; --index of cov line
4426: px_Req_related_lines_tbl(l_related_lines_Index).Related_Line_Index := l_line_index+1; -- index of service item
4427: -- Right now hardcoding relationship to service
4428: px_Req_related_lines_tbl(l_related_lines_Index).Relationship_Type_Code:= QP_PREQ_GRP.G_SERVICE_LINE;
4429: end if;
4430: end if; --If for pi/p
4431: i := l_line_tbl.next(i);
4432:

Line 4473: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,

4469: p_api_version IN NUMBER,
4470: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE ,
4471: p_CHR_ID IN NUMBER,
4472: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
4473: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
4474: p_Req_LINE_DETAIL_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
4475: p_Req_LINE_DETAIL_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
4476: p_Req_LINE_DETAIL_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
4477: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

Line 4474: p_Req_LINE_DETAIL_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

4470: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE ,
4471: p_CHR_ID IN NUMBER,
4472: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
4473: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
4474: p_Req_LINE_DETAIL_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
4475: p_Req_LINE_DETAIL_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
4476: p_Req_LINE_DETAIL_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
4477: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4478: p_CLE_PRICE_tbl IN CLE_PRICE_tbl_TYPE,

Line 4475: p_Req_LINE_DETAIL_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

4471: p_CHR_ID IN NUMBER,
4472: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
4473: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
4474: p_Req_LINE_DETAIL_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
4475: p_Req_LINE_DETAIL_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
4476: p_Req_LINE_DETAIL_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
4477: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4478: p_CLE_PRICE_tbl IN CLE_PRICE_tbl_TYPE,
4479: p_service_qty_tbl IN NUM_TBL_TYPE,

Line 4476: p_Req_LINE_DETAIL_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

4472: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
4473: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
4474: p_Req_LINE_DETAIL_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
4475: p_Req_LINE_DETAIL_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
4476: p_Req_LINE_DETAIL_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
4477: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4478: p_CLE_PRICE_tbl IN CLE_PRICE_tbl_TYPE,
4479: p_service_qty_tbl IN NUM_TBL_TYPE,
4480: x_return_status OUT NOCOPY VARCHAR2,

Line 4477: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

4473: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
4474: p_Req_LINE_DETAIL_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
4475: p_Req_LINE_DETAIL_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
4476: p_Req_LINE_DETAIL_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
4477: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
4478: p_CLE_PRICE_tbl IN CLE_PRICE_tbl_TYPE,
4479: p_service_qty_tbl IN NUM_TBL_TYPE,
4480: x_return_status OUT NOCOPY VARCHAR2,
4481: x_msg_count OUT NOCOPY NUMBER,

Line 4836: p_Req_LINE_DETAIL_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,

4832: -------------------------------------------------------------------------
4833: -- LOAD_ADJ_LINES
4834: -------------------------------------------------------------------------
4835: PROCEDURE LOAD_ADJ_LINES(
4836: p_Req_LINE_DETAIL_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
4837: p_opr IN varchar2 DEFAULT 'I' ,
4838: p_service_qty IN NUMBER DEFAULT 1,
4839: p_adj_id IN NUMBER default 0,
4840: p_obj IN NUMBER default 1,

Line 4899: FUNCTION IS_SERVICED_REQ_LINE( p_req_line_rec IN QP_PREQ_GRP.LINE_rec_TYPE,

4895: --Added for pricing of service lines
4896:
4897: --tope pbh changes comment the function out
4898: /*
4899: FUNCTION IS_SERVICED_REQ_LINE( p_req_line_rec IN QP_PREQ_GRP.LINE_rec_TYPE,
4900: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE)
4901: RETURN VARCHAR2 IS
4902: serviced_rec varchar2(1) := 'N';
4903: i pls_integer := 0;

Line 4900: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE)

4896:
4897: --tope pbh changes comment the function out
4898: /*
4899: FUNCTION IS_SERVICED_REQ_LINE( p_req_line_rec IN QP_PREQ_GRP.LINE_rec_TYPE,
4900: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE)
4901: RETURN VARCHAR2 IS
4902: serviced_rec varchar2(1) := 'N';
4903: i pls_integer := 0;
4904:

Line 4909: and p_Req_related_line_tbl(i).Relationship_Type_Code = QP_PREQ_GRP.G_SERVICE_LINE

4905: BEGIN
4906: i := p_Req_RELATED_LINE_TBL.first;
4907: While i is not null loop
4908: If p_req_line_rec.line_index = p_req_related_line_tbl(i).line_index
4909: and p_Req_related_line_tbl(i).Relationship_Type_Code = QP_PREQ_GRP.G_SERVICE_LINE
4910: Then
4911: serviced_rec := 'Y';
4912: IF (l_debug = 'Y') THEN
4913: my_debug('line index '||p_req_line_rec.line_index||'No updates to id'||p_req_line_rec.line_id);

Line 4924: PROCEDURE IS_SERVICED_REQ_LINE(p_req_line_rec IN QP_PREQ_GRP.LINE_rec_TYPE,

4920: END IS_SERVICED_REQ_LINE;
4921: */
4922:
4923: --tope pbh changes
4924: PROCEDURE IS_SERVICED_REQ_LINE(p_req_line_rec IN QP_PREQ_GRP.LINE_rec_TYPE,
4925: detail_index IN NUMBER ,
4926: l_serviced_rec_yn OUT NOCOPY VARCHAR2 ,
4927: l_process_child_yn OUT NOCOPY VARCHAR2 )
4928: IS

Line 4935: and p_Req_related_line_tbl(i).Relationship_Type_Code = QP_PREQ_GRP.G_SERVICE_LINE

4931: BEGIN
4932: i := p_Req_RELATED_LINE_TBL.first;
4933: While i is not null loop
4934: If p_req_line_rec.line_index = p_req_related_line_tbl(i).line_index
4935: and p_Req_related_line_tbl(i).Relationship_Type_Code = QP_PREQ_GRP.G_SERVICE_LINE
4936: Then
4937: l_serviced_rec_yn := 'Y';
4938: IF (l_debug = 'Y') THEN
4939: my_debug('line index '||p_req_line_rec.line_index||'No updates to id'||p_req_line_rec.line_id);

Line 5102: QP_PREQ_GRP.G_STATUS_UPDATED

5098:
5099:
5100:
5101: if p_req_line_tbl( p_req_line_detail_Tbl(i).line_index).status_code in (
5102: QP_PREQ_GRP.G_STATUS_UPDATED
5103: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
5104: ,QP_PREQ_GRP.G_STATUS_NEW
5105: ,QP_PREQ_GRP.G_STATUS_UNCHANGED
5106: ,QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED )

Line 5103: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION

5099:
5100:
5101: if p_req_line_tbl( p_req_line_detail_Tbl(i).line_index).status_code in (
5102: QP_PREQ_GRP.G_STATUS_UPDATED
5103: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
5104: ,QP_PREQ_GRP.G_STATUS_NEW
5105: ,QP_PREQ_GRP.G_STATUS_UNCHANGED
5106: ,QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED )
5107: and (p_req_line_tbl(p_req_line_detail_Tbl(i).line_index).line_Type_code ='LINE'

Line 5104: ,QP_PREQ_GRP.G_STATUS_NEW

5100:
5101: if p_req_line_tbl( p_req_line_detail_Tbl(i).line_index).status_code in (
5102: QP_PREQ_GRP.G_STATUS_UPDATED
5103: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
5104: ,QP_PREQ_GRP.G_STATUS_NEW
5105: ,QP_PREQ_GRP.G_STATUS_UNCHANGED
5106: ,QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED )
5107: and (p_req_line_tbl(p_req_line_detail_Tbl(i).line_index).line_Type_code ='LINE'
5108: and nvl(p_req_line_tbl( p_req_line_detail_Tbl(i).line_index).processed_code,'0')

Line 5105: ,QP_PREQ_GRP.G_STATUS_UNCHANGED

5101: if p_req_line_tbl( p_req_line_detail_Tbl(i).line_index).status_code in (
5102: QP_PREQ_GRP.G_STATUS_UPDATED
5103: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
5104: ,QP_PREQ_GRP.G_STATUS_NEW
5105: ,QP_PREQ_GRP.G_STATUS_UNCHANGED
5106: ,QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED )
5107: and (p_req_line_tbl(p_req_line_detail_Tbl(i).line_index).line_Type_code ='LINE'
5108: and nvl(p_req_line_tbl( p_req_line_detail_Tbl(i).line_index).processed_code,'0')
5109: <> QP_PREQ_GRP.G_BY_ENGINE

Line 5106: ,QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED )

5102: QP_PREQ_GRP.G_STATUS_UPDATED
5103: ,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
5104: ,QP_PREQ_GRP.G_STATUS_NEW
5105: ,QP_PREQ_GRP.G_STATUS_UNCHANGED
5106: ,QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED )
5107: and (p_req_line_tbl(p_req_line_detail_Tbl(i).line_index).line_Type_code ='LINE'
5108: and nvl(p_req_line_tbl( p_req_line_detail_Tbl(i).line_index).processed_code,'0')
5109: <> QP_PREQ_GRP.G_BY_ENGINE
5110: --commented out to support negative pricing

Line 5109: <> QP_PREQ_GRP.G_BY_ENGINE

5105: ,QP_PREQ_GRP.G_STATUS_UNCHANGED
5106: ,QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED )
5107: and (p_req_line_tbl(p_req_line_detail_Tbl(i).line_index).line_Type_code ='LINE'
5108: and nvl(p_req_line_tbl( p_req_line_detail_Tbl(i).line_index).processed_code,'0')
5109: <> QP_PREQ_GRP.G_BY_ENGINE
5110: --commented out to support negative pricing
5111: -- and ( p_req_line_tbl(p_req_line_detail_Tbl(i).line_index).unit_price >= 0
5112: -- and p_req_line_tbl(p_req_line_detail_Tbl(i).line_index).Adjusted_unit_price >= 0))
5113: OR

Line 5471: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,

5467: p_api_version IN NUMBER,
5468: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5469: p_CHR_ID IN NUMBER,
5470: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
5471: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
5472: p_Req_LINE_DETAIL_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
5473: p_Req_LINE_DETAIL_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
5474: p_Req_LINE_DETAIL_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
5475: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

Line 5472: p_Req_LINE_DETAIL_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

5468: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5469: p_CHR_ID IN NUMBER,
5470: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
5471: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
5472: p_Req_LINE_DETAIL_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
5473: p_Req_LINE_DETAIL_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
5474: p_Req_LINE_DETAIL_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
5475: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
5476: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,

Line 5473: p_Req_LINE_DETAIL_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

5469: p_CHR_ID IN NUMBER,
5470: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
5471: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
5472: p_Req_LINE_DETAIL_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
5473: p_Req_LINE_DETAIL_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
5474: p_Req_LINE_DETAIL_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
5475: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
5476: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,
5477: x_return_status OUT NOCOPY VARCHAR2,

Line 5474: p_Req_LINE_DETAIL_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

5470: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
5471: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
5472: p_Req_LINE_DETAIL_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
5473: p_Req_LINE_DETAIL_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
5474: p_Req_LINE_DETAIL_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
5475: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
5476: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,
5477: x_return_status OUT NOCOPY VARCHAR2,
5478: x_msg_count OUT NOCOPY NUMBER,

Line 5475: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

5471: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
5472: p_Req_LINE_DETAIL_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
5473: p_Req_LINE_DETAIL_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
5474: p_Req_LINE_DETAIL_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
5475: p_Req_RELATED_LINE_TBL IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
5476: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,
5477: x_return_status OUT NOCOPY VARCHAR2,
5478: x_msg_count OUT NOCOPY NUMBER,
5479: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 5592: p_req_line_tbl(i).status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,

5588: If l_line_rec.id <> 0 then --#1.1 That means found the rec. filter out nocopy free goods and header line
5589: l_line_rec.ret_sts := 'E';
5590: if--#2
5591: p_req_line_tbl(i).line_Type_code ='LINE' and --#2
5592: p_req_line_tbl(i).status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
5593: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5594: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5595: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5596: OKC_API.G_RET_STS_UNEXP_ERROR,

Line 5593: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,

5589: l_line_rec.ret_sts := 'E';
5590: if--#2
5591: p_req_line_tbl(i).line_Type_code ='LINE' and --#2
5592: p_req_line_tbl(i).status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
5593: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5594: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5595: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5596: OKC_API.G_RET_STS_UNEXP_ERROR,
5597: OKC_API.G_RET_STS_ERROR,

Line 5594: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,

5590: if--#2
5591: p_req_line_tbl(i).line_Type_code ='LINE' and --#2
5592: p_req_line_tbl(i).status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
5593: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5594: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5595: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5596: OKC_API.G_RET_STS_UNEXP_ERROR,
5597: OKC_API.G_RET_STS_ERROR,
5598: QP_PREQ_GRP.G_STATUS_CALC_ERROR,

Line 5595: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,

5591: p_req_line_tbl(i).line_Type_code ='LINE' and --#2
5592: p_req_line_tbl(i).status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
5593: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5594: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5595: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5596: OKC_API.G_RET_STS_UNEXP_ERROR,
5597: OKC_API.G_RET_STS_ERROR,
5598: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5599: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,

Line 5598: QP_PREQ_GRP.G_STATUS_CALC_ERROR,

5594: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5595: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5596: OKC_API.G_RET_STS_UNEXP_ERROR,
5597: OKC_API.G_RET_STS_ERROR,
5598: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5599: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5600: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5601: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5602: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,

Line 5599: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,

5595: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5596: OKC_API.G_RET_STS_UNEXP_ERROR,
5597: OKC_API.G_RET_STS_ERROR,
5598: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5599: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5600: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5601: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5602: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5603: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,

Line 5600: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

5596: OKC_API.G_RET_STS_UNEXP_ERROR,
5597: OKC_API.G_RET_STS_ERROR,
5598: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5599: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5600: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5601: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5602: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5603: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5604: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR,

Line 5601: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

5597: OKC_API.G_RET_STS_ERROR,
5598: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5599: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5600: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5601: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5602: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5603: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5604: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR,
5605: QP_PREQ_PUB.G_BACK_CALCULATION_STS)

Line 5602: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,

5598: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5599: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5600: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5601: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5602: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5603: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5604: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR,
5605: QP_PREQ_PUB.G_BACK_CALCULATION_STS)
5606: then

Line 5603: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,

5599: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5600: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5601: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5602: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5603: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5604: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR,
5605: QP_PREQ_PUB.G_BACK_CALCULATION_STS)
5606: then
5607: IF (l_debug = 'Y') THEN

Line 5604: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR,

5600: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5601: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5602: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5603: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5604: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR,
5605: QP_PREQ_PUB.G_BACK_CALCULATION_STS)
5606: then
5607: IF (l_debug = 'Y') THEN
5608: my_debug('15020: some error in request, code-'||p_req_line_tbl(i).status_code);

Line 5651: If p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST

5647:
5648: --san x_return_status := OKC_API.G_RET_STS_ERROR;
5649: x_return_status :=G_SOME_LINE_ERRORED;
5650: --?????change all pricing error names to OKC_QP_... later
5651: If p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST
5652: and l_prc1 is not null then --#3
5653: OKC_API.set_message(p_app_name => g_app_name,
5654: p_msg_name => 'OKC_QP_INVALID_PRICE_LIST', --invalid pricelist/item combi
5655: p_token1 => 'line_num',

Line 5659: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND

5655: p_token1 => 'line_num',
5656: p_token1_value => l_line_rec.line_num,
5657: p_token2 => 'Price_list',
5658: p_token2_value => l_prc1);
5659: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND
5660: OR (p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST
5661: AND l_prc1 is null ) Then
5662: OKC_API.set_message(p_app_name => g_app_name,
5663: p_msg_name => 'OKC_QP_NO_PRICE_LIST', --pricelist not found

Line 5660: OR (p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST

5656: p_token1_value => l_line_rec.line_num,
5657: p_token2 => 'Price_list',
5658: p_token2_value => l_prc1);
5659: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND
5660: OR (p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST
5661: AND l_prc1 is null ) Then
5662: OKC_API.set_message(p_app_name => g_app_name,
5663: p_msg_name => 'OKC_QP_NO_PRICE_LIST', --pricelist not found
5664: p_token1 => 'LINE_NUM',

Line 5666: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then

5662: OKC_API.set_message(p_app_name => g_app_name,
5663: p_msg_name => 'OKC_QP_NO_PRICE_LIST', --pricelist not found
5664: p_token1 => 'LINE_NUM',
5665: p_token1_value => l_line_rec.line_num);
5666: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
5667: OKC_API.set_message(p_app_name => g_app_name,
5668: p_msg_name => 'OKC_QP_FORMULA_ERROR', --Error in formula processing
5669: p_token1 => 'line_num',
5670: p_token1_value => l_line_rec.line_num);

Line 5672: (QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,

5668: p_msg_name => 'OKC_QP_FORMULA_ERROR', --Error in formula processing
5669: p_token1 => 'line_num',
5670: p_token1_value => l_line_rec.line_num);
5671: Elsif p_req_line_tbl(i).status_code in
5672: (QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
5673: FND_API.G_RET_STS_ERROR)
5674: then
5675: OKC_API.set_message(p_app_name => g_app_name,
5676: p_msg_name => 'OKC_QP_PRICING_ERROR', --other errors in processing

Line 5682: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then

5678: p_token1_value => l_line_rec.line_num,
5679: p_token2 => 'Err_Text',
5680: p_token2_value => p_req_line_tbl(i).status_text);
5681:
5682: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
5683: OKC_API.set_message(p_app_name => g_app_name,
5684: p_msg_name => 'OKC_QP_INVALID_UOM', --invalid uom
5685: p_token1 => 'UOM',
5686: p_token1_value => p_req_line_tbl(i).line_uom_code,

Line 5690: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then

5686: p_token1_value => p_req_line_tbl(i).line_uom_code,
5687: p_token2 => 'line_num',
5688: p_token2_value => l_line_rec.line_num);--????check priced or line uom here
5689: --dbms_output.put_line('ddddd'||l_line_rec.line_num||'fff'||p_req_line_tbl(i).line_uom_code);
5690: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
5691: BEGIN
5692: ---Modified to show correct price lists in error message
5693: l_prc1 := null;
5694: --open l_cur;

Line 5732: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then

5728: l_prc2:=null;
5729: --dbms_output.put_line('a3');
5730:
5731:
5732: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
5733: OKC_API.set_message(p_app_name => g_app_name,
5734: p_msg_name => 'OKC_QP_INVAL_UOM_CONV', --invalid uom conversion
5735: p_token1 => 'line_num',
5736: p_token1_value => l_line_rec.line_num,

Line 5740: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then

5736: p_token1_value => l_line_rec.line_num,
5737: p_token2 => 'err_text',
5738: p_token2_value => p_req_line_tbl(i).status_text);
5739:
5740: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
5741: OKC_API.set_message(p_app_name => g_app_name,
5742: p_msg_name => 'OKC_QP_INVALID_INCOMP', --Unable to resolve incompatibility
5743: p_token1 => 'line_num',
5744: p_token1_value => l_line_rec.line_num,

Line 5747: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then

5743: p_token1 => 'line_num',
5744: p_token1_value => l_line_rec.line_num,
5745: p_token2 => 'err_text',
5746: p_token2_value => p_req_line_tbl(i).status_text);
5747: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
5748: OKC_API.set_message(p_app_name => g_app_name,
5749: p_msg_name => 'OKC_QP_BEST_PRICE', --error while evaluating best price
5750: p_token1 => 'line_num',
5751: p_token1_value => l_line_rec.line_num,

Line 5795: ( QP_PREQ_GRP.G_STATUS_UPDATED,

5791: x_return_status := G_SOME_LINE_ERRORED;
5792: */
5793: elsif p_req_line_tbl(i).line_Type_code ='LINE' and
5794: p_req_line_tbl(i).status_code in
5795: ( QP_PREQ_GRP.G_STATUS_UPDATED,
5796: QP_PREQ_GRP.G_STATUS_NEW,
5797: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,
5798: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
5799: QP_PREQ_GRP.G_STATUS_UNCHANGED,

Line 5796: QP_PREQ_GRP.G_STATUS_NEW,

5792: */
5793: elsif p_req_line_tbl(i).line_Type_code ='LINE' and
5794: p_req_line_tbl(i).status_code in
5795: ( QP_PREQ_GRP.G_STATUS_UPDATED,
5796: QP_PREQ_GRP.G_STATUS_NEW,
5797: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,
5798: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
5799: QP_PREQ_GRP.G_STATUS_UNCHANGED,
5800: QP_PREQ_PUB.G_BACK_CALCULATION_STS) and

Line 5797: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,

5793: elsif p_req_line_tbl(i).line_Type_code ='LINE' and
5794: p_req_line_tbl(i).status_code in
5795: ( QP_PREQ_GRP.G_STATUS_UPDATED,
5796: QP_PREQ_GRP.G_STATUS_NEW,
5797: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,
5798: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
5799: QP_PREQ_GRP.G_STATUS_UNCHANGED,
5800: QP_PREQ_PUB.G_BACK_CALCULATION_STS) and
5801: --???? change later nvl(p_req_line_tbl(i).processed_code,'0') = QP_PREQ_PUB.G_BACK_CALCULATION_STS then

Line 5798: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,

5794: p_req_line_tbl(i).status_code in
5795: ( QP_PREQ_GRP.G_STATUS_UPDATED,
5796: QP_PREQ_GRP.G_STATUS_NEW,
5797: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,
5798: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
5799: QP_PREQ_GRP.G_STATUS_UNCHANGED,
5800: QP_PREQ_PUB.G_BACK_CALCULATION_STS) and
5801: --???? change later nvl(p_req_line_tbl(i).processed_code,'0') = QP_PREQ_PUB.G_BACK_CALCULATION_STS then
5802: -- right now this way because of a bug in QP. Later on QP might return this error in retcode on request line

Line 5799: QP_PREQ_GRP.G_STATUS_UNCHANGED,

5795: ( QP_PREQ_GRP.G_STATUS_UPDATED,
5796: QP_PREQ_GRP.G_STATUS_NEW,
5797: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,
5798: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
5799: QP_PREQ_GRP.G_STATUS_UNCHANGED,
5800: QP_PREQ_PUB.G_BACK_CALCULATION_STS) and
5801: --???? change later nvl(p_req_line_tbl(i).processed_code,'0') = QP_PREQ_PUB.G_BACK_CALCULATION_STS then
5802: -- right now this way because of a bug in QP. Later on QP might return this error in retcode on request line
5803: -- also QP_PREQ_PUB.G_BACK_CALCULATION_STS might hold 'BACK CALCULATION ERROR' instaed of

Line 5832: ( QP_PREQ_GRP.G_STATUS_UPDATED,

5828:
5829:
5830: elsif p_req_line_tbl(i).line_Type_code ='LINE' and
5831: p_req_line_tbl(i).status_code in
5832: ( QP_PREQ_GRP.G_STATUS_UPDATED,
5833: QP_PREQ_GRP.G_STATUS_NEW,
5834: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,
5835: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
5836: QP_PREQ_GRP.G_STATUS_UNCHANGED) and

Line 5833: QP_PREQ_GRP.G_STATUS_NEW,

5829:
5830: elsif p_req_line_tbl(i).line_Type_code ='LINE' and
5831: p_req_line_tbl(i).status_code in
5832: ( QP_PREQ_GRP.G_STATUS_UPDATED,
5833: QP_PREQ_GRP.G_STATUS_NEW,
5834: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,
5835: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
5836: QP_PREQ_GRP.G_STATUS_UNCHANGED) and
5837: nvl(p_req_line_tbl(i).processed_code,'0') <> QP_PREQ_PUB.G_BY_ENGINE--????check this one

Line 5834: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,

5830: elsif p_req_line_tbl(i).line_Type_code ='LINE' and
5831: p_req_line_tbl(i).status_code in
5832: ( QP_PREQ_GRP.G_STATUS_UPDATED,
5833: QP_PREQ_GRP.G_STATUS_NEW,
5834: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,
5835: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
5836: QP_PREQ_GRP.G_STATUS_UNCHANGED) and
5837: nvl(p_req_line_tbl(i).processed_code,'0') <> QP_PREQ_PUB.G_BY_ENGINE--????check this one
5838: and p_req_line_tbl(i).price_flag IN ('Y','P')

Line 5835: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,

5831: p_req_line_tbl(i).status_code in
5832: ( QP_PREQ_GRP.G_STATUS_UPDATED,
5833: QP_PREQ_GRP.G_STATUS_NEW,
5834: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,
5835: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
5836: QP_PREQ_GRP.G_STATUS_UNCHANGED) and
5837: nvl(p_req_line_tbl(i).processed_code,'0') <> QP_PREQ_PUB.G_BY_ENGINE--????check this one
5838: and p_req_line_tbl(i).price_flag IN ('Y','P')
5839: then

Line 5836: QP_PREQ_GRP.G_STATUS_UNCHANGED) and

5832: ( QP_PREQ_GRP.G_STATUS_UPDATED,
5833: QP_PREQ_GRP.G_STATUS_NEW,
5834: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,
5835: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
5836: QP_PREQ_GRP.G_STATUS_UNCHANGED) and
5837: nvl(p_req_line_tbl(i).processed_code,'0') <> QP_PREQ_PUB.G_BY_ENGINE--????check this one
5838: and p_req_line_tbl(i).price_flag IN ('Y','P')
5839: then
5840: --??? update line's unit price to null in case of error

Line 6081: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

6077: p_api_version IN NUMBER ,
6078: p_init_msg_list IN VARCHAR2 ,
6079: p_CHR_ID IN NUMBER,
6080: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
6081: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
6082: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
6083: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
6084: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
6085: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

Line 6082: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

6078: p_init_msg_list IN VARCHAR2 ,
6079: p_CHR_ID IN NUMBER,
6080: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
6081: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
6082: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
6083: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
6084: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
6085: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
6086: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

Line 6083: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

6079: p_CHR_ID IN NUMBER,
6080: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
6081: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
6082: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
6083: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
6084: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
6085: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
6086: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
6087: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

Line 6084: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

6080: p_Control_Rec IN OKC_CONTROL_REC_TYPE,
6081: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
6082: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
6083: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
6084: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
6085: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
6086: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
6087: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
6088: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,

Line 6085: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

6081: px_req_line_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
6082: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
6083: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
6084: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
6085: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
6086: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
6087: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
6088: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,
6089: x_return_status OUT NOCOPY VARCHAR2,

Line 6086: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

6082: px_Req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
6083: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
6084: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
6085: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
6086: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
6087: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
6088: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,
6089: x_return_status OUT NOCOPY VARCHAR2,
6090: x_msg_count OUT NOCOPY NUMBER,

Line 6087: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

6083: px_Req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
6084: px_Req_LINE_DETAIL_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
6085: px_Req_LINE_DETAIL_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
6086: px_Req_LINE_DETAIL_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
6087: px_Req_RELATED_LINE_TBL IN OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
6088: px_CLE_PRICE_TBL IN OUT NOCOPY CLE_PRICE_TBL_TYPE,
6089: x_return_status OUT NOCOPY VARCHAR2,
6090: x_msg_count OUT NOCOPY NUMBER,
6091: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 6095: l_hdr_prc_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

6091: x_msg_data OUT NOCOPY VARCHAR2) IS
6092:
6093: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
6094: l_api_name constant VARCHAR2(30) := 'CALCULATE PRICE';
6095: l_hdr_prc_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6096: l_hdr_qual_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6097:
6098:
6099: l_line_tbl line_tbl_type;

Line 6096: l_hdr_qual_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

6092:
6093: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
6094: l_api_name constant VARCHAR2(30) := 'CALCULATE PRICE';
6095: l_hdr_prc_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6096: l_hdr_qual_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
6097:
6098:
6099: l_line_tbl line_tbl_type;
6100: l_id_tbl num_tbl_type;

Line 6111: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE:=px_Req_RELATED_LINE_TBL;

6107:
6108: l_pricing_event varchar2(10) := p_control_rec.qp_control_rec.pricing_event;
6109:
6110:
6111: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE:=px_Req_RELATED_LINE_TBL;
6112: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE:=px_req_line_tbl ;
6113: l_pricing_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE := px_Req_line_attr_tbl;
6114: l_qualifiers_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE := px_Req_qual_tbl;
6115: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE:= px_Req_LINE_DETAIL_tbl;

Line 6112: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE:=px_req_line_tbl ;

6108: l_pricing_event varchar2(10) := p_control_rec.qp_control_rec.pricing_event;
6109:
6110:
6111: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE:=px_Req_RELATED_LINE_TBL;
6112: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE:=px_req_line_tbl ;
6113: l_pricing_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE := px_Req_line_attr_tbl;
6114: l_qualifiers_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE := px_Req_qual_tbl;
6115: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE:= px_Req_LINE_DETAIL_tbl;
6116: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE:= px_Req_LINE_DETAIL_qual_tbl;

Line 6113: l_pricing_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE := px_Req_line_attr_tbl;

6109:
6110:
6111: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE:=px_Req_RELATED_LINE_TBL;
6112: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE:=px_req_line_tbl ;
6113: l_pricing_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE := px_Req_line_attr_tbl;
6114: l_qualifiers_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE := px_Req_qual_tbl;
6115: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE:= px_Req_LINE_DETAIL_tbl;
6116: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE:= px_Req_LINE_DETAIL_qual_tbl;
6117: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE:= px_Req_LINE_DETAIL_attr_tbl;

Line 6114: l_qualifiers_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE := px_Req_qual_tbl;

6110:
6111: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE:=px_Req_RELATED_LINE_TBL;
6112: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE:=px_req_line_tbl ;
6113: l_pricing_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE := px_Req_line_attr_tbl;
6114: l_qualifiers_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE := px_Req_qual_tbl;
6115: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE:= px_Req_LINE_DETAIL_tbl;
6116: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE:= px_Req_LINE_DETAIL_qual_tbl;
6117: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE:= px_Req_LINE_DETAIL_attr_tbl;
6118:

Line 6115: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE:= px_Req_LINE_DETAIL_tbl;

6111: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE:=px_Req_RELATED_LINE_TBL;
6112: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE:=px_req_line_tbl ;
6113: l_pricing_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE := px_Req_line_attr_tbl;
6114: l_qualifiers_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE := px_Req_qual_tbl;
6115: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE:= px_Req_LINE_DETAIL_tbl;
6116: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE:= px_Req_LINE_DETAIL_qual_tbl;
6117: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE:= px_Req_LINE_DETAIL_attr_tbl;
6118:
6119: l_prc_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 6116: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE:= px_Req_LINE_DETAIL_qual_tbl;

6112: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE:=px_req_line_tbl ;
6113: l_pricing_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE := px_Req_line_attr_tbl;
6114: l_qualifiers_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE := px_Req_qual_tbl;
6115: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE:= px_Req_LINE_DETAIL_tbl;
6116: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE:= px_Req_LINE_DETAIL_qual_tbl;
6117: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE:= px_Req_LINE_DETAIL_attr_tbl;
6118:
6119: l_prc_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6120: l_qual_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE ;

Line 6117: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE:= px_Req_LINE_DETAIL_attr_tbl;

6113: l_pricing_contexts_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE := px_Req_line_attr_tbl;
6114: l_qualifiers_contexts_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE := px_Req_qual_tbl;
6115: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE:= px_Req_LINE_DETAIL_tbl;
6116: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE:= px_Req_LINE_DETAIL_qual_tbl;
6117: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE:= px_Req_LINE_DETAIL_attr_tbl;
6118:
6119: l_prc_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6120: l_qual_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE ;
6121:

Line 6119: l_prc_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

6115: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE:= px_Req_LINE_DETAIL_tbl;
6116: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE:= px_Req_LINE_DETAIL_qual_tbl;
6117: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE:= px_Req_LINE_DETAIL_attr_tbl;
6118:
6119: l_prc_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6120: l_qual_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE ;
6121:
6122: l_bpi_prc_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6123: l_bpi_qual_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE ;

Line 6120: l_qual_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE ;

6116: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE:= px_Req_LINE_DETAIL_qual_tbl;
6117: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE:= px_Req_LINE_DETAIL_attr_tbl;
6118:
6119: l_prc_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6120: l_qual_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE ;
6121:
6122: l_bpi_prc_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6123: l_bpi_qual_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE ;
6124:

Line 6122: l_bpi_prc_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

6118:
6119: l_prc_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6120: l_qual_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE ;
6121:
6122: l_bpi_prc_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6123: l_bpi_qual_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE ;
6124:
6125: l_index pls_integer;
6126: l_Req_LINE_index number :=null;

Line 6123: l_bpi_qual_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE ;

6119: l_prc_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6120: l_qual_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE ;
6121:
6122: l_bpi_prc_Tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
6123: l_bpi_qual_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE ;
6124:
6125: l_index pls_integer;
6126: l_Req_LINE_index number :=null;
6127: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE:=p_control_rec.qp_control_rec;

Line 6127: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE:=p_control_rec.qp_control_rec;

6123: l_bpi_qual_Tbl QP_PREQ_GRP.QUAL_TBL_TYPE ;
6124:
6125: l_index pls_integer;
6126: l_Req_LINE_index number :=null;
6127: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE:=p_control_rec.qp_control_rec;
6128: l_return_status_text Varchar2(240);
6129: l_okc_control_rec OKC_CONTROL_REC_TYPE := p_control_rec;
6130: l_line_index pls_integer :=0;
6131:

Line 6986: --QP_PREQ_GRP.PRICE_REQUEST

6982: IF (l_debug = 'Y') THEN
6983: my_debug('16924:Before Calling Price Request calculate flag'||l_control_rec.calculate_flag);
6984: END IF;
6985: QP_PREQ_PUB.PRICE_REQUEST
6986: --QP_PREQ_GRP.PRICE_REQUEST
6987: (p_control_rec => l_control_rec
6988: ,p_line_tbl => l_Req_line_tbl
6989: ,p_qual_tbl => l_qualifiers_contexts_tbl
6990: ,p_line_attr_tbl => l_pricing_contexts_tbl

Line 7369: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

7365: l_id number;
7366: l_control_rec OKC_CONTROL_REC_TYPE:= p_control_rec;
7367: l_id_tbl num_tbl_type;
7368: l_cle_price_tbl CLE_PRICE_TBL_TYPE;
7369: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7370: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
7371: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7372: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7373: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 7370: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

7366: l_control_rec OKC_CONTROL_REC_TYPE:= p_control_rec;
7367: l_id_tbl num_tbl_type;
7368: l_cle_price_tbl CLE_PRICE_TBL_TYPE;
7369: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7370: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
7371: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7372: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7373: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7374: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 7371: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

7367: l_id_tbl num_tbl_type;
7368: l_cle_price_tbl CLE_PRICE_TBL_TYPE;
7369: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7370: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
7371: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7372: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7373: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7374: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7375: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 7372: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

7368: l_cle_price_tbl CLE_PRICE_TBL_TYPE;
7369: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7370: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
7371: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7372: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7373: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7374: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7375: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7376: BEGIN

Line 7373: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

7369: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7370: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
7371: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7372: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7373: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7374: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7375: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7376: BEGIN
7377: --dbms_output.put_line('start new get manual adjs');

Line 7374: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

7370: l_req_line_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
7371: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7372: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7373: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7374: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7375: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7376: BEGIN
7377: --dbms_output.put_line('start new get manual adjs');
7378: IF (l_debug = 'Y') THEN

Line 7375: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

7371: l_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7372: l_req_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7373: l_req_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7374: l_req_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7375: l_req_related_line_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7376: BEGIN
7377: --dbms_output.put_line('start new get manual adjs');
7378: IF (l_debug = 'Y') THEN
7379: okc_debug.Set_Indentation('GET_MANUAL_ADJUSTMENTS');