1025: p_applicant_name IN VARCHAR2,
1026: p_applicant_full_name IN VARCHAR2
1027: )
1028: IS
1029: l_event_t wf_event_t;
1030: l_parameter_list_t wf_parameter_list_t;
1031: l_itemKey varchar2(100);
1032: l_incomplt_appl_url varchar2(1000);
1033:
1038:
1039:
1040: BEGIN
1041:
1042: -- initialize the wf_event_t object
1043: --
1044: wf_event_t.Initialize(l_event_t);
1045:
1046: OPEN cur_seq ;
1040: BEGIN
1041:
1042: -- initialize the wf_event_t object
1043: --
1044: wf_event_t.Initialize(l_event_t);
1045:
1046: OPEN cur_seq ;
1047: FETCH cur_seq INTO l_itemKey ;
1048: CLOSE cur_seq ;
1530: p_alt_code_acad IN VARCHAR2,
1531: p_alt_code_adm IN VARCHAR2
1532: )
1533: IS
1534: l_event_t wf_event_t;
1535: l_parameter_list_t wf_parameter_list_t;
1536: l_itemKey varchar2(100);
1537: l_incomplt_appl_url varchar2(1000);
1538:
1543:
1544:
1545: BEGIN
1546:
1547: -- initialize the wf_event_t object
1548: --
1549: wf_event_t.Initialize(l_event_t);
1550:
1551: OPEN cur_seq ;
1545: BEGIN
1546:
1547: -- initialize the wf_event_t object
1548: --
1549: wf_event_t.Initialize(l_event_t);
1550:
1551: OPEN cur_seq ;
1552: FETCH cur_seq INTO l_itemKey ;
1553: CLOSE cur_seq ;
1583: p_alt_code_acad IN VARCHAR2,
1584: p_alt_code_adm IN VARCHAR2
1585: )
1586: IS
1587: l_event_t wf_event_t;
1588: l_parameter_list_t wf_parameter_list_t;
1589: l_itemKey varchar2(100);
1590: l_incomplt_appl_url varchar2(1000);
1591:
1596:
1597:
1598: BEGIN
1599:
1600: -- initialize the wf_event_t object
1601: --
1602: wf_event_t.Initialize(l_event_t);
1603:
1604: OPEN cur_seq ;
1598: BEGIN
1599:
1600: -- initialize the wf_event_t object
1601: --
1602: wf_event_t.Initialize(l_event_t);
1603:
1604: OPEN cur_seq ;
1605: FETCH cur_seq INTO l_itemKey ;
1606: CLOSE cur_seq ;