54:
55: BEGIN
56:
57:
58: l_event_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_EVENT_NAME');
59: l_show_cause_expiry_dt := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_SHOW_CAUSE_EXPIRY_DT');
60: l_appeal_expiry_dt := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_APPEAL_EXPIRY_DT');
61: l_person_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_PERSON_ID');
62: l_course_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_COURSE_CD');
55: BEGIN
56:
57:
58: l_event_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_EVENT_NAME');
59: l_show_cause_expiry_dt := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_SHOW_CAUSE_EXPIRY_DT');
60: l_appeal_expiry_dt := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_APPEAL_EXPIRY_DT');
61: l_person_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_PERSON_ID');
62: l_course_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_COURSE_CD');
63:
56:
57:
58: l_event_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_EVENT_NAME');
59: l_show_cause_expiry_dt := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_SHOW_CAUSE_EXPIRY_DT');
60: l_appeal_expiry_dt := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_APPEAL_EXPIRY_DT');
61: l_person_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_PERSON_ID');
62: l_course_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_COURSE_CD');
63:
64:
57:
58: l_event_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_EVENT_NAME');
59: l_show_cause_expiry_dt := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_SHOW_CAUSE_EXPIRY_DT');
60: l_appeal_expiry_dt := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_APPEAL_EXPIRY_DT');
61: l_person_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_PERSON_ID');
62: l_course_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_COURSE_CD');
63:
64:
65: OPEN c_user_name(l_person_id);
58: l_event_name := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_EVENT_NAME');
59: l_show_cause_expiry_dt := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_SHOW_CAUSE_EXPIRY_DT');
60: l_appeal_expiry_dt := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_APPEAL_EXPIRY_DT');
61: l_person_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_PERSON_ID');
62: l_course_cd := Wf_Engine.GetItemAttrText(itemtype,itemkey,'IA_COURSE_CD');
63:
64:
65: OPEN c_user_name(l_person_id);
66: FETCH c_user_name INTO l_user_name;
99:
100:
101: -- Setting the values for the User Name
102:
103: Wf_Engine.SetItemAttrText( ItemType => itemtype,
104: ItemKey => itemkey,
105: aname => 'IA_USER_NAME',
106: avalue => l_user_name
107: );
107: );
108:
109: -- Setting the values for the Person Name
110:
111: Wf_Engine.SetItemAttrText( ItemType => itemtype,
112: ItemKey => itemkey,
113: aname => 'IA_PERSON_NAME',
114: avalue => l_party_name
115: );
116:
117:
118: -- Setting the values for the Person Pre Name Adjunct
119:
120: Wf_Engine.SetItemAttrText( ItemType => itemtype,
121: ItemKey => itemkey,
122: aname => 'IA_PERSON_PREFIX',
123: avalue => l_person_pre_name_adjunct
124: );
124: );
125:
126: -- Setting the values for the Person Pre Name Adjunct
127:
128: Wf_Engine.SetItemAttrText( ItemType => itemtype,
129: ItemKey => itemkey,
130: aname => 'IA_PROGRAM_TITLE',
131: avalue => l_title
132: );