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';
427: g_ItemType Varchar2(10) := 'ASOQOTWF';
428: g_processName Varchar2(30) := 'PROCESSMAP';
429:
430:
431: l_adhoc_user WF_USERS.NAME%TYPE;
432: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
433: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
434:
435: l_partyId Number;
429:
430:
431: l_adhoc_user WF_USERS.NAME%TYPE;
432: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
433: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
434:
435: l_partyId Number;
436:
437: l_notifEnabled Varchar2(3) := 'Y';
452:
453: l_quoteSourceSatusId Number := null;
454: l_quoteDestStatusId Number := null;
455:
456: l_sales_adhoc_user WF_USERS.NAME%TYPE;
457: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
458: l_nls_language WF_LANGUAGES.NLS_LANGUAGE%TYPE := 'AMERICAN';
459:
460: l_notification_preference VARCHAR(100);
453: l_quoteSourceSatusId Number := null;
454: l_quoteDestStatusId Number := null;
455:
456: l_sales_adhoc_user WF_USERS.NAME%TYPE;
457: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
458: l_nls_language WF_LANGUAGES.NLS_LANGUAGE%TYPE := 'AMERICAN';
459:
460: l_notification_preference VARCHAR(100);
461: l_role_users VARCHAR(800);