APPS.CSM_QUERY_PKG dependencies on WF_ENGINE

Line 1096: wf_engine.createprocess(l_item_type, l_item_key,l_root_process);

1092: END IF;
1093: CLOSE c_get_wf_root;
1094:
1095:
1096: wf_engine.createprocess(l_item_type, l_item_key,l_root_process);
1097:
1098: wf_engine.setitemuserkey(itemtype => l_item_type
1099: ,itemkey => l_item_key
1100: ,userkey => 'USERKEY: ' || l_item_key);

Line 1098: wf_engine.setitemuserkey(itemtype => l_item_type

1094:
1095:
1096: wf_engine.createprocess(l_item_type, l_item_key,l_root_process);
1097:
1098: wf_engine.setitemuserkey(itemtype => l_item_type
1099: ,itemkey => l_item_key
1100: ,userkey => 'USERKEY: ' || l_item_key);
1101: wf_engine.setitemowner(itemtype => l_item_type
1102: ,itemkey => l_item_key

Line 1101: wf_engine.setitemowner(itemtype => l_item_type

1097:
1098: wf_engine.setitemuserkey(itemtype => l_item_type
1099: ,itemkey => l_item_key
1100: ,userkey => 'USERKEY: ' || l_item_key);
1101: wf_engine.setitemowner(itemtype => l_item_type
1102: ,itemkey => l_item_key
1103: ,owner => 'SYSADMIN');
1104:
1105: --Set the Default Variables

Line 1106: wf_engine.setitemattrText(itemtype => l_item_type

1102: ,itemkey => l_item_key
1103: ,owner => 'SYSADMIN');
1104:
1105: --Set the Default Variables
1106: wf_engine.setitemattrText(itemtype => l_item_type
1107: ,itemkey => l_item_key
1108: ,aname => 'USER_ID'
1109: ,avalue => p_USER_ID);
1110:

Line 1111: wf_engine.setitemattrText(itemtype => l_item_type

1107: ,itemkey => l_item_key
1108: ,aname => 'USER_ID'
1109: ,avalue => p_USER_ID);
1110:
1111: wf_engine.setitemattrText(itemtype => l_item_type
1112: ,itemkey => l_item_key
1113: ,aname => 'QUERY_ID'
1114: ,avalue => p_QUERY_ID);
1115:

Line 1116: wf_engine.setitemattrText(itemtype => l_item_type

1112: ,itemkey => l_item_key
1113: ,aname => 'QUERY_ID'
1114: ,avalue => p_QUERY_ID);
1115:
1116: wf_engine.setitemattrText(itemtype => l_item_type
1117: ,itemkey => l_item_key
1118: ,aname => 'INSTANCE_ID'
1119: ,avalue => p_INSTANCE_ID);
1120:

Line 1125: wf_engine.setitemattrDate(itemtype => l_item_type

1121: --Set the parmeters for the Workflow
1122: FOR l_variable_rec IN c_get_variables(p_USER_ID,p_QUERY_ID,p_INSTANCE_ID)
1123: LOOP
1124: IF UPPER(l_variable_rec.VARIABLE_TYPE) = 'DATE' THEN
1125: wf_engine.setitemattrDate(itemtype => l_item_type
1126: ,itemkey => l_item_key
1127: ,aname => l_variable_rec.VARIABLE_NAME
1128: ,avalue => l_variable_rec.VARIABLE_VALUE_DATE);
1129: ELSE

Line 1130: wf_engine.setitemattrText(itemtype => l_item_type

1126: ,itemkey => l_item_key
1127: ,aname => l_variable_rec.VARIABLE_NAME
1128: ,avalue => l_variable_rec.VARIABLE_VALUE_DATE);
1129: ELSE
1130: wf_engine.setitemattrText(itemtype => l_item_type
1131: ,itemkey => l_item_key
1132: ,aname => l_variable_rec.VARIABLE_NAME
1133: ,avalue => l_variable_rec.VARIABLE_VALUE_CHAR);
1134: END IF;

Line 1136: wf_engine.startprocess(l_item_type, l_item_key);

1132: ,aname => l_variable_rec.VARIABLE_NAME
1133: ,avalue => l_variable_rec.VARIABLE_VALUE_CHAR);
1134: END IF;
1135: END LOOP;
1136: wf_engine.startprocess(l_item_type, l_item_key);
1137: --update Work flow status as running
1138: UPDATE_EXE_STATUS( p_USER_ID, p_QUERY_ID, p_INSTANCE_ID,
1139: NULL,SYSDATE,'RUNNING','Query Successfully Executed');
1140: