APPS.AD_ZD_TABLE dependencies on AD_PATCHED_TABLES

Line 74: ** AD_PATCHED_TABLES.STATUS:

70: end local_chr;
71:
72: /*
73: ** Stores patched table name for finalize and cutover processing
74: ** AD_PATCHED_TABLES.STATUS:
75: ** 'N' - New
76: ** 'C' - Completed
77: ** 'U' - Updated
78: */

Line 86: from ad_patched_tables

82:
83: -- Get existing table status
84: select status
85: into l_status
86: from ad_patched_tables
87: where owner = x_table_owner
88: and name = x_table_name;
89:
90: -- Set "Completed" table back "Updated" status

Line 92: update ad_patched_tables

88: and name = x_table_name;
89:
90: -- Set "Completed" table back "Updated" status
91: if (l_status = 'C') then
92: update ad_patched_tables
93: set status='U'
94: where owner = x_table_owner
95: and name = x_table_name;
96: commit;

Line 101: insert into ad_patched_tables(owner, name, status)

97: end if;
98:
99: exception when no_data_found then
100: -- Add missing table with "New" status
101: insert into ad_patched_tables(owner, name, status)
102: values (x_table_owner, x_table_name, 'N');
103: commit;
104:
105: end STORE;

Line 2136: from ad_patched_tables

2132: C_MODULE varchar2(80) := c_package||'finalize';
2133:
2134: cursor C_PATCHED_TABLES is
2135: select owner, name, status
2136: from ad_patched_tables
2137: where status in ('N', 'U');
2138: begin
2139: log(c_module,'PROCEDURE', 'begin: no parameter(s)');
2140:

Line 2160: update ad_patched_tables

2156: x_unique => true);
2157: end if;
2158:
2159: -- Mark as Complete
2160: update ad_patched_tables
2161: set status = 'C'
2162: where owner = tablerec.owner
2163: and name = tablerec.name;
2164: commit;

Line 2261: delete from ad_patched_tables

2257:
2258: end loop;
2259:
2260: begin
2261: delete from ad_patched_tables
2262: where owner = x_table_owner
2263: and name = x_table_name;
2264: exception
2265: when no_data_found then

Line 2457: delete from ad_patched_tables;

2453: end if;
2454: end loop;
2455:
2456: -- Clear patched table list
2457: delete from ad_patched_tables;
2458: commit;
2459:
2460: log(c_module, 'PROCEDURE', 'end');
2461: end ABORT;