DBA Data[Home] [Help]

APPS.PO_ADVANCED_PRICE_PVT dependencies on PO_LINE_TYPES

Line 929: l_purchase_basis PO_LINE_TYPES.purchase_basis%TYPE;

925: IS
926: l_api_name CONSTANT varchar2(30) := 'IS_VALID_QP_LINE_TYPE';
927: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;
928: l_progress VARCHAR2(3) := '000';
929: l_purchase_basis PO_LINE_TYPES.purchase_basis%TYPE;
930: -- Bug 3343261: should use value_basis instead of matching_basis
931: -- l_matching_basis PO_LINE_TYPES.matching_basis%TYPE;
932: l_value_basis PO_LINE_TYPES.order_type_lookup_code%TYPE;
933: BEGIN

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

927: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;
928: l_progress VARCHAR2(3) := '000';
929: l_purchase_basis PO_LINE_TYPES.purchase_basis%TYPE;
930: -- Bug 3343261: should use value_basis instead of matching_basis
931: -- l_matching_basis PO_LINE_TYPES.matching_basis%TYPE;
932: l_value_basis PO_LINE_TYPES.order_type_lookup_code%TYPE;
933: BEGIN
934: IF g_debug_stmt THEN
935: PO_DEBUG.debug_begin(l_log_head);

Line 932: l_value_basis PO_LINE_TYPES.order_type_lookup_code%TYPE;

928: l_progress VARCHAR2(3) := '000';
929: l_purchase_basis PO_LINE_TYPES.purchase_basis%TYPE;
930: -- Bug 3343261: should use value_basis instead of matching_basis
931: -- l_matching_basis PO_LINE_TYPES.matching_basis%TYPE;
932: l_value_basis PO_LINE_TYPES.order_type_lookup_code%TYPE;
933: BEGIN
934: IF g_debug_stmt THEN
935: PO_DEBUG.debug_begin(l_log_head);
936: PO_DEBUG.debug_var(l_log_head,l_progress,'p_line_type_id',p_line_type_id);

Line 952: FROM PO_LINE_TYPES

948: INTO l_purchase_basis,
949: -- Bug 3343261: should use value_basis instead of matching_basis
950: -- l_matching_basis,
951: l_value_basis
952: FROM PO_LINE_TYPES
953: WHERE line_type_id = p_line_type_id;
954:
955: l_progress := '020';
956: IF g_debug_stmt THEN