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_POSITIONS

Line 73: FROM ahl_mc_path_positions pos

69: --
70: --Check the encoded path position csr
71: CURSOR get_position_id_csr (p_encoded_path IN VARCHAR2) IS
72: SELECT pos.path_position_id
73: FROM ahl_mc_path_positions pos
74: WHERE pos.encoded_path_position = p_encoded_path;
75: --
76: CURSOR get_sibling_poskey_csr(p_mc_id IN NUMBER, p_poskey IN NUMBER) IS
77: SELECT distinct r2.position_key

Line 87: FROM AHL_MC_PATH_POSITIONS pos

83: AND hdr.mc_id = p_mc_id;
84: --
85: CURSOR get_pos_common_id_csr (p_encoded_path IN VARCHAR2, p_size IN NUMBER) IS
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: --

Line 93: SELECT ahl_mc_path_positions_s.nextval

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;
95: --
96: l_junk VARCHAR2(1);
97: l_api_version CONSTANT NUMBER := 1.0;

Line 101: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;

97: l_api_version CONSTANT NUMBER := 1.0;
98: l_api_name CONSTANT VARCHAR2(30) := 'Create_Position_ID';
99: l_pos_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
100: l_position_id NUMBER;
101: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
102: l_position_ref_code VARCHAR2(30);
103: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
104: l_msg_count NUMBER;
105: l_return_val BOOLEAN;

Line 242: UPDATE ahl_mc_path_positions SET

238: FETCH get_position_id_csr INTO x_position_id;
239: IF (get_position_id_csr%FOUND) THEN
240: IF (l_position_ref_code <> FND_API.G_MISS_CHAR OR
241: l_position_ref_code IS NULL) THEN
242: UPDATE ahl_mc_path_positions SET
243: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
244: LAST_UPDATE_DATE = sysdate,
245: LAST_UPDATED_BY = fnd_global.USER_ID,
246: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,

Line 267: INSERT INTO ahl_mc_path_positions(

263: END IF;
264: CLOSE get_pos_common_id_csr;
265:
266: --Do inserts
267: INSERT INTO ahl_mc_path_positions(
268: PATH_POSITION_ID,
269: PATH_POS_COMMON_ID,
270: OBJECT_VERSION_NUMBER,
271: LAST_UPDATE_DATE,

Line 490: FROM AHL_MC_PATH_POSITIONS pos

486: --
487: --Fetch all encoded path positions like the generated path
488: CURSOR get_matching_pos_csr (p_encoded_path IN VARCHAR2, p_size IN NUMBER) IS
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: --

Line 498: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;

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;
498: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
499: l_api_version CONSTANT NUMBER := 1.0;
500: l_api_name CONSTANT VARCHAR2(30) := 'Map_Instance_To_Positions';
501: l_position_id NUMBER;
502: l_unit_csi_id NUMBER;

Line 1589: FROM ahl_mc_path_positions

1585: order by sequence;
1586: --
1587: CURSOR get_path_position_ref_csr (p_position_id IN NUMBER) IS
1588: SELECT position_ref_code
1589: FROM ahl_mc_path_positions
1590: WHERE path_position_id = p_position_id;
1591: --
1592: l_api_version CONSTANT NUMBER := 1.0;
1593: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Position';

Line 1886: DELETE FROM AHL_MC_PATH_POSITIONS

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;
1888: END IF;
1889: CLOSE check_posid_in_rstmts_csr;
1890:

Line 1916: DELETE FROM AHL_MC_PATH_POSITIONS

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;
1918:
1919: END IF;
1920: CLOSE check_posid_in_rstmts_csr;

Line 1982: FROM AHL_MC_PATH_POSITIONS

1978: IS
1979: --
1980: CURSOR get_pos_ref_csr (p_position_id IN NUMBER) IS
1981: SELECT position_ref_code
1982: FROM AHL_MC_PATH_POSITIONS
1983: WHERE path_position_id = p_position_id;
1984: --
1985: --Select the default position reference.
1986: CURSOR get_def_pos_ref_csr (p_position_id IN NUMBER) IS

Line 2051: FROM AHL_MC_PATH_POSITIONS

2047: IS
2048: --
2049: CURSOR get_path_pos_ref_csr (p_encoded_path IN VARCHAR2) IS
2050: SELECT position_ref_code
2051: FROM AHL_MC_PATH_POSITIONS
2052: WHERE encoded_path_position = p_encoded_path;
2053: --
2054: --Select the default position reference.
2055: CURSOR get_def_path_pos_ref_csr (p_mc_id IN NUMBER,

Line 2069: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;

2065: --
2066: l_pos_ref_code VARCHAR2(30);
2067: l_pos_ref_meaning VARCHAR2(80);
2068: l_pos_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
2069: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
2070: l_return_val BOOLEAN;
2071: --
2072: BEGIN
2073: --Remove the version numbers if any.

Line 2150: FROM AHL_MC_PATH_POSITIONS

2146: AND b.relationship_id = p_rel_id;
2147: --
2148: CURSOR get_path_pos_ref_csr (p_encoded_path IN VARCHAR2) IS
2149: SELECT position_ref_code
2150: FROM AHL_MC_PATH_POSITIONS
2151: WHERE encoded_path_position = p_encoded_path;
2152: --
2153: --Select the default position reference.
2154: CURSOR get_def_path_pos_ref_csr (p_relationship_id IN NUMBER) IS

Line 2164: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;

2160: l_pos_ref_meaning VARCHAR2(80);
2161: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
2162: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
2163: l_index NUMBER;
2164: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
2165: l_return_val BOOLEAN;
2166: l_uc_header NUMBER;
2167: --
2168: BEGIN

Line 2241: l_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;

2237: )
2238: RETURN VARCHAR2
2239: IS
2240: --
2241: l_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
2242: l_path_pos_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
2243: --
2244: BEGIN
2245: l_path := '';