APPS.OE_DEFAULTING_FWK_PUB dependencies on OE_DEF_AK_FKEYS_V

Line 515: -- This will never fetch null entity code because the oe_def_ak_fkeys_v

511: l_uk_name := fkey_view.unique_key_name;
512: l_fk_name := fkey_view.foreign_key_name;
513: l_related_entity_code := fkey_view.uk_entity_code;
514:
515: -- This will never fetch null entity code because the oe_def_ak_fkeys_v
516: -- will fetch only the entities WHERE entity_code is not null.
517: l_related_pkg := l_app_short_name||'_'||l_related_entity_code||'_Def'||'_Util';
518:
519: OPEN PKGSTATUS(l_related_pkg );

Line 590: -- This will never fetch null entity code because the oe_def_ak_fkeys_v

586: l_uk_name := fkey_view.unique_key_name;
587: l_fk_name := fkey_view.foreign_key_name;
588: l_related_entity_code := fkey_view.uk_entity_code;
589:
590: -- This will never fetch null entity code because the oe_def_ak_fkeys_v
591: -- will fetch only the entities WHERE entity_code is not null.
592: l_related_pkg := l_app_short_name||'_'||l_related_entity_code||'_Def'||'_Util';
593:
594: OPEN PKGSTATUS(l_related_pkg );

Line 2127: TYPE foreign_keys_tbl_type IS TABLE OF OE_DEF_AK_FKEYS_V%ROWTYPE

2123: -- table declaration
2124: TYPE obj_attr_tbl_type IS TABLE OF OE_DEF_AK_ATTR_EXT_V%ROWTYPE
2125: INDEX BY BINARY_INTEGER;
2126:
2127: TYPE foreign_keys_tbl_type IS TABLE OF OE_DEF_AK_FKEYS_V%ROWTYPE
2128: INDEX BY BINARY_INTEGER;
2129:
2130: TYPE col_rec_type IS RECORD
2131: ( attribute_code VARCHAR2(30)

Line 2212: FROM OE_DEF_AK_FKEYS_V

2208: CURSOR FKEY(l_database_object_name varchar2,p_application_id number)
2209: IS
2210: SELECT unique_key_name,uk_database_object_name,foreign_key_name,
2211: fk_entity_code
2212: FROM OE_DEF_AK_FKEYS_V
2213: WHERE fk_database_object_name=l_database_object_name
2214: AND application_id=p_application_id;
2215:
2216: CURSOR FKEY_DATE(l_database_object_name varchar2,p_application_id number)

Line 2220: FROM OE_DEF_AK_FKEYS_V fk

2216: CURSOR FKEY_DATE(l_database_object_name varchar2,p_application_id number)
2217: IS
2218: SELECT unique_key_name,uk_database_object_name
2219: , foreign_key_name, fk_entity_code
2220: FROM OE_DEF_AK_FKEYS_V fk
2221: WHERE fk_database_object_name=l_database_object_name
2222: AND application_id=p_application_id
2223: AND exists (SELECT 'Y'
2224: FROM ak_object_attributes_vl oa