DBA Data[Home] [Help]

APPS.QLTDACTB dependencies on WF_ITEM_ATTRIBUTES

Line 2125: CURSOR wf_item_attributes_cursor IS

2121: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID
2122: and qpcao.PLAN_CHAR_ACTION_ID = X_PCA_ID
2123: and qc.char_context_flag = 3;
2124:
2125: CURSOR wf_item_attributes_cursor IS
2126: SELECT name
2127: FROM wf_item_attributes wia
2128: WHERE wia.item_type = X_WF_ITEMTYPE;
2129:

Line 2127: FROM wf_item_attributes wia

2123: and qc.char_context_flag = 3;
2124:
2125: CURSOR wf_item_attributes_cursor IS
2126: SELECT name
2127: FROM wf_item_attributes wia
2128: WHERE wia.item_type = X_WF_ITEMTYPE;
2129:
2130: -- Bug 4958762: SQL Repository Fix SQL ID: 15008550
2131: CURSOR token_column_datatype (t_char_id number) IS

Line 2150: TYPE wf_attributes_table IS TABLE OF WF_ITEM_ATTRIBUTES.NAME%TYPE

2146: Cursor l_WorkFlowItemKey IS
2147: select qa_action_workflow_s.nextval
2148: from dual;
2149:
2150: TYPE wf_attributes_table IS TABLE OF WF_ITEM_ATTRIBUTES.NAME%TYPE
2151: INDEX BY BINARY_INTEGER;
2152:
2153: Cursor wf_number_of_processes IS
2154: select process_name

Line 2177: FOR attr_rec IN wf_item_attributes_cursor LOOP

2173: l_user_name varchar2(100);
2174:
2175: BEGIN
2176:
2177: FOR attr_rec IN wf_item_attributes_cursor LOOP
2178: wf_itemattributes(i) := attr_rec.name;
2179: i := i + 1;
2180: END LOOP;
2181: