DBA Data[Home] [Help]

APPS.CSF_ALERTS_PUB dependencies on WF_ENGINE

Line 773: wf_engine.createprocess(itemtype => itemtype,

769: end if;
770:
771: itemtype := 'CSFALERT';
772:
773: wf_engine.createprocess(itemtype => itemtype,
774: itemkey => itemkey,
775: process => 'MAIN_PROCESS');
776:
777: wf_engine.setItemAttrNumber(itemtype => itemtype,

Line 777: wf_engine.setItemAttrNumber(itemtype => itemtype,

773: wf_engine.createprocess(itemtype => itemtype,
774: itemkey => itemkey,
775: process => 'MAIN_PROCESS');
776:
777: wf_engine.setItemAttrNumber(itemtype => itemtype,
778: itemkey => itemkey,
779: aname => 'TASK_ASSGN_ID',
780: avalue => l_task_asgn_id);
781:

Line 782: wf_engine.setItemAttrNumber(itemtype => itemtype,

778: itemkey => itemkey,
779: aname => 'TASK_ASSGN_ID',
780: avalue => l_task_asgn_id);
781:
782: wf_engine.setItemAttrNumber(itemtype => itemtype,
783: itemkey => itemkey,
784: aname => 'RES_ID',
785: avalue => l_resource_id);
786:

Line 787: wf_engine.setItemAttrText(itemtype => itemtype,

783: itemkey => itemkey,
784: aname => 'RES_ID',
785: avalue => l_resource_id);
786:
787: wf_engine.setItemAttrText(itemtype => itemtype,
788: itemkey => itemkey,
789: aname => 'RES_TYPE',
790: avalue => l_resource_type);
791:

Line 792: wf_engine.setItemAttrText(itemtype => itemtype,

788: itemkey => itemkey,
789: aname => 'RES_TYPE',
790: avalue => l_resource_type);
791:
792: wf_engine.setItemAttrText(itemtype => itemtype,
793: itemkey => itemkey,
794: aname => 'EVENT_TYPE',
795: avalue => l_csfw_event_type);
796:

Line 797: wf_engine.setItemAttrText(itemtype => itemtype,

793: itemkey => itemkey,
794: aname => 'EVENT_TYPE',
795: avalue => l_csfw_event_type);
796:
797: wf_engine.setItemAttrText(itemtype => itemtype,
798: itemkey => itemkey,
799: aname => 'RESOURCE',
800: avalue => l_resource);
801:

Line 802: wf_engine.setItemAttrText(itemtype => itemtype,

798: itemkey => itemkey,
799: aname => 'RESOURCE',
800: avalue => l_resource);
801:
802: wf_engine.setItemAttrText(itemtype => itemtype,
803: itemkey => itemkey,
804: aname => 'DOCUMENT_ID',
805: avalue => l_document_id);
806:

Line 807: wf_engine.setItemAttrText(itemtype => itemtype,

803: itemkey => itemkey,
804: aname => 'DOCUMENT_ID',
805: avalue => l_document_id);
806:
807: wf_engine.setItemAttrText(itemtype => itemtype,
808: itemkey => itemkey,
809: aname => 'MSG_SUBJECT',
810: avalue => l_msg_subject);
811:

Line 812: wf_engine.setItemAttrText(itemtype => itemtype,

808: itemkey => itemkey,
809: aname => 'MSG_SUBJECT',
810: avalue => l_msg_subject);
811:
812: wf_engine.setItemAttrText(itemtype => itemtype,
813: itemkey => itemkey,
814: aname => 'MSG_SUBJECT2',
815: avalue => l_msg_subject2);
816:

Line 829: wf_engine.setItemAttrText(itemtype => itemtype,

825: else
826: l_auto_reject := 'FALSE';
827: end if;
828:
829: wf_engine.setItemAttrText(itemtype => itemtype,
830: itemkey => itemkey,
831: aname => 'AUTO_REJECT_VALUE',
832: avalue => l_auto_reject);
833:

Line 841: wf_engine.setItemAttrNumber(itemtype => itemtype,

837: 513,
838: null,
839: null);
840:
841: wf_engine.setItemAttrNumber(itemtype => itemtype,
842: itemkey => itemkey,
843: aname => 'TIMEOUT1',
844: avalue => l_time_out1);
845:

Line 853: wf_engine.setItemAttrNumber(itemtype => itemtype,

849: 513,
850: null,
851: null);
852:
853: wf_engine.setItemAttrNumber(itemtype => itemtype,
854: itemkey => itemkey,
855: aname => 'TIMEOUT2',
856: avalue => l_time_out2);
857:

Line 859: wf_engine.setItemAttrNumber(itemtype => itemtype,

855: aname => 'TIMEOUT2',
856: avalue => l_time_out2);
857:
858: -- original task assignment status id
859: wf_engine.setItemAttrNumber(itemtype => itemtype,
860: itemkey => itemkey,
861: aname => 'ORG_TSK_ASG_STS_ID',
862: avalue => l_org_assignment_status_id);
863:

Line 864: wf_engine.startprocess(itemtype => itemtype,

860: itemkey => itemkey,
861: aname => 'ORG_TSK_ASG_STS_ID',
862: avalue => l_org_assignment_status_id);
863:
864: wf_engine.startprocess(itemtype => itemtype,
865: itemkey => itemkey);
866:
867: return 'SUCCESS';
868:

Line 879: l_event_type := wf_engine.GetItemAttrText(itemtype => itemtype,

875: resultout out nocopy varchar2) is
876:
877: l_event_type varchar2(20);
878: begin
879: l_event_type := wf_engine.GetItemAttrText(itemtype => itemtype,
880: itemkey => itemkey,
881: aname => 'EVENT_TYPE');
882: resultout := 'COMPLETE:' || l_event_type;
883: end;

Line 949: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

945: begin
946:
947: resultout := 'COMPLETE:F';
948:
949: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
950: itemkey => itemkey,
951: aname => 'TASK_ASSGN_ID');
952:
953: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 953: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

949: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
950: itemkey => itemkey,
951: aname => 'TASK_ASSGN_ID');
952:
953: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
954: itemkey => itemkey,
955: aname => 'ORG_TSK_ASG_STS_ID');
956:
957:

Line 996: l_AUTO_REJECT_VALUE := wf_engine.GetItemAttrText(itemtype => itemtype,

992: l_AUTO_REJECT_VALUE varchar2(25);
993:
994: begin
995: resultout := 'COMPLETE:F';
996: l_AUTO_REJECT_VALUE := wf_engine.GetItemAttrText(itemtype => itemtype,
997: itemkey => itemkey,
998: aname => 'AUTO_REJECT_VALUE');
999: if l_AUTO_REJECT_VALUE = 'TRUE' then
1000: -- bug # 5845177

Line 1001: wf_engine.setItemAttrText(itemtype => itemtype,

997: itemkey => itemkey,
998: aname => 'AUTO_REJECT_VALUE');
999: if l_AUTO_REJECT_VALUE = 'TRUE' then
1000: -- bug # 5845177
1001: wf_engine.setItemAttrText(itemtype => itemtype,
1002: itemkey => itemkey,
1003: aname => 'IS_AUTO_REJECT',
1004: avalue => 'Y');
1005: resultout := 'COMPLETE:T';

Line 1042: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1038: FROM
1039: jtf_task_assignments jta
1040: WHERE jta.task_assignment_id = v_task_assgn_id;
1041: begin
1042: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1043: itemkey => itemkey,
1044: aname => 'TASK_ASSGN_ID');
1045:
1046: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1046: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1042: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1043: itemkey => itemkey,
1044: aname => 'TASK_ASSGN_ID');
1045:
1046: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1047: itemkey => itemkey,
1048: aname => 'ORG_TSK_ASG_STS_ID');
1049:
1050: open c_task_assgn_detail(l_task_assgn_id);

Line 1063: l_resource_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1059: resultout := 'COMPLETE';
1060:
1061: if l_org_assignment_status_id = l_curr_assignment_status_id then
1062:
1063: l_resource_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1064: itemkey => itemkey,
1065: aname => 'RES_ID');
1066:
1067: l_resource_type := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1067: l_resource_type := wf_engine.GetItemAttrText(itemtype => itemtype,

1063: l_resource_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1064: itemkey => itemkey,
1065: aname => 'RES_ID');
1066:
1067: l_resource_type := wf_engine.GetItemAttrText(itemtype => itemtype,
1068: itemkey => itemkey,
1069: aname => 'RES_TYPE');
1070:
1071: p_user_id := getUserId(l_resource_id, l_resource_type);

Line 1159: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1155: select task_id
1156: from jtf_task_assignments
1157: where task_assignment_id = v_task_asgn_id;
1158: begin
1159: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1160: itemkey => itemkey,
1161: aname => 'TASK_ASSGN_ID');
1162:
1163: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1163: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1159: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1160: itemkey => itemkey,
1161: aname => 'TASK_ASSGN_ID');
1162:
1163: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1164: itemkey => itemkey,
1165: aname => 'ORG_TSK_ASG_STS_ID');
1166:
1167: open c_task_assgn_detail(l_task_assgn_id);

Line 1180: l_resource_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1176:
1177: resultout := 'COMPLETE:F';
1178: if l_org_assignment_status_id = l_curr_assignment_status_id then
1179:
1180: l_resource_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1181: itemkey => itemkey,
1182: aname => 'RES_ID');
1183:
1184: l_resource_type := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1184: l_resource_type := wf_engine.GetItemAttrText(itemtype => itemtype,

1180: l_resource_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1181: itemkey => itemkey,
1182: aname => 'RES_ID');
1183:
1184: l_resource_type := wf_engine.GetItemAttrText(itemtype => itemtype,
1185: itemkey => itemkey,
1186: aname => 'RES_TYPE');
1187:
1188: p_user_id := getUserId(l_resource_id, l_resource_type);

Line 1223: l_auto_reject := wf_engine.GetItemAttrText(itemtype => itemtype,

1219:
1220: if l_return_status = 'S' then
1221:
1222: -- bug # 5220702
1223: l_auto_reject := wf_engine.GetItemAttrText(itemtype => itemtype,
1224: itemkey => itemkey,
1225: aname => 'IS_AUTO_REJECT');
1226: if l_auto_reject = 'Y' then
1227: -- modify subject and document_id

Line 1246: wf_engine.setItemAttrText(itemtype => itemtype,

1242: l_msg_subject := fnd_message.get;
1243:
1244: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id);
1245:
1246: wf_engine.setItemAttrText(itemtype => itemtype,
1247: itemkey => itemkey,
1248: aname => 'DOCUMENT_ID',
1249: avalue => l_document_id);
1250:

Line 1251: wf_engine.setItemAttrText(itemtype => itemtype,

1247: itemkey => itemkey,
1248: aname => 'DOCUMENT_ID',
1249: avalue => l_document_id);
1250:
1251: wf_engine.setItemAttrText(itemtype => itemtype,
1252: itemkey => itemkey,
1253: aname => 'MSG_SUBJECT',
1254: avalue => l_msg_subject);
1255: