DBA Data[Home] [Help]

APPS.CSF_ALERTS_PUB dependencies on WF_ENGINE

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

779: end if;
780:
781: itemtype := 'CSFALERT';
782:
783: wf_engine.createprocess(itemtype => itemtype,
784: itemkey => itemkey,
785: process => 'MAIN_PROCESS');
786:
787: wf_engine.setItemAttrNumber(itemtype => itemtype,

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

783: wf_engine.createprocess(itemtype => itemtype,
784: itemkey => itemkey,
785: process => 'MAIN_PROCESS');
786:
787: wf_engine.setItemAttrNumber(itemtype => itemtype,
788: itemkey => itemkey,
789: aname => 'TASK_ASSGN_ID',
790: avalue => l_task_asgn_id);
791:

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

788: itemkey => itemkey,
789: aname => 'TASK_ASSGN_ID',
790: avalue => l_task_asgn_id);
791:
792: wf_engine.setItemAttrNumber(itemtype => itemtype,
793: itemkey => itemkey,
794: aname => 'RES_ID',
795: avalue => l_resource_id);
796:

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

793: itemkey => itemkey,
794: aname => 'RES_ID',
795: avalue => l_resource_id);
796:
797: wf_engine.setItemAttrText(itemtype => itemtype,
798: itemkey => itemkey,
799: aname => 'RES_TYPE',
800: avalue => l_resource_type);
801:

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

798: itemkey => itemkey,
799: aname => 'RES_TYPE',
800: avalue => l_resource_type);
801:
802: wf_engine.setItemAttrText(itemtype => itemtype,
803: itemkey => itemkey,
804: aname => 'EVENT_TYPE',
805: avalue => l_csfw_event_type);
806:

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

803: itemkey => itemkey,
804: aname => 'EVENT_TYPE',
805: avalue => l_csfw_event_type);
806:
807: wf_engine.setItemAttrText(itemtype => itemtype,
808: itemkey => itemkey,
809: aname => 'RESOURCE',
810: avalue => l_resource);
811:

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

808: itemkey => itemkey,
809: aname => 'RESOURCE',
810: avalue => l_resource);
811:
812: wf_engine.setItemAttrText(itemtype => itemtype,
813: itemkey => itemkey,
814: aname => 'DOCUMENT_ID',
815: avalue => l_document_id);
816:

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

813: itemkey => itemkey,
814: aname => 'DOCUMENT_ID',
815: avalue => l_document_id);
816:
817: wf_engine.setItemAttrText(itemtype => itemtype,
818: itemkey => itemkey,
819: aname => 'MSG_SUBJECT',
820: avalue => l_msg_subject);
821:

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

818: itemkey => itemkey,
819: aname => 'MSG_SUBJECT',
820: avalue => l_msg_subject);
821:
822: wf_engine.setItemAttrText(itemtype => itemtype,
823: itemkey => itemkey,
824: aname => 'MSG_SUBJECT2',
825: avalue => l_msg_subject2);
826:

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

835: else
836: l_auto_reject := 'FALSE';
837: end if;
838:
839: wf_engine.setItemAttrText(itemtype => itemtype,
840: itemkey => itemkey,
841: aname => 'AUTO_REJECT_VALUE',
842: avalue => l_auto_reject);
843:

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

847: 513,
848: null,
849: null);
850:
851: wf_engine.setItemAttrNumber(itemtype => itemtype,
852: itemkey => itemkey,
853: aname => 'TIMEOUT1',
854: avalue => l_time_out1);
855:

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

859: 513,
860: null,
861: null);
862:
863: wf_engine.setItemAttrNumber(itemtype => itemtype,
864: itemkey => itemkey,
865: aname => 'TIMEOUT2',
866: avalue => l_time_out2);
867:

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

865: aname => 'TIMEOUT2',
866: avalue => l_time_out2);
867:
868: -- original task assignment status id
869: wf_engine.setItemAttrNumber(itemtype => itemtype,
870: itemkey => itemkey,
871: aname => 'ORG_TSK_ASG_STS_ID',
872: avalue => l_org_assignment_status_id);
873:

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

870: itemkey => itemkey,
871: aname => 'ORG_TSK_ASG_STS_ID',
872: avalue => l_org_assignment_status_id);
873:
874: wf_engine.startprocess(itemtype => itemtype,
875: itemkey => itemkey);
876:
877: return 'SUCCESS';
878:

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

885: resultout out nocopy varchar2) is
886:
887: l_event_type varchar2(20);
888: begin
889: l_event_type := wf_engine.GetItemAttrText(itemtype => itemtype,
890: itemkey => itemkey,
891: aname => 'EVENT_TYPE');
892: resultout := 'COMPLETE:' || l_event_type;
893: end;

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

955: begin
956:
957: resultout := 'COMPLETE:F';
958:
959: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
960: itemkey => itemkey,
961: aname => 'TASK_ASSGN_ID');
962:
963: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

959: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
960: itemkey => itemkey,
961: aname => 'TASK_ASSGN_ID');
962:
963: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
964: itemkey => itemkey,
965: aname => 'ORG_TSK_ASG_STS_ID');
966:
967:

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

1002: l_AUTO_REJECT_VALUE varchar2(25);
1003:
1004: begin
1005: resultout := 'COMPLETE:F';
1006: l_AUTO_REJECT_VALUE := wf_engine.GetItemAttrText(itemtype => itemtype,
1007: itemkey => itemkey,
1008: aname => 'AUTO_REJECT_VALUE');
1009: if l_AUTO_REJECT_VALUE = 'TRUE' then
1010: -- bug # 5845177

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

1007: itemkey => itemkey,
1008: aname => 'AUTO_REJECT_VALUE');
1009: if l_AUTO_REJECT_VALUE = 'TRUE' then
1010: -- bug # 5845177
1011: wf_engine.setItemAttrText(itemtype => itemtype,
1012: itemkey => itemkey,
1013: aname => 'IS_AUTO_REJECT',
1014: avalue => 'Y');
1015: resultout := 'COMPLETE:T';

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

1048: FROM
1049: jtf_task_assignments jta
1050: WHERE jta.task_assignment_id = v_task_assgn_id;
1051: begin
1052: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1053: itemkey => itemkey,
1054: aname => 'TASK_ASSGN_ID');
1055:
1056: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

1052: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1053: itemkey => itemkey,
1054: aname => 'TASK_ASSGN_ID');
1055:
1056: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1057: itemkey => itemkey,
1058: aname => 'ORG_TSK_ASG_STS_ID');
1059:
1060: open c_task_assgn_detail(l_task_assgn_id);

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

1069: resultout := 'COMPLETE';
1070:
1071: if l_org_assignment_status_id = l_curr_assignment_status_id then
1072:
1073: l_resource_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1074: itemkey => itemkey,
1075: aname => 'RES_ID');
1076:
1077: l_resource_type := wf_engine.GetItemAttrText(itemtype => itemtype,

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

1073: l_resource_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1074: itemkey => itemkey,
1075: aname => 'RES_ID');
1076:
1077: l_resource_type := wf_engine.GetItemAttrText(itemtype => itemtype,
1078: itemkey => itemkey,
1079: aname => 'RES_TYPE');
1080:
1081: p_user_id := getUserId(l_resource_id, l_resource_type);

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

1165: select task_id
1166: from jtf_task_assignments
1167: where task_assignment_id = v_task_asgn_id;
1168: begin
1169: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1170: itemkey => itemkey,
1171: aname => 'TASK_ASSGN_ID');
1172:
1173: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

1169: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1170: itemkey => itemkey,
1171: aname => 'TASK_ASSGN_ID');
1172:
1173: l_org_assignment_status_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1174: itemkey => itemkey,
1175: aname => 'ORG_TSK_ASG_STS_ID');
1176:
1177: open c_task_assgn_detail(l_task_assgn_id);

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

1186:
1187: resultout := 'COMPLETE:F';
1188: if l_org_assignment_status_id = l_curr_assignment_status_id then
1189:
1190: l_resource_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1191: itemkey => itemkey,
1192: aname => 'RES_ID');
1193:
1194: l_resource_type := wf_engine.GetItemAttrText(itemtype => itemtype,

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

1190: l_resource_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1191: itemkey => itemkey,
1192: aname => 'RES_ID');
1193:
1194: l_resource_type := wf_engine.GetItemAttrText(itemtype => itemtype,
1195: itemkey => itemkey,
1196: aname => 'RES_TYPE');
1197:
1198: p_user_id := getUserId(l_resource_id, l_resource_type);

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

1229:
1230: if l_return_status = 'S' then
1231:
1232: -- bug # 5220702
1233: l_auto_reject := wf_engine.GetItemAttrText(itemtype => itemtype,
1234: itemkey => itemkey,
1235: aname => 'IS_AUTO_REJECT');
1236: if l_auto_reject = 'Y' then
1237: -- modify subject and document_id

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

1252: l_msg_subject := fnd_message.get;
1253:
1254: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id);
1255:
1256: wf_engine.setItemAttrText(itemtype => itemtype,
1257: itemkey => itemkey,
1258: aname => 'DOCUMENT_ID',
1259: avalue => l_document_id);
1260:

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

1257: itemkey => itemkey,
1258: aname => 'DOCUMENT_ID',
1259: avalue => l_document_id);
1260:
1261: wf_engine.setItemAttrText(itemtype => itemtype,
1262: itemkey => itemkey,
1263: aname => 'MSG_SUBJECT',
1264: avalue => l_msg_subject);
1265: