765: x_return_status OUT nocopy VARCHAR2,
766: x_msg_count OUT nocopy NUMBER,
767: x_msg_data OUT nocopy VARCHAR2)
768: IS
769: l_itemtype wf_items.item_type%TYPE;
770: l_itemkey wf_items.item_key%TYPE;
771: l_receiver wf_roles.name%TYPE;
772: l_count NUMBER;
773:
766: x_msg_count OUT nocopy NUMBER,
767: x_msg_data OUT nocopy VARCHAR2)
768: IS
769: l_itemtype wf_items.item_type%TYPE;
770: l_itemkey wf_items.item_key%TYPE;
771: l_receiver wf_roles.name%TYPE;
772: l_count NUMBER;
773:
774: BEGIN
808: x_msg_count OUT nocopy NUMBER,
809: x_msg_data OUT nocopy VARCHAR2
810: )
811: IS
812: l_itemtype wf_items.item_type%TYPE;
813: l_itemkey wf_items.item_key%TYPE;
814: l_count NUMBER;
815: l_user_name fnd_user.user_name%TYPE;
816: l_user_id NUMBER;
809: x_msg_data OUT nocopy VARCHAR2
810: )
811: IS
812: l_itemtype wf_items.item_type%TYPE;
813: l_itemkey wf_items.item_key%TYPE;
814: l_count NUMBER;
815: l_user_name fnd_user.user_name%TYPE;
816: l_user_id NUMBER;
817: BEGIN
1370: x_msg_data OUT NOCOPY VARCHAR2
1371: ) IS
1372: l_step VARCHAR2(100);
1373: l_method VARCHAR2(30);
1374: l_itemtype wf_items.item_type%TYPE;
1375: l_itemkey wf_items.item_key%TYPE;
1376: l_receiver fnd_user.user_name%TYPE;
1377:
1378: l_party_usages number := 0 ;
1371: ) IS
1372: l_step VARCHAR2(100);
1373: l_method VARCHAR2(30);
1374: l_itemtype wf_items.item_type%TYPE;
1375: l_itemkey wf_items.item_key%TYPE;
1376: l_receiver fnd_user.user_name%TYPE;
1377:
1378: l_party_usages number := 0 ;
1379: