APPS.PO_LINES_SV4 dependencies on PO_LINES

Line 1: PACKAGE BODY PO_LINES_SV4 as

1: PACKAGE BODY PO_LINES_SV4 as
2: /* $Header: POXPOL4B.pls 120.2.12020000.2 2013/02/10 13:12:22 vegajula ship $ */
3:
4: /*============================= PO_LINES_SV4 ==============================*/
5:

Line 4: /*============================= PO_LINES_SV4 ==============================*/

1: PACKAGE BODY PO_LINES_SV4 as
2: /* $Header: POXPOL4B.pls 120.2.12020000.2 2013/02/10 13:12:22 vegajula ship $ */
3:
4: /*============================= PO_LINES_SV4 ==============================*/
5:
6: --Global Variables
7:
8: g_org_id NUMBER; --

Line 20: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

16:
17: =============================================================================*/
18: FUNCTION get_line_num
19: (
20: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
21: )
22: RETURN PO_LINES_ALL.line_num%TYPE
23: IS
24: x_line_num PO_LINES_ALL.line_num%TYPE;

Line 22: RETURN PO_LINES_ALL.line_num%TYPE

18: FUNCTION get_line_num
19: (
20: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
21: )
22: RETURN PO_LINES_ALL.line_num%TYPE
23: IS
24: x_line_num PO_LINES_ALL.line_num%TYPE;
25: BEGIN
26:

Line 24: x_line_num PO_LINES_ALL.line_num%TYPE;

20: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
21: )
22: RETURN PO_LINES_ALL.line_num%TYPE
23: IS
24: x_line_num PO_LINES_ALL.line_num%TYPE;
25: BEGIN
26:
27: SELECT line_num
28: INTO x_line_num

Line 29: FROM po_lines_all

25: BEGIN
26:
27: SELECT line_num
28: INTO x_line_num
29: FROM po_lines_all
30: WHERE po_line_id = p_po_line_id;
31:
32: return (x_line_num);
33:

Line 52: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

48:
49: =============================================================================*/
50: FUNCTION is_cumulative_pricing
51: (
52: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
53: )
54: RETURN BOOLEAN
55: IS
56: l_price_break_lookup_code PO_LINES_ALL.price_break_lookup_code%TYPE;

Line 56: l_price_break_lookup_code PO_LINES_ALL.price_break_lookup_code%TYPE;

52: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
53: )
54: RETURN BOOLEAN
55: IS
56: l_price_break_lookup_code PO_LINES_ALL.price_break_lookup_code%TYPE;
57: BEGIN
58:
59: SELECT price_break_lookup_code
60: INTO l_price_break_lookup_code

Line 61: FROM po_lines_all

57: BEGIN
58:
59: SELECT price_break_lookup_code
60: INTO l_price_break_lookup_code
61: FROM po_lines_all
62: WHERE po_line_id = p_po_line_id;
63:
64: IF ( l_price_break_lookup_code = 'CUMULATIVE' ) THEN
65: return(TRUE);

Line 96: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

92: -- Exceptions : -
93: --=============================================================================
94: FUNCTION effective_dates_exist
95: (
96: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
97: )
98: RETURN BOOLEAN
99: IS
100: l_count NUMBER;

Line 139: p_po_line_id PO_LINES_ALL.po_line_id%TYPE

135: -- Exceptions : -
136: --=============================================================================
137: FUNCTION allow_price_override
138: (
139: p_po_line_id PO_LINES_ALL.po_line_id%TYPE
140: )
141: RETURN BOOLEAN
142: IS
143: l_allow_price_override_flag PO_LINES_ALL.allow_price_override_flag%TYPE;

Line 143: l_allow_price_override_flag PO_LINES_ALL.allow_price_override_flag%TYPE;

139: p_po_line_id PO_LINES_ALL.po_line_id%TYPE
140: )
141: RETURN BOOLEAN
142: IS
143: l_allow_price_override_flag PO_LINES_ALL.allow_price_override_flag%TYPE;
144: BEGIN
145:
146: SELECT allow_price_override_flag
147: INTO l_allow_price_override_flag

Line 148: FROM po_lines_all

144: BEGIN
145:
146: SELECT allow_price_override_flag
147: INTO l_allow_price_override_flag
148: FROM po_lines_all
149: WHERE po_line_id = p_po_line_id;
150:
151: IF ( l_allow_price_override_flag = 'Y' )
152: THEN

Line 380: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;

376: X_progress varchar2(3);
377: X_row_exists number := 0;
378:
379: l_is_global_agreement BOOLEAN; --
380: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
381: X_amount_received NUMBER;
382: X_amount_billed NUMBER;
383:
384: --

Line 501: from po_lines_all

497:
498: X_Progress := '100';
499: Select order_type_lookup_code
500: into l_value_basis
501: from po_lines_all
502: where po_line_id = X_po_line_id;
503:
504: --
505: X_Progress := '110';

Line 615: po_message_s.sql_error('PO_LINES_SV4','get_ship_quantity_info',

611: EXCEPTION
612:
613: WHEN OTHERS THEN
614: -- dbms_output.put_line('In exception');
615: po_message_s.sql_error('PO_LINES_SV4','get_ship_quantity_info',
616: x_progress, sqlcode, sqlerrm);
617: RAISE;
618:
619:

Line 704: FROM po_lines

700: X_progress := '020';
701:
702: SELECT line_num
703: INTO X_quotation_line
704: FROM po_lines
705: WHERE po_line_id = X_from_line_id;
706:
707: EXCEPTION
708:

Line 886: from po_lines

882: BEGIN
883:
884: select po_line_id, item_id
885: into x_po_line_id_record.po_line_id, X_po_line_id_record.item_id
886: from po_lines
887: where po_header_id = X_po_line_id_record.po_header_id and
888: line_num = X_po_line_id_record.document_line_num;
889:
890: if (x_po_line_id_record.po_line_id is null) then

Line 988: This function will be called in the query of the view po_lines_v.

984: end get_om_uom_tl;
985:
986: /*
987: Bug 8247574: Introduced the below function to fetch inventory_org_id.
988: This function will be called in the query of the view po_lines_v.
989: This is done for performance gains.
990: */
991:
992: /**

Line 1037: END PO_LINES_SV4;

1033: END IF;
1034: RETURN l_inv_org_id;
1035: END;
1036:
1037: END PO_LINES_SV4;