APPS.AP_ACCTG_DATA_FIX_PKG dependencies on AP_ACCTG_DATA_FIX_PKG
Line 1: PACKAGE BODY AP_Acctg_Data_Fix_PKG AS
1: PACKAGE BODY AP_Acctg_Data_Fix_PKG AS 2: /* $Header: apgdfalb.pls 120.45.12020000.5 2012/10/16 11:45:48 vinerao ship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
Line 11: G_MODULE_NAME CONSTANT VARCHAR2(50) :='AP.PLSQL.AP_ACCTG_DATA_FIX_PKG.';
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT; 11: G_MODULE_NAME CONSTANT VARCHAR2(50) :='AP.PLSQL.AP_ACCTG_DATA_FIX_PKG.'; 12:
13:
14:
15: /* Procedure to open the log files on the instance where the datafix
Line 59: l_message := 'in side AP_ACCTG_DATA_FIX_PKG.Open_Log_Out_Files '||'
';
55: WHEN OTHERS THEN
56: l_message := 'Exception :: '||SQLERRM||'
';
60: FND_File.Put_Line(fnd_file.log,l_message);
61: APP_EXCEPTION.RAISE_EXCEPTION;
62: END Open_Log_Out_Files;
63:
Line 84: 'AP_Acctg_Data_Fix_PKG.Create_Temp_Acctg_Tables';
80: l_calling_sequence VARCHAR2(2000);
81: l_message VARCHAR2(500);
82: Begin
83: l_calling_sequence := 84: 'AP_Acctg_Data_Fix_PKG.Create_Temp_Acctg_Tables'; 85:
86: Execute Immediate
87: 'create table '||'Events_'||P_Bug_Number||
88: ' as select * from XLA_EVENTS where rownum<1 ';
Line 154: 'AP_Acctg_Data_Fix_PKG.Get_Cols<-' ;
150:
151: begin
152:
153: l_calling_sequence := 154: 'AP_Acctg_Data_Fix_PKG.Get_Cols<-' ; 155: stmt_str := 'select column_name from '|| l_all_tab_columns ||
156: ' where table_name=:1 and column_name<>''DATAFIX_UPDATE_DATE''';
157: OPEN cur FOR stmt_str USING TAB_NAME;
158: LOOP
Line 194: 'AP_Acctg_Data_Fix_PKG.Get_Cols<-' ;
190:
191: begin
192:
193: l_calling_sequence := 194: 'AP_Acctg_Data_Fix_PKG.Get_Cols<-' ; 195: stmt_str := 'select column_name from '|| l_all_tab_columns ||
196: ' where table_name=:1 and owner =:2 and column_name<>''DATAFIX_UPDATE_DATE''';
197: OPEN cur FOR stmt_str USING TAB_NAME, SCHEMA_NAME;
198: LOOP
Line 241: 'AP_Acctg_Data_Fix_PKG.Back_Up_Acctg<-'||P_calling_Sequence ;
237: l_calling_sequence VARCHAR2(2000);
238: BEGIN
239:
240: l_calling_sequence := 241: 'AP_Acctg_Data_Fix_PKG.Back_Up_Acctg<-'||P_calling_Sequence ; 242:
243: l_debug_info := 'Setting the driver table name';
244: IF P_Driver_Table IS NULL THEN
245: l_driver_table := 'AP_TEMP_DATA_DRIVER_'||P_Bug_number;
Line 257: AP_Acctg_Data_Fix_PKG.Print('_______________________________________'||
253: OPEN cur FOR sql_liab_stat;
254: fetch cur into bkp_tables_exists;
255: CLOSE cur;
256: 257: AP_Acctg_Data_Fix_PKG.Print('_______________________________________'|| 258: '_______________________________________');
259:
260: if (bkp_tables_exists=0) then
261: l_message := 'Backup tables do not Exist: Before creating accounting backup tables
';
Line 264: AP_Acctg_Data_Fix_PKG.Create_Temp_Acctg_Tables(p_bug_number);
260: if (bkp_tables_exists=0) then
261: l_message := 'Backup tables do not Exist: Before creating accounting backup tables
Line 854: Code changes are done in ap_acctg_data_fix_pkg.del_nonfinal_xla_entries procedure
850: RETURN;
851: END IF;
852:
853: /* Bug 11674553 854: Code changes are done in ap_acctg_data_fix_pkg.del_nonfinal_xla_entries procedure 855: for deleting the journals, event and entity by calling api instead of directly
856: deleting from xla tables.
857:
858: While calling delete entity, if l_result is 0 then entity deleted
Line 1131: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG.Check_Period <- '||p_calling_sequence;
1127: period_close_list PERIOD_CLOSE_REC_TYP;
1128:
1129: BEGIN
1130: 1131: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG.Check_Period <- '||p_calling_sequence; 1132: l_bug_no := p_bug_no;
1133:
1134: l_debug_info := 'Constructing the name of the driver table';
1135: IF p_driver_table IS NOT NULL THEN
Line 1752: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG.check_ccid <- '||p_calling_sequence;
1748: invalid_ccid REFCURTYP;
1749:
1750: BEGIN
1751: 1752: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG.check_ccid <- '||p_calling_sequence; 1753: l_bug_no := p_bug_no;
1754:
1755: l_debug_info := 'Constructing the driver table name';
1756: IF p_driver_table IS NOT NULL THEN
Line 2093: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG <- '||p_calling_sequence;