eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_WF dependencies on WF_ENGINE

Line 1022: wf_engine.SetItemAttrText(itemtype => p_itemtype,

1018: l_proc VARCHAR2(61) := g_package || 'set_fyi_user';
1019: BEGIN
1020: hr_utility.set_location(l_proc || ' Entering',10);
1021: hr_utility.set_location(l_proc || ' p_fyi_user '|| p_fyi_user,20);
1022: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1023: itemkey => p_ItemKey,
1024: aname => 'FYI_USER',
1025: avalue => p_fyi_user );
1026: hr_utility.set_location(l_proc || ' Exiting',100);

Line 1086: wf_engine.SetItemAttrText(itemtype => p_itemtype,

1082: hr_utility.set_location(l_proc || 'p_status '|| p_status,30);
1083: IF NOT wf_process_not_running (p_itemkey => p_itemkey
1084: , p_itemtype => p_itemtype) THEN
1085: IF p_route_to_user IS NOT NULL THEN
1086: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1087: itemkey => p_ItemKey,
1088: aname => 'ROUTE_TO_USER',
1089: avalue => p_route_to_user );
1090: IF l_status IS NULL AND p_route_to_user IS NOT NULL THEN

Line 1093: wf_engine.SetItemAttrText(itemtype => p_itemtype,

1089: avalue => p_route_to_user );
1090: IF l_status IS NULL AND p_route_to_user IS NOT NULL THEN
1091: l_status := 'FOUND';
1092: END IF;
1093: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1094: itemkey => p_ItemKey,
1095: aname => 'NEXT_USER_STATUS',
1096: avalue => l_status );
1097: ELSE

Line 1098: wf_engine.SetItemAttrText(itemtype => p_itemtype,

1094: itemkey => p_ItemKey,
1095: aname => 'NEXT_USER_STATUS',
1096: avalue => l_status );
1097: ELSE
1098: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1099: itemkey => p_ItemKey,
1100: aname => 'NEXT_USER_STATUS',
1101: avalue => 'NOT_FOUND' );
1102: END IF;

Line 1225: wf_engine.createProcess( ItemType => p_itemtype,

1221: hr_utility.set_location(l_proc || ' Params - p_post_style_cd '|| p_post_style_cd,15);
1222: -- as timeout is in days as per our transaction category form, while
1223: -- workflow keeps the timeout in minutes making changes .
1224: l_timeout_days := nvl(p_timeout_days,0) * 24 * 60;
1225: wf_engine.createProcess( ItemType => p_itemtype,
1226: ItemKey => p_ItemKey,
1227: process => p_process_name );
1228: hr_utility.set_location(l_proc || ' Set timeout',15);
1229: wf_engine.SetItemAttrNumber(itemtype => p_itemtype

Line 1229: wf_engine.SetItemAttrNumber(itemtype => p_itemtype

1225: wf_engine.createProcess( ItemType => p_itemtype,
1226: ItemKey => p_ItemKey,
1227: process => p_process_name );
1228: hr_utility.set_location(l_proc || ' Set timeout',15);
1229: wf_engine.SetItemAttrNumber(itemtype => p_itemtype
1230: , itemkey => p_itemkey
1231: , aname => 'TIMEOUT_DAYS'
1232: , avalue => l_timeout_days);
1233: -- wf_engine.SetItemAttrText( itemtype => p_itemtype

Line 1233: -- wf_engine.SetItemAttrText( itemtype => p_itemtype

1229: wf_engine.SetItemAttrNumber(itemtype => p_itemtype
1230: , itemkey => p_itemkey
1231: , aname => 'TIMEOUT_DAYS'
1232: , avalue => l_timeout_days);
1233: -- wf_engine.SetItemAttrText( itemtype => p_itemtype
1234: -- , itemkey => p_itemkey
1235: -- , aname => 'TRANSACTION_STATUS'
1236: -- , avalue => 'PENDING');
1237: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

Line 1237: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

1233: -- wf_engine.SetItemAttrText( itemtype => p_itemtype
1234: -- , itemkey => p_itemkey
1235: -- , aname => 'TRANSACTION_STATUS'
1236: -- , avalue => 'PENDING');
1237: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
1238: , itemkey => p_itemkey
1239: , aname => 'TRANSACTION_ID'
1240: , avalue => p_transaction_id);
1241: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

Line 1241: wf_engine.SetItemAttrNumber( itemtype => p_itemtype

1237: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
1238: , itemkey => p_itemkey
1239: , aname => 'TRANSACTION_ID'
1240: , avalue => p_transaction_id);
1241: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
1242: , itemkey => p_itemkey
1243: , aname => 'TRANSACTION_CATEGORY_ID'
1244: , avalue => p_transaction_category_id);
1245: wf_engine.SetItemAttrText( itemtype => p_itemtype

Line 1245: wf_engine.SetItemAttrText( itemtype => p_itemtype

1241: wf_engine.SetItemAttrNumber( itemtype => p_itemtype
1242: , itemkey => p_itemkey
1243: , aname => 'TRANSACTION_CATEGORY_ID'
1244: , avalue => p_transaction_category_id);
1245: wf_engine.SetItemAttrText( itemtype => p_itemtype
1246: , itemkey => p_itemkey
1247: , aname => 'TRANSACTION_NAME'
1248: , avalue => p_transaction_name);
1249: hr_utility.set_location('launch url is being set',50);

Line 1250: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1246: , itemkey => p_itemkey
1247: , aname => 'TRANSACTION_NAME'
1248: , avalue => p_transaction_name);
1249: hr_utility.set_location('launch url is being set',50);
1250: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1251: itemkey => p_itemkey,
1252: aname => 'LAUNCH_URL',
1253: avalue => p_launch_url);
1254: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1254: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1250: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1251: itemkey => p_itemkey,
1252: aname => 'LAUNCH_URL',
1253: avalue => p_launch_url);
1254: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1255: itemkey => p_itemkey,
1256: aname => 'TRAN_CAT_NAME',
1257: avalue => p_transaction_category_name);
1258:

Line 1263: wf_engine.SetItemAttrText(itemtype => p_itemtype

1259: l_form_name := l_form_name || ':TRANSACTION_ID=' || to_char(p_transaction_id) || ' ROUTING_HISTORY_ID='||to_char(nvl(p_routing_history_id, 0));
1260:
1261: hr_utility.set_location(l_proc || ' Set form name ' || l_form_name,15);
1262:
1263: wf_engine.SetItemAttrText(itemtype => p_itemtype
1264: , itemkey => p_itemkey
1265: , aname => 'RHT_FORM_NAME'
1266: , avalue => 'PQHWSRHT:TRANSACTION_CATEGORY_ID='||to_char(p_transaction_category_id)
1267: || ' TRANSACTION_ID=' || to_char(p_transaction_id));

Line 1268: wf_engine.SetItemAttrText(itemtype => p_itemtype

1264: , itemkey => p_itemkey
1265: , aname => 'RHT_FORM_NAME'
1266: , avalue => 'PQHWSRHT:TRANSACTION_CATEGORY_ID='||to_char(p_transaction_category_id)
1267: || ' TRANSACTION_ID=' || to_char(p_transaction_id));
1268: wf_engine.SetItemAttrText(itemtype => p_itemtype
1269: , itemkey => p_itemkey
1270: , aname => 'PROCESS_LOG_FORM_NAME'
1271: , avalue => 'PQHWSPLG:TRANSACTION_CATEGORY_ID='||to_char(p_transaction_category_id)
1272: || ' TRANSACTION_ID=' || to_char(p_transaction_id));

Line 1273: wf_engine.SetItemAttrText(itemtype => p_itemtype

1269: , itemkey => p_itemkey
1270: , aname => 'PROCESS_LOG_FORM_NAME'
1271: , avalue => 'PQHWSPLG:TRANSACTION_CATEGORY_ID='||to_char(p_transaction_category_id)
1272: || ' TRANSACTION_ID=' || to_char(p_transaction_id));
1273: wf_engine.SetItemAttrText(itemtype => p_itemtype
1274: , itemkey => p_itemkey
1275: , aname => 'FORM_NAME'
1276: , avalue => l_form_name);
1277: wf_engine.SetItemAttrText(itemtype => p_itemtype

Line 1277: wf_engine.SetItemAttrText(itemtype => p_itemtype

1273: wf_engine.SetItemAttrText(itemtype => p_itemtype
1274: , itemkey => p_itemkey
1275: , aname => 'FORM_NAME'
1276: , avalue => l_form_name);
1277: wf_engine.SetItemAttrText(itemtype => p_itemtype
1278: , itemkey => p_itemkey
1279: , aname => 'POST_TXN_FUNCTION'
1280: , avalue => p_post_txn_function);
1281: wf_engine.SetItemAttrText(itemtype => p_itemtype

Line 1281: wf_engine.SetItemAttrText(itemtype => p_itemtype

1277: wf_engine.SetItemAttrText(itemtype => p_itemtype
1278: , itemkey => p_itemkey
1279: , aname => 'POST_TXN_FUNCTION'
1280: , avalue => p_post_txn_function);
1281: wf_engine.SetItemAttrText(itemtype => p_itemtype
1282: , itemkey => p_itemkey
1283: , aname => 'POST_STYLE_CD'
1284: , avalue => p_post_style_cd);
1285: wf_engine.SetItemAttrText(itemtype => p_itemtype

Line 1285: wf_engine.SetItemAttrText(itemtype => p_itemtype

1281: wf_engine.SetItemAttrText(itemtype => p_itemtype
1282: , itemkey => p_itemkey
1283: , aname => 'POST_STYLE_CD'
1284: , avalue => p_post_style_cd);
1285: wf_engine.SetItemAttrText(itemtype => p_itemtype
1286: , itemkey => p_itemkey
1287: , aname => 'FUTURE_ACTION_CD'
1288: , avalue => p_future_action_cd);
1289: wf_engine.SetItemAttrText(itemtype => p_itemtype

Line 1289: wf_engine.SetItemAttrText(itemtype => p_itemtype

1285: wf_engine.SetItemAttrText(itemtype => p_itemtype
1286: , itemkey => p_itemkey
1287: , aname => 'FUTURE_ACTION_CD'
1288: , avalue => p_future_action_cd);
1289: wf_engine.SetItemAttrText(itemtype => p_itemtype
1290: , itemkey => p_itemkey
1291: , aname => 'TRANSACTION_STATUS'
1292: , avalue => p_user_action_cd);
1293: wf_engine.SetItemAttrDate(itemtype => p_itemtype

Line 1293: wf_engine.SetItemAttrDate(itemtype => p_itemtype

1289: wf_engine.SetItemAttrText(itemtype => p_itemtype
1290: , itemkey => p_itemkey
1291: , aname => 'TRANSACTION_STATUS'
1292: , avalue => p_user_action_cd);
1293: wf_engine.SetItemAttrDate(itemtype => p_itemtype
1294: , itemkey => p_itemkey
1295: , aname => 'EFFECTIVE_DATE'
1296: , avalue => p_effective_date);
1297: wf_engine.SetItemAttrText(itemtype => p_itemtype

Line 1297: wf_engine.SetItemAttrText(itemtype => p_itemtype

1293: wf_engine.SetItemAttrDate(itemtype => p_itemtype
1294: , itemkey => p_itemkey
1295: , aname => 'EFFECTIVE_DATE'
1296: , avalue => p_effective_date);
1297: wf_engine.SetItemAttrText(itemtype => p_itemtype
1298: , itemkey => p_ItemKey
1299: , aname => 'ROUTED_BY_USER'
1300: , avalue => nvl(fnd_profile.value('USERNAME'),p_route_to_user));
1301: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1301: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1297: wf_engine.SetItemAttrText(itemtype => p_itemtype
1298: , itemkey => p_ItemKey
1299: , aname => 'ROUTED_BY_USER'
1300: , avalue => nvl(fnd_profile.value('USERNAME'),p_route_to_user));
1301: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1302: itemkey => p_itemkey,
1303: aname => 'COMMENTS',
1304: avalue => p_comments);
1305: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1305: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1301: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1302: itemkey => p_itemkey,
1303: aname => 'COMMENTS',
1304: avalue => p_comments);
1305: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1306: itemkey => p_itemkey,
1307: aname => 'PARAMETER1_NAME',
1308: avalue => p_parameter1_name);
1309: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1309: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1305: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1306: itemkey => p_itemkey,
1307: aname => 'PARAMETER1_NAME',
1308: avalue => p_parameter1_name);
1309: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1310: itemkey => p_itemkey,
1311: aname => 'PARAMETER1_VALUE',
1312: avalue => p_parameter1_value);
1313: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1313: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1309: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1310: itemkey => p_itemkey,
1311: aname => 'PARAMETER1_VALUE',
1312: avalue => p_parameter1_value);
1313: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1314: itemkey => p_itemkey,
1315: aname => 'PARAMETER2_NAME',
1316: avalue => p_parameter2_name);
1317: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1317: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1313: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1314: itemkey => p_itemkey,
1315: aname => 'PARAMETER2_NAME',
1316: avalue => p_parameter2_name);
1317: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1318: itemkey => p_itemkey,
1319: aname => 'PARAMETER2_VALUE',
1320: avalue => p_parameter2_value);
1321: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1321: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1317: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1318: itemkey => p_itemkey,
1319: aname => 'PARAMETER2_VALUE',
1320: avalue => p_parameter2_value);
1321: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1322: itemkey => p_itemkey,
1323: aname => 'PARAMETER3_NAME',
1324: avalue => p_parameter3_name);
1325: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1325: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1321: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1322: itemkey => p_itemkey,
1323: aname => 'PARAMETER3_NAME',
1324: avalue => p_parameter3_name);
1325: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1326: itemkey => p_itemkey,
1327: aname => 'PARAMETER3_VALUE',
1328: avalue => p_parameter3_value);
1329: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1329: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1325: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1326: itemkey => p_itemkey,
1327: aname => 'PARAMETER3_VALUE',
1328: avalue => p_parameter3_value);
1329: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1330: itemkey => p_itemkey,
1331: aname => 'PARAMETER4_NAME',
1332: avalue => p_parameter4_name);
1333: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1333: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1329: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1330: itemkey => p_itemkey,
1331: aname => 'PARAMETER4_NAME',
1332: avalue => p_parameter4_name);
1333: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1334: itemkey => p_itemkey,
1335: aname => 'PARAMETER4_VALUE',
1336: avalue => p_parameter4_value);
1337: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1337: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1333: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1334: itemkey => p_itemkey,
1335: aname => 'PARAMETER4_VALUE',
1336: avalue => p_parameter4_value);
1337: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1338: itemkey => p_itemkey,
1339: aname => 'PARAMETER5_NAME',
1340: avalue => p_parameter5_name);
1341: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1341: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1337: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1338: itemkey => p_itemkey,
1339: aname => 'PARAMETER5_NAME',
1340: avalue => p_parameter5_name);
1341: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1342: itemkey => p_itemkey,
1343: aname => 'PARAMETER5_VALUE',
1344: avalue => p_parameter5_value);
1345: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1345: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1341: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1342: itemkey => p_itemkey,
1343: aname => 'PARAMETER5_VALUE',
1344: avalue => p_parameter5_value);
1345: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1346: itemkey => p_itemkey,
1347: aname => 'PARAMETER6_NAME',
1348: avalue => p_parameter6_name);
1349: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1349: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1345: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1346: itemkey => p_itemkey,
1347: aname => 'PARAMETER6_NAME',
1348: avalue => p_parameter6_name);
1349: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1350: itemkey => p_itemkey,
1351: aname => 'PARAMETER6_VALUE',
1352: avalue => p_parameter6_value);
1353: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1353: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1349: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1350: itemkey => p_itemkey,
1351: aname => 'PARAMETER6_VALUE',
1352: avalue => p_parameter6_value);
1353: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1354: itemkey => p_itemkey,
1355: aname => 'PARAMETER7_NAME',
1356: avalue => p_parameter7_name);
1357: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1357: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1353: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1354: itemkey => p_itemkey,
1355: aname => 'PARAMETER7_NAME',
1356: avalue => p_parameter7_name);
1357: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1358: itemkey => p_itemkey,
1359: aname => 'PARAMETER7_VALUE',
1360: avalue => p_parameter7_value);
1361: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1361: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1357: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1358: itemkey => p_itemkey,
1359: aname => 'PARAMETER7_VALUE',
1360: avalue => p_parameter7_value);
1361: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1362: itemkey => p_itemkey,
1363: aname => 'PARAMETER8_NAME',
1364: avalue => p_parameter8_name);
1365: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1365: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1361: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1362: itemkey => p_itemkey,
1363: aname => 'PARAMETER8_NAME',
1364: avalue => p_parameter8_name);
1365: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1366: itemkey => p_itemkey,
1367: aname => 'PARAMETER8_VALUE',
1368: avalue => p_parameter8_value);
1369: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1369: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1365: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1366: itemkey => p_itemkey,
1367: aname => 'PARAMETER8_VALUE',
1368: avalue => p_parameter8_value);
1369: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1370: itemkey => p_itemkey,
1371: aname => 'PARAMETER9_NAME',
1372: avalue => p_parameter9_name);
1373: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1373: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1369: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1370: itemkey => p_itemkey,
1371: aname => 'PARAMETER9_NAME',
1372: avalue => p_parameter9_name);
1373: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1374: itemkey => p_itemkey,
1375: aname => 'PARAMETER9_VALUE',
1376: avalue => p_parameter9_value);
1377: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1377: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1373: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1374: itemkey => p_itemkey,
1375: aname => 'PARAMETER9_VALUE',
1376: avalue => p_parameter9_value);
1377: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1378: itemkey => p_itemkey,
1379: aname => 'PARAMETER10_NAME',
1380: avalue => p_parameter10_name);
1381: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 1381: wf_engine.SetItemAttrText( itemtype => p_itemtype,

1377: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1378: itemkey => p_itemkey,
1379: aname => 'PARAMETER10_NAME',
1380: avalue => p_parameter10_name);
1381: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1382: itemkey => p_itemkey,
1383: aname => 'PARAMETER10_VALUE',
1384: avalue => p_parameter10_value);
1385: hr_utility.set_location(l_proc || ' p_route_to_user' || p_route_to_user,15);

Line 1388: wf_engine.SetItemAttrText(itemtype => p_itemtype,

1384: avalue => p_parameter10_value);
1385: hr_utility.set_location(l_proc || ' p_route_to_user' || p_route_to_user,15);
1386: hr_utility.set_location(l_proc || ' p_user_status ' || p_user_status,15);
1387: IF p_route_to_user IS NOT NULL THEN
1388: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1389: itemkey => p_ItemKey,
1390: aname => 'ROUTE_TO_USER',
1391: avalue => p_route_to_user );
1392: wf_engine.SetItemAttrText(itemtype => p_itemtype,

Line 1392: wf_engine.SetItemAttrText(itemtype => p_itemtype,

1388: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1389: itemkey => p_ItemKey,
1390: aname => 'ROUTE_TO_USER',
1391: avalue => p_route_to_user );
1392: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1393: itemkey => p_ItemKey,
1394: aname => 'NEXT_USER_STATUS',
1395: avalue => p_user_status );
1396: ELSE

Line 1397: wf_engine.SetItemAttrText(itemtype => p_itemtype,

1393: itemkey => p_ItemKey,
1394: aname => 'NEXT_USER_STATUS',
1395: avalue => p_user_status );
1396: ELSE
1397: wf_engine.SetItemAttrText(itemtype => p_itemtype,
1398: itemkey => p_ItemKey,
1399: aname => 'NEXT_USER_STATUS',
1400: avalue => 'NOT_FOUND' );
1401: END IF;

Line 1403: wf_engine.StartProcess ( ItemType => p_itemtype,

1399: aname => 'NEXT_USER_STATUS',
1400: avalue => 'NOT_FOUND' );
1401: END IF;
1402: hr_utility.set_location(l_proc || ' Start Process',15);
1403: wf_engine.StartProcess ( ItemType => p_itemtype,
1404: ItemKey => p_ItemKey );
1405: hr_utility.set_location(l_proc || ' Exiting ',100);
1406: End;
1407: PROCEDURE get_apply_error(p_itemkey IN VARCHAR2,

Line 1415: p_apply_error_mesg := wf_engine.GetItemAttrText(

1411: IS
1412: l_proc varchar2(61) := g_package ||'get_error' ;
1413: BEGIN
1414: hr_utility.set_location(l_proc || ' Entering',10);
1415: p_apply_error_mesg := wf_engine.GetItemAttrText(
1416: itemtype => p_workflow_name,
1417: itemkey => p_itemkey,
1418: aname => 'APPLY_ERROR_MESG');
1419: hr_utility.set_location(l_proc || 'apply_msg'||substr(p_apply_error_mesg,1,26),20);

Line 1421: p_apply_error_num := wf_engine.GetItemAttrText(

1417: itemkey => p_itemkey,
1418: aname => 'APPLY_ERROR_MESG');
1419: hr_utility.set_location(l_proc || 'apply_msg'||substr(p_apply_error_mesg,1,26),20);
1420: hr_utility.set_location(l_proc || 'apply_msg'||substr(p_apply_error_mesg,27,26),21);
1421: p_apply_error_num := wf_engine.GetItemAttrText(
1422: itemtype => p_workflow_name,
1423: itemkey => p_itemkey,
1424: aname => 'APPLY_ERROR_NUM');
1425: hr_utility.set_location(l_proc || 'apply_code'||p_apply_error_num,30);

Line 1441: wf_engine.SetItemAttrText(

1437: hr_utility.set_location(l_proc || ' workflow_name'||p_workflow_name,30);
1438: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,1,26),31);
1439: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,27,26),32);
1440: hr_utility.set_location(l_proc || ' error_num'||p_apply_error_num,33);
1441: wf_engine.SetItemAttrText(
1442: itemtype => p_workflow_name,
1443: itemkey => p_itemkey,
1444: aname => 'APPLY_ERROR_MESG',
1445: avalue => p_apply_error_mesg);

Line 1448: wf_engine.SetItemAttrText(

1444: aname => 'APPLY_ERROR_MESG',
1445: avalue => p_apply_error_mesg);
1446: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,1,26),35);
1447: hr_utility.set_location(l_proc || ' error_mesg'||substr(p_apply_error_mesg,27,26),35);
1448: wf_engine.SetItemAttrText(
1449: itemtype => p_workflow_name,
1450: itemkey => p_itemkey,
1451: aname => 'APPLY_ERROR_NUM',
1452: avalue => p_apply_error_num);

Line 1801: wf_engine.SetItemAttrText(

1797: , p_itemkey => l_itemkey
1798: , p_route_to_user => l_route_to_user
1799: , p_status => p_user_status
1800: );
1801: wf_engine.SetItemAttrText(
1802: itemtype => l_workflow_name,
1803: itemkey => l_itemkey,
1804: aname => 'TRANSACTION_NAME',
1805: avalue => p_transaction_name);

Line 1806: wf_engine.SetItemAttrText(

1802: itemtype => l_workflow_name,
1803: itemkey => l_itemkey,
1804: aname => 'TRANSACTION_NAME',
1805: avalue => p_transaction_name);
1806: wf_engine.SetItemAttrText(
1807: itemtype => l_workflow_name,
1808: itemkey => l_itemkey,
1809: aname => 'TRAN_CAT_NAME',
1810: avalue => l_transaction_category_name);

Line 1812: wf_engine.CompleteActivity(

1808: itemkey => l_itemkey,
1809: aname => 'TRAN_CAT_NAME',
1810: avalue => l_transaction_category_name);
1811: l_activity := get_respond_activity(l_itemkey);
1812: wf_engine.CompleteActivity(
1813: l_workflow_name
1814: , l_itemkey
1815: , l_activity
1816: , l_user_action_cd);

Line 1844: l_form_name := wf_engine.GetItemAttrText(itemtype => l_workflow_name

1840: , p_forwarded_by_member_id => p_forwarded_by_member_id
1841: , p_routing_history_id => l_routing_history_id
1842: );
1843: IF not l_wf_not_running THEN -- Create a new workflow process
1844: l_form_name := wf_engine.GetItemAttrText(itemtype => l_workflow_name
1845: , itemkey => l_itemkey
1846: , aname => 'FORM_NAME'
1847: );
1848: l_pos := instr(l_form_name, ' ROUTIN');

Line 1855: wf_engine.SetItemAttrText(itemtype => l_workflow_name

1851: end if;
1852: l_form_name := l_form_name || ' ROUTING_HISTORY_ID=' || to_char(nvl(l_routing_history_id, 0));
1853:
1854: hr_utility.set_location(l_proc || ' Set form name ' || l_form_name,15);
1855: wf_engine.SetItemAttrText(itemtype => l_workflow_name
1856: , itemkey => l_itemkey
1857: , aname => 'FORM_NAME'
1858: , avalue => l_form_name);
1859: END IF;

Line 1910: wf_engine.SetItemAttrText( itemtype => l_workflow_name,

1906: END IF;
1907: hr_utility.set_location(l_proc || ' l_route_to_user '|| l_route_to_user,50);
1908: hr_utility.set_location(l_proc || ' l_user_action_cd '|| l_user_action_cd,50);
1909:
1910: wf_engine.SetItemAttrText( itemtype => l_workflow_name,
1911: itemkey => l_itemkey,
1912: aname => 'COMMENTS',
1913: avalue => p_comments);
1914: IF NOT l_wf_not_running THEN -- Move forward with the existing workflow process

Line 1916: wf_engine.SetItemAttrText(

1912: aname => 'COMMENTS',
1913: avalue => p_comments);
1914: IF NOT l_wf_not_running THEN -- Move forward with the existing workflow process
1915: hr_utility.set_location(l_proc || ' Completing Activity '||l_activity,60);
1916: wf_engine.SetItemAttrText(
1917: itemtype => l_workflow_name,
1918: itemkey => l_itemkey,
1919: aname => 'TRAN_CAT_NAME',
1920: avalue => l_transaction_category_name);

Line 1922: wf_engine.SetItemAttrDate(

1918: itemkey => l_itemkey,
1919: aname => 'TRAN_CAT_NAME',
1920: avalue => l_transaction_category_name);
1921: hr_utility.set_location(l_proc || ' l_route_to_user '|| l_route_to_user,50);
1922: wf_engine.SetItemAttrDate(
1923: itemtype => l_workflow_name,
1924: itemkey => l_itemkey,
1925: aname => 'EFFECTIVE_DATE',
1926: avalue => p_effective_date);

Line 1927: wf_engine.SetItemAttrText(

1923: itemtype => l_workflow_name,
1924: itemkey => l_itemkey,
1925: aname => 'EFFECTIVE_DATE',
1926: avalue => p_effective_date);
1927: wf_engine.SetItemAttrText(
1928: itemtype => l_workflow_name,
1929: itemkey => l_itemkey,
1930: aname => 'TRANSACTION_STATUS',
1931: avalue => l_user_action_cd);

Line 1932: wf_engine.SetItemAttrText(

1928: itemtype => l_workflow_name,
1929: itemkey => l_itemkey,
1930: aname => 'TRANSACTION_STATUS',
1931: avalue => l_user_action_cd);
1932: wf_engine.SetItemAttrText(
1933: itemtype => l_workflow_name,
1934: itemkey => l_itemkey,
1935: aname => 'TRANSACTION_NAME',
1936: avalue => p_transaction_name);

Line 1939: wf_engine.SetItemAttrText( itemtype => l_workflow_name,

1935: aname => 'TRANSACTION_NAME',
1936: avalue => p_transaction_name);
1937: --added by kgowripe for fixing 2897321
1938: hr_utility.set_location('resetting launch url ',51);
1939: wf_engine.SetItemAttrText( itemtype => l_workflow_name,
1940: itemkey => l_itemkey,
1941: aname => 'LAUNCH_URL',
1942: avalue => l_url);
1943: --changes end here kgowripe

Line 1962: wf_engine.CompleteActivity(

1958: l_activity := get_respond_activity(l_itemkey);
1959: hr_utility.set_location(l_proc || ' activity is '||l_activity,68);
1960: hr_utility.set_location(l_proc || ' action_cd is '||l_user_action_cd,69);
1961: begin
1962: wf_engine.CompleteActivity(
1963: l_workflow_name
1964: , l_itemkey
1965: , l_activity
1966: , l_user_action_cd);

Line 2024: wf_engine.CompleteActivity(

2020: , p_itemkey => l_itemkey
2021: , p_route_to_user => p_route_to_user
2022: , p_status => p_user_status
2023: );
2024: wf_engine.CompleteActivity(
2025: l_workflow_name
2026: , l_itemkey
2027: , 'BLOCK'
2028: , 'REROUTE');

Line 2098: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,

2094: BEGIN
2095: hr_utility.set_location(l_proc || ' Entering',10);
2096: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2097: IF (FUNCMODE = 'RUN') THEN
2098: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,
2099: itemkey => ItemKey,
2100: aname => 'TRANSACTION_STATUS');
2101: hr_utility.set_location(l_proc || ' user action code ' || l_user_action_cd, 25);
2102: --ns:26-Jun-2006: Bug 5357676: Set routed_by_user for correct From to appear in fyi notification.

Line 2103: wf_engine.SetItemAttrText(itemtype => itemtype

2099: itemkey => ItemKey,
2100: aname => 'TRANSACTION_STATUS');
2101: hr_utility.set_location(l_proc || ' user action code ' || l_user_action_cd, 25);
2102: --ns:26-Jun-2006: Bug 5357676: Set routed_by_user for correct From to appear in fyi notification.
2103: wf_engine.SetItemAttrText(itemtype => itemtype
2104: , itemkey => itemKey
2105: , aname => 'ROUTED_BY_USER'
2106: , avalue => FND_GLOBAL.user_name );
2107: --ns: end fix for 5357676

Line 2109: l_user := wf_engine.GetItemAttrText(itemtype => itemtype,

2105: , aname => 'ROUTED_BY_USER'
2106: , avalue => FND_GLOBAL.user_name );
2107: --ns: end fix for 5357676
2108: IF l_user_action_cd in ('FYI_NOT','PQH_BPR') THEN
2109: l_user := wf_engine.GetItemAttrText(itemtype => itemtype,
2110: itemkey => ItemKey,
2111: aname => 'ROUTE_TO_USER');
2112: hr_utility.set_location(l_proc || ' user ' || l_user, 28);
2113: SET_FYI_USER (

Line 2238: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,

2234: hr_utility.set_location(l_proc || ' Entering',10);
2235: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2236: IF (FUNCMODE = 'RUN') THEN
2237: create_process_log('Find Notice_type ' || itemkey);
2238: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,
2239: itemkey => ItemKey,
2240: aname => 'TRANSACTION_STATUS');
2241: if l_user_action_cd = 'OVERRIDE' then
2242: l_status := 'OVERRIDE';

Line 2285: l_status := wf_engine.GetItemAttrText(itemtype => itemtype,

2281: hr_utility.set_location(l_proc || ' Entering',10);
2282: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2283: IF (FUNCMODE = 'RUN') THEN
2284: create_process_log('Find Next User ' || itemkey);
2285: l_status := wf_engine.GetItemAttrText(itemtype => itemtype,
2286: itemkey => ItemKey,
2287: aname => 'NEXT_USER_STATUS');
2288: l_user := get_last_user(p_itemkey => itemkey);
2289: IF l_user IS NOT NULL THEN

Line 2290: wf_engine.SetItemAttrText(itemtype => itemtype

2286: itemkey => ItemKey,
2287: aname => 'NEXT_USER_STATUS');
2288: l_user := get_last_user(p_itemkey => itemkey);
2289: IF l_user IS NOT NULL THEN
2290: wf_engine.SetItemAttrText(itemtype => itemtype
2291: , itemkey => ItemKey
2292: , aname => 'ROUTED_BY_USER'
2293: , avalue => l_user);
2294: END IF;

Line 2358: l_future_action_cd := wf_engine.GetItemAttrText(

2354: BEGIN
2355: hr_utility.set_location(l_proc || ' Entering',10);
2356: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2357: IF (FUNCMODE = 'RUN') THEN
2358: l_future_action_cd := wf_engine.GetItemAttrText(
2359: itemtype => itemtype,
2360: itemkey => ItemKey,
2361: aname => 'FUTURE_ACTION_CD');
2362: l_post_style_cd := wf_engine.GetItemAttrText(

Line 2362: l_post_style_cd := wf_engine.GetItemAttrText(

2358: l_future_action_cd := wf_engine.GetItemAttrText(
2359: itemtype => itemtype,
2360: itemkey => ItemKey,
2361: aname => 'FUTURE_ACTION_CD');
2362: l_post_style_cd := wf_engine.GetItemAttrText(
2363: itemtype => itemtype,
2364: itemkey => ItemKey,
2365: aname => 'POST_STYLE_CD');
2366: l_effective_date := wf_engine.GetItemAttrDate(

Line 2366: l_effective_date := wf_engine.GetItemAttrDate(

2362: l_post_style_cd := wf_engine.GetItemAttrText(
2363: itemtype => itemtype,
2364: itemkey => ItemKey,
2365: aname => 'POST_STYLE_CD');
2366: l_effective_date := wf_engine.GetItemAttrDate(
2367: itemtype => itemtype,
2368: itemkey => ItemKey,
2369: aname => 'EFFECTIVE_DATE');
2370: create_process_log('APPROVE_TXN : l_effective_date = ' || TO_CHAR(l_effective_date) || ' - ');

Line 2415: l_post_txn_function := wf_engine.GetItemAttrText(

2411: p_apply_error_mesg => l_apply_error_mesg,
2412: p_apply_error_num => l_apply_error_num );
2413: hr_utility.set_location(l_proc || ' After error setting ', 33);
2414: create_process_log('POST_TXN : itemkey = ' || itemkey);
2415: l_post_txn_function := wf_engine.GetItemAttrText(
2416: itemtype => itemtype,
2417: itemkey => ItemKey,
2418: aname => 'POST_TXN_FUNCTION');
2419: decode_itemkey(p_itemkey => itemkey

Line 2456: wf_engine.SetItemAttrText(

2452: p_apply_error_num => l_sqlcode );
2453: hr_utility.set_location(l_proc || ' After error setting ', 33);
2454: END;
2455: IF l_dbupdate = 'SUCCESS' THEN
2456: wf_engine.SetItemAttrText(
2457: itemtype => itemtype,
2458: itemkey => itemkey,
2459: aname => 'TRANSACTION_STATUS',
2460: avalue => 'DBSUCCESS');

Line 2463: wf_engine.SetItemAttrText(

2459: aname => 'TRANSACTION_STATUS',
2460: avalue => 'DBSUCCESS');
2461: result := 'COMPLETE:SUCCESS';
2462: ELSIF l_dbupdate = 'FAILURE' THEN
2463: wf_engine.SetItemAttrText(
2464: itemtype => itemtype,
2465: itemkey => itemkey,
2466: aname => 'TRANSACTION_STATUS',
2467: avalue => 'DBERROR');

Line 2470: wf_engine.SetItemAttrText(

2466: aname => 'TRANSACTION_STATUS',
2467: avalue => 'DBERROR');
2468: result := 'COMPLETE:ERROR';
2469: ELSE
2470: wf_engine.SetItemAttrText(
2471: itemtype => itemtype,
2472: itemkey => itemkey,
2473: aname => 'TRANSACTION_STATUS',
2474: avalue => 'DBWARNING');

Line 2519: l_form_name := wf_engine.GetItemAttrText(itemtype => itemtype,

2515: BEGIN
2516: hr_utility.set_location(l_proc || ' Entering',10);
2517: hr_utility.set_location(l_proc || 'Parameter - Funcmode = ' || funcmode,20);
2518: create_process_log('In ' || l_proc || ' ' || funcmode);
2519: l_form_name := wf_engine.GetItemAttrText(itemtype => itemtype,
2520: itemkey => ItemKey,
2521: aname => 'FORM_NAME');
2522: create_process_log('In ' || l_proc || ' Form Name ' || l_form_name);
2523: IF funcmode IN ('FORWARD', 'TRANSFER') THEN

Line 2531: wf_engine.SetItemAttrText(itemtype => itemtype

2527: IF l_routing_history_id IS NOT NULL THEN
2528: update_routing_history(p_routing_history_id => l_routing_history_id
2529: , p_user_action_cd => 'TIMEOUT');
2530: END IF;
2531: wf_engine.SetItemAttrText(itemtype => itemtype
2532: , itemkey => itemkey
2533: , aname => 'TRANSACTION_STATUS'
2534: , avalue => 'TIMEOUT');
2535: result := 'COMPLETE:TIMEOUT';

Line 2565: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,

2561: BEGIN
2562: hr_utility.set_location(l_proc || ' Entering',10);
2563: hr_utility.set_location(l_proc || ' FuncMode' || funcmode, 20);
2564: IF (FUNCMODE = 'RUN') THEN
2565: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,
2566: itemkey => ItemKey,
2567: aname => 'TRANSACTION_STATUS');
2568: hr_utility.set_location(l_proc || ' User Action '|| l_user_action_cd, 20);
2569: IF l_user_action_cd in ('FYI_NOT','PQH_BPR') THEN

Line 2591: l_user := wf_engine.GetItemAttrText(itemtype => itemtype,

2587: , p_status => 'FOUND'
2588: );
2589: end if;
2590: elsif l_user_action_cd NOT IN ('REJECT','FRC_RJCT', 'APPLY','TIMEOUT') THEN
2591: l_user := wf_engine.GetItemAttrText(itemtype => itemtype,
2592: itemkey => ItemKey,
2593: aname => 'ROUTE_TO_USER');
2594: set_next_user (
2595: p_itemtype => itemtype

Line 2622: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,

2618: BEGIN
2619: hr_utility.set_location(l_proc || ' Entering',10);
2620: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);
2621: IF (FUNCMODE = 'RUN') THEN
2622: l_user_action_cd := wf_engine.GetItemAttrText(itemtype => itemtype,
2623: itemkey => ItemKey,
2624: aname => 'TRANSACTION_STATUS');
2625: result := 'COMPLETE:'||l_user_action_cd;
2626: END IF;

Line 2653: l_post_txn_function := wf_engine.GetItemAttrText(

2649: pragma exception_init (chk_root_not_defined1, -900);
2650: BEGIN
2651: hr_utility.set_location(l_proc || ' Entering',10);
2652: if (funcmode='RUN') then
2653: l_post_txn_function := wf_engine.GetItemAttrText(
2654: itemtype => itemtype,
2655: itemkey => ItemKey,
2656: aname => 'POST_TXN_FUNCTION');
2657: hr_utility.set_location(l_proc ||substr(l_post_txn_function,1,30),15);

Line 2770: wf_engine.CompleteActivity(

2766: procedure complete_delegate_workflow(
2767: p_itemkey in varchar2,
2768: p_workflow_name in varchar2 ) is
2769: begin
2770: wf_engine.CompleteActivity(
2771: p_workflow_name
2772: , p_itemkey
2773: , 'DELEGATE_BLOCK'
2774: , 'COMPLETE');