[Home] [Help]
PACKAGE: APPS.AP_INVOICE_LINES_UTILITY_PKG
Source
1 PACKAGE AP_INVOICE_LINES_UTILITY_PKG AS
2 /* $Header: apilnuts.pls 120.13.12010000.2 2008/08/08 03:17:42 sparames ship $ */
3
4 FUNCTION get_encumbered_flag(
5 p_invoice_id IN NUMBER,
6 p_line_number IN NUMBER ) RETURN VARCHAR2;
7
8 FUNCTION get_posting_status(
9 p_invoice_id IN NUMBER,
10 p_line_number IN NUMBER ) RETURN VARCHAR2;
11
12 FUNCTION get_approval_status(
13 p_invoice_id IN NUMBER,
14 p_line_number IN NUMBER) RETURN VARCHAR2;
15
16 FUNCTION Is_Line_Discardable(
17 P_line_rec IN ap_invoice_lines%ROWTYPE,
18 P_error_code OUT NOCOPY VARCHAR2,
19 P_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
20
21 FUNCTION Allocation_Exists (p_Invoice_Id Number,
22 p_Line_Number Number,
23 p_Calling_Sequence Varchar2) RETURN BOOLEAN;
24 FUNCTION Inv_Reversed_Via_Qc (p_Invoice_Id Number,
25 p_Calling_Sequence Varchar2) RETURN BOOLEAN;
26
27 FUNCTION Is_Line_Dists_Trans_FA (p_Invoice_Id Number,
28 p_Line_Number Number,
29 p_Calling_Sequence Varchar2) RETURN BOOLEAN;
30 FUNCTION Line_Dists_Acct_Event_Created (p_Invoice_Id Number,
31 p_Line_Number Number,
32 p_Calling_Sequence Varchar2) RETURN BOOLEAN;
33
34 FUNCTION Line_Referred_By_Corr (p_Invoice_Id Number,
35 p_Line_Number Number,
36 p_Calling_Sequence Varchar2) RETURN BOOLEAN;
37
38 FUNCTION Line_Dists_Referred_By_Other(p_Invoice_Id Number,
39 p_Line_Number Number,
40 p_Calling_Sequence Varchar2) RETURN BOOLEAN;
41
42 FUNCTION Outstanding_Alloc_Exists (p_Invoice_Id Number,
43 p_Line_Number Number,
44 p_Calling_Sequence Varchar2) RETURN BOOLEAN;
45
46 FUNCTION Line_Dists_Trans_Pa (p_Invoice_Id Number,
47 p_Line_Number Number,
48 p_Calling_Sequence Varchar2) RETURN BOOLEAN;
49
50 FUNCTION Can_Line_Be_Deleted (p_line_rec IN ap_invoice_lines%ROWTYPE,
51 p_error_code OUT NOCOPY Varchar2,
52 p_Calling_Sequence Varchar2) RETURN BOOLEAN;
53
54 FUNCTION Get_Packet_Id (p_invoice_id In Number,
55 p_Line_Number In Number) RETURN NUMBER;
56
57 FUNCTION Is_Line_Fully_Distributed(
58 P_Invoice_Id IN NUMBER,
59 P_Line_Number IN NUMBER,
60 P_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
61
62 FUNCTION Is_PO_RCV_Amount_Exceeded(
63 P_Invoice_Id IN NUMBER,
64 P_Line_Number IN NUMBER,
65 P_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
66
67 FUNCTION Is_Invoice_Fully_Distributed (
68 P_invoice_id IN NUMBER) RETURN BOOLEAN;
69
70 --Invoice Lines: Distributions
71 FUNCTION Pending_Alloc_Exists_Chrg_Line
72 (p_Invoice_Id Number,
73 p_Line_Number Number,
74 p_Calling_Sequence Varchar2) Return BOOLEAN ;
75
76 --ETAX: Invwkb
77 FUNCTION Is_Line_a_Correction(
78 P_Invoice_Id IN NUMBER,
79 P_Line_Number IN NUMBER,
80 P_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
81
82 FUNCTION Line_Referred_By_Adjustment(
83 P_Invoice_Id IN NUMBER,
84 P_Line_Number IN NUMBER,
85 P_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
86
87 FUNCTION Is_Line_a_Adjustment(
88 P_Invoice_Id IN NUMBER,
89 P_Line_Number IN NUMBER,
90 P_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
91
92 FUNCTION Is_Line_a_Prepay(
93 P_Invoice_Id IN NUMBER,
94 P_Line_Number IN NUMBER,
95 P_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
96
97 Function Get_Retained_Amount
98 (p_line_location_id IN NUMBER,
99 p_match_amount IN NUMBER) RETURN NUMBER;
100
101 -- Bug 6917289
102 PROCEDURE Manual_Withhold_Tax(p_invoice_id IN number
103 ,p_manual_withhold_amount IN number);
104
105 -- Bug 6917289
106 FUNCTION get_awt_flag(
107 p_invoice_id IN NUMBER,
108 p_line_number IN NUMBER ) RETURN VARCHAR2;
109
110 END AP_INVOICE_LINES_UTILITY_PKG;
111