APPS.JTF_ESCWFACTIVITY_PVT dependencies on AK_OBJECTS_VL

Line 20: g_object_type AK_OBJECTS_VL.DATABASE_OBJECT_NAME%TYPE;

16: -- type of object.
17: -- possible values are: - 'CS_BRM_3D_SERVICE_REQUEST_V' - SR
18: -- - 'CSS_BRM_3D_DEFECT_V' - Defect
19: -- - 'JTF_BRM_3D_TASK_V' - Task
20: g_object_type AK_OBJECTS_VL.DATABASE_OBJECT_NAME%TYPE;
21:
22: -- unique rule identifier
23: g_rule_id JTF_BRM_RULES_VL.RULE_ID%TYPE;
24:

Line 33: g_object_name AK_OBJECTS_VL.NAME%TYPE;

29: -- WF user id of person to receive notification
30: g_notif_person_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
31:
32: -- user-visible object name
33: g_object_name AK_OBJECTS_VL.NAME%TYPE;
34:
35: -- short name for the rule
36: g_rule_name JTF_BRM_RULES_VL.RULE_NAME%TYPE;
37:

Line 992: CURSOR c_query_ak(b_object_type AK_OBJECTS_VL.DATABASE_OBJECT_NAME%TYPE)

988:
989: -------------------------------------------------------------------------
990: -- Cursor for AK_Objects query
991: -------------------------------------------------------------------------
992: CURSOR c_query_ak(b_object_type AK_OBJECTS_VL.DATABASE_OBJECT_NAME%TYPE)
993: IS SELECT description
994: FROM AK_OBJECTS_VL
995: WHERE DATABASE_OBJECT_NAME = b_object_type;
996:

Line 994: FROM AK_OBJECTS_VL

990: -- Cursor for AK_Objects query
991: -------------------------------------------------------------------------
992: CURSOR c_query_ak(b_object_type AK_OBJECTS_VL.DATABASE_OBJECT_NAME%TYPE)
993: IS SELECT description
994: FROM AK_OBJECTS_VL
995: WHERE DATABASE_OBJECT_NAME = b_object_type;
996:
997: -------------------------------------------------------------------------
998: -- Cursor for BRM_Rules query