1 PACKAGE BODY FV_THIRD_PARTY_PAYMENTS_PKG AS
2 /* $Header: FVTPPPRB.pls 120.4 2005/12/29 22:01:12 dsadhukh ship $ */
3
4 PROCEDURE LOG_MESSAGE
5 (
6 p_error_level NUMBER,
7 p_module_name VARCHAR2,
8 p_message VARCHAR2,
9 p_debug VARCHAR2 DEFAULT 'Y'
10 );
11
12 PROCEDURE INITIALIZATION;
13
14 PROCEDURE PROCESS_PAYMENT_RECS;
15
16 PROCEDURE POPULATE_TPP_CHK_DTLS (p_assignment_id NUMBER,
17 p_check_number NUMBER,
18 p_checkrun_name VARCHAR2,
19 p_exception_category VARCHAR2,
20 p_org_id NUMBER,
21 p_set_of_books_id NUMBER,
22 p_creation_date DATE,
23 p_created_by NUMBER,
24 p_last_update_date DATE,
25 p_last_updated_by NUMBER,
26 p_last_update_login NUMBER);
27
28 PROCEDURE PRINT_EXCEPTION_REPORT;
29
30 FUNCTION VENDOR_NAME(p_vendor_id NUMBER) RETURN VARCHAR2;
31
32 FUNCTION VENDOR_SITE(p_vendor_site_id NUMBER) RETURN VARCHAR2;
33
34 PROCEDURE SUBMIT_TPP_REPORT;
35
36 -- -------------------------------------------------------------
37 -- PROCEDURE MAIN
38 -- -------------------------------------------------------------
39 -- This is called from the concurrent program to execute Third
40 -- Party Payments Process. The purpose of this process is to call
41 -- all the subsequent procedures.
42 -- -------------------------------------------------------------
43 PROCEDURE MAIN(x_errbuf OUT NOCOPY VARCHAR2,
44 x_retcode OUT NOCOPY NUMBER,
45 p_checkrun_name VARCHAR2)
46 IS
47 BEGIN
48 null;
49 END MAIN;
50
51
52 -- -------------------------------------------------------------
53 -- PROCEDURE LOG_MESSAGE
54 -- -------------------------------------------------------------
55 -- The purpose of this procedures is to accept a message and
56 -- print it to the log file.
57 -- -------------------------------------------------------------
58 PROCEDURE LOG_MESSAGE
59 (
60 p_error_level NUMBER,
61 p_module_name VARCHAR2,
62 p_message VARCHAR2,
63 p_debug VARCHAR2 DEFAULT 'Y'
64 ) IS
65 BEGIN
66 null;
67 END LOG_MESSAGE;
68
69
70 -- -------------------------------------------------------------
71 -- PROCEDURE INITIALIZATION
72 -- -------------------------------------------------------------
73 -- The purpose of this procedure is to delete any existing data
74 -- from Fv_Tpp_Check_Details table for g_checkrun_name.
75 -- -------------------------------------------------------------
76 PROCEDURE INITIALIZATION IS
77 BEGIN
78 null;
79 END INITIALIZATION;
80
81
82 -- -------------------------------------------------------------
83 -- PROCEDURE PROCESS_PAYMENT_RECS
84 -- -------------------------------------------------------------
85 -- The purpose of this procedure is to fetch payments and update
86 -- the supplier information with the third party information.
87 -- -------------------------------------------------------------
88 PROCEDURE PROCESS_PAYMENT_RECS IS
89 BEGIN
90 null;
91 END PROCESS_PAYMENT_RECS;
92
93
94 -- -------------------------------------------------------------
95 -- PROCEDURE POPULATE_TPP_CHK_DTLS
96 -- -------------------------------------------------------------
97 -- The purpose of this procedure is to populate fv_tpp_check_
98 -- details_all table.
99 -- -------------------------------------------------------------
100 PROCEDURE POPULATE_TPP_CHK_DTLS (p_assignment_id NUMBER,
101 p_check_number NUMBER,
102 p_checkrun_name VARCHAR2,
103 p_exception_category VARCHAR2,
104 p_org_id NUMBER,
105 p_set_of_books_id NUMBER,
106 p_creation_date DATE,
107 p_created_by NUMBER,
108 p_last_update_date DATE,
109 p_last_updated_by NUMBER,
110 p_last_update_login NUMBER) IS
111 BEGIN
112 null;
113 END POPULATE_TPP_CHK_DTLS;
114
115
116 -- -------------------------------------------------------------
117 -- PROCEDURE PRINT_EXCEPTION_REPORT
118 -- -------------------------------------------------------------
119 -- The purpose of this procedure is to print the exception report
120 -- in the output/log file.
121 -- -------------------------------------------------------------
122 PROCEDURE PRINT_EXCEPTION_REPORT IS
123
124 BEGIN
125 null;
126 END PRINT_EXCEPTION_REPORT;
127
128
129 -- -------------------------------------------------------------
130 -- FUNCTION VENDOR_NAME
131 -- -------------------------------------------------------------
132 -- The purpose of this function is return a vendor_name
133 -- corresponding to a vendor_id
134 -- -------------------------------------------------------------
135 FUNCTION VENDOR_NAME(p_vendor_id NUMBER) RETURN VARCHAR2 IS
136 BEGIN
137 RETURN null;
138 END VENDOR_NAME;
139
140
141 -- -------------------------------------------------------------
142 -- FUNCTION VENDOR_SITE
143 -- -------------------------------------------------------------
144 -- The purpose of this function is return a vendor_site_code
145 -- corresponding to a vendor_site_id
146 -- -------------------------------------------------------------
147 FUNCTION VENDOR_SITE(p_vendor_site_id NUMBER) RETURN VARCHAR2 IS
148 BEGIN
149 RETURN null;
150 END VENDOR_SITE;
151
152
153 -- -------------------------------------------------------------
154 -- PROCEDURE SUBMIT_TPP_REPORT
155 -- -------------------------------------------------------------
156 -- The purpose of this procedure is to submit TPP Report if any
157 -- data found in fv_tpp_check_details for the payment batch. The
158 -- process waits for the report to complete.
159 -- -------------------------------------------------------------
160 PROCEDURE SUBMIT_TPP_REPORT IS
161 BEGIN
162 null;
163 END SUBMIT_TPP_REPORT;
164
165 END FV_THIRD_PARTY_PAYMENTS_PKG;