1 PACKAGE FV_AP_PREPAY_PKG_PVT AS
2 -- $Header: FVAPPFRS.pls 120.0 2003/09/15 21:37:01 snama noship $
3
4 ---------------------------------------------------------------------------
5 ---------------------------------------------------------------------------
6 -- Public Procedure Specification
7 ---------------------------------------------------------------------------
8 ---------------------------------------------------------------------------
9
10 PROCEDURE Funds_Check(p_invoice_id IN NUMBER,
11 p_dist_line_num IN NUMBER,
12 p_return_message_name IN OUT NOCOPY VARCHAR2,
13 p_calling_sequence IN VARCHAR2);
14
15 PROCEDURE Funds_Reserve(p_invoice_id IN NUMBER,
16 p_unique_packet_id_per IN VARCHAR2,
17 p_set_of_books_id IN NUMBER,
18 p_base_currency_code IN VARCHAR2,
19 p_inv_enc_type_id IN NUMBER,
20 p_purch_enc_type_id IN NUMBER,
21 p_conc_flag IN VARCHAR2,
22 p_system_user IN NUMBER,
23 p_ussgl_option IN VARCHAR2,
24 p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
25 p_hold_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
26 p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
27 p_calling_sequence IN VARCHAR2);
28
29
30 PROCEDURE SetUp_Flexbuild_Params(p_chart_of_accounts_id IN NUMBER,
31 p_flex_method IN VARCHAR2,
32 p_flex_xrate_flag IN BOOLEAN,
33 p_xrate_gain_ccid IN NUMBER,
34 p_xrate_loss_ccid IN NUMBER,
35 p_flex_qualifier_name IN OUT NOCOPY VARCHAR2,
36 p_flex_segment_delimiter IN OUT NOCOPY VARCHAR2,
37 p_flex_segment_number IN OUT NOCOPY NUMBER,
38 p_num_of_segments IN OUT NOCOPY NUMBER,
39 p_xrate_gain_segments IN OUT NOCOPY FND_FLEX_EXT.SEGMENTARRAY,
40 p_xrate_loss_segments IN OUT NOCOPY FND_FLEX_EXT.SEGMENTARRAY,
41 p_xrate_cant_flexbuild_flag IN OUT NOCOPY BOOLEAN,
42 p_cant_flexbuild_reason IN OUT NOCOPY VARCHAR2,
43 p_calling_sequence IN VARCHAR2);
44
45 PROCEDURE Calc_IPV_ERV(p_auto_offsets_flag IN VARCHAR2,
46 p_xrate_cant_flexbuild_flag IN BOOLEAN,
47 p_chart_of_accounts_id IN NUMBER,
48 p_xrate_gain_segments IN FND_FLEX_EXT.SEGMENTARRAY,
49 p_xrate_loss_segments IN FND_FLEX_EXT.SEGMENTARRAY,
50 p_sys_xrate_gain_ccid IN NUMBER,
51 p_sys_xrate_loss_ccid IN NUMBER,
52 p_dist_ccid IN NUMBER,
53 p_expense_ccid IN NUMBER,
54 p_variance_ccid IN NUMBER,
55 p_segment_number IN NUMBER,
56 p_flex_method IN VARCHAR2,
57 p_flex_qualifier_name IN VARCHAR2,
58 p_flex_segment_delimiter IN VARCHAR2,
59 p_po_rate IN NUMBER,
60 p_po_price IN NUMBER,
61 p_inv_rate IN NUMBER,
62 p_rtxn_rate IN NUMBER,
63 p_rtxn_uom IN VARCHAR2,
64 p_rtxn_item_id IN NUMBER,
65 p_po_uom IN VARCHAR2,
66 p_match_option IN VARCHAR2,
67 p_inv_price IN NUMBER,
68 p_inv_qty IN NUMBER,
69 p_dist_amount IN NUMBER,
70 p_base_dist_amount IN NUMBER,
71 p_inv_currency_code IN VARCHAR2,
72 p_base_currency_code IN VARCHAR2,
73 p_destination_type IN VARCHAR2,
74 p_ipv IN OUT NOCOPY NUMBER,
75 p_bipv IN OUT NOCOPY NUMBER,
76 p_price_var_ccid IN OUT NOCOPY NUMBER,
77 p_erv IN OUT NOCOPY NUMBER,
78 p_erv_ccid IN OUT NOCOPY NUMBER,
79 p_calling_sequence IN VARCHAR2);
80
81 Procedure Calc_Tax_IPV_ERV(p_auto_offsets_flag IN VARCHAR2,
82 p_xrate_cant_flexbuild_flag IN BOOLEAN,
83 p_chart_of_accounts_id IN NUMBER,
84 p_xrate_gain_segments IN FND_FLEX_EXT.SEGMENTARRAY,
85 p_xrate_loss_segments IN FND_FLEX_EXT.SEGMENTARRAY,
86 p_sys_xrate_gain_ccid IN NUMBER,
87 p_sys_xrate_loss_ccid IN NUMBER,
88 p_flex_segment_number IN NUMBER,
89 p_flex_method IN VARCHAR2,
90 p_flex_qualifier_name IN VARCHAR2,
91 p_flex_segment_delimiter IN VARCHAR2,
92 p_tax_dist_id IN NUMBER,
93 p_po_dist_id IN NUMBER,
94 p_dist_ccid IN NUMBER,
95 p_sum_qty_invoiced IN NUMBER,
96 p_sum_allocated_amount IN NUMBER,
97 p_po_expense_ccid IN NUMBER,
98 p_price_variance_ccid IN NUMBER,
99 p_po_price IN NUMBER,
100 p_rtxn_rate IN NUMBER,
101 p_rtxn_uom IN VARCHAR2,
102 p_rtxn_item_id IN NUMBER,
103 p_po_uom IN VARCHAR2,
104 p_match_option IN VARCHAR2,
105 p_po_rate IN NUMBER,
106 p_inv_rate IN NUMBER,
107 p_destination_type IN VARCHAR2,
108 p_po_tax_rate IN NUMBER,
109 p_po_recov_rate IN NUMBER,
110 p_invoice_currency_code IN VARCHAR2,
111 p_base_currency_code IN VARCHAR2,
112 p_tax_ipv_ccid IN OUT NOCOPY NUMBER,
113 p_tax_erv_ccid IN OUT NOCOPY NUMBER,
114 p_tax_ipv IN OUT NOCOPY NUMBER,
115 p_tax_bipv IN OUT NOCOPY NUMBER,
116 p_tax_erv IN OUT NOCOPY NUMBER,
117 p_calling_sequence IN VARCHAR2,
118 p_tax_id IN NUMBER,
119 p_codeorgroup IN NUMBER,
120 p_vendor_id IN NUMBER,
121 p_vendor_site_id IN NUMBER);
122
123 PROCEDURE Calc_QV(p_invoice_id IN NUMBER,
124 p_po_dist_id IN NUMBER,
125 p_inv_currency_code IN VARCHAR2,
126 p_base_currency_code IN VARCHAR2,
127 p_po_price IN NUMBER,
128 p_po_qty IN NUMBER,
129 p_match_option IN VARCHAR2,
130 p_rtxn_uom IN VARCHAR2,
131 p_po_uom IN VARCHAR2,
132 p_item_id IN NUMBER,
133 p_qv IN OUT NOCOPY NUMBER,
134 p_bqv IN OUT NOCOPY NUMBER,
135 p_update_line_num IN OUT NOCOPY NUMBER,
136 p_calling_sequence IN VARCHAR2);
137
138 END FV_AP_PREPAY_PKG_PVT;