DBA Data[Home] [Help]

APPS.GCS_RULES_PROCESSOR dependencies on DUAL

Line 3747: Select gcs_entry_headers_s.nextval From dual;

3743:
3744: procedureName varchar(30);
3745:
3746: cursor getEntryId is
3747: Select gcs_entry_headers_s.nextval From dual;
3748: entryId gcs_entry_headers.entry_id%TYPE := -1;
3749:
3750: cursor getADEntryId is
3751: SELECT B.assoc_entry_id

Line 4533: Select gcs_entry_headers_s.nextval From dual;

4529:
4530: procedureName varchar(30);
4531:
4532: cursor getEntryId is
4533: Select gcs_entry_headers_s.nextval From dual;
4534: entryId gcs_entry_headers.entry_id%TYPE := -1;
4535:
4536: errbuf varchar2(100);
4537: retcode varchar2(100);

Line 5107: EXECUTE IMMEDIATE 'SELECT ' || l_parsed_formula(i) || ' FROM DUAL'

5103: CLOSE getEvaluatedFormulas;
5104:
5105: FOR i IN 1 .. l_parsed_formula.COUNT LOOP
5106:
5107: EXECUTE IMMEDIATE 'SELECT ' || l_parsed_formula(i) || ' FROM DUAL'
5108: INTO l_parsed_result;
5109:
5110: if (l_parsed_result <> 0) then
5111: l_valid_formula := TRUE;