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.QA_SEQUENCE_API dependencies on QLTTRAWB

Line 345: x_seq_table OUT NOCOPY QLTTRAWB.CHAR50_TABLE ) IS

341: -- rponnusa Mon Nov 18 03:49:15 PST 2002
342:
343: PROCEDURE FILL_SEQ_TABLE (p_char_id IN NUMBER,
344: p_count IN NUMBER,
345: x_seq_table OUT NOCOPY QLTTRAWB.CHAR50_TABLE ) IS
346:
347: -- This procedure is called from qlttrawb.plb
348: -- For sequence datatype, we need to generate distinct sequence value for each record.
349: -- First generate p_count distinct seq values, bundle it in seq table

Line 347: -- This procedure is called from qlttrawb.plb

343: PROCEDURE FILL_SEQ_TABLE (p_char_id IN NUMBER,
344: p_count IN NUMBER,
345: x_seq_table OUT NOCOPY QLTTRAWB.CHAR50_TABLE ) IS
346:
347: -- This procedure is called from qlttrawb.plb
348: -- For sequence datatype, we need to generate distinct sequence value for each record.
349: -- First generate p_count distinct seq values, bundle it in seq table
350: -- and send it back to calling procedure.
351: -- p_count is the no. of records processed by the worker.

Line 356: x_seq_table := QLTTRAWB.CHAR50_TABLE ();

352: --
353:
354: BEGIN
355: -- we need to initialize the collection before actually use it.
356: x_seq_table := QLTTRAWB.CHAR50_TABLE ();
357:
358: -- create the number of elements required for the collection.
359: x_seq_table.EXTEND(p_count);
360:

Line 648: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,

644: -- bulk fetch all the records into corresponding plsql tables
645: -- this is called from transaction mode
646:
647: FETCH coll_cur BULK COLLECT INTO
648: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
649: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
650: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
651: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
652: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,

Line 649: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,

645: -- this is called from transaction mode
646:
647: FETCH coll_cur BULK COLLECT INTO
648: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
649: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
650: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
651: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
652: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
653: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,

Line 650: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,

646:
647: FETCH coll_cur BULK COLLECT INTO
648: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
649: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
650: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
651: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
652: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
653: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
654: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;

Line 651: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,

647: FETCH coll_cur BULK COLLECT INTO
648: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
649: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
650: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
651: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
652: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
653: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
654: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
655:

Line 652: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,

648: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
649: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
650: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
651: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
652: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
653: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
654: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
655:
656: l_row_count := coll_cur%ROWCOUNT;

Line 653: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,

649: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
650: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
651: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
652: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
653: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
654: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
655:
656: l_row_count := coll_cur%ROWCOUNT;
657: CLOSE coll_cur;

Line 654: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;

650: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
651: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
652: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
653: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
654: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
655:
656: l_row_count := coll_cur%ROWCOUNT;
657: CLOSE coll_cur;
658:

Line 665: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,

661: -- bulk fetch all the records into corresponding plsql tables
662: -- this is called from direct data entry mode
663:
664: FETCH txn_cur BULK COLLECT INTO
665: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
666: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
667: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
668: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
669: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,

Line 666: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,

662: -- this is called from direct data entry mode
663:
664: FETCH txn_cur BULK COLLECT INTO
665: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
666: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
667: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
668: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
669: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
670: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,

Line 667: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,

663:
664: FETCH txn_cur BULK COLLECT INTO
665: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
666: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
667: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
668: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
669: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
670: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
671: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;

Line 668: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,

664: FETCH txn_cur BULK COLLECT INTO
665: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
666: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
667: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
668: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
669: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
670: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
671: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
672:

Line 669: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,

665: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
666: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
667: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
668: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
669: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
670: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
671: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
672:
673: l_row_count := txn_cur%ROWCOUNT;

Line 670: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,

666: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
667: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
668: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
669: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
670: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
671: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
672:
673: l_row_count := txn_cur%ROWCOUNT;
674: CLOSE txn_cur;

Line 671: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;

667: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
668: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
669: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
670: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
671: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
672:
673: l_row_count := txn_cur%ROWCOUNT;
674: CLOSE txn_cur;
675:

Line 1140: FOR i IN 1..QLTTRAWB.g_occurrence_tab.count LOOP

1136: parentChildCntr PLS_INTEGER := 1;
1137:
1138: BEGIN
1139:
1140: FOR i IN 1..QLTTRAWB.g_occurrence_tab.count LOOP
1141:
1142: -- Find out the position of parent and/or child record in the plsql table
1143: -- by looping through the G_OCCURRENCE and store it in rec. indicator.
1144:

Line 1146: QLTTRAWB.g_occurrence_tab(i) = p_parent_occurrence) THEN

1142: -- Find out the position of parent and/or child record in the plsql table
1143: -- by looping through the G_OCCURRENCE and store it in rec. indicator.
1144:
1145: IF (p_parent_plan_id IS NOT NULL AND
1146: QLTTRAWB.g_occurrence_tab(i) = p_parent_occurrence) THEN
1147:
1148: l_parent_rec_indicator := i;
1149:
1150: ELSIF QLTTRAWB.g_occurrence_tab(i) = p_occurrence THEN -- for child record

Line 1150: ELSIF QLTTRAWB.g_occurrence_tab(i) = p_occurrence THEN -- for child record

1146: QLTTRAWB.g_occurrence_tab(i) = p_parent_occurrence) THEN
1147:
1148: l_parent_rec_indicator := i;
1149:
1150: ELSIF QLTTRAWB.g_occurrence_tab(i) = p_occurrence THEN -- for child record
1151: l_cur_rec_indicator := i;
1152: END IF;
1153:
1154: END LOOP;

Line 1177: -- In the QLTTRAWB.g_seq_tab1..15 if any value is 'Automatic' means that new seq. number

1173:
1174: -- Generate new seq. value for parent rec. sequence elements or for child rec.
1175: -- sequence element which doesnt have any seq copy relation with parent rec.
1176:
1177: -- In the QLTTRAWB.g_seq_tab1..15 if any value is 'Automatic' means that new seq. number
1178: -- needs to be generated.
1179:
1180: -- For normal datacollection, generated only the sequence values for all the elements in
1181: -- the plan. But in eRes enabled txn, generated and capture the audit information at the

Line 1187: IF NVL(QLTTRAWB.g_seq_tab1(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1183:
1184: l_seq_default_value := get_sequence_default_value();
1185: l_eres_enabled := get_eres_profile();
1186:
1187: IF NVL(QLTTRAWB.g_seq_tab1(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1188: l_char_id := g_curr_plan_seq_char_ids(1);
1189:
1190: --
1191: -- Bug 5228667

Line 1208: QLTTRAWB.g_seq_tab1(l_cur_rec_indicator) := l_seq_value;

1204: l_char_id);
1205: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1206: End if;
1207:
1208: QLTTRAWB.g_seq_tab1(l_cur_rec_indicator) := l_seq_value;
1209:
1210: --
1211: -- Bug 5228667
1212: -- if ERES Txn is being resubmitted then the Seq

Line 1240: IF NVL(QLTTRAWB.g_seq_tab2(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1236:
1237: END IF;
1238:
1239:
1240: IF NVL(QLTTRAWB.g_seq_tab2(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1241: l_char_id := g_curr_plan_seq_char_ids(2);
1242:
1243: --
1244: -- Bug 5228667

Line 1261: QLTTRAWB.g_seq_tab2(l_cur_rec_indicator) := l_seq_value;

1257: l_char_id);
1258: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1259: End if;
1260:
1261: QLTTRAWB.g_seq_tab2(l_cur_rec_indicator) := l_seq_value;
1262:
1263: --
1264: -- Bug 5228667
1265: -- if ERES Txn is being resubmitted then the Seq

Line 1287: IF NVL(QLTTRAWB.g_seq_tab3(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1283: -- Bug 3160651.
1284: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1285: END IF;
1286:
1287: IF NVL(QLTTRAWB.g_seq_tab3(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1288: l_char_id := g_curr_plan_seq_char_ids(3);
1289:
1290: --
1291: -- Bug 5228667

Line 1308: QLTTRAWB.g_seq_tab3(l_cur_rec_indicator) := l_seq_value;

1304: l_char_id);
1305: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1306: End if;
1307:
1308: QLTTRAWB.g_seq_tab3(l_cur_rec_indicator) := l_seq_value;
1309:
1310: --
1311: -- Bug 5228667
1312: -- if ERES Txn is being resubmitted then the Seq

Line 1335: IF NVL(QLTTRAWB.g_seq_tab4(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1331: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1332:
1333: END IF;
1334:
1335: IF NVL(QLTTRAWB.g_seq_tab4(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1336: l_char_id := g_curr_plan_seq_char_ids(4);
1337:
1338: --
1339: -- Bug 5228667

Line 1356: QLTTRAWB.g_seq_tab4(l_cur_rec_indicator) := l_seq_value;

1352: l_char_id);
1353: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1354: End if;
1355:
1356: QLTTRAWB.g_seq_tab4(l_cur_rec_indicator) := l_seq_value;
1357:
1358: --
1359: -- Bug 5228667
1360: -- if ERES Txn is being resubmitted then the Seq

Line 1383: IF NVL(QLTTRAWB.g_seq_tab5(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1379: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1380:
1381: END IF;
1382:
1383: IF NVL(QLTTRAWB.g_seq_tab5(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1384: l_char_id := g_curr_plan_seq_char_ids(5);
1385:
1386: --
1387: -- Bug 5228667

Line 1404: QLTTRAWB.g_seq_tab5(l_cur_rec_indicator) := l_seq_value;

1400: l_char_id);
1401: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1402: End if;
1403:
1404: QLTTRAWB.g_seq_tab5(l_cur_rec_indicator) := l_seq_value;
1405:
1406: --
1407: -- Bug 5228667
1408: -- if ERES Txn is being resubmitted then the Seq

Line 1431: IF NVL(QLTTRAWB.g_seq_tab6(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1427: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1428:
1429: END IF;
1430:
1431: IF NVL(QLTTRAWB.g_seq_tab6(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1432: l_char_id := g_curr_plan_seq_char_ids(6);
1433:
1434: --
1435: -- Bug 5228667

Line 1452: QLTTRAWB.g_seq_tab6(l_cur_rec_indicator) := l_seq_value;

1448: l_char_id);
1449: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1450: End if;
1451:
1452: QLTTRAWB.g_seq_tab6(l_cur_rec_indicator) := l_seq_value;
1453:
1454: --
1455: -- Bug 5228667
1456: -- if ERES Txn is being resubmitted then the Seq

Line 1479: IF NVL(QLTTRAWB.g_seq_tab7(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1475: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1476:
1477: END IF;
1478:
1479: IF NVL(QLTTRAWB.g_seq_tab7(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1480: l_char_id := g_curr_plan_seq_char_ids(7);
1481:
1482: --
1483: -- Bug 5228667

Line 1500: QLTTRAWB.g_seq_tab7(l_cur_rec_indicator) := l_seq_value;

1496: l_char_id);
1497: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1498: End if;
1499:
1500: QLTTRAWB.g_seq_tab7(l_cur_rec_indicator) := l_seq_value;
1501:
1502: --
1503: -- Bug 5228667
1504: -- if ERES Txn is being resubmitted then the Seq

Line 1527: IF NVL(QLTTRAWB.g_seq_tab8(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1523: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1524:
1525: END IF;
1526:
1527: IF NVL(QLTTRAWB.g_seq_tab8(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1528: l_char_id := g_curr_plan_seq_char_ids(8);
1529:
1530: --
1531: -- Bug 5228667

Line 1548: QLTTRAWB.g_seq_tab8(l_cur_rec_indicator) := l_seq_value;

1544: l_char_id);
1545: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1546: End if;
1547:
1548: QLTTRAWB.g_seq_tab8(l_cur_rec_indicator) := l_seq_value;
1549:
1550: --
1551: -- Bug 5228667
1552: -- if ERES Txn is being resubmitted then the Seq

Line 1575: IF NVL(QLTTRAWB.g_seq_tab9(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1571: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1572:
1573: END IF;
1574:
1575: IF NVL(QLTTRAWB.g_seq_tab9(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1576: l_char_id := g_curr_plan_seq_char_ids(9);
1577:
1578: --
1579: -- Bug 5228667

Line 1596: QLTTRAWB.g_seq_tab9(l_cur_rec_indicator) := l_seq_value;

1592: l_char_id);
1593: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1594: End if;
1595:
1596: QLTTRAWB.g_seq_tab9(l_cur_rec_indicator) := l_seq_value;
1597:
1598: --
1599: -- Bug 5228667
1600: -- if ERES Txn is being resubmitted then the Seq

Line 1623: IF NVL(QLTTRAWB.g_seq_tab10(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1619: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1620:
1621: END IF;
1622:
1623: IF NVL(QLTTRAWB.g_seq_tab10(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1624: l_char_id := g_curr_plan_seq_char_ids(10);
1625:
1626: --
1627: -- Bug 5228667

Line 1644: QLTTRAWB.g_seq_tab10(l_cur_rec_indicator) := l_seq_value;

1640: l_char_id);
1641: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1642: End if;
1643:
1644: QLTTRAWB.g_seq_tab10(l_cur_rec_indicator) := l_seq_value;
1645:
1646: --
1647: -- Bug 5228667
1648: -- if ERES Txn is being resubmitted then the Seq

Line 1672: IF NVL(QLTTRAWB.g_seq_tab11(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1668:
1669: END IF;
1670:
1671:
1672: IF NVL(QLTTRAWB.g_seq_tab11(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1673: l_char_id := g_curr_plan_seq_char_ids(11);
1674:
1675: --
1676: -- Bug 5228667

Line 1693: QLTTRAWB.g_seq_tab11(l_cur_rec_indicator) := l_seq_value;

1689: l_char_id);
1690: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1691: End if;
1692:
1693: QLTTRAWB.g_seq_tab11(l_cur_rec_indicator) := l_seq_value;
1694:
1695: --
1696: -- Bug 5228667
1697: -- if ERES Txn is being resubmitted then the Seq

Line 1720: IF NVL(QLTTRAWB.g_seq_tab12(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1716: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1717:
1718: END IF;
1719:
1720: IF NVL(QLTTRAWB.g_seq_tab12(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1721: l_char_id := g_curr_plan_seq_char_ids(12);
1722:
1723: --
1724: -- Bug 5228667

Line 1741: QLTTRAWB.g_seq_tab12(l_cur_rec_indicator) := l_seq_value;

1737: l_char_id);
1738: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1739: End if;
1740:
1741: QLTTRAWB.g_seq_tab12(l_cur_rec_indicator) := l_seq_value;
1742:
1743: --
1744: -- Bug 5228667
1745: -- if ERES Txn is being resubmitted then the Seq

Line 1768: IF NVL(QLTTRAWB.g_seq_tab13(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1764: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1765:
1766: END IF;
1767:
1768: IF NVL(QLTTRAWB.g_seq_tab13(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1769: l_char_id := g_curr_plan_seq_char_ids(13);
1770:
1771: --
1772: -- Bug 5228667

Line 1789: QLTTRAWB.g_seq_tab13(l_cur_rec_indicator) := l_seq_value;

1785: l_char_id);
1786: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1787: End if;
1788:
1789: QLTTRAWB.g_seq_tab13(l_cur_rec_indicator) := l_seq_value;
1790:
1791: --
1792: -- Bug 5228667
1793: -- if ERES Txn is being resubmitted then the Seq

Line 1816: IF NVL(QLTTRAWB.g_seq_tab14(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1812: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1813:
1814: END IF;
1815:
1816: IF NVL(QLTTRAWB.g_seq_tab14(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1817: l_char_id := g_curr_plan_seq_char_ids(14);
1818:
1819: --
1820: -- Bug 5228667

Line 1837: QLTTRAWB.g_seq_tab14(l_cur_rec_indicator) := l_seq_value;

1833: l_char_id);
1834: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1835: End if;
1836:
1837: QLTTRAWB.g_seq_tab14(l_cur_rec_indicator) := l_seq_value;
1838:
1839: --
1840: -- Bug 5228667
1841: -- if ERES Txn is being resubmitted then the Seq

Line 1864: IF NVL(QLTTRAWB.g_seq_tab15(l_cur_rec_indicator),' ') = l_seq_default_value THEN

1860: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1861:
1862: END IF;
1863:
1864: IF NVL(QLTTRAWB.g_seq_tab15(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1865: l_char_id := g_curr_plan_seq_char_ids(15);
1866:
1867: --
1868: -- Bug 5228667

Line 1885: QLTTRAWB.g_seq_tab15(l_cur_rec_indicator) := l_seq_value;

1881: l_char_id);
1882: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1883: End if;
1884:
1885: QLTTRAWB.g_seq_tab15(l_cur_rec_indicator) := l_seq_value;
1886:
1887: --
1888: -- Bug 5228667
1889: -- if ERES Txn is being resubmitted then the Seq

Line 1915: -- to be read from the the QLTTRAWB.g_seq_tabX array

1911:
1912: --
1913: -- Bug 5114865
1914: -- Collect the indexes for the Seq Type elements
1915: -- to be read from the the QLTTRAWB.g_seq_tabX array
1916: -- ntungare Sun Apr 9 23:40:46 PDT 2006
1917: If g_curr_plan_seq_char_ids.COUNT <> 0
1918: THEN
1919: g_true_seq_gen_recids(NVL(g_true_seq_gen_recids.LAST,0)+1) := l_cur_rec_indicator;

Line 1951: -- seq element in the QLTTRAWB.g_seq_tab1..15 table for the child rec.

1947:
1948: -- First pack all the char_id of the seq. element in the plan into x_seq_char_ids
1949: -- If it is top level parent rec, then dont do anything.
1950: -- If it is child rec and copy relations exist then copy parent seq. value to child
1951: -- seq element in the QLTTRAWB.g_seq_tab1..15 table for the child rec.
1952:
1953: l_seq_value VARCHAR2(30);
1954: i NUMBER;
1955:

Line 2102: p_seq_value := QLTTRAWB.g_seq_tab1(p_cur_record_indicator);

2098: BEGIN
2099:
2100: IF p_seq_position = 1 THEN
2101: IF p_action = 1 THEN
2102: p_seq_value := QLTTRAWB.g_seq_tab1(p_cur_record_indicator);
2103: ELSE
2104: QLTTRAWB.g_seq_tab1(p_cur_record_indicator):= p_seq_value;
2105: END IF;
2106:

Line 2104: QLTTRAWB.g_seq_tab1(p_cur_record_indicator):= p_seq_value;

2100: IF p_seq_position = 1 THEN
2101: IF p_action = 1 THEN
2102: p_seq_value := QLTTRAWB.g_seq_tab1(p_cur_record_indicator);
2103: ELSE
2104: QLTTRAWB.g_seq_tab1(p_cur_record_indicator):= p_seq_value;
2105: END IF;
2106:
2107:
2108: ELSIF p_seq_position = 2 THEN

Line 2110: p_seq_value := QLTTRAWB.g_seq_tab2(p_cur_record_indicator);

2106:
2107:
2108: ELSIF p_seq_position = 2 THEN
2109: IF p_action = 1 THEN
2110: p_seq_value := QLTTRAWB.g_seq_tab2(p_cur_record_indicator);
2111: ELSE
2112: QLTTRAWB.g_seq_tab2(p_cur_record_indicator):= p_seq_value;
2113: END IF;
2114:

Line 2112: QLTTRAWB.g_seq_tab2(p_cur_record_indicator):= p_seq_value;

2108: ELSIF p_seq_position = 2 THEN
2109: IF p_action = 1 THEN
2110: p_seq_value := QLTTRAWB.g_seq_tab2(p_cur_record_indicator);
2111: ELSE
2112: QLTTRAWB.g_seq_tab2(p_cur_record_indicator):= p_seq_value;
2113: END IF;
2114:
2115: ELSIF p_seq_position = 3 THEN
2116: IF p_action = 1 THEN

Line 2117: p_seq_value := QLTTRAWB.g_seq_tab3(p_cur_record_indicator);

2113: END IF;
2114:
2115: ELSIF p_seq_position = 3 THEN
2116: IF p_action = 1 THEN
2117: p_seq_value := QLTTRAWB.g_seq_tab3(p_cur_record_indicator);
2118: ELSE
2119: QLTTRAWB.g_seq_tab3(p_cur_record_indicator):= p_seq_value;
2120: END IF;
2121:

Line 2119: QLTTRAWB.g_seq_tab3(p_cur_record_indicator):= p_seq_value;

2115: ELSIF p_seq_position = 3 THEN
2116: IF p_action = 1 THEN
2117: p_seq_value := QLTTRAWB.g_seq_tab3(p_cur_record_indicator);
2118: ELSE
2119: QLTTRAWB.g_seq_tab3(p_cur_record_indicator):= p_seq_value;
2120: END IF;
2121:
2122: ELSIF p_seq_position = 4 THEN
2123: IF p_action = 1 THEN

Line 2124: p_seq_value := QLTTRAWB.g_seq_tab4(p_cur_record_indicator);

2120: END IF;
2121:
2122: ELSIF p_seq_position = 4 THEN
2123: IF p_action = 1 THEN
2124: p_seq_value := QLTTRAWB.g_seq_tab4(p_cur_record_indicator);
2125: ELSE
2126: QLTTRAWB.g_seq_tab4( p_cur_record_indicator):= p_seq_value;
2127: END IF;
2128:

Line 2126: QLTTRAWB.g_seq_tab4( p_cur_record_indicator):= p_seq_value;

2122: ELSIF p_seq_position = 4 THEN
2123: IF p_action = 1 THEN
2124: p_seq_value := QLTTRAWB.g_seq_tab4(p_cur_record_indicator);
2125: ELSE
2126: QLTTRAWB.g_seq_tab4( p_cur_record_indicator):= p_seq_value;
2127: END IF;
2128:
2129: ELSIF p_seq_position = 5 THEN
2130: IF p_action = 1 THEN

Line 2131: p_seq_value := QLTTRAWB.g_seq_tab5(p_cur_record_indicator);

2127: END IF;
2128:
2129: ELSIF p_seq_position = 5 THEN
2130: IF p_action = 1 THEN
2131: p_seq_value := QLTTRAWB.g_seq_tab5(p_cur_record_indicator);
2132: ELSE
2133: QLTTRAWB.g_seq_tab5(p_cur_record_indicator):= p_seq_value;
2134: END IF;
2135:

Line 2133: QLTTRAWB.g_seq_tab5(p_cur_record_indicator):= p_seq_value;

2129: ELSIF p_seq_position = 5 THEN
2130: IF p_action = 1 THEN
2131: p_seq_value := QLTTRAWB.g_seq_tab5(p_cur_record_indicator);
2132: ELSE
2133: QLTTRAWB.g_seq_tab5(p_cur_record_indicator):= p_seq_value;
2134: END IF;
2135:
2136: ELSIF p_seq_position = 6 THEN
2137: IF p_action = 1 THEN

Line 2138: p_seq_value := QLTTRAWB.g_seq_tab6(p_cur_record_indicator);

2134: END IF;
2135:
2136: ELSIF p_seq_position = 6 THEN
2137: IF p_action = 1 THEN
2138: p_seq_value := QLTTRAWB.g_seq_tab6(p_cur_record_indicator);
2139: ELSE
2140: QLTTRAWB.g_seq_tab6(p_cur_record_indicator):= p_seq_value;
2141: END IF;
2142:

Line 2140: QLTTRAWB.g_seq_tab6(p_cur_record_indicator):= p_seq_value;

2136: ELSIF p_seq_position = 6 THEN
2137: IF p_action = 1 THEN
2138: p_seq_value := QLTTRAWB.g_seq_tab6(p_cur_record_indicator);
2139: ELSE
2140: QLTTRAWB.g_seq_tab6(p_cur_record_indicator):= p_seq_value;
2141: END IF;
2142:
2143: ELSIF p_seq_position = 7 THEN
2144: IF p_action = 1 THEN

Line 2145: p_seq_value := QLTTRAWB.g_seq_tab7(p_cur_record_indicator);

2141: END IF;
2142:
2143: ELSIF p_seq_position = 7 THEN
2144: IF p_action = 1 THEN
2145: p_seq_value := QLTTRAWB.g_seq_tab7(p_cur_record_indicator);
2146: ELSE
2147: QLTTRAWB.g_seq_tab7(p_cur_record_indicator):= p_seq_value;
2148: END IF;
2149:

Line 2147: QLTTRAWB.g_seq_tab7(p_cur_record_indicator):= p_seq_value;

2143: ELSIF p_seq_position = 7 THEN
2144: IF p_action = 1 THEN
2145: p_seq_value := QLTTRAWB.g_seq_tab7(p_cur_record_indicator);
2146: ELSE
2147: QLTTRAWB.g_seq_tab7(p_cur_record_indicator):= p_seq_value;
2148: END IF;
2149:
2150: ELSIF p_seq_position = 8 THEN
2151: IF p_action = 1 THEN

Line 2152: p_seq_value := QLTTRAWB.g_seq_tab8(p_cur_record_indicator);

2148: END IF;
2149:
2150: ELSIF p_seq_position = 8 THEN
2151: IF p_action = 1 THEN
2152: p_seq_value := QLTTRAWB.g_seq_tab8(p_cur_record_indicator);
2153: ELSE
2154: QLTTRAWB.g_seq_tab8(p_cur_record_indicator):= p_seq_value;
2155: END IF;
2156:

Line 2154: QLTTRAWB.g_seq_tab8(p_cur_record_indicator):= p_seq_value;

2150: ELSIF p_seq_position = 8 THEN
2151: IF p_action = 1 THEN
2152: p_seq_value := QLTTRAWB.g_seq_tab8(p_cur_record_indicator);
2153: ELSE
2154: QLTTRAWB.g_seq_tab8(p_cur_record_indicator):= p_seq_value;
2155: END IF;
2156:
2157: ELSIF p_seq_position = 9 THEN
2158: IF p_action = 1 THEN

Line 2159: p_seq_value := QLTTRAWB.g_seq_tab9(p_cur_record_indicator);

2155: END IF;
2156:
2157: ELSIF p_seq_position = 9 THEN
2158: IF p_action = 1 THEN
2159: p_seq_value := QLTTRAWB.g_seq_tab9(p_cur_record_indicator);
2160: ELSE
2161: QLTTRAWB.g_seq_tab9(p_cur_record_indicator):= p_seq_value;
2162: END IF;
2163:

Line 2161: QLTTRAWB.g_seq_tab9(p_cur_record_indicator):= p_seq_value;

2157: ELSIF p_seq_position = 9 THEN
2158: IF p_action = 1 THEN
2159: p_seq_value := QLTTRAWB.g_seq_tab9(p_cur_record_indicator);
2160: ELSE
2161: QLTTRAWB.g_seq_tab9(p_cur_record_indicator):= p_seq_value;
2162: END IF;
2163:
2164: ELSIF p_seq_position = 10 THEN
2165: IF p_action = 1 THEN

Line 2166: p_seq_value := QLTTRAWB.g_seq_tab10(p_cur_record_indicator);

2162: END IF;
2163:
2164: ELSIF p_seq_position = 10 THEN
2165: IF p_action = 1 THEN
2166: p_seq_value := QLTTRAWB.g_seq_tab10(p_cur_record_indicator);
2167: ELSE
2168: QLTTRAWB.g_seq_tab10(p_cur_record_indicator):= p_seq_value;
2169: END IF;
2170:

Line 2168: QLTTRAWB.g_seq_tab10(p_cur_record_indicator):= p_seq_value;

2164: ELSIF p_seq_position = 10 THEN
2165: IF p_action = 1 THEN
2166: p_seq_value := QLTTRAWB.g_seq_tab10(p_cur_record_indicator);
2167: ELSE
2168: QLTTRAWB.g_seq_tab10(p_cur_record_indicator):= p_seq_value;
2169: END IF;
2170:
2171: ELSIF p_seq_position = 11 THEN
2172: IF p_action = 1 THEN

Line 2173: p_seq_value := QLTTRAWB.g_seq_tab11(p_cur_record_indicator);

2169: END IF;
2170:
2171: ELSIF p_seq_position = 11 THEN
2172: IF p_action = 1 THEN
2173: p_seq_value := QLTTRAWB.g_seq_tab11(p_cur_record_indicator);
2174: ELSE
2175: QLTTRAWB.g_seq_tab11(p_cur_record_indicator):= p_seq_value;
2176: END IF;
2177:

Line 2175: QLTTRAWB.g_seq_tab11(p_cur_record_indicator):= p_seq_value;

2171: ELSIF p_seq_position = 11 THEN
2172: IF p_action = 1 THEN
2173: p_seq_value := QLTTRAWB.g_seq_tab11(p_cur_record_indicator);
2174: ELSE
2175: QLTTRAWB.g_seq_tab11(p_cur_record_indicator):= p_seq_value;
2176: END IF;
2177:
2178: ELSIF p_seq_position = 12 THEN
2179: IF p_action = 1 THEN

Line 2180: p_seq_value := QLTTRAWB.g_seq_tab12(p_cur_record_indicator);

2176: END IF;
2177:
2178: ELSIF p_seq_position = 12 THEN
2179: IF p_action = 1 THEN
2180: p_seq_value := QLTTRAWB.g_seq_tab12(p_cur_record_indicator);
2181: ELSE
2182: QLTTRAWB.g_seq_tab12(p_cur_record_indicator):= p_seq_value;
2183: END IF;
2184:

Line 2182: QLTTRAWB.g_seq_tab12(p_cur_record_indicator):= p_seq_value;

2178: ELSIF p_seq_position = 12 THEN
2179: IF p_action = 1 THEN
2180: p_seq_value := QLTTRAWB.g_seq_tab12(p_cur_record_indicator);
2181: ELSE
2182: QLTTRAWB.g_seq_tab12(p_cur_record_indicator):= p_seq_value;
2183: END IF;
2184:
2185: ELSIF p_seq_position = 13 THEN
2186: IF p_action = 1 THEN

Line 2187: p_seq_value := QLTTRAWB.g_seq_tab13(p_cur_record_indicator);

2183: END IF;
2184:
2185: ELSIF p_seq_position = 13 THEN
2186: IF p_action = 1 THEN
2187: p_seq_value := QLTTRAWB.g_seq_tab13(p_cur_record_indicator);
2188: ELSE
2189: QLTTRAWB.g_seq_tab13(p_cur_record_indicator):= p_seq_value;
2190: END IF;
2191:

Line 2189: QLTTRAWB.g_seq_tab13(p_cur_record_indicator):= p_seq_value;

2185: ELSIF p_seq_position = 13 THEN
2186: IF p_action = 1 THEN
2187: p_seq_value := QLTTRAWB.g_seq_tab13(p_cur_record_indicator);
2188: ELSE
2189: QLTTRAWB.g_seq_tab13(p_cur_record_indicator):= p_seq_value;
2190: END IF;
2191:
2192:
2193: ELSIF p_seq_position = 14 THEN

Line 2195: p_seq_value := QLTTRAWB.g_seq_tab14(p_cur_record_indicator);

2191:
2192:
2193: ELSIF p_seq_position = 14 THEN
2194: IF p_action = 1 THEN
2195: p_seq_value := QLTTRAWB.g_seq_tab14(p_cur_record_indicator);
2196: ELSE
2197: QLTTRAWB.g_seq_tab14(p_cur_record_indicator):= p_seq_value;
2198: END IF;
2199:

Line 2197: QLTTRAWB.g_seq_tab14(p_cur_record_indicator):= p_seq_value;

2193: ELSIF p_seq_position = 14 THEN
2194: IF p_action = 1 THEN
2195: p_seq_value := QLTTRAWB.g_seq_tab14(p_cur_record_indicator);
2196: ELSE
2197: QLTTRAWB.g_seq_tab14(p_cur_record_indicator):= p_seq_value;
2198: END IF;
2199:
2200: ELSIF p_seq_position = 15 THEN
2201: IF p_action = 1 THEN

Line 2202: p_seq_value := QLTTRAWB.g_seq_tab15(p_cur_record_indicator);

2198: END IF;
2199:
2200: ELSIF p_seq_position = 15 THEN
2201: IF p_action = 1 THEN
2202: p_seq_value := QLTTRAWB.g_seq_tab15(p_cur_record_indicator);
2203: ELSE
2204: QLTTRAWB.g_seq_tab15(p_cur_record_indicator):= p_seq_value;
2205: END IF;
2206: END IF;

Line 2204: QLTTRAWB.g_seq_tab15(p_cur_record_indicator):= p_seq_value;

2200: ELSIF p_seq_position = 15 THEN
2201: IF p_action = 1 THEN
2202: p_seq_value := QLTTRAWB.g_seq_tab15(p_cur_record_indicator);
2203: ELSE
2204: QLTTRAWB.g_seq_tab15(p_cur_record_indicator):= p_seq_value;
2205: END IF;
2206: END IF;
2207:
2208: END find_update_seq_in_collection;

Line 2219: QLTTRAWB.g_seq_tab1:= NULL;

2215: PROCEDURE reset_sequence_global_arrays AS
2216: BEGIN
2217: g_true_seq_gen_recids.delete;
2218: ParentChild_Tab.delete;
2219: QLTTRAWB.g_seq_tab1:= NULL;
2220: QLTTRAWB.g_seq_tab2:= NULL;
2221: QLTTRAWB.g_seq_tab3:= NULL;
2222: QLTTRAWB.g_seq_tab4:= NULL;
2223: QLTTRAWB.g_seq_tab5:= NULL;

Line 2220: QLTTRAWB.g_seq_tab2:= NULL;

2216: BEGIN
2217: g_true_seq_gen_recids.delete;
2218: ParentChild_Tab.delete;
2219: QLTTRAWB.g_seq_tab1:= NULL;
2220: QLTTRAWB.g_seq_tab2:= NULL;
2221: QLTTRAWB.g_seq_tab3:= NULL;
2222: QLTTRAWB.g_seq_tab4:= NULL;
2223: QLTTRAWB.g_seq_tab5:= NULL;
2224: QLTTRAWB.g_seq_tab6:= NULL;

Line 2221: QLTTRAWB.g_seq_tab3:= NULL;

2217: g_true_seq_gen_recids.delete;
2218: ParentChild_Tab.delete;
2219: QLTTRAWB.g_seq_tab1:= NULL;
2220: QLTTRAWB.g_seq_tab2:= NULL;
2221: QLTTRAWB.g_seq_tab3:= NULL;
2222: QLTTRAWB.g_seq_tab4:= NULL;
2223: QLTTRAWB.g_seq_tab5:= NULL;
2224: QLTTRAWB.g_seq_tab6:= NULL;
2225: QLTTRAWB.g_seq_tab7:= NULL;

Line 2222: QLTTRAWB.g_seq_tab4:= NULL;

2218: ParentChild_Tab.delete;
2219: QLTTRAWB.g_seq_tab1:= NULL;
2220: QLTTRAWB.g_seq_tab2:= NULL;
2221: QLTTRAWB.g_seq_tab3:= NULL;
2222: QLTTRAWB.g_seq_tab4:= NULL;
2223: QLTTRAWB.g_seq_tab5:= NULL;
2224: QLTTRAWB.g_seq_tab6:= NULL;
2225: QLTTRAWB.g_seq_tab7:= NULL;
2226: QLTTRAWB.g_seq_tab8:= NULL;

Line 2223: QLTTRAWB.g_seq_tab5:= NULL;

2219: QLTTRAWB.g_seq_tab1:= NULL;
2220: QLTTRAWB.g_seq_tab2:= NULL;
2221: QLTTRAWB.g_seq_tab3:= NULL;
2222: QLTTRAWB.g_seq_tab4:= NULL;
2223: QLTTRAWB.g_seq_tab5:= NULL;
2224: QLTTRAWB.g_seq_tab6:= NULL;
2225: QLTTRAWB.g_seq_tab7:= NULL;
2226: QLTTRAWB.g_seq_tab8:= NULL;
2227: QLTTRAWB.g_seq_tab9:= NULL;

Line 2224: QLTTRAWB.g_seq_tab6:= NULL;

2220: QLTTRAWB.g_seq_tab2:= NULL;
2221: QLTTRAWB.g_seq_tab3:= NULL;
2222: QLTTRAWB.g_seq_tab4:= NULL;
2223: QLTTRAWB.g_seq_tab5:= NULL;
2224: QLTTRAWB.g_seq_tab6:= NULL;
2225: QLTTRAWB.g_seq_tab7:= NULL;
2226: QLTTRAWB.g_seq_tab8:= NULL;
2227: QLTTRAWB.g_seq_tab9:= NULL;
2228: QLTTRAWB.g_seq_tab10:= NULL;

Line 2225: QLTTRAWB.g_seq_tab7:= NULL;

2221: QLTTRAWB.g_seq_tab3:= NULL;
2222: QLTTRAWB.g_seq_tab4:= NULL;
2223: QLTTRAWB.g_seq_tab5:= NULL;
2224: QLTTRAWB.g_seq_tab6:= NULL;
2225: QLTTRAWB.g_seq_tab7:= NULL;
2226: QLTTRAWB.g_seq_tab8:= NULL;
2227: QLTTRAWB.g_seq_tab9:= NULL;
2228: QLTTRAWB.g_seq_tab10:= NULL;
2229: QLTTRAWB.g_seq_tab11:= NULL;

Line 2226: QLTTRAWB.g_seq_tab8:= NULL;

2222: QLTTRAWB.g_seq_tab4:= NULL;
2223: QLTTRAWB.g_seq_tab5:= NULL;
2224: QLTTRAWB.g_seq_tab6:= NULL;
2225: QLTTRAWB.g_seq_tab7:= NULL;
2226: QLTTRAWB.g_seq_tab8:= NULL;
2227: QLTTRAWB.g_seq_tab9:= NULL;
2228: QLTTRAWB.g_seq_tab10:= NULL;
2229: QLTTRAWB.g_seq_tab11:= NULL;
2230: QLTTRAWB.g_seq_tab12:= NULL;

Line 2227: QLTTRAWB.g_seq_tab9:= NULL;

2223: QLTTRAWB.g_seq_tab5:= NULL;
2224: QLTTRAWB.g_seq_tab6:= NULL;
2225: QLTTRAWB.g_seq_tab7:= NULL;
2226: QLTTRAWB.g_seq_tab8:= NULL;
2227: QLTTRAWB.g_seq_tab9:= NULL;
2228: QLTTRAWB.g_seq_tab10:= NULL;
2229: QLTTRAWB.g_seq_tab11:= NULL;
2230: QLTTRAWB.g_seq_tab12:= NULL;
2231: QLTTRAWB.g_seq_tab13:= NULL;

Line 2228: QLTTRAWB.g_seq_tab10:= NULL;

2224: QLTTRAWB.g_seq_tab6:= NULL;
2225: QLTTRAWB.g_seq_tab7:= NULL;
2226: QLTTRAWB.g_seq_tab8:= NULL;
2227: QLTTRAWB.g_seq_tab9:= NULL;
2228: QLTTRAWB.g_seq_tab10:= NULL;
2229: QLTTRAWB.g_seq_tab11:= NULL;
2230: QLTTRAWB.g_seq_tab12:= NULL;
2231: QLTTRAWB.g_seq_tab13:= NULL;
2232: QLTTRAWB.g_seq_tab14:= NULL;

Line 2229: QLTTRAWB.g_seq_tab11:= NULL;

2225: QLTTRAWB.g_seq_tab7:= NULL;
2226: QLTTRAWB.g_seq_tab8:= NULL;
2227: QLTTRAWB.g_seq_tab9:= NULL;
2228: QLTTRAWB.g_seq_tab10:= NULL;
2229: QLTTRAWB.g_seq_tab11:= NULL;
2230: QLTTRAWB.g_seq_tab12:= NULL;
2231: QLTTRAWB.g_seq_tab13:= NULL;
2232: QLTTRAWB.g_seq_tab14:= NULL;
2233: QLTTRAWB.g_seq_tab15:= NULL;

Line 2230: QLTTRAWB.g_seq_tab12:= NULL;

2226: QLTTRAWB.g_seq_tab8:= NULL;
2227: QLTTRAWB.g_seq_tab9:= NULL;
2228: QLTTRAWB.g_seq_tab10:= NULL;
2229: QLTTRAWB.g_seq_tab11:= NULL;
2230: QLTTRAWB.g_seq_tab12:= NULL;
2231: QLTTRAWB.g_seq_tab13:= NULL;
2232: QLTTRAWB.g_seq_tab14:= NULL;
2233: QLTTRAWB.g_seq_tab15:= NULL;
2234: QLTTRAWB.g_plan_id_tab:= NULL;

Line 2231: QLTTRAWB.g_seq_tab13:= NULL;

2227: QLTTRAWB.g_seq_tab9:= NULL;
2228: QLTTRAWB.g_seq_tab10:= NULL;
2229: QLTTRAWB.g_seq_tab11:= NULL;
2230: QLTTRAWB.g_seq_tab12:= NULL;
2231: QLTTRAWB.g_seq_tab13:= NULL;
2232: QLTTRAWB.g_seq_tab14:= NULL;
2233: QLTTRAWB.g_seq_tab15:= NULL;
2234: QLTTRAWB.g_plan_id_tab:= NULL;
2235: QLTTRAWB.g_collection_id_tab:= NULL;

Line 2232: QLTTRAWB.g_seq_tab14:= NULL;

2228: QLTTRAWB.g_seq_tab10:= NULL;
2229: QLTTRAWB.g_seq_tab11:= NULL;
2230: QLTTRAWB.g_seq_tab12:= NULL;
2231: QLTTRAWB.g_seq_tab13:= NULL;
2232: QLTTRAWB.g_seq_tab14:= NULL;
2233: QLTTRAWB.g_seq_tab15:= NULL;
2234: QLTTRAWB.g_plan_id_tab:= NULL;
2235: QLTTRAWB.g_collection_id_tab:= NULL;
2236: QLTTRAWB.g_occurrence_tab:= NULL;

Line 2233: QLTTRAWB.g_seq_tab15:= NULL;

2229: QLTTRAWB.g_seq_tab11:= NULL;
2230: QLTTRAWB.g_seq_tab12:= NULL;
2231: QLTTRAWB.g_seq_tab13:= NULL;
2232: QLTTRAWB.g_seq_tab14:= NULL;
2233: QLTTRAWB.g_seq_tab15:= NULL;
2234: QLTTRAWB.g_plan_id_tab:= NULL;
2235: QLTTRAWB.g_collection_id_tab:= NULL;
2236: QLTTRAWB.g_occurrence_tab:= NULL;
2237: QLTTRAWB.g_txn_header_id_tab:= NULL;

Line 2234: QLTTRAWB.g_plan_id_tab:= NULL;

2230: QLTTRAWB.g_seq_tab12:= NULL;
2231: QLTTRAWB.g_seq_tab13:= NULL;
2232: QLTTRAWB.g_seq_tab14:= NULL;
2233: QLTTRAWB.g_seq_tab15:= NULL;
2234: QLTTRAWB.g_plan_id_tab:= NULL;
2235: QLTTRAWB.g_collection_id_tab:= NULL;
2236: QLTTRAWB.g_occurrence_tab:= NULL;
2237: QLTTRAWB.g_txn_header_id_tab:= NULL;
2238: END reset_sequence_global_arrays;

Line 2235: QLTTRAWB.g_collection_id_tab:= NULL;

2231: QLTTRAWB.g_seq_tab13:= NULL;
2232: QLTTRAWB.g_seq_tab14:= NULL;
2233: QLTTRAWB.g_seq_tab15:= NULL;
2234: QLTTRAWB.g_plan_id_tab:= NULL;
2235: QLTTRAWB.g_collection_id_tab:= NULL;
2236: QLTTRAWB.g_occurrence_tab:= NULL;
2237: QLTTRAWB.g_txn_header_id_tab:= NULL;
2238: END reset_sequence_global_arrays;
2239:

Line 2236: QLTTRAWB.g_occurrence_tab:= NULL;

2232: QLTTRAWB.g_seq_tab14:= NULL;
2233: QLTTRAWB.g_seq_tab15:= NULL;
2234: QLTTRAWB.g_plan_id_tab:= NULL;
2235: QLTTRAWB.g_collection_id_tab:= NULL;
2236: QLTTRAWB.g_occurrence_tab:= NULL;
2237: QLTTRAWB.g_txn_header_id_tab:= NULL;
2238: END reset_sequence_global_arrays;
2239:
2240: PROCEDURE update_record(p_total_rec_count NUMBER) IS

Line 2237: QLTTRAWB.g_txn_header_id_tab:= NULL;

2233: QLTTRAWB.g_seq_tab15:= NULL;
2234: QLTTRAWB.g_plan_id_tab:= NULL;
2235: QLTTRAWB.g_collection_id_tab:= NULL;
2236: QLTTRAWB.g_occurrence_tab:= NULL;
2237: QLTTRAWB.g_txn_header_id_tab:= NULL;
2238: END reset_sequence_global_arrays;
2239:
2240: PROCEDURE update_record(p_total_rec_count NUMBER) IS
2241:

Line 2255: -- SET sequence1 = QLTTRAWB.g_seq_tab1(k),

2251: -- Bulk update done once for all the records in collection
2252:
2253: -- FORALL k IN 1..p_total_rec_count
2254: -- UPDATE qa_results
2255: -- SET sequence1 = QLTTRAWB.g_seq_tab1(k),
2256: -- sequence2 = QLTTRAWB.g_seq_tab2(k),
2257: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2258: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2259: -- sequence5 = QLTTRAWB.g_seq_tab5(k),

Line 2256: -- sequence2 = QLTTRAWB.g_seq_tab2(k),

2252:
2253: -- FORALL k IN 1..p_total_rec_count
2254: -- UPDATE qa_results
2255: -- SET sequence1 = QLTTRAWB.g_seq_tab1(k),
2256: -- sequence2 = QLTTRAWB.g_seq_tab2(k),
2257: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2258: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2259: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2260: -- sequence6 = QLTTRAWB.g_seq_tab6(k),

Line 2257: -- sequence3 = QLTTRAWB.g_seq_tab3(k),

2253: -- FORALL k IN 1..p_total_rec_count
2254: -- UPDATE qa_results
2255: -- SET sequence1 = QLTTRAWB.g_seq_tab1(k),
2256: -- sequence2 = QLTTRAWB.g_seq_tab2(k),
2257: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2258: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2259: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2260: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2261: -- sequence7 = QLTTRAWB.g_seq_tab7(k),

Line 2258: -- sequence4 = QLTTRAWB.g_seq_tab4(k),

2254: -- UPDATE qa_results
2255: -- SET sequence1 = QLTTRAWB.g_seq_tab1(k),
2256: -- sequence2 = QLTTRAWB.g_seq_tab2(k),
2257: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2258: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2259: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2260: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2261: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2262: -- sequence8 = QLTTRAWB.g_seq_tab8(k),

Line 2259: -- sequence5 = QLTTRAWB.g_seq_tab5(k),

2255: -- SET sequence1 = QLTTRAWB.g_seq_tab1(k),
2256: -- sequence2 = QLTTRAWB.g_seq_tab2(k),
2257: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2258: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2259: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2260: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2261: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2262: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2263: -- sequence9 = QLTTRAWB.g_seq_tab9(k),

Line 2260: -- sequence6 = QLTTRAWB.g_seq_tab6(k),

2256: -- sequence2 = QLTTRAWB.g_seq_tab2(k),
2257: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2258: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2259: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2260: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2261: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2262: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2263: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2264: -- sequence10 = QLTTRAWB.g_seq_tab10(k),

Line 2261: -- sequence7 = QLTTRAWB.g_seq_tab7(k),

2257: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2258: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2259: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2260: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2261: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2262: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2263: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2264: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2265: -- sequence11 = QLTTRAWB.g_seq_tab11(k),

Line 2262: -- sequence8 = QLTTRAWB.g_seq_tab8(k),

2258: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2259: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2260: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2261: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2262: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2263: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2264: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2265: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2266: -- sequence12 = QLTTRAWB.g_seq_tab12(k),

Line 2263: -- sequence9 = QLTTRAWB.g_seq_tab9(k),

2259: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2260: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2261: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2262: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2263: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2264: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2265: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2266: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2267: -- sequence13 = QLTTRAWB.g_seq_tab13(k),

Line 2264: -- sequence10 = QLTTRAWB.g_seq_tab10(k),

2260: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2261: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2262: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2263: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2264: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2265: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2266: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2267: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2268: -- sequence14 = QLTTRAWB.g_seq_tab14(k),

Line 2265: -- sequence11 = QLTTRAWB.g_seq_tab11(k),

2261: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2262: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2263: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2264: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2265: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2266: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2267: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2268: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2269: -- sequence15 = QLTTRAWB.g_seq_tab15(k)

Line 2266: -- sequence12 = QLTTRAWB.g_seq_tab12(k),

2262: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2263: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2264: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2265: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2266: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2267: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2268: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2269: -- sequence15 = QLTTRAWB.g_seq_tab15(k)
2270: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND

Line 2267: -- sequence13 = QLTTRAWB.g_seq_tab13(k),

2263: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2264: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2265: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2266: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2267: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2268: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2269: -- sequence15 = QLTTRAWB.g_seq_tab15(k)
2270: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND
2271: -- collection_id = QLTTRAWB.g_collection_id_tab(k) AND

Line 2268: -- sequence14 = QLTTRAWB.g_seq_tab14(k),

2264: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2265: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2266: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2267: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2268: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2269: -- sequence15 = QLTTRAWB.g_seq_tab15(k)
2270: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND
2271: -- collection_id = QLTTRAWB.g_collection_id_tab(k) AND
2272: -- occurrence = QLTTRAWB.g_occurrence_tab(k);

Line 2269: -- sequence15 = QLTTRAWB.g_seq_tab15(k)

2265: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2266: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2267: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2268: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2269: -- sequence15 = QLTTRAWB.g_seq_tab15(k)
2270: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND
2271: -- collection_id = QLTTRAWB.g_collection_id_tab(k) AND
2272: -- occurrence = QLTTRAWB.g_occurrence_tab(k);
2273:

Line 2270: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND

2266: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2267: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2268: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2269: -- sequence15 = QLTTRAWB.g_seq_tab15(k)
2270: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND
2271: -- collection_id = QLTTRAWB.g_collection_id_tab(k) AND
2272: -- occurrence = QLTTRAWB.g_occurrence_tab(k);
2273:
2274: --

Line 2271: -- collection_id = QLTTRAWB.g_collection_id_tab(k) AND

2267: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2268: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2269: -- sequence15 = QLTTRAWB.g_seq_tab15(k)
2270: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND
2271: -- collection_id = QLTTRAWB.g_collection_id_tab(k) AND
2272: -- occurrence = QLTTRAWB.g_occurrence_tab(k);
2273:
2274: --
2275: -- Bug 5114865

Line 2272: -- occurrence = QLTTRAWB.g_occurrence_tab(k);

2268: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2269: -- sequence15 = QLTTRAWB.g_seq_tab15(k)
2270: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND
2271: -- collection_id = QLTTRAWB.g_collection_id_tab(k) AND
2272: -- occurrence = QLTTRAWB.g_occurrence_tab(k);
2273:
2274: --
2275: -- Bug 5114865
2276: -- Updating the data for the Seq Type elements

Line 2282: SET sequence1 = QLTTRAWB.g_seq_tab1(g_true_seq_gen_recids(k)),

2278: --
2279: FOR k in 1..g_true_seq_gen_recids.COUNT
2280: LOOP
2281: UPDATE qa_results
2282: SET sequence1 = QLTTRAWB.g_seq_tab1(g_true_seq_gen_recids(k)),
2283: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),
2284: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2285: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2286: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),

Line 2283: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),

2279: FOR k in 1..g_true_seq_gen_recids.COUNT
2280: LOOP
2281: UPDATE qa_results
2282: SET sequence1 = QLTTRAWB.g_seq_tab1(g_true_seq_gen_recids(k)),
2283: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),
2284: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2285: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2286: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2287: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),

Line 2284: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),

2280: LOOP
2281: UPDATE qa_results
2282: SET sequence1 = QLTTRAWB.g_seq_tab1(g_true_seq_gen_recids(k)),
2283: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),
2284: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2285: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2286: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2287: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2288: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),

Line 2285: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),

2281: UPDATE qa_results
2282: SET sequence1 = QLTTRAWB.g_seq_tab1(g_true_seq_gen_recids(k)),
2283: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),
2284: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2285: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2286: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2287: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2288: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2289: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),

Line 2286: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),

2282: SET sequence1 = QLTTRAWB.g_seq_tab1(g_true_seq_gen_recids(k)),
2283: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),
2284: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2285: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2286: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2287: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2288: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2289: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2290: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),

Line 2287: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),

2283: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),
2284: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2285: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2286: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2287: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2288: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2289: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2290: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2291: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),

Line 2288: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),

2284: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2285: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2286: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2287: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2288: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2289: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2290: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2291: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2292: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),

Line 2289: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),

2285: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2286: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2287: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2288: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2289: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2290: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2291: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2292: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2293: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),

Line 2290: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),

2286: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2287: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2288: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2289: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2290: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2291: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2292: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2293: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2294: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),

Line 2291: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),

2287: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2288: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2289: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2290: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2291: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2292: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2293: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2294: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2295: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),

Line 2292: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),

2288: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2289: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2290: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2291: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2292: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2293: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2294: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2295: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2296: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))

Line 2293: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),

2289: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2290: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2291: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2292: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2293: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2294: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2295: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2296: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))
2297: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND

Line 2294: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),

2290: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2291: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2292: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2293: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2294: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2295: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2296: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))
2297: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND
2298: collection_id = QLTTRAWB.g_collection_id_tab(g_true_seq_gen_recids(k)) AND

Line 2295: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),

2291: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2292: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2293: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2294: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2295: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2296: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))
2297: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND
2298: collection_id = QLTTRAWB.g_collection_id_tab(g_true_seq_gen_recids(k)) AND
2299: occurrence = QLTTRAWB.g_occurrence_tab(g_true_seq_gen_recids(k));

Line 2296: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))

2292: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2293: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2294: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2295: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2296: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))
2297: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND
2298: collection_id = QLTTRAWB.g_collection_id_tab(g_true_seq_gen_recids(k)) AND
2299: occurrence = QLTTRAWB.g_occurrence_tab(g_true_seq_gen_recids(k));
2300: END LOOP;

Line 2297: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND

2293: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2294: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2295: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2296: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))
2297: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND
2298: collection_id = QLTTRAWB.g_collection_id_tab(g_true_seq_gen_recids(k)) AND
2299: occurrence = QLTTRAWB.g_occurrence_tab(g_true_seq_gen_recids(k));
2300: END LOOP;
2301:

Line 2298: collection_id = QLTTRAWB.g_collection_id_tab(g_true_seq_gen_recids(k)) AND

2294: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2295: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2296: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))
2297: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND
2298: collection_id = QLTTRAWB.g_collection_id_tab(g_true_seq_gen_recids(k)) AND
2299: occurrence = QLTTRAWB.g_occurrence_tab(g_true_seq_gen_recids(k));
2300: END LOOP;
2301:
2302: -- Bug 5114865

Line 2299: occurrence = QLTTRAWB.g_occurrence_tab(g_true_seq_gen_recids(k));

2295: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2296: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))
2297: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND
2298: collection_id = QLTTRAWB.g_collection_id_tab(g_true_seq_gen_recids(k)) AND
2299: occurrence = QLTTRAWB.g_occurrence_tab(g_true_seq_gen_recids(k));
2300: END LOOP;
2301:
2302: -- Bug 5114865
2303: -- Updating the data for the Seq->Char elem relations

Line 2492: QLTTRAWB.init_seq_table(l_row_count);

2488: BEGIN
2489: l_row_count := p_occurrences.COUNT;
2490:
2491: -- initialize all collection objects.
2492: QLTTRAWB.init_seq_table(l_row_count);
2493:
2494: i := p_occurrences.FIRST;
2495: WHILE i IS NOT NULL LOOP
2496:

Line 2506: QLTTRAWB.g_occurrence_tab(l_count), QLTTRAWB.g_collection_id_tab(l_count),

2502: sequence7,sequence8,sequence9,
2503: sequence10,sequence11,sequence12,
2504: sequence13,sequence14,sequence15
2505: INTO
2506: QLTTRAWB.g_occurrence_tab(l_count), QLTTRAWB.g_collection_id_tab(l_count),
2507: QLTTRAWB.g_plan_id_tab(l_count), QLTTRAWB.g_txn_header_id_tab(l_count),
2508: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),
2509: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2510: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),

Line 2507: QLTTRAWB.g_plan_id_tab(l_count), QLTTRAWB.g_txn_header_id_tab(l_count),

2503: sequence10,sequence11,sequence12,
2504: sequence13,sequence14,sequence15
2505: INTO
2506: QLTTRAWB.g_occurrence_tab(l_count), QLTTRAWB.g_collection_id_tab(l_count),
2507: QLTTRAWB.g_plan_id_tab(l_count), QLTTRAWB.g_txn_header_id_tab(l_count),
2508: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),
2509: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2510: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),
2511: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),

Line 2508: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),

2504: sequence13,sequence14,sequence15
2505: INTO
2506: QLTTRAWB.g_occurrence_tab(l_count), QLTTRAWB.g_collection_id_tab(l_count),
2507: QLTTRAWB.g_plan_id_tab(l_count), QLTTRAWB.g_txn_header_id_tab(l_count),
2508: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),
2509: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2510: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),
2511: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),
2512: QLTTRAWB.g_seq_tab13(l_count), QLTTRAWB.g_seq_tab14(l_count), QLTTRAWB.g_seq_tab15(l_count)

Line 2509: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),

2505: INTO
2506: QLTTRAWB.g_occurrence_tab(l_count), QLTTRAWB.g_collection_id_tab(l_count),
2507: QLTTRAWB.g_plan_id_tab(l_count), QLTTRAWB.g_txn_header_id_tab(l_count),
2508: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),
2509: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2510: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),
2511: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),
2512: QLTTRAWB.g_seq_tab13(l_count), QLTTRAWB.g_seq_tab14(l_count), QLTTRAWB.g_seq_tab15(l_count)
2513: FROM qa_results

Line 2510: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),

2506: QLTTRAWB.g_occurrence_tab(l_count), QLTTRAWB.g_collection_id_tab(l_count),
2507: QLTTRAWB.g_plan_id_tab(l_count), QLTTRAWB.g_txn_header_id_tab(l_count),
2508: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),
2509: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2510: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),
2511: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),
2512: QLTTRAWB.g_seq_tab13(l_count), QLTTRAWB.g_seq_tab14(l_count), QLTTRAWB.g_seq_tab15(l_count)
2513: FROM qa_results
2514: WHERE plan_id = p_plan_ids(i) AND

Line 2511: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),

2507: QLTTRAWB.g_plan_id_tab(l_count), QLTTRAWB.g_txn_header_id_tab(l_count),
2508: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),
2509: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2510: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),
2511: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),
2512: QLTTRAWB.g_seq_tab13(l_count), QLTTRAWB.g_seq_tab14(l_count), QLTTRAWB.g_seq_tab15(l_count)
2513: FROM qa_results
2514: WHERE plan_id = p_plan_ids(i) AND
2515: collection_id = p_collection_ids(i) AND

Line 2512: QLTTRAWB.g_seq_tab13(l_count), QLTTRAWB.g_seq_tab14(l_count), QLTTRAWB.g_seq_tab15(l_count)

2508: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),
2509: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2510: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),
2511: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),
2512: QLTTRAWB.g_seq_tab13(l_count), QLTTRAWB.g_seq_tab14(l_count), QLTTRAWB.g_seq_tab15(l_count)
2513: FROM qa_results
2514: WHERE plan_id = p_plan_ids(i) AND
2515: collection_id = p_collection_ids(i) AND
2516: occurrence = p_occurrences(i);

Line 2588: FOR j IN 1..QLTTRAWB.g_occurrence_tab.count LOOP

2584: l_user_id := fnd_global.user_id;
2585: l_login_id := fnd_global.login_id;
2586: l_date := SYSDATE;
2587:
2588: FOR j IN 1..QLTTRAWB.g_occurrence_tab.count LOOP
2589:
2590: IF QLTTRAWB.g_occurrence_tab(j) = p_occurrence THEN
2591: l_cur_rec_indicator := j;
2592: END IF;

Line 2590: IF QLTTRAWB.g_occurrence_tab(j) = p_occurrence THEN

2586: l_date := SYSDATE;
2587:
2588: FOR j IN 1..QLTTRAWB.g_occurrence_tab.count LOOP
2589:
2590: IF QLTTRAWB.g_occurrence_tab(j) = p_occurrence THEN
2591: l_cur_rec_indicator := j;
2592: END IF;
2593: END LOOP;
2594:

Line 2618: p_txn_header_id => QLTTRAWB.g_txn_header_id_tab(l_cur_rec_indicator),

2614: p_plan_id => p_plan_id,
2615: p_collection_id => p_collection_id,
2616: p_occurrence => p_occurrence,
2617: p_char_id => g_curr_plan_seq_char_ids(i),
2618: p_txn_header_id => QLTTRAWB.g_txn_header_id_tab(l_cur_rec_indicator),
2619: p_sequence_value => l_seq_value,
2620: p_user_id => l_user_id,
2621: p_source_code => 'EQR',
2622: p_source_id => NULL,

Line 2651: p_plan_id => QLTTRAWB.g_plan_id_tab(p_cur_rec_indicator),

2647: l_login_id := fnd_global.login_id;
2648: l_date := SYSDATE;
2649:
2650: sequence_audit_log(
2651: p_plan_id => QLTTRAWB.g_plan_id_tab(p_cur_rec_indicator),
2652: p_collection_id => QLTTRAWB.g_collection_id_tab(p_cur_rec_indicator),
2653: p_occurrence => QLTTRAWB.g_occurrence_tab(p_cur_rec_indicator),
2654: p_char_id => p_char_id,
2655: p_txn_header_id => QLTTRAWB.g_txn_header_id_tab(p_cur_rec_indicator),

Line 2652: p_collection_id => QLTTRAWB.g_collection_id_tab(p_cur_rec_indicator),

2648: l_date := SYSDATE;
2649:
2650: sequence_audit_log(
2651: p_plan_id => QLTTRAWB.g_plan_id_tab(p_cur_rec_indicator),
2652: p_collection_id => QLTTRAWB.g_collection_id_tab(p_cur_rec_indicator),
2653: p_occurrence => QLTTRAWB.g_occurrence_tab(p_cur_rec_indicator),
2654: p_char_id => p_char_id,
2655: p_txn_header_id => QLTTRAWB.g_txn_header_id_tab(p_cur_rec_indicator),
2656: p_sequence_value => p_seq_value,

Line 2653: p_occurrence => QLTTRAWB.g_occurrence_tab(p_cur_rec_indicator),

2649:
2650: sequence_audit_log(
2651: p_plan_id => QLTTRAWB.g_plan_id_tab(p_cur_rec_indicator),
2652: p_collection_id => QLTTRAWB.g_collection_id_tab(p_cur_rec_indicator),
2653: p_occurrence => QLTTRAWB.g_occurrence_tab(p_cur_rec_indicator),
2654: p_char_id => p_char_id,
2655: p_txn_header_id => QLTTRAWB.g_txn_header_id_tab(p_cur_rec_indicator),
2656: p_sequence_value => p_seq_value,
2657: p_user_id => l_user_id,

Line 2655: p_txn_header_id => QLTTRAWB.g_txn_header_id_tab(p_cur_rec_indicator),

2651: p_plan_id => QLTTRAWB.g_plan_id_tab(p_cur_rec_indicator),
2652: p_collection_id => QLTTRAWB.g_collection_id_tab(p_cur_rec_indicator),
2653: p_occurrence => QLTTRAWB.g_occurrence_tab(p_cur_rec_indicator),
2654: p_char_id => p_char_id,
2655: p_txn_header_id => QLTTRAWB.g_txn_header_id_tab(p_cur_rec_indicator),
2656: p_sequence_value => p_seq_value,
2657: p_user_id => l_user_id,
2658: p_source_code => 'EDR', -- ERES
2659: p_source_id => NULL, -- eRes ID not generated at this time

Line 2970: p_plan_id => qlttrawb.g_plan_id_tab(p_cur_rec_indicator),

2966: || ' Seq val = ' || p_seq_value);
2967: END IF;
2968:
2969: sequence_audit_log(
2970: p_plan_id => qlttrawb.g_plan_id_tab(p_cur_rec_indicator),
2971: p_collection_id => qlttrawb.g_collection_id_tab(p_cur_rec_indicator),
2972: p_occurrence => qlttrawb.g_occurrence_tab(p_cur_rec_indicator),
2973: p_char_id => p_char_id,
2974: p_txn_header_id => qlttrawb.g_txn_header_id_tab(p_cur_rec_indicator),

Line 2971: p_collection_id => qlttrawb.g_collection_id_tab(p_cur_rec_indicator),

2967: END IF;
2968:
2969: sequence_audit_log(
2970: p_plan_id => qlttrawb.g_plan_id_tab(p_cur_rec_indicator),
2971: p_collection_id => qlttrawb.g_collection_id_tab(p_cur_rec_indicator),
2972: p_occurrence => qlttrawb.g_occurrence_tab(p_cur_rec_indicator),
2973: p_char_id => p_char_id,
2974: p_txn_header_id => qlttrawb.g_txn_header_id_tab(p_cur_rec_indicator),
2975: p_sequence_value => p_seq_value,

Line 2972: p_occurrence => qlttrawb.g_occurrence_tab(p_cur_rec_indicator),

2968:
2969: sequence_audit_log(
2970: p_plan_id => qlttrawb.g_plan_id_tab(p_cur_rec_indicator),
2971: p_collection_id => qlttrawb.g_collection_id_tab(p_cur_rec_indicator),
2972: p_occurrence => qlttrawb.g_occurrence_tab(p_cur_rec_indicator),
2973: p_char_id => p_char_id,
2974: p_txn_header_id => qlttrawb.g_txn_header_id_tab(p_cur_rec_indicator),
2975: p_sequence_value => p_seq_value,
2976: p_user_id => l_user_id,

Line 2974: p_txn_header_id => qlttrawb.g_txn_header_id_tab(p_cur_rec_indicator),

2970: p_plan_id => qlttrawb.g_plan_id_tab(p_cur_rec_indicator),
2971: p_collection_id => qlttrawb.g_collection_id_tab(p_cur_rec_indicator),
2972: p_occurrence => qlttrawb.g_occurrence_tab(p_cur_rec_indicator),
2973: p_char_id => p_char_id,
2974: p_txn_header_id => qlttrawb.g_txn_header_id_tab(p_cur_rec_indicator),
2975: p_sequence_value => p_seq_value,
2976: p_user_id => l_user_id,
2977: p_source_code => p_module, -- OA Transaction Integration /Mobile
2978: p_source_id => NULL, -- Parent transaction not committed till this time