1: PACKAGE BODY igs_av_val_asuleb AS
2: /* $Header: IGSAV07B.pls 115.7 2003/12/10 07:40:42 nalkumar ship $ */
3:
4: G_ITEM_TYPE VARCHAR2(300);
5: -- To validate the basis year advanced standing units or levels.
51: RETURN TRUE;
52: EXCEPTION
53: WHEN OTHERS THEN
54: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
55: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.ADVP_VAL_BASIS_YEAR');
56: App_Exception.Raise_Exception;
57: IGS_GE_MSG_STACK.ADD;
58: END;
59: END advp_val_basis_year;
102: /* Write the header doc into CLOB variable */
103: WF_NOTIFICATION.WriteToClob(document, l_message);
104: EXCEPTION
105: WHEN OTHERS THEN
106: wf_core.context('igs_av_val_asuleb','create_transcript',l_item_type,l_item_key);
107: RAISE;
108: END create_transcript;
109:
110: PROCEDURE wf_set_role(
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,
179: ItemKey => itemkey,
180: aname => 'P_DEL_BDTL',
181: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_DEL_BDTL');
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;
183: IF NVL(l_notification_flag, 'Z') IN ('DM', 'MN', 'M', 'DMN') THEN
184: wf_engine.setitemattrtext(ItemType => itemtype,
185: ItemKey => itemkey,
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,
189: ItemKey => itemkey,
190: aname => 'P_MOD_BDTL',
191: avalue => 'PLSQLCLOB:igs_av_val_asuleb.create_transcript/'||itemtype||':'||itemkey||'*P_REC_MOD_BDTL');
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;
193: IF NVL(l_notification_flag, 'Z') IN ('DMN', 'DN', 'MN', 'N') THEN
194: wf_engine.setitemattrtext(ItemType => itemtype,
195: ItemKey => itemkey,
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:
199: END IF;
200:
201: --
266: --
267: l_parameter_list_t.delete;
268: EXCEPTION
269: WHEN OTHERS THEN
270: wf_core.context('IGS_AV_VAL_ASULEB', 'VALIDATE_TRANSCRIPT',
271: l_seq_val,l_raise_event);
272: RAISE;
273: END validate_transcript;
274:
723: ItemKey => p_itemkey,
724: aname => 'P_REC_NEW_BDTL',
725: avalue => l_new_basis_dtls_body);
726: END get_transcript_data;
727: END igs_av_val_asuleb;