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.PN_REC_EXP_EXTR_FROM_GL_PKG dependencies on DBMS_SQL

Line 181: l_cursor := dbms_sql.open_cursor;

177: l_info := 'processing Map Row: '||to_char(i)
178: ||'; Creating dynamic Where Clause';
179:
180: l_Where_Clause := null;
181: l_cursor := dbms_sql.open_cursor;
182:
183: /* segment 1 */
184: IF p_map_t(i).segment1_low IS NOT NULL
185: and p_map_t(i).segment1_high IS NULL THEN

Line 957: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);

953:
954:
955:
956: put_log('l_statement='||l_statement);
957: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
958: dbms_sql.bind_variable(l_cursor,'l_sob_id',l_sob_id);
959: dbms_sql.bind_variable(l_cursor,'x_summary_flag',x_summary_flag);
960:
961: /* segment 1 */

Line 958: dbms_sql.bind_variable(l_cursor,'l_sob_id',l_sob_id);

954:
955:
956: put_log('l_statement='||l_statement);
957: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
958: dbms_sql.bind_variable(l_cursor,'l_sob_id',l_sob_id);
959: dbms_sql.bind_variable(l_cursor,'x_summary_flag',x_summary_flag);
960:
961: /* segment 1 */
962: IF p_map_t(i).segment1_low IS NOT NULL

Line 959: dbms_sql.bind_variable(l_cursor,'x_summary_flag',x_summary_flag);

955:
956: put_log('l_statement='||l_statement);
957: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
958: dbms_sql.bind_variable(l_cursor,'l_sob_id',l_sob_id);
959: dbms_sql.bind_variable(l_cursor,'x_summary_flag',x_summary_flag);
960:
961: /* segment 1 */
962: IF p_map_t(i).segment1_low IS NOT NULL
963: and p_map_t(i).segment1_high IS NULL THEN

Line 964: dbms_sql.bind_variable(l_cursor,'l_segment1_low',l_segment1_low);

960:
961: /* segment 1 */
962: IF p_map_t(i).segment1_low IS NOT NULL
963: and p_map_t(i).segment1_high IS NULL THEN
964: dbms_sql.bind_variable(l_cursor,'l_segment1_low',l_segment1_low);
965:
966: ELSIF p_map_t(i).segment1_low IS NULL
967: and p_map_t(i).segment1_high IS NOT NULL THEN
968: dbms_sql.bind_variable(l_cursor,'l_segment1_high',l_segment1_high);

Line 968: dbms_sql.bind_variable(l_cursor,'l_segment1_high',l_segment1_high);

964: dbms_sql.bind_variable(l_cursor,'l_segment1_low',l_segment1_low);
965:
966: ELSIF p_map_t(i).segment1_low IS NULL
967: and p_map_t(i).segment1_high IS NOT NULL THEN
968: dbms_sql.bind_variable(l_cursor,'l_segment1_high',l_segment1_high);
969:
970: ELSIF p_map_t(i).segment1_low IS NOT NULL
971: and p_map_t(i).segment1_high IS NOT NULL THEN
972: dbms_sql.bind_variable(l_cursor,'l_segment1_low',l_segment1_low);

Line 972: dbms_sql.bind_variable(l_cursor,'l_segment1_low',l_segment1_low);

968: dbms_sql.bind_variable(l_cursor,'l_segment1_high',l_segment1_high);
969:
970: ELSIF p_map_t(i).segment1_low IS NOT NULL
971: and p_map_t(i).segment1_high IS NOT NULL THEN
972: dbms_sql.bind_variable(l_cursor,'l_segment1_low',l_segment1_low);
973: dbms_sql.bind_variable(l_cursor,'l_segment1_high',l_segment1_high);
974: END IF;
975:
976: /* segment 2 */

Line 973: dbms_sql.bind_variable(l_cursor,'l_segment1_high',l_segment1_high);

969:
970: ELSIF p_map_t(i).segment1_low IS NOT NULL
971: and p_map_t(i).segment1_high IS NOT NULL THEN
972: dbms_sql.bind_variable(l_cursor,'l_segment1_low',l_segment1_low);
973: dbms_sql.bind_variable(l_cursor,'l_segment1_high',l_segment1_high);
974: END IF;
975:
976: /* segment 2 */
977: IF p_map_t(i).segment2_low IS NOT NULL

Line 979: dbms_sql.bind_variable(l_cursor,'l_segment2_low',l_segment2_low);

975:
976: /* segment 2 */
977: IF p_map_t(i).segment2_low IS NOT NULL
978: and p_map_t(i).segment2_high IS NULL THEN
979: dbms_sql.bind_variable(l_cursor,'l_segment2_low',l_segment2_low);
980:
981: ELSIF p_map_t(i).segment2_low IS NULL
982: and p_map_t(i).segment2_high IS NOT NULL THEN
983: dbms_sql.bind_variable(l_cursor,'l_segment2_high',l_segment2_high);

Line 983: dbms_sql.bind_variable(l_cursor,'l_segment2_high',l_segment2_high);

979: dbms_sql.bind_variable(l_cursor,'l_segment2_low',l_segment2_low);
980:
981: ELSIF p_map_t(i).segment2_low IS NULL
982: and p_map_t(i).segment2_high IS NOT NULL THEN
983: dbms_sql.bind_variable(l_cursor,'l_segment2_high',l_segment2_high);
984:
985: ELSIF p_map_t(i).segment2_low IS NOT NULL
986: and p_map_t(i).segment2_high IS NOT NULL THEN
987: dbms_sql.bind_variable(l_cursor,'l_segment2_low',l_segment2_low);

Line 987: dbms_sql.bind_variable(l_cursor,'l_segment2_low',l_segment2_low);

983: dbms_sql.bind_variable(l_cursor,'l_segment2_high',l_segment2_high);
984:
985: ELSIF p_map_t(i).segment2_low IS NOT NULL
986: and p_map_t(i).segment2_high IS NOT NULL THEN
987: dbms_sql.bind_variable(l_cursor,'l_segment2_low',l_segment2_low);
988: dbms_sql.bind_variable(l_cursor,'l_segment2_high',l_segment2_high);
989: END IF;
990:
991: /* segment 3 */

Line 988: dbms_sql.bind_variable(l_cursor,'l_segment2_high',l_segment2_high);

984:
985: ELSIF p_map_t(i).segment2_low IS NOT NULL
986: and p_map_t(i).segment2_high IS NOT NULL THEN
987: dbms_sql.bind_variable(l_cursor,'l_segment2_low',l_segment2_low);
988: dbms_sql.bind_variable(l_cursor,'l_segment2_high',l_segment2_high);
989: END IF;
990:
991: /* segment 3 */
992: IF p_map_t(i).segment3_low IS NOT NULL

Line 994: dbms_sql.bind_variable(l_cursor,'l_segment3_low',l_segment3_low);

990:
991: /* segment 3 */
992: IF p_map_t(i).segment3_low IS NOT NULL
993: and p_map_t(i).segment3_high IS NULL THEN
994: dbms_sql.bind_variable(l_cursor,'l_segment3_low',l_segment3_low);
995:
996: ELSIF p_map_t(i).segment3_low IS NULL
997: and p_map_t(i).segment3_high IS NOT NULL THEN
998: dbms_sql.bind_variable(l_cursor,'l_segment3_high',l_segment3_high);

Line 998: dbms_sql.bind_variable(l_cursor,'l_segment3_high',l_segment3_high);

994: dbms_sql.bind_variable(l_cursor,'l_segment3_low',l_segment3_low);
995:
996: ELSIF p_map_t(i).segment3_low IS NULL
997: and p_map_t(i).segment3_high IS NOT NULL THEN
998: dbms_sql.bind_variable(l_cursor,'l_segment3_high',l_segment3_high);
999:
1000: ELSIF p_map_t(i).segment3_low IS NOT NULL
1001: and p_map_t(i).segment3_high IS NOT NULL THEN
1002: dbms_sql.bind_variable(l_cursor,'l_segment3_low',l_segment3_low);

Line 1002: dbms_sql.bind_variable(l_cursor,'l_segment3_low',l_segment3_low);

998: dbms_sql.bind_variable(l_cursor,'l_segment3_high',l_segment3_high);
999:
1000: ELSIF p_map_t(i).segment3_low IS NOT NULL
1001: and p_map_t(i).segment3_high IS NOT NULL THEN
1002: dbms_sql.bind_variable(l_cursor,'l_segment3_low',l_segment3_low);
1003: dbms_sql.bind_variable(l_cursor,'l_segment3_high',l_segment3_high);
1004: END IF;
1005:
1006: /* segment 4 */

Line 1003: dbms_sql.bind_variable(l_cursor,'l_segment3_high',l_segment3_high);

999:
1000: ELSIF p_map_t(i).segment3_low IS NOT NULL
1001: and p_map_t(i).segment3_high IS NOT NULL THEN
1002: dbms_sql.bind_variable(l_cursor,'l_segment3_low',l_segment3_low);
1003: dbms_sql.bind_variable(l_cursor,'l_segment3_high',l_segment3_high);
1004: END IF;
1005:
1006: /* segment 4 */
1007: IF p_map_t(i).segment4_low IS NOT NULL

Line 1009: dbms_sql.bind_variable(l_cursor,'l_segment4_low',l_segment4_low);

1005:
1006: /* segment 4 */
1007: IF p_map_t(i).segment4_low IS NOT NULL
1008: and p_map_t(i).segment4_high IS NULL THEN
1009: dbms_sql.bind_variable(l_cursor,'l_segment4_low',l_segment4_low);
1010:
1011: ELSIF p_map_t(i).segment4_low IS NULL
1012: and p_map_t(i).segment4_high IS NOT NULL THEN
1013: dbms_sql.bind_variable(l_cursor,'l_segment4_high',l_segment4_high);

Line 1013: dbms_sql.bind_variable(l_cursor,'l_segment4_high',l_segment4_high);

1009: dbms_sql.bind_variable(l_cursor,'l_segment4_low',l_segment4_low);
1010:
1011: ELSIF p_map_t(i).segment4_low IS NULL
1012: and p_map_t(i).segment4_high IS NOT NULL THEN
1013: dbms_sql.bind_variable(l_cursor,'l_segment4_high',l_segment4_high);
1014:
1015: ELSIF p_map_t(i).segment4_low IS NOT NULL
1016: and p_map_t(i).segment4_high IS NOT NULL THEN
1017: dbms_sql.bind_variable(l_cursor,'l_segment4_low',l_segment4_low);

Line 1017: dbms_sql.bind_variable(l_cursor,'l_segment4_low',l_segment4_low);

1013: dbms_sql.bind_variable(l_cursor,'l_segment4_high',l_segment4_high);
1014:
1015: ELSIF p_map_t(i).segment4_low IS NOT NULL
1016: and p_map_t(i).segment4_high IS NOT NULL THEN
1017: dbms_sql.bind_variable(l_cursor,'l_segment4_low',l_segment4_low);
1018: dbms_sql.bind_variable(l_cursor,'l_segment4_high',l_segment4_high);
1019: END IF;
1020:
1021: /* segment 5 */

Line 1018: dbms_sql.bind_variable(l_cursor,'l_segment4_high',l_segment4_high);

1014:
1015: ELSIF p_map_t(i).segment4_low IS NOT NULL
1016: and p_map_t(i).segment4_high IS NOT NULL THEN
1017: dbms_sql.bind_variable(l_cursor,'l_segment4_low',l_segment4_low);
1018: dbms_sql.bind_variable(l_cursor,'l_segment4_high',l_segment4_high);
1019: END IF;
1020:
1021: /* segment 5 */
1022: IF p_map_t(i).segment5_low IS NOT NULL

Line 1024: dbms_sql.bind_variable(l_cursor,'l_segment5_low',l_segment5_low);

1020:
1021: /* segment 5 */
1022: IF p_map_t(i).segment5_low IS NOT NULL
1023: and p_map_t(i).segment5_high IS NULL THEN
1024: dbms_sql.bind_variable(l_cursor,'l_segment5_low',l_segment5_low);
1025:
1026: ELSIF p_map_t(i).segment5_low IS NULL
1027: and p_map_t(i).segment5_high IS NOT NULL THEN
1028: dbms_sql.bind_variable(l_cursor,'l_segment5_high',l_segment5_high);

Line 1028: dbms_sql.bind_variable(l_cursor,'l_segment5_high',l_segment5_high);

1024: dbms_sql.bind_variable(l_cursor,'l_segment5_low',l_segment5_low);
1025:
1026: ELSIF p_map_t(i).segment5_low IS NULL
1027: and p_map_t(i).segment5_high IS NOT NULL THEN
1028: dbms_sql.bind_variable(l_cursor,'l_segment5_high',l_segment5_high);
1029:
1030: ELSIF p_map_t(i).segment5_low IS NOT NULL
1031: and p_map_t(i).segment5_high IS NOT NULL THEN
1032: dbms_sql.bind_variable(l_cursor,'l_segment5_low',l_segment5_low);

Line 1032: dbms_sql.bind_variable(l_cursor,'l_segment5_low',l_segment5_low);

1028: dbms_sql.bind_variable(l_cursor,'l_segment5_high',l_segment5_high);
1029:
1030: ELSIF p_map_t(i).segment5_low IS NOT NULL
1031: and p_map_t(i).segment5_high IS NOT NULL THEN
1032: dbms_sql.bind_variable(l_cursor,'l_segment5_low',l_segment5_low);
1033: dbms_sql.bind_variable(l_cursor,'l_segment5_high',l_segment5_high);
1034: END IF;
1035:
1036: /* segment 6 */

Line 1033: dbms_sql.bind_variable(l_cursor,'l_segment5_high',l_segment5_high);

1029:
1030: ELSIF p_map_t(i).segment5_low IS NOT NULL
1031: and p_map_t(i).segment5_high IS NOT NULL THEN
1032: dbms_sql.bind_variable(l_cursor,'l_segment5_low',l_segment5_low);
1033: dbms_sql.bind_variable(l_cursor,'l_segment5_high',l_segment5_high);
1034: END IF;
1035:
1036: /* segment 6 */
1037: IF p_map_t(i).segment6_low IS NOT NULL

Line 1039: dbms_sql.bind_variable(l_cursor,'l_segment6_low',l_segment6_low);

1035:
1036: /* segment 6 */
1037: IF p_map_t(i).segment6_low IS NOT NULL
1038: and p_map_t(i).segment6_high IS NULL THEN
1039: dbms_sql.bind_variable(l_cursor,'l_segment6_low',l_segment6_low);
1040:
1041: ELSIF p_map_t(i).segment6_low IS NULL
1042: and p_map_t(i).segment6_high IS NOT NULL THEN
1043: dbms_sql.bind_variable(l_cursor,'l_segment6_high',l_segment6_high);

Line 1043: dbms_sql.bind_variable(l_cursor,'l_segment6_high',l_segment6_high);

1039: dbms_sql.bind_variable(l_cursor,'l_segment6_low',l_segment6_low);
1040:
1041: ELSIF p_map_t(i).segment6_low IS NULL
1042: and p_map_t(i).segment6_high IS NOT NULL THEN
1043: dbms_sql.bind_variable(l_cursor,'l_segment6_high',l_segment6_high);
1044:
1045: ELSIF p_map_t(i).segment6_low IS NOT NULL
1046: and p_map_t(i).segment6_high IS NOT NULL THEN
1047: dbms_sql.bind_variable(l_cursor,'l_segment6_low',l_segment6_low);

Line 1047: dbms_sql.bind_variable(l_cursor,'l_segment6_low',l_segment6_low);

1043: dbms_sql.bind_variable(l_cursor,'l_segment6_high',l_segment6_high);
1044:
1045: ELSIF p_map_t(i).segment6_low IS NOT NULL
1046: and p_map_t(i).segment6_high IS NOT NULL THEN
1047: dbms_sql.bind_variable(l_cursor,'l_segment6_low',l_segment6_low);
1048: dbms_sql.bind_variable(l_cursor,'l_segment6_high',l_segment6_high);
1049: END IF;
1050:
1051: /* segment 7 */

Line 1048: dbms_sql.bind_variable(l_cursor,'l_segment6_high',l_segment6_high);

1044:
1045: ELSIF p_map_t(i).segment6_low IS NOT NULL
1046: and p_map_t(i).segment6_high IS NOT NULL THEN
1047: dbms_sql.bind_variable(l_cursor,'l_segment6_low',l_segment6_low);
1048: dbms_sql.bind_variable(l_cursor,'l_segment6_high',l_segment6_high);
1049: END IF;
1050:
1051: /* segment 7 */
1052: IF p_map_t(i).segment7_low IS NOT NULL

Line 1054: dbms_sql.bind_variable(l_cursor,'l_segment7_low',l_segment7_low);

1050:
1051: /* segment 7 */
1052: IF p_map_t(i).segment7_low IS NOT NULL
1053: and p_map_t(i).segment7_high IS NULL THEN
1054: dbms_sql.bind_variable(l_cursor,'l_segment7_low',l_segment7_low);
1055:
1056: ELSIF p_map_t(i).segment7_low IS NULL
1057: and p_map_t(i).segment7_high IS NOT NULL THEN
1058: dbms_sql.bind_variable(l_cursor,'l_segment7_high',l_segment7_high);

Line 1058: dbms_sql.bind_variable(l_cursor,'l_segment7_high',l_segment7_high);

1054: dbms_sql.bind_variable(l_cursor,'l_segment7_low',l_segment7_low);
1055:
1056: ELSIF p_map_t(i).segment7_low IS NULL
1057: and p_map_t(i).segment7_high IS NOT NULL THEN
1058: dbms_sql.bind_variable(l_cursor,'l_segment7_high',l_segment7_high);
1059:
1060: ELSIF p_map_t(i).segment7_low IS NOT NULL
1061: and p_map_t(i).segment7_high IS NOT NULL THEN
1062: dbms_sql.bind_variable(l_cursor,'l_segment7_low',l_segment7_low);

Line 1062: dbms_sql.bind_variable(l_cursor,'l_segment7_low',l_segment7_low);

1058: dbms_sql.bind_variable(l_cursor,'l_segment7_high',l_segment7_high);
1059:
1060: ELSIF p_map_t(i).segment7_low IS NOT NULL
1061: and p_map_t(i).segment7_high IS NOT NULL THEN
1062: dbms_sql.bind_variable(l_cursor,'l_segment7_low',l_segment7_low);
1063: dbms_sql.bind_variable(l_cursor,'l_segment7_high',l_segment7_high);
1064: END IF;
1065:
1066: /* segment 8 */

Line 1063: dbms_sql.bind_variable(l_cursor,'l_segment7_high',l_segment7_high);

1059:
1060: ELSIF p_map_t(i).segment7_low IS NOT NULL
1061: and p_map_t(i).segment7_high IS NOT NULL THEN
1062: dbms_sql.bind_variable(l_cursor,'l_segment7_low',l_segment7_low);
1063: dbms_sql.bind_variable(l_cursor,'l_segment7_high',l_segment7_high);
1064: END IF;
1065:
1066: /* segment 8 */
1067: IF p_map_t(i).segment8_low IS NOT NULL

Line 1069: dbms_sql.bind_variable(l_cursor,'l_segment8_low',l_segment8_low);

1065:
1066: /* segment 8 */
1067: IF p_map_t(i).segment8_low IS NOT NULL
1068: and p_map_t(i).segment8_high IS NULL THEN
1069: dbms_sql.bind_variable(l_cursor,'l_segment8_low',l_segment8_low);
1070:
1071: ELSIF p_map_t(i).segment8_low IS NULL
1072: and p_map_t(i).segment8_high IS NOT NULL THEN
1073: dbms_sql.bind_variable(l_cursor,'l_segment8_high',l_segment8_high);

Line 1073: dbms_sql.bind_variable(l_cursor,'l_segment8_high',l_segment8_high);

1069: dbms_sql.bind_variable(l_cursor,'l_segment8_low',l_segment8_low);
1070:
1071: ELSIF p_map_t(i).segment8_low IS NULL
1072: and p_map_t(i).segment8_high IS NOT NULL THEN
1073: dbms_sql.bind_variable(l_cursor,'l_segment8_high',l_segment8_high);
1074:
1075: ELSIF p_map_t(i).segment8_low IS NOT NULL
1076: and p_map_t(i).segment8_high IS NOT NULL THEN
1077: dbms_sql.bind_variable(l_cursor,'l_segment8_low',l_segment8_low);

Line 1077: dbms_sql.bind_variable(l_cursor,'l_segment8_low',l_segment8_low);

1073: dbms_sql.bind_variable(l_cursor,'l_segment8_high',l_segment8_high);
1074:
1075: ELSIF p_map_t(i).segment8_low IS NOT NULL
1076: and p_map_t(i).segment8_high IS NOT NULL THEN
1077: dbms_sql.bind_variable(l_cursor,'l_segment8_low',l_segment8_low);
1078: dbms_sql.bind_variable(l_cursor,'l_segment8_high',l_segment8_high);
1079: END IF;
1080:
1081: /* segment 9 */

Line 1078: dbms_sql.bind_variable(l_cursor,'l_segment8_high',l_segment8_high);

1074:
1075: ELSIF p_map_t(i).segment8_low IS NOT NULL
1076: and p_map_t(i).segment8_high IS NOT NULL THEN
1077: dbms_sql.bind_variable(l_cursor,'l_segment8_low',l_segment8_low);
1078: dbms_sql.bind_variable(l_cursor,'l_segment8_high',l_segment8_high);
1079: END IF;
1080:
1081: /* segment 9 */
1082: IF p_map_t(i).segment9_low IS NOT NULL

Line 1084: dbms_sql.bind_variable(l_cursor,'l_segment9_low',l_segment9_low);

1080:
1081: /* segment 9 */
1082: IF p_map_t(i).segment9_low IS NOT NULL
1083: and p_map_t(i).segment9_high IS NULL THEN
1084: dbms_sql.bind_variable(l_cursor,'l_segment9_low',l_segment9_low);
1085:
1086: ELSIF p_map_t(i).segment9_low IS NULL
1087: and p_map_t(i).segment9_high IS NOT NULL THEN
1088: dbms_sql.bind_variable(l_cursor,'l_segment9_high',l_segment9_high);

Line 1088: dbms_sql.bind_variable(l_cursor,'l_segment9_high',l_segment9_high);

1084: dbms_sql.bind_variable(l_cursor,'l_segment9_low',l_segment9_low);
1085:
1086: ELSIF p_map_t(i).segment9_low IS NULL
1087: and p_map_t(i).segment9_high IS NOT NULL THEN
1088: dbms_sql.bind_variable(l_cursor,'l_segment9_high',l_segment9_high);
1089:
1090: ELSIF p_map_t(i).segment9_low IS NOT NULL
1091: and p_map_t(i).segment9_high IS NOT NULL THEN
1092: dbms_sql.bind_variable(l_cursor,'l_segment9_low',l_segment9_low);

Line 1092: dbms_sql.bind_variable(l_cursor,'l_segment9_low',l_segment9_low);

1088: dbms_sql.bind_variable(l_cursor,'l_segment9_high',l_segment9_high);
1089:
1090: ELSIF p_map_t(i).segment9_low IS NOT NULL
1091: and p_map_t(i).segment9_high IS NOT NULL THEN
1092: dbms_sql.bind_variable(l_cursor,'l_segment9_low',l_segment9_low);
1093: dbms_sql.bind_variable(l_cursor,'l_segment9_high',l_segment9_high);
1094: END IF;
1095:
1096: /* segment 10 */

Line 1093: dbms_sql.bind_variable(l_cursor,'l_segment9_high',l_segment9_high);

1089:
1090: ELSIF p_map_t(i).segment9_low IS NOT NULL
1091: and p_map_t(i).segment9_high IS NOT NULL THEN
1092: dbms_sql.bind_variable(l_cursor,'l_segment9_low',l_segment9_low);
1093: dbms_sql.bind_variable(l_cursor,'l_segment9_high',l_segment9_high);
1094: END IF;
1095:
1096: /* segment 10 */
1097: IF p_map_t(i).segment10_low IS NOT NULL

Line 1099: dbms_sql.bind_variable(l_cursor,'l_segment10_low',l_segment10_low);

1095:
1096: /* segment 10 */
1097: IF p_map_t(i).segment10_low IS NOT NULL
1098: and p_map_t(i).segment10_high IS NULL THEN
1099: dbms_sql.bind_variable(l_cursor,'l_segment10_low',l_segment10_low);
1100:
1101: ELSIF p_map_t(i).segment10_low IS NULL
1102: and p_map_t(i).segment10_high IS NOT NULL THEN
1103: dbms_sql.bind_variable(l_cursor,'l_segment10_high',l_segment10_high);

Line 1103: dbms_sql.bind_variable(l_cursor,'l_segment10_high',l_segment10_high);

1099: dbms_sql.bind_variable(l_cursor,'l_segment10_low',l_segment10_low);
1100:
1101: ELSIF p_map_t(i).segment10_low IS NULL
1102: and p_map_t(i).segment10_high IS NOT NULL THEN
1103: dbms_sql.bind_variable(l_cursor,'l_segment10_high',l_segment10_high);
1104:
1105: ELSIF p_map_t(i).segment10_low IS NOT NULL
1106: and p_map_t(i).segment10_high IS NOT NULL THEN
1107: dbms_sql.bind_variable(l_cursor,'l_segment10_low',l_segment10_low);

Line 1107: dbms_sql.bind_variable(l_cursor,'l_segment10_low',l_segment10_low);

1103: dbms_sql.bind_variable(l_cursor,'l_segment10_high',l_segment10_high);
1104:
1105: ELSIF p_map_t(i).segment10_low IS NOT NULL
1106: and p_map_t(i).segment10_high IS NOT NULL THEN
1107: dbms_sql.bind_variable(l_cursor,'l_segment10_low',l_segment10_low);
1108: dbms_sql.bind_variable(l_cursor,'l_segment10_high',l_segment10_high);
1109: END IF;
1110:
1111: /* segment 11 */

Line 1108: dbms_sql.bind_variable(l_cursor,'l_segment10_high',l_segment10_high);

1104:
1105: ELSIF p_map_t(i).segment10_low IS NOT NULL
1106: and p_map_t(i).segment10_high IS NOT NULL THEN
1107: dbms_sql.bind_variable(l_cursor,'l_segment10_low',l_segment10_low);
1108: dbms_sql.bind_variable(l_cursor,'l_segment10_high',l_segment10_high);
1109: END IF;
1110:
1111: /* segment 11 */
1112: IF p_map_t(i).segment11_low IS NOT NULL

Line 1114: dbms_sql.bind_variable(l_cursor,'l_segment11_low',l_segment11_low);

1110:
1111: /* segment 11 */
1112: IF p_map_t(i).segment11_low IS NOT NULL
1113: and p_map_t(i).segment11_high IS NULL THEN
1114: dbms_sql.bind_variable(l_cursor,'l_segment11_low',l_segment11_low);
1115:
1116: ELSIF p_map_t(i).segment11_low IS NULL
1117: and p_map_t(i).segment11_high IS NOT NULL THEN
1118: dbms_sql.bind_variable(l_cursor,'l_segment11_high',l_segment11_high);

Line 1118: dbms_sql.bind_variable(l_cursor,'l_segment11_high',l_segment11_high);

1114: dbms_sql.bind_variable(l_cursor,'l_segment11_low',l_segment11_low);
1115:
1116: ELSIF p_map_t(i).segment11_low IS NULL
1117: and p_map_t(i).segment11_high IS NOT NULL THEN
1118: dbms_sql.bind_variable(l_cursor,'l_segment11_high',l_segment11_high);
1119:
1120: ELSIF p_map_t(i).segment11_low IS NOT NULL
1121: and p_map_t(i).segment11_high IS NOT NULL THEN
1122: dbms_sql.bind_variable(l_cursor,'l_segment11_low',l_segment11_low);

Line 1122: dbms_sql.bind_variable(l_cursor,'l_segment11_low',l_segment11_low);

1118: dbms_sql.bind_variable(l_cursor,'l_segment11_high',l_segment11_high);
1119:
1120: ELSIF p_map_t(i).segment11_low IS NOT NULL
1121: and p_map_t(i).segment11_high IS NOT NULL THEN
1122: dbms_sql.bind_variable(l_cursor,'l_segment11_low',l_segment11_low);
1123: dbms_sql.bind_variable(l_cursor,'l_segment11_high',l_segment11_high);
1124: END IF;
1125:
1126: /* segment 12 */

Line 1123: dbms_sql.bind_variable(l_cursor,'l_segment11_high',l_segment11_high);

1119:
1120: ELSIF p_map_t(i).segment11_low IS NOT NULL
1121: and p_map_t(i).segment11_high IS NOT NULL THEN
1122: dbms_sql.bind_variable(l_cursor,'l_segment11_low',l_segment11_low);
1123: dbms_sql.bind_variable(l_cursor,'l_segment11_high',l_segment11_high);
1124: END IF;
1125:
1126: /* segment 12 */
1127: IF p_map_t(i).segment12_low IS NOT NULL

Line 1129: dbms_sql.bind_variable(l_cursor,'l_segment12_low',l_segment12_low);

1125:
1126: /* segment 12 */
1127: IF p_map_t(i).segment12_low IS NOT NULL
1128: and p_map_t(i).segment12_high IS NULL THEN
1129: dbms_sql.bind_variable(l_cursor,'l_segment12_low',l_segment12_low);
1130:
1131: ELSIF p_map_t(i).segment12_low IS NULL
1132: and p_map_t(i).segment12_high IS NOT NULL THEN
1133: dbms_sql.bind_variable(l_cursor,'l_segment12_high',l_segment12_high);

Line 1133: dbms_sql.bind_variable(l_cursor,'l_segment12_high',l_segment12_high);

1129: dbms_sql.bind_variable(l_cursor,'l_segment12_low',l_segment12_low);
1130:
1131: ELSIF p_map_t(i).segment12_low IS NULL
1132: and p_map_t(i).segment12_high IS NOT NULL THEN
1133: dbms_sql.bind_variable(l_cursor,'l_segment12_high',l_segment12_high);
1134:
1135: ELSIF p_map_t(i).segment12_low IS NOT NULL
1136: and p_map_t(i).segment12_high IS NOT NULL THEN
1137: dbms_sql.bind_variable(l_cursor,'l_segment12_low',l_segment12_low);

Line 1137: dbms_sql.bind_variable(l_cursor,'l_segment12_low',l_segment12_low);

1133: dbms_sql.bind_variable(l_cursor,'l_segment12_high',l_segment12_high);
1134:
1135: ELSIF p_map_t(i).segment12_low IS NOT NULL
1136: and p_map_t(i).segment12_high IS NOT NULL THEN
1137: dbms_sql.bind_variable(l_cursor,'l_segment12_low',l_segment12_low);
1138: dbms_sql.bind_variable(l_cursor,'l_segment12_high',l_segment12_high);
1139: END IF;
1140:
1141: /* segment 13 */

Line 1138: dbms_sql.bind_variable(l_cursor,'l_segment12_high',l_segment12_high);

1134:
1135: ELSIF p_map_t(i).segment12_low IS NOT NULL
1136: and p_map_t(i).segment12_high IS NOT NULL THEN
1137: dbms_sql.bind_variable(l_cursor,'l_segment12_low',l_segment12_low);
1138: dbms_sql.bind_variable(l_cursor,'l_segment12_high',l_segment12_high);
1139: END IF;
1140:
1141: /* segment 13 */
1142: IF p_map_t(i).segment13_low IS NOT NULL

Line 1144: dbms_sql.bind_variable(l_cursor,'l_segment13_low',l_segment13_low);

1140:
1141: /* segment 13 */
1142: IF p_map_t(i).segment13_low IS NOT NULL
1143: and p_map_t(i).segment13_high IS NULL THEN
1144: dbms_sql.bind_variable(l_cursor,'l_segment13_low',l_segment13_low);
1145:
1146: ELSIF p_map_t(i).segment13_low IS NULL
1147: and p_map_t(i).segment13_high IS NOT NULL THEN
1148: dbms_sql.bind_variable(l_cursor,'l_segment13_high',l_segment13_high);

Line 1148: dbms_sql.bind_variable(l_cursor,'l_segment13_high',l_segment13_high);

1144: dbms_sql.bind_variable(l_cursor,'l_segment13_low',l_segment13_low);
1145:
1146: ELSIF p_map_t(i).segment13_low IS NULL
1147: and p_map_t(i).segment13_high IS NOT NULL THEN
1148: dbms_sql.bind_variable(l_cursor,'l_segment13_high',l_segment13_high);
1149:
1150: ELSIF p_map_t(i).segment13_low IS NOT NULL
1151: and p_map_t(i).segment13_high IS NOT NULL THEN
1152: dbms_sql.bind_variable(l_cursor,'l_segment13_low',l_segment13_low);

Line 1152: dbms_sql.bind_variable(l_cursor,'l_segment13_low',l_segment13_low);

1148: dbms_sql.bind_variable(l_cursor,'l_segment13_high',l_segment13_high);
1149:
1150: ELSIF p_map_t(i).segment13_low IS NOT NULL
1151: and p_map_t(i).segment13_high IS NOT NULL THEN
1152: dbms_sql.bind_variable(l_cursor,'l_segment13_low',l_segment13_low);
1153: dbms_sql.bind_variable(l_cursor,'l_segment13_high',l_segment13_high);
1154: END IF;
1155:
1156: /* segment 14 */

Line 1153: dbms_sql.bind_variable(l_cursor,'l_segment13_high',l_segment13_high);

1149:
1150: ELSIF p_map_t(i).segment13_low IS NOT NULL
1151: and p_map_t(i).segment13_high IS NOT NULL THEN
1152: dbms_sql.bind_variable(l_cursor,'l_segment13_low',l_segment13_low);
1153: dbms_sql.bind_variable(l_cursor,'l_segment13_high',l_segment13_high);
1154: END IF;
1155:
1156: /* segment 14 */
1157: IF p_map_t(i).segment14_low IS NOT NULL

Line 1159: dbms_sql.bind_variable(l_cursor,'l_segment14_low',l_segment14_low);

1155:
1156: /* segment 14 */
1157: IF p_map_t(i).segment14_low IS NOT NULL
1158: and p_map_t(i).segment14_high IS NULL THEN
1159: dbms_sql.bind_variable(l_cursor,'l_segment14_low',l_segment14_low);
1160:
1161: ELSIF p_map_t(i).segment14_low IS NULL
1162: and p_map_t(i).segment14_high IS NOT NULL THEN
1163: dbms_sql.bind_variable(l_cursor,'l_segment14_high',l_segment14_high);

Line 1163: dbms_sql.bind_variable(l_cursor,'l_segment14_high',l_segment14_high);

1159: dbms_sql.bind_variable(l_cursor,'l_segment14_low',l_segment14_low);
1160:
1161: ELSIF p_map_t(i).segment14_low IS NULL
1162: and p_map_t(i).segment14_high IS NOT NULL THEN
1163: dbms_sql.bind_variable(l_cursor,'l_segment14_high',l_segment14_high);
1164:
1165: ELSIF p_map_t(i).segment14_low IS NOT NULL
1166: and p_map_t(i).segment14_high IS NOT NULL THEN
1167: dbms_sql.bind_variable(l_cursor,'l_segment14_low',l_segment14_low);

Line 1167: dbms_sql.bind_variable(l_cursor,'l_segment14_low',l_segment14_low);

1163: dbms_sql.bind_variable(l_cursor,'l_segment14_high',l_segment14_high);
1164:
1165: ELSIF p_map_t(i).segment14_low IS NOT NULL
1166: and p_map_t(i).segment14_high IS NOT NULL THEN
1167: dbms_sql.bind_variable(l_cursor,'l_segment14_low',l_segment14_low);
1168: dbms_sql.bind_variable(l_cursor,'l_segment14_high',l_segment14_high);
1169: END IF;
1170:
1171: /* segment 15 */

Line 1168: dbms_sql.bind_variable(l_cursor,'l_segment14_high',l_segment14_high);

1164:
1165: ELSIF p_map_t(i).segment14_low IS NOT NULL
1166: and p_map_t(i).segment14_high IS NOT NULL THEN
1167: dbms_sql.bind_variable(l_cursor,'l_segment14_low',l_segment14_low);
1168: dbms_sql.bind_variable(l_cursor,'l_segment14_high',l_segment14_high);
1169: END IF;
1170:
1171: /* segment 15 */
1172: IF p_map_t(i).segment15_low IS NOT NULL

Line 1174: dbms_sql.bind_variable(l_cursor,'l_segment15_low',l_segment15_low);

1170:
1171: /* segment 15 */
1172: IF p_map_t(i).segment15_low IS NOT NULL
1173: and p_map_t(i).segment15_high IS NULL THEN
1174: dbms_sql.bind_variable(l_cursor,'l_segment15_low',l_segment15_low);
1175:
1176: ELSIF p_map_t(i).segment15_low IS NULL
1177: and p_map_t(i).segment15_high IS NOT NULL THEN
1178: dbms_sql.bind_variable(l_cursor,'l_segment15_high',l_segment15_high);

Line 1178: dbms_sql.bind_variable(l_cursor,'l_segment15_high',l_segment15_high);

1174: dbms_sql.bind_variable(l_cursor,'l_segment15_low',l_segment15_low);
1175:
1176: ELSIF p_map_t(i).segment15_low IS NULL
1177: and p_map_t(i).segment15_high IS NOT NULL THEN
1178: dbms_sql.bind_variable(l_cursor,'l_segment15_high',l_segment15_high);
1179:
1180: ELSIF p_map_t(i).segment15_low IS NOT NULL
1181: and p_map_t(i).segment15_high IS NOT NULL THEN
1182: dbms_sql.bind_variable(l_cursor,'l_segment15_low',l_segment15_low);

Line 1182: dbms_sql.bind_variable(l_cursor,'l_segment15_low',l_segment15_low);

1178: dbms_sql.bind_variable(l_cursor,'l_segment15_high',l_segment15_high);
1179:
1180: ELSIF p_map_t(i).segment15_low IS NOT NULL
1181: and p_map_t(i).segment15_high IS NOT NULL THEN
1182: dbms_sql.bind_variable(l_cursor,'l_segment15_low',l_segment15_low);
1183: dbms_sql.bind_variable(l_cursor,'l_segment15_high',l_segment15_high);
1184: END IF;
1185:
1186: /* segment 16 */

Line 1183: dbms_sql.bind_variable(l_cursor,'l_segment15_high',l_segment15_high);

1179:
1180: ELSIF p_map_t(i).segment15_low IS NOT NULL
1181: and p_map_t(i).segment15_high IS NOT NULL THEN
1182: dbms_sql.bind_variable(l_cursor,'l_segment15_low',l_segment15_low);
1183: dbms_sql.bind_variable(l_cursor,'l_segment15_high',l_segment15_high);
1184: END IF;
1185:
1186: /* segment 16 */
1187: IF p_map_t(i).segment16_low IS NOT NULL

Line 1189: dbms_sql.bind_variable(l_cursor,'l_segment16_low',l_segment16_low);

1185:
1186: /* segment 16 */
1187: IF p_map_t(i).segment16_low IS NOT NULL
1188: and p_map_t(i).segment16_high IS NULL THEN
1189: dbms_sql.bind_variable(l_cursor,'l_segment16_low',l_segment16_low);
1190:
1191: ELSIF p_map_t(i).segment16_low IS NULL
1192: and p_map_t(i).segment16_high IS NOT NULL THEN
1193: dbms_sql.bind_variable(l_cursor,'l_segment16_high',l_segment16_high);

Line 1193: dbms_sql.bind_variable(l_cursor,'l_segment16_high',l_segment16_high);

1189: dbms_sql.bind_variable(l_cursor,'l_segment16_low',l_segment16_low);
1190:
1191: ELSIF p_map_t(i).segment16_low IS NULL
1192: and p_map_t(i).segment16_high IS NOT NULL THEN
1193: dbms_sql.bind_variable(l_cursor,'l_segment16_high',l_segment16_high);
1194:
1195: ELSIF p_map_t(i).segment16_low IS NOT NULL
1196: and p_map_t(i).segment16_high IS NOT NULL THEN
1197: dbms_sql.bind_variable(l_cursor,'l_segment16_low',l_segment16_low);

Line 1197: dbms_sql.bind_variable(l_cursor,'l_segment16_low',l_segment16_low);

1193: dbms_sql.bind_variable(l_cursor,'l_segment16_high',l_segment16_high);
1194:
1195: ELSIF p_map_t(i).segment16_low IS NOT NULL
1196: and p_map_t(i).segment16_high IS NOT NULL THEN
1197: dbms_sql.bind_variable(l_cursor,'l_segment16_low',l_segment16_low);
1198: dbms_sql.bind_variable(l_cursor,'l_segment16_high',l_segment16_high);
1199: END IF;
1200:
1201: /* segment 17 */

Line 1198: dbms_sql.bind_variable(l_cursor,'l_segment16_high',l_segment16_high);

1194:
1195: ELSIF p_map_t(i).segment16_low IS NOT NULL
1196: and p_map_t(i).segment16_high IS NOT NULL THEN
1197: dbms_sql.bind_variable(l_cursor,'l_segment16_low',l_segment16_low);
1198: dbms_sql.bind_variable(l_cursor,'l_segment16_high',l_segment16_high);
1199: END IF;
1200:
1201: /* segment 17 */
1202: IF p_map_t(i).segment17_low IS NOT NULL

Line 1204: dbms_sql.bind_variable(l_cursor,'l_segment17_low',l_segment17_low);

1200:
1201: /* segment 17 */
1202: IF p_map_t(i).segment17_low IS NOT NULL
1203: and p_map_t(i).segment17_high IS NULL THEN
1204: dbms_sql.bind_variable(l_cursor,'l_segment17_low',l_segment17_low);
1205:
1206: ELSIF p_map_t(i).segment17_low IS NULL
1207: and p_map_t(i).segment17_high IS NOT NULL THEN
1208: dbms_sql.bind_variable(l_cursor,'l_segment17_high',l_segment17_high);

Line 1208: dbms_sql.bind_variable(l_cursor,'l_segment17_high',l_segment17_high);

1204: dbms_sql.bind_variable(l_cursor,'l_segment17_low',l_segment17_low);
1205:
1206: ELSIF p_map_t(i).segment17_low IS NULL
1207: and p_map_t(i).segment17_high IS NOT NULL THEN
1208: dbms_sql.bind_variable(l_cursor,'l_segment17_high',l_segment17_high);
1209:
1210: ELSIF p_map_t(i).segment17_low IS NOT NULL
1211: and p_map_t(i).segment17_high IS NOT NULL THEN
1212: dbms_sql.bind_variable(l_cursor,'l_segment17_low',l_segment17_low);

Line 1212: dbms_sql.bind_variable(l_cursor,'l_segment17_low',l_segment17_low);

1208: dbms_sql.bind_variable(l_cursor,'l_segment17_high',l_segment17_high);
1209:
1210: ELSIF p_map_t(i).segment17_low IS NOT NULL
1211: and p_map_t(i).segment17_high IS NOT NULL THEN
1212: dbms_sql.bind_variable(l_cursor,'l_segment17_low',l_segment17_low);
1213: dbms_sql.bind_variable(l_cursor,'l_segment17_high',l_segment17_high);
1214: END IF;
1215:
1216: /* segment 18 */

Line 1213: dbms_sql.bind_variable(l_cursor,'l_segment17_high',l_segment17_high);

1209:
1210: ELSIF p_map_t(i).segment17_low IS NOT NULL
1211: and p_map_t(i).segment17_high IS NOT NULL THEN
1212: dbms_sql.bind_variable(l_cursor,'l_segment17_low',l_segment17_low);
1213: dbms_sql.bind_variable(l_cursor,'l_segment17_high',l_segment17_high);
1214: END IF;
1215:
1216: /* segment 18 */
1217: IF p_map_t(i).segment18_low IS NOT NULL

Line 1219: dbms_sql.bind_variable(l_cursor,'l_segment18_low',l_segment18_low);

1215:
1216: /* segment 18 */
1217: IF p_map_t(i).segment18_low IS NOT NULL
1218: and p_map_t(i).segment18_high IS NULL THEN
1219: dbms_sql.bind_variable(l_cursor,'l_segment18_low',l_segment18_low);
1220:
1221: ELSIF p_map_t(i).segment18_low IS NULL
1222: and p_map_t(i).segment18_high IS NOT NULL THEN
1223: dbms_sql.bind_variable(l_cursor,'l_segment18_high',l_segment18_high);

Line 1223: dbms_sql.bind_variable(l_cursor,'l_segment18_high',l_segment18_high);

1219: dbms_sql.bind_variable(l_cursor,'l_segment18_low',l_segment18_low);
1220:
1221: ELSIF p_map_t(i).segment18_low IS NULL
1222: and p_map_t(i).segment18_high IS NOT NULL THEN
1223: dbms_sql.bind_variable(l_cursor,'l_segment18_high',l_segment18_high);
1224:
1225: ELSIF p_map_t(i).segment18_low IS NOT NULL
1226: and p_map_t(i).segment18_high IS NOT NULL THEN
1227: dbms_sql.bind_variable(l_cursor,'l_segment18_low',l_segment18_low);

Line 1227: dbms_sql.bind_variable(l_cursor,'l_segment18_low',l_segment18_low);

1223: dbms_sql.bind_variable(l_cursor,'l_segment18_high',l_segment18_high);
1224:
1225: ELSIF p_map_t(i).segment18_low IS NOT NULL
1226: and p_map_t(i).segment18_high IS NOT NULL THEN
1227: dbms_sql.bind_variable(l_cursor,'l_segment18_low',l_segment18_low);
1228: dbms_sql.bind_variable(l_cursor,'l_segment18_high',l_segment18_high);
1229: END IF;
1230:
1231: /* segment 19 */

Line 1228: dbms_sql.bind_variable(l_cursor,'l_segment18_high',l_segment18_high);

1224:
1225: ELSIF p_map_t(i).segment18_low IS NOT NULL
1226: and p_map_t(i).segment18_high IS NOT NULL THEN
1227: dbms_sql.bind_variable(l_cursor,'l_segment18_low',l_segment18_low);
1228: dbms_sql.bind_variable(l_cursor,'l_segment18_high',l_segment18_high);
1229: END IF;
1230:
1231: /* segment 19 */
1232: IF p_map_t(i).segment19_low IS NOT NULL

Line 1234: dbms_sql.bind_variable(l_cursor,'l_segment19_low',l_segment19_low);

1230:
1231: /* segment 19 */
1232: IF p_map_t(i).segment19_low IS NOT NULL
1233: and p_map_t(i).segment19_high IS NULL THEN
1234: dbms_sql.bind_variable(l_cursor,'l_segment19_low',l_segment19_low);
1235:
1236: ELSIF p_map_t(i).segment19_low IS NULL
1237: and p_map_t(i).segment19_high IS NOT NULL THEN
1238: dbms_sql.bind_variable(l_cursor,'l_segment19_high',l_segment19_high);

Line 1238: dbms_sql.bind_variable(l_cursor,'l_segment19_high',l_segment19_high);

1234: dbms_sql.bind_variable(l_cursor,'l_segment19_low',l_segment19_low);
1235:
1236: ELSIF p_map_t(i).segment19_low IS NULL
1237: and p_map_t(i).segment19_high IS NOT NULL THEN
1238: dbms_sql.bind_variable(l_cursor,'l_segment19_high',l_segment19_high);
1239:
1240: ELSIF p_map_t(i).segment19_low IS NOT NULL
1241: and p_map_t(i).segment19_high IS NOT NULL THEN
1242: dbms_sql.bind_variable(l_cursor,'l_segment19_low',l_segment19_low);

Line 1242: dbms_sql.bind_variable(l_cursor,'l_segment19_low',l_segment19_low);

1238: dbms_sql.bind_variable(l_cursor,'l_segment19_high',l_segment19_high);
1239:
1240: ELSIF p_map_t(i).segment19_low IS NOT NULL
1241: and p_map_t(i).segment19_high IS NOT NULL THEN
1242: dbms_sql.bind_variable(l_cursor,'l_segment19_low',l_segment19_low);
1243: dbms_sql.bind_variable(l_cursor,'l_segment19_high',l_segment19_high);
1244: END IF;
1245:
1246: /* segment 20 */

Line 1243: dbms_sql.bind_variable(l_cursor,'l_segment19_high',l_segment19_high);

1239:
1240: ELSIF p_map_t(i).segment19_low IS NOT NULL
1241: and p_map_t(i).segment19_high IS NOT NULL THEN
1242: dbms_sql.bind_variable(l_cursor,'l_segment19_low',l_segment19_low);
1243: dbms_sql.bind_variable(l_cursor,'l_segment19_high',l_segment19_high);
1244: END IF;
1245:
1246: /* segment 20 */
1247: IF p_map_t(i).segment20_low IS NOT NULL

Line 1249: dbms_sql.bind_variable(l_cursor,'l_segment20_low',l_segment20_low);

1245:
1246: /* segment 20 */
1247: IF p_map_t(i).segment20_low IS NOT NULL
1248: and p_map_t(i).segment20_high IS NULL THEN
1249: dbms_sql.bind_variable(l_cursor,'l_segment20_low',l_segment20_low);
1250:
1251: ELSIF p_map_t(i).segment20_low IS NULL
1252: and p_map_t(i).segment20_high IS NOT NULL THEN
1253: dbms_sql.bind_variable(l_cursor,'l_segment20_high',l_segment20_high);

Line 1253: dbms_sql.bind_variable(l_cursor,'l_segment20_high',l_segment20_high);

1249: dbms_sql.bind_variable(l_cursor,'l_segment20_low',l_segment20_low);
1250:
1251: ELSIF p_map_t(i).segment20_low IS NULL
1252: and p_map_t(i).segment20_high IS NOT NULL THEN
1253: dbms_sql.bind_variable(l_cursor,'l_segment20_high',l_segment20_high);
1254:
1255: ELSIF p_map_t(i).segment20_low IS NOT NULL
1256: and p_map_t(i).segment20_high IS NOT NULL THEN
1257: dbms_sql.bind_variable(l_cursor,'l_segment20_low',l_segment20_low);

Line 1257: dbms_sql.bind_variable(l_cursor,'l_segment20_low',l_segment20_low);

1253: dbms_sql.bind_variable(l_cursor,'l_segment20_high',l_segment20_high);
1254:
1255: ELSIF p_map_t(i).segment20_low IS NOT NULL
1256: and p_map_t(i).segment20_high IS NOT NULL THEN
1257: dbms_sql.bind_variable(l_cursor,'l_segment20_low',l_segment20_low);
1258: dbms_sql.bind_variable(l_cursor,'l_segment20_high',l_segment20_high);
1259: END IF;
1260:
1261: /* segment 21 */

Line 1258: dbms_sql.bind_variable(l_cursor,'l_segment20_high',l_segment20_high);

1254:
1255: ELSIF p_map_t(i).segment20_low IS NOT NULL
1256: and p_map_t(i).segment20_high IS NOT NULL THEN
1257: dbms_sql.bind_variable(l_cursor,'l_segment20_low',l_segment20_low);
1258: dbms_sql.bind_variable(l_cursor,'l_segment20_high',l_segment20_high);
1259: END IF;
1260:
1261: /* segment 21 */
1262: IF p_map_t(i).segment21_low IS NOT NULL

Line 1264: dbms_sql.bind_variable(l_cursor,'l_segment21_low',l_segment21_low);

1260:
1261: /* segment 21 */
1262: IF p_map_t(i).segment21_low IS NOT NULL
1263: and p_map_t(i).segment21_high IS NULL THEN
1264: dbms_sql.bind_variable(l_cursor,'l_segment21_low',l_segment21_low);
1265:
1266: ELSIF p_map_t(i).segment21_low IS NULL
1267: and p_map_t(i).segment21_high IS NOT NULL THEN
1268: dbms_sql.bind_variable(l_cursor,'l_segment21_high',l_segment21_high);

Line 1268: dbms_sql.bind_variable(l_cursor,'l_segment21_high',l_segment21_high);

1264: dbms_sql.bind_variable(l_cursor,'l_segment21_low',l_segment21_low);
1265:
1266: ELSIF p_map_t(i).segment21_low IS NULL
1267: and p_map_t(i).segment21_high IS NOT NULL THEN
1268: dbms_sql.bind_variable(l_cursor,'l_segment21_high',l_segment21_high);
1269:
1270: ELSIF p_map_t(i).segment21_low IS NOT NULL
1271: and p_map_t(i).segment21_high IS NOT NULL THEN
1272: dbms_sql.bind_variable(l_cursor,'l_segment21_low',l_segment21_low);

Line 1272: dbms_sql.bind_variable(l_cursor,'l_segment21_low',l_segment21_low);

1268: dbms_sql.bind_variable(l_cursor,'l_segment21_high',l_segment21_high);
1269:
1270: ELSIF p_map_t(i).segment21_low IS NOT NULL
1271: and p_map_t(i).segment21_high IS NOT NULL THEN
1272: dbms_sql.bind_variable(l_cursor,'l_segment21_low',l_segment21_low);
1273: dbms_sql.bind_variable(l_cursor,'l_segment21_high',l_segment21_high);
1274: END IF;
1275:
1276: /* segment 22 */

Line 1273: dbms_sql.bind_variable(l_cursor,'l_segment21_high',l_segment21_high);

1269:
1270: ELSIF p_map_t(i).segment21_low IS NOT NULL
1271: and p_map_t(i).segment21_high IS NOT NULL THEN
1272: dbms_sql.bind_variable(l_cursor,'l_segment21_low',l_segment21_low);
1273: dbms_sql.bind_variable(l_cursor,'l_segment21_high',l_segment21_high);
1274: END IF;
1275:
1276: /* segment 22 */
1277: IF p_map_t(i).segment22_low IS NOT NULL

Line 1279: dbms_sql.bind_variable(l_cursor,'l_segment22_low',l_segment22_low);

1275:
1276: /* segment 22 */
1277: IF p_map_t(i).segment22_low IS NOT NULL
1278: and p_map_t(i).segment22_high IS NULL THEN
1279: dbms_sql.bind_variable(l_cursor,'l_segment22_low',l_segment22_low);
1280:
1281: ELSIF p_map_t(i).segment22_low IS NULL
1282: and p_map_t(i).segment22_high IS NOT NULL THEN
1283: dbms_sql.bind_variable(l_cursor,'l_segment22_high',l_segment22_high);

Line 1283: dbms_sql.bind_variable(l_cursor,'l_segment22_high',l_segment22_high);

1279: dbms_sql.bind_variable(l_cursor,'l_segment22_low',l_segment22_low);
1280:
1281: ELSIF p_map_t(i).segment22_low IS NULL
1282: and p_map_t(i).segment22_high IS NOT NULL THEN
1283: dbms_sql.bind_variable(l_cursor,'l_segment22_high',l_segment22_high);
1284:
1285: ELSIF p_map_t(i).segment22_low IS NOT NULL
1286: and p_map_t(i).segment22_high IS NOT NULL THEN
1287: dbms_sql.bind_variable(l_cursor,'l_segment22_low',l_segment22_low);

Line 1287: dbms_sql.bind_variable(l_cursor,'l_segment22_low',l_segment22_low);

1283: dbms_sql.bind_variable(l_cursor,'l_segment22_high',l_segment22_high);
1284:
1285: ELSIF p_map_t(i).segment22_low IS NOT NULL
1286: and p_map_t(i).segment22_high IS NOT NULL THEN
1287: dbms_sql.bind_variable(l_cursor,'l_segment22_low',l_segment22_low);
1288: dbms_sql.bind_variable(l_cursor,'l_segment22_high',l_segment22_high);
1289: END IF;
1290:
1291: /* segment 23 */

Line 1288: dbms_sql.bind_variable(l_cursor,'l_segment22_high',l_segment22_high);

1284:
1285: ELSIF p_map_t(i).segment22_low IS NOT NULL
1286: and p_map_t(i).segment22_high IS NOT NULL THEN
1287: dbms_sql.bind_variable(l_cursor,'l_segment22_low',l_segment22_low);
1288: dbms_sql.bind_variable(l_cursor,'l_segment22_high',l_segment22_high);
1289: END IF;
1290:
1291: /* segment 23 */
1292: IF p_map_t(i).segment23_low IS NOT NULL

Line 1294: dbms_sql.bind_variable(l_cursor,'l_segment23_low',l_segment23_low);

1290:
1291: /* segment 23 */
1292: IF p_map_t(i).segment23_low IS NOT NULL
1293: and p_map_t(i).segment23_high IS NULL THEN
1294: dbms_sql.bind_variable(l_cursor,'l_segment23_low',l_segment23_low);
1295:
1296: ELSIF p_map_t(i).segment23_low IS NULL
1297: and p_map_t(i).segment23_high IS NOT NULL THEN
1298: dbms_sql.bind_variable(l_cursor,'l_segment23_high',l_segment23_high);

Line 1298: dbms_sql.bind_variable(l_cursor,'l_segment23_high',l_segment23_high);

1294: dbms_sql.bind_variable(l_cursor,'l_segment23_low',l_segment23_low);
1295:
1296: ELSIF p_map_t(i).segment23_low IS NULL
1297: and p_map_t(i).segment23_high IS NOT NULL THEN
1298: dbms_sql.bind_variable(l_cursor,'l_segment23_high',l_segment23_high);
1299:
1300: ELSIF p_map_t(i).segment23_low IS NOT NULL
1301: and p_map_t(i).segment23_high IS NOT NULL THEN
1302: dbms_sql.bind_variable(l_cursor,'l_segment23_low',l_segment23_low);

Line 1302: dbms_sql.bind_variable(l_cursor,'l_segment23_low',l_segment23_low);

1298: dbms_sql.bind_variable(l_cursor,'l_segment23_high',l_segment23_high);
1299:
1300: ELSIF p_map_t(i).segment23_low IS NOT NULL
1301: and p_map_t(i).segment23_high IS NOT NULL THEN
1302: dbms_sql.bind_variable(l_cursor,'l_segment23_low',l_segment23_low);
1303: dbms_sql.bind_variable(l_cursor,'l_segment23_high',l_segment23_high);
1304: END IF;
1305:
1306: /* segment 24 */

Line 1303: dbms_sql.bind_variable(l_cursor,'l_segment23_high',l_segment23_high);

1299:
1300: ELSIF p_map_t(i).segment23_low IS NOT NULL
1301: and p_map_t(i).segment23_high IS NOT NULL THEN
1302: dbms_sql.bind_variable(l_cursor,'l_segment23_low',l_segment23_low);
1303: dbms_sql.bind_variable(l_cursor,'l_segment23_high',l_segment23_high);
1304: END IF;
1305:
1306: /* segment 24 */
1307: IF p_map_t(i).segment24_low IS NOT NULL

Line 1309: dbms_sql.bind_variable(l_cursor,'l_segment24_low',l_segment24_low);

1305:
1306: /* segment 24 */
1307: IF p_map_t(i).segment24_low IS NOT NULL
1308: and p_map_t(i).segment24_high IS NULL THEN
1309: dbms_sql.bind_variable(l_cursor,'l_segment24_low',l_segment24_low);
1310:
1311: ELSIF p_map_t(i).segment24_low IS NULL
1312: and p_map_t(i).segment24_high IS NOT NULL THEN
1313: dbms_sql.bind_variable(l_cursor,'l_segment24_high',l_segment24_high);

Line 1313: dbms_sql.bind_variable(l_cursor,'l_segment24_high',l_segment24_high);

1309: dbms_sql.bind_variable(l_cursor,'l_segment24_low',l_segment24_low);
1310:
1311: ELSIF p_map_t(i).segment24_low IS NULL
1312: and p_map_t(i).segment24_high IS NOT NULL THEN
1313: dbms_sql.bind_variable(l_cursor,'l_segment24_high',l_segment24_high);
1314:
1315: ELSIF p_map_t(i).segment24_low IS NOT NULL
1316: and p_map_t(i).segment24_high IS NOT NULL THEN
1317: dbms_sql.bind_variable(l_cursor,'l_segment24_low',l_segment24_low);

Line 1317: dbms_sql.bind_variable(l_cursor,'l_segment24_low',l_segment24_low);

1313: dbms_sql.bind_variable(l_cursor,'l_segment24_high',l_segment24_high);
1314:
1315: ELSIF p_map_t(i).segment24_low IS NOT NULL
1316: and p_map_t(i).segment24_high IS NOT NULL THEN
1317: dbms_sql.bind_variable(l_cursor,'l_segment24_low',l_segment24_low);
1318: dbms_sql.bind_variable(l_cursor,'l_segment24_high',l_segment24_high);
1319: END IF;
1320:
1321: /* segment 25 */

Line 1318: dbms_sql.bind_variable(l_cursor,'l_segment24_high',l_segment24_high);

1314:
1315: ELSIF p_map_t(i).segment24_low IS NOT NULL
1316: and p_map_t(i).segment24_high IS NOT NULL THEN
1317: dbms_sql.bind_variable(l_cursor,'l_segment24_low',l_segment24_low);
1318: dbms_sql.bind_variable(l_cursor,'l_segment24_high',l_segment24_high);
1319: END IF;
1320:
1321: /* segment 25 */
1322: IF p_map_t(i).segment25_low IS NOT NULL

Line 1324: dbms_sql.bind_variable(l_cursor,'l_segment25_low',l_segment25_low);

1320:
1321: /* segment 25 */
1322: IF p_map_t(i).segment25_low IS NOT NULL
1323: and p_map_t(i).segment25_high IS NULL THEN
1324: dbms_sql.bind_variable(l_cursor,'l_segment25_low',l_segment25_low);
1325:
1326: ELSIF p_map_t(i).segment25_low IS NULL
1327: and p_map_t(i).segment25_high IS NOT NULL THEN
1328: dbms_sql.bind_variable(l_cursor,'l_segment25_high',l_segment25_high);

Line 1328: dbms_sql.bind_variable(l_cursor,'l_segment25_high',l_segment25_high);

1324: dbms_sql.bind_variable(l_cursor,'l_segment25_low',l_segment25_low);
1325:
1326: ELSIF p_map_t(i).segment25_low IS NULL
1327: and p_map_t(i).segment25_high IS NOT NULL THEN
1328: dbms_sql.bind_variable(l_cursor,'l_segment25_high',l_segment25_high);
1329:
1330: ELSIF p_map_t(i).segment25_low IS NOT NULL
1331: and p_map_t(i).segment25_high IS NOT NULL THEN
1332: dbms_sql.bind_variable(l_cursor,'l_segment25_low',l_segment25_low);

Line 1332: dbms_sql.bind_variable(l_cursor,'l_segment25_low',l_segment25_low);

1328: dbms_sql.bind_variable(l_cursor,'l_segment25_high',l_segment25_high);
1329:
1330: ELSIF p_map_t(i).segment25_low IS NOT NULL
1331: and p_map_t(i).segment25_high IS NOT NULL THEN
1332: dbms_sql.bind_variable(l_cursor,'l_segment25_low',l_segment25_low);
1333: dbms_sql.bind_variable(l_cursor,'l_segment25_high',l_segment25_high);
1334: END IF;
1335:
1336: /* segment 26 */

Line 1333: dbms_sql.bind_variable(l_cursor,'l_segment25_high',l_segment25_high);

1329:
1330: ELSIF p_map_t(i).segment25_low IS NOT NULL
1331: and p_map_t(i).segment25_high IS NOT NULL THEN
1332: dbms_sql.bind_variable(l_cursor,'l_segment25_low',l_segment25_low);
1333: dbms_sql.bind_variable(l_cursor,'l_segment25_high',l_segment25_high);
1334: END IF;
1335:
1336: /* segment 26 */
1337: IF p_map_t(i).segment26_low IS NOT NULL

Line 1339: dbms_sql.bind_variable(l_cursor,'l_segment26_low',l_segment26_low);

1335:
1336: /* segment 26 */
1337: IF p_map_t(i).segment26_low IS NOT NULL
1338: and p_map_t(i).segment26_high IS NULL THEN
1339: dbms_sql.bind_variable(l_cursor,'l_segment26_low',l_segment26_low);
1340:
1341: ELSIF p_map_t(i).segment26_low IS NULL
1342: and p_map_t(i).segment26_high IS NOT NULL THEN
1343: dbms_sql.bind_variable(l_cursor,'l_segment26_high',l_segment26_high);

Line 1343: dbms_sql.bind_variable(l_cursor,'l_segment26_high',l_segment26_high);

1339: dbms_sql.bind_variable(l_cursor,'l_segment26_low',l_segment26_low);
1340:
1341: ELSIF p_map_t(i).segment26_low IS NULL
1342: and p_map_t(i).segment26_high IS NOT NULL THEN
1343: dbms_sql.bind_variable(l_cursor,'l_segment26_high',l_segment26_high);
1344:
1345: ELSIF p_map_t(i).segment26_low IS NOT NULL
1346: and p_map_t(i).segment26_high IS NOT NULL THEN
1347: dbms_sql.bind_variable(l_cursor,'l_segment26_low',l_segment26_low);

Line 1347: dbms_sql.bind_variable(l_cursor,'l_segment26_low',l_segment26_low);

1343: dbms_sql.bind_variable(l_cursor,'l_segment26_high',l_segment26_high);
1344:
1345: ELSIF p_map_t(i).segment26_low IS NOT NULL
1346: and p_map_t(i).segment26_high IS NOT NULL THEN
1347: dbms_sql.bind_variable(l_cursor,'l_segment26_low',l_segment26_low);
1348: dbms_sql.bind_variable(l_cursor,'l_segment26_high',l_segment26_high);
1349: END IF;
1350:
1351: /* segment 27 */

Line 1348: dbms_sql.bind_variable(l_cursor,'l_segment26_high',l_segment26_high);

1344:
1345: ELSIF p_map_t(i).segment26_low IS NOT NULL
1346: and p_map_t(i).segment26_high IS NOT NULL THEN
1347: dbms_sql.bind_variable(l_cursor,'l_segment26_low',l_segment26_low);
1348: dbms_sql.bind_variable(l_cursor,'l_segment26_high',l_segment26_high);
1349: END IF;
1350:
1351: /* segment 27 */
1352: IF p_map_t(i).segment27_low IS NOT NULL

Line 1354: dbms_sql.bind_variable(l_cursor,'l_segment27_low',l_segment27_low);

1350:
1351: /* segment 27 */
1352: IF p_map_t(i).segment27_low IS NOT NULL
1353: and p_map_t(i).segment27_high IS NULL THEN
1354: dbms_sql.bind_variable(l_cursor,'l_segment27_low',l_segment27_low);
1355:
1356: ELSIF p_map_t(i).segment27_low IS NULL
1357: and p_map_t(i).segment27_high IS NOT NULL THEN
1358: dbms_sql.bind_variable(l_cursor,'l_segment27_high',l_segment27_high);

Line 1358: dbms_sql.bind_variable(l_cursor,'l_segment27_high',l_segment27_high);

1354: dbms_sql.bind_variable(l_cursor,'l_segment27_low',l_segment27_low);
1355:
1356: ELSIF p_map_t(i).segment27_low IS NULL
1357: and p_map_t(i).segment27_high IS NOT NULL THEN
1358: dbms_sql.bind_variable(l_cursor,'l_segment27_high',l_segment27_high);
1359:
1360: ELSIF p_map_t(i).segment27_low IS NOT NULL
1361: and p_map_t(i).segment27_high IS NOT NULL THEN
1362: dbms_sql.bind_variable(l_cursor,'l_segment27_low',l_segment27_low);

Line 1362: dbms_sql.bind_variable(l_cursor,'l_segment27_low',l_segment27_low);

1358: dbms_sql.bind_variable(l_cursor,'l_segment27_high',l_segment27_high);
1359:
1360: ELSIF p_map_t(i).segment27_low IS NOT NULL
1361: and p_map_t(i).segment27_high IS NOT NULL THEN
1362: dbms_sql.bind_variable(l_cursor,'l_segment27_low',l_segment27_low);
1363: dbms_sql.bind_variable(l_cursor,'l_segment27_high',l_segment27_high);
1364: END IF;
1365:
1366: /* segment 28 */

Line 1363: dbms_sql.bind_variable(l_cursor,'l_segment27_high',l_segment27_high);

1359:
1360: ELSIF p_map_t(i).segment27_low IS NOT NULL
1361: and p_map_t(i).segment27_high IS NOT NULL THEN
1362: dbms_sql.bind_variable(l_cursor,'l_segment27_low',l_segment27_low);
1363: dbms_sql.bind_variable(l_cursor,'l_segment27_high',l_segment27_high);
1364: END IF;
1365:
1366: /* segment 28 */
1367: IF p_map_t(i).segment28_low IS NOT NULL

Line 1369: dbms_sql.bind_variable(l_cursor,'l_segment28_low',l_segment28_low);

