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.PO_ADVANCED_PRICE_PVT dependencies on QP_PREQ_LINES_TMP

Line 472: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;

468: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
469: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
470: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
471:
472: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;
473: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;
474:
475: --
476: l_return_status VARCHAR2(1);

Line 473: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;

469: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
470: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
471:
472: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;
473: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;
474:
475: --
476: l_return_status VARCHAR2(1);
477: l_msg_count NUMBER;

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

873: l_progress := '240';
874: IF g_debug_stmt THEN
875: PO_DEBUG.debug_stmt(l_log_head, l_progress,'Fetch QP pricing');
876: PO_DEBUG.debug_var(l_log_head, l_progress, 'l_line_id', l_line_id);
877: PO_DEBUG.debug_table(l_log_head, l_progress, 'QP_PREQ_LINES_TMP_T', PO_DEBUG.g_all_rows, NULL, 'QP');
878: END IF;
879:
880: /* Use API insted
881: -- SQL What: Fetch Price from Pricing Temp table

Line 891: FROM QP_PREQ_LINES_TMP

887: INTO x_base_unit_price,
888: x_unit_price,
889: l_price_status_code,
890: l_price_status_text
891: FROM QP_PREQ_LINES_TMP
892: WHERE line_id = l_line_id
893: AND (processed_code IS NULL OR processed_code <> 'INVALID');
894: */
895:

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

1600: IF g_debug_stmt THEN
1601: PO_LOG.stmt(l_log_head, d_pos,'Fetch QP pricing');
1602: PO_LOG.stmt(l_log_head, d_pos, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);
1603: PO_LOG.stmt(l_log_head, d_pos, 'p_header_rec.shipment_header_id', p_header_rec.shipment_header_id);
1604: PO_LOG.stmt(l_log_head, d_pos, 'QP_PREQ_LINES_TMP_T', PO_LOG.c_all_rows);
1605: END IF;
1606:
1607: IF p_return_price_flag THEN
1608: --Access the QP views to retrieve the values for price

Line 1627: FROM qp_preq_lines_tmp

1623: x_price_tbl(j).base_unit_price,
1624: x_price_tbl(j).adjusted_price,
1625: x_price_tbl(j).pricing_status_code,
1626: x_price_tbl(j).pricing_status_text
1627: FROM qp_preq_lines_tmp
1628: WHERE line_index = j;
1629:
1630: d_pos := 260;
1631:

Line 1664: qp_preq_lines_tmp WHERE line_index = j;

1660: SELECT pricing_status_code, pricing_status_text INTO
1661: x_price_tbl(j).pricing_status_code,
1662: x_price_tbl(j).pricing_status_text
1663: FROM
1664: qp_preq_lines_tmp WHERE line_index = j;
1665: d_pos := 290;
1666: END LOOP;
1667: END IF;
1668:

Line 1882: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;

1878: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1879: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1880: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
1881:
1882: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;
1883: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;
1884:
1885: l_return_status VARCHAR2(1);
1886: l_msg_count NUMBER;

Line 1883: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;

1879: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1880: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
1881:
1882: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;
1883: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;
1884:
1885: l_return_status VARCHAR2(1);
1886: l_msg_count NUMBER;
1887: l_msg_data VARCHAR2(2000);

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

2190: l_progress := '240';
2191: IF g_debug_stmt THEN
2192: PO_DEBUG.debug_stmt(l_log_head, l_progress,'The QP call is made successfully. The Manual modifiers can be fetched from QP temp tables');
2193: PO_DEBUG.debug_var(l_log_head, l_progress, 'l_line_id', l_line_id);
2194: PO_DEBUG.debug_table(l_log_head, l_progress, 'QP_PREQ_LINES_TMP_T', PO_DEBUG.g_all_rows, NULL, 'QP');
2195: END IF;
2196:
2197: l_progress := '300';
2198: IF g_debug_stmt THEN