DBA Data[Home] [Help]

APPS.IGS_AV_VAL_ASULEB dependencies on WF_ENGINE

Line 97: l_message := wf_engine.GetItemAttrText( itemtype => l_item_type,

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;

Line 145: p_person_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_STUDENT_ID'),

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,

Line 146: p_education_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_EDUCATION_ID'),

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,

Line 147: p_transcript_id => wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_TRANSCRIPT_ID'));

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',

Line 149: wf_engine.setitemattrtext(ItemType => itemtype,

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:

Line 152: avalue => wf_engine.getitemattrtext(itemtype,itemkey,'IA_REC_ADHOCROLE'));

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');

Line 154: l_del_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_DEL_UDTL');

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

Line 155: l_mod_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_MOD_UDTL');

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.

Line 156: l_new_basis_dtls_body := wf_engine.getitemattrtext(itemtype,itemkey,'P_REC_NEW_BDTL');

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

Line 174: wf_engine.setitemattrtext(ItemType => itemtype,

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,

Line 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;

Line 184: wf_engine.setitemattrtext(ItemType => itemtype,

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,

Line 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;

Line 194: wf_engine.setitemattrtext(ItemType => itemtype,

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:

Line 703: wf_engine.setitemattrtext(ItemType => p_itemtype,

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:

Line 708: wf_engine.setitemattrtext(ItemType => p_itemtype,

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:

Line 713: wf_engine.setitemattrtext(ItemType => p_itemtype,

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,

Line 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:

Line 722: wf_engine.setitemattrtext(ItemType => p_itemtype,

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;