APPS.OEONUM dependencies on AD_DDL

Line 23: ad_ddl_found boolean := TRUE;

19: sql_buffer varchar2(240);
20: ddl_parameter varchar2(240);
21: rel_name varchar2(240);
22: cid integer;
23: ad_ddl_found boolean := TRUE;
24: oexoenum_found boolean := TRUE;
25: dummy varchar2(1);
26: package_result number;
27: x number;

Line 58: ** Check if the AD_DDL PL-SQL package is installed,

54:
55:
56:
57: /*
58: ** Check if the AD_DDL PL-SQL package is installed,
59: ** if it is then call it to create the sequence.
60: ** We are doing this for caompatibility issues. If the AD_DDL
61: ** package is not installed then then check to see if the
62: ** OEXOENUM package is installed. If it is

Line 60: ** We are doing this for caompatibility issues. If the AD_DDL

56:
57: /*
58: ** Check if the AD_DDL PL-SQL package is installed,
59: ** if it is then call it to create the sequence.
60: ** We are doing this for caompatibility issues. If the AD_DDL
61: ** package is not installed then then check to see if the
62: ** OEXOENUM package is installed. If it is
63: ** then let it create the sequence, else create it manually.
64: */

Line 71: WHERE NAME='AD_DDL'

67:
68: SELECT 'X'
69: INTO DUMMY
70: FROM ALL_SOURCE
71: WHERE NAME='AD_DDL'
72: AND ROWNUM = 1 ;
73: EXCEPTION
74:
75: WHEN NO_DATA_FOUND THEN

Line 76: ad_ddl_found := FALSE;

72: AND ROWNUM = 1 ;
73: EXCEPTION
74:
75: WHEN NO_DATA_FOUND THEN
76: ad_ddl_found := FALSE;
77:
78: WHEN OTHERS THEN
79: return_status := -1;
80: OEONUM.Raise_Exception(Routine=>'OEONUM.CreateSource',

Line 95: if not ad_ddl_found then

91: ** one that has the OEXOENUM package installed in, so if we are
92: ** sending patches to 10.4.% we need to avoid calling this package.
93: */
94:
95: if not ad_ddl_found then
96:
97: BEGIN
98: SELECT 'X'
99: INTO DUMMY

Line 161: else /* ad_ddl_found */

157: return_status := 0;
158:
159: end if; /* not oexoenum_found */
160:
161: else /* ad_ddl_found */
162:
163:
164: /*
165: ** Build PL/SQL block for getting the oracle username

Line 199: 'AD_DDL.DO_DDL(' ||

195:
196:
197: if( SubStr(Rel_Name,1,4) = '10.6') then
198: sql_buffer := 'BEGIN ' ||
199: 'AD_DDL.DO_DDL(' ||
200: ''''||out_oracle_schema||'''' ||
201: ',''OE'',' ||
202: to_char(AD_DDL.CREATE_SEQUENCE) ||
203: ','||

Line 202: to_char(AD_DDL.CREATE_SEQUENCE) ||

198: sql_buffer := 'BEGIN ' ||
199: 'AD_DDL.DO_DDL(' ||
200: ''''||out_oracle_schema||'''' ||
201: ',''OE'',' ||
202: to_char(AD_DDL.CREATE_SEQUENCE) ||
203: ','||
204: ''''||ddl_parameter||'''' || '); ' ||
205: 'END;';
206: else

Line 208: 'AD_DDL.DO_DDL(' ||

204: ''''||ddl_parameter||'''' || '); ' ||
205: 'END;';
206: else
207: sql_buffer := 'BEGIN ' ||
208: 'AD_DDL.DO_DDL(' ||
209: ''''||out_oracle_schema||'''' ||
210: ',''OE'',' ||
211: to_char(AD_DDL.CREATE_SEQUENCE) ||
212: ','||

Line 211: to_char(AD_DDL.CREATE_SEQUENCE) ||

207: sql_buffer := 'BEGIN ' ||
208: 'AD_DDL.DO_DDL(' ||
209: ''''||out_oracle_schema||'''' ||
210: ',''OE'',' ||
211: to_char(AD_DDL.CREATE_SEQUENCE) ||
212: ','||
213: ''''||ddl_parameter||'''' || ',' ||
214: ''''||sequence_name||'''' ||
215: '); ' ||

Line 231: end if; /* not ad_ddl_found */

227:
228: return_status := 0;
229:
230:
231: end if; /* not ad_ddl_found */
232:
233:
234: EXCEPTION
235: