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

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

713: --
714: --
715:
716:
717: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
718: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
719:
720:
721: -- Getting the Full Name of the Student

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

714: --
715:
716:
717: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
718: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
719:
720:
721: -- Getting the Full Name of the Student
722:

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

725: CLOSE c_full_name;
726:
727: -- Setting this full name of the student
728:
729: Wf_Engine.SetItemAttrText( ItemType => itemtype,
730: ItemKey => itemkey,
731: aname => 'IA_PERSONNAME',
732: avalue => l_c_full_name.full_name
733: );

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

770: END IF;
771:
772: -- now set this role to the workflow
773:
774: Wf_Engine.SetItemAttrText( ItemType => itemtype,
775: ItemKey => itemkey,
776: aname => 'IA_ROLE',
777: avalue => l_role_name
778: );

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

877: -- adhoc role
878: --
879: --
880:
881: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
882: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
883: l_delete := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DELETED');
884: l_approved := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_APPROVED');
885:

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

878: --
879: --
880:
881: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
882: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
883: l_delete := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DELETED');
884: l_approved := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_APPROVED');
885:
886:

Line 883: l_delete := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DELETED');

879: --
880:
881: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
882: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
883: l_delete := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DELETED');
884: l_approved := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_APPROVED');
885:
886:
887:

Line 884: l_approved := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_APPROVED');

880:
881: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
882: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
883: l_delete := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DELETED');
884: l_approved := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_APPROVED');
885:
886:
887:
888: -- Setting the value of the attribute IA_APPROVED_MSG based on the P_APPROVED value.

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

895:
896: -- Setting this the attribute IA_APPROVED_MSG
897:
898:
899: Wf_Engine.SetItemAttrText( ItemType => itemtype,
900: ItemKey => itemkey,
901: aname => 'IA_APPROVED_MSG',
902: avalue => l_c_mesg_text.message_text
903: );

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

912: CLOSE c_full_name;
913:
914: -- Setting this full name of the student
915:
916: Wf_Engine.SetItemAttrText( ItemType => itemtype,
917: ItemKey => itemkey,
918: aname => 'IA_PERSONNAME',
919: avalue => l_c_full_name.full_name
920: );

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

953: role_users => l_user_name_admin);
954: END IF;
955:
956: -- now set this role to the workflow
957: Wf_Engine.SetItemAttrText( ItemType => itemtype,
958: ItemKey => itemkey,
959: aname => 'IA_ROLE',
960: avalue => l_role_name
961: );

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

1074: -- adhoc role
1075: --
1076: --
1077:
1078: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1079: l_person_id_suvisor := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_SUPERVISORID');
1080: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1081: l_staff_ind := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_STAFF_IND');
1082:

Line 1079: l_person_id_suvisor := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_SUPERVISORID');

1075: --
1076: --
1077:
1078: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1079: l_person_id_suvisor := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_SUPERVISORID');
1080: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1081: l_staff_ind := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_STAFF_IND');
1082:
1083:

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

1076: --
1077:
1078: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1079: l_person_id_suvisor := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_SUPERVISORID');
1080: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1081: l_staff_ind := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_STAFF_IND');
1082:
1083:
1084:

Line 1081: l_staff_ind := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_STAFF_IND');

1077:
1078: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1079: l_person_id_suvisor := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_SUPERVISORID');
1080: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1081: l_staff_ind := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_STAFF_IND');
1082:
1083:
1084:
1085: -- Setting the value of the attribute IA_APPROVED_MSG based on the P_APPROVED value.

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

1091: CLOSE c_mesg_text ;
1092:
1093: -- Setting this the attribute IA_APPROVED_MSG
1094:
1095: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1096: ItemKey => itemkey,
1097: aname => 'IA_STAFF_IND',
1098: avalue => l_c_mesg_text.message_text
1099: );

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

1109:
1110:
1111: -- Setting this full name of the student
1112:
1113: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1114: ItemKey => itemkey,
1115: aname => 'IA_PERSONNAME',
1116: avalue => l_c_full_name.full_name
1117: );

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

1122: OPEN c_full_name(l_person_id_suvisor);
1123: FETCH c_full_name INTO l_c_full_name_sup;
1124: CLOSE c_full_name;
1125:
1126: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1127: ItemKey => itemkey,
1128: aname => 'P_SUPERVISORNAME',
1129: avalue => l_c_full_name_sup.full_name
1130: );

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

1195:
1196: END IF;
1197:
1198: -- now set this role to the workflow
1199: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1200: ItemKey => itemkey,
1201: aname => 'IA_ROLE',
1202: avalue => l_role_name
1203: );

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

1207: IF (l_user_name_stu IS NULL AND l_user_name_sup IS NULL ) THEN
1208:
1209: -- Setting this full name of the student
1210:
1211: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1212: ItemKey => itemkey,
1213: aname => 'IA_PERSON1',
1214: avalue => l_c_full_name.full_name
1215: );

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

1217:
1218:
1219: -- Setting this full name of the Supervisor
1220:
1221: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1222: ItemKey => itemkey,
1223: aname => 'IA_PERSON2',
1224: avalue => l_c_full_name_sup.full_name
1225: );

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

1226:
1227: -- Add the admin to the role
1228: IF ( l_user_name_adm IS NOT NULL ) THEN
1229:
1230: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1231: ItemKey => itemkey,
1232: aname => 'IA_ADMIN_USER',
1233: avalue => l_user_name_adm
1234: );

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

1240: ELSIF (l_user_name_stu IS NOT NULL AND l_user_name_sup IS NULL ) THEN
1241:
1242: -- Setting this full name of the Supervisor
1243:
1244: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1245: ItemKey => itemkey,
1246: aname => 'IA_PERSON1',
1247: avalue => l_c_full_name_sup.full_name
1248: );

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

1249:
1250: -- Add the admin to the role
1251: IF ( l_user_name_adm IS NOT NULL ) THEN
1252:
1253: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1254: ItemKey => itemkey,
1255: aname => 'IA_ADMIN_USER',
1256: avalue => l_user_name_adm
1257: );

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

1265: ELSIF (l_user_name_stu IS NULL AND l_user_name_sup IS NOT NULL ) THEN
1266:
1267: -- Setting this full name of the student
1268:
1269: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1270: ItemKey => itemkey,
1271: aname => 'IA_PERSON1',
1272: avalue => l_c_full_name.full_name
1273: );

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

1274:
1275: -- Add the admin to the role
1276: IF ( l_user_name_adm IS NOT NULL ) THEN
1277:
1278: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1279: ItemKey => itemkey,
1280: aname => 'IA_ADMIN_USER',
1281: avalue => l_user_name_adm
1282: );

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

1410: -- adhoc role
1411: --
1412: --
1413:
1414: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1415: l_person_id_suvisor := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_SUPRVSR');
1416: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1417:
1418: -- Getting the Full Name of the Student

Line 1415: l_person_id_suvisor := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_SUPRVSR');

1411: --
1412: --
1413:
1414: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1415: l_person_id_suvisor := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_SUPRVSR');
1416: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1417:
1418: -- Getting the Full Name of the Student
1419:

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

1412: --
1413:
1414: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
1415: l_person_id_suvisor := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_SUPRVSR');
1416: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
1417:
1418: -- Getting the Full Name of the Student
1419:
1420: OPEN c_full_name(l_person_id_stu);

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

1422: CLOSE c_full_name;
1423:
1424: -- Setting this full name of the student
1425:
1426: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1427: ItemKey => itemkey,
1428: aname => 'IA_PERSONNAME',
1429: avalue => l_c_full_name.full_name
1430: );

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

1509:
1510:
1511: -- Setting the Adhoc Role Attribute
1512:
1513: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1514: ItemKey => itemkey,
1515: aname => 'IA_ROLE',
1516: avalue => l_role_name);
1517:

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

1522: OPEN c_full_name(l_person_id_stu);
1523: FETCH c_full_name INTO l_c_full_name;
1524: CLOSE c_full_name;
1525:
1526: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1527: ItemKey => itemkey,
1528: aname => 'IA_PERSON1',
1529: avalue => l_c_full_name.full_name
1530: );

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

1532:
1533:
1534: -- Setting this full name of the Supervisor
1535:
1536: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1537: ItemKey => itemkey,
1538: aname => 'IA_PERSON2',
1539: avalue => l_sup_name
1540: );

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

1541:
1542: -- setting admin to IA for performer of admin notification
1543: IF ( l_user_name_adm IS NOT NULL ) THEN
1544:
1545: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1546: ItemKey => itemkey,
1547: aname => 'IA_ADMIN_USER',
1548: avalue => l_user_name_adm
1549: );

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

1556: ELSIF (l_user_name_stu IS NOT NULL AND l_supervisor_flag = 'FALSE' ) THEN
1557:
1558: -- Setting this full name of the Supervisor
1559:
1560: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1561: ItemKey => itemkey,
1562: aname => 'IA_PERSON1',
1563: avalue => l_sup_name
1564: );

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

1565:
1566: -- setting admin to IA for performer of admin notification
1567: IF ( l_user_name_adm IS NOT NULL ) THEN
1568:
1569: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1570: ItemKey => itemkey,
1571: aname => 'IA_ADMIN_USER',
1572: avalue => l_user_name_adm
1573: );

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

1584: OPEN c_full_name(l_person_id_stu);
1585: FETCH c_full_name INTO l_c_full_name;
1586: CLOSE c_full_name;
1587:
1588: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1589: ItemKey => itemkey,
1590: aname => 'IA_PERSON1',
1591: avalue => l_c_full_name.full_name
1592: );

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

1593:
1594: -- setting admin to IA for performer of admin notification
1595: IF ( l_user_name_adm IS NOT NULL ) THEN
1596:
1597: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1598: ItemKey => itemkey,
1599: aname => 'IA_ADMIN_USER',
1600: avalue => l_user_name_adm
1601: );

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

2565: -- adhoc role
2566: --
2567:
2568:
2569: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
2570: l_person_id_suvisor := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_SUPERVISOR');
2571: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
2572:
2573:

Line 2570: l_person_id_suvisor := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_SUPERVISOR');

2566: --
2567:
2568:
2569: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
2570: l_person_id_suvisor := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_SUPERVISOR');
2571: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
2572:
2573:
2574: -- Checking for User Name for the corresponding person ID of a student

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

2567:
2568:
2569: l_person_id_stu := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
2570: l_person_id_suvisor := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_SUPERVISOR');
2571: l_person_id_app := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_ADMIN');
2572:
2573:
2574: -- Checking for User Name for the corresponding person ID of a student
2575:

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

2668: END LOOP;
2669:
2670: -- Setting the Adhoc Role Attribute
2671:
2672: Wf_Engine.SetItemAttrText( ItemType => itemtype,
2673: ItemKey => itemkey,
2674: aname => 'P_ROLE',
2675: avalue => l_role_name);
2676:

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

2673: ItemKey => itemkey,
2674: aname => 'P_ROLE',
2675: avalue => l_role_name);
2676:
2677: Wf_Engine.SetItemAttrText( ItemType => itemtype,
2678: ItemKey => itemkey,
2679: aname => 'P_FROM_ROLE',
2680: avalue => l_user_name_adm);
2681:

Line 2723: l_person_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');

2719: funcmode => funcmode ,
2720: resultout => resultout
2721: );
2722:
2723: l_person_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
2724: l_lookup := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PROGRAMSTAT');
2725:
2726: OPEN c_person_info(l_person_id);
2727: FETCH c_person_info INTO l_c_person_info;

Line 2724: l_lookup := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PROGRAMSTAT');

2720: resultout => resultout
2721: );
2722:
2723: l_person_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
2724: l_lookup := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PROGRAMSTAT');
2725:
2726: OPEN c_person_info(l_person_id);
2727: FETCH c_person_info INTO l_c_person_info;
2728: CLOSE c_person_info;

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

2726: OPEN c_person_info(l_person_id);
2727: FETCH c_person_info INTO l_c_person_info;
2728: CLOSE c_person_info;
2729:
2730: Wf_Engine.SetItemAttrText( ItemType => itemtype,
2731: ItemKey => itemkey,
2732: aname => 'IA_PERSON_NUMBER',
2733: avalue => l_c_person_info.person_number);
2734:

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

2736: OPEN c_status(l_lookup);
2737: FETCH c_status INTO l_c_status;
2738: CLOSE c_status;
2739:
2740: Wf_Engine.SetItemAttrText( ItemType => itemtype,
2741: ItemKey => itemkey,
2742: aname => 'IA_PROG_STATUS',
2743: avalue => l_c_status.meaning);
2744:

Line 2780: l_person_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');

2776: funcmode => funcmode ,
2777: resultout => resultout
2778: );
2779:
2780: l_person_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSONID');
2781:
2782: OPEN c_person_info(l_person_id);
2783: FETCH c_person_info INTO l_c_person_info;
2784: CLOSE c_person_info;

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

2782: OPEN c_person_info(l_person_id);
2783: FETCH c_person_info INTO l_c_person_info;
2784: CLOSE c_person_info;
2785:
2786: Wf_Engine.SetItemAttrText( ItemType => itemtype,
2787: ItemKey => itemkey,
2788: aname => 'IA_PERSON_NUMBER',
2789: avalue => l_c_person_info.person_number);
2790: