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 684: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,

680: -- bulk fetch all the records into corresponding plsql tables
681: -- this is called from transaction mode
682:
683: FETCH coll_cur BULK COLLECT INTO
684: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
685: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
686: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
687: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
688: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,

Line 685: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,

681: -- this is called from transaction mode
682:
683: FETCH coll_cur BULK COLLECT INTO
684: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
685: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
686: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
687: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
688: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
689: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,

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

682:
683: FETCH coll_cur BULK COLLECT INTO
684: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
685: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
686: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
687: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
688: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
689: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
690: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;

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

683: FETCH coll_cur BULK COLLECT INTO
684: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
685: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
686: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
687: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
688: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
689: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
690: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
691:

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

684: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
685: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
686: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
687: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
688: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
689: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
690: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
691:
692: l_row_count := coll_cur%ROWCOUNT;

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

685: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
686: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
687: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
688: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
689: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
690: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
691:
692: l_row_count := coll_cur%ROWCOUNT;
693: CLOSE coll_cur;

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

686: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
687: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
688: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
689: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
690: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
691:
692: l_row_count := coll_cur%ROWCOUNT;
693: CLOSE coll_cur;
694:

Line 701: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,

697: -- bulk fetch all the records into corresponding plsql tables
698: -- this is called from direct data entry mode
699:
700: FETCH txn_cur BULK COLLECT INTO
701: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
702: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
703: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
704: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
705: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,

Line 702: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,

698: -- this is called from direct data entry mode
699:
700: FETCH txn_cur BULK COLLECT INTO
701: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
702: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
703: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
704: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
705: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
706: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,

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

699:
700: FETCH txn_cur BULK COLLECT INTO
701: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
702: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
703: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
704: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
705: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
706: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
707: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;

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

700: FETCH txn_cur BULK COLLECT INTO
701: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
702: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
703: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
704: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
705: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
706: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
707: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
708:

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

701: QLTTRAWB.g_occurrence_tab, QLTTRAWB.g_collection_id_tab,
702: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
703: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
704: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
705: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
706: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
707: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
708:
709: l_row_count := txn_cur%ROWCOUNT;

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

702: QLTTRAWB.g_plan_id_tab, QLTTRAWB.g_txn_header_id_tab,
703: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
704: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
705: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
706: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
707: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
708:
709: l_row_count := txn_cur%ROWCOUNT;
710: CLOSE txn_cur;

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

703: QLTTRAWB.g_seq_tab1, QLTTRAWB.g_seq_tab2, QLTTRAWB.g_seq_tab3,
704: QLTTRAWB.g_seq_tab4, QLTTRAWB.g_seq_tab5, QLTTRAWB.g_seq_tab6,
705: QLTTRAWB.g_seq_tab7, QLTTRAWB.g_seq_tab8, QLTTRAWB.g_seq_tab9,
706: QLTTRAWB.g_seq_tab10,QLTTRAWB.g_seq_tab11, QLTTRAWB.g_seq_tab12,
707: QLTTRAWB.g_seq_tab13,QLTTRAWB.g_seq_tab14, QLTTRAWB.g_seq_tab15;
708:
709: l_row_count := txn_cur%ROWCOUNT;
710: CLOSE txn_cur;
711:

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

1190: parentChildCntr PLS_INTEGER := 1;
1191:
1192: BEGIN
1193:
1194: FOR i IN 1..QLTTRAWB.g_occurrence_tab.count LOOP
1195:
1196: -- Find out the position of parent and/or child record in the plsql table
1197: -- by looping through the G_OCCURRENCE and store it in rec. indicator.
1198:

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

1196: -- Find out the position of parent and/or child record in the plsql table
1197: -- by looping through the G_OCCURRENCE and store it in rec. indicator.
1198:
1199: IF (p_parent_plan_id IS NOT NULL AND
1200: QLTTRAWB.g_occurrence_tab(i) = p_parent_occurrence) THEN
1201:
1202: l_parent_rec_indicator := i;
1203:
1204: ELSIF QLTTRAWB.g_occurrence_tab(i) = p_occurrence THEN -- for child record

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

1200: QLTTRAWB.g_occurrence_tab(i) = p_parent_occurrence) THEN
1201:
1202: l_parent_rec_indicator := i;
1203:
1204: ELSIF QLTTRAWB.g_occurrence_tab(i) = p_occurrence THEN -- for child record
1205: l_cur_rec_indicator := i;
1206: END IF;
1207:
1208: END LOOP;

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

1227:
1228: -- Generate new seq. value for parent rec. sequence elements or for child rec.
1229: -- sequence element which doesnt have any seq copy relation with parent rec.
1230:
1231: -- In the QLTTRAWB.g_seq_tab1..15 if any value is 'Automatic' means that new seq. number
1232: -- needs to be generated.
1233:
1234: -- For normal datacollection, generated only the sequence values for all the elements in
1235: -- the plan. But in eRes enabled txn, generated and capture the audit information at the

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

1237:
1238: l_seq_default_value := get_sequence_default_value();
1239: l_eres_enabled := get_eres_profile();
1240:
1241: IF NVL(QLTTRAWB.g_seq_tab1(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1242: l_char_id := g_curr_plan_seq_char_ids(1);
1243:
1244: --
1245: -- Bug 5228667

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

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

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

1290:
1291: END IF;
1292:
1293:
1294: IF NVL(QLTTRAWB.g_seq_tab2(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1295: l_char_id := g_curr_plan_seq_char_ids(2);
1296:
1297: --
1298: -- Bug 5228667

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

1311: l_char_id);
1312: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1313: End if;
1314:
1315: QLTTRAWB.g_seq_tab2(l_cur_rec_indicator) := l_seq_value;
1316:
1317: --
1318: -- Bug 5228667
1319: -- if ERES Txn is being resubmitted then the Seq

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

1337: -- Bug 3160651.
1338: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1339: END IF;
1340:
1341: IF NVL(QLTTRAWB.g_seq_tab3(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1342: l_char_id := g_curr_plan_seq_char_ids(3);
1343:
1344: --
1345: -- Bug 5228667

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

1358: l_char_id);
1359: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1360: End if;
1361:
1362: QLTTRAWB.g_seq_tab3(l_cur_rec_indicator) := l_seq_value;
1363:
1364: --
1365: -- Bug 5228667
1366: -- if ERES Txn is being resubmitted then the Seq

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

1385: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1386:
1387: END IF;
1388:
1389: IF NVL(QLTTRAWB.g_seq_tab4(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1390: l_char_id := g_curr_plan_seq_char_ids(4);
1391:
1392: --
1393: -- Bug 5228667

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

1406: l_char_id);
1407: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1408: End if;
1409:
1410: QLTTRAWB.g_seq_tab4(l_cur_rec_indicator) := l_seq_value;
1411:
1412: --
1413: -- Bug 5228667
1414: -- if ERES Txn is being resubmitted then the Seq

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

1433: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1434:
1435: END IF;
1436:
1437: IF NVL(QLTTRAWB.g_seq_tab5(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1438: l_char_id := g_curr_plan_seq_char_ids(5);
1439:
1440: --
1441: -- Bug 5228667

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

1454: l_char_id);
1455: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1456: End if;
1457:
1458: QLTTRAWB.g_seq_tab5(l_cur_rec_indicator) := l_seq_value;
1459:
1460: --
1461: -- Bug 5228667
1462: -- if ERES Txn is being resubmitted then the Seq

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

1481: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1482:
1483: END IF;
1484:
1485: IF NVL(QLTTRAWB.g_seq_tab6(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1486: l_char_id := g_curr_plan_seq_char_ids(6);
1487:
1488: --
1489: -- Bug 5228667

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

1502: l_char_id);
1503: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1504: End if;
1505:
1506: QLTTRAWB.g_seq_tab6(l_cur_rec_indicator) := l_seq_value;
1507:
1508: --
1509: -- Bug 5228667
1510: -- if ERES Txn is being resubmitted then the Seq

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

1529: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1530:
1531: END IF;
1532:
1533: IF NVL(QLTTRAWB.g_seq_tab7(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1534: l_char_id := g_curr_plan_seq_char_ids(7);
1535:
1536: --
1537: -- Bug 5228667

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

1550: l_char_id);
1551: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1552: End if;
1553:
1554: QLTTRAWB.g_seq_tab7(l_cur_rec_indicator) := l_seq_value;
1555:
1556: --
1557: -- Bug 5228667
1558: -- if ERES Txn is being resubmitted then the Seq

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

1577: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1578:
1579: END IF;
1580:
1581: IF NVL(QLTTRAWB.g_seq_tab8(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1582: l_char_id := g_curr_plan_seq_char_ids(8);
1583:
1584: --
1585: -- Bug 5228667

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

1598: l_char_id);
1599: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1600: End if;
1601:
1602: QLTTRAWB.g_seq_tab8(l_cur_rec_indicator) := l_seq_value;
1603:
1604: --
1605: -- Bug 5228667
1606: -- if ERES Txn is being resubmitted then the Seq

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

1625: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1626:
1627: END IF;
1628:
1629: IF NVL(QLTTRAWB.g_seq_tab9(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1630: l_char_id := g_curr_plan_seq_char_ids(9);
1631:
1632: --
1633: -- Bug 5228667

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

1646: l_char_id);
1647: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1648: End if;
1649:
1650: QLTTRAWB.g_seq_tab9(l_cur_rec_indicator) := l_seq_value;
1651:
1652: --
1653: -- Bug 5228667
1654: -- if ERES Txn is being resubmitted then the Seq

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

1673: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1674:
1675: END IF;
1676:
1677: IF NVL(QLTTRAWB.g_seq_tab10(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1678: l_char_id := g_curr_plan_seq_char_ids(10);
1679:
1680: --
1681: -- Bug 5228667

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

1694: l_char_id);
1695: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1696: End if;
1697:
1698: QLTTRAWB.g_seq_tab10(l_cur_rec_indicator) := l_seq_value;
1699:
1700: --
1701: -- Bug 5228667
1702: -- if ERES Txn is being resubmitted then the Seq

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

1722:
1723: END IF;
1724:
1725:
1726: IF NVL(QLTTRAWB.g_seq_tab11(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1727: l_char_id := g_curr_plan_seq_char_ids(11);
1728:
1729: --
1730: -- Bug 5228667

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

1743: l_char_id);
1744: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1745: End if;
1746:
1747: QLTTRAWB.g_seq_tab11(l_cur_rec_indicator) := l_seq_value;
1748:
1749: --
1750: -- Bug 5228667
1751: -- if ERES Txn is being resubmitted then the Seq

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

1770: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1771:
1772: END IF;
1773:
1774: IF NVL(QLTTRAWB.g_seq_tab12(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1775: l_char_id := g_curr_plan_seq_char_ids(12);
1776:
1777: --
1778: -- Bug 5228667

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

1791: l_char_id);
1792: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1793: End if;
1794:
1795: QLTTRAWB.g_seq_tab12(l_cur_rec_indicator) := l_seq_value;
1796:
1797: --
1798: -- Bug 5228667
1799: -- if ERES Txn is being resubmitted then the Seq

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

1818: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1819:
1820: END IF;
1821:
1822: IF NVL(QLTTRAWB.g_seq_tab13(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1823: l_char_id := g_curr_plan_seq_char_ids(13);
1824:
1825: --
1826: -- Bug 5228667

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

1839: l_char_id);
1840: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1841: End if;
1842:
1843: QLTTRAWB.g_seq_tab13(l_cur_rec_indicator) := l_seq_value;
1844:
1845: --
1846: -- Bug 5228667
1847: -- if ERES Txn is being resubmitted then the Seq

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

1866: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1867:
1868: END IF;
1869:
1870: IF NVL(QLTTRAWB.g_seq_tab14(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1871: l_char_id := g_curr_plan_seq_char_ids(14);
1872:
1873: --
1874: -- Bug 5228667

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

1887: l_char_id);
1888: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1889: End if;
1890:
1891: QLTTRAWB.g_seq_tab14(l_cur_rec_indicator) := l_seq_value;
1892:
1893: --
1894: -- Bug 5228667
1895: -- if ERES Txn is being resubmitted then the Seq

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

1914: populate_message_array(l_char_id,l_seq_value,l_plan_name);
1915:
1916: END IF;
1917:
1918: IF NVL(QLTTRAWB.g_seq_tab15(l_cur_rec_indicator),' ') = l_seq_default_value THEN
1919: l_char_id := g_curr_plan_seq_char_ids(15);
1920:
1921: --
1922: -- Bug 5228667

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

1935: l_char_id);
1936: ELSE l_seq_value := get_next_seq(l_char_id,FALSE);
1937: End if;
1938:
1939: QLTTRAWB.g_seq_tab15(l_cur_rec_indicator) := l_seq_value;
1940:
1941: --
1942: -- Bug 5228667
1943: -- if ERES Txn is being resubmitted then the Seq

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

1965:
1966: --
1967: -- Bug 5114865
1968: -- Collect the indexes for the Seq Type elements
1969: -- to be read from the the QLTTRAWB.g_seq_tabX array
1970: -- ntungare Sun Apr 9 23:40:46 PDT 2006
1971: If g_curr_plan_seq_char_ids.COUNT <> 0
1972: THEN
1973: g_true_seq_gen_recids(NVL(g_true_seq_gen_recids.LAST,0)+1) := l_cur_rec_indicator;

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

2001:
2002: -- First pack all the char_id of the seq. element in the plan into x_seq_char_ids
2003: -- If it is top level parent rec, then dont do anything.
2004: -- If it is child rec and copy relations exist then copy parent seq. value to child
2005: -- seq element in the QLTTRAWB.g_seq_tab1..15 table for the child rec.
2006:
2007: l_seq_value VARCHAR2(30);
2008: i NUMBER;
2009:

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

2152: BEGIN
2153:
2154: IF p_seq_position = 1 THEN
2155: IF p_action = 1 THEN
2156: p_seq_value := QLTTRAWB.g_seq_tab1(p_cur_record_indicator);
2157: ELSE
2158: QLTTRAWB.g_seq_tab1(p_cur_record_indicator):= p_seq_value;
2159: END IF;
2160:

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

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

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

2160:
2161:
2162: ELSIF p_seq_position = 2 THEN
2163: IF p_action = 1 THEN
2164: p_seq_value := QLTTRAWB.g_seq_tab2(p_cur_record_indicator);
2165: ELSE
2166: QLTTRAWB.g_seq_tab2(p_cur_record_indicator):= p_seq_value;
2167: END IF;
2168:

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

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

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

2167: END IF;
2168:
2169: ELSIF p_seq_position = 3 THEN
2170: IF p_action = 1 THEN
2171: p_seq_value := QLTTRAWB.g_seq_tab3(p_cur_record_indicator);
2172: ELSE
2173: QLTTRAWB.g_seq_tab3(p_cur_record_indicator):= p_seq_value;
2174: END IF;
2175:

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

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

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

2174: END IF;
2175:
2176: ELSIF p_seq_position = 4 THEN
2177: IF p_action = 1 THEN
2178: p_seq_value := QLTTRAWB.g_seq_tab4(p_cur_record_indicator);
2179: ELSE
2180: QLTTRAWB.g_seq_tab4( p_cur_record_indicator):= p_seq_value;
2181: END IF;
2182:

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

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

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

2181: END IF;
2182:
2183: ELSIF p_seq_position = 5 THEN
2184: IF p_action = 1 THEN
2185: p_seq_value := QLTTRAWB.g_seq_tab5(p_cur_record_indicator);
2186: ELSE
2187: QLTTRAWB.g_seq_tab5(p_cur_record_indicator):= p_seq_value;
2188: END IF;
2189:

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

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

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

2188: END IF;
2189:
2190: ELSIF p_seq_position = 6 THEN
2191: IF p_action = 1 THEN
2192: p_seq_value := QLTTRAWB.g_seq_tab6(p_cur_record_indicator);
2193: ELSE
2194: QLTTRAWB.g_seq_tab6(p_cur_record_indicator):= p_seq_value;
2195: END IF;
2196:

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

2190: ELSIF p_seq_position = 6 THEN
2191: IF p_action = 1 THEN
2192: p_seq_value := QLTTRAWB.g_seq_tab6(p_cur_record_indicator);
2193: ELSE
2194: QLTTRAWB.g_seq_tab6(p_cur_record_indicator):= p_seq_value;
2195: END IF;
2196:
2197: ELSIF p_seq_position = 7 THEN
2198: IF p_action = 1 THEN

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

2195: END IF;
2196:
2197: ELSIF p_seq_position = 7 THEN
2198: IF p_action = 1 THEN
2199: p_seq_value := QLTTRAWB.g_seq_tab7(p_cur_record_indicator);
2200: ELSE
2201: QLTTRAWB.g_seq_tab7(p_cur_record_indicator):= p_seq_value;
2202: END IF;
2203:

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

2197: ELSIF p_seq_position = 7 THEN
2198: IF p_action = 1 THEN
2199: p_seq_value := QLTTRAWB.g_seq_tab7(p_cur_record_indicator);
2200: ELSE
2201: QLTTRAWB.g_seq_tab7(p_cur_record_indicator):= p_seq_value;
2202: END IF;
2203:
2204: ELSIF p_seq_position = 8 THEN
2205: IF p_action = 1 THEN

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

2202: END IF;
2203:
2204: ELSIF p_seq_position = 8 THEN
2205: IF p_action = 1 THEN
2206: p_seq_value := QLTTRAWB.g_seq_tab8(p_cur_record_indicator);
2207: ELSE
2208: QLTTRAWB.g_seq_tab8(p_cur_record_indicator):= p_seq_value;
2209: END IF;
2210:

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

2204: ELSIF p_seq_position = 8 THEN
2205: IF p_action = 1 THEN
2206: p_seq_value := QLTTRAWB.g_seq_tab8(p_cur_record_indicator);
2207: ELSE
2208: QLTTRAWB.g_seq_tab8(p_cur_record_indicator):= p_seq_value;
2209: END IF;
2210:
2211: ELSIF p_seq_position = 9 THEN
2212: IF p_action = 1 THEN

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

2209: END IF;
2210:
2211: ELSIF p_seq_position = 9 THEN
2212: IF p_action = 1 THEN
2213: p_seq_value := QLTTRAWB.g_seq_tab9(p_cur_record_indicator);
2214: ELSE
2215: QLTTRAWB.g_seq_tab9(p_cur_record_indicator):= p_seq_value;
2216: END IF;
2217:

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

2211: ELSIF p_seq_position = 9 THEN
2212: IF p_action = 1 THEN
2213: p_seq_value := QLTTRAWB.g_seq_tab9(p_cur_record_indicator);
2214: ELSE
2215: QLTTRAWB.g_seq_tab9(p_cur_record_indicator):= p_seq_value;
2216: END IF;
2217:
2218: ELSIF p_seq_position = 10 THEN
2219: IF p_action = 1 THEN

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

2216: END IF;
2217:
2218: ELSIF p_seq_position = 10 THEN
2219: IF p_action = 1 THEN
2220: p_seq_value := QLTTRAWB.g_seq_tab10(p_cur_record_indicator);
2221: ELSE
2222: QLTTRAWB.g_seq_tab10(p_cur_record_indicator):= p_seq_value;
2223: END IF;
2224:

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

2218: ELSIF p_seq_position = 10 THEN
2219: IF p_action = 1 THEN
2220: p_seq_value := QLTTRAWB.g_seq_tab10(p_cur_record_indicator);
2221: ELSE
2222: QLTTRAWB.g_seq_tab10(p_cur_record_indicator):= p_seq_value;
2223: END IF;
2224:
2225: ELSIF p_seq_position = 11 THEN
2226: IF p_action = 1 THEN

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

2223: END IF;
2224:
2225: ELSIF p_seq_position = 11 THEN
2226: IF p_action = 1 THEN
2227: p_seq_value := QLTTRAWB.g_seq_tab11(p_cur_record_indicator);
2228: ELSE
2229: QLTTRAWB.g_seq_tab11(p_cur_record_indicator):= p_seq_value;
2230: END IF;
2231:

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

2225: ELSIF p_seq_position = 11 THEN
2226: IF p_action = 1 THEN
2227: p_seq_value := QLTTRAWB.g_seq_tab11(p_cur_record_indicator);
2228: ELSE
2229: QLTTRAWB.g_seq_tab11(p_cur_record_indicator):= p_seq_value;
2230: END IF;
2231:
2232: ELSIF p_seq_position = 12 THEN
2233: IF p_action = 1 THEN

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

2230: END IF;
2231:
2232: ELSIF p_seq_position = 12 THEN
2233: IF p_action = 1 THEN
2234: p_seq_value := QLTTRAWB.g_seq_tab12(p_cur_record_indicator);
2235: ELSE
2236: QLTTRAWB.g_seq_tab12(p_cur_record_indicator):= p_seq_value;
2237: END IF;
2238:

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

2232: ELSIF p_seq_position = 12 THEN
2233: IF p_action = 1 THEN
2234: p_seq_value := QLTTRAWB.g_seq_tab12(p_cur_record_indicator);
2235: ELSE
2236: QLTTRAWB.g_seq_tab12(p_cur_record_indicator):= p_seq_value;
2237: END IF;
2238:
2239: ELSIF p_seq_position = 13 THEN
2240: IF p_action = 1 THEN

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

2237: END IF;
2238:
2239: ELSIF p_seq_position = 13 THEN
2240: IF p_action = 1 THEN
2241: p_seq_value := QLTTRAWB.g_seq_tab13(p_cur_record_indicator);
2242: ELSE
2243: QLTTRAWB.g_seq_tab13(p_cur_record_indicator):= p_seq_value;
2244: END IF;
2245:

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

2239: ELSIF p_seq_position = 13 THEN
2240: IF p_action = 1 THEN
2241: p_seq_value := QLTTRAWB.g_seq_tab13(p_cur_record_indicator);
2242: ELSE
2243: QLTTRAWB.g_seq_tab13(p_cur_record_indicator):= p_seq_value;
2244: END IF;
2245:
2246:
2247: ELSIF p_seq_position = 14 THEN

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

2245:
2246:
2247: ELSIF p_seq_position = 14 THEN
2248: IF p_action = 1 THEN
2249: p_seq_value := QLTTRAWB.g_seq_tab14(p_cur_record_indicator);
2250: ELSE
2251: QLTTRAWB.g_seq_tab14(p_cur_record_indicator):= p_seq_value;
2252: END IF;
2253:

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

2247: ELSIF p_seq_position = 14 THEN
2248: IF p_action = 1 THEN
2249: p_seq_value := QLTTRAWB.g_seq_tab14(p_cur_record_indicator);
2250: ELSE
2251: QLTTRAWB.g_seq_tab14(p_cur_record_indicator):= p_seq_value;
2252: END IF;
2253:
2254: ELSIF p_seq_position = 15 THEN
2255: IF p_action = 1 THEN

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

2252: END IF;
2253:
2254: ELSIF p_seq_position = 15 THEN
2255: IF p_action = 1 THEN
2256: p_seq_value := QLTTRAWB.g_seq_tab15(p_cur_record_indicator);
2257: ELSE
2258: QLTTRAWB.g_seq_tab15(p_cur_record_indicator):= p_seq_value;
2259: END IF;
2260: END IF;

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

2254: ELSIF p_seq_position = 15 THEN
2255: IF p_action = 1 THEN
2256: p_seq_value := QLTTRAWB.g_seq_tab15(p_cur_record_indicator);
2257: ELSE
2258: QLTTRAWB.g_seq_tab15(p_cur_record_indicator):= p_seq_value;
2259: END IF;
2260: END IF;
2261:
2262: END find_update_seq_in_collection;

Line 2273: QLTTRAWB.g_seq_tab1:= NULL;

2269: PROCEDURE reset_sequence_global_arrays AS
2270: BEGIN
2271: g_true_seq_gen_recids.delete;
2272: ParentChild_Tab.delete;
2273: QLTTRAWB.g_seq_tab1:= NULL;
2274: QLTTRAWB.g_seq_tab2:= NULL;
2275: QLTTRAWB.g_seq_tab3:= NULL;
2276: QLTTRAWB.g_seq_tab4:= NULL;
2277: QLTTRAWB.g_seq_tab5:= NULL;

Line 2274: QLTTRAWB.g_seq_tab2:= NULL;

2270: BEGIN
2271: g_true_seq_gen_recids.delete;
2272: ParentChild_Tab.delete;
2273: QLTTRAWB.g_seq_tab1:= NULL;
2274: QLTTRAWB.g_seq_tab2:= NULL;
2275: QLTTRAWB.g_seq_tab3:= NULL;
2276: QLTTRAWB.g_seq_tab4:= NULL;
2277: QLTTRAWB.g_seq_tab5:= NULL;
2278: QLTTRAWB.g_seq_tab6:= NULL;

Line 2275: QLTTRAWB.g_seq_tab3:= NULL;

2271: g_true_seq_gen_recids.delete;
2272: ParentChild_Tab.delete;
2273: QLTTRAWB.g_seq_tab1:= NULL;
2274: QLTTRAWB.g_seq_tab2:= NULL;
2275: QLTTRAWB.g_seq_tab3:= NULL;
2276: QLTTRAWB.g_seq_tab4:= NULL;
2277: QLTTRAWB.g_seq_tab5:= NULL;
2278: QLTTRAWB.g_seq_tab6:= NULL;
2279: QLTTRAWB.g_seq_tab7:= NULL;

Line 2276: QLTTRAWB.g_seq_tab4:= NULL;

2272: ParentChild_Tab.delete;
2273: QLTTRAWB.g_seq_tab1:= NULL;
2274: QLTTRAWB.g_seq_tab2:= NULL;
2275: QLTTRAWB.g_seq_tab3:= NULL;
2276: QLTTRAWB.g_seq_tab4:= NULL;
2277: QLTTRAWB.g_seq_tab5:= NULL;
2278: QLTTRAWB.g_seq_tab6:= NULL;
2279: QLTTRAWB.g_seq_tab7:= NULL;
2280: QLTTRAWB.g_seq_tab8:= NULL;

Line 2277: QLTTRAWB.g_seq_tab5:= NULL;

2273: QLTTRAWB.g_seq_tab1:= NULL;
2274: QLTTRAWB.g_seq_tab2:= NULL;
2275: QLTTRAWB.g_seq_tab3:= NULL;
2276: QLTTRAWB.g_seq_tab4:= NULL;
2277: QLTTRAWB.g_seq_tab5:= NULL;
2278: QLTTRAWB.g_seq_tab6:= NULL;
2279: QLTTRAWB.g_seq_tab7:= NULL;
2280: QLTTRAWB.g_seq_tab8:= NULL;
2281: QLTTRAWB.g_seq_tab9:= NULL;

Line 2278: QLTTRAWB.g_seq_tab6:= NULL;

2274: QLTTRAWB.g_seq_tab2:= NULL;
2275: QLTTRAWB.g_seq_tab3:= NULL;
2276: QLTTRAWB.g_seq_tab4:= NULL;
2277: QLTTRAWB.g_seq_tab5:= NULL;
2278: QLTTRAWB.g_seq_tab6:= NULL;
2279: QLTTRAWB.g_seq_tab7:= NULL;
2280: QLTTRAWB.g_seq_tab8:= NULL;
2281: QLTTRAWB.g_seq_tab9:= NULL;
2282: QLTTRAWB.g_seq_tab10:= NULL;

Line 2279: QLTTRAWB.g_seq_tab7:= NULL;

2275: QLTTRAWB.g_seq_tab3:= NULL;
2276: QLTTRAWB.g_seq_tab4:= NULL;
2277: QLTTRAWB.g_seq_tab5:= NULL;
2278: QLTTRAWB.g_seq_tab6:= NULL;
2279: QLTTRAWB.g_seq_tab7:= NULL;
2280: QLTTRAWB.g_seq_tab8:= NULL;
2281: QLTTRAWB.g_seq_tab9:= NULL;
2282: QLTTRAWB.g_seq_tab10:= NULL;
2283: QLTTRAWB.g_seq_tab11:= NULL;

Line 2280: QLTTRAWB.g_seq_tab8:= NULL;

2276: QLTTRAWB.g_seq_tab4:= NULL;
2277: QLTTRAWB.g_seq_tab5:= NULL;
2278: QLTTRAWB.g_seq_tab6:= NULL;
2279: QLTTRAWB.g_seq_tab7:= NULL;
2280: QLTTRAWB.g_seq_tab8:= NULL;
2281: QLTTRAWB.g_seq_tab9:= NULL;
2282: QLTTRAWB.g_seq_tab10:= NULL;
2283: QLTTRAWB.g_seq_tab11:= NULL;
2284: QLTTRAWB.g_seq_tab12:= NULL;

Line 2281: QLTTRAWB.g_seq_tab9:= NULL;

2277: QLTTRAWB.g_seq_tab5:= NULL;
2278: QLTTRAWB.g_seq_tab6:= NULL;
2279: QLTTRAWB.g_seq_tab7:= NULL;
2280: QLTTRAWB.g_seq_tab8:= NULL;
2281: QLTTRAWB.g_seq_tab9:= NULL;
2282: QLTTRAWB.g_seq_tab10:= NULL;
2283: QLTTRAWB.g_seq_tab11:= NULL;
2284: QLTTRAWB.g_seq_tab12:= NULL;
2285: QLTTRAWB.g_seq_tab13:= NULL;

Line 2282: QLTTRAWB.g_seq_tab10:= NULL;

2278: QLTTRAWB.g_seq_tab6:= NULL;
2279: QLTTRAWB.g_seq_tab7:= NULL;
2280: QLTTRAWB.g_seq_tab8:= NULL;
2281: QLTTRAWB.g_seq_tab9:= NULL;
2282: QLTTRAWB.g_seq_tab10:= NULL;
2283: QLTTRAWB.g_seq_tab11:= NULL;
2284: QLTTRAWB.g_seq_tab12:= NULL;
2285: QLTTRAWB.g_seq_tab13:= NULL;
2286: QLTTRAWB.g_seq_tab14:= NULL;

Line 2283: QLTTRAWB.g_seq_tab11:= NULL;

2279: QLTTRAWB.g_seq_tab7:= NULL;
2280: QLTTRAWB.g_seq_tab8:= NULL;
2281: QLTTRAWB.g_seq_tab9:= NULL;
2282: QLTTRAWB.g_seq_tab10:= NULL;
2283: QLTTRAWB.g_seq_tab11:= NULL;
2284: QLTTRAWB.g_seq_tab12:= NULL;
2285: QLTTRAWB.g_seq_tab13:= NULL;
2286: QLTTRAWB.g_seq_tab14:= NULL;
2287: QLTTRAWB.g_seq_tab15:= NULL;

Line 2284: QLTTRAWB.g_seq_tab12:= NULL;

2280: QLTTRAWB.g_seq_tab8:= NULL;
2281: QLTTRAWB.g_seq_tab9:= NULL;
2282: QLTTRAWB.g_seq_tab10:= NULL;
2283: QLTTRAWB.g_seq_tab11:= NULL;
2284: QLTTRAWB.g_seq_tab12:= NULL;
2285: QLTTRAWB.g_seq_tab13:= NULL;
2286: QLTTRAWB.g_seq_tab14:= NULL;
2287: QLTTRAWB.g_seq_tab15:= NULL;
2288: QLTTRAWB.g_plan_id_tab:= NULL;

Line 2285: QLTTRAWB.g_seq_tab13:= NULL;

2281: QLTTRAWB.g_seq_tab9:= NULL;
2282: QLTTRAWB.g_seq_tab10:= NULL;
2283: QLTTRAWB.g_seq_tab11:= NULL;
2284: QLTTRAWB.g_seq_tab12:= NULL;
2285: QLTTRAWB.g_seq_tab13:= NULL;
2286: QLTTRAWB.g_seq_tab14:= NULL;
2287: QLTTRAWB.g_seq_tab15:= NULL;
2288: QLTTRAWB.g_plan_id_tab:= NULL;
2289: QLTTRAWB.g_collection_id_tab:= NULL;

Line 2286: QLTTRAWB.g_seq_tab14:= NULL;

2282: QLTTRAWB.g_seq_tab10:= NULL;
2283: QLTTRAWB.g_seq_tab11:= NULL;
2284: QLTTRAWB.g_seq_tab12:= NULL;
2285: QLTTRAWB.g_seq_tab13:= NULL;
2286: QLTTRAWB.g_seq_tab14:= NULL;
2287: QLTTRAWB.g_seq_tab15:= NULL;
2288: QLTTRAWB.g_plan_id_tab:= NULL;
2289: QLTTRAWB.g_collection_id_tab:= NULL;
2290: QLTTRAWB.g_occurrence_tab:= NULL;

Line 2287: QLTTRAWB.g_seq_tab15:= NULL;

2283: QLTTRAWB.g_seq_tab11:= NULL;
2284: QLTTRAWB.g_seq_tab12:= NULL;
2285: QLTTRAWB.g_seq_tab13:= NULL;
2286: QLTTRAWB.g_seq_tab14:= NULL;
2287: QLTTRAWB.g_seq_tab15:= NULL;
2288: QLTTRAWB.g_plan_id_tab:= NULL;
2289: QLTTRAWB.g_collection_id_tab:= NULL;
2290: QLTTRAWB.g_occurrence_tab:= NULL;
2291: QLTTRAWB.g_txn_header_id_tab:= NULL;

Line 2288: QLTTRAWB.g_plan_id_tab:= NULL;

2284: QLTTRAWB.g_seq_tab12:= NULL;
2285: QLTTRAWB.g_seq_tab13:= NULL;
2286: QLTTRAWB.g_seq_tab14:= NULL;
2287: QLTTRAWB.g_seq_tab15:= NULL;
2288: QLTTRAWB.g_plan_id_tab:= NULL;
2289: QLTTRAWB.g_collection_id_tab:= NULL;
2290: QLTTRAWB.g_occurrence_tab:= NULL;
2291: QLTTRAWB.g_txn_header_id_tab:= NULL;
2292: END reset_sequence_global_arrays;

Line 2289: QLTTRAWB.g_collection_id_tab:= NULL;

2285: QLTTRAWB.g_seq_tab13:= NULL;
2286: QLTTRAWB.g_seq_tab14:= NULL;
2287: QLTTRAWB.g_seq_tab15:= NULL;
2288: QLTTRAWB.g_plan_id_tab:= NULL;
2289: QLTTRAWB.g_collection_id_tab:= NULL;
2290: QLTTRAWB.g_occurrence_tab:= NULL;
2291: QLTTRAWB.g_txn_header_id_tab:= NULL;
2292: END reset_sequence_global_arrays;
2293:

Line 2290: QLTTRAWB.g_occurrence_tab:= NULL;

2286: QLTTRAWB.g_seq_tab14:= NULL;
2287: QLTTRAWB.g_seq_tab15:= NULL;
2288: QLTTRAWB.g_plan_id_tab:= NULL;
2289: QLTTRAWB.g_collection_id_tab:= NULL;
2290: QLTTRAWB.g_occurrence_tab:= NULL;
2291: QLTTRAWB.g_txn_header_id_tab:= NULL;
2292: END reset_sequence_global_arrays;
2293:
2294: PROCEDURE update_record(p_total_rec_count NUMBER) IS

Line 2291: QLTTRAWB.g_txn_header_id_tab:= NULL;

2287: QLTTRAWB.g_seq_tab15:= NULL;
2288: QLTTRAWB.g_plan_id_tab:= NULL;
2289: QLTTRAWB.g_collection_id_tab:= NULL;
2290: QLTTRAWB.g_occurrence_tab:= NULL;
2291: QLTTRAWB.g_txn_header_id_tab:= NULL;
2292: END reset_sequence_global_arrays;
2293:
2294: PROCEDURE update_record(p_total_rec_count NUMBER) IS
2295:

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

2305: -- Bulk update done once for all the records in collection
2306:
2307: -- FORALL k IN 1..p_total_rec_count
2308: -- UPDATE qa_results
2309: -- SET sequence1 = QLTTRAWB.g_seq_tab1(k),
2310: -- sequence2 = QLTTRAWB.g_seq_tab2(k),
2311: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2312: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2313: -- sequence5 = QLTTRAWB.g_seq_tab5(k),

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

2306:
2307: -- FORALL k IN 1..p_total_rec_count
2308: -- UPDATE qa_results
2309: -- SET sequence1 = QLTTRAWB.g_seq_tab1(k),
2310: -- sequence2 = QLTTRAWB.g_seq_tab2(k),
2311: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2312: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2313: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2314: -- sequence6 = QLTTRAWB.g_seq_tab6(k),

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

2307: -- FORALL k IN 1..p_total_rec_count
2308: -- UPDATE qa_results
2309: -- SET sequence1 = QLTTRAWB.g_seq_tab1(k),
2310: -- sequence2 = QLTTRAWB.g_seq_tab2(k),
2311: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2312: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2313: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2314: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2315: -- sequence7 = QLTTRAWB.g_seq_tab7(k),

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

2308: -- UPDATE qa_results
2309: -- SET sequence1 = QLTTRAWB.g_seq_tab1(k),
2310: -- sequence2 = QLTTRAWB.g_seq_tab2(k),
2311: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2312: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2313: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2314: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2315: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2316: -- sequence8 = QLTTRAWB.g_seq_tab8(k),

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

2309: -- SET sequence1 = QLTTRAWB.g_seq_tab1(k),
2310: -- sequence2 = QLTTRAWB.g_seq_tab2(k),
2311: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2312: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2313: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2314: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2315: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2316: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2317: -- sequence9 = QLTTRAWB.g_seq_tab9(k),

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

2310: -- sequence2 = QLTTRAWB.g_seq_tab2(k),
2311: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2312: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2313: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2314: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2315: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2316: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2317: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2318: -- sequence10 = QLTTRAWB.g_seq_tab10(k),

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

2311: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2312: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2313: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2314: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2315: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2316: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2317: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2318: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2319: -- sequence11 = QLTTRAWB.g_seq_tab11(k),

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

2312: -- sequence4 = QLTTRAWB.g_seq_tab4(k),
2313: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2314: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2315: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2316: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2317: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2318: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2319: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2320: -- sequence12 = QLTTRAWB.g_seq_tab12(k),

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

2313: -- sequence5 = QLTTRAWB.g_seq_tab5(k),
2314: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2315: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2316: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2317: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2318: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2319: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2320: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2321: -- sequence13 = QLTTRAWB.g_seq_tab13(k),

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

2314: -- sequence6 = QLTTRAWB.g_seq_tab6(k),
2315: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2316: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2317: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2318: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2319: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2320: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2321: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2322: -- sequence14 = QLTTRAWB.g_seq_tab14(k),

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

2315: -- sequence7 = QLTTRAWB.g_seq_tab7(k),
2316: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2317: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2318: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2319: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2320: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2321: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2322: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2323: -- sequence15 = QLTTRAWB.g_seq_tab15(k)

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

2316: -- sequence8 = QLTTRAWB.g_seq_tab8(k),
2317: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2318: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2319: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2320: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2321: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2322: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2323: -- sequence15 = QLTTRAWB.g_seq_tab15(k)
2324: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND

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

2317: -- sequence9 = QLTTRAWB.g_seq_tab9(k),
2318: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2319: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2320: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2321: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2322: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2323: -- sequence15 = QLTTRAWB.g_seq_tab15(k)
2324: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND
2325: -- collection_id = QLTTRAWB.g_collection_id_tab(k) AND

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

2318: -- sequence10 = QLTTRAWB.g_seq_tab10(k),
2319: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2320: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2321: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2322: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2323: -- sequence15 = QLTTRAWB.g_seq_tab15(k)
2324: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND
2325: -- collection_id = QLTTRAWB.g_collection_id_tab(k) AND
2326: -- occurrence = QLTTRAWB.g_occurrence_tab(k);

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

2319: -- sequence11 = QLTTRAWB.g_seq_tab11(k),
2320: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2321: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2322: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2323: -- sequence15 = QLTTRAWB.g_seq_tab15(k)
2324: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND
2325: -- collection_id = QLTTRAWB.g_collection_id_tab(k) AND
2326: -- occurrence = QLTTRAWB.g_occurrence_tab(k);
2327:

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

2320: -- sequence12 = QLTTRAWB.g_seq_tab12(k),
2321: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2322: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2323: -- sequence15 = QLTTRAWB.g_seq_tab15(k)
2324: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND
2325: -- collection_id = QLTTRAWB.g_collection_id_tab(k) AND
2326: -- occurrence = QLTTRAWB.g_occurrence_tab(k);
2327:
2328: --

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

2321: -- sequence13 = QLTTRAWB.g_seq_tab13(k),
2322: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2323: -- sequence15 = QLTTRAWB.g_seq_tab15(k)
2324: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND
2325: -- collection_id = QLTTRAWB.g_collection_id_tab(k) AND
2326: -- occurrence = QLTTRAWB.g_occurrence_tab(k);
2327:
2328: --
2329: -- Bug 5114865

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

2322: -- sequence14 = QLTTRAWB.g_seq_tab14(k),
2323: -- sequence15 = QLTTRAWB.g_seq_tab15(k)
2324: -- WHERE plan_id = QLTTRAWB.g_plan_id_tab(k) AND
2325: -- collection_id = QLTTRAWB.g_collection_id_tab(k) AND
2326: -- occurrence = QLTTRAWB.g_occurrence_tab(k);
2327:
2328: --
2329: -- Bug 5114865
2330: -- Updating the data for the Seq Type elements

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

2332: --
2333: FOR k in 1..g_true_seq_gen_recids.COUNT
2334: LOOP
2335: UPDATE qa_results
2336: SET sequence1 = QLTTRAWB.g_seq_tab1(g_true_seq_gen_recids(k)),
2337: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),
2338: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2339: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2340: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),

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

2333: FOR k in 1..g_true_seq_gen_recids.COUNT
2334: LOOP
2335: UPDATE qa_results
2336: SET sequence1 = QLTTRAWB.g_seq_tab1(g_true_seq_gen_recids(k)),
2337: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),
2338: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2339: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2340: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2341: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),

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

2334: LOOP
2335: UPDATE qa_results
2336: SET sequence1 = QLTTRAWB.g_seq_tab1(g_true_seq_gen_recids(k)),
2337: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),
2338: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2339: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2340: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2341: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2342: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),

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

2335: UPDATE qa_results
2336: SET sequence1 = QLTTRAWB.g_seq_tab1(g_true_seq_gen_recids(k)),
2337: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),
2338: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2339: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2340: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2341: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2342: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2343: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),

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

2336: SET sequence1 = QLTTRAWB.g_seq_tab1(g_true_seq_gen_recids(k)),
2337: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),
2338: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2339: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2340: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2341: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2342: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2343: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2344: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),

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

2337: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),
2338: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2339: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2340: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2341: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2342: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2343: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2344: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2345: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),

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

2338: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2339: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2340: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2341: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2342: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2343: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2344: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2345: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2346: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),

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

2339: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),
2340: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2341: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2342: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2343: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2344: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2345: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2346: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2347: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),

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

2340: sequence5 = QLTTRAWB.g_seq_tab5(g_true_seq_gen_recids(k)),
2341: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2342: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2343: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2344: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2345: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2346: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2347: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2348: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),

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

2341: sequence6 = QLTTRAWB.g_seq_tab6(g_true_seq_gen_recids(k)),
2342: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2343: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2344: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2345: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2346: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2347: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2348: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2349: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),

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

2342: sequence7 = QLTTRAWB.g_seq_tab7(g_true_seq_gen_recids(k)),
2343: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2344: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2345: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2346: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2347: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2348: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2349: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2350: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))

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

2343: sequence8 = QLTTRAWB.g_seq_tab8(g_true_seq_gen_recids(k)),
2344: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2345: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2346: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2347: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2348: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2349: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2350: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))
2351: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND

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

2344: sequence9 = QLTTRAWB.g_seq_tab9(g_true_seq_gen_recids(k)),
2345: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2346: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2347: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2348: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2349: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2350: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))
2351: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND
2352: collection_id = QLTTRAWB.g_collection_id_tab(g_true_seq_gen_recids(k)) AND

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

2345: sequence10 = QLTTRAWB.g_seq_tab10(g_true_seq_gen_recids(k)),
2346: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2347: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2348: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2349: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2350: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))
2351: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND
2352: collection_id = QLTTRAWB.g_collection_id_tab(g_true_seq_gen_recids(k)) AND
2353: occurrence = QLTTRAWB.g_occurrence_tab(g_true_seq_gen_recids(k));

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

2346: sequence11 = QLTTRAWB.g_seq_tab11(g_true_seq_gen_recids(k)),
2347: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2348: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2349: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2350: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))
2351: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND
2352: collection_id = QLTTRAWB.g_collection_id_tab(g_true_seq_gen_recids(k)) AND
2353: occurrence = QLTTRAWB.g_occurrence_tab(g_true_seq_gen_recids(k));
2354: END LOOP;

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

2347: sequence12 = QLTTRAWB.g_seq_tab12(g_true_seq_gen_recids(k)),
2348: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2349: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2350: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))
2351: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND
2352: collection_id = QLTTRAWB.g_collection_id_tab(g_true_seq_gen_recids(k)) AND
2353: occurrence = QLTTRAWB.g_occurrence_tab(g_true_seq_gen_recids(k));
2354: END LOOP;
2355:

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

2348: sequence13 = QLTTRAWB.g_seq_tab13(g_true_seq_gen_recids(k)),
2349: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2350: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))
2351: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND
2352: collection_id = QLTTRAWB.g_collection_id_tab(g_true_seq_gen_recids(k)) AND
2353: occurrence = QLTTRAWB.g_occurrence_tab(g_true_seq_gen_recids(k));
2354: END LOOP;
2355:
2356: -- Bug 5114865

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

2349: sequence14 = QLTTRAWB.g_seq_tab14(g_true_seq_gen_recids(k)),
2350: sequence15 = QLTTRAWB.g_seq_tab15(g_true_seq_gen_recids(k))
2351: WHERE plan_id = QLTTRAWB.g_plan_id_tab(g_true_seq_gen_recids(k)) AND
2352: collection_id = QLTTRAWB.g_collection_id_tab(g_true_seq_gen_recids(k)) AND
2353: occurrence = QLTTRAWB.g_occurrence_tab(g_true_seq_gen_recids(k));
2354: END LOOP;
2355:
2356: -- Bug 5114865
2357: -- Updating the data for the Seq->Char elem relations

Line 2546: QLTTRAWB.init_seq_table(l_row_count);

2542: BEGIN
2543: l_row_count := p_occurrences.COUNT;
2544:
2545: -- initialize all collection objects.
2546: QLTTRAWB.init_seq_table(l_row_count);
2547:
2548: i := p_occurrences.FIRST;
2549: WHILE i IS NOT NULL LOOP
2550:

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

2556: sequence7,sequence8,sequence9,
2557: sequence10,sequence11,sequence12,
2558: sequence13,sequence14,sequence15
2559: INTO
2560: QLTTRAWB.g_occurrence_tab(l_count), QLTTRAWB.g_collection_id_tab(l_count),
2561: QLTTRAWB.g_plan_id_tab(l_count), QLTTRAWB.g_txn_header_id_tab(l_count),
2562: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),
2563: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2564: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),

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

2557: sequence10,sequence11,sequence12,
2558: sequence13,sequence14,sequence15
2559: INTO
2560: QLTTRAWB.g_occurrence_tab(l_count), QLTTRAWB.g_collection_id_tab(l_count),
2561: QLTTRAWB.g_plan_id_tab(l_count), QLTTRAWB.g_txn_header_id_tab(l_count),
2562: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),
2563: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2564: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),
2565: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),

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

2558: sequence13,sequence14,sequence15
2559: INTO
2560: QLTTRAWB.g_occurrence_tab(l_count), QLTTRAWB.g_collection_id_tab(l_count),
2561: QLTTRAWB.g_plan_id_tab(l_count), QLTTRAWB.g_txn_header_id_tab(l_count),
2562: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),
2563: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2564: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),
2565: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),
2566: QLTTRAWB.g_seq_tab13(l_count), QLTTRAWB.g_seq_tab14(l_count), QLTTRAWB.g_seq_tab15(l_count)

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

2559: INTO
2560: QLTTRAWB.g_occurrence_tab(l_count), QLTTRAWB.g_collection_id_tab(l_count),
2561: QLTTRAWB.g_plan_id_tab(l_count), QLTTRAWB.g_txn_header_id_tab(l_count),
2562: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),
2563: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2564: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),
2565: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),
2566: QLTTRAWB.g_seq_tab13(l_count), QLTTRAWB.g_seq_tab14(l_count), QLTTRAWB.g_seq_tab15(l_count)
2567: FROM qa_results

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

2560: QLTTRAWB.g_occurrence_tab(l_count), QLTTRAWB.g_collection_id_tab(l_count),
2561: QLTTRAWB.g_plan_id_tab(l_count), QLTTRAWB.g_txn_header_id_tab(l_count),
2562: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),
2563: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2564: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),
2565: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),
2566: QLTTRAWB.g_seq_tab13(l_count), QLTTRAWB.g_seq_tab14(l_count), QLTTRAWB.g_seq_tab15(l_count)
2567: FROM qa_results
2568: WHERE plan_id = p_plan_ids(i) AND

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

2561: QLTTRAWB.g_plan_id_tab(l_count), QLTTRAWB.g_txn_header_id_tab(l_count),
2562: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),
2563: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2564: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),
2565: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),
2566: QLTTRAWB.g_seq_tab13(l_count), QLTTRAWB.g_seq_tab14(l_count), QLTTRAWB.g_seq_tab15(l_count)
2567: FROM qa_results
2568: WHERE plan_id = p_plan_ids(i) AND
2569: collection_id = p_collection_ids(i) AND

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

2562: QLTTRAWB.g_seq_tab1(l_count), QLTTRAWB.g_seq_tab2(l_count), QLTTRAWB.g_seq_tab3(l_count),
2563: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2564: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),
2565: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),
2566: QLTTRAWB.g_seq_tab13(l_count), QLTTRAWB.g_seq_tab14(l_count), QLTTRAWB.g_seq_tab15(l_count)
2567: FROM qa_results
2568: WHERE plan_id = p_plan_ids(i) AND
2569: collection_id = p_collection_ids(i) AND
2570: occurrence = p_occurrences(i);

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

2638: l_user_id := fnd_global.user_id;
2639: l_login_id := fnd_global.login_id;
2640: l_date := SYSDATE;
2641:
2642: FOR j IN 1..QLTTRAWB.g_occurrence_tab.count LOOP
2643:
2644: IF QLTTRAWB.g_occurrence_tab(j) = p_occurrence THEN
2645: l_cur_rec_indicator := j;
2646: END IF;

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

2640: l_date := SYSDATE;
2641:
2642: FOR j IN 1..QLTTRAWB.g_occurrence_tab.count LOOP
2643:
2644: IF QLTTRAWB.g_occurrence_tab(j) = p_occurrence THEN
2645: l_cur_rec_indicator := j;
2646: END IF;
2647: END LOOP;
2648:

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

2668: p_plan_id => p_plan_id,
2669: p_collection_id => p_collection_id,
2670: p_occurrence => p_occurrence,
2671: p_char_id => g_curr_plan_seq_char_ids(i),
2672: p_txn_header_id => QLTTRAWB.g_txn_header_id_tab(l_cur_rec_indicator),
2673: p_sequence_value => l_seq_value,
2674: p_user_id => l_user_id,
2675: p_source_code => 'EQR',
2676: p_source_id => NULL,

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

2701: l_login_id := fnd_global.login_id;
2702: l_date := SYSDATE;
2703:
2704: sequence_audit_log(
2705: p_plan_id => QLTTRAWB.g_plan_id_tab(p_cur_rec_indicator),
2706: p_collection_id => QLTTRAWB.g_collection_id_tab(p_cur_rec_indicator),
2707: p_occurrence => QLTTRAWB.g_occurrence_tab(p_cur_rec_indicator),
2708: p_char_id => p_char_id,
2709: p_txn_header_id => QLTTRAWB.g_txn_header_id_tab(p_cur_rec_indicator),

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

2702: l_date := SYSDATE;
2703:
2704: sequence_audit_log(
2705: p_plan_id => QLTTRAWB.g_plan_id_tab(p_cur_rec_indicator),
2706: p_collection_id => QLTTRAWB.g_collection_id_tab(p_cur_rec_indicator),
2707: p_occurrence => QLTTRAWB.g_occurrence_tab(p_cur_rec_indicator),
2708: p_char_id => p_char_id,
2709: p_txn_header_id => QLTTRAWB.g_txn_header_id_tab(p_cur_rec_indicator),
2710: p_sequence_value => p_seq_value,

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

2703:
2704: sequence_audit_log(
2705: p_plan_id => QLTTRAWB.g_plan_id_tab(p_cur_rec_indicator),
2706: p_collection_id => QLTTRAWB.g_collection_id_tab(p_cur_rec_indicator),
2707: p_occurrence => QLTTRAWB.g_occurrence_tab(p_cur_rec_indicator),
2708: p_char_id => p_char_id,
2709: p_txn_header_id => QLTTRAWB.g_txn_header_id_tab(p_cur_rec_indicator),
2710: p_sequence_value => p_seq_value,
2711: p_user_id => l_user_id,

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

2705: p_plan_id => QLTTRAWB.g_plan_id_tab(p_cur_rec_indicator),
2706: p_collection_id => QLTTRAWB.g_collection_id_tab(p_cur_rec_indicator),
2707: p_occurrence => QLTTRAWB.g_occurrence_tab(p_cur_rec_indicator),
2708: p_char_id => p_char_id,
2709: p_txn_header_id => QLTTRAWB.g_txn_header_id_tab(p_cur_rec_indicator),
2710: p_sequence_value => p_seq_value,
2711: p_user_id => l_user_id,
2712: p_source_code => 'EDR', -- ERES
2713: p_source_id => NULL, -- eRes ID not generated at this time

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

3020: || ' Seq val = ' || p_seq_value);
3021: END IF;
3022:
3023: sequence_audit_log(
3024: p_plan_id => qlttrawb.g_plan_id_tab(p_cur_rec_indicator),
3025: p_collection_id => qlttrawb.g_collection_id_tab(p_cur_rec_indicator),
3026: p_occurrence => qlttrawb.g_occurrence_tab(p_cur_rec_indicator),
3027: p_char_id => p_char_id,
3028: p_txn_header_id => qlttrawb.g_txn_header_id_tab(p_cur_rec_indicator),

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

3021: END IF;
3022:
3023: sequence_audit_log(
3024: p_plan_id => qlttrawb.g_plan_id_tab(p_cur_rec_indicator),
3025: p_collection_id => qlttrawb.g_collection_id_tab(p_cur_rec_indicator),
3026: p_occurrence => qlttrawb.g_occurrence_tab(p_cur_rec_indicator),
3027: p_char_id => p_char_id,
3028: p_txn_header_id => qlttrawb.g_txn_header_id_tab(p_cur_rec_indicator),
3029: p_sequence_value => p_seq_value,

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

3022:
3023: sequence_audit_log(
3024: p_plan_id => qlttrawb.g_plan_id_tab(p_cur_rec_indicator),
3025: p_collection_id => qlttrawb.g_collection_id_tab(p_cur_rec_indicator),
3026: p_occurrence => qlttrawb.g_occurrence_tab(p_cur_rec_indicator),
3027: p_char_id => p_char_id,
3028: p_txn_header_id => qlttrawb.g_txn_header_id_tab(p_cur_rec_indicator),
3029: p_sequence_value => p_seq_value,
3030: p_user_id => l_user_id,

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

3024: p_plan_id => qlttrawb.g_plan_id_tab(p_cur_rec_indicator),
3025: p_collection_id => qlttrawb.g_collection_id_tab(p_cur_rec_indicator),
3026: p_occurrence => qlttrawb.g_occurrence_tab(p_cur_rec_indicator),
3027: p_char_id => p_char_id,
3028: p_txn_header_id => qlttrawb.g_txn_header_id_tab(p_cur_rec_indicator),
3029: p_sequence_value => p_seq_value,
3030: p_user_id => l_user_id,
3031: p_source_code => p_module, -- OA Transaction Integration /Mobile
3032: p_source_id => NULL, -- Parent transaction not committed till this time