APPS.IEX_DUNNING_PVT dependencies on DUAL

Line 4390: select fnd_profile.value(nvl('IEX_ALLOW_DUN_FULL_PROMISE','N')) into l_allow_send from dual; -- Added for bug#8408162

4386: close c_fully_promised_billto;
4387: end if;
4388:
4389: --End bug 7197038 gnramasa 8th july 08
4390: select fnd_profile.value(nvl('IEX_ALLOW_DUN_FULL_PROMISE','N')) into l_allow_send from dual; -- Added for bug#8408162
4391:
4392: if l_turnoff_coll_on_bankru = 'Y' then
4393: open c_no_of_bankruptcy (p_delinquencies_tbl(1).party_cust_id);
4394: fetch c_no_of_bankruptcy into l_no_of_bankruptcy;

Line 7201: select fnd_profile.value(nvl('IEX_ALLOW_DUN_FULL_PROMISE','N')) into l_allow_send from dual;

7197: and pd.status='COLLECTABLE'
7198: and pd.state='PROMISE'
7199: group by pd.delinquency_id
7200: having sum(nvl(pd.promise_amount,0))>=ps.amount_due_remaining);
7201: select fnd_profile.value(nvl('IEX_ALLOW_DUN_FULL_PROMISE','N')) into l_allow_send from dual;
7202:
7203: if l_turnoff_coll_on_bankru = 'Y' then
7204: open c_no_of_bankruptcy (l_party_cust_id);
7205: fetch c_no_of_bankruptcy into l_no_of_bankruptcy;

Line 13364: vstr3 := ' ,' || '''D''' || ')) FROM DUAL ';

13360: ----vstr1 := 'SELECT SYSDATE + ';
13361: vstr1 := 'SELECT to_date('' ';
13362: ----vstr2 := ' , TO_NUMBER(TO_CHAR(SYSDATE + ' ;
13363: vstr2 := ' , TO_NUMBER(TO_CHAR(to_date('' ' ;
13364: vstr3 := ' ,' || '''D''' || ')) FROM DUAL ';
13365:
13366: ----vstr4 := 'SELECT SYSDATE + ' ;
13367: vstr4 := 'SELECT to_date('' ' ;
13368: vstr5 := ' FROM DUAL ';

Line 13368: vstr5 := ' FROM DUAL ';

13364: vstr3 := ' ,' || '''D''' || ')) FROM DUAL ';
13365:
13366: ----vstr4 := 'SELECT SYSDATE + ' ;
13367: vstr4 := 'SELECT to_date('' ' ;
13368: vstr5 := ' FROM DUAL ';
13369:
13370: -- Initialize message list IF p_init_msg_list is set to TRUE.
13371: IF FND_API.to_Boolean( p_init_msg_list )
13372: THEN

Line 13391: ', TO_NUMBER(TO_CHAR(SYSDATE + ' || l_callback_days || ',' || '''D''' || ')) FROM DUAL ';

13387: v_create_string := vstr1 || l_correspondence_date || ''',''DD-MON-RR'') + ' || l_callback_days || vstr2
13388: || l_correspondence_date || ''',''DD-MON-RR'') + ' || l_callback_days || vstr3;
13389: /*
13390: v_create_string := 'SELECT SYSDATE + ' || l_callback_days ||
13391: ', TO_NUMBER(TO_CHAR(SYSDATE + ' || l_callback_days || ',' || '''D''' || ')) FROM DUAL ';
13392: */
13393: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - string='||v_create_string);
13394:
13395: DBMS_SQL.parse(v_cursor, v_create_string, 1);

Line 13426: --v_create_string := 'SELECT SYSDATE + ' || l_callback_days || ' FROM DUAL ';

13422: v_cursor := DBMS_SQL.OPEN_CURSOR;
13423: -- clchang updated for sql bind var 05/07/2003
13424: ----v_create_string := vstr4 || l_callback_days || vstr5;
13425: v_create_string := vstr4 || l_correspondence_date || ''',''DD-MON-RR'') + ' || l_callback_days || vstr5;
13426: --v_create_string := 'SELECT SYSDATE + ' || l_callback_days || ' FROM DUAL ';
13427:
13428: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - createstring='||v_create_string);
13429:
13430: DBMS_SQL.parse(v_cursor, v_create_string, 1);

Line 18011: from dual;

18007: l_req_id := p_request_id;
18008:
18009: select to_char(sysdate, 'YYYY-MM-DD')
18010: into l_report_date
18011: from dual;
18012:
18013: select name
18014: into l_dunning_plan
18015: from iex_dunning_plans_vl