APPS.ASG_DEFER dependencies on DUAL

Line 51: ||' from dual';

47: end if;
48: l_qry := 'select '''||p_user_name||''' user_name,'''||to_char(p_tranid)
49: ||''' tran_id, '''||p_error_msg||''' ERROR_DESCRIPTION ,'
50: ||''''||p_pubitem||''' pub_item ,'''||p_sequence||''' SEQUENCE '
51: ||' from dual';
52: /*l_qry := 'select DEVICE_USER_NAME user_name,DEFERRED_TRAN_ID tran_id ,'
53: ||'ERROR_DESCRIPTION ,OBJECT_NAME pub_item,SEQUENCE '
54: ||'from asg_deferred_traninfo where CREATION_DATE >= to_date('''
55: ||to_char(p_start_time,'mm-dd-yyyy hh24:mi:ss')

Line 69: select asg_events_s.nextval into l_seq from dual;

65: then
66: asg_helper.log('Raising event oracle.apps.asg.upload.datadeferred',
67: 'asg_defer',g_stmt_level);
68: end if;
69: select asg_events_s.nextval into l_seq from dual;
70: wf_event.raise(p_event_name=>'oracle.apps.asg.upload.datadeferred',
71: p_event_key=>l_seq,p_parameters=>null,
72: p_event_data=>l_clob,p_send_date=>null);
73: if(asg_helper.check_is_log_enabled(g_stmt_level))

Line 140: into l_prof_value from dual;

136: ELSE
137: l_error_msg := p_error_msg;
138: END IF;
139: select nvl(fnd_profile.value_specific('ASG_ENABLE_UPLOAD_EVENTS'),'N')
140: into l_prof_value from dual;
141: l_cp_run := asg_apply.is_conc_program_running;
142:
143: if(l_prof_value = 'Y')
144: then