DBA Data[Home] [Help]

APPS.QP_PREQ_PUB dependencies on QP_LIST_LINES

Line 287: qp_list_lines qpl WHERE qpl.list_line_id = to_number(attr.value_from))

283: --fix for bug 2374591 ask for promotions not getting applied
284: --updating the list_header_id in the attribute where list_line_id is passed
285: UPDATE qp_npreq_line_attrs_tmp attr SET attr.list_header_id =
286: (SELECT qpl.list_header_id FROM
287: qp_list_lines qpl WHERE qpl.list_line_id = to_number(attr.value_from))
288: WHERE attr.context = 'MODLIST'
289: AND attribute = 'QUALIFIER_ATTRIBUTE2'
290: AND pricing_status_code = 'X';
291:

Line 792: p_list_line_type_code IN QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE

788: null;
789: END Determine_svc_item_quantity;
790:
791: PROCEDURE CALCULATE_BUCKET_PRICE(
792: p_list_line_type_code IN QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE
793: , p_price IN NUMBER
794: , p_priced_quantity NUMBER := 1
795: , p_operand_calculation_code IN QP_LIST_LINES.ARITHMETIC_OPERATOR%TYPE
796: , p_operand_value IN NUMBER

Line 795: , p_operand_calculation_code IN QP_LIST_LINES.ARITHMETIC_OPERATOR%TYPE

791: PROCEDURE CALCULATE_BUCKET_PRICE(
792: p_list_line_type_code IN QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE
793: , p_price IN NUMBER
794: , p_priced_quantity NUMBER := 1
795: , p_operand_calculation_code IN QP_LIST_LINES.ARITHMETIC_OPERATOR%TYPE
796: , p_operand_value IN NUMBER
797: , x_calc_adjustment OUT NOCOPY NUMBER
798: , x_return_status OUT NOCOPY VARCHAR2 --DEFAULT FND_API.G_RET_STS_SUCCESS
799: , x_return_status_text OUT NOCOPY VARCHAR2)

Line 2888: qp_list_lines ql

2884: qp_price_req_sources req,
2885: qp_list_headers_b lhdr,
2886: qp_npreq_line_attrs_tmp lattr,
2887: qp_pricing_attributes qpa,
2888: qp_list_lines ql
2889: WHERE lattr.line_index = line.line_index
2890: AND lattr.pricing_status_code IN
2891: (G_STATUS_NEW, G_STATUS_UNCHANGED)
2892: AND lattr.attribute_type = G_PRODUCT_TYPE

Line 2933: qp_list_lines ql

2929: qp_price_req_sources_v req,
2930: qp_list_headers_b lhdr,
2931: qp_npreq_line_attrs_tmp lattr,
2932: qp_pricing_attributes qpa,
2933: qp_list_lines ql
2934: WHERE lattr.line_index = line.line_index
2935: AND lattr.pricing_status_code IN
2936: (G_STATUS_NEW, G_STATUS_UNCHANGED)
2937: AND lattr.attribute_type = G_PRODUCT_TYPE

Line 4223: FROM qp_list_lines

4219: WHERE pricing_status_code = G_STATUS_NEW;
4220:
4221: CURSOR l_net_amount_flag_cur (p_list_line_id NUMBER) IS
4222: SELECT net_amount_flag
4223: FROM qp_list_lines
4224: WHERE list_line_id = p_list_line_id;
4225:
4226:
4227: Calculate_Exc EXCEPTION;

Line 4583: -- obtain net_adj_amount_flag from qp_list_lines table if null,

4579: WHILE J IS NOT NULL
4580: LOOP
4581:
4582: -- begin 2892848
4583: -- obtain net_adj_amount_flag from qp_list_lines table if null,
4584: -- since it may not be passed from calling application
4585: IF l_adj_tbl(j).net_amount_flag IS NULL THEN -- get it from setup just in case
4586: OPEN l_net_amount_flag_cur(l_adj_tbl(j).created_from_list_line_id);
4587: FETCH l_net_amount_flag_cur INTO l_adj_tbl(j).net_amount_flag;

Line 5389: -- obtain net_adj_amount_flag from qp_list_lines table if null,

5385: END IF; --G_pbhvolattr_attribute.exists
5386: END IF; --modifier level code
5387:
5388: /* out 2892848
5389: -- obtain net_adj_amount_flag from qp_list_lines table if null,
5390: -- since it may not be passed from calling application
5391: -- net_amount_new 2720717
5392: IF l_adj_tbl(j).net_amount_flag IS NULL THEN
5393: OPEN l_net_amount_flag_cur(l_adj_tbl(j).created_from_list_line_id);

Line 7352: FROM qp_list_lines

7348:
7349: -- net_amount 2720717
7350: CURSOR l_net_amount_flag_cur (p_list_line_id NUMBER) IS
7351: SELECT net_amount_flag
7352: FROM qp_list_lines
7353: WHERE list_line_id = p_list_line_id;
7354:
7355: l_bucket_price_rec l_bucket_price_cur%ROWTYPE;
7356: l_line_rec l_line_cur%ROWTYPE;

Line 7598: -- obtain net_adj_amount_flag from qp_list_lines table if null,

7594: EXIT WHEN l_bucket_price_cur%NOTFOUND;
7595:
7596: -- begin 2892848
7597: -- ASK PRIYA see if there is a way to tell if line is from calling application???
7598: -- obtain net_adj_amount_flag from qp_list_lines table if null,
7599: -- since it may not be passed from calling application
7600: IF l_bucket_price_rec.net_amount_flag IS NULL THEN -- get it from setup just in case
7601: OPEN l_net_amount_flag_cur(l_bucket_price_rec.created_from_list_line_id);
7602: FETCH l_net_amount_flag_cur INTO l_bucket_price_rec.net_amount_flag;

Line 8212: -- obtain net_adj_amount_flag from qp_list_lines table if null,

8208: || l_pbh_pricing_attr ||' l_total_value '|| l_total_value
8209: ||' l_req_value_per_unit '|| l_req_value_per_unit);
8210: END IF; --l_debug
8211:
8212: -- obtain net_adj_amount_flag from qp_list_lines table if null,
8213: -- since it may not be passed from calling application
8214: -- net_amount_new 2720717
8215: IF l_bucket_price_rec.net_amount_flag IS NULL THEN
8216: OPEN l_net_amount_flag_cur(l_bucket_price_rec.created_from_list_line_id);

Line 9206: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_LINES_PK,LIST_LINE_ID,1

9202: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_TYPE_CODE,3
9203: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,SOURCE_SYSTEM_CODE,4
9204: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_HEADER_ID,5
9205: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,GSA_INDICATOR,6
9206: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_LINES_PK,LIST_LINE_ID,1
9207: */
9208: IF l_debug = FND_API.G_TRUE THEN
9209: QP_PREQ_GRP.engine_debug('Pub GSA attr_mgr_installed '
9210: || G_ATTR_MGR_INSTALLED);

Line 9237: qp_list_lines ql

9233: FROM qp_npreq_line_attrs_tmp lattr,
9234: qp_pricing_attributes qpa,
9235: qp_list_headers_b lhdr, --7323912
9236: qp_price_req_sources req, --7323912
9237: qp_list_lines ql
9238: WHERE lattr.line_index = line.line_index
9239: AND lattr.attribute_type = G_PRODUCT_TYPE
9240: AND lattr.context = qpa.product_attribute_context
9241: AND lattr.attribute = qpa.product_attribute

Line 9291: qp_list_lines ql

9287: FROM qp_npreq_line_attrs_tmp lattr,
9288: qp_pricing_attributes qpa,
9289: qp_list_headers_b lhdr, --7323912
9290: qp_price_req_sources_v req, --7323912
9291: qp_list_lines ql
9292: WHERE lattr.line_index = line.line_index
9293: AND lattr.attribute_type = G_PRODUCT_TYPE
9294: AND lattr.context = qpa.product_attribute_context
9295: AND lattr.attribute = qpa.product_attribute

Line 12524: FROM qp_npreq_ldets_tmp ldet, qp_npreq_line_attrs_tmp lattr, qp_list_lines qpl

12520: , ldet.accrual_flag
12521: , qpl.accrual_conversion_rate
12522: , qpl.estim_accrual_rate
12523: -- , qpl.benefit_qty
12524: FROM qp_npreq_ldets_tmp ldet, qp_npreq_line_attrs_tmp lattr, qp_list_lines qpl
12525: WHERE ldet.pricing_phase_id > 1
12526: AND ldet.pricing_status_code = G_STATUS_NEW
12527: AND ldet.line_index > -1
12528: AND ldet.created_from_list_line_type IN ('DIS', 'SUR', 'FREIGHT_CHARGE',

Line 12675: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1

12671: ORDER_UOM_SELLING_PRICE
12672: FROM QP_INT_LINES;
12673:
12674: /*
12675: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
12676: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_INT_LDETS_N4,PRICING_STATUS_CODE,1
12677: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
12678: */
12679: CURSOR l_ldets_cur(p_line_index NUMBER) IS

Line 12738: QP_LIST_LINES b

12734: b.COMMENTS,
12735: a.ORDER_QTY_OPERAND,
12736: a.ORDER_QTY_ADJ_AMT
12737: FROM QP_INT_LDETS a,
12738: QP_LIST_LINES b
12739: WHERE a.line_index = p_line_index
12740: AND a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID
12741: AND a.PRICING_STATUS_CODE = G_STATUS_NEW;
12742:

Line 12917: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1

12913: SERVICE_PERIOD
12914: FROM qp_npreq_lines_tmp;
12915:
12916: /*
12917: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
12918: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1
12919: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
12920: */
12921: CURSOR l_ldets_cur(p_line_index NUMBER) IS

Line 12982: QP_LIST_LINES b

12978: b.COMMENTS,
12979: a.ORDER_QTY_OPERAND,
12980: a.ORDER_QTY_ADJ_AMT
12981: FROM qp_npreq_ldets_tmp a,
12982: QP_LIST_LINES b
12983: WHERE a.line_index = p_line_index
12984: AND a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID
12985: AND a.PRICING_STATUS_CODE = G_STATUS_NEW;
12986:

Line 13189: QP_LIST_LINES A

13185: --3169430
13186: CURSOR modifier_exists IS
13187: SELECT 'X'
13188: FROM
13189: QP_LIST_LINES A
13190: WHERE A.PRICING_PHASE_ID >1
13191: AND modifier_level_code IN ('LINE', 'LINEGROUP', 'ORDER')
13192: AND ROWNUM = 1;
13193:

Line 14678: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_LIST_LINES_PK,LIST_LINE_ID,1

14674: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
14675: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
14676: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
14677: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
14678: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_LIST_LINES_PK,LIST_LINE_ID,1
14679: */
14680: SELECT MIN(qpll.operand) INTO l_operand
14681: FROM
14682: QP_QUALIFIERS qpq,

Line 14684: QP_LIST_LINES qpll,

14680: SELECT MIN(qpll.operand) INTO l_operand
14681: FROM
14682: QP_QUALIFIERS qpq,
14683: QP_PRICING_ATTRIBUTES qppa,
14684: QP_LIST_LINES qpll,
14685: QP_LIST_HEADERS_B qplh,
14686: QP_PRICE_REQ_SOURCES_V qpprs
14687: WHERE
14688: qpq.qualifier_context = 'CUSTOMER' AND