93: --
94: -- If the Item Name is not null then get the value of the item from the WF
95: -- and return it to the message in a document (CLOB) format.
96: --
97: l_message := wf_engine.GetItemAttrText( itemtype => l_item_type,
98: itemkey => l_item_key,
99: aname => l_item);
100: END IF;
101: END IF;
141: --
142: get_transcript_data(
143: p_itemtype => itemtype,
144: p_itemkey => itemkey ,
145: p_person_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_STUDENT_ID'),
146: p_education_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_EDUCATION_ID'),
147: p_transcript_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_TRANSCRIPT_ID'));
148:
149: wf_engine.setitemattrtext(ItemType => itemtype,
142: get_transcript_data(
143: p_itemtype => itemtype,
144: p_itemkey => itemkey ,
145: p_person_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_STUDENT_ID'),
146: p_education_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_EDUCATION_ID'),
147: p_transcript_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_TRANSCRIPT_ID'));
148:
149: wf_engine.setitemattrtext(ItemType => itemtype,
150: ItemKey => itemkey,
143: p_itemtype => itemtype,
144: p_itemkey => itemkey ,
145: p_person_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_STUDENT_ID'),
146: p_education_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_EDUCATION_ID'),
147: p_transcript_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_TRANSCRIPT_ID'));
148:
149: wf_engine.setitemattrtext(ItemType => itemtype,
150: ItemKey => itemkey,
151: aname => 'IA_ADHOCROLE',
145: p_person_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_STUDENT_ID'),
146: p_education_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_EDUCATION_ID'),
147: p_transcript_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_TRANSCRIPT_ID'));
148:
149: wf_engine.setitemattrtext(ItemType => itemtype,
150: ItemKey => itemkey,
151: aname => 'IA_ADHOCROLE',
152: avalue => wf_engine.getitemattrtext(itemtype,itemkey,'IA_REC_ADHOCROLE'));
153:
148:
149: wf_engine.setitemattrtext(ItemType => itemtype,
150: ItemKey => itemkey,
151: aname => 'IA_ADHOCROLE',
152: avalue => wf_engine.getitemattrtext(itemtype,itemkey,'IA_REC_ADHOCROLE'));
153:
154: l_del_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_DEL_UDTL');
155: l_mod_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_MOD_UDTL');
156: l_new_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_NEW_BDTL');
150: ItemKey => itemkey,
151: aname => 'IA_ADHOCROLE',
152: avalue => wf_engine.getitemattrtext(itemtype,itemkey,'IA_REC_ADHOCROLE'));
153:
154: l_del_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_DEL_UDTL');
155: l_mod_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_MOD_UDTL');
156: l_new_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_NEW_BDTL');
157:
158: -- Based on the value of l_del_basis_dtls_body, l_mod_basis_dtls_body and l_new_basis_dtls_body
151: aname => 'IA_ADHOCROLE',
152: avalue => wf_engine.getitemattrtext(itemtype,itemkey,'IA_REC_ADHOCROLE'));
153:
154: l_del_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_DEL_UDTL');
155: l_mod_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_MOD_UDTL');
156: l_new_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_NEW_BDTL');
157:
158: -- Based on the value of l_del_basis_dtls_body, l_mod_basis_dtls_body and l_new_basis_dtls_body
159: -- set the lookup code value.
152: avalue => wf_engine.getitemattrtext(itemtype,itemkey,'IA_REC_ADHOCROLE'));
153:
154: l_del_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_DEL_UDTL');
155: l_mod_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_MOD_UDTL');
156: l_new_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_NEW_BDTL');
157:
158: -- Based on the value of l_del_basis_dtls_body, l_mod_basis_dtls_body and l_new_basis_dtls_body
159: -- set the lookup code value.
160: IF l_del_basis_dtls_body IS NOT NULL THEN
170: --
171: --Based on the value of the Notification Flag set the value of the Message Attributes.
172: --
173: IF NVL(l_notification_flag, 'Z') IN ('D', 'DM', 'DN', 'DMN') THEN
174: wf_engine.setitemattrtext(ItemType => itemtype,
175: ItemKey => itemkey,
176: aname => 'P_DEL_UDTL',
177: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_DEL_UDTL');
178: wf_engine.setitemattrtext(ItemType => itemtype,
174: wf_engine.setitemattrtext(ItemType => itemtype,
175: ItemKey => itemkey,
176: aname => 'P_DEL_UDTL',
177: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_DEL_UDTL');
178: wf_engine.setitemattrtext(ItemType => itemtype,
179: ItemKey => itemkey,
180: aname => 'P_DEL_BDTL',
181: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_DEL_BDTL');
182: END IF;
180: aname => 'P_DEL_BDTL',
181: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_DEL_BDTL');
182: END IF;
183: IF NVL(l_notification_flag, 'Z') IN ('DM', 'MN', 'M', 'DMN') THEN
184: wf_engine.setitemattrtext(ItemType => itemtype,
185: ItemKey => itemkey,
186: aname => 'P_MOD_UDTL',
187: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_MOD_UDTL');
188: wf_engine.setitemattrtext(ItemType => itemtype,
184: wf_engine.setitemattrtext(ItemType => itemtype,
185: ItemKey => itemkey,
186: aname => 'P_MOD_UDTL',
187: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_MOD_UDTL');
188: wf_engine.setitemattrtext(ItemType => itemtype,
189: ItemKey => itemkey,
190: aname => 'P_MOD_BDTL',
191: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_MOD_BDTL');
192: END IF;
190: aname => 'P_MOD_BDTL',
191: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_MOD_BDTL');
192: END IF;
193: IF NVL(l_notification_flag, 'Z') IN ('DMN', 'DN', 'MN', 'N') THEN
194: wf_engine.setitemattrtext(ItemType => itemtype,
195: ItemKey => itemkey,
196: aname => 'P_NEW_BDTL',
197: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_NEW_BDTL');
198:
699:
700: --
701: -- Set the value of the Paramentes in Workflow....
702: --
703: wf_engine.setitemattrtext(ItemType => p_itemtype,
704: ItemKey => p_itemkey,
705: aname => 'P_REC_DEL_UDTL',
706: avalue => l_del_unit_details_body);
707:
704: ItemKey => p_itemkey,
705: aname => 'P_REC_DEL_UDTL',
706: avalue => l_del_unit_details_body);
707:
708: wf_engine.setitemattrtext(ItemType => p_itemtype,
709: ItemKey => p_itemkey,
710: aname => 'P_REC_DEL_BDTL',
711: avalue => l_del_basis_dtls_body);
712:
709: ItemKey => p_itemkey,
710: aname => 'P_REC_DEL_BDTL',
711: avalue => l_del_basis_dtls_body);
712:
713: wf_engine.setitemattrtext(ItemType => p_itemtype,
714: ItemKey => p_itemkey,
715: aname => 'P_REC_MOD_UDTL',
716: avalue => l_mod_unit_details_body);
717: wf_engine.setitemattrtext(ItemType => p_itemtype,
713: wf_engine.setitemattrtext(ItemType => p_itemtype,
714: ItemKey => p_itemkey,
715: aname => 'P_REC_MOD_UDTL',
716: avalue => l_mod_unit_details_body);
717: wf_engine.setitemattrtext(ItemType => p_itemtype,
718: ItemKey => p_itemkey,
719: aname => 'P_REC_MOD_BDTL',
720: avalue => l_mod_basis_dtls_body);
721:
718: ItemKey => p_itemkey,
719: aname => 'P_REC_MOD_BDTL',
720: avalue => l_mod_basis_dtls_body);
721:
722: wf_engine.setitemattrtext(ItemType => p_itemtype,
723: ItemKey => p_itemkey,
724: aname => 'P_REC_NEW_BDTL',
725: avalue => l_new_basis_dtls_body);
726: END get_transcript_data;