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.AHL_MC_PATH_POSITION_PVT dependencies on AHL_MC_PATH_POSITION_NODES

Line 90: AHL_MC_PATH_POSITION_NODES where path_position_id = pos.path_position_id);

86: SELECT pos.path_pos_common_id
87: FROM AHL_MC_PATH_POSITIONS pos
88: WHERE pos.encoded_path_position like p_encoded_path
89: AND p_size = (select COUNT(path_position_node_id) from
90: AHL_MC_PATH_POSITION_NODES where path_position_id = pos.path_position_id);
91: --
92: CURSOR get_next_path_pos_id_csr IS
93: SELECT ahl_mc_path_positions_s.nextval
94: FROM dual;

Line 316: INSERT INTO ahl_mc_path_position_nodes(

312: RETURNING path_position_id INTO x_position_id;
313:
314: --Insert the path position nodes
315: FOR i IN p_path_position_tbl.FIRST..p_path_position_tbl.LAST LOOP
316: INSERT INTO ahl_mc_path_position_nodes(
317: PATH_POSITION_NODE_ID,
318: OBJECT_VERSION_NUMBER,
319: LAST_UPDATE_DATE,
320: LAST_UPDATED_BY,

Line 345: ahl_mc_path_position_nodes_s.nextval,

341: ATTRIBUTE12, ATTRIBUTE13,
342: ATTRIBUTE14,
343: ATTRIBUTE15
344: ) VALUES (
345: ahl_mc_path_position_nodes_s.nextval,
346: 1,
347: sysdate,
348: fnd_global.user_id,
349: sysdate,

Line 493: AHL_MC_PATH_POSITION_NODES where path_position_id = pos.path_position_id);

489: SELECT pos.path_position_id
490: FROM AHL_MC_PATH_POSITIONS pos
491: WHERE p_encoded_path LIKE pos.encoded_path_position
492: AND p_size = (select COUNT(path_position_node_id) from
493: AHL_MC_PATH_POSITION_NODES where path_position_id = pos.path_position_id);
494: --
495: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
496: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
497: l_index NUMBER;

Line 669: FROM AHL_MC_PATH_POSITION_NODES path

665: --
666: --Fetch all the position path information for given position_id
667: CURSOR get_position_path_csr (p_position_id IN NUMBER) IS
668: SELECT path.sequence, path.mc_id, path.version_number, path.position_key
669: FROM AHL_MC_PATH_POSITION_NODES path
670: WHERE path.path_position_id = p_position_id
671: order by sequence;
672: --
673: --Determine if position_key maps to top node of the configuration

Line 955: FROM AHL_MC_PATH_POSITION_NODES path

951: --Step 1) Build the path Position table object
952: --Fetch all the position path information for given position_id
953: CURSOR get_position_path_csr (p_position_id IN NUMBER) IS
954: SELECT path.sequence, path.mc_id, path.version_number, path.position_key
955: FROM AHL_MC_PATH_POSITION_NODES path
956: WHERE path.path_position_id = p_position_id
957: order by sequence;
958:
959: --

Line 1388: FROM ahl_mc_path_position_nodes pnodes, ahl_mc_headers_b hdr

1384: WHERE mc_header_id = p_mc_header_id;
1385: --
1386: CURSOR get_ver_position_ids_csr (p_header_id IN NUMBER) IS
1387: SELECT pnodes.path_position_id
1388: FROM ahl_mc_path_position_nodes pnodes, ahl_mc_headers_b hdr
1389: WHERE pnodes.sequence = 0
1390: AND pnodes.mc_id = hdr.mc_id
1391: AND pnodes.version_number = hdr.version_number
1392: AND hdr.mc_header_id = p_header_id;

Line 1396: FROM ahl_mc_path_position_nodes pnodes, ahl_mc_headers_b hdr

1392: AND hdr.mc_header_id = p_header_id;
1393: --
1394: CURSOR get_nover_position_ids_csr(p_header_id IN NUMBER) IS
1395: SELECT pnodes.path_position_id
1396: FROM ahl_mc_path_position_nodes pnodes, ahl_mc_headers_b hdr
1397: WHERE pnodes.sequence = 0
1398: AND pnodes.mc_id = hdr.mc_id
1399: AND pnodes.version_number IS NULL
1400: AND hdr.mc_header_id = p_header_id;

Line 1583: FROM ahl_mc_path_position_nodes

1579: WHERE mc_header_id = p_mc_header_id;
1580: --
1581: CURSOR get_mc_path_position_nodes_csr (p_position_id IN NUMBER) IS
1582: SELECT *
1583: FROM ahl_mc_path_position_nodes
1584: WHERE path_position_id = p_position_id
1585: order by sequence;
1586: --
1587: CURSOR get_path_position_ref_csr (p_position_id IN NUMBER) IS

Line 1798: FROM AHL_MC_PATH_POSITION_NODES path, AHL_MC_HEADERS_B headers

1794: --
1795: --Fetch all version specific path positions
1796: CURSOR get_ver_position_ids_csr (p_mc_header_id IN NUMBER) IS
1797: SELECT path.path_position_id
1798: FROM AHL_MC_PATH_POSITION_NODES path, AHL_MC_HEADERS_B headers
1799: WHERE path.MC_ID = headers.mc_id
1800: AND path.sequence = 0
1801: AND path.version_number = headers.version_number
1802: AND headers.mc_header_id = p_mc_header_id;

Line 1807: FROM AHL_MC_PATH_POSITION_NODES path, AHL_MC_HEADERS_B headers

1803: --
1804: --Fetch all non-version specific path positions
1805: CURSOR get_nover_position_ids_csr (p_mc_header_id IN NUMBER) IS
1806: SELECT path.path_position_id
1807: FROM AHL_MC_PATH_POSITION_NODES path, AHL_MC_HEADERS_B headers
1808: WHERE path.MC_ID = headers.mc_id
1809: AND path.sequence = 0
1810: AND path.version_number IS NULL
1811: AND headers.mc_header_id = p_mc_header_id;

Line 1883: DELETE FROM AHL_MC_PATH_POSITION_NODES

1879: FETCH check_posid_in_rstmts_csr INTO l_junk;
1880: IF (check_posid_in_rstmts_csr%NOTFOUND) THEN
1881:
1882: --Delete the position_id
1883: DELETE FROM AHL_MC_PATH_POSITION_NODES
1884: WHERE path_position_id = l_position_id;
1885:
1886: DELETE FROM AHL_MC_PATH_POSITIONS
1887: WHERE path_position_id = l_position_id;

Line 1913: DELETE FROM AHL_MC_PATH_POSITION_NODES

1909: FETCH check_posid_in_rstmts_csr INTO l_junk;
1910: IF (check_posid_in_rstmts_csr%NOTFOUND) THEN
1911:
1912: --Delete the position_id
1913: DELETE FROM AHL_MC_PATH_POSITION_NODES
1914: WHERE path_position_id = l_position_id;
1915:
1916: DELETE FROM AHL_MC_PATH_POSITIONS
1917: WHERE path_position_id = l_position_id;

Line 1989: AHL_MC_PATH_POSITION_NODES pnodes

1985: --Select the default position reference.
1986: CURSOR get_def_pos_ref_csr (p_position_id IN NUMBER) IS
1987: SELECT rel.position_ref_code
1988: FROM AHL_MC_HEADERS_B hd, AHL_MC_RELATIONSHIPS rel,
1989: AHL_MC_PATH_POSITION_NODES pnodes
1990: WHERE hd.mc_header_id = rel.mc_header_id
1991: AND rel.position_key = pnodes.position_key
1992: AND hd.mc_id = pnodes.mc_id
1993: AND pnodes.sequence = (SELECT MAX(sequence) FROM AHL_MC_PATH_POSITION_NODES

Line 1993: AND pnodes.sequence = (SELECT MAX(sequence) FROM AHL_MC_PATH_POSITION_NODES

1989: AHL_MC_PATH_POSITION_NODES pnodes
1990: WHERE hd.mc_header_id = rel.mc_header_id
1991: AND rel.position_key = pnodes.position_key
1992: AND hd.mc_id = pnodes.mc_id
1993: AND pnodes.sequence = (SELECT MAX(sequence) FROM AHL_MC_PATH_POSITION_NODES
1994: WHERE path_position_id = p_position_id)
1995: AND pnodes.path_position_id = p_position_id
1996: order by hd.version_number desc;
1997: --

Line 2720: -- for a given path position id, get the mc id and version no from ahl_mc_path_position_nodes

2716: p_relationship_id IN NUMBER,
2717: p_path_position_id IN NUMBER
2718: ) RETURN VARCHAR2 IS
2719: --
2720: -- for a given path position id, get the mc id and version no from ahl_mc_path_position_nodes
2721: -- from the mc id and version no, get the mc header id from ahl_mc_headers_b
2722: -- from the mc header id and position key (from ahl_mc_path_position_nodes), get the relationship id from ahl_mc_relationships
2723: CURSOR get_rel_id_csr (p_path_position_id NUMBER) IS
2724: SELECT mcr.relationship_id

Line 2722: -- from the mc header id and position key (from ahl_mc_path_position_nodes), get the relationship id from ahl_mc_relationships

2718: ) RETURN VARCHAR2 IS
2719: --
2720: -- for a given path position id, get the mc id and version no from ahl_mc_path_position_nodes
2721: -- from the mc id and version no, get the mc header id from ahl_mc_headers_b
2722: -- from the mc header id and position key (from ahl_mc_path_position_nodes), get the relationship id from ahl_mc_relationships
2723: CURSOR get_rel_id_csr (p_path_position_id NUMBER) IS
2724: SELECT mcr.relationship_id
2725: FROM ahl_mc_path_position_nodes mpn, ahl_mc_headers_b mch,
2726: ahl_mc_relationships mcr

Line 2725: FROM ahl_mc_path_position_nodes mpn, ahl_mc_headers_b mch,

2721: -- from the mc id and version no, get the mc header id from ahl_mc_headers_b
2722: -- from the mc header id and position key (from ahl_mc_path_position_nodes), get the relationship id from ahl_mc_relationships
2723: CURSOR get_rel_id_csr (p_path_position_id NUMBER) IS
2724: SELECT mcr.relationship_id
2725: FROM ahl_mc_path_position_nodes mpn, ahl_mc_headers_b mch,
2726: ahl_mc_relationships mcr
2727: WHERE mpn.path_position_id = p_path_position_id
2728: AND mpn.sequence = (
2729: SELECT MAX(sequence)

Line 2730: FROM ahl_mc_path_position_nodes

2726: ahl_mc_relationships mcr
2727: WHERE mpn.path_position_id = p_path_position_id
2728: AND mpn.sequence = (
2729: SELECT MAX(sequence)
2730: FROM ahl_mc_path_position_nodes
2731: WHERE path_position_id = mpn.path_position_id
2732: )
2733: AND mpn.mc_id = mch.mc_id
2734: AND mch.version_number = NVL(mpn.version_number, mch.version_number)