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.CN_SCA_WF_PKG dependencies on WF_ENGINE

Line 556: wf_engine.createprocess(itemtype => l_itemType,

552: l_itemType := p_wf_item_type;
553:
554: -- Create WF Process
555: -- =================
556: wf_engine.createprocess(itemtype => l_itemType,
557: itemkey => l_itemKey,
558: process => l_process);
559:
560: -- Set Item Attributes

Line 565: wf_engine.setitemattrnumber(itemtype => l_itemType,

561: -- ===================
562:
563: -- 1. sca_batch_id (NUMBER)
564: -- ------------------------
565: wf_engine.setitemattrnumber(itemtype => l_itemType,
566: itemkey => l_itemKey,
567: aname => 'SCA_BATCH_ID',
568: avalue => p_sca_batch_id);
569:

Line 576: wf_engine.setitemattrtext(itemtype => l_itemType,

572: -- get org_id
573: l_orgId := fnd_profile.value('ORG_ID');
574:
575: -- set item attribute
576: wf_engine.setitemattrtext(itemtype => l_itemType,
577: itemkey => l_itemKey,
578: aname => 'ORG_ID',
579: avalue => l_orgId);
580:

Line 598: wf_engine.setitemattrtext(itemtype => l_itemType,

594: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_NO_TRX_SRC'));
595: END;
596:
597: -- set item attribute
598: wf_engine.setitemattrtext(itemtype => l_itemType,
599: itemkey => l_itemKey,
600: aname => 'TRX_SOURCE',
601: avalue => l_trxSrc);
602:

Line 631: wf_engine.setitemattrtext(itemtype => l_itemType,

627: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_NO_PROFILE_VAL'));
628: END IF;
629:
630: -- set item attribute
631: wf_engine.setitemattrtext(itemtype => l_itemType,
632: itemkey => l_itemKey,
633: aname => 'REV_DIST_FUNC',
634: avalue => l_revFunc);
635:

Line 642: wf_engine.startprocess(itemtype => l_itemType,

638: -- defauls to 'Y', so no need to set
639:
640: -- Start WF Process
641: -- ================
642: wf_engine.startprocess(itemtype => l_itemType,
643: itemkey => l_itemKey);
644:
645: -- End of API body
646:

Line 744: wf_engine.createprocess(itemtype => p_wf_item_type,

740: -- =================
741: l_itemKey := p_start_header_id || '-' || p_end_header_id || '.' ||
742: wf_core.random;
743:
744: wf_engine.createprocess(itemtype => p_wf_item_type,
745: itemkey => l_itemKey,
746: process => p_wf_process);
747:
748: -- Set Item Attributes

Line 753: wf_engine.setitemattrnumber(itemtype => l_itemType,

749: -- ===================
750:
751: -- 1. start_header_id (NUMBER)
752: -- ---------------------------
753: wf_engine.setitemattrnumber(itemtype => l_itemType,
754: itemkey => l_itemKey,
755: aname => 'START_HEADER_ID',
756: avalue => p_start_header_id);
757:

Line 760: wf_engine.setitemattrnumber(itemtype => l_itemType,

756: avalue => p_start_header_id);
757:
758: -- 2. end_header_id (NUMBER)
759: -- -------------------------
760: wf_engine.setitemattrnumber(itemtype => l_itemType,
761: itemkey => l_itemKey,
762: aname => 'END_HEADER_ID',
763: avalue => p_end_header_id);
764:

Line 771: wf_engine.setitemattrtext(itemtype => l_itemType,

767: -- get org_id
768: l_orgId := fnd_profile.value('ORG_ID');
769:
770: -- set item attribute
771: wf_engine.setitemattrtext(itemtype => l_itemType,
772: itemkey => l_itemKey,
773: aname => 'ORG_ID',
774: avalue => l_orgId);
775:

Line 779: wf_engine.setitemattrtext(itemtype => l_itemType,

775:
776: -- 4. trx_source (TEXT)
777: -- --------------------
778: -- set item attribute
779: wf_engine.setitemattrtext(itemtype => l_itemType,
780: itemkey => l_itemKey,
781: aname => 'TRX_SOURCE',
782: avalue => p_trx_source);
783:

Line 812: wf_engine.setitemattrtext(itemtype => l_itemType,

808: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_NO_PROFILE_VAL'));
809: END IF;
810:
811: -- set item attribute
812: wf_engine.setitemattrtext(itemtype => l_itemType,
813: itemkey => l_itemKey,
814: aname => 'REV_DIST_FUNC',
815: avalue => l_revFunc);
816:

Line 820: wf_engine.setitemattrtext(itemtype => l_itemType,

816:
817: -- 6. online_flag (TEXT)
818: -- ---------------------
819: -- set item attribute
820: wf_engine.setitemattrtext(itemtype => l_itemType,
821: itemkey => l_itemKey,
822: aname => 'ONLINE_FLAG',
823: avalue => 'N');
824:

Line 827: wf_engine.startprocess(itemtype => l_itemType,

823: avalue => 'N');
824:
825: -- Start WF Process
826: -- ================
827: wf_engine.startprocess(itemtype => l_itemType,
828: itemkey => l_itemKey);
829:
830: -- End of API body
831:

Line 917: -- Modify WF Engine threshold to force deferal of process

913: END IF;
914:
915: l_itemType := p_wf_item_type;
916:
917: -- Modify WF Engine threshold to force deferal of process
918: -- ======================================================
919: l_save_threshold := wf_engine.threshold;
920: wf_engine.threshold := -1;
921:

Line 919: l_save_threshold := wf_engine.threshold;

915: l_itemType := p_wf_item_type;
916:
917: -- Modify WF Engine threshold to force deferal of process
918: -- ======================================================
919: l_save_threshold := wf_engine.threshold;
920: wf_engine.threshold := -1;
921:
922: -- Create WF Process
923: -- =================

Line 920: wf_engine.threshold := -1;

916:
917: -- Modify WF Engine threshold to force deferal of process
918: -- ======================================================
919: l_save_threshold := wf_engine.threshold;
920: wf_engine.threshold := -1;
921:
922: -- Create WF Process
923: -- =================
924: l_itemKey := TO_CHAR(p_start_date,'YYYY/MM/DD') || '-' ||

Line 928: wf_engine.createprocess(itemtype => p_wf_item_type,

924: l_itemKey := TO_CHAR(p_start_date,'YYYY/MM/DD') || '-' ||
925: TO_CHAR(p_end_date,'YYYY/MM/DD') || '.' ||
926: wf_core.random;
927:
928: wf_engine.createprocess(itemtype => p_wf_item_type,
929: itemkey => l_itemKey,
930: process => p_wf_process);
931:
932: -- Set Item Attributes

Line 937: wf_engine.setitemattrdate(itemtype => l_itemType,

933: -- ===================
934:
935: -- 1. start_date (DATE)
936: -- --------------------
937: wf_engine.setitemattrdate(itemtype => l_itemType,
938: itemkey => l_itemKey,
939: aname => 'START_DATE',
940: avalue => p_start_date);
941:

Line 944: wf_engine.setitemattrdate(itemtype => l_itemType,

940: avalue => p_start_date);
941:
942: -- 2. end_date (DATE)
943: -- ------------------
944: wf_engine.setitemattrdate(itemtype => l_itemType,
945: itemkey => l_itemKey,
946: aname => 'END_DATE',
947: avalue => p_end_date);
948:

Line 956: wf_engine.setitemattrtext(itemtype => l_itemType,

952: -- l_orgId := fnd_profile.value('ORG_ID');
953: --l_orgId := p_org_id;
954:
955: -- set item attribute
956: wf_engine.setitemattrtext(itemtype => l_itemType,
957: itemkey => l_itemKey,
958: aname => 'ORG_ID',
959: avalue => p_org_id);
960:

Line 964: wf_engine.setitemattrtext(itemtype => l_itemType,

960:
961: -- 4. trx_source (TEXT)
962: -- --------------------
963: -- set item attribute
964: wf_engine.setitemattrtext(itemtype => l_itemType,
965: itemkey => l_itemKey,
966: aname => 'TRX_SOURCE',
967: avalue => p_trx_source);
968:

Line 971: wf_engine.startprocess(itemtype => l_itemType,

967: avalue => p_trx_source);
968:
969: -- Start WF Process
970: -- ================
971: wf_engine.startprocess(itemtype => l_itemType,
972: itemkey => l_itemKey);
973:
974: -- Restore WF Engine threshold
975: -- ===========================

Line 974: -- Restore WF Engine threshold

970: -- ================
971: wf_engine.startprocess(itemtype => l_itemType,
972: itemkey => l_itemKey);
973:
974: -- Restore WF Engine threshold
975: -- ===========================
976: wf_engine.threshold := l_save_threshold;
977:
978: -- Populate out param

Line 976: wf_engine.threshold := l_save_threshold;

972: itemkey => l_itemKey);
973:
974: -- Restore WF Engine threshold
975: -- ===========================
976: wf_engine.threshold := l_save_threshold;
977:
978: -- Populate out param
979: -- ==================
980: x_wf_item_key := l_itemKey;

Line 1032: resultOut := wf_engine.eng_error || ':' || wf_engine.eng_null;

1028: IF UPPER(itemType) = 'CNSCARPR' THEN
1029: resultOut := 'CN_SCA_REV_DIST_PR';
1030: RETURN;
1031: ELSE
1032: resultOut := wf_engine.eng_error || ':' || wf_engine.eng_null;
1033: -- we do NOT return control to WF, but rather propagate an exception
1034: wf_core.token('NAME',itemType);
1035: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ITEM_TYPE'));
1036: END IF;

Line 1040: resultOut := wf_engine.eng_null;

1036: END IF;
1037: END IF;
1038:
1039: -- ANY OTHER mode (NOT implemented)
1040: resultOut := wf_engine.eng_null;
1041: RETURN;
1042:
1043: EXCEPTION
1044: -- Any other mode but RUN

Line 1098: l_revFunc := wf_engine.getitemattrtext(itemtype => itemType,

1094: -- RUN mode
1095: IF (funcMode = 'RUN') THEN
1096:
1097: -- get rev_dist_func from item
1098: l_revFunc := wf_engine.getitemattrtext(itemtype => itemType,
1099: itemkey => itemKey,
1100: aname => 'REV_DIST_FUNC');
1101:
1102: -- return resultOut

Line 1103: resultOut := wf_engine.eng_completed || ':' || l_revFunc;

1099: itemkey => itemKey,
1100: aname => 'REV_DIST_FUNC');
1101:
1102: -- return resultOut
1103: resultOut := wf_engine.eng_completed || ':' || l_revFunc;
1104: RETURN;
1105:
1106: END IF; -- funcMode = 'RUN'
1107:

Line 1111: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;

1107:
1108: -- CANCEL mode
1109: IF (funcMode = 'CANCEL') THEN
1110:
1111: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;
1112: RETURN;
1113:
1114: END IF;
1115:

Line 1117: resultOut := wf_engine.eng_null;

1113:
1114: END IF;
1115:
1116: -- ANY OTHER mode (NOT implemented)
1117: resultOut := wf_engine.eng_null;
1118: RETURN;
1119:
1120: EXCEPTION
1121: WHEN OTHERS THEN

Line 1176: l_orgId := wf_engine.getitemattrtext(itemtype => itemType,

1172:
1173: IF (funcMode = 'RUN') THEN
1174:
1175: -- get attr ORG_ID
1176: l_orgId := wf_engine.getitemattrtext(itemtype => itemType,
1177: itemkey => itemKey ,
1178: aname => 'ORG_ID');
1179:
1180: -- set org context

Line 1184: l_onlineFlag := wf_engine.getitemattrtext(itemtype => itemType,

1180: -- set org context
1181: fnd_client_info.set_org_context(l_orgId);
1182:
1183: -- get attr online_flag
1184: l_onlineFlag := wf_engine.getitemattrtext(itemtype => itemType,
1185: itemkey => itemKey ,
1186: aname => 'ONLINE_FLAG');
1187:
1188: -- get attr and execute even distribution process according to online flag

Line 1191: l_scaBatchId := wf_engine.getitemattrnumber(itemtype => itemType,

1187:
1188: -- get attr and execute even distribution process according to online flag
1189: IF (l_onlineFlag = 'Y') THEN
1190: -- get attr sca_batch_id
1191: l_scaBatchId := wf_engine.getitemattrnumber(itemtype => itemType,
1192: itemkey => itemKey ,
1193: aname => 'SCA_BATCH_ID');
1194:
1195: -- call private procedure

Line 1202: l_startHeaderId := wf_engine.getitemattrnumber(itemtype => itemType,

1198: x_return_status => l_return_status);
1199:
1200: ELSIF (l_onlineFlag = 'N') THEN
1201: -- get attr start_header_id
1202: l_startHeaderId := wf_engine.getitemattrnumber(itemtype => itemType,
1203: itemkey => itemKey ,
1204: aname => 'START_HEADER_ID');
1205:
1206: -- get attr end_header_id

Line 1207: l_endHeaderId := wf_engine.getitemattrnumber(itemtype => itemType,

1203: itemkey => itemKey ,
1204: aname => 'START_HEADER_ID');
1205:
1206: -- get attr end_header_id
1207: l_endHeaderId := wf_engine.getitemattrnumber(itemtype => itemType,
1208: itemkey => itemKey ,
1209: aname => 'END_HEADER_ID');
1210:
1211: -- call private procedure

Line 1226: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;

1222: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: END IF;
1225:
1226: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;
1227: RETURN;
1228:
1229: END IF;
1230:

Line 1234: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;

1230:
1231: -- CANCEL mode
1232: IF (funcMode = 'CANCEL') THEN
1233:
1234: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;
1235: RETURN;
1236:
1237: END IF;
1238:

Line 1240: resultOut := wf_engine.eng_null;

1236:
1237: END IF;
1238:
1239: -- ANY OTHER mode (NOT implemented)
1240: resultOut := wf_engine.eng_null;
1241: RETURN;
1242:
1243: EXCEPTION
1244: WHEN OTHERS THEN

Line 1299: l_orgId := wf_engine.getitemattrtext(itemtype => itemType,

1295:
1296: IF (funcMode = 'RUN') THEN
1297:
1298: -- get attr ORG_ID
1299: l_orgId := wf_engine.getitemattrtext(itemtype => itemType,
1300: itemkey => itemKey ,
1301: aname => 'ORG_ID');
1302:
1303: -- set org context

Line 1307: l_onlineFlag := wf_engine.getitemattrtext(itemtype => itemType,

1303: -- set org context
1304: fnd_client_info.set_org_context(l_orgId);
1305:
1306: -- get attr online_flag
1307: l_onlineFlag := wf_engine.getitemattrtext(itemtype => itemType,
1308: itemkey => itemKey ,
1309: aname => 'ONLINE_FLAG');
1310:
1311: -- get attr and execute weighted average distribution process according to online flag

Line 1314: l_scaBatchId := wf_engine.getitemattrnumber(itemtype => itemType,

1310:
1311: -- get attr and execute weighted average distribution process according to online flag
1312: IF (l_onlineFlag = 'Y') THEN
1313: -- get attr sca_batch_id
1314: l_scaBatchId := wf_engine.getitemattrnumber(itemtype => itemType,
1315: itemkey => itemKey ,
1316: aname => 'SCA_BATCH_ID');
1317:
1318: -- call private procedure

Line 1326: l_startHeaderId := wf_engine.getitemattrnumber(itemtype => itemType,

1322:
1323: ELSIF (l_onlineFlag = 'N') THEN
1324:
1325: -- get attr start_header_id
1326: l_startHeaderId := wf_engine.getitemattrnumber(itemtype => itemType,
1327: itemkey => itemKey ,
1328: aname => 'START_HEADER_ID');
1329:
1330: -- get attr end_header_id

Line 1331: l_endHeaderId := wf_engine.getitemattrnumber(itemtype => itemType,

1327: itemkey => itemKey ,
1328: aname => 'START_HEADER_ID');
1329:
1330: -- get attr end_header_id
1331: l_endHeaderId := wf_engine.getitemattrnumber(itemtype => itemType,
1332: itemkey => itemKey ,
1333: aname => 'END_HEADER_ID');
1334:
1335: -- call private procedure

Line 1350: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;

1346: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1348: END IF;
1349:
1350: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;
1351: RETURN;
1352:
1353: END IF;
1354:

Line 1358: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;

1354:
1355: -- CANCEL mode
1356: IF (funcMode = 'CANCEL') THEN
1357:
1358: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;
1359: RETURN;
1360:
1361: END IF;
1362:

Line 1364: resultOut := wf_engine.eng_null;

1360:
1361: END IF;
1362:
1363: -- ANY OTHER mode (NOT implemented)
1364: resultOut := wf_engine.eng_null;
1365: RETURN;
1366:
1367: EXCEPTION
1368: WHEN OTHERS THEN

Line 1420: l_trxSrc := wf_engine.getitemattrtext(itemtype => itemType,

1416: -- RUN mode
1417: IF (funcMode = 'RUN') THEN
1418:
1419: -- get rev_dist_func from item
1420: l_trxSrc := wf_engine.getitemattrtext(itemtype => itemType,
1421: itemkey => itemKey,
1422: aname => 'TRX_SOURCE');
1423:
1424: -- if l_trxSrc is NOT CN, then set to 'CUSTOM'

Line 1430: resultOut := wf_engine.eng_completed || ':' || l_trxSrc;

1426: l_trxSrc := 'CUSTOM';
1427: END IF;
1428:
1429: -- return resultOut
1430: resultOut := wf_engine.eng_completed || ':' || l_trxSrc;
1431: RETURN;
1432:
1433: END IF; -- funcMode = 'RUN'
1434:

Line 1438: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;

1434:
1435: -- CANCEL mode
1436: IF (funcMode = 'CANCEL') THEN
1437:
1438: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;
1439: RETURN;
1440:
1441: END IF;
1442:

Line 1444: resultOut := wf_engine.eng_null;

1440:
1441: END IF;
1442:
1443: -- ANY OTHER mode (NOT implemented)
1444: resultOut := wf_engine.eng_null;
1445: RETURN;
1446:
1447: EXCEPTION
1448: WHEN OTHERS THEN

Line 1507: l_startDate := wf_engine.getitemattrdate(itemtype => itemType,

1503: -- Get Item Attributes
1504: -- ===================
1505:
1506: -- get start_date
1507: l_startDate := wf_engine.getitemattrdate(itemtype => itemType,
1508: itemkey => itemKey,
1509: aname => 'START_DATE');
1510:
1511: -- get end_date

Line 1512: l_endDate := wf_engine.getitemattrdate(itemtype => itemType,

1508: itemkey => itemKey,
1509: aname => 'START_DATE');
1510:
1511: -- get end_date
1512: l_endDate := wf_engine.getitemattrdate(itemtype => itemType,
1513: itemkey => itemKey,
1514: aname => 'END_DATE');
1515:
1516: -- get attr ORG_ID

Line 1517: l_orgId := wf_engine.getitemattrtext(itemtype => itemType,

1513: itemkey => itemKey,
1514: aname => 'END_DATE');
1515:
1516: -- get attr ORG_ID
1517: l_orgId := wf_engine.getitemattrtext(itemtype => itemType,
1518: itemkey => itemKey ,
1519: aname => 'ORG_ID');
1520:
1521: -- set org context

Line 1536: wf_engine.setitemattrnumber(itemtype => itemType,

1532: x_process_audit_id => l_process_audit_id);
1533:
1534: -- set attr PROCESS_AUDIT_ID (if not NULL, regardless of return status)
1535: IF (l_process_audit_id <> NULL) THEN
1536: wf_engine.setitemattrnumber(itemtype => itemType,
1537: itemkey => itemKey,
1538: aname => 'PROCESS_AUDIT_ID',
1539: avalue => l_process_audit_id);
1540: END IF;

Line 1550: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;

1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1547: END IF;
1548:
1549: -- return resultOut
1550: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;
1551: RETURN;
1552:
1553: END IF; -- funcMode = 'RUN'
1554:

Line 1558: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;

1554:
1555: -- CANCEL mode
1556: IF (funcMode = 'CANCEL') THEN
1557:
1558: resultOut := wf_engine.eng_completed || ':' || wf_engine.eng_null;
1559: RETURN;
1560:
1561: END IF;
1562:

Line 1564: resultOut := wf_engine.eng_null;

1560:
1561: END IF;
1562:
1563: -- ANY OTHER mode (NOT implemented)
1564: resultOut := wf_engine.eng_null;
1565: RETURN;
1566:
1567: EXCEPTION
1568: WHEN OTHERS THEN