APPS.ASG_DEFER dependencies on DUAL

Line 54: ||' from dual';

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

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

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

Line 144: into l_prof_value from dual;

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