'||
2050: ''||columnNtfTableHeader||'
'||
2051: ''||columnNtfRowValue||'
';
2052:
2053: wf_engine.SetItemAttrText ( itemtype => v_item_type,
2054: itemkey => l_item_key,
2055: aname => 'NOTIFICATION_TITLE' ,
2056: avalue => v_notificationTitle );
2057:
Line 2058: wf_engine.SetItemAttrText ( itemtype => v_item_type,
2054: itemkey => l_item_key,
2055: aname => 'NOTIFICATION_TITLE' ,
2056: avalue => v_notificationTitle );
2057:
2058: wf_engine.SetItemAttrText ( itemtype => v_item_type,
2059: itemkey => l_item_key,
2060: aname => 'NTF_BODY' ,
2061: avalue => vNtfBodyText );
2062: if v_debug and
Line 2069: wf_engine.SetItemAttrText ( itemtype => v_item_type,
2065: --log_message('notificationText='||vNtfBodyText);
2066: dumpstmt('notificationText='||vNtfBodyText);
2067: end if;
2068:
2069: wf_engine.SetItemAttrText ( itemtype => v_item_type,
2070: itemkey => l_item_key,
2071: aname => 'EXCEPTION_TYPE_NAME' ,
2072: avalue => v_exception_name );
2073:
Line 2075: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,
2071: aname => 'EXCEPTION_TYPE_NAME' ,
2072: avalue => v_exception_name );
2073:
2074:
2075: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,
2076: itemkey => l_item_key,
2077: aname => 'EXCEPTION_TYPE' ,
2078: avalue => v_exception_id );
2079:
Line 2080: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,
2076: itemkey => l_item_key,
2077: aname => 'EXCEPTION_TYPE' ,
2078: avalue => v_exception_id );
2079:
2080: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,
2081: itemkey => l_item_key,
2082: aname => 'EXCEPTION_EXIST' ,
2083: avalue => v_exception_exist );
2084:
Line 2085: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,
2081: itemkey => l_item_key,
2082: aname => 'EXCEPTION_EXIST' ,
2083: avalue => v_exception_exist );
2084:
2085: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,
2086: itemkey => l_item_key,
2087: aname => 'EXCEPTION_DETAIL_ID' ,
2088: avalue => v_EXCEPTION_DETAIL_ID(rowCounter) );
2089: details_url :=
Line 2118: wf_engine.SetItemAttrText ( itemtype => v_item_type,
2114: );
2115:
2116: details_url := details_url||'/OracleApps.RF?F='||l_Report_Run_str; */
2117: log_message('oa details_url='||details_url);
2118: wf_engine.SetItemAttrText ( itemtype => v_item_type,
2119: itemkey => l_item_key,
2120: aname => 'DETAILS_URL',
2121: avalue => details_url );
2122:
Line 2130: wf_engine.StartProcess( itemtype => v_item_type,
2126: vFirstRow then
2127: log_message('Before starting workflow process. Key='|| l_item_key );
2128: end if;
2129:
2130: wf_engine.StartProcess( itemtype => v_item_type,
2131: itemkey => l_item_key );
2132:
2133:
2134: if v_debug and
Line 2139: WF_ENGINE.threshold := saveThreshold;
2135: vFirstRow then
2136: log_message('after starting workflow process. Key='|| l_item_key );
2137: end if;
2138:
2139: WF_ENGINE.threshold := saveThreshold;
2140:
2141: end loop; --v_NumRows
2142:
2143: end if; -- v_NumRows <> 0
Line 2218: wf_engine.SetItemAttrDate ( itemtype => v_item_type,
2214: log_message('Initializing wk flow Date attribute='||wfAttributeName ||
2215: ' Value='||to_char(l_dateValue) );
2216: end if;
2217: if AttributeTypeList(columnCounter) = 'SELECT' then
2218: wf_engine.SetItemAttrDate ( itemtype => v_item_type,
2219: itemkey => l_item_key,
2220: aname => wfAttributeName ,
2221: avalue => l_dateValue );
2222: elsif AttributeTypeList(columnCounter) = 'CALCULATION' then
Line 2223: wf_engine.AddItemAttr ( itemtype => v_item_type,
2219: itemkey => l_item_key,
2220: aname => wfAttributeName ,
2221: avalue => l_dateValue );
2222: elsif AttributeTypeList(columnCounter) = 'CALCULATION' then
2223: wf_engine.AddItemAttr ( itemtype => v_item_type,
2224: itemkey => l_item_key,
2225: aname => wfAttributeName ,
2226: date_value => l_dateValue);
2227: end if;
Line 2240: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,
2236: l_numberValue := NumberValue(numberCounter,rowCounter);
2237: l_SelValue := to_char(l_numberValue);
2238: if AttributeTypeList(columnCounter) = 'SELECT' then
2239:
2240: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,
2241: itemkey => l_item_key,
2242: aname => wfAttributeName ,
2243: avalue => l_SelValue );
2244:
Line 2247: wf_engine.AddItemAttr ( itemtype => v_item_type,
2243: avalue => l_SelValue );
2244:
2245: elsif AttributeTypeList(columnCounter) = 'CALCULATION' then
2246:
2247: wf_engine.AddItemAttr ( itemtype => v_item_type,
2248: itemkey => l_item_key,
2249: aname => wfAttributeName ,
2250: number_value => l_numberValue);
2251: end if;
Line 2266: wf_engine.SetItemAttrText ( itemtype => v_item_type,
2262: ' Value='||l_varcharValue );
2263: end if;
2264: if AttributeTypeList(columnCounter) = 'SELECT' then
2265:
2266: wf_engine.SetItemAttrText ( itemtype => v_item_type,
2267: itemkey => l_item_key,
2268: aname => wfAttributeName ,
2269: avalue => l_varcharValue );
2270:
Line 2273: wf_engine.AddItemAttr ( itemtype => v_item_type,
2269: avalue => l_varcharValue );
2270:
2271: elsif AttributeTypeList(columnCounter) = 'CALCULATION' then
2272:
2273: wf_engine.AddItemAttr ( itemtype => v_item_type,
2274: itemkey => l_item_key,
2275: aname => wfAttributeName ,
2276: text_value => l_varcharValue);
2277:
Line 3005: l_exception_exist := wf_engine.getItemAttrNumber(
3001: lAdhocUser Varchar2(320);
3002:
3003: begin
3004: if ( p_funcmode = 'RUN' ) THEN
3005: l_exception_exist := wf_engine.getItemAttrNumber(
3006: p_item_type,
3007: pItemKey,
3008: 'EXCEPTION_EXIST');
3009:
Line 3153: l_publisher_item_name := wf_engine.getItemAttrText(
3149:
3150: begin
3151:
3152: --we fetch the item_name from the ouput attr
3153: l_publisher_item_name := wf_engine.getItemAttrText(
3154: p_item_type,
3155: pItemKey,
3156: 'P.ITEM_NAME' );
3157:
Line 3158: l_publisher_site_name := wf_engine.getItemAttrText(
3154: p_item_type,
3155: pItemKey,
3156: 'P.ITEM_NAME' );
3157:
3158: l_publisher_site_name := wf_engine.getItemAttrText(
3159: p_item_type,
3160: pItemKey,
3161: 'P.PUBLISHER_SITE_NAME' );
3162:
Line 3256: text_value := wf_engine.getItemAttrText(
3252: l_end_pos number;
3253: begin
3254:
3255: if command = 'GET' then
3256: text_value := wf_engine.getItemAttrText(
3257: v_item_type,
3258: context,
3259: attr_name);
3260: if v_debug then