1365:
1366: /* segment 28 */
1367: IF p_map_t(i).segment28_low IS NOT NULL
1368: and p_map_t(i).segment28_high IS NULL THEN
1369: dbms_sql.bind_variable(l_cursor,'l_segment28_low',l_segment28_low);
1370:
1371: ELSIF p_map_t(i).segment28_low IS NULL
1372: and p_map_t(i).segment28_high IS NOT NULL THEN
1373: dbms_sql.bind_variable(l_cursor,'l_segment28_high',l_segment28_high);

Line 1373: dbms_sql.bind_variable(l_cursor,'l_segment28_high',l_segment28_high);

1369: dbms_sql.bind_variable(l_cursor,'l_segment28_low',l_segment28_low);
1370:
1371: ELSIF p_map_t(i).segment28_low IS NULL
1372: and p_map_t(i).segment28_high IS NOT NULL THEN
1373: dbms_sql.bind_variable(l_cursor,'l_segment28_high',l_segment28_high);
1374:
1375: ELSIF p_map_t(i).segment28_low IS NOT NULL
1376: and p_map_t(i).segment28_high IS NOT NULL THEN
1377: dbms_sql.bind_variable(l_cursor,'l_segment28_low',l_segment28_low);

Line 1377: dbms_sql.bind_variable(l_cursor,'l_segment28_low',l_segment28_low);

1373: dbms_sql.bind_variable(l_cursor,'l_segment28_high',l_segment28_high);
1374:
1375: ELSIF p_map_t(i).segment28_low IS NOT NULL
1376: and p_map_t(i).segment28_high IS NOT NULL THEN
1377: dbms_sql.bind_variable(l_cursor,'l_segment28_low',l_segment28_low);
1378: dbms_sql.bind_variable(l_cursor,'l_segment28_high',l_segment28_high);
1379: END IF;
1380:
1381: /* segment 29 */

Line 1378: dbms_sql.bind_variable(l_cursor,'l_segment28_high',l_segment28_high);

1374:
1375: ELSIF p_map_t(i).segment28_low IS NOT NULL
1376: and p_map_t(i).segment28_high IS NOT NULL THEN
1377: dbms_sql.bind_variable(l_cursor,'l_segment28_low',l_segment28_low);
1378: dbms_sql.bind_variable(l_cursor,'l_segment28_high',l_segment28_high);
1379: END IF;
1380:
1381: /* segment 29 */
1382: IF p_map_t(i).segment29_low IS NOT NULL

Line 1384: dbms_sql.bind_variable(l_cursor,'l_segment29_low',l_segment29_low);

1380:
1381: /* segment 29 */
1382: IF p_map_t(i).segment29_low IS NOT NULL
1383: and p_map_t(i).segment29_high IS NULL THEN
1384: dbms_sql.bind_variable(l_cursor,'l_segment29_low',l_segment29_low);
1385:
1386: ELSIF p_map_t(i).segment29_low IS NULL
1387: and p_map_t(i).segment29_high IS NOT NULL THEN
1388: dbms_sql.bind_variable(l_cursor,'l_segment29_high',l_segment29_high);

Line 1388: dbms_sql.bind_variable(l_cursor,'l_segment29_high',l_segment29_high);

1384: dbms_sql.bind_variable(l_cursor,'l_segment29_low',l_segment29_low);
1385:
1386: ELSIF p_map_t(i).segment29_low IS NULL
1387: and p_map_t(i).segment29_high IS NOT NULL THEN
1388: dbms_sql.bind_variable(l_cursor,'l_segment29_high',l_segment29_high);
1389:
1390: ELSIF p_map_t(i).segment29_low IS NOT NULL
1391: and p_map_t(i).segment29_high IS NOT NULL THEN
1392: dbms_sql.bind_variable(l_cursor,'l_segment29_low',l_segment29_low);

Line 1392: dbms_sql.bind_variable(l_cursor,'l_segment29_low',l_segment29_low);

1388: dbms_sql.bind_variable(l_cursor,'l_segment29_high',l_segment29_high);
1389:
1390: ELSIF p_map_t(i).segment29_low IS NOT NULL
1391: and p_map_t(i).segment29_high IS NOT NULL THEN
1392: dbms_sql.bind_variable(l_cursor,'l_segment29_low',l_segment29_low);
1393: dbms_sql.bind_variable(l_cursor,'l_segment29_high',l_segment29_high);
1394: END IF;
1395:
1396: /* segment 30 */

Line 1393: dbms_sql.bind_variable(l_cursor,'l_segment29_high',l_segment29_high);

1389:
1390: ELSIF p_map_t(i).segment29_low IS NOT NULL
1391: and p_map_t(i).segment29_high IS NOT NULL THEN
1392: dbms_sql.bind_variable(l_cursor,'l_segment29_low',l_segment29_low);
1393: dbms_sql.bind_variable(l_cursor,'l_segment29_high',l_segment29_high);
1394: END IF;
1395:
1396: /* segment 30 */
1397: IF p_map_t(i).segment30_low IS NOT NULL

Line 1399: dbms_sql.bind_variable(l_cursor,'l_segment30_low',l_segment30_low);

1395:
1396: /* segment 30 */
1397: IF p_map_t(i).segment30_low IS NOT NULL
1398: and p_map_t(i).segment30_high IS NULL THEN
1399: dbms_sql.bind_variable(l_cursor,'l_segment30_low',l_segment30_low);
1400:
1401: ELSIF p_map_t(i).segment30_low IS NULL
1402: and p_map_t(i).segment30_high IS NOT NULL THEN
1403: dbms_sql.bind_variable(l_cursor,'l_segment30_high',l_segment30_high);

Line 1403: dbms_sql.bind_variable(l_cursor,'l_segment30_high',l_segment30_high);

1399: dbms_sql.bind_variable(l_cursor,'l_segment30_low',l_segment30_low);
1400:
1401: ELSIF p_map_t(i).segment30_low IS NULL
1402: and p_map_t(i).segment30_high IS NOT NULL THEN
1403: dbms_sql.bind_variable(l_cursor,'l_segment30_high',l_segment30_high);
1404:
1405: ELSIF p_map_t(i).segment30_low IS NOT NULL
1406: and p_map_t(i).segment30_high IS NOT NULL THEN
1407: dbms_sql.bind_variable(l_cursor,'l_segment30_low',l_segment30_low);

Line 1407: dbms_sql.bind_variable(l_cursor,'l_segment30_low',l_segment30_low);

1403: dbms_sql.bind_variable(l_cursor,'l_segment30_high',l_segment30_high);
1404:
1405: ELSIF p_map_t(i).segment30_low IS NOT NULL
1406: and p_map_t(i).segment30_high IS NOT NULL THEN
1407: dbms_sql.bind_variable(l_cursor,'l_segment30_low',l_segment30_low);
1408: dbms_sql.bind_variable(l_cursor,'l_segment30_high',l_segment30_high);
1409: END IF;
1410:
1411: dbms_sql.define_column (l_cursor,1,l_ccid_temp);

Line 1408: dbms_sql.bind_variable(l_cursor,'l_segment30_high',l_segment30_high);

1404:
1405: ELSIF p_map_t(i).segment30_low IS NOT NULL
1406: and p_map_t(i).segment30_high IS NOT NULL THEN
1407: dbms_sql.bind_variable(l_cursor,'l_segment30_low',l_segment30_low);
1408: dbms_sql.bind_variable(l_cursor,'l_segment30_high',l_segment30_high);
1409: END IF;
1410:
1411: dbms_sql.define_column (l_cursor,1,l_ccid_temp);
1412: l_rows := dbms_sql.execute(l_cursor);

Line 1411: dbms_sql.define_column (l_cursor,1,l_ccid_temp);

1407: dbms_sql.bind_variable(l_cursor,'l_segment30_low',l_segment30_low);
1408: dbms_sql.bind_variable(l_cursor,'l_segment30_high',l_segment30_high);
1409: END IF;
1410:
1411: dbms_sql.define_column (l_cursor,1,l_ccid_temp);
1412: l_rows := dbms_sql.execute(l_cursor);
1413:
1414: l_info := 'populating the CCID pl/sql table';
1415:

Line 1412: l_rows := dbms_sql.execute(l_cursor);

1408: dbms_sql.bind_variable(l_cursor,'l_segment30_high',l_segment30_high);
1409: END IF;
1410:
1411: dbms_sql.define_column (l_cursor,1,l_ccid_temp);
1412: l_rows := dbms_sql.execute(l_cursor);
1413:
1414: l_info := 'populating the CCID pl/sql table';
1415:
1416: LOOP

Line 1418: l_count := dbms_sql.fetch_rows( l_cursor );

1414: l_info := 'populating the CCID pl/sql table';
1415:
1416: LOOP
1417:
1418: l_count := dbms_sql.fetch_rows( l_cursor );
1419: EXIT WHEN l_count <> 1;
1420: dbms_sql.column_value(l_cursor,1,l_ccid_temp);
1421:
1422: l_ccid_tbl_count := l_ccid_tbl_count + 1;

Line 1420: dbms_sql.column_value(l_cursor,1,l_ccid_temp);

1416: LOOP
1417:
1418: l_count := dbms_sql.fetch_rows( l_cursor );
1419: EXIT WHEN l_count <> 1;
1420: dbms_sql.column_value(l_cursor,1,l_ccid_temp);
1421:
1422: l_ccid_tbl_count := l_ccid_tbl_count + 1;
1423:
1424: p_ccid_t(l_ccid_tbl_count).map_row := i;

Line 1432: IF dbms_sql.is_open (l_cursor) THEN

1428: p_ccid_t(l_ccid_tbl_count).bud_amount := 0;
1429:
1430: END LOOP;
1431:
1432: IF dbms_sql.is_open (l_cursor) THEN
1433: dbms_sql.close_cursor (l_cursor);
1434: END IF;
1435:
1436:

Line 1433: dbms_sql.close_cursor (l_cursor);

1429:
1430: END LOOP;
1431:
1432: IF dbms_sql.is_open (l_cursor) THEN
1433: dbms_sql.close_cursor (l_cursor);
1434: END IF;
1435:
1436:
1437: