APPS.CN_CLASSIFICATION_GEN dependencies on AD_DDL

Line 2077: ad_ddl.build_package(j.text, k);

2073: k := 1;
2074: --Create package spec
2075: FOR j IN fetch_code(l_pks_start, l_pks_end - 1, l_pks_object_id)
2076: LOOP
2077: ad_ddl.build_package(j.text, k);
2078: k := k + 1;
2079: END LOOP;
2080: ad_ddl.build_package('END;', k);
2081: -----+

Line 2080: ad_ddl.build_package('END;', k);

2076: LOOP
2077: ad_ddl.build_package(j.text, k);
2078: k := k + 1;
2079: END LOOP;
2080: ad_ddl.build_package('END;', k);
2081: -----+
2082: -- Added Select..Into.. From. Statement
2083: --pramadas/24-Dec-2003/Bug Fix : 3322008
2084: -----+

Line 2090: ad_ddl.create_plsql_object(

2086: SELECT user
2087: INTO l_applsys_schema
2088: FROM dual;
2089:
2090: ad_ddl.create_plsql_object(
2091: applsys_schema => l_applsys_schema,
2092: application_short_name => 'CN',
2093: object_name => l_pkg_name,
2094: lb => 1,

Line 2132: -- our program looks OK, only the do ad_ddl build package

2128: -- Modified By Kumar.S
2129: -- Dated on 09/29/00
2130: -- Bug No 1406969
2131: -- Truncation Error pl/sql numeric value error
2132: -- our program looks OK, only the do ad_ddl build package
2133: -- using an variable which has a limitation of 255 Characters
2134: --
2135:
2136: IF length(j.text ) <= 254 then

Line 2137: ad_ddl.build_package(j.text, k);

2133: -- using an variable which has a limitation of 255 Characters
2134: --
2135:
2136: IF length(j.text ) <= 254 then
2137: ad_ddl.build_package(j.text, k);
2138: ELSE
2139:
2140: l_text := j.text;
2141: LOOP

Line 2171: ad_ddl.build_package(substr(l_text,1,l_pos), k);

2167:
2168: END LOOP;
2169:
2170:
2171: ad_ddl.build_package(substr(l_text,1,l_pos), k);
2172: l_text := substr(l_text, l_pos +1 );
2173:
2174: IF nvl(l_pos,0) = 0 then
2175: ad_ddl.build_package(substr(l_text,l_pos), k);

Line 2175: ad_ddl.build_package(substr(l_text,l_pos), k);

2171: ad_ddl.build_package(substr(l_text,1,l_pos), k);
2172: l_text := substr(l_text, l_pos +1 );
2173:
2174: IF nvl(l_pos,0) = 0 then
2175: ad_ddl.build_package(substr(l_text,l_pos), k);
2176: EXIT;
2177: END IF;
2178: k := k +1;
2179:

Line 2185: ad_ddl.build_package('END;', k);

2181:
2182: END IF;
2183: k := k + 1;
2184: END LOOP;
2185: ad_ddl.build_package('END;', k);
2186: ad_ddl.create_plsql_object(
2187: applsys_schema => l_applsys_schema,
2188: application_short_name => 'CN',
2189: object_name => l_pkg_name,

Line 2186: ad_ddl.create_plsql_object(

2182: END IF;
2183: k := k + 1;
2184: END LOOP;
2185: ad_ddl.build_package('END;', k);
2186: ad_ddl.create_plsql_object(
2187: applsys_schema => l_applsys_schema,
2188: application_short_name => 'CN',
2189: object_name => l_pkg_name,
2190: lb => 1,