DBA Data[Home] [Help]

APPS.ONT_FEEDBACK_PKG dependencies on WF_ITEMS

Line 11: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'ONTCUSTF';

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);

Line 12: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;

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);

Line 116: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'ONTDEFCT';

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);

Line 117: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;

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);

Line 238: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE := 'ONTCUSTF';

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);

Line 239: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;

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);