7: p_comments IN VARCHAR2,
8: p_feedback IN VARCHAR2,
9: p_phone IN VARCHAR2) IS
10:
11: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'ONTCUSTF';
12: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;
13: l_WorkflowProcess VARCHAR2(30) := 'ONT_CUST_FEEDBACK';
14: l_display_name VARCHAR2(240);
15: l_Email_address VARCHAR2(240);
8: p_feedback IN VARCHAR2,
9: p_phone IN VARCHAR2) IS
10:
11: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'ONTCUSTF';
12: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;
13: l_WorkflowProcess VARCHAR2(30) := 'ONT_CUST_FEEDBACK';
14: l_display_name VARCHAR2(240);
15: l_Email_address VARCHAR2(240);
16: l_Notification_preference VARCHAR2(240);
112: p_lot IN VARCHAR2,
113: p_products IN VARCHAR2,
114: p_shipdate IN VARCHAR2) IS
115:
116: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'ONTDEFCT';
117: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;
118: l_WorkflowProcess VARCHAR2(30) := 'DEFECTPROC';
119: l_display_name VARCHAR2(240);
120: l_Email_address VARCHAR2(240);
113: p_products IN VARCHAR2,
114: p_shipdate IN VARCHAR2) IS
115:
116: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'ONTDEFCT';
117: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;
118: l_WorkflowProcess VARCHAR2(30) := 'DEFECTPROC';
119: l_display_name VARCHAR2(240);
120: l_Email_address VARCHAR2(240);
121: l_Notification_preference VARCHAR2(240);
234: p_quantity IN VARCHAR2,
235: p_products IN VARCHAR2,
236: p_phone IN VARCHAR2) IS
237:
238: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'ONTCUSTF';
239: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;
240: l_WorkflowProcess VARCHAR2(30) := 'ONT_CUST_FEEDBACK';
241: l_display_name VARCHAR2(240);
242: l_Email_address VARCHAR2(240);
235: p_products IN VARCHAR2,
236: p_phone IN VARCHAR2) IS
237:
238: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'ONTCUSTF';
239: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;
240: l_WorkflowProcess VARCHAR2(30) := 'ONT_CUST_FEEDBACK';
241: l_display_name VARCHAR2(240);
242: l_Email_address VARCHAR2(240);
243: l_Notification_preference VARCHAR2(240);