DBA Data[Home] [Help]

APPS.QLTDACTB dependencies on WF_ITEM_ATTRIBUTES

Line 2045: CURSOR wf_item_attributes_cursor IS

2041: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID
2042: and qpcao.PLAN_CHAR_ACTION_ID = X_PCA_ID
2043: and qc.char_context_flag = 3;
2044:
2045: CURSOR wf_item_attributes_cursor IS
2046: SELECT name
2047: FROM wf_item_attributes wia
2048: WHERE wia.item_type = X_WF_ITEMTYPE;
2049:

Line 2047: FROM wf_item_attributes wia

2043: and qc.char_context_flag = 3;
2044:
2045: CURSOR wf_item_attributes_cursor IS
2046: SELECT name
2047: FROM wf_item_attributes wia
2048: WHERE wia.item_type = X_WF_ITEMTYPE;
2049:
2050: -- Bug 4958762: SQL Repository Fix SQL ID: 15008550
2051: CURSOR token_column_datatype (t_char_id number) IS

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

2066: Cursor l_WorkFlowItemKey IS
2067: select qa_action_workflow_s.nextval
2068: from dual;
2069:
2070: TYPE wf_attributes_table IS TABLE OF WF_ITEM_ATTRIBUTES.NAME%TYPE
2071: INDEX BY BINARY_INTEGER;
2072:
2073: Cursor wf_number_of_processes IS
2074: select process_name

Line 2088: FOR attr_rec IN wf_item_attributes_cursor LOOP

2084: l_pca_id_exists BOOLEAN := FALSE;
2085:
2086: BEGIN
2087:
2088: FOR attr_rec IN wf_item_attributes_cursor LOOP
2089: wf_itemattributes(i) := attr_rec.name;
2090: i := i + 1;
2091: END LOOP;
2092: