APPS.PSB_VALIDATE_ACCT_PVT dependencies on DBMS_SQL

Line 771: l_cursor_id := dbms_sql.open_cursor;

767: END LOOP;
768: --
769: l_sql := l_sql ||l_sql_tmp;
770:
771: l_cursor_id := dbms_sql.open_cursor;
772:
773: -- Parsing the statement.
774: dbms_sql.parse(l_cursor_id, l_sql, dbms_sql.v7);
775: -- Bind input variables

Line 774: dbms_sql.parse(l_cursor_id, l_sql, dbms_sql.v7);

770:
771: l_cursor_id := dbms_sql.open_cursor;
772:
773: -- Parsing the statement.
774: dbms_sql.parse(l_cursor_id, l_sql, dbms_sql.v7);
775: -- Bind input variables
776: dbms_sql.bind_variable(l_cursor_id, ':ccid',
777: p_code_combination_id);
778:

Line 776: dbms_sql.bind_variable(l_cursor_id, ':ccid',

772:
773: -- Parsing the statement.
774: dbms_sql.parse(l_cursor_id, l_sql, dbms_sql.v7);
775: -- Bind input variables
776: dbms_sql.bind_variable(l_cursor_id, ':ccid',
777: p_code_combination_id);
778:
779: dbms_sql.bind_variable(l_cursor_id, ':line_sequence_id',
780: p_aps_line_id);

Line 779: dbms_sql.bind_variable(l_cursor_id, ':line_sequence_id',

775: -- Bind input variables
776: dbms_sql.bind_variable(l_cursor_id, ':ccid',
777: p_code_combination_id);
778:
779: dbms_sql.bind_variable(l_cursor_id, ':line_sequence_id',
780: p_aps_line_id);
781:
782: -- define output varaible
783: dbms_sql.define_column(l_cursor_id, 1, l_rec_count);

Line 783: dbms_sql.define_column(l_cursor_id, 1, l_rec_count);

779: dbms_sql.bind_variable(l_cursor_id, ':line_sequence_id',
780: p_aps_line_id);
781:
782: -- define output varaible
783: dbms_sql.define_column(l_cursor_id, 1, l_rec_count);
784: -- execute
785: l_ignore := dbms_sql.execute(l_cursor_id);
786: -- fetch
787: l_ignore := dbms_sql.fetch_rows(l_cursor_id );

Line 785: l_ignore := dbms_sql.execute(l_cursor_id);

781:
782: -- define output varaible
783: dbms_sql.define_column(l_cursor_id, 1, l_rec_count);
784: -- execute
785: l_ignore := dbms_sql.execute(l_cursor_id);
786: -- fetch
787: l_ignore := dbms_sql.fetch_rows(l_cursor_id );
788: -- retrieve the value
789: dbms_sql.column_value(l_cursor_id,1,l_rec_count);

Line 787: l_ignore := dbms_sql.fetch_rows(l_cursor_id );

783: dbms_sql.define_column(l_cursor_id, 1, l_rec_count);
784: -- execute
785: l_ignore := dbms_sql.execute(l_cursor_id);
786: -- fetch
787: l_ignore := dbms_sql.fetch_rows(l_cursor_id );
788: -- retrieve the value
789: dbms_sql.column_value(l_cursor_id,1,l_rec_count);
790: -- close the cursor
791: dbms_sql.close_cursor(l_cursor_id);

Line 789: dbms_sql.column_value(l_cursor_id,1,l_rec_count);

785: l_ignore := dbms_sql.execute(l_cursor_id);
786: -- fetch
787: l_ignore := dbms_sql.fetch_rows(l_cursor_id );
788: -- retrieve the value
789: dbms_sql.column_value(l_cursor_id,1,l_rec_count);
790: -- close the cursor
791: dbms_sql.close_cursor(l_cursor_id);
792:
793: IF l_rec_count > 0 THEN

Line 791: dbms_sql.close_cursor(l_cursor_id);

787: l_ignore := dbms_sql.fetch_rows(l_cursor_id );
788: -- retrieve the value
789: dbms_sql.column_value(l_cursor_id,1,l_rec_count);
790: -- close the cursor
791: dbms_sql.close_cursor(l_cursor_id);
792:
793: IF l_rec_count > 0 THEN
794: RETURN TRUE;
795: ELSE