APPS.PO_ADVANCED_PRICE_PVT dependencies on QP_PREQ_LINES_TMP

Line 454: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;

450: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
451: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
452: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
453:
454: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;
455: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;
456:
457: --
458: l_return_status VARCHAR2(1);

Line 455: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;

451: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
452: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
453:
454: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;
455: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;
456:
457: --
458: l_return_status VARCHAR2(1);
459: l_msg_count NUMBER;

Line 792: PO_DEBUG.debug_table(l_log_head,l_progress,'QP_PREQ_LINES_TMP_T',PO_DEBUG.g_all_rows,NULL,'QP');

788: l_progress := '240';
789: IF g_debug_stmt THEN
790: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Fetch QP pricing');
791: PO_DEBUG.debug_var(l_log_head,l_progress,'l_line_id',l_line_id);
792: PO_DEBUG.debug_table(l_log_head,l_progress,'QP_PREQ_LINES_TMP_T',PO_DEBUG.g_all_rows,NULL,'QP');
793: END IF;
794:
795: /* Use API insted
796: -- SQL What: Fetch Price from Pricing Temp table

Line 806: FROM QP_PREQ_LINES_TMP

802: INTO x_base_unit_price,
803: x_unit_price,
804: l_price_status_code,
805: l_price_status_text
806: FROM QP_PREQ_LINES_TMP
807: WHERE line_id = l_line_id
808: AND (processed_code IS NULL OR processed_code <> 'INVALID');
809: */
810:

Line 1517: PO_LOG.stmt(l_log_head,d_pos,'QP_PREQ_LINES_TMP_T',PO_LOG.c_all_rows);

1513: IF g_debug_stmt THEN
1514: PO_LOG.stmt(l_log_head,d_pos,'Fetch QP pricing');
1515: PO_LOG.stmt(l_log_head,d_pos,'p_header_rec.p_order_header_id',p_header_rec.p_order_header_id);
1516: PO_LOG.stmt(l_log_head,d_pos,'p_header_rec.shipment_header_id',p_header_rec.shipment_header_id);
1517: PO_LOG.stmt(l_log_head,d_pos,'QP_PREQ_LINES_TMP_T',PO_LOG.c_all_rows);
1518: END IF;
1519:
1520: if p_return_price_flag then
1521: --Access the QP views to retrieve the values for price

Line 1540: from qp_preq_lines_tmp

1536: x_price_tbl(j).base_unit_price,
1537: x_price_tbl(j).adjusted_price,
1538: x_price_tbl(j).pricing_status_code,
1539: x_price_tbl(j).pricing_status_text
1540: from qp_preq_lines_tmp
1541: where line_index = j;
1542:
1543: d_pos := 260;
1544:

Line 1577: qp_preq_lines_tmp where line_index =j;

1573: select pricing_status_code, pricing_status_text into
1574: x_price_tbl(j).pricing_status_code,
1575: x_price_tbl(j).pricing_status_text
1576: from
1577: qp_preq_lines_tmp where line_index =j;
1578: d_pos := 290;
1579: END LOOP;
1580: End if;
1581: