[Home] [Help]
777: g_ind := 0;
778: g_treeno := 1;
779: g_depth := 1;
780:
781: DELETE FROM mtl_gen_temp;
782: END init;
783:
784: PROCEDURE inv_populate_child(
785: p_object_id IN NUMBER
796: -- do not get the next level, if the node has already been processed once.
797:
798: CURSOR search_cur IS
799: SELECT *
800: FROM mtl_gen_temp
801: WHERE treeno < g_treeno
802: AND DEPTH < g_depth
803: ORDER BY ind DESC;
804:
851: IF g_ind > 1 THEN
852: BEGIN
853: SELECT 1
854: INTO l_count
855: FROM mtl_gen_temp
856: WHERE label = p_object_id
857: AND related_label = 0
858: AND (p_object_id2 is null or label2=p_object_id2)
859: AND ROWNUM < 2;
865: IF l_debug =1 THEN
866: inv_trx_util_pub.TRACE('insert1, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
867: END IF;
868:
869: INSERT INTO mtl_gen_temp
870: (
871: ind
872: , treeno
873: , DEPTH
903: IF g_ind > 1 and get_hierc='Y' THEN
904: BEGIN
905: SELECT 1
906: INTO l_count
907: FROM mtl_gen_temp
908: WHERE treeno = g_treeno
909: AND label = p_object_id
910: AND (p_object_id2 is null or label2=p_object_id2)
911: AND ROWNUM < 2;
918: IF l_debug=1 THEN
919: inv_trx_util_pub.TRACE('insert2 g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
920: END IF;
921:
922: INSERT INTO mtl_gen_temp
923: (
924: ind
925: , treeno
926: , DEPTH
966: IF l_debug=1 THEN
967: inv_trx_util_pub.TRACE('insert3 g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
968: END IF;
969:
970: INSERT INTO mtl_gen_temp
971: (
972: ind
973: , treeno
974: , DEPTH
1001: IF l_debug=1 THEN
1002: inv_trx_util_pub.TRACE('insert4 g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1003: END IF;
1004:
1005: INSERT INTO mtl_gen_temp
1006: (
1007: ind
1008: , treeno
1009: , DEPTH
1133: l_prev_parent := p_related_object_id;
1134:
1135:
1136:
1137: INSERT INTO mtl_gen_temp
1138: (
1139: ind
1140: , treeno
1141: , DEPTH
1173: END IF;
1174:
1175: g_ind := g_ind + 1;
1176:
1177: INSERT INTO mtl_gen_temp
1178: (
1179: ind
1180: , treeno
1181: , DEPTH
1215: END IF;
1216:
1217: g_ind := g_ind + 1;
1218:
1219: INSERT INTO mtl_gen_temp
1220: (
1221: ind
1222: , treeno
1223: , DEPTH
1279: OR end_date_active > SYSDATE);
1280:
1281: CURSOR search_cur IS
1282: SELECT *
1283: FROM mtl_gen_temp
1284: WHERE treeno < g_treeno
1285: AND DEPTH < g_depth
1286: ORDER BY ind DESC;
1287:
1302: IF g_ind > 0 THEN
1303: BEGIN
1304: SELECT 1
1305: INTO l_count
1306: FROM mtl_gen_temp
1307: WHERE label = p_object_id
1308: AND related_label = 0
1309: AND (p_object_id2 is null or label2=p_object_id2)
1310: AND ROWNUM < 2;
1317: inv_trx_util_pub.TRACE('insert1, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1318: END IF;
1319:
1320:
1321: INSERT INTO mtl_gen_temp
1322: (
1323: ind
1324: , treeno
1325: , DEPTH
1355: IF g_ind > 1 and get_hierc='Y' THEN
1356: BEGIN
1357: SELECT 1
1358: INTO l_count
1359: FROM mtl_gen_temp
1360: WHERE treeno = g_treeno
1361: AND label = p_object_id
1362: AND (p_object_id2 is null or label2=p_object_id2)
1363: AND ROWNUM < 2;
1372: inv_trx_util_pub.TRACE('insert2, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1373: END IF;
1374:
1375:
1376: INSERT INTO mtl_gen_temp
1377: (
1378: ind
1379: , treeno
1380: , DEPTH
1420: inv_trx_util_pub.TRACE('insert3, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1421: END IF;
1422:
1423:
1424: INSERT INTO mtl_gen_temp
1425: (
1426: ind
1427: , treeno
1428: , DEPTH
1457: inv_trx_util_pub.TRACE('insert4, g_ind '||g_ind, 'INV_OBJECT_GENEALOGY', 9);
1458: END IF;
1459:
1460:
1461: INSERT INTO mtl_gen_temp
1462: (
1463: ind
1464: , treeno
1465: , DEPTH
1554: inv_object_genealogy.init;
1555: g_ind := g_ind + 1;
1556: l_prev_parent := p_related_object_id;
1557:
1558: INSERT INTO mtl_gen_temp
1559: (
1560: ind
1561: , treeno
1562: , DEPTH
1592: END IF;
1593:
1594: g_ind := g_ind + 1;
1595:
1596: INSERT INTO mtl_gen_temp
1597: (
1598: ind
1599: , treeno
1600: , DEPTH