68: g_ItemType Varchar2(10) := 'ASOQOTWF';
69: g_processName Varchar2(30) := 'PROCESSMAP';
70:
71:
72: l_adhoc_user WF_USERS.NAME%TYPE;
73: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
74: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
75:
76: l_partyId Number;
70:
71:
72: l_adhoc_user WF_USERS.NAME%TYPE;
73: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
74: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
75:
76: l_partyId Number;
77:
78: l_notifEnabled Varchar2(3) := 'Y';
444: g_ItemType Varchar2(10) := 'ASOQOTWF';
445: g_processName Varchar2(30) := 'PROCESSMAP';
446:
447:
448: l_adhoc_user WF_USERS.NAME%TYPE;
449: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
450: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
451:
452: l_partyId Number;
446:
447:
448: l_adhoc_user WF_USERS.NAME%TYPE;
449: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
450: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
451:
452: l_partyId Number;
453:
454: l_notifEnabled Varchar2(3) := 'Y';
469:
470: l_quoteSourceSatusId Number := null;
471: l_quoteDestStatusId Number := null;
472:
473: l_sales_adhoc_user WF_USERS.NAME%TYPE;
474: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
475: l_nls_language WF_LANGUAGES.NLS_LANGUAGE%TYPE := 'AMERICAN';
476:
477: l_notification_preference VARCHAR(100);
470: l_quoteSourceSatusId Number := null;
471: l_quoteDestStatusId Number := null;
472:
473: l_sales_adhoc_user WF_USERS.NAME%TYPE;
474: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
475: l_nls_language WF_LANGUAGES.NLS_LANGUAGE%TYPE := 'AMERICAN';
476:
477: l_notification_preference VARCHAR(100);
478: l_role_users VARCHAR(800);