99: IF (g_po_wf_debug = 'Y') THEN
100: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
101: '10:Start get_wf_params ');
102: END IF;
103: x_po_header_id := PO_wf_Util_Pkg.GetItemAttrNumber(
104: itemtype => itemtype,
105: itemkey => itemkey,
106: aname => 'DOCUMENT_ID');
107:
104: itemtype => itemtype,
105: itemkey => itemkey,
106: aname => 'DOCUMENT_ID');
107:
108: x_po_doc_type := PO_wf_Util_Pkg.GetItemAttrText(
109: itemtype => itemtype,
110: itemkey => itemkey,
111: aname => 'DOCUMENT_TYPE');
112:
109: itemtype => itemtype,
110: itemkey => itemkey,
111: aname => 'DOCUMENT_TYPE');
112:
113: x_po_doc_subtype := PO_wf_Util_Pkg.GetItemAttrText(
114: itemtype => itemtype,
115: itemkey => itemkey,
116: aname => 'DOCUMENT_SUBTYPE');
117:
323: '10: Start function contract_terms_Changed ');
324: END IF;
325:
326:
327: l_conterms_yn := PO_wf_Util_Pkg.GetItemAttrText(
328: itemtype => itemtype,
329: itemkey => itemkey,
330: aname => 'CONTERMS_EXIST_FLAG');
331:
1282: result := WF_ENGINE.eng_null;
1283: return;
1284: END IF;
1285: result := 'NO_CHANGE';
1286: l_conterms_yn := PO_wf_Util_Pkg.GetItemAttrText(
1287: itemtype => itemtype,
1288: itemkey => itemkey,
1289: aname => 'CONTERMS_EXIST_FLAG');
1290: IF (l_conterms_yn = 'Y') then
1432: result := WF_ENGINE.eng_null;
1433: return;
1434: END IF;
1435: result := 'N';
1436: l_conterms_yn := PO_wf_Util_Pkg.GetItemAttrText(
1437: itemtype => itemtype,
1438: itemkey => itemkey,
1439: aname => 'CONTERMS_EXIST_FLAG');
1440: IF (l_conterms_yn = 'Y') then
1583: result := WF_ENGINE.eng_null;
1584: return;
1585: END IF;
1586: result := 'NONE';
1587: l_conterms_yn := PO_wf_Util_Pkg.GetItemAttrText(
1588: itemtype => itemtype,
1589: itemkey => itemkey,
1590: aname => 'CONTERMS_EXIST_FLAG');
1591: IF (l_conterms_yn = 'Y') then
1735: result := WF_ENGINE.eng_null;
1736: return;
1737: END IF;
1738: result := 'NON_STANDARD';
1739: l_conterms_yn := PO_wf_Util_Pkg.GetItemAttrText(
1740: itemtype => itemtype,
1741: itemkey => itemkey,
1742: aname => 'CONTERMS_EXIST_FLAG');
1743: IF (l_conterms_yn = 'Y') then
1890: result := WF_ENGINE.eng_null;
1891: return;
1892: END IF;
1893: result := 'ALL';
1894: l_conterms_yn := PO_wf_Util_Pkg.GetItemAttrText(
1895: itemtype => itemtype,
1896: itemkey => itemkey,
1897: aname => 'CONTERMS_EXIST_FLAG');
1898: IF (l_conterms_yn = 'Y') then
2046: result := WF_ENGINE.eng_null;
2047: return;
2048: END IF;
2049: result := 'ALL';
2050: l_conterms_yn := PO_wf_Util_Pkg.GetItemAttrText(
2051: itemtype => itemtype,
2052: itemkey => itemkey,
2053: aname => 'CONTERMS_EXIST_FLAG');
2054: IF (l_conterms_yn = 'Y') then