[Home] [Help]
831: g_ind := 0;
832: g_treeno := 1;
833: g_depth := 1;
834:
835: DELETE FROM mtl_gen_temp;
836: END init;
837:
838: PROCEDURE inv_populate_child(
839: p_object_id IN NUMBER
851: -- do not get the next level, if the node has already been processed once.
852:
853: CURSOR search_cur IS
854: SELECT *
855: FROM mtl_gen_temp
856: WHERE treeno < g_treeno
857: AND DEPTH < g_depth
858: ORDER BY ind DESC;
859:
941: IF g_ind > 1 THEN
942: BEGIN
943: SELECT 1
944: INTO l_count
945: FROM mtl_gen_temp
946: WHERE label = p_object_id
947: AND related_label = 0
948: AND (p_object_id2 is null or label2=p_object_id2)
949: AND ROWNUM < 2;
955: IF l_debug =1 THEN
956: inv_trx_util_pub.TRACE('insert1, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
957: END IF;
958:
959: INSERT INTO mtl_gen_temp
960: (
961: ind
962: , treeno
963: , DEPTH
993: IF g_ind > 1 and get_hierc='Y' THEN
994: BEGIN
995: SELECT 1
996: INTO l_count
997: FROM mtl_gen_temp
998: WHERE treeno = g_treeno
999: AND label = p_object_id
1000: AND (p_object_id2 is null or label2=p_object_id2)
1001: AND ROWNUM < 2;
1008: IF l_debug=1 THEN
1009: inv_trx_util_pub.TRACE('insert2 g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1010: END IF;
1011:
1012: INSERT INTO mtl_gen_temp
1013: (
1014: ind
1015: , treeno
1016: , DEPTH
1056: IF l_debug=1 THEN
1057: inv_trx_util_pub.TRACE('insert3 g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1058: END IF;
1059:
1060: INSERT INTO mtl_gen_temp
1061: (
1062: ind
1063: , treeno
1064: , DEPTH
1091: IF l_debug=1 THEN
1092: inv_trx_util_pub.TRACE('insert4 g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1093: END IF;
1094:
1095: INSERT INTO mtl_gen_temp
1096: (
1097: ind
1098: , treeno
1099: , DEPTH
1269: l_prev_parent := p_related_object_id;
1270:
1271:
1272:
1273: INSERT INTO mtl_gen_temp
1274: (
1275: ind
1276: , treeno
1277: , DEPTH
1309: END IF;
1310:
1311: g_ind := g_ind + 1;
1312:
1313: INSERT INTO mtl_gen_temp
1314: (
1315: ind
1316: , treeno
1317: , DEPTH
1380: END IF;
1381:
1382: g_ind := g_ind + 1;
1383:
1384: INSERT INTO mtl_gen_temp
1385: (
1386: ind
1387: , treeno
1388: , DEPTH
1447: OR end_date_active > SYSDATE);
1448:
1449: CURSOR search_cur IS
1450: SELECT *
1451: FROM mtl_gen_temp
1452: WHERE treeno < g_treeno
1453: AND DEPTH < g_depth
1454: ORDER BY ind DESC;
1455:
1470: IF g_ind > 0 THEN
1471: BEGIN
1472: SELECT 1
1473: INTO l_count
1474: FROM mtl_gen_temp
1475: WHERE label = p_object_id
1476: AND related_label = 0
1477: AND (p_object_id2 is null or label2=p_object_id2)
1478: AND ROWNUM < 2;
1485: inv_trx_util_pub.TRACE('insert1, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1486: END IF;
1487:
1488:
1489: INSERT INTO mtl_gen_temp
1490: (
1491: ind
1492: , treeno
1493: , DEPTH
1523: IF g_ind > 1 and get_hierc='Y' THEN
1524: BEGIN
1525: SELECT 1
1526: INTO l_count
1527: FROM mtl_gen_temp
1528: WHERE treeno = g_treeno
1529: AND label = p_object_id
1530: AND (p_object_id2 is null or label2=p_object_id2)
1531: AND ROWNUM < 2;
1540: inv_trx_util_pub.TRACE('insert2, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1541: END IF;
1542:
1543:
1544: INSERT INTO mtl_gen_temp
1545: (
1546: ind
1547: , treeno
1548: , DEPTH
1588: inv_trx_util_pub.TRACE('insert3, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1589: END IF;
1590:
1591:
1592: INSERT INTO mtl_gen_temp
1593: (
1594: ind
1595: , treeno
1596: , DEPTH
1625: inv_trx_util_pub.TRACE('insert4, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1626: END IF;
1627:
1628:
1629: INSERT INTO mtl_gen_temp
1630: (
1631: ind
1632: , treeno
1633: , DEPTH
1726: inv_object_genealogy.init;
1727: g_ind := g_ind + 1;
1728: l_prev_parent := p_related_object_id;
1729:
1730: INSERT INTO mtl_gen_temp
1731: (
1732: ind
1733: , treeno
1734: , DEPTH
1792: END IF;
1793:
1794: g_ind := g_ind + 1;
1795:
1796: INSERT INTO mtl_gen_temp
1797: (
1798: ind
1799: , treeno
1800: , DEPTH