APPS.AP_ACCTG_DATA_FIX_PKG dependencies on ALL_TABLES

Line 224: l_driver_table ALL_TABLES.TABLE_NAME%TYPE;

220: Procedure Back_Up_Acctg(P_Bug_Number in number,
221: P_Driver_Table in VARCHAR2 DEFAULT NULL,
222: P_Calling_Sequence in VARCHAR2 DEFAULT NULL) is
223:
224: l_driver_table ALL_TABLES.TABLE_NAME%TYPE;
225: l_debug_info VARCHAR2(4000);
226: sql_liab_stat varchar2(5000);
227: col_str1 varchar2(5000);
228: col_str2 varchar2(5000);

Line 236: l_tables varchar2(100) := 'ALL_TABLES';

232: bkp_tables_exists number:=0;
233: l_message varchar2(500);
234: TYPE sqlCurTyp IS REF CURSOR;
235: cur sqlCurTyp;
236: l_tables varchar2(100) := 'ALL_TABLES';
237: l_calling_sequence VARCHAR2(2000);
238: BEGIN
239:
240: l_calling_sequence :=

Line 567: l_tables varchar2(100) := 'ALL_TABLES';

563: l_calling_sequence varchar2(4000);
564: l_message LONG;
565: TYPE sqlCurTyp IS REF CURSOR;
566: cur sqlCurTyp;
567: l_tables varchar2(100) := 'ALL_TABLES';
568: l_bkp_tables_exists number:=0;
569: sql_stmt LONG;
570: col_str1 LONG;
571: l_sql_stmt LONG;

Line 1088: l_driver_table ALL_TABLES.TABLE_NAME%TYPE;

1084: p_calling_sequence IN VARCHAR2) IS
1085:
1086: l_sql_stmt LONG;
1087: l_bug_no VARCHAR2(100);
1088: l_driver_table ALL_TABLES.TABLE_NAME%TYPE;
1089: l_debug_info VARCHAR2(4000);
1090: l_error_log LONG;
1091: l_date_string VARCHAR2(100);
1092: l_dummy NUMBER;

Line 1703: l_driver_table ALL_TABLES.TABLE_NAME%TYPE;

1699: p_calling_sequence IN VARCHAR2) IS
1700:
1701: l_sql_stmt LONG;
1702: l_bug_no VARCHAR2(100);
1703: l_driver_table ALL_TABLES.TABLE_NAME%TYPE;
1704: l_debug_info VARCHAR2(4000);
1705: l_error_log LONG;
1706: l_date VARCHAR2(100);
1707: l_dummy NUMBER;

Line 2079: l_table_name VARCHAR2(20) := 'ALL_TABLES';

2075:
2076: l_Period_Name VARCHAR2(15);
2077: l_cur_Period_Name VARCHAR2(15);
2078: NULL_VALUE NUMBER := null;
2079: l_table_name VARCHAR2(20) := 'ALL_TABLES';
2080: ins_AP_undo_event_log_stmt VARCHAR2(200) := 'INSERT INTO AP_undo_event_log('
2081: ||'EVENT_ID,E2,E3,STATUS,INVOICE_ID,CHECK_ID, BUG_ID) '||
2082: 'VALUES(:1, :2, :3, :4, :5, :6, :7)';
2083: log_table_exists_stmt VARCHAR2(200) := 'select count(*) '||

Line 2603: l_driver_table ALL_TABLES.TABLE_NAME%TYPE;

2599: p_calling_sequence IN VARCHAR2) IS
2600:
2601: l_sql_stmt LONG;
2602: l_bug_no VARCHAR2(100);
2603: l_driver_table ALL_TABLES.TABLE_NAME%TYPE;
2604: l_debug_info VARCHAR2(4000);
2605: l_error_log LONG;
2606: l_prev_org_id NUMBER := -99;
2607: l_org_id NUMBER := -99;

Line 4440: l_driver_table ALL_TABLES.TABLE_NAME%TYPE;

4436: l_bc_event_id_tab TAB_NUMBER;
4437: TYPE Tab_Char IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.MATCH_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
4438: l_match_status_flg_tab TAB_CHAR;
4439: l_bug_no VARCHAR2(100);
4440: l_driver_table ALL_TABLES.TABLE_NAME%TYPE;
4441: l_debug_info VARCHAR2(4000);
4442: l_error_log LONG;
4443: l_prev_org_id NUMBER := -99;
4444: l_org_id NUMBER := -99;

Line 5031: l_driver_table ALL_TABLES.TABLE_NAME%TYPE;

5027: l_sql_stmt LONG;
5028: l_sql_errors NUMBER;
5029: l_rowcount NUMBER;
5030: l_bug_no VARCHAR2(100);
5031: l_driver_table ALL_TABLES.TABLE_NAME%TYPE;
5032: l_debug_info VARCHAR2(4000);
5033: l_error_log LONG;
5034: l_message VARCHAR2(4000);
5035: l_calling_sequence VARCHAR2(4000);

Line 5540: l_table_name VARCHAR2(20) := 'ALL_TABLES';

5536: l_entered_Period VARCHAR2(15);
5537: l_Period_Name VARCHAR2(15);
5538: l_cur_Period_Name VARCHAR2(15);
5539: NULL_VALUE NUMBER := NULL;
5540: l_table_name VARCHAR2(20) := 'ALL_TABLES';
5541: ins_ap_undo_event_log_stmt VARCHAR2(200) := 'INSERT INTO AP_undo_event_log('
5542: ||'EVENT_ID,E2,E3,STATUS,INVOICE_ID,CHECK_ID, BUG_ID) '
5543: ||'VALUES(:1, :2, :3, :4, :5, :6, :7)';
5544: log_table_exists_stmt VARCHAR2(200) := 'select count(*) from '||l_table_name