DBA Data[Home] [Help]

APPS.IGS_EN_WLST_GEN_PROC dependencies on WF_ENGINE

Line 786: IF wf_engine.getitemattrnumber(itemtype,itemkey,'IA_STD_COUNT') IS NULL THEN

782: BEGIN
783:
784: IF funcmode='RUN' THEN
785:
786: IF wf_engine.getitemattrnumber(itemtype,itemkey,'IA_STD_COUNT') IS NULL THEN
787:
788: l_event_message := wf_engine.getitemattrevent(itemtype,itemkey,'IA_EVE_MSG');
789: l_par_st_count := wf_event.getvalueforparameter('TOTAL_STDNT_COUNT',l_event_message.parameter_list);
790:

Line 788: l_event_message := wf_engine.getitemattrevent(itemtype,itemkey,'IA_EVE_MSG');

784: IF funcmode='RUN' THEN
785:
786: IF wf_engine.getitemattrnumber(itemtype,itemkey,'IA_STD_COUNT') IS NULL THEN
787:
788: l_event_message := wf_engine.getitemattrevent(itemtype,itemkey,'IA_EVE_MSG');
789: l_par_st_count := wf_event.getvalueforparameter('TOTAL_STDNT_COUNT',l_event_message.parameter_list);
790:
791: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_STD_COUNT',l_par_st_count);
792: l_chk_val := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_STD_COUNT');

Line 791: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_STD_COUNT',l_par_st_count);

787:
788: l_event_message := wf_engine.getitemattrevent(itemtype,itemkey,'IA_EVE_MSG');
789: l_par_st_count := wf_event.getvalueforparameter('TOTAL_STDNT_COUNT',l_event_message.parameter_list);
790:
791: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_STD_COUNT',l_par_st_count);
792: l_chk_val := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_STD_COUNT');
793:
794: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',0);
795: END IF;

Line 792: l_chk_val := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_STD_COUNT');

788: l_event_message := wf_engine.getitemattrevent(itemtype,itemkey,'IA_EVE_MSG');
789: l_par_st_count := wf_event.getvalueforparameter('TOTAL_STDNT_COUNT',l_event_message.parameter_list);
790:
791: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_STD_COUNT',l_par_st_count);
792: l_chk_val := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_STD_COUNT');
793:
794: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',0);
795: END IF;
796:

Line 794: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',0);

790:
791: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_STD_COUNT',l_par_st_count);
792: l_chk_val := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_STD_COUNT');
793:
794: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',0);
795: END IF;
796:
797: l_curr_student := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_CURR_STD');
798: l_total_std := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_STD_COUNT');

Line 797: l_curr_student := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_CURR_STD');

793:
794: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',0);
795: END IF;
796:
797: l_curr_student := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_CURR_STD');
798: l_total_std := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_STD_COUNT');
799:
800: IF (l_total_std - l_curr_student) > 0 THEN
801: resultout := 'COMPLETE:Y';

Line 798: l_total_std := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_STD_COUNT');

794: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',0);
795: END IF;
796:
797: l_curr_student := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_CURR_STD');
798: l_total_std := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_STD_COUNT');
799:
800: IF (l_total_std - l_curr_student) > 0 THEN
801: resultout := 'COMPLETE:Y';
802: ELSE

Line 846: l_event_name := wf_engine.getitemattrtext(itemtype,itemkey,'IA_EVENT');

842: BEGIN
843:
844: IF funcmode='RUN' THEN
845:
846: l_event_name := wf_engine.getitemattrtext(itemtype,itemkey,'IA_EVENT');
847: l_event_key := wf_engine.getitemattrtext(itemtype,itemkey,'IA_EVE_KEY');
848: l_event_message := wf_engine.getitemattrevent(itemtype,itemkey,'IA_EVE_MSG');
849: l_curr_student := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_CURR_STD');
850: l_curr_student := l_curr_student + 1;

Line 847: l_event_key := wf_engine.getitemattrtext(itemtype,itemkey,'IA_EVE_KEY');

843:
844: IF funcmode='RUN' THEN
845:
846: l_event_name := wf_engine.getitemattrtext(itemtype,itemkey,'IA_EVENT');
847: l_event_key := wf_engine.getitemattrtext(itemtype,itemkey,'IA_EVE_KEY');
848: l_event_message := wf_engine.getitemattrevent(itemtype,itemkey,'IA_EVE_MSG');
849: l_curr_student := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_CURR_STD');
850: l_curr_student := l_curr_student + 1;
851:

Line 848: l_event_message := wf_engine.getitemattrevent(itemtype,itemkey,'IA_EVE_MSG');

844: IF funcmode='RUN' THEN
845:
846: l_event_name := wf_engine.getitemattrtext(itemtype,itemkey,'IA_EVENT');
847: l_event_key := wf_engine.getitemattrtext(itemtype,itemkey,'IA_EVE_KEY');
848: l_event_message := wf_engine.getitemattrevent(itemtype,itemkey,'IA_EVE_MSG');
849: l_curr_student := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_CURR_STD');
850: l_curr_student := l_curr_student + 1;
851:
852: l_param_name := 'PARAM_'||l_Curr_student;

Line 849: l_curr_student := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_CURR_STD');

845:
846: l_event_name := wf_engine.getitemattrtext(itemtype,itemkey,'IA_EVENT');
847: l_event_key := wf_engine.getitemattrtext(itemtype,itemkey,'IA_EVE_KEY');
848: l_event_message := wf_engine.getitemattrevent(itemtype,itemkey,'IA_EVE_MSG');
849: l_curr_student := wf_engine.getitemattrnumber(itemtype,itemkey,'IA_CURR_STD');
850: l_curr_student := l_curr_student + 1;
851:
852: l_param_name := 'PARAM_'||l_Curr_student;
853: l_param_value := wf_event.getvalueforparameter(l_param_name,l_event_message.parameter_list);

Line 860: wf_engine.setitemattrtext(itemtype,itemkey,'IA_UNAME',l_std_name);

856: IF l_send_wf = 'Y' THEN
857: l_std_name := LTRIM(RTRIM(SUBSTR(l_param_Value,1,100)));
858: l_std_pos := TO_NUMBER(SUBSTR(l_param_value,102));
859:
860: wf_engine.setitemattrtext(itemtype,itemkey,'IA_UNAME',l_std_name);
861: wf_engine.setitemattrtext(itemtype,itemkey,'IA_WLPOS',l_std_pos);
862: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',l_curr_student);
863: resultout := 'COMPLETE:Y';
864: ELSE

Line 861: wf_engine.setitemattrtext(itemtype,itemkey,'IA_WLPOS',l_std_pos);

857: l_std_name := LTRIM(RTRIM(SUBSTR(l_param_Value,1,100)));
858: l_std_pos := TO_NUMBER(SUBSTR(l_param_value,102));
859:
860: wf_engine.setitemattrtext(itemtype,itemkey,'IA_UNAME',l_std_name);
861: wf_engine.setitemattrtext(itemtype,itemkey,'IA_WLPOS',l_std_pos);
862: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',l_curr_student);
863: resultout := 'COMPLETE:Y';
864: ELSE
865: wf_engine.setitemattrtext(itemtype,itemkey,'IA_UNAME',l_std_name);

Line 862: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',l_curr_student);

858: l_std_pos := TO_NUMBER(SUBSTR(l_param_value,102));
859:
860: wf_engine.setitemattrtext(itemtype,itemkey,'IA_UNAME',l_std_name);
861: wf_engine.setitemattrtext(itemtype,itemkey,'IA_WLPOS',l_std_pos);
862: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',l_curr_student);
863: resultout := 'COMPLETE:Y';
864: ELSE
865: wf_engine.setitemattrtext(itemtype,itemkey,'IA_UNAME',l_std_name);
866: wf_engine.setitemattrtext(itemtype,itemkey,'IA_WLPOS',l_std_pos);

Line 865: wf_engine.setitemattrtext(itemtype,itemkey,'IA_UNAME',l_std_name);

861: wf_engine.setitemattrtext(itemtype,itemkey,'IA_WLPOS',l_std_pos);
862: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',l_curr_student);
863: resultout := 'COMPLETE:Y';
864: ELSE
865: wf_engine.setitemattrtext(itemtype,itemkey,'IA_UNAME',l_std_name);
866: wf_engine.setitemattrtext(itemtype,itemkey,'IA_WLPOS',l_std_pos);
867: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',l_curr_student);
868: resultout := 'COMPLETE:N';
869: END IF;

Line 866: wf_engine.setitemattrtext(itemtype,itemkey,'IA_WLPOS',l_std_pos);

862: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',l_curr_student);
863: resultout := 'COMPLETE:Y';
864: ELSE
865: wf_engine.setitemattrtext(itemtype,itemkey,'IA_UNAME',l_std_name);
866: wf_engine.setitemattrtext(itemtype,itemkey,'IA_WLPOS',l_std_pos);
867: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',l_curr_student);
868: resultout := 'COMPLETE:N';
869: END IF;
870: END IF;

Line 867: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',l_curr_student);

863: resultout := 'COMPLETE:Y';
864: ELSE
865: wf_engine.setitemattrtext(itemtype,itemkey,'IA_UNAME',l_std_name);
866: wf_engine.setitemattrtext(itemtype,itemkey,'IA_WLPOS',l_std_pos);
867: wf_engine.setitemattrnumber(itemtype,itemkey,'IA_CURR_STD',l_curr_student);
868: resultout := 'COMPLETE:N';
869: END IF;
870: END IF;
871:

Line 1660: l_party_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_ID');

1656: -- fetch student for whom the record has been procesed and add the user name to the
1657: -- adhoc role
1658: --
1659: --
1660: l_party_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_ID');
1661: l_cal_type := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_LOAD_CAL_TYPE');
1662: l_seq_num := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_LOAD_CA_SEQ_NUM');
1663:
1664:

Line 1661: l_cal_type := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_LOAD_CAL_TYPE');

1657: -- adhoc role
1658: --
1659: --
1660: l_party_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_ID');
1661: l_cal_type := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_LOAD_CAL_TYPE');
1662: l_seq_num := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_LOAD_CA_SEQ_NUM');
1663:
1664:
1665: -- Getting the Person Number

Line 1662: l_seq_num := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_LOAD_CA_SEQ_NUM');

1658: --
1659: --
1660: l_party_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_PERSON_ID');
1661: l_cal_type := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_LOAD_CAL_TYPE');
1662: l_seq_num := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_LOAD_CA_SEQ_NUM');
1663:
1664:
1665: -- Getting the Person Number
1666: OPEN c_person_num(l_party_id);

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

1668: CLOSE c_person_num;
1669:
1670:
1671: -- Setting the Load calendar description
1672: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1673: ItemKey => itemkey,
1674: aname => 'P_PERSON_NUM',
1675: avalue => l_party_number
1676: );

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

1683: CLOSE c_cal_desc;
1684:
1685:
1686: -- Setting the Load calendar description
1687: Wf_Engine.SetItemAttrText( ItemType => itemtype,
1688: ItemKey => itemkey,
1689: aname => 'P_LOAD_CAL_DESC',
1690: avalue => l_description
1691: );