APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on DUAL

Line 680: -- FROM DUAL;

676: -- TYPE PartyCurTyp IS REF CURSOR; -- define weak REF CURSOR type
677: -- l_party_cv PartyCurTyp; -- declare cursor variable
678: -- CURSOR c_party_mkt_seg_seq IS -- generate an ID for INSERT
679: -- SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
680: -- FROM DUAL;
681:
682:
683: --R12: mkothari -- added cursor to get territory org
684: CURSOR client_info_csr IS select org_id from jtf_terr_all where terr_id = p_terr_id;

Line 1275: select length(l_store_final_sql) into len from dual;

1271: l_store_csr := DBMS_SQL.open_cursor;
1272: DBMS_SQL.parse(l_store_csr, l_store_insert_sql, DBMS_SQL.native);
1273: DBMS_SQL.BIND_VARIABLE (l_store_csr, ':terr_id', p_terr_id);
1274:
1275: select length(l_store_final_sql) into len from dual;
1276: Ozf_Utility_pvt.write_conc_log('############### Timestamp before for loop: '||to_char(sysdate,'DD-MM-YYYY HH24:MI:SS'));
1277: for n in 1..len
1278: LOOP
1279: --select SUBSTR(SUBSTR(l_store_final_sql,instr(l_store_final_sql,':',1,n),11),10,10 )into lvar from dual;

Line 1279: --select SUBSTR(SUBSTR(l_store_final_sql,instr(l_store_final_sql,':',1,n),11),10,10 )into lvar from dual;

1275: select length(l_store_final_sql) into len from dual;
1276: Ozf_Utility_pvt.write_conc_log('############### Timestamp before for loop: '||to_char(sysdate,'DD-MM-YYYY HH24:MI:SS'));
1277: for n in 1..len
1278: LOOP
1279: --select SUBSTR(SUBSTR(l_store_final_sql,instr(l_store_final_sql,':',1,n),11),10,10 )into lvar from dual;
1280:
1281: -- IF lvar between '1' and '9999' then
1282: Ozf_Utility_pvt.write_conc_log('############### Counter value inside for loop is: '||n);
1283: /*

Line 1290: select instr(translate(lvar,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ','XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'),'X') into isNum FROM dual;

1286: */
1287: exit when instr(l_store_final_sql,':',1,n) = 0;
1288: IF instr(l_store_final_sql,':',1,n)>0 THEN
1289: lvar:=n;
1290: select instr(translate(lvar,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ','XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'),'X') into isNum FROM dual;
1291: IF isNum = 0 then
1292:
1293: write_conc_log('###############Bind Variable Number: '||lvar);
1294:

Line 1690: FROM DUAL;

1686: /* yzhao: fix bug 2789492 - MKTF1R9:1159.0203:FUNC-BUDGET WITH MARKET ELIGIBILITY BUYING GROUP DOES NOT VALI */
1687: AND directional_flag = NVL(p_direction, directional_flag);
1688: CURSOR c_party_mkt_seg_seq IS -- generate an ID
1689: SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
1690: FROM DUAL;
1691: BEGIN
1692: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Start buyinggroup_id=' || p_bg_id);
1693: p_errbuf := null;
1694: p_retcode := 0;