APPS.PO_LINES_SV4 dependencies on PO_LINES_ALL

Line 15: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

11:
12: =============================================================================*/
13: FUNCTION get_line_num
14: (
15: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
16: )
17: RETURN PO_LINES_ALL.line_num%TYPE
18: IS
19: x_line_num PO_LINES_ALL.line_num%TYPE;

Line 17: RETURN PO_LINES_ALL.line_num%TYPE

13: FUNCTION get_line_num
14: (
15: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
16: )
17: RETURN PO_LINES_ALL.line_num%TYPE
18: IS
19: x_line_num PO_LINES_ALL.line_num%TYPE;
20: BEGIN
21:

Line 19: x_line_num PO_LINES_ALL.line_num%TYPE;

15: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
16: )
17: RETURN PO_LINES_ALL.line_num%TYPE
18: IS
19: x_line_num PO_LINES_ALL.line_num%TYPE;
20: BEGIN
21:
22: SELECT line_num
23: INTO x_line_num

Line 24: FROM po_lines_all

20: BEGIN
21:
22: SELECT line_num
23: INTO x_line_num
24: FROM po_lines_all
25: WHERE po_line_id = p_po_line_id;
26:
27: return (x_line_num);
28:

Line 47: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

43:
44: =============================================================================*/
45: FUNCTION is_cumulative_pricing
46: (
47: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
48: )
49: RETURN BOOLEAN
50: IS
51: l_price_break_lookup_code PO_LINES_ALL.price_break_lookup_code%TYPE;

Line 51: l_price_break_lookup_code PO_LINES_ALL.price_break_lookup_code%TYPE;

47: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
48: )
49: RETURN BOOLEAN
50: IS
51: l_price_break_lookup_code PO_LINES_ALL.price_break_lookup_code%TYPE;
52: BEGIN
53:
54: SELECT price_break_lookup_code
55: INTO l_price_break_lookup_code

Line 56: FROM po_lines_all

52: BEGIN
53:
54: SELECT price_break_lookup_code
55: INTO l_price_break_lookup_code
56: FROM po_lines_all
57: WHERE po_line_id = p_po_line_id;
58:
59: IF ( l_price_break_lookup_code = 'CUMULATIVE' ) THEN
60: return(TRUE);

Line 91: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE

87: -- Exceptions : -
88: --=============================================================================
89: FUNCTION effective_dates_exist
90: (
91: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
92: )
93: RETURN BOOLEAN
94: IS
95: l_count NUMBER;

Line 134: p_po_line_id PO_LINES_ALL.po_line_id%TYPE

130: -- Exceptions : -
131: --=============================================================================
132: FUNCTION allow_price_override
133: (
134: p_po_line_id PO_LINES_ALL.po_line_id%TYPE
135: )
136: RETURN BOOLEAN
137: IS
138: l_allow_price_override_flag PO_LINES_ALL.allow_price_override_flag%TYPE;

Line 138: l_allow_price_override_flag PO_LINES_ALL.allow_price_override_flag%TYPE;

134: p_po_line_id PO_LINES_ALL.po_line_id%TYPE
135: )
136: RETURN BOOLEAN
137: IS
138: l_allow_price_override_flag PO_LINES_ALL.allow_price_override_flag%TYPE;
139: BEGIN
140:
141: SELECT allow_price_override_flag
142: INTO l_allow_price_override_flag

Line 143: FROM po_lines_all

139: BEGIN
140:
141: SELECT allow_price_override_flag
142: INTO l_allow_price_override_flag
143: FROM po_lines_all
144: WHERE po_line_id = p_po_line_id;
145:
146: IF ( l_allow_price_override_flag = 'Y' )
147: THEN

Line 375: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;

371: X_progress varchar2(3);
372: X_row_exists number := 0;
373:
374: l_is_global_agreement BOOLEAN; --
375: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
376: X_amount_received NUMBER;
377: X_amount_billed NUMBER;
378:
379: --

Line 496: from po_lines_all

492:
493: X_Progress := '100';
494: Select order_type_lookup_code
495: into l_value_basis
496: from po_lines_all
497: where po_line_id = X_po_line_id;
498:
499: --
500: X_Progress := '110';