386:
387: CURSOR APP
388: is
389: SELECT substr(rtrim(APPLICATION_SHORT_NAME),1,3)
390: FROM fnd_application
391: WHERE application_id = p_application_id;
392:
393: CURSOR OBJ (p_database_object_name varchar2,p_application_id number)
394: is
1211: AND attribute_application_id = p_application_id
1212: AND attribute_code = p_attribute_code;
1213: CURSOR APP is
1214: SELECT substr(rtrim(APPLICATION_SHORT_NAME),1,3)
1215: FROM fnd_application
1216: WHERE application_id = p_application_id;
1217: CURSOR ENT_SEQ (p_entity_code varchar2)
1218: IS
1219: SELECT entity_id FROM OE_DEF_AK_OBJ_EXT_V
1711: AND attribute_application_id = p_application_id
1712: AND attribute_code = p_attribute_code;
1713: CURSOR APP is
1714: SELECT substr(rtrim(APPLICATION_SHORT_NAME),1,3)
1715: FROM fnd_application
1716: WHERE application_id = p_application_id;
1717: CURSOR ENT_SEQ (p_entity_code varchar2)
1718: IS
1719: SELECT entity_id FROM OE_DEF_AK_OBJ_EXT_V
3442:
3443: CURSOR APP
3444: is
3445: SELECT substr(rtrim(APPLICATION_SHORT_NAME),1,3)
3446: FROM fnd_application
3447: WHERE application_id = p_application_id;
3448:
3449: CURSOR OASS(p_database_object_name varchar2)
3450: is