APPS.GR_WF_UTIL_PVT dependencies on GR_ITEM_GENERAL

Line 995: l_item_code GR_ITEM_GENERAL.ITEM_CODE%TYPE;

991: l_item_name_txt VARCHAR2(240);
992: l_current_prop_txt VARCHAR2(240);
993: l_proposed_prop_txt VARCHAR2(240);
994: l_item_code_seq NUMBER;
995: l_item_code GR_ITEM_GENERAL.ITEM_CODE%TYPE;
996:
997: CURSOR get_property_value (V_orgn_id NUMBER, V_item_code VARCHAR2, V_element_name VARCHAR2) IS
998: SELECT d.property_name, DECODE(b.property_type_indicator, 'A', a.alpha_value, 'D', a.date_value, 'N', a.number_value, 'F', a.alpha_value ) property_value,
999: d.property_value Proposed_value

Line 1158: select item_code into l_item_code from gr_item_General_v where rownum=1;

1154: itemkey => l_itemkey,
1155: aname => 'PROPERTY_DETAILS',
1156: avalue => l_property_details);
1157:
1158: select item_code into l_item_code from gr_item_General_v where rownum=1;
1159:
1160: -- get values to be stored into the workflow item
1161: l_performer_name := get_default_role('oracle.apps.gr.reg.documentmanager',l_item_code);
1162: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,