APPS.PO_ADVANCED_PRICE_PVT dependencies on PO_LINE_TYPES

Line 1014: l_purchase_basis PO_LINE_TYPES.purchase_basis%TYPE;

1010: IS
1011: l_api_name CONSTANT VARCHAR2(30) := 'IS_VALID_QP_LINE_TYPE';
1012: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1013: l_progress VARCHAR2(3) := '000';
1014: l_purchase_basis PO_LINE_TYPES.purchase_basis%TYPE;
1015: -- Bug 3343261: should use value_basis instead of matching_basis
1016: -- l_matching_basis PO_LINE_TYPES.matching_basis%TYPE;
1017: l_value_basis PO_LINE_TYPES.order_type_lookup_code%TYPE;
1018: BEGIN

Line 1016: -- l_matching_basis PO_LINE_TYPES.matching_basis%TYPE;

1012: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1013: l_progress VARCHAR2(3) := '000';
1014: l_purchase_basis PO_LINE_TYPES.purchase_basis%TYPE;
1015: -- Bug 3343261: should use value_basis instead of matching_basis
1016: -- l_matching_basis PO_LINE_TYPES.matching_basis%TYPE;
1017: l_value_basis PO_LINE_TYPES.order_type_lookup_code%TYPE;
1018: BEGIN
1019: IF g_debug_stmt THEN
1020: PO_DEBUG.debug_begin(l_log_head);

Line 1017: l_value_basis PO_LINE_TYPES.order_type_lookup_code%TYPE;

1013: l_progress VARCHAR2(3) := '000';
1014: l_purchase_basis PO_LINE_TYPES.purchase_basis%TYPE;
1015: -- Bug 3343261: should use value_basis instead of matching_basis
1016: -- l_matching_basis PO_LINE_TYPES.matching_basis%TYPE;
1017: l_value_basis PO_LINE_TYPES.order_type_lookup_code%TYPE;
1018: BEGIN
1019: IF g_debug_stmt THEN
1020: PO_DEBUG.debug_begin(l_log_head);
1021: PO_DEBUG.debug_var(l_log_head, l_progress, 'p_line_type_id', p_line_type_id);

Line 1037: FROM PO_LINE_TYPES

1033: INTO l_purchase_basis,
1034: -- Bug 3343261: should use value_basis instead of matching_basis
1035: -- l_matching_basis,
1036: l_value_basis
1037: FROM PO_LINE_TYPES
1038: WHERE line_type_id = p_line_type_id;
1039:
1040: l_progress := '020';
1041: IF g_debug_stmt THEN