DBA Data[Home] [Help]

APPS.AD_DD dependencies on FND_PRIMARY_KEY_COLUMNS

Line 637: insert into fnd_primary_key_columns(

633: '" with application_short_name "'|| p_appl_short_name||'"');
634: end if;
635:
636:
637: insert into fnd_primary_key_columns(
638: APPLICATION_ID,
639: TABLE_ID,
640: PRIMARY_KEY_ID,
641: PRIMARY_KEY_SEQUENCE,

Line 657: from fnd_primary_key_columns

653: 0
654: from dual
655: where not exists (
656: select 'x'
657: from fnd_primary_key_columns
658: where application_id = l_appl_id
659: and table_id = l_table_id
660: and primary_key_id = l_key_id
661: and column_id = l_col_id);

Line 705: delete from fnd_primary_key_columns

701: p_tab_name||'" with application_short_name "'||
702: p_appl_short_name||'"');
703: end if;
704:
705: delete from fnd_primary_key_columns
706: where application_id = l_appl_id
707: and table_id = l_table_id
708: and primary_key_id = l_key_id
709: and column_id = decode(p_col_name, null, column_id, l_col_id);