APPS.JTF_ESCWFACTIVITY_PVT dependencies on JTF_BRM_PROCESSES

Line 149: CURSOR c_get_rule(b_rule_id JTF_BRM_PROCESSES.RULE_ID%TYPE)

145: IS
146: -------------------------------------------------------------------------
147: -- Cursor for Rule query
148: -------------------------------------------------------------------------
149: CURSOR c_get_rule(b_rule_id JTF_BRM_PROCESSES.RULE_ID%TYPE)
150: IS SELECT workflow_item_type
151: , workflow_process_name
152: FROM jtf_brm_processes
153: WHERE rule_id = b_rule_id;

Line 152: FROM jtf_brm_processes

148: -------------------------------------------------------------------------
149: CURSOR c_get_rule(b_rule_id JTF_BRM_PROCESSES.RULE_ID%TYPE)
150: IS SELECT workflow_item_type
151: , workflow_process_name
152: FROM jtf_brm_processes
153: WHERE rule_id = b_rule_id;
154:
155: l_attr_value JTF_BRM_WF_ATTR_VALUES_V.WF_ATTRIBUTE_VALUE%TYPE;
156: l_item_type JTF_BRM_PROCESSES.WORKFLOW_ITEM_TYPE%TYPE;

Line 156: l_item_type JTF_BRM_PROCESSES.WORKFLOW_ITEM_TYPE%TYPE;

152: FROM jtf_brm_processes
153: WHERE rule_id = b_rule_id;
154:
155: l_attr_value JTF_BRM_WF_ATTR_VALUES_V.WF_ATTRIBUTE_VALUE%TYPE;
156: l_item_type JTF_BRM_PROCESSES.WORKFLOW_ITEM_TYPE%TYPE;
157: l_process_name JTF_BRM_PROCESSES.WORKFLOW_PROCESS_NAME%TYPE;
158:
159: BEGIN
160:

Line 157: l_process_name JTF_BRM_PROCESSES.WORKFLOW_PROCESS_NAME%TYPE;

153: WHERE rule_id = b_rule_id;
154:
155: l_attr_value JTF_BRM_WF_ATTR_VALUES_V.WF_ATTRIBUTE_VALUE%TYPE;
156: l_item_type JTF_BRM_PROCESSES.WORKFLOW_ITEM_TYPE%TYPE;
157: l_process_name JTF_BRM_PROCESSES.WORKFLOW_PROCESS_NAME%TYPE;
158:
159: BEGIN
160:
161: debug( fnd_log.level_statement