APPS.AD_DD dependencies on FND_PRIMARY_KEYS

Line 76: from fnd_primary_keys

72: begin
73:
74: select count(*)
75: into l_tmp
76: from fnd_primary_keys
77: where application_id = p_appl_id
78: and table_id = p_table_id
79: and primary_key_name <> upper(p_key_name)
80: and primary_key_type = 'D';

Line 98: from fnd_primary_keys

94: begin
95:
96: select primary_key_id
97: into l_key_id
98: from fnd_primary_keys
99: where application_id = p_appl_id
100: and table_id = p_table_id
101: and primary_key_name = upper(p_key_name);
102:

Line 191: insert into fnd_primary_keys (

187:
188:
189: if (p_mode = 'INSERT' and l_key_id is null) then
190:
191: insert into fnd_primary_keys (
192: APPLICATION_ID,
193: TABLE_ID,
194: PRIMARY_KEY_ID,
195: PRIMARY_KEY_NAME,

Line 205: fnd_primary_keys_s.nextval,

201: DESCRIPTION,
202: ENABLED_FLAG)
203: select l_appl_id,
204: l_table_id,
205: fnd_primary_keys_s.nextval,
206: p_key_name,
207: to_date('01/01/1990', 'DD/MM/YYYY'), 1,
208: to_date('01/01/1990', 'DD/MM/YYYY'), 1,
209: 0,

Line 217: from fnd_primary_keys

213: p_enabled_flag
214: from dual
215: where not exists (
216: select 'x'
217: from fnd_primary_keys
218: where application_id = l_appl_id
219: and table_id = l_table_id
220: and primary_key_name = upper(p_key_name));
221:

Line 224: update fnd_primary_keys

220: and primary_key_name = upper(p_key_name));
221:
222: elsif (p_mode = 'UPDATE' and l_key_id is not null) then
223:
224: update fnd_primary_keys
225: set primary_key_type = nvl(p_key_type, primary_key_type),
226: audit_key_flag = nvl(p_audit_flag, audit_key_flag),
227: description = nvl(p_description, description),
228: enabled_flag = nvl(p_enabled_flag, enabled_flag)