APPS.GL_SECURITY_PKG dependencies on GL_BIS_SEGVAL_INT

Line 145: -- To initialize, populate and update GL_BIS_SEGVAL_INT temporary

141:
142: -- Procedure
143: -- init
144: -- Purpose
145: -- To initialize, populate and update GL_BIS_SEGVAL_INT temporary
146: -- table based on segment value security rules.
147: -- This procedure is called from the Discoverer's POST_LOGON trigger.
148: --
149: PROCEDURE init IS

Line 159: -- Populate the Global Temporary Table GL_BIS_SEGVAL_INT

155: BEGIN
156: -- Now there is no need to check for the module name for a session
157: -- as this procedure is always going to be called from the
158: -- Discoverer's POST_LOGON trigger
159: -- Populate the Global Temporary Table GL_BIS_SEGVAL_INT
160: -- with the security rules
161:
162: delete from GL_BIS_SEGVAL_INT; -- 6341771, clean up the existing rows
163: init_segval;

Line 162: delete from GL_BIS_SEGVAL_INT; -- 6341771, clean up the existing rows

158: -- Discoverer's POST_LOGON trigger
159: -- Populate the Global Temporary Table GL_BIS_SEGVAL_INT
160: -- with the security rules
161:
162: delete from GL_BIS_SEGVAL_INT; -- 6341771, clean up the existing rows
163: init_segval;
164: commit; -- 6341771, execute commit in autonomous transaction
165: END init;
166:

Line 170: -- Initialize, populate and update GL_BIS_SEGVAL_INT temporary

166:
167: -- Procedure
168: -- init_segval
169: -- Purpose
170: -- Initialize, populate and update GL_BIS_SEGVAL_INT temporary
171: -- table based on segment value security rules
172: --
173: PROCEDURE init_segval IS
174:

Line 343: sql_stmt := 'INSERT INTO GL_BIS_SEGVAL_INT( ' ||

339: EXIT WHEN seg_cur%NOTFOUND;
340:
341: IF validate_type <> 'F' THEN
342: -- Not table validated segment
343: sql_stmt := 'INSERT INTO GL_BIS_SEGVAL_INT( ' ||
344: 'segment_column_name,' ||
345: 'segment_value, ' ||
346: 'parent_segment) ' ||
347: 'SELECT ''' || segment_column_name || ''',' ||

Line 359: sql_stmt := 'INSERT INTO GL_BIS_SEGVAL_INT( ' ||

355: INTO v_column_name, v_appl_table_name
356: FROM FND_FLEX_VALIDATION_TABLES
357: WHERE flex_value_set_id = value_set_id;
358:
359: sql_stmt := 'INSERT INTO GL_BIS_SEGVAL_INT( ' ||
360: 'segment_column_name,' ||
361: 'segment_value,' ||
362: 'parent_segment) ' ||
363: ' SELECT ''' || segment_column_name || ''',' ||

Line 368: sql_stmt2 := 'INSERT INTO GL_BIS_SEGVAL_INT( ' ||

364: v_column_name || ',' || 'NULL' ||
365: ' FROM ' || v_appl_table_name;
366:
367: -- Insert parent segment value for table validated segment
368: sql_stmt2 := 'INSERT INTO GL_BIS_SEGVAL_INT( ' ||
369: 'segment_column_name,' ||
370: 'segment_value, ' ||
371: 'parent_segment) ' ||
372: ' SELECT ''' || segment_column_name || ''',' ||

Line 437: del_stmt := 'DELETE /*+ index(gl_bis_segval_int gl_bis_segval_int_n1) */ FROM GL_BIS_SEGVAL_INT ' ||

433: count_line := 0;
434: count_stmt := 0;
435:
436: -- The first part of the delete statement is fixed within the rule
437: del_stmt := 'DELETE /*+ index(gl_bis_segval_int gl_bis_segval_int_n1) */ FROM GL_BIS_SEGVAL_INT ' ||
438: 'WHERE segment_column_name=''' || segment_column_name || '''';
439:
440: -- If the segment is a dependent segment, then add dynamic
441: -- SQL statement where clause for the parent segment

Line 450: -- DELETE /*+ index(gl_bis_segval_int gl_bis_segval_int_n1) */

446:
447: -- Build Dynamic SQL statement to delete all segment values
448: -- not in the include range
449: -- Dynamic SQL statement example:
450: -- DELETE /*+ index(gl_bis_segval_int gl_bis_segval_int_n1) */
451: -- FROM GL_BIS_SEGVAL_INT
452: -- WHERE segment_column_name = 'SEGMENT1'
453: -- AND parent_segment = '01'
454: -- AND ( segment_value < '100'

Line 451: -- FROM GL_BIS_SEGVAL_INT

447: -- Build Dynamic SQL statement to delete all segment values
448: -- not in the include range
449: -- Dynamic SQL statement example:
450: -- DELETE /*+ index(gl_bis_segval_int gl_bis_segval_int_n1) */
451: -- FROM GL_BIS_SEGVAL_INT
452: -- WHERE segment_column_name = 'SEGMENT1'
453: -- AND parent_segment = '01'
454: -- AND ( segment_value < '100'
455: -- OR (segment_value > '300' AND segment_value < '500')...)

Line 608: -- DELETE /*+ index(gl_bis_segval_int gl_bis_segval_int_n1) */

604:
605: -- Build Dynamic SQL statement to delete all segment values
606: -- in the exclude range
607: -- Dynamic SQL statement example:
608: -- DELETE /*+ index(gl_bis_segval_int gl_bis_segval_int_n1) */
609: -- FROM GL_BIS_SEGVAL_INT
610: -- WHERE segment_column_name = 'SEGMENT1'
611: -- AND parent_segment = '01'
612: -- AND ( segment_value < '100'

Line 609: -- FROM GL_BIS_SEGVAL_INT

605: -- Build Dynamic SQL statement to delete all segment values
606: -- in the exclude range
607: -- Dynamic SQL statement example:
608: -- DELETE /*+ index(gl_bis_segval_int gl_bis_segval_int_n1) */
609: -- FROM GL_BIS_SEGVAL_INT
610: -- WHERE segment_column_name = 'SEGMENT1'
611: -- AND parent_segment = '01'
612: -- AND ( segment_value < '100'
613: -- OR (segment_value >= '300' AND segment_value <= '500')...)

Line 816: -- according to the rules stored in GL_BIS_SEGVAL_INT temporary

812: -- Function
813: -- Validate_access
814: -- Purpose
815: -- Validate the given code combination id and ledger id
816: -- according to the rules stored in GL_BIS_SEGVAL_INT temporary
817: -- table by gl_security_pkg.init
818: --
819: FUNCTION validate_access(p_ledger_id IN NUMBER DEFAULT NULL,
820: ccid IN NUMBER DEFAULT NULL) RETURN VARCHAR2 IS

Line 1031: -- exists in the GL_BIS_SEGVAL_INT temporary table. If not,

1027: END;
1028:
1029: -- For each segment of the given code combination id, if the
1030: -- segment is secruity enabled, we check if the segment value
1031: -- exists in the GL_BIS_SEGVAL_INT temporary table. If not,
1032: -- then return FALSE.
1033:
1034: IF (seg1_flag) THEN
1035: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

Line 1035: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1031: -- exists in the GL_BIS_SEGVAL_INT temporary table. If not,
1032: -- then return FALSE.
1033:
1034: IF (seg1_flag) THEN
1035: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1036: count(*)
1037: into total_count
1038: FROM GL_BIS_SEGVAL_INT
1039: WHERE segment_column_name = 'SEGMENT1'

Line 1038: FROM GL_BIS_SEGVAL_INT

1034: IF (seg1_flag) THEN
1035: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1036: count(*)
1037: into total_count
1038: FROM GL_BIS_SEGVAL_INT
1039: WHERE segment_column_name = 'SEGMENT1'
1040: AND segment_value = segment1;
1041:
1042: IF (total_count = 0) THEN

Line 1048: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1044: END IF;
1045: END IF;
1046:
1047: IF (seg2_flag) THEN
1048: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1049: count(*)
1050: into total_count
1051: FROM GL_BIS_SEGVAL_INT
1052: WHERE segment_column_name = 'SEGMENT2'

Line 1051: FROM GL_BIS_SEGVAL_INT

1047: IF (seg2_flag) THEN
1048: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1049: count(*)
1050: into total_count
1051: FROM GL_BIS_SEGVAL_INT
1052: WHERE segment_column_name = 'SEGMENT2'
1053: AND segment_value = segment2;
1054:
1055: IF (total_count = 0) THEN

Line 1061: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1057: END IF;
1058: END IF;
1059:
1060: IF (seg3_flag) THEN
1061: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1062: count(*)
1063: into total_count
1064: FROM GL_BIS_SEGVAL_INT
1065: WHERE segment_column_name = 'SEGMENT3'

Line 1064: FROM GL_BIS_SEGVAL_INT

1060: IF (seg3_flag) THEN
1061: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1062: count(*)
1063: into total_count
1064: FROM GL_BIS_SEGVAL_INT
1065: WHERE segment_column_name = 'SEGMENT3'
1066: AND segment_value = segment3;
1067:
1068: IF (total_count = 0) THEN

Line 1074: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1070: END IF;
1071: END IF;
1072:
1073: IF (seg4_flag) THEN
1074: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1075: count(*)
1076: into total_count
1077: FROM GL_BIS_SEGVAL_INT
1078: WHERE segment_column_name = 'SEGMENT4'

Line 1077: FROM GL_BIS_SEGVAL_INT

1073: IF (seg4_flag) THEN
1074: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1075: count(*)
1076: into total_count
1077: FROM GL_BIS_SEGVAL_INT
1078: WHERE segment_column_name = 'SEGMENT4'
1079: AND segment_value = segment4;
1080:
1081: IF (total_count = 0) THEN

Line 1087: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1083: END IF;
1084: END IF;
1085:
1086: IF (seg5_flag) THEN
1087: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1088: count(*)
1089: into total_count
1090: FROM GL_BIS_SEGVAL_INT
1091: WHERE segment_column_name = 'SEGMENT5'

Line 1090: FROM GL_BIS_SEGVAL_INT

1086: IF (seg5_flag) THEN
1087: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1088: count(*)
1089: into total_count
1090: FROM GL_BIS_SEGVAL_INT
1091: WHERE segment_column_name = 'SEGMENT5'
1092: AND segment_value = segment5;
1093:
1094: IF (total_count = 0) THEN

Line 1100: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1096: END IF;
1097: END IF;
1098:
1099: IF (seg6_flag) THEN
1100: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1101: count(*)
1102: into total_count
1103: FROM GL_BIS_SEGVAL_INT
1104: WHERE segment_column_name = 'SEGMENT6'

Line 1103: FROM GL_BIS_SEGVAL_INT

1099: IF (seg6_flag) THEN
1100: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1101: count(*)
1102: into total_count
1103: FROM GL_BIS_SEGVAL_INT
1104: WHERE segment_column_name = 'SEGMENT6'
1105: AND segment_value = segment6;
1106:
1107: IF (total_count = 0) THEN

Line 1113: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1109: END IF;
1110: END IF;
1111:
1112: IF (seg7_flag) THEN
1113: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1114: count(*)
1115: into total_count
1116: FROM GL_BIS_SEGVAL_INT
1117: WHERE segment_column_name = 'SEGMENT7'

Line 1116: FROM GL_BIS_SEGVAL_INT

1112: IF (seg7_flag) THEN
1113: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1114: count(*)
1115: into total_count
1116: FROM GL_BIS_SEGVAL_INT
1117: WHERE segment_column_name = 'SEGMENT7'
1118: AND segment_value = segment7;
1119:
1120: IF (total_count = 0) THEN

Line 1126: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1122: END IF;
1123: END IF;
1124:
1125: IF (seg8_flag) THEN
1126: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1127: count(*)
1128: into total_count
1129: FROM GL_BIS_SEGVAL_INT
1130: WHERE segment_column_name = 'SEGMENT8'

Line 1129: FROM GL_BIS_SEGVAL_INT

1125: IF (seg8_flag) THEN
1126: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1127: count(*)
1128: into total_count
1129: FROM GL_BIS_SEGVAL_INT
1130: WHERE segment_column_name = 'SEGMENT8'
1131: AND segment_value = segment8;
1132:
1133: IF (total_count = 0) THEN

Line 1139: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1135: END IF;
1136: END IF;
1137:
1138: IF (seg9_flag) THEN
1139: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1140: count(*)
1141: into total_count
1142: FROM GL_BIS_SEGVAL_INT
1143: WHERE segment_column_name = 'SEGMENT9'

Line 1142: FROM GL_BIS_SEGVAL_INT

1138: IF (seg9_flag) THEN
1139: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1140: count(*)
1141: into total_count
1142: FROM GL_BIS_SEGVAL_INT
1143: WHERE segment_column_name = 'SEGMENT9'
1144: AND segment_value = segment9;
1145:
1146: IF (total_count = 0) THEN

Line 1152: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1148: END IF;
1149: END IF;
1150:
1151: IF (seg10_flag) THEN
1152: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1153: count(*)
1154: into total_count
1155: FROM GL_BIS_SEGVAL_INT
1156: WHERE segment_column_name = 'SEGMENT10'

Line 1155: FROM GL_BIS_SEGVAL_INT

1151: IF (seg10_flag) THEN
1152: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1153: count(*)
1154: into total_count
1155: FROM GL_BIS_SEGVAL_INT
1156: WHERE segment_column_name = 'SEGMENT10'
1157: AND segment_value = segment10;
1158:
1159: IF (total_count = 0) THEN

Line 1165: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1161: END IF;
1162: END IF;
1163:
1164: IF (seg11_flag) THEN
1165: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1166: count(*)
1167: into total_count
1168: FROM GL_BIS_SEGVAL_INT
1169: WHERE segment_column_name = 'SEGMENT11'

Line 1168: FROM GL_BIS_SEGVAL_INT

1164: IF (seg11_flag) THEN
1165: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1166: count(*)
1167: into total_count
1168: FROM GL_BIS_SEGVAL_INT
1169: WHERE segment_column_name = 'SEGMENT11'
1170: AND segment_value = segment11;
1171:
1172: IF (total_count = 0) THEN

Line 1178: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1174: END IF;
1175: END IF;
1176:
1177: IF (seg12_flag) THEN
1178: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1179: count(*)
1180: into total_count
1181: FROM GL_BIS_SEGVAL_INT
1182: WHERE segment_column_name = 'SEGMENT12'

Line 1181: FROM GL_BIS_SEGVAL_INT

1177: IF (seg12_flag) THEN
1178: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1179: count(*)
1180: into total_count
1181: FROM GL_BIS_SEGVAL_INT
1182: WHERE segment_column_name = 'SEGMENT12'
1183: AND segment_value = segment12;
1184:
1185: IF (total_count = 0) THEN

Line 1191: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1187: END IF;
1188: END IF;
1189:
1190: IF (seg13_flag) THEN
1191: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1192: count(*)
1193: into total_count
1194: FROM GL_BIS_SEGVAL_INT
1195: WHERE segment_column_name = 'SEGMENT13'

Line 1194: FROM GL_BIS_SEGVAL_INT

1190: IF (seg13_flag) THEN
1191: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1192: count(*)
1193: into total_count
1194: FROM GL_BIS_SEGVAL_INT
1195: WHERE segment_column_name = 'SEGMENT13'
1196: AND segment_value = segment13;
1197:
1198: IF (total_count = 0) THEN

Line 1204: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1200: END IF;
1201: END IF;
1202:
1203: IF (seg14_flag) THEN
1204: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1205: count(*)
1206: into total_count
1207: FROM GL_BIS_SEGVAL_INT
1208: WHERE segment_column_name = 'SEGMENT14'

Line 1207: FROM GL_BIS_SEGVAL_INT

1203: IF (seg14_flag) THEN
1204: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1205: count(*)
1206: into total_count
1207: FROM GL_BIS_SEGVAL_INT
1208: WHERE segment_column_name = 'SEGMENT14'
1209: AND segment_value = segment14;
1210:
1211: IF (total_count = 0) THEN

Line 1217: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1213: END IF;
1214: END IF;
1215:
1216: IF (seg15_flag) THEN
1217: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1218: count(*)
1219: into total_count
1220: FROM GL_BIS_SEGVAL_INT
1221: WHERE segment_column_name = 'SEGMENT15'

Line 1220: FROM GL_BIS_SEGVAL_INT

1216: IF (seg15_flag) THEN
1217: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1218: count(*)
1219: into total_count
1220: FROM GL_BIS_SEGVAL_INT
1221: WHERE segment_column_name = 'SEGMENT15'
1222: AND segment_value = segment15;
1223:
1224: IF (total_count = 0) THEN

Line 1230: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1226: END IF;
1227: END IF;
1228:
1229: IF (seg16_flag) THEN
1230: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1231: count(*)
1232: into total_count
1233: FROM GL_BIS_SEGVAL_INT
1234: WHERE segment_column_name = 'SEGMENT16'

Line 1233: FROM GL_BIS_SEGVAL_INT

1229: IF (seg16_flag) THEN
1230: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1231: count(*)
1232: into total_count
1233: FROM GL_BIS_SEGVAL_INT
1234: WHERE segment_column_name = 'SEGMENT16'
1235: AND segment_value = segment16;
1236:
1237: IF (total_count = 0) THEN

Line 1243: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1239: END IF;
1240: END IF;
1241:
1242: IF (seg17_flag) THEN
1243: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1244: count(*)
1245: into total_count
1246: FROM GL_BIS_SEGVAL_INT
1247: WHERE segment_column_name = 'SEGMENT17'

Line 1246: FROM GL_BIS_SEGVAL_INT

1242: IF (seg17_flag) THEN
1243: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1244: count(*)
1245: into total_count
1246: FROM GL_BIS_SEGVAL_INT
1247: WHERE segment_column_name = 'SEGMENT17'
1248: AND segment_value = segment17;
1249:
1250: IF (total_count = 0) THEN

Line 1256: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1252: END IF;
1253: END IF;
1254:
1255: IF (seg18_flag) THEN
1256: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1257: count(*)
1258: into total_count
1259: FROM GL_BIS_SEGVAL_INT
1260: WHERE segment_column_name = 'SEGMENT18'

Line 1259: FROM GL_BIS_SEGVAL_INT

1255: IF (seg18_flag) THEN
1256: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1257: count(*)
1258: into total_count
1259: FROM GL_BIS_SEGVAL_INT
1260: WHERE segment_column_name = 'SEGMENT18'
1261: AND segment_value = segment18;
1262:
1263: IF (total_count = 0) THEN

Line 1269: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1265: END IF;
1266: END IF;
1267:
1268: IF (seg19_flag) THEN
1269: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1270: count(*)
1271: into total_count
1272: FROM GL_BIS_SEGVAL_INT
1273: WHERE segment_column_name = 'SEGMENT19'

Line 1272: FROM GL_BIS_SEGVAL_INT

1268: IF (seg19_flag) THEN
1269: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1270: count(*)
1271: into total_count
1272: FROM GL_BIS_SEGVAL_INT
1273: WHERE segment_column_name = 'SEGMENT19'
1274: AND segment_value = segment19;
1275:
1276: IF (total_count = 0) THEN

Line 1282: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1278: END IF;
1279: END IF;
1280:
1281: IF (seg20_flag) THEN
1282: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1283: count(*)
1284: into total_count
1285: FROM GL_BIS_SEGVAL_INT
1286: WHERE segment_column_name = 'SEGMENT20'

Line 1285: FROM GL_BIS_SEGVAL_INT

1281: IF (seg20_flag) THEN
1282: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1283: count(*)
1284: into total_count
1285: FROM GL_BIS_SEGVAL_INT
1286: WHERE segment_column_name = 'SEGMENT20'
1287: AND segment_value = segment20;
1288:
1289: IF (total_count = 0) THEN

Line 1295: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1291: END IF;
1292: END IF;
1293:
1294: IF (seg21_flag) THEN
1295: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1296: count(*)
1297: into total_count
1298: FROM GL_BIS_SEGVAL_INT
1299: WHERE segment_column_name = 'SEGMENT21'

Line 1298: FROM GL_BIS_SEGVAL_INT

1294: IF (seg21_flag) THEN
1295: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1296: count(*)
1297: into total_count
1298: FROM GL_BIS_SEGVAL_INT
1299: WHERE segment_column_name = 'SEGMENT21'
1300: AND segment_value = segment21;
1301:
1302: IF (total_count = 0) THEN

Line 1308: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1304: END IF;
1305: END IF;
1306:
1307: IF (seg22_flag) THEN
1308: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1309: count(*)
1310: into total_count
1311: FROM GL_BIS_SEGVAL_INT
1312: WHERE segment_column_name = 'SEGMENT22'

Line 1311: FROM GL_BIS_SEGVAL_INT

1307: IF (seg22_flag) THEN
1308: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1309: count(*)
1310: into total_count
1311: FROM GL_BIS_SEGVAL_INT
1312: WHERE segment_column_name = 'SEGMENT22'
1313: AND segment_value = segment22;
1314:
1315: IF (total_count = 0) THEN

Line 1321: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1317: END IF;
1318: END IF;
1319:
1320: IF (seg23_flag) THEN
1321: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1322: count(*)
1323: into total_count
1324: FROM GL_BIS_SEGVAL_INT
1325: WHERE segment_column_name = 'SEGMENT23'

Line 1324: FROM GL_BIS_SEGVAL_INT

1320: IF (seg23_flag) THEN
1321: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1322: count(*)
1323: into total_count
1324: FROM GL_BIS_SEGVAL_INT
1325: WHERE segment_column_name = 'SEGMENT23'
1326: AND segment_value = segment23;
1327:
1328: IF (total_count = 0) THEN

Line 1334: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1330: END IF;
1331: END IF;
1332:
1333: IF (seg24_flag) THEN
1334: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1335: count(*)
1336: into total_count
1337: FROM GL_BIS_SEGVAL_INT
1338: WHERE segment_column_name = 'SEGMENT24'

Line 1337: FROM GL_BIS_SEGVAL_INT

1333: IF (seg24_flag) THEN
1334: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1335: count(*)
1336: into total_count
1337: FROM GL_BIS_SEGVAL_INT
1338: WHERE segment_column_name = 'SEGMENT24'
1339: AND segment_value = segment24;
1340:
1341: IF (total_count = 0) THEN

Line 1347: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1343: END IF;
1344: END IF;
1345:
1346: IF (seg25_flag) THEN
1347: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1348: count(*)
1349: into total_count
1350: FROM GL_BIS_SEGVAL_INT
1351: WHERE segment_column_name = 'SEGMENT25'

Line 1350: FROM GL_BIS_SEGVAL_INT

1346: IF (seg25_flag) THEN
1347: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1348: count(*)
1349: into total_count
1350: FROM GL_BIS_SEGVAL_INT
1351: WHERE segment_column_name = 'SEGMENT25'
1352: AND segment_value = segment25;
1353:
1354: IF (total_count = 0) THEN

Line 1360: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1356: END IF;
1357: END IF;
1358:
1359: IF (seg26_flag) THEN
1360: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1361: count(*)
1362: into total_count
1363: FROM GL_BIS_SEGVAL_INT
1364: WHERE segment_column_name = 'SEGMENT26'

Line 1363: FROM GL_BIS_SEGVAL_INT

1359: IF (seg26_flag) THEN
1360: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1361: count(*)
1362: into total_count
1363: FROM GL_BIS_SEGVAL_INT
1364: WHERE segment_column_name = 'SEGMENT26'
1365: AND segment_value = segment26;
1366:
1367: IF (total_count = 0) THEN

Line 1373: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1369: END IF;
1370: END IF;
1371:
1372: IF (seg27_flag) THEN
1373: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1374: count(*)
1375: into total_count
1376: FROM GL_BIS_SEGVAL_INT
1377: WHERE segment_column_name = 'SEGMENT27'

Line 1376: FROM GL_BIS_SEGVAL_INT

1372: IF (seg27_flag) THEN
1373: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1374: count(*)
1375: into total_count
1376: FROM GL_BIS_SEGVAL_INT
1377: WHERE segment_column_name = 'SEGMENT27'
1378: AND segment_value = segment27;
1379:
1380: IF (total_count = 0) THEN

Line 1386: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1382: END IF;
1383: END IF;
1384:
1385: IF (seg28_flag) THEN
1386: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1387: count(*)
1388: into total_count
1389: FROM GL_BIS_SEGVAL_INT
1390: WHERE segment_column_name = 'SEGMENT28'

Line 1389: FROM GL_BIS_SEGVAL_INT

1385: IF (seg28_flag) THEN
1386: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1387: count(*)
1388: into total_count
1389: FROM GL_BIS_SEGVAL_INT
1390: WHERE segment_column_name = 'SEGMENT28'
1391: AND segment_value = segment28;
1392:
1393: IF (total_count = 0) THEN

Line 1399: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1395: END IF;
1396: END IF;
1397:
1398: IF (seg29_flag) THEN
1399: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1400: count(*)
1401: into total_count
1402: FROM GL_BIS_SEGVAL_INT
1403: WHERE segment_column_name = 'SEGMENT29'

Line 1402: FROM GL_BIS_SEGVAL_INT

1398: IF (seg29_flag) THEN
1399: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1400: count(*)
1401: into total_count
1402: FROM GL_BIS_SEGVAL_INT
1403: WHERE segment_column_name = 'SEGMENT29'
1404: AND segment_value = segment29;
1405:
1406: IF (total_count = 0) THEN

Line 1412: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1408: END IF;
1409: END IF;
1410:
1411: IF (seg30_flag) THEN
1412: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1413: count(*)
1414: into total_count
1415: FROM GL_BIS_SEGVAL_INT
1416: WHERE segment_column_name = 'SEGMENT30'

Line 1415: FROM GL_BIS_SEGVAL_INT

1411: IF (seg30_flag) THEN
1412: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1413: count(*)
1414: into total_count
1415: FROM GL_BIS_SEGVAL_INT
1416: WHERE segment_column_name = 'SEGMENT30'
1417: AND segment_value = segment30;
1418:
1419: IF (total_count = 0) THEN

Line 1482: -- according to the rules stored in GL_BIS_SEGVAL_INT temporary

1478: -- Function
1479: -- Validate_segval
1480: -- Purpose
1481: -- Validate the given segment number and segment value
1482: -- according to the rules stored in GL_BIS_SEGVAL_INT temporary
1483: -- table by gl_security_pkg.init
1484: --
1485: FUNCTION validate_segval(segnum1 IN NUMBER DEFAULT NULL,
1486: segnum2 IN NUMBER DEFAULT NULL,

Line 1507: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1503: IF (seg_col_name(segnum1) IS NOT NULL) THEN
1504:
1505: seg1_name := seg_col_name(segnum1);
1506:
1507: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1508: count(*)
1509: into count1
1510: FROM GL_BIS_SEGVAL_INT
1511: WHERE segment_column_name = seg1_name

Line 1510: FROM GL_BIS_SEGVAL_INT

1506:
1507: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1508: count(*)
1509: into count1
1510: FROM GL_BIS_SEGVAL_INT
1511: WHERE segment_column_name = seg1_name
1512: AND segment_value = segval1;
1513:
1514: IF (count1 = 0) THEN

Line 1549: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */

1545: IF (seg_col_name(segnum2) IS NOT NULL) THEN
1546:
1547: seg2_name := seg_col_name(segnum2);
1548:
1549: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1550: count(*)
1551: into count1
1552: FROM GL_BIS_SEGVAL_INT
1553: WHERE segment_column_name = seg2_name

Line 1552: FROM GL_BIS_SEGVAL_INT

1548:
1549: SELECT /*+ index(gl_bis_segval_int gl_bis_segval_int_n1 ) */
1550: count(*)
1551: into count1
1552: FROM GL_BIS_SEGVAL_INT
1553: WHERE segment_column_name = seg2_name
1554: AND segment_value = segval2;
1555:
1556: IF (count1 = 0) THEN