DBA Data[Home] [Help]

APPS.POS_SUPPLIER_USER_REG_PKG dependencies on WF_ITEMS

Line 943: l_itemtype wf_items.item_type%TYPE;

939: p_user_name IN VARCHAR2,
940: p_password IN VARCHAR2
941: )
942: IS
943: l_itemtype wf_items.item_type%TYPE;
944: l_itemkey wf_items.item_key%TYPE;
945: l_process wf_process_activities.process_name%TYPE;
946: is_osn VARCHAR2(1);
947: BEGIN

Line 944: l_itemkey wf_items.item_key%TYPE;

940: p_password IN VARCHAR2
941: )
942: IS
943: l_itemtype wf_items.item_type%TYPE;
944: l_itemkey wf_items.item_key%TYPE;
945: l_process wf_process_activities.process_name%TYPE;
946: is_osn VARCHAR2(1);
947: BEGIN
948: IF p_is_invited = 'Y' THEN

Line 1021: l_itemtype wf_items.item_type%TYPE;

1017: p_vendor_name IN VARCHAR2,
1018: p_approver_role IN VARCHAR2
1019: )
1020: IS
1021: l_itemtype wf_items.item_type%TYPE;
1022: l_itemkey wf_items.item_key%TYPE;
1023: l_local_user_name wf_local_users.name%TYPE;
1024: l_process wf_process_activities.process_name%TYPE;
1025: is_osn VARCHAR2(1);

Line 1022: l_itemkey wf_items.item_key%TYPE;

1018: p_approver_role IN VARCHAR2
1019: )
1020: IS
1021: l_itemtype wf_items.item_type%TYPE;
1022: l_itemkey wf_items.item_key%TYPE;
1023: l_local_user_name wf_local_users.name%TYPE;
1024: l_process wf_process_activities.process_name%TYPE;
1025: is_osn VARCHAR2(1);
1026: lv_approver_role WF_USER_ROLES.ROLE_NAME%TYPE;

Line 1104: l_itemtype wf_items.item_type%TYPE;

1100: p_note IN VARCHAR2,
1101: p_invitation_key IN VARCHAR2
1102: )
1103: IS
1104: l_itemtype wf_items.item_type%TYPE;
1105: l_itemkey wf_items.item_key%TYPE;
1106: l_local_user_name wf_local_users.name%TYPE;
1107: l_process wf_process_activities.process_name%TYPE;
1108: BEGIN

Line 1105: l_itemkey wf_items.item_key%TYPE;

1101: p_invitation_key IN VARCHAR2
1102: )
1103: IS
1104: l_itemtype wf_items.item_type%TYPE;
1105: l_itemkey wf_items.item_key%TYPE;
1106: l_local_user_name wf_local_users.name%TYPE;
1107: l_process wf_process_activities.process_name%TYPE;
1108: BEGIN
1109:

Line 1163: l_itemtype wf_items.item_type%TYPE;

1159: p_email IN VARCHAR2,
1160: p_language_code IN VARCHAR2
1161: )
1162: IS
1163: l_itemtype wf_items.item_type%TYPE;
1164: l_itemkey wf_items.item_key%TYPE;
1165: l_local_user_name wf_local_users.name%TYPE;
1166: l_process wf_process_activities.process_name%TYPE;
1167: BEGIN

Line 1164: l_itemkey wf_items.item_key%TYPE;

1160: p_language_code IN VARCHAR2
1161: )
1162: IS
1163: l_itemtype wf_items.item_type%TYPE;
1164: l_itemkey wf_items.item_key%TYPE;
1165: l_local_user_name wf_local_users.name%TYPE;
1166: l_process wf_process_activities.process_name%TYPE;
1167: BEGIN
1168: