DBA Data[Home] [Help]

APPS.IGS_RE_WORKFLOW dependencies on WF_EVENT_T

Line 158: l_event_t wf_event_t;

154: -- Who When What
155: --
156: -------------------------------------------------------------------------------------------------
157:
158: l_event_t wf_event_t;
159: l_parameter_list_t wf_parameter_list_t;
160: l_itemKey varchar2(100);
161: ln_seq_val NUMBER;
162:

Line 209: -- initialize the wf_event_t object

205: FETCH cur_user_id INTO l_cur_user_id ;
206: CLOSE cur_user_id ;
207:
208: --
209: -- initialize the wf_event_t object
210: --
211:
212: wf_event_t.Initialize(l_event_t);
213:

Line 212: wf_event_t.Initialize(l_event_t);

208: --
209: -- initialize the wf_event_t object
210: --
211:
212: wf_event_t.Initialize(l_event_t);
213:
214:
215: --
216: -- Adding the parameters to the parameter list

Line 265: l_event_t wf_event_t;

261: -- Who When What
262: --
263: -------------------------------------------------------------------------------------------------
264:
265: l_event_t wf_event_t;
266: l_parameter_list_t wf_parameter_list_t;
267: l_itemKey varchar2(100);
268: ln_seq_val NUMBER;
269:

Line 331: -- initialize the wf_event_t object

327: FETCH cur_course_cd INTO l_cur_course_cd;
328: CLOSE cur_course_cd;
329:
330: --
331: -- initialize the wf_event_t object
332: --
333:
334: wf_event_t.Initialize(l_event_t);
335:

Line 334: wf_event_t.Initialize(l_event_t);

330: --
331: -- initialize the wf_event_t object
332: --
333:
334: wf_event_t.Initialize(l_event_t);
335:
336:
337:
338: --

Line 394: l_event_t wf_event_t;

390: -- Who When What
391: --
392: -------------------------------------------------------------------------------------------------
393:
394: l_event_t wf_event_t;
395: l_parameter_list_t wf_parameter_list_t;
396: l_itemKey varchar2(100);
397: ln_seq_val NUMBER;
398:

Line 479: -- initialize the wf_event_t object

475: OPEN cur_res_start_dt ;
476: FETCH cur_res_start_dt INTO l_cur_res_start_dt;
477: CLOSE cur_res_start_dt;
478: --
479: -- initialize the wf_event_t object
480: --
481:
482: wf_event_t.Initialize(l_event_t);
483:

Line 482: wf_event_t.Initialize(l_event_t);

478: --
479: -- initialize the wf_event_t object
480: --
481:
482: wf_event_t.Initialize(l_event_t);
483:
484:
485: l_staff_ind := IGS_EN_GEN_003.GET_STAFF_IND(p_supervisorid);
486:

Line 544: l_event_t wf_event_t;

540: -- Who When What
541: --
542: -------------------------------------------------------------------------------------------------
543:
544: l_event_t wf_event_t;
545: l_parameter_list_t wf_parameter_list_t;
546: l_itemKey varchar2(100);
547: ln_seq_val NUMBER;
548:

Line 596: -- initialize the wf_event_t object

592: FETCH cur_user_id INTO l_cur_user_id ;
593: CLOSE cur_user_id ;
594:
595: --
596: -- initialize the wf_event_t object
597: --
598:
599: wf_event_t.Initialize(l_event_t);
600:

Line 599: wf_event_t.Initialize(l_event_t);

595: --
596: -- initialize the wf_event_t object
597: --
598:
599: wf_event_t.Initialize(l_event_t);
600:
601:
602: --
603: -- Adding the parameters to the parameter list

Line 1658: l_event_t wf_event_t;

1654: -- Change History:
1655: -- Who When What
1656: --
1657: -------------------------------------------------------------------------------------------------
1658: l_event_t wf_event_t;
1659: l_parameter_list_t wf_parameter_list_t;
1660: l_itemKey varchar2(100);
1661: ln_seq_val NUMBER;
1662: l_programcd igs_re_candidature.sca_course_cd%TYPE;

Line 1737: -- initialize the wf_event_t object

1733: FETCH cur_user_id INTO l_cur_user_id ;
1734: CLOSE cur_user_id ;
1735:
1736: --
1737: -- initialize the wf_event_t object
1738: --
1739:
1740: wf_event_t.Initialize(l_event_t);
1741:

Line 1740: wf_event_t.Initialize(l_event_t);

1736: --
1737: -- initialize the wf_event_t object
1738: --
1739:
1740: wf_event_t.Initialize(l_event_t);
1741:
1742:
1743:
1744:

Line 1835: l_event_t wf_event_t;

1831: -- Who When What
1832: --
1833: -------------------------------------------------------------------------------------------------
1834:
1835: l_event_t wf_event_t;
1836: l_parameter_list_t wf_parameter_list_t;
1837: l_itemKey varchar2(100);
1838: ln_seq_val NUMBER;
1839: l_programcd igs_re_candidature.sca_course_cd%TYPE;

Line 1902: -- initialize the wf_event_t object

1898: FETCH cur_user_id INTO l_cur_user_id ;
1899: CLOSE cur_user_id ;
1900:
1901: --
1902: -- initialize the wf_event_t object
1903: --
1904:
1905: wf_event_t.Initialize(l_event_t);
1906:

Line 1905: wf_event_t.Initialize(l_event_t);

1901: --
1902: -- initialize the wf_event_t object
1903: --
1904:
1905: wf_event_t.Initialize(l_event_t);
1906:
1907:
1908: OPEN c_research(p_personid,p_ca_sequence_number);
1909: FETCH c_research INTO l_programcd,l_res_topic;

Line 1994: l_event_t wf_event_t;

1990: -- Who When What
1991: --
1992: -------------------------------------------------------------------------------------------------
1993:
1994: l_event_t wf_event_t;
1995: l_parameter_list_t wf_parameter_list_t;
1996: l_itemKey varchar2(100);
1997: ln_seq_val NUMBER;
1998: l_programcd igs_re_candidature.sca_course_cd%TYPE;

Line 2053: -- initialize the wf_event_t object

2049: FETCH cur_user_id INTO l_cur_user_id ;
2050: CLOSE cur_user_id ;
2051:
2052: --
2053: -- initialize the wf_event_t object
2054: --
2055:
2056: wf_event_t.Initialize(l_event_t);
2057:

Line 2056: wf_event_t.Initialize(l_event_t);

2052: --
2053: -- initialize the wf_event_t object
2054: --
2055:
2056: wf_event_t.Initialize(l_event_t);
2057:
2058:
2059: OPEN c_research(p_personid,p_ca_sequence_number);
2060: FETCH c_research INTO l_programcd,l_res_topic;

Line 2140: l_event_t wf_event_t;

2136: -- Who When What
2137: --
2138: -------------------------------------------------------------------------------------------------
2139:
2140: l_event_t wf_event_t;
2141: l_parameter_list_t wf_parameter_list_t;
2142: l_itemKey varchar2(100);
2143: ln_seq_val NUMBER;
2144: l_programcd igs_re_candidature.sca_course_cd%TYPE;

Line 2208: -- initialize the wf_event_t object

2204: FETCH cur_user_id INTO l_cur_user_id ;
2205: CLOSE cur_user_id ;
2206:
2207: --
2208: -- initialize the wf_event_t object
2209: --
2210:
2211: wf_event_t.Initialize(l_event_t);
2212:

Line 2211: wf_event_t.Initialize(l_event_t);

2207: --
2208: -- initialize the wf_event_t object
2209: --
2210:
2211: wf_event_t.Initialize(l_event_t);
2212:
2213:
2214:
2215: OPEN cur_res_top(p_personid,p_programcd);

Line 2331: l_event_t wf_event_t;

2327: l_supervisor VARCHAR2(32000);
2328: l_cur_prof_value cur_prof_value%ROWTYPE;
2329: l_cur_user_id cur_user_id%ROWTYPE;
2330: ln_seq_val NUMBER;
2331: l_event_t wf_event_t;
2332: l_parameter_list_t wf_parameter_list_t;
2333: l_itemKey varchar2(100);
2334: l_flag NUMBER := 0;
2335:

Line 2374: -- initialize the wf_event_t object

2370: FOR l_cur_achived_milestone IN cur_achived_milestone(l_cur_prog_atmpt.person_id,l_cur_prog_atmpt.sequence_number) LOOP
2371:
2372:
2373: --
2374: -- initialize the wf_event_t object
2375: --
2376:
2377:
2378: wf_event_t.Initialize(l_event_t);

Line 2378: wf_event_t.Initialize(l_event_t);

2374: -- initialize the wf_event_t object
2375: --
2376:
2377:
2378: wf_event_t.Initialize(l_event_t);
2379:
2380: -- Get the sequence value
2381:
2382: OPEN c_seq_num;