1 PACKAGE AP_Acctg_Data_Fix_PKG AS
2 /* $Header: apgdfals.pls 120.1 2008/03/10 09:48:49 serabell noship $ */
3
4 TYPE Event_ID
5 IS TABLE OF
6 AP_ACCOUNTING_EVENTS_ALL.accounting_event_id%TYPE
7 INDEX BY BINARY_INTEGER;
8
9 TYPE Source_ID
10 IS TABLE OF
11 AP_ACCOUNTING_EVENTS_ALL.Source_id%TYPE
12 INDEX BY BINARY_INTEGER;
13 --Bug5073523
14 TYPE Accounting_date
15 is TABLE OF
16 AP_ACCOUNTING_EVENTS_ALL.Accounting_date%TYPE
17 INDEX BY BINARY_INTEGER;
18
19 TYPE SOB_ID
20 is TABLE OF
21 AP_INVOICE_DISTRIBUTIONS_ALL.set_of_books_id%TYPE
22 INDEX BY BINARY_INTEGER;
23
24 TYPE Source_Table
25 IS TABLE OF
26 AP_ACCOUNTING_EVENTS_ALL.Source_Table%TYPE
27 INDEX BY BINARY_INTEGER;
28
29 TYPE Org_ID
30 IS TABLE OF
31 AP_ACCOUNTING_EVENTS_ALL.org_id%TYPE
32 INDEX BY BINARY_INTEGER;
33
34 TYPE Period_Name
35 IS TABLE OF
36 VARCHAR2(15)
37 INDEX BY BINARY_INTEGER;
38
39 TYPE Header_ID
40 IS TABLE OF
41 NUMBER(15)
42 INDEX BY BINARY_INTEGER;
43
44 TYPE Group_ID
45 IS TABLE OF
46 NUMBER(15)
47 INDEX BY BINARY_INTEGER;
48
49 TYPE Vendor_Name
50 IS TABLE OF
51 PO_VENDORS.vendor_name%TYPE
52 INDEX BY BINARY_INTEGER;
53
54 G_Group_ID Group_ID;
55
56 G_Bug_Number NUMBER;
57 NAMES_FILE UTL_FILE.FILE_TYPE ;
58
59 /* Procedure to open the log files on the instance where the datafix
60 script is being run. The log file contains the log messages
61 and the report outputs written by the data fix scripts.
62 The file location is the environment's 'utl_file_dir' parameter. */
63 PROCEDURE Open_Log_Out_Files
64 (p_bug_number IN VARCHAR2,
65 p_file_location OUT NOCOPY VARCHAR2);
66
67
68 /* Procedure to close the log files on the instance once all the log
69 messages are written to it. */
70 PROCEDURE Close_Log_Out_Files;
71
72
73 /* Procedure to create temproary backup tables for the accounting */
74 PROCEDURE Create_Temp_Acctg_Tables
75 (p_bug_number IN NUMBER);
76
77
78 /* Procedure to get all the columns for a particular table.
79 This procedure gets called from Back_Up_Acctg procedure. */
80 PROCEDURE get_cols
81 (tab_name IN VARCHAR2,
82 ret_str OUT NOCOPY VARCHAR2);
83
84
85 /* Procedure to get the backup of all the Accounting (XLA) tables. */
86 PROCEDURE Back_Up_Acctg
87 (p_bug_number IN NUMBER);
88
89
90 /* Procedure to print messages in the Log file */
91 PROCEDURE Print
92 (p_message IN VARCHAR2,
93 p_calling_sequence IN VARCHAR2 DEFAULT NULL);
94
95
96 /* Procedure to print the values in the table and column list
97 passed as parameters, in HTML table format, into the Log file. */
98 PROCEDURE Print_Html_Table
99 (p_select_list IN VARCHAR2,
100 p_table_in IN VARCHAR2,
101 p_where_in IN VARCHAR2 DEFAULT NULL,
102 p_calling_sequence IN VARCHAR2 DEFAULT NULL);
103
104
105 /* Procedure to backup the data from the source table to destination
106 table. It also takes in as input SELECT LIST which determine
107 the list of columns which will be backed up. The additional
108 WHERE caluse can also be passed in as input. */
109 PROCEDURE Backup_data
110 (p_source_table IN VARCHAR2,
111 p_destination_table IN VARCHAR2,
112 p_select_list IN VARCHAR2,
113 p_where_clause IN VARCHAR2,
114 p_calling_sequence IN VARCHAR2 DEFAULT NULL);
115
116
117 END AP_Acctg_Data_Fix_PKG;