APPS.PSA_FUNDS_CHECKER_PKG dependencies on DBMS_SQL

Line 2281: cur_ussgl := dbms_sql.open_cursor;

2277: psa_utils.debug_other_string(g_state_level,l_full_path, ' sql_ussgl1 -> ' || SUBSTR(sql_ussgl,1,3500));
2278: psa_utils.debug_other_string(g_state_level,l_full_path, ' sql_ussgl1 -> ' || SUBSTR(sql_ussgl,3500,7000));
2279: -- ========================= FND LOG =============================
2280:
2281: cur_ussgl := dbms_sql.open_cursor;
2282: dbms_sql.parse(cur_ussgl, sql_ussgl, dbms_sql.v7);
2283:
2284: for i in 1..g_num_segs loop
2285: dbms_sql.define_column(cur_ussgl, i, 'segment' || i, 30);

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

2278: psa_utils.debug_other_string(g_state_level,l_full_path, ' sql_ussgl1 -> ' || SUBSTR(sql_ussgl,3500,7000));
2279: -- ========================= FND LOG =============================
2280:
2281: cur_ussgl := dbms_sql.open_cursor;
2282: dbms_sql.parse(cur_ussgl, sql_ussgl, dbms_sql.v7);
2283:
2284: for i in 1..g_num_segs loop
2285: dbms_sql.define_column(cur_ussgl, i, 'segment' || i, 30);
2286: end loop;

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

2281: cur_ussgl := dbms_sql.open_cursor;
2282: dbms_sql.parse(cur_ussgl, sql_ussgl, dbms_sql.v7);
2283:
2284: for i in 1..g_num_segs loop
2285: dbms_sql.define_column(cur_ussgl, i, 'segment' || i, 30);
2286: end loop;
2287:
2288: dbms_sql.define_column(cur_ussgl, g_num_segs + 1, l_ccid);
2289:

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

2284: for i in 1..g_num_segs loop
2285: dbms_sql.define_column(cur_ussgl, i, 'segment' || i, 30);
2286: end loop;
2287:
2288: dbms_sql.define_column(cur_ussgl, g_num_segs + 1, l_ccid);
2289:
2290: ignore := dbms_sql.execute(cur_ussgl);
2291:
2292: loop

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

2286: end loop;
2287:
2288: dbms_sql.define_column(cur_ussgl, g_num_segs + 1, l_ccid);
2289:
2290: ignore := dbms_sql.execute(cur_ussgl);
2291:
2292: loop
2293:
2294: if dbms_sql.fetch_rows(cur_ussgl) > 0 then

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

2290: ignore := dbms_sql.execute(cur_ussgl);
2291:
2292: loop
2293:
2294: if dbms_sql.fetch_rows(cur_ussgl) > 0 then
2295:
2296: for i in 1..g_num_segs loop
2297: dbms_sql.column_value(cur_ussgl, i, seg_val(i));
2298: end loop;

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

2293:
2294: if dbms_sql.fetch_rows(cur_ussgl) > 0 then
2295:
2296: for i in 1..g_num_segs loop
2297: dbms_sql.column_value(cur_ussgl, i, seg_val(i));
2298: end loop;
2299:
2300: dbms_sql.column_value(cur_ussgl, g_num_segs + 1, l_ccid);
2301:

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

2296: for i in 1..g_num_segs loop
2297: dbms_sql.column_value(cur_ussgl, i, seg_val(i));
2298: end loop;
2299:
2300: dbms_sql.column_value(cur_ussgl, g_num_segs + 1, l_ccid);
2301:
2302: if not FND_FLEX_EXT.GET_COMBINATION_ID('SQLGL', 'GL#', g_coa_id,
2303: sysdate, g_num_segs, seg_val, l_ccid_out) then
2304: goto return_invalid;

Line 2331: dbms_sql.close_cursor(cur_ussgl);

2327: end if;
2328:
2329: end loop;
2330:
2331: dbms_sql.close_cursor(cur_ussgl);
2332:
2333: -- =========================== FND LOG ===========================
2334: psa_utils.debug_other_string(g_state_level,l_full_path, ' g_fcmode -> ' || g_fcmode);
2335: -- ========================= FND LOG =============================

Line 2370: if dbms_sql.is_open(cur_ussgl) then

2366: -- =========================== FND LOG ===========================
2367: psa_utils.debug_other_string(g_state_level,l_full_path, ' reached return_invalid label ');
2368: -- ========================= FND LOG =============================
2369:
2370: if dbms_sql.is_open(cur_ussgl) then
2371: dbms_sql.close_cursor(cur_ussgl);
2372: end if;
2373:
2374: message_token('PROCEDURE', 'Funds Checker');

Line 2371: dbms_sql.close_cursor(cur_ussgl);

2367: psa_utils.debug_other_string(g_state_level,l_full_path, ' reached return_invalid label ');
2368: -- ========================= FND LOG =============================
2369:
2370: if dbms_sql.is_open(cur_ussgl) then
2371: dbms_sql.close_cursor(cur_ussgl);
2372: end if;
2373:
2374: message_token('PROCEDURE', 'Funds Checker');
2375: message_token('EVENT', FND_MESSAGE.GET_ENCODED);

Line 2399: if dbms_sql.is_open(cur_ussgl) then

2395: if ussgl%ISOPEN then
2396: close ussgl;
2397: end if;
2398:
2399: if dbms_sql.is_open(cur_ussgl) then
2400: dbms_sql.close_cursor(cur_ussgl);
2401: end if;
2402:
2403: if append_je%ISOPEN then

Line 2400: dbms_sql.close_cursor(cur_ussgl);

2396: close ussgl;
2397: end if;
2398:
2399: if dbms_sql.is_open(cur_ussgl) then
2400: dbms_sql.close_cursor(cur_ussgl);
2401: end if;
2402:
2403: if append_je%ISOPEN then
2404: close append_je;