APPS.POS_ASN_NOTIF dependencies on DUAL

Line 26: SELECT po_wf_itemkey_s.nextval INTO l_seq_val FROM dual;

22: l_supplier_displayname VARCHAR2(360);
23:
24: BEGIN
25:
26: SELECT po_wf_itemkey_s.nextval INTO l_seq_val FROM dual;
27: l_item_key := 'POSASNNB_' || p_shipment_num || '_' || to_char(l_seq_val);
28:
29: if (p_notif_type = 'CANCEL') then
30: wf_engine.createProcess( ItemType => l_item_type,

Line 107: SELECT po_wf_itemkey_s.nextval INTO l_seq_val FROM dual;

103: l_buyer_user_displayname VARCHAR2(360);
104:
105: BEGIN
106:
107: SELECT po_wf_itemkey_s.nextval INTO l_seq_val FROM dual;
108: l_item_key := 'WCAPPRV_' || p_wc_num || '_' || to_char(l_seq_val);
109:
110:
111: wf_engine.createProcess

Line 310: FROM dual;

306: -- verify if timezone conversion preference is enabled for the buyer user
307:
308: SELECT Nvl(FND_PROFILE.value_specific('ENABLE_TIMEZONE_CONVERSIONS', l_user_id), 'N')
309: INTO l_timezone_conversion
310: FROM dual;
311:
312: IF l_timezone_conversion = 'Y' THEN
313:
314: -- get the server timezone and client time zone values for date time stamp conversion

Line 1010: FROM dual;

1006: -- verify if timezone conversion preference is enabled for the buyer user
1007:
1008: SELECT Nvl(FND_PROFILE.value_specific('ENABLE_TIMEZONE_CONVERSIONS', l_user_id), 'N')
1009: INTO l_timezone_conversion
1010: FROM dual;
1011:
1012: IF l_timezone_conversion = 'Y' THEN
1013:
1014: -- get the server timezone and client time zone values for date time stamp conversion