APPS.EDR_STANDARD dependencies on DBMS_SQL

Line 581: IF dbms_sql.is_open(l_dbms_cur) THEN

577: /* Construct SQL */
578: l_sql:='select document_id from edr_psig_documents where ' || l_where_clause || ' )' ;
579:
580: /* Open Dynamic sql */
581: IF dbms_sql.is_open(l_dbms_cur) THEN
582: dbms_sql.close_cursor(l_dbms_cur);
583: END IF;
584:
585: /* Opening the Cursor to fetch the row */

Line 582: dbms_sql.close_cursor(l_dbms_cur);

578: l_sql:='select document_id from edr_psig_documents where ' || l_where_clause || ' )' ;
579:
580: /* Open Dynamic sql */
581: IF dbms_sql.is_open(l_dbms_cur) THEN
582: dbms_sql.close_cursor(l_dbms_cur);
583: END IF;
584:
585: /* Opening the Cursor to fetch the row */
586: l_dbms_cur:=dbms_sql.open_cursor;

Line 586: l_dbms_cur:=dbms_sql.open_cursor;

582: dbms_sql.close_cursor(l_dbms_cur);
583: END IF;
584:
585: /* Opening the Cursor to fetch the row */
586: l_dbms_cur:=dbms_sql.open_cursor;
587: dbms_sql.parse(l_dbms_cur,l_sql,0);
588: dbms_sql.define_column(l_dbms_cur,1,l_document_id);
589:
590: l_Rows_processed:=dbms_sql.execute(l_dbms_cur);

Line 587: dbms_sql.parse(l_dbms_cur,l_sql,0);

583: END IF;
584:
585: /* Opening the Cursor to fetch the row */
586: l_dbms_cur:=dbms_sql.open_cursor;
587: dbms_sql.parse(l_dbms_cur,l_sql,0);
588: dbms_sql.define_column(l_dbms_cur,1,l_document_id);
589:
590: l_Rows_processed:=dbms_sql.execute(l_dbms_cur);
591: loop

Line 588: dbms_sql.define_column(l_dbms_cur,1,l_document_id);

584:
585: /* Opening the Cursor to fetch the row */
586: l_dbms_cur:=dbms_sql.open_cursor;
587: dbms_sql.parse(l_dbms_cur,l_sql,0);
588: dbms_sql.define_column(l_dbms_cur,1,l_document_id);
589:
590: l_Rows_processed:=dbms_sql.execute(l_dbms_cur);
591: loop
592: IF dbms_sql.fetch_rows(l_dbms_cur) = 0 THEN

Line 590: l_Rows_processed:=dbms_sql.execute(l_dbms_cur);

586: l_dbms_cur:=dbms_sql.open_cursor;
587: dbms_sql.parse(l_dbms_cur,l_sql,0);
588: dbms_sql.define_column(l_dbms_cur,1,l_document_id);
589:
590: l_Rows_processed:=dbms_sql.execute(l_dbms_cur);
591: loop
592: IF dbms_sql.fetch_rows(l_dbms_cur) = 0 THEN
593: exit;
594: ELSE

Line 592: IF dbms_sql.fetch_rows(l_dbms_cur) = 0 THEN

588: dbms_sql.define_column(l_dbms_cur,1,l_document_id);
589:
590: l_Rows_processed:=dbms_sql.execute(l_dbms_cur);
591: loop
592: IF dbms_sql.fetch_rows(l_dbms_cur) = 0 THEN
593: exit;
594: ELSE
595: if (l_count=0) then
596:

Line 600: dbms_sql.column_value(l_dbms_cur,1,l_document_id);

596:
597: select EDR_TRANS_QUERY_TEMP_S.nextval into l_query_id from dual;
598: end if;
599: l_count:=l_count+1;
600: dbms_sql.column_value(l_dbms_cur,1,l_document_id);
601: insert into EDR_TRANS_QUERY_TEMP(QUERY_ID,
602: DOCUMENT_ID,
603: CREATION_DATE,
604: CREATED_BY,

Line 621: dbms_sql.close_cursor(l_dbms_cur);

617: );
618:
619: END IF;
620: END LOOP;
621: dbms_sql.close_cursor(l_dbms_cur);
622: commit;
623:
624: END IF;
625: return l_query_id;