APPS.JTF_ESCWFACTIVITY_PVT dependencies on JTF_BRM_RULES_VL

Line 23: g_rule_id JTF_BRM_RULES_VL.RULE_ID%TYPE;

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:
25: ----------------------------------------------------------------------------
26: -- Attributes set by this package before returning to WF
27: ----------------------------------------------------------------------------

Line 36: g_rule_name JTF_BRM_RULES_VL.RULE_NAME%TYPE;

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:
38: -- long description of rule
39: g_rule_desc JTF_BRM_RULES_VL.RULE_DESCRIPTION%TYPE;
40:

Line 39: g_rule_desc JTF_BRM_RULES_VL.RULE_DESCRIPTION%TYPE;

35: -- short name for the rule
36: g_rule_name JTF_BRM_RULES_VL.RULE_NAME%TYPE;
37:
38: -- long description of rule
39: g_rule_desc JTF_BRM_RULES_VL.RULE_DESCRIPTION%TYPE;
40:
41: -- business rule owner
42: g_rule_owner JTF_BRM_RULES_VL.RULE_OWNER%TYPE;
43:

Line 42: g_rule_owner JTF_BRM_RULES_VL.RULE_OWNER%TYPE;

38: -- long description of rule
39: g_rule_desc JTF_BRM_RULES_VL.RULE_DESCRIPTION%TYPE;
40:
41: -- business rule owner
42: g_rule_owner JTF_BRM_RULES_VL.RULE_OWNER%TYPE;
43:
44: -- date and time the object was detected
45: g_detected_date DATE;
46:

Line 1000: CURSOR c_query_rule(b_rule_id JTF_BRM_RULES_VL.RULE_ID%TYPE)

996:
997: -------------------------------------------------------------------------
998: -- Cursor for BRM_Rules query
999: -------------------------------------------------------------------------
1000: CURSOR c_query_rule(b_rule_id JTF_BRM_RULES_VL.RULE_ID%TYPE)
1001: IS SELECT rule_name
1002: , rule_description
1003: , rule_owner
1004: FROM JTF_BRM_RULES_VL

Line 1004: FROM JTF_BRM_RULES_VL

1000: CURSOR c_query_rule(b_rule_id JTF_BRM_RULES_VL.RULE_ID%TYPE)
1001: IS SELECT rule_name
1002: , rule_description
1003: , rule_owner
1004: FROM JTF_BRM_RULES_VL
1005: WHERE rule_id = b_rule_id;
1006:
1007: -------------------------------------------------------------------------
1008: -- Cursor for JTF_Objects query