APPS.CN_CLASSIFICATION_GEN dependencies on AD_DDL

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

2081: k := 1;
2082: --Create package spec
2083: FOR j IN fetch_code(l_pks_start, l_pks_end - 1, l_pks_object_id)
2084: LOOP
2085: ad_ddl.build_package(j.text, k);
2086: k := k + 1;
2087: END LOOP;
2088: ad_ddl.build_package('END;', k);
2089: -----+

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

2084: LOOP
2085: ad_ddl.build_package(j.text, k);
2086: k := k + 1;
2087: END LOOP;
2088: ad_ddl.build_package('END;', k);
2089: -----+
2090: -- Added Select..Into.. From. Statement
2091: --pramadas/24-Dec-2003/Bug Fix : 3322008
2092: -----+

Line 2098: ad_ddl.create_plsql_object(

2094: SELECT user
2095: INTO l_applsys_schema
2096: FROM dual;
2097:
2098: ad_ddl.create_plsql_object(
2099: applsys_schema => l_applsys_schema,
2100: application_short_name => 'CN',
2101: object_name => l_pkg_name,
2102: lb => 1,

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

2136: -- Modified By Kumar.S
2137: -- Dated on 09/29/00
2138: -- Bug No 1406969
2139: -- Truncation Error pl/sql numeric value error
2140: -- our program looks OK, only the do ad_ddl build package
2141: -- using an variable which has a limitation of 255 Characters
2142: --
2143:
2144: IF length(j.text ) <= 254 then

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

2141: -- using an variable which has a limitation of 255 Characters
2142: --
2143:
2144: IF length(j.text ) <= 254 then
2145: ad_ddl.build_package(j.text, k);
2146: ELSE
2147:
2148: l_text := j.text;
2149: LOOP

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

2175:
2176: END LOOP;
2177:
2178:
2179: ad_ddl.build_package(substr(l_text,1,l_pos), k);
2180: l_text := substr(l_text, l_pos +1 );
2181:
2182: IF nvl(l_pos,0) = 0 then
2183: ad_ddl.build_package(substr(l_text,l_pos), k);

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

2179: ad_ddl.build_package(substr(l_text,1,l_pos), k);
2180: l_text := substr(l_text, l_pos +1 );
2181:
2182: IF nvl(l_pos,0) = 0 then
2183: ad_ddl.build_package(substr(l_text,l_pos), k);
2184: EXIT;
2185: END IF;
2186: k := k +1;
2187:

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

2189:
2190: END IF;
2191: k := k + 1;
2192: END LOOP;
2193: ad_ddl.build_package('END;', k);
2194: ad_ddl.create_plsql_object(
2195: applsys_schema => l_applsys_schema,
2196: application_short_name => 'CN',
2197: object_name => l_pkg_name,

Line 2194: ad_ddl.create_plsql_object(

2190: END IF;
2191: k := k + 1;
2192: END LOOP;
2193: ad_ddl.build_package('END;', k);
2194: ad_ddl.create_plsql_object(
2195: applsys_schema => l_applsys_schema,
2196: application_short_name => 'CN',
2197: object_name => l_pkg_name,
2198: lb => 1,