DBA Data[Home] [Help]

APPS.PO_LINES_SV4 dependencies on PO_LINES_ALL

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';