1 PACKAGE jai_ap_tds_prepayments_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_ap_tds_ppay.pls 120.2.12010000.2 2010/01/29 08:22:45 mbremkum ship $ */
3
4 /* ----------------------------------------------------------------------------
5 FILENAME : jai_ap_tds_prepayemnts_pkg_s.sql
6
7 Created By : Aparajita
8
9 Created Date : 03-mar-2005
10
11 Bug :
12
13 Purpose : Implementation of prepayment functionality for TDS.
14
15 Called from : Trigger ja_in_ap_aia_after_trg
16 Trigger ja_in_ap_aida_after_trg
17
18 CHANGE HISTORY:
19 -------------------------------------------------------------------------------
20 S.No Date Author and Details
21 -------------------------------------------------------------------------------
22 1. 03/03/2005 Aparajita for bug#4088186. version#115.0. TDS Clean Up.
23
24 Created this package for implementing the TDS prepayment
25 functionality onto AP invoice.
26 2. 08-Jun-2005 Version 116.1 jai_ap_tds_ppay -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
27 as required for CASE COMPLAINCE.
28
29 3. 03/05/2007 Bug 5722028. Added by csahoo 120.2
30 Forward porting to R12.
31 Added parameter p_creation_date for the follownig procedures
32 Process_prepayment
33 process_unapply
34 process_tds_invoices
35
36 Depedencies:
37 =============
38 jai_ap_tds_gen.pls - 120.5
39 jai_ap_tds_gen.plb - 120.19
40 jai_ap_tds_ppay.pls - 120.2
41 jai_ap_tds_ppay.plb - 120.5
42 jai_ap_tds_can.plb - 120.6
43
44 ---------------------------------------------------------------------------- */
45
46 procedure process_prepayment
47 (
48 p_event in varchar2 default null, --Added for Bug 8431516
49 p_invoice_id in number,
50 p_invoice_distribution_id in number,
51 p_prepay_distribution_id in number,
52 p_parent_reversal_id in number,
53 p_prepay_amount in number,
54 p_vendor_id in number,
55 p_vendor_site_id in number,
56 p_accounting_date in date,
57 p_invoice_currency_code in varchar2,
58 p_exchange_rate in number,
59 p_set_of_books_id in number,
60 p_org_id in number,
61 -- Bug 5722028. Added by CSahoo
62 p_creation_date in date,
63 p_process_flag out nocopy varchar2,
64 p_process_message out nocopy varchar2,
65 p_codepath in out nocopy varchar2
66 );
67
68
69 procedure process_unapply
70 (
71 p_event in varchar2, --Added for Bug 8431516
72 p_invoice_id in number,
73 p_invoice_distribution_id in number, /* PREPAY UNAPPLY distribution */
74 p_parent_distribution_id in number, /* parent PREPAY APPLY distribution */
75 p_prepay_distribution_id in number, /* Distribution id of prepay line - Bug 5751783*/
76 p_prepay_amount in number,
77 p_vendor_id in number,
78 p_vendor_site_id in number,
79 p_accounting_date in date,
80 p_invoice_currency_code in varchar2,
81 p_exchange_rate in number,
82 p_set_of_books_id in number,
83 p_org_id in number,
84 -- Bug 5722028. Added by CSahoo
85 p_creation_date in date,
86 p_process_flag out nocopy varchar2,
87 p_process_message out nocopy varchar2,
88 p_codepath in out nocopy varchar2
89 );
90
91
92 procedure allocate_prepayment
93 (
94 p_invoice_id in number,
95 p_invoice_distribution_id in number, /* Of the PREPAY line */
96 p_prepay_amount in number,
97 p_process_flag out nocopy varchar2,
98 p_process_message out nocopy varchar2,
99 p_codepath in out nocopy varchar2
100 );
101
102 procedure populate_section_tax
103 (
104 p_invoice_id in number,
105 p_invoice_distribution_id in number, /* Of the PREPAY line in the SI*/
106 p_prepay_distribution_id in number, /*Distribution id of the PP invoice */
107 p_process_flag out nocopy varchar2,
108 p_process_message out nocopy varchar2,
109 p_codepath in out nocopy varchar2
110 );
111
112 procedure process_tds_invoices
113 (
114 p_event in varchar2, --Added for Bug 8431516
115 p_invoice_id in number,
116 p_invoice_distribution_id in number,
117 p_prepay_distribution_id in number,
118 p_prepay_amount in number,
119 p_vendor_id in number,
120 p_vendor_site_id in number,
121 p_accounting_date in date,
122 p_invoice_currency_code in varchar2,
123 p_exchange_rate in number,
124 p_set_of_books_id in number,
125 p_org_id in number,
126 -- Bug 5722028. Added by CSahoo
127 p_creation_date in date,
128 p_process_flag out nocopy varchar2,
129 p_process_message out nocopy varchar2,
130 p_codepath in out nocopy varchar2
131 );
132
133 procedure process_old_transaction
134 (
135 p_invoice_id in number,
136 p_invoice_distribution_id in number,
137 p_prepay_distribution_id in number,
138 p_amount in number,
139 p_last_updated_by in number,
140 p_last_update_date in date,
141 p_created_by in number,
142 p_creation_date in date,
143 p_org_id in number,
144 p_process_flag out nocopy varchar2,
145 p_process_message out nocopy varchar2
146 );
147
148 END jai_ap_tds_prepayments_pkg;