DBA Data[Home] [Help]

APPS.IGS_EN_WORKFLOW dependencies on WF_ENGINE

Line 935: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');

931: -- adhoc role
932: --
933: --
934:
935: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
936: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_APPROVER');
937:
938: -- Getting the Full Name of the Student
939:

Line 936: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_APPROVER');

932: --
933: --
934:
935: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
936: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_APPROVER');
937:
938: -- Getting the Full Name of the Student
939:
940: OPEN c_full_name(l_person_id_stu);

Line 946: Wf_Engine.SetItemAttrText( ItemType => itemtype,

942: CLOSE c_full_name;
943:
944: -- Setting this full name of the student
945:
946: Wf_Engine.SetItemAttrText( ItemType => itemtype,
947: ItemKey => itemkey,
948: aname => 'IA_PERSONNAME',
949: avalue => l_c_full_name.full_name
950: );

Line 991: Wf_Engine.SetItemAttrText( ItemType => itemtype,

987:
988:
989:
990: -- now set this role to the workflow
991: Wf_Engine.SetItemAttrText( ItemType => itemtype,
992: ItemKey => itemkey,
993: aname => 'IA_ROLE',
994: avalue => l_role_name
995: );

Line 1088: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');

1084: -- adhoc role
1085: --
1086: --
1087:
1088: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1089: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1090:
1091:
1092: -- Getting the Full Name of the Student

Line 1089: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');

1085: --
1086: --
1087:
1088: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1089: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1090:
1091:
1092: -- Getting the Full Name of the Student
1093:

Line 1100: Wf_Engine.SetItemAttrText( ItemType => itemtype,

1096: CLOSE c_full_name;
1097:
1098: -- Setting this full name of the student
1099:
1100: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1101: ItemKey => itemkey,
1102: aname => 'IA_PERSONNAME',
1103: avalue => l_c_full_name.full_name
1104: );

Line 1141: Wf_Engine.SetItemAttrText( ItemType => itemtype,

1137: role_users => l_user_name_admin);
1138: END IF;
1139:
1140: -- now set this role to the workflow
1141: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1142: ItemKey => itemkey,
1143: aname => 'IA_ROLE',
1144: avalue => l_role_name
1145: );

Line 1238: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');

1234: -- adhoc role
1235: --
1236: --
1237:
1238: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1239: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1240:
1241: -- Getting the Full Name of the Student
1242:

Line 1239: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');

1235: --
1236: --
1237:
1238: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1239: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1240:
1241: -- Getting the Full Name of the Student
1242:
1243: OPEN c_full_name(l_person_id_stu);

Line 1250: Wf_Engine.SetItemAttrText( ItemType => itemtype,

1246:
1247:
1248: -- Setting this full name of the student
1249:
1250: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1251: ItemKey => itemkey,
1252: aname => 'IA_PERSONNAME',
1253: avalue => l_c_full_name.full_name
1254: );

Line 1294: Wf_Engine.SetItemAttrText( ItemType => itemtype,

1290: role_users => l_user_name_admin);
1291: END IF;
1292:
1293: -- now set this role to the workflow
1294: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1295: ItemKey => itemkey,
1296: aname => 'IA_ROLE',
1297: avalue => l_role_name
1298: );

Line 1410: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');

1406: -- adhoc role
1407: --
1408: --
1409:
1410: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1411: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1412: l_discon_rsn_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DISCONTINCD');
1413: l_discon_rsn_type := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DISCONTINTYPE');
1414:

Line 1411: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');

1407: --
1408: --
1409:
1410: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1411: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1412: l_discon_rsn_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DISCONTINCD');
1413: l_discon_rsn_type := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DISCONTINTYPE');
1414:
1415: -- getting the description of discontinuation reason code

Line 1412: l_discon_rsn_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DISCONTINCD');

1408: --
1409:
1410: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1411: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1412: l_discon_rsn_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DISCONTINCD');
1413: l_discon_rsn_type := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DISCONTINTYPE');
1414:
1415: -- getting the description of discontinuation reason code
1416: -- and setting it in internal attribute

Line 1413: l_discon_rsn_type := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DISCONTINTYPE');

1409:
1410: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1411: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1412: l_discon_rsn_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DISCONTINCD');
1413: l_discon_rsn_type := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DISCONTINTYPE');
1414:
1415: -- getting the description of discontinuation reason code
1416: -- and setting it in internal attribute
1417:

Line 1422: Wf_Engine.SetItemAttrText( ItemType => itemtype,

1418: OPEN c_discon_rsn(l_discon_rsn_cd);
1419: FETCH c_discon_rsn INTO l_c_discon_rsn;
1420: CLOSE c_discon_rsn;
1421:
1422: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1423: ItemKey => itemkey,
1424: aname => 'IA_DISCON_RSN_DESC',
1425: avalue => l_c_discon_rsn.description
1426: );

Line 1436: Wf_Engine.SetItemAttrText( ItemType => itemtype,

1432: OPEN c_discon_type(l_discon_rsn_type);
1433: FETCH c_discon_type INTO l_c_discon_type;
1434: CLOSE c_discon_type;
1435:
1436: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1437: ItemKey => itemkey,
1438: aname => 'IA_DISCON_TYPE_DESC',
1439: avalue => l_c_discon_type.meaning
1440: );

Line 1450: Wf_Engine.SetItemAttrText( ItemType => itemtype,

1446: CLOSE c_full_name;
1447:
1448: -- Setting this full name of the student
1449:
1450: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1451: ItemKey => itemkey,
1452: aname => 'IA_PERSONNAME',
1453: avalue => l_c_full_name.full_name
1454: );

Line 1519: Wf_Engine.SetItemAttrText( ItemType => itemtype,

1515: END IF;
1516:
1517: -- now set this role to the workflow
1518:
1519: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1520: ItemKey => itemkey,
1521: aname => 'IA_ROLE',
1522: avalue => l_role_name
1523: );