eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_RULE_VALIDATE_PKG dependencies on DBMS_SQL

Line 2068: source_cursor := DBMS_SQL.OPEN_CURSOR;

2064:
2065:
2066: BEGIN
2067:
2068: source_cursor := DBMS_SQL.OPEN_CURSOR;
2069: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2070: dbms_sql.bind_variable(source_cursor , '1' , p_FlexFieldName);
2071: dbms_sql.bind_variable(source_cursor , '2' , p_FlexFieldAppShortName);
2072:

Line 2069: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);

2065:
2066: BEGIN
2067:
2068: source_cursor := DBMS_SQL.OPEN_CURSOR;
2069: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2070: dbms_sql.bind_variable(source_cursor , '1' , p_FlexFieldName);
2071: dbms_sql.bind_variable(source_cursor , '2' , p_FlexFieldAppShortName);
2072:
2073: dbms_sql.define_column(source_cursor, 1, l_num);

Line 2070: dbms_sql.bind_variable(source_cursor , '1' , p_FlexFieldName);

2066: BEGIN
2067:
2068: source_cursor := DBMS_SQL.OPEN_CURSOR;
2069: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2070: dbms_sql.bind_variable(source_cursor , '1' , p_FlexFieldName);
2071: dbms_sql.bind_variable(source_cursor , '2' , p_FlexFieldAppShortName);
2072:
2073: dbms_sql.define_column(source_cursor, 1, l_num);
2074:

Line 2071: dbms_sql.bind_variable(source_cursor , '2' , p_FlexFieldAppShortName);

2067:
2068: source_cursor := DBMS_SQL.OPEN_CURSOR;
2069: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2070: dbms_sql.bind_variable(source_cursor , '1' , p_FlexFieldName);
2071: dbms_sql.bind_variable(source_cursor , '2' , p_FlexFieldAppShortName);
2072:
2073: dbms_sql.define_column(source_cursor, 1, l_num);
2074:
2075: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

Line 2073: dbms_sql.define_column(source_cursor, 1, l_num);

2069: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2070: dbms_sql.bind_variable(source_cursor , '1' , p_FlexFieldName);
2071: dbms_sql.bind_variable(source_cursor , '2' , p_FlexFieldAppShortName);
2072:
2073: dbms_sql.define_column(source_cursor, 1, l_num);
2074:
2075: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2076:
2077: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN

Line 2075: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

2071: dbms_sql.bind_variable(source_cursor , '2' , p_FlexFieldAppShortName);
2072:
2073: dbms_sql.define_column(source_cursor, 1, l_num);
2074:
2075: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2076:
2077: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
2078: -- get column values of the row
2079: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);

Line 2077: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN

2073: dbms_sql.define_column(source_cursor, 1, l_num);
2074:
2075: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2076:
2077: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
2078: -- get column values of the row
2079: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
2080: END IF;
2081:

Line 2079: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);

2075: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2076:
2077: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
2078: -- get column values of the row
2079: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
2080: END IF;
2081:
2082: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2083:

Line 2082: DBMS_SQL.CLOSE_CURSOR(source_cursor);

2078: -- get column values of the row
2079: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
2080: END IF;
2081:
2082: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2083:
2084: IF(l_num > 0) THEN RETURN TRUE;
2085: ELSE RETURN FALSE;
2086: END IF;

Line 2090: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

2086: END IF;
2087:
2088: EXCEPTION
2089: WHEN OTHERS THEN
2090: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
2091: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2092: END IF;
2093: RETURN FALSE;
2094: END isFlexFieldValid;

Line 2091: DBMS_SQL.CLOSE_CURSOR(source_cursor);

2087:
2088: EXCEPTION
2089: WHEN OTHERS THEN
2090: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
2091: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2092: END IF;
2093: RETURN FALSE;
2094: END isFlexFieldValid;
2095:

Line 2110: source_cursor := DBMS_SQL.OPEN_CURSOR;

2106:
2107:
2108: BEGIN
2109:
2110: source_cursor := DBMS_SQL.OPEN_CURSOR;
2111: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2112: dbms_sql.bind_variable(source_cursor , '1' , p_org_id);
2113:
2114: dbms_sql.define_column(source_cursor, 1, l_num);

Line 2111: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);

2107:
2108: BEGIN
2109:
2110: source_cursor := DBMS_SQL.OPEN_CURSOR;
2111: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2112: dbms_sql.bind_variable(source_cursor , '1' , p_org_id);
2113:
2114: dbms_sql.define_column(source_cursor, 1, l_num);
2115:

Line 2112: dbms_sql.bind_variable(source_cursor , '1' , p_org_id);

2108: BEGIN
2109:
2110: source_cursor := DBMS_SQL.OPEN_CURSOR;
2111: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2112: dbms_sql.bind_variable(source_cursor , '1' , p_org_id);
2113:
2114: dbms_sql.define_column(source_cursor, 1, l_num);
2115:
2116: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

Line 2114: dbms_sql.define_column(source_cursor, 1, l_num);

2110: source_cursor := DBMS_SQL.OPEN_CURSOR;
2111: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2112: dbms_sql.bind_variable(source_cursor , '1' , p_org_id);
2113:
2114: dbms_sql.define_column(source_cursor, 1, l_num);
2115:
2116: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2117:
2118: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN

Line 2116: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

2112: dbms_sql.bind_variable(source_cursor , '1' , p_org_id);
2113:
2114: dbms_sql.define_column(source_cursor, 1, l_num);
2115:
2116: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2117:
2118: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
2119: -- get column values of the row
2120: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);

Line 2118: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN

2114: dbms_sql.define_column(source_cursor, 1, l_num);
2115:
2116: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2117:
2118: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
2119: -- get column values of the row
2120: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
2121: END IF;
2122:

Line 2120: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);

2116: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2117:
2118: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
2119: -- get column values of the row
2120: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
2121: END IF;
2122:
2123: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2124:

Line 2123: DBMS_SQL.CLOSE_CURSOR(source_cursor);

2119: -- get column values of the row
2120: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
2121: END IF;
2122:
2123: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2124:
2125: IF(l_num > 0) THEN RETURN TRUE;
2126: ELSE RETURN FALSE;
2127: END IF;

Line 2131: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

2127: END IF;
2128:
2129: EXCEPTION
2130: WHEN OTHERS THEN
2131: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
2132: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2133: END IF;
2134: RETURN FALSE;
2135: END validate_org_id;

Line 2132: DBMS_SQL.CLOSE_CURSOR(source_cursor);

2128:
2129: EXCEPTION
2130: WHEN OTHERS THEN
2131: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
2132: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2133: END IF;
2134: RETURN FALSE;
2135: END validate_org_id;
2136:

Line 2150: source_cursor := DBMS_SQL.OPEN_CURSOR;

2146: WHERE APPLICATION_ID = :1';
2147:
2148:
2149: BEGIN
2150: source_cursor := DBMS_SQL.OPEN_CURSOR;
2151: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2152: dbms_sql.bind_variable(source_cursor , '1' , p_application_id);
2153:
2154: dbms_sql.define_column(source_cursor, 1, l_num);

Line 2151: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);

2147:
2148:
2149: BEGIN
2150: source_cursor := DBMS_SQL.OPEN_CURSOR;
2151: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2152: dbms_sql.bind_variable(source_cursor , '1' , p_application_id);
2153:
2154: dbms_sql.define_column(source_cursor, 1, l_num);
2155:

Line 2152: dbms_sql.bind_variable(source_cursor , '1' , p_application_id);

2148:
2149: BEGIN
2150: source_cursor := DBMS_SQL.OPEN_CURSOR;
2151: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2152: dbms_sql.bind_variable(source_cursor , '1' , p_application_id);
2153:
2154: dbms_sql.define_column(source_cursor, 1, l_num);
2155:
2156: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

Line 2154: dbms_sql.define_column(source_cursor, 1, l_num);

2150: source_cursor := DBMS_SQL.OPEN_CURSOR;
2151: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2152: dbms_sql.bind_variable(source_cursor , '1' , p_application_id);
2153:
2154: dbms_sql.define_column(source_cursor, 1, l_num);
2155:
2156: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2157:
2158: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN

Line 2156: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

2152: dbms_sql.bind_variable(source_cursor , '1' , p_application_id);
2153:
2154: dbms_sql.define_column(source_cursor, 1, l_num);
2155:
2156: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2157:
2158: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
2159: -- get column values of the row
2160: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);

Line 2158: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN

2154: dbms_sql.define_column(source_cursor, 1, l_num);
2155:
2156: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2157:
2158: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
2159: -- get column values of the row
2160: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
2161: END IF;
2162:

Line 2160: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);

2156: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2157:
2158: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
2159: -- get column values of the row
2160: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
2161: END IF;
2162:
2163: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2164:

Line 2163: DBMS_SQL.CLOSE_CURSOR(source_cursor);

2159: -- get column values of the row
2160: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
2161: END IF;
2162:
2163: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2164:
2165: IF(l_num > 0) THEN RETURN TRUE;
2166: ELSE RETURN FALSE;
2167: END IF;

Line 2171: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

2167: END IF;
2168:
2169: EXCEPTION
2170: WHEN OTHERS THEN
2171: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
2172: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2173: END IF;
2174: RETURN FALSE;
2175: END validate_application_id;

Line 2172: DBMS_SQL.CLOSE_CURSOR(source_cursor);

2168:
2169: EXCEPTION
2170: WHEN OTHERS THEN
2171: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
2172: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2173: END IF;
2174: RETURN FALSE;
2175: END validate_application_id;
2176:

Line 2191: source_cursor := DBMS_SQL.OPEN_CURSOR;

2187: WHERE FLEX_VALUE_SET_ID = :1';
2188:
2189: BEGIN
2190:
2191: source_cursor := DBMS_SQL.OPEN_CURSOR;
2192: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2193: dbms_sql.bind_variable(source_cursor , '1' , p_flex_value_set_id);
2194:
2195: dbms_sql.define_column(source_cursor, 1, l_num);

Line 2192: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);

2188:
2189: BEGIN
2190:
2191: source_cursor := DBMS_SQL.OPEN_CURSOR;
2192: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2193: dbms_sql.bind_variable(source_cursor , '1' , p_flex_value_set_id);
2194:
2195: dbms_sql.define_column(source_cursor, 1, l_num);
2196:

Line 2193: dbms_sql.bind_variable(source_cursor , '1' , p_flex_value_set_id);

2189: BEGIN
2190:
2191: source_cursor := DBMS_SQL.OPEN_CURSOR;
2192: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2193: dbms_sql.bind_variable(source_cursor , '1' , p_flex_value_set_id);
2194:
2195: dbms_sql.define_column(source_cursor, 1, l_num);
2196:
2197: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

Line 2195: dbms_sql.define_column(source_cursor, 1, l_num);

2191: source_cursor := DBMS_SQL.OPEN_CURSOR;
2192: DBMS_SQL.PARSE(source_cursor, l_DFFSql,DBMS_SQL.native);
2193: dbms_sql.bind_variable(source_cursor , '1' , p_flex_value_set_id);
2194:
2195: dbms_sql.define_column(source_cursor, 1, l_num);
2196:
2197: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2198:
2199: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN

Line 2197: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);

2193: dbms_sql.bind_variable(source_cursor , '1' , p_flex_value_set_id);
2194:
2195: dbms_sql.define_column(source_cursor, 1, l_num);
2196:
2197: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2198:
2199: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
2200: -- get column values of the row
2201: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);

Line 2199: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN

2195: dbms_sql.define_column(source_cursor, 1, l_num);
2196:
2197: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2198:
2199: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
2200: -- get column values of the row
2201: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
2202: END IF;
2203:

Line 2201: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);

2197: num_rows_processed := DBMS_SQL.EXECUTE(source_cursor);
2198:
2199: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
2200: -- get column values of the row
2201: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
2202: END IF;
2203:
2204: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2205:

Line 2204: DBMS_SQL.CLOSE_CURSOR(source_cursor);

2200: -- get column values of the row
2201: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_num);
2202: END IF;
2203:
2204: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2205:
2206: IF(l_num > 0) THEN RETURN TRUE;
2207: ELSE RETURN FALSE;
2208: END IF;

Line 2212: IF DBMS_SQL.IS_OPEN(source_cursor) THEN

2208: END IF;
2209:
2210: EXCEPTION
2211: WHEN OTHERS THEN
2212: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
2213: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2214: END IF;
2215: RETURN FALSE;
2216: END validate_flex_value_set_id;

Line 2213: DBMS_SQL.CLOSE_CURSOR(source_cursor);

2209:
2210: EXCEPTION
2211: WHEN OTHERS THEN
2212: IF DBMS_SQL.IS_OPEN(source_cursor) THEN
2213: DBMS_SQL.CLOSE_CURSOR(source_cursor);
2214: END IF;
2215: RETURN FALSE;
2216: END validate_flex_value_set_id;
2217: