APPS.AML_MONITOR_WF dependencies on DUAL

Line 475: /* FROM dual; */

471:
472: -- ******************************************************************
473: */
474: /* SELECT TO_CHAR(AS_WORKFLOW_KEYS_S.nextval) INTO itemkey */
475: /* FROM dual; */
476:
477: if l_monitor_found = 'Y' then
478: l_existing_itemkey := null;
479: open c_chk_item_key(g_item_type, P_Sales_Lead_Id||'%' );

Line 485: select p_sales_lead_id||'_'||'1' into itemkey from dual;

481: close c_chk_item_key;
482:
483:
484: if l_existing_itemkey is null then
485: select p_sales_lead_id||'_'||'1' into itemkey from dual;
486: else
487: select p_sales_lead_id || '_' || (substr(l_existing_itemkey,(instr(l_existing_itemkey,'_')+1) ) + 1 ) into itemkey
488: from dual ;
489: end if;

Line 488: from dual ;

484: if l_existing_itemkey is null then
485: select p_sales_lead_id||'_'||'1' into itemkey from dual;
486: else
487: select p_sales_lead_id || '_' || (substr(l_existing_itemkey,(instr(l_existing_itemkey,'_')+1) ) + 1 ) into itemkey
488: from dual ;
489: end if;
490:
491: IF (AS_DEBUG_LOW_ON) THEN
492: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'itemkey:' || itemkey);

Line 543: into l_monitor_launch_date from dual;

539: avalue => p_sales_lead_id);
540:
541:
542: select to_date(to_char(sysdate,'MM/DD/YYYY HH:MI:SS AM'),'MM/DD/YYYY HH:MI:SS AM')
543: into l_monitor_launch_date from dual;
544:
545: wf_engine.SetItemAttrDate(itemtype => itemtype,
546: itemkey => itemkey,
547: aname => 'MONITOR_LAUNCH_DATE',

Line 814: into l_monitor_launch_date from dual;

810: itemkey => itemkey,
811: aname => 'MONITOR_CONDITION_ID');
812:
813: select to_date(to_char(sysdate,'MM/DD/YYYY HH:MI:SS AM'),'MM/DD/YYYY HH:MI:SS AM')
814: into l_monitor_launch_date from dual;
815:
816: wf_engine.SetItemAttrDate(itemtype => itemtype,
817: itemkey => itemkey,
818: aname => 'MONITOR_LAUNCH_DATE',

Line 1572: SELECT aml_MONITOR_LOG_S.nextval into l_monitor_log_id FROM sys.dual;

1568: X_Msg_Data => l_msg_data
1569: ) ;
1570: /*
1571:
1572: SELECT aml_MONITOR_LOG_S.nextval into l_monitor_log_id FROM sys.dual;
1573:
1574:
1575: INSERT INTO aml_MONITOR_LOG(
1576: MONITOR_LOG_ID

Line 2963: into l_monitor_launch_date from dual;

2959: avalue => l_sales_lead_id);
2960:
2961:
2962: select to_date(to_char(sysdate,'MM/DD/YYYY HH:MI:SS AM'),'MM/DD/YYYY HH:MI:SS AM')
2963: into l_monitor_launch_date from dual;
2964:
2965: wf_engine.SetItemAttrDate(itemtype => itemtype,
2966: itemkey => itemkey,
2967: aname => 'MONITOR_LAUNCH_DATE',

Line 3398: select instr(l_notify_role_list, l_manager_username) into l_number from dual;

3394:
3395: if l_manager_username = l_lead_owner_username then
3396: null;
3397: elsif l_manager_username is not null then
3398: select instr(l_notify_role_list, l_manager_username) into l_number from dual;
3399: if l_number = 0 then
3400: l_notify_role_list := l_notify_role_list||','||l_manager_username;
3401: else
3402: null;

Line 3431: select instr(l_notify_role_list, l_mgr_name) into l_number from dual;

3427: status => 'ACTIVE',
3428: expiration_date => null);
3429:
3430:
3431: select instr(l_notify_role_list, l_mgr_name) into l_number from dual;
3432: if l_number = 0 then
3433: l_notify_role_list := l_notify_role_list||','||l_mgr_name;
3434: else
3435: null;