1042: p_requisition_header_id =>p_header_id,
1043: itemtype => l_wf_itemtype,
1044: itemkey => l_wf_itemkey);
1045:
1046: l_is_ame_approval:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1047: itemkey => l_wf_itemkey,
1048: aname => 'IS_AME_APPROVAL');
1049: l_progress := '003';
1050:
1050:
1051: -- Then we can use the updated item attributes to update notification attributes
1052: If ( l_is_ame_approval = 'N') then
1053:
1054: l_description := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1055: itemkey => l_wf_itemkey,
1056: aname => 'REQ_DESCRIPTION');
1057:
1058: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1054: l_description := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1055: itemkey => l_wf_itemkey,
1056: aname => 'REQ_DESCRIPTION');
1057:
1058: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1059: itemkey => l_wf_itemkey,
1060: aname => 'REQ_AMOUNT_CURRENCY_DSP');
1061:
1062: l_justification := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1058: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1059: itemkey => l_wf_itemkey,
1060: aname => 'REQ_AMOUNT_CURRENCY_DSP');
1061:
1062: l_justification := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1063: itemkey => l_wf_itemkey,
1064: aname => 'JUSTIFICATION');
1065:
1066: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1062: l_justification := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1063: itemkey => l_wf_itemkey,
1064: aname => 'JUSTIFICATION');
1065:
1066: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1067: itemkey => l_wf_itemkey,
1068: aname => 'TAX_AMOUNT_CURRENCY_DSP');
1069:
1070: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1066: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1067: itemkey => l_wf_itemkey,
1068: aname => 'TAX_AMOUNT_CURRENCY_DSP');
1069:
1070: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => l_wf_itemtype,
1071: itemkey => l_wf_itemkey,
1072: aname => 'TOTAL_AMOUNT_DSP');
1073:
1074: l_progress := '004';
1111: p_requisition_header_id =>p_header_id,
1112: itemtype => l_child_wf_itemtype,
1113: itemkey => l_child_wf_itemkey);
1114:
1115: l_description :=PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1116: itemkey => l_child_wf_itemkey,
1117: aname => 'REQ_DESCRIPTION');
1118:
1119: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_child_wf_itemtype,
1115: l_description :=PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1116: itemkey => l_child_wf_itemkey,
1117: aname => 'REQ_DESCRIPTION');
1118:
1119: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_child_wf_itemtype,
1120: itemkey => l_child_wf_itemkey,
1121: aname => 'REQ_AMOUNT_CURRENCY_DSP');
1122:
1123: l_justification := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1119: l_req_total := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => l_child_wf_itemtype,
1120: itemkey => l_child_wf_itemkey,
1121: aname => 'REQ_AMOUNT_CURRENCY_DSP');
1122:
1123: l_justification := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1124: itemkey => l_child_wf_itemkey,
1125: aname => 'JUSTIFICATION');
1126:
1127: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1123: l_justification := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1124: itemkey => l_child_wf_itemkey,
1125: aname => 'JUSTIFICATION');
1126:
1127: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1128: itemkey => l_child_wf_itemkey,
1129: aname => 'TAX_AMOUNT_CURRENCY_DSP');
1130:
1131: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText
1127: l_estimated_tax := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_child_wf_itemtype,
1128: itemkey => l_child_wf_itemkey,
1129: aname => 'TAX_AMOUNT_CURRENCY_DSP');
1130:
1131: l_total_amount_dsp:= PO_WF_UTIL_PKG.GetItemAttrText
1132: ( itemtype => l_child_wf_itemtype,
1133: itemkey => l_child_wf_itemkey,
1134: aname => 'TOTAL_AMOUNT_DSP');
1135:
6014: wf_engine.CreateProcess(ItemType => l_itemtype,
6015: ItemKey => l_itemkey,
6016: process => l_workflow_process );
6017:
6018: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => l_itemtype,
6019: itemkey => l_itemkey,
6020: aname => 'DOCUMENT_ID',
6021: avalue => p_document_id);
6022:
6019: itemkey => l_itemkey,
6020: aname => 'DOCUMENT_ID',
6021: avalue => p_document_id);
6022:
6023: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => l_itemtype,
6024: itemkey => l_itemkey,
6025: aname => 'REVISION_NUM',
6026: avalue => p_revision_num);
6027:
6024: itemkey => l_itemkey,
6025: aname => 'REVISION_NUM',
6026: avalue => p_revision_num);
6027:
6028: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
6029: itemkey => l_itemkey,
6030: aname =>'DOCUMENT_DISPLAY_NAME',
6031: avalue => fnd_message.get_string('ICX', 'ICX_CLM_MIPR')||' - ' || l_segment1 || ', ' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REVISION'));
6032:
6033: fnd_message.set_name('ICX', 'ICX_MIPR_DOC_RECEIVED');
6034: fnd_message.set_token('MIPR_DOC', p_mipr_type);
6035: fnd_message.set_token('DOC_NUM', l_segment1);
6036:
6037: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
6038: itemkey => l_itemkey,
6039: aname => 'EMAIL_TEXT_WITH_PDF',
6040: avalue => fnd_message.get);
6041:
6038: itemkey => l_itemkey,
6039: aname => 'EMAIL_TEXT_WITH_PDF',
6040: avalue => fnd_message.get);
6041:
6042: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
6043: itemkey => l_itemkey,
6044: aname => '#FROM_ROLE',
6045: avalue => p_from_user);
6046:
6043: itemkey => l_itemkey,
6044: aname => '#FROM_ROLE',
6045: avalue => p_from_user);
6046:
6047: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
6048: itemkey => l_itemkey,
6049: aname => 'MIPR_EMAIL_PERFORMER',
6050: avalue => l_po_email_performer);
6051:
6048: itemkey => l_itemkey,
6049: aname => 'MIPR_EMAIL_PERFORMER',
6050: avalue => l_po_email_performer);
6051:
6052: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
6053: itemkey => l_itemkey,
6054: aname => 'PDF_ATTACHMENT_MIPR',
6055: avalue => 'PLSQLBLOB:POR_UTIL_PKG.PDF_ATTACH_MIPR/' || l_itemtype || ':' || l_itemkey);
6056: