APPS.OE_PC_CONSTRAINTS_ADMIN_PUB dependencies on OE_PC_ENTITIES_V

Line 40: l_app_short_name OE_PC_ENTITIES_V.APPLICATION_SHORT_NAME%TYPE;

36: l_pkg_body LONG;
37: l_return_status varchar2(1);
38: l_msg_data varchar2(255);
39: l_msg_count number;
40: l_app_short_name OE_PC_ENTITIES_V.APPLICATION_SHORT_NAME%TYPE;
41: l_db_object_name OE_PC_ENTITIES_V.DB_OBJECT_NAME%TYPE;
42: l_entity_id OE_PC_ENTITIES_V.ENTITY_ID%TYPE;
43:
44: l_Q varchar2(3) := '''';

Line 41: l_db_object_name OE_PC_ENTITIES_V.DB_OBJECT_NAME%TYPE;

37: l_return_status varchar2(1);
38: l_msg_data varchar2(255);
39: l_msg_count number;
40: l_app_short_name OE_PC_ENTITIES_V.APPLICATION_SHORT_NAME%TYPE;
41: l_db_object_name OE_PC_ENTITIES_V.DB_OBJECT_NAME%TYPE;
42: l_entity_id OE_PC_ENTITIES_V.ENTITY_ID%TYPE;
43:
44: l_Q varchar2(3) := '''';
45: l_NULL varchar2(10) := l_Q || l_Q;

Line 42: l_entity_id OE_PC_ENTITIES_V.ENTITY_ID%TYPE;

38: l_msg_data varchar2(255);
39: l_msg_count number;
40: l_app_short_name OE_PC_ENTITIES_V.APPLICATION_SHORT_NAME%TYPE;
41: l_db_object_name OE_PC_ENTITIES_V.DB_OBJECT_NAME%TYPE;
42: l_entity_id OE_PC_ENTITIES_V.ENTITY_ID%TYPE;
43:
44: l_Q varchar2(3) := '''';
45: l_NULL varchar2(10) := l_Q || l_Q;
46: l_DUMMY_COL varchar2(10) := l_Q || '#NULL'|| l_Q;

Line 57: FROM OE_PC_ENTITIES_V

53: FROM DUAL;
54:
55: CURSOR C_APP
56: IS SELECT application_short_name, db_object_name, entity_id
57: FROM OE_PC_ENTITIES_V
58: where application_id = p_application_id
59: AND entity_short_name = p_entity_short_name;
60: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
61: BEGIN