DBA Data[Home] [Help]

APPS.PER_SP_STAGE dependencies on WF_ITEMS

Line 1037: PROCEDURE reject_transaction( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

1033: -- |----------------------< reject_transaction >--------------------------|
1034: -- ---------------------------------------------------------------------------
1035: --
1036:
1037: PROCEDURE reject_transaction( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1038: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
1039: actid IN NUMBER,
1040: funcmode IN VARCHAR2,
1041: resultout OUT nocopy VARCHAR2 ) IS

Line 1038: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

1034: -- ---------------------------------------------------------------------------
1035: --
1036:
1037: PROCEDURE reject_transaction( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1038: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
1039: actid IN NUMBER,
1040: funcmode IN VARCHAR2,
1041: resultout OUT nocopy VARCHAR2 ) IS
1042: l_copy_entity_txn_id NUMBER;

Line 1086: PROCEDURE commit_transaction ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

1082: -- |----------------------< commit_transaction >--------------------------|
1083: -- ---------------------------------------------------------------------------
1084: --
1085:
1086: PROCEDURE commit_transaction ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1087: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
1088: actid IN NUMBER,
1089: funcmode IN VARCHAR2,
1090: resultout OUT nocopy VARCHAR2 )

Line 1087: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

1083: -- ---------------------------------------------------------------------------
1084: --
1085:
1086: PROCEDURE commit_transaction ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1087: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
1088: actid IN NUMBER,
1089: funcmode IN VARCHAR2,
1090: resultout OUT nocopy VARCHAR2 )
1091: is

Line 1225: PROCEDURE get_approval_req ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

1221: -- ---------------------------------------------------------------------------
1222: -- |----------------------< get_approval_req >--------------------------|
1223: -- ---------------------------------------------------------------------------
1224: --
1225: PROCEDURE get_approval_req ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1226: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
1227: actid IN NUMBER,
1228: funcmode IN VARCHAR2,
1229: resultout OUT nocopy VARCHAR2 )

Line 1226: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,

1222: -- |----------------------< get_approval_req >--------------------------|
1223: -- ---------------------------------------------------------------------------
1224: --
1225: PROCEDURE get_approval_req ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
1226: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
1227: actid IN NUMBER,
1228: funcmode IN VARCHAR2,
1229: resultout OUT nocopy VARCHAR2 )
1230: IS

Line 1287: p_item_type in wf_items.item_type%type,

1283: -- ---------------------------------------------------------------------------
1284: --
1285:
1286: PROCEDURE launch_wf(p_process in wf_process_activities.process_name%type,
1287: p_item_type in wf_items.item_type%type,
1288: p_person_id in number,
1289: p_copy_entity_txn_id in number,
1290: p_approval_reqd in varchar2)
1291:

Line 1296: l_item_type wf_items.item_type%type := upper(p_item_type);

1292: is
1293:
1294: l_proc varchar2(72) := 'launch_wf';
1295: l_process wf_activities.name%type := upper(p_process);
1296: l_item_type wf_items.item_type%type := upper(p_item_type);
1297: l_item_key wf_items.item_key%type;
1298: l_return_status varchar2(1000);
1299: l_process_display_name varchar2(240);
1300: l_role_name wf_roles.name%type;

Line 1297: l_item_key wf_items.item_key%type;

1293:
1294: l_proc varchar2(72) := 'launch_wf';
1295: l_process wf_activities.name%type := upper(p_process);
1296: l_item_type wf_items.item_type%type := upper(p_item_type);
1297: l_item_key wf_items.item_key%type;
1298: l_return_status varchar2(1000);
1299: l_process_display_name varchar2(240);
1300: l_role_name wf_roles.name%type;
1301: l_role_displayname wf_roles.display_name%type;