APPS.AD_TRACKABLE_ENTITIES_PKG dependencies on AD_TRACKABLE_ENTITIES

Line 1: PACKAGE BODY AD_TRACKABLE_ENTITIES_PKG AS

1: PACKAGE BODY AD_TRACKABLE_ENTITIES_PKG AS
2: -- $Header: adcodlinb.pls 120.3 2006/03/10 08:08:26 rahkumar noship $
3:
4: PROCEDURE validate_name( p_te IN VARCHAR2) is
5: l_te varchar2(30);

Line 24: insert into AD_TRACKABLE_ENTITIES (

20: BEGIN
21: validate_name(p_trackable_entity_name);
22: validate_name(p_type);
23:
24: insert into AD_TRACKABLE_ENTITIES (
25: abbreviation, name, type, baseline, codelevel,
26: used_flag, load_flag)
27: values ( p_trackable_entity_name, p_desc, p_type, '0', '0',
28: 'F' ,'F' );

Line 51: from AD_TRACKABLE_ENTITIES

47: -- Select the details of the event for the passed parameters.
48:
49: select baseline, codelevel
50: into x_baseline, x_te_level
51: from AD_TRACKABLE_ENTITIES
52: where abbreviation = p_trackable_entity_name;
53:
54: x_status := 'TRUE';
55:

Line 76: update AD_TRACKABLE_ENTITIES

72: validate_name(p_trackable_entity_name);
73: validate_level(p_te_level);
74: validate_level(p_baseline);
75:
76: update AD_TRACKABLE_ENTITIES
77: set codelevel = p_te_level ,
78: baseline = p_baseline
79: where abbreviation = p_trackable_entity_name;
80:

Line 107: from AD_TRACKABLE_ENTITIES

103: validate_name(p_trackable_entity_name);
104:
105: select baseline, codelevel, used_flag
106: into x_baseline, x_te_level, x_used_status
107: from AD_TRACKABLE_ENTITIES
108: where abbreviation = p_trackable_entity_name;
109:
110: x_status := 'TRUE';
111:

Line 129: update AD_TRACKABLE_ENTITIES

125: x_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2) is
126: BEGIN
127: validate_name(p_trackable_entity_name);
128:
129: update AD_TRACKABLE_ENTITIES
130: set used_flag = p_used_status
131: where abbreviation = p_trackable_entity_name;
132:
133: if(SQL%ROWCOUNT = 0) then

Line 159: from AD_TRACKABLE_ENTITIES

155: validate_name(p_trackable_entity_name);
156:
157: select baseline, codelevel, load_flag
158: into x_baseline, x_te_level, x_load_status
159: from AD_TRACKABLE_ENTITIES
160: where abbreviation = p_trackable_entity_name;
161:
162: x_status := 'TRUE';
163:

Line 180: update AD_TRACKABLE_ENTITIES

176: x_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2) is
177: BEGIN
178: validate_name(p_trackable_entity_name);
179:
180: update AD_TRACKABLE_ENTITIES
181: set load_flag = p_load_status
182: where abbreviation = p_trackable_entity_name;
183:
184: COMMIT;

Line 214: from AD_TRACKABLE_ENTITIES

210: validate_name(p_trackable_entity_name);
211:
212: select name, type, baseline, codelevel, used_flag, load_flag
213: into x_desc, x_type, x_baseline, x_te_level, x_used_status, x_load_status
214: from AD_TRACKABLE_ENTITIES
215: where abbreviation = p_trackable_entity_name;
216:
217: x_status := 'TRUE';
218:

Line 241: UPDATE AD_TRACKABLE_ENTITIES

237: x_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2) is
238: BEGIN
239: validate_name(p_trackable_entity_name);
240:
241: UPDATE AD_TRACKABLE_ENTITIES
242: set name = p_trackable_entity_desc,
243: type = p_type,
244: baseline = p_baseline,
245: codelevel = p_te_level,

Line 251: insert into AD_TRACKABLE_ENTITIES

247: load_flag = p_load_status
248: where abbreviation = p_trackable_entity_name;
249:
250: if(SQL%ROWCOUNT = 0) then
251: insert into AD_TRACKABLE_ENTITIES
252: (abbreviation, name, type, baseline, codelevel, used_flag, load_flag)
253: values (p_trackable_entity_name, p_trackable_entity_desc, p_type, p_te_level,
254: p_baseline, p_used_status, p_load_status);
255: end if;

Line 269: END AD_TRACKABLE_ENTITIES_PKG;

265: END set_te_info;
266:
267:
268:
269: END AD_TRACKABLE_ENTITIES_PKG;