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: l_enterprise_name VARCHAR2(10000);

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: l_enterprise_name VARCHAR2(10000);
948: BEGIN

Line 1039: l_itemtype wf_items.item_type%TYPE;

1035: p_vendor_name IN VARCHAR2,
1036: p_approver_role IN VARCHAR2
1037: )
1038: IS
1039: l_itemtype wf_items.item_type%TYPE;
1040: l_itemkey wf_items.item_key%TYPE;
1041: l_local_user_name wf_local_users.name%TYPE;
1042: l_process wf_process_activities.process_name%TYPE;
1043: is_osn VARCHAR2(1);

Line 1040: l_itemkey wf_items.item_key%TYPE;

1036: p_approver_role IN VARCHAR2
1037: )
1038: IS
1039: l_itemtype wf_items.item_type%TYPE;
1040: l_itemkey wf_items.item_key%TYPE;
1041: l_local_user_name wf_local_users.name%TYPE;
1042: l_process wf_process_activities.process_name%TYPE;
1043: is_osn VARCHAR2(1);
1044: lv_approver_role WF_USER_ROLES.ROLE_NAME%TYPE;

Line 1122: l_itemtype wf_items.item_type%TYPE;

1118: p_note IN VARCHAR2,
1119: p_invitation_key IN VARCHAR2
1120: )
1121: IS
1122: l_itemtype wf_items.item_type%TYPE;
1123: l_itemkey wf_items.item_key%TYPE;
1124: l_local_user_name wf_local_users.name%TYPE;
1125: l_process wf_process_activities.process_name%TYPE;
1126: BEGIN

Line 1123: l_itemkey wf_items.item_key%TYPE;

1119: p_invitation_key IN VARCHAR2
1120: )
1121: IS
1122: l_itemtype wf_items.item_type%TYPE;
1123: l_itemkey wf_items.item_key%TYPE;
1124: l_local_user_name wf_local_users.name%TYPE;
1125: l_process wf_process_activities.process_name%TYPE;
1126: BEGIN
1127:

Line 1181: l_itemtype wf_items.item_type%TYPE;

1177: p_email IN VARCHAR2,
1178: p_language_code IN VARCHAR2
1179: )
1180: IS
1181: l_itemtype wf_items.item_type%TYPE;
1182: l_itemkey wf_items.item_key%TYPE;
1183: l_local_user_name wf_local_users.name%TYPE;
1184: l_process wf_process_activities.process_name%TYPE;
1185: BEGIN

Line 1182: l_itemkey wf_items.item_key%TYPE;

1178: p_language_code IN VARCHAR2
1179: )
1180: IS
1181: l_itemtype wf_items.item_type%TYPE;
1182: l_itemkey wf_items.item_key%TYPE;
1183: l_local_user_name wf_local_users.name%TYPE;
1184: l_process wf_process_activities.process_name%TYPE;
1185: BEGIN
1186:

Line 1779: l_item_type wf_items.item_type%TYPE;

1775: l_email VARCHAR2(1000) := '';
1776: l_username VARCHAR2(500) := '';
1777: l_password VARCHAR2(100) := '';
1778: l_disp_type VARCHAR2(20) := 'text/plain';
1779: l_item_type wf_items.item_type%TYPE;
1780: l_item_key wf_items.item_key%TYPE;
1781: BEGIN
1782:
1783: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1780: l_item_key wf_items.item_key%TYPE;

1776: l_username VARCHAR2(500) := '';
1777: l_password VARCHAR2(100) := '';
1778: l_disp_type VARCHAR2(20) := 'text/plain';
1779: l_item_type wf_items.item_type%TYPE;
1780: l_item_key wf_items.item_key%TYPE;
1781: BEGIN
1782:
1783: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1784: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'p_document_id ' || p_document_id);