APPS.PSA_FUNDS_CHECKER_PKG dependencies on DBMS_SQL

Line 2292: cur_ussgl := dbms_sql.open_cursor;

2288: psa_utils.debug_other_string(g_state_level,l_full_path, ' sql_ussgl1 -> ' || SUBSTR(sql_ussgl,1,3500));
2289: psa_utils.debug_other_string(g_state_level,l_full_path, ' sql_ussgl1 -> ' || SUBSTR(sql_ussgl,3500,7000));
2290: -- ========================= FND LOG =============================
2291:
2292: cur_ussgl := dbms_sql.open_cursor;
2293: dbms_sql.parse(cur_ussgl, sql_ussgl, dbms_sql.v7);
2294:
2295: for i in 1..g_num_segs loop
2296: dbms_sql.define_column(cur_ussgl, i, 'segment' || i, 30);

Line 2293: dbms_sql.parse(cur_ussgl, sql_ussgl, dbms_sql.v7);

2289: psa_utils.debug_other_string(g_state_level,l_full_path, ' sql_ussgl1 -> ' || SUBSTR(sql_ussgl,3500,7000));
2290: -- ========================= FND LOG =============================
2291:
2292: cur_ussgl := dbms_sql.open_cursor;
2293: dbms_sql.parse(cur_ussgl, sql_ussgl, dbms_sql.v7);
2294:
2295: for i in 1..g_num_segs loop
2296: dbms_sql.define_column(cur_ussgl, i, 'segment' || i, 30);
2297: end loop;

Line 2296: dbms_sql.define_column(cur_ussgl, i, 'segment' || i, 30);

2292: cur_ussgl := dbms_sql.open_cursor;
2293: dbms_sql.parse(cur_ussgl, sql_ussgl, dbms_sql.v7);
2294:
2295: for i in 1..g_num_segs loop
2296: dbms_sql.define_column(cur_ussgl, i, 'segment' || i, 30);
2297: end loop;
2298:
2299: dbms_sql.define_column(cur_ussgl, g_num_segs + 1, l_ccid);
2300:

Line 2299: dbms_sql.define_column(cur_ussgl, g_num_segs + 1, l_ccid);

2295: for i in 1..g_num_segs loop
2296: dbms_sql.define_column(cur_ussgl, i, 'segment' || i, 30);
2297: end loop;
2298:
2299: dbms_sql.define_column(cur_ussgl, g_num_segs + 1, l_ccid);
2300:
2301: ignore := dbms_sql.execute(cur_ussgl);
2302:
2303: loop

Line 2301: ignore := dbms_sql.execute(cur_ussgl);

2297: end loop;
2298:
2299: dbms_sql.define_column(cur_ussgl, g_num_segs + 1, l_ccid);
2300:
2301: ignore := dbms_sql.execute(cur_ussgl);
2302:
2303: loop
2304:
2305: if dbms_sql.fetch_rows(cur_ussgl) > 0 then

Line 2305: if dbms_sql.fetch_rows(cur_ussgl) > 0 then

2301: ignore := dbms_sql.execute(cur_ussgl);
2302:
2303: loop
2304:
2305: if dbms_sql.fetch_rows(cur_ussgl) > 0 then
2306:
2307: for i in 1..g_num_segs loop
2308: dbms_sql.column_value(cur_ussgl, i, seg_val(i));
2309: end loop;

Line 2308: dbms_sql.column_value(cur_ussgl, i, seg_val(i));

2304:
2305: if dbms_sql.fetch_rows(cur_ussgl) > 0 then
2306:
2307: for i in 1..g_num_segs loop
2308: dbms_sql.column_value(cur_ussgl, i, seg_val(i));
2309: end loop;
2310:
2311: dbms_sql.column_value(cur_ussgl, g_num_segs + 1, l_ccid);
2312:

Line 2311: dbms_sql.column_value(cur_ussgl, g_num_segs + 1, l_ccid);

2307: for i in 1..g_num_segs loop
2308: dbms_sql.column_value(cur_ussgl, i, seg_val(i));
2309: end loop;
2310:
2311: dbms_sql.column_value(cur_ussgl, g_num_segs + 1, l_ccid);
2312:
2313: if not FND_FLEX_EXT.GET_COMBINATION_ID('SQLGL', 'GL#', g_coa_id,
2314: sysdate, g_num_segs, seg_val, l_ccid_out) then
2315: goto return_invalid;

Line 2342: dbms_sql.close_cursor(cur_ussgl);

2338: end if;
2339:
2340: end loop;
2341:
2342: dbms_sql.close_cursor(cur_ussgl);
2343:
2344: -- =========================== FND LOG ===========================
2345: psa_utils.debug_other_string(g_state_level,l_full_path, ' g_fcmode -> ' || g_fcmode);
2346: -- ========================= FND LOG =============================

Line 2381: if dbms_sql.is_open(cur_ussgl) then

2377: -- =========================== FND LOG ===========================
2378: psa_utils.debug_other_string(g_state_level,l_full_path, ' reached return_invalid label ');
2379: -- ========================= FND LOG =============================
2380:
2381: if dbms_sql.is_open(cur_ussgl) then
2382: dbms_sql.close_cursor(cur_ussgl);
2383: end if;
2384:
2385: message_token('PROCEDURE', 'Funds Checker');

Line 2382: dbms_sql.close_cursor(cur_ussgl);

2378: psa_utils.debug_other_string(g_state_level,l_full_path, ' reached return_invalid label ');
2379: -- ========================= FND LOG =============================
2380:
2381: if dbms_sql.is_open(cur_ussgl) then
2382: dbms_sql.close_cursor(cur_ussgl);
2383: end if;
2384:
2385: message_token('PROCEDURE', 'Funds Checker');
2386: message_token('EVENT', FND_MESSAGE.GET_ENCODED);

Line 2410: if dbms_sql.is_open(cur_ussgl) then

2406: if ussgl%ISOPEN then
2407: close ussgl;
2408: end if;
2409:
2410: if dbms_sql.is_open(cur_ussgl) then
2411: dbms_sql.close_cursor(cur_ussgl);
2412: end if;
2413:
2414: if append_je%ISOPEN then

Line 2411: dbms_sql.close_cursor(cur_ussgl);

2407: close ussgl;
2408: end if;
2409:
2410: if dbms_sql.is_open(cur_ussgl) then
2411: dbms_sql.close_cursor(cur_ussgl);
2412: end if;
2413:
2414: if append_je%ISOPEN then
2415: close append_je;