7: --------------------------get_approval_req--------------------------------
8: --------------------------------------------------------------------------
9:
10: PROCEDURE get_approval_req (
11: itemtype IN WF_ITEMS.ITEM_TYPE%TYPE
12: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE
13: ,actid IN NUMBER
14: ,funcmode IN VARCHAR2
15: ,resultout OUT nocopy VARCHAR2 );
8: --------------------------------------------------------------------------
9:
10: PROCEDURE get_approval_req (
11: itemtype IN WF_ITEMS.ITEM_TYPE%TYPE
12: ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE
13: ,actid IN NUMBER
14: ,funcmode IN VARCHAR2
15: ,resultout OUT nocopy VARCHAR2 );
16:
403: function getActionMode(p_transaction_id in number) return varchar2;
404:
405: function get_transaction_id(p_transaction_step_id in number) return number;
406:
407: PROCEDURE block_for_transaction (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
408: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
409: actid IN NUMBER,
410: funcmode IN VARCHAR2,
411: resultout OUT nocopy VARCHAR2 );
404:
405: function get_transaction_id(p_transaction_step_id in number) return number;
406:
407: PROCEDURE block_for_transaction (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
408: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
409: actid IN NUMBER,
410: funcmode IN VARCHAR2,
411: resultout OUT nocopy VARCHAR2 );
412:
410: funcmode IN VARCHAR2,
411: resultout OUT nocopy VARCHAR2 );
412:
413: /*Added for bug#16449378*/
414: PROCEDURE create_bprv_block (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
415: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
416: actid IN NUMBER,
417: funcmode IN VARCHAR2,
418: resultout OUT nocopy VARCHAR2 );
411: resultout OUT nocopy VARCHAR2 );
412:
413: /*Added for bug#16449378*/
414: PROCEDURE create_bprv_block (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
415: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
416: actid IN NUMBER,
417: funcmode IN VARCHAR2,
418: resultout OUT nocopy VARCHAR2 );
419: