APPS.AZW_PROC dependencies on AZ_CONTEXTS_SQL

Line 531: sqlstatement az_contexts_sql.SQL_STATEMENT%TYPE;

527: RETURN VARCHAR2 IS
528:
529: curs integer;
530: rows integer;
531: sqlstatement az_contexts_sql.SQL_STATEMENT%TYPE;
532: v_ctxt_name az_processes.context_name%TYPE;
533:
534: BEGIN
535:

Line 540: FROM az_contexts_sql

536: v_ctxt_name := NULL;
537:
538: SELECT sql_statement
539: INTO sqlstatement
540: FROM az_contexts_sql
541: WHERE context = ctx_type
542: AND purpose = 'GET_NAME';
543:
544: curs := DBMS_SQL.OPEN_CURSOR;

Line 889: sqlstatement az_contexts_sql.SQL_STATEMENT%TYPE;

885: ORDER BY set_of_books_id;
886:
887: curs integer;
888: rows integer;
889: sqlstatement az_contexts_sql.SQL_STATEMENT%TYPE;
890: t1 NUMBER(15);
891: t2 varchar2(40);
892:
893:

Line 982: FROM az_contexts_sql

978:
979: BEGIN
980: SELECT sql_statement
981: INTO sqlstatement
982: FROM az_contexts_sql
983: WHERE context = ctx_type
984: AND purpose = 'POPULATE';
985:
986: curs := DBMS_SQL.OPEN_CURSOR;

Line 1274: sqlstatement az_contexts_sql.SQL_STATEMENT%TYPE;

1270: PROCEDURE disable_invalid_opm_processes(ctx_type IN VARCHAR2) IS
1271:
1272: curs integer;
1273: rows integer;
1274: sqlstatement az_contexts_sql.SQL_STATEMENT%TYPE;
1275:
1276: BEGIN
1277:
1278: SELECT sql_statement

Line 1280: FROM az_contexts_sql

1276: BEGIN
1277:
1278: SELECT sql_statement
1279: INTO sqlstatement
1280: FROM az_contexts_sql
1281: WHERE context = ctx_type
1282: AND purpose = 'DELETE';
1283:
1284: curs := DBMS_SQL.OPEN_CURSOR;