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 250: UPDATE ahl_mc_path_positions SET

246: IF (l_position_ref_code <> FND_API.G_MISS_CHAR OR
247: l_position_ref_code IS NULL) THEN
248: */
249: IF (l_position_ref_code IS NOT NULL) THEN
250: UPDATE ahl_mc_path_positions SET
251: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
252: LAST_UPDATE_DATE = sysdate,
253: LAST_UPDATED_BY = fnd_global.USER_ID,
254: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,

Line 276: INSERT INTO ahl_mc_path_positions(

272: END IF;
273: CLOSE get_pos_common_id_csr;
274:
275: --Do inserts
276: INSERT INTO ahl_mc_path_positions(
277: PATH_POSITION_ID,
278: PATH_POS_COMMON_ID,
279: OBJECT_VERSION_NUMBER,
280: LAST_UPDATE_DATE,

Line 499: FROM AHL_MC_PATH_POSITIONS pos

495: --
496: --Fetch all encoded path positions like the generated path
497: CURSOR get_matching_pos_csr (p_encoded_path IN VARCHAR2, p_size IN NUMBER) IS
498: SELECT pos.path_position_id
499: FROM AHL_MC_PATH_POSITIONS pos
500: -- Query modified by jaramana on 12-JUN-2012 to fix perf bug 13629335
501: -- The first predicate ensures that any index on encoded_path_position is used for improved performance
502: -- The second predicate (with the variable in the LHS and the table column value having embedded wild card characters in the RHS)
503: -- does the wild card comparison correctly

Line 527: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;

523:
524: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
525: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
526: l_index NUMBER;
527: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
528: l_api_version CONSTANT NUMBER := 1.0;
529: l_api_name CONSTANT VARCHAR2(30) := 'Map_Instance_To_Positions';
530: l_position_id NUMBER;
531: l_unit_csi_id NUMBER;

Line 1647: FROM ahl_mc_path_positions

1643: order by sequence;
1644: --
1645: CURSOR get_path_position_ref_csr (p_position_id IN NUMBER) IS
1646: SELECT position_ref_code
1647: FROM ahl_mc_path_positions
1648: WHERE path_position_id = p_position_id;
1649: --
1650: l_api_version CONSTANT NUMBER := 1.0;
1651: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Position';

Line 1944: DELETE FROM AHL_MC_PATH_POSITIONS

1940: --Delete the position_id
1941: DELETE FROM AHL_MC_PATH_POSITION_NODES
1942: WHERE path_position_id = l_position_id;
1943:
1944: DELETE FROM AHL_MC_PATH_POSITIONS
1945: WHERE path_position_id = l_position_id;
1946: END IF;
1947: CLOSE check_posid_in_rstmts_csr;
1948:

Line 1974: DELETE FROM AHL_MC_PATH_POSITIONS

1970: --Delete the position_id
1971: DELETE FROM AHL_MC_PATH_POSITION_NODES
1972: WHERE path_position_id = l_position_id;
1973:
1974: DELETE FROM AHL_MC_PATH_POSITIONS
1975: WHERE path_position_id = l_position_id;
1976:
1977: END IF;
1978: CLOSE check_posid_in_rstmts_csr;

Line 2040: FROM AHL_MC_PATH_POSITIONS

2036: IS
2037: --
2038: CURSOR get_pos_ref_csr (p_position_id IN NUMBER) IS
2039: SELECT position_ref_code
2040: FROM AHL_MC_PATH_POSITIONS
2041: WHERE path_position_id = p_position_id;
2042: --
2043: --Select the default position reference.
2044: CURSOR get_def_pos_ref_csr (p_position_id IN NUMBER) IS

Line 2109: FROM AHL_MC_PATH_POSITIONS

2105: IS
2106: --
2107: CURSOR get_path_pos_ref_csr (p_encoded_path IN VARCHAR2) IS
2108: SELECT position_ref_code
2109: FROM AHL_MC_PATH_POSITIONS
2110: WHERE encoded_path_position = p_encoded_path;
2111: --
2112: --Select the default position reference.
2113: CURSOR get_def_path_pos_ref_csr (p_mc_id IN NUMBER,

Line 2127: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;

2123: --
2124: l_pos_ref_code VARCHAR2(30);
2125: l_pos_ref_meaning VARCHAR2(80);
2126: l_pos_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
2127: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
2128: l_return_val BOOLEAN;
2129: --
2130: BEGIN
2131: --Remove the version numbers if any.

Line 2208: FROM AHL_MC_PATH_POSITIONS

2204: AND b.relationship_id = p_rel_id;
2205: --
2206: CURSOR get_path_pos_ref_csr (p_encoded_path IN VARCHAR2) IS
2207: SELECT position_ref_code
2208: FROM AHL_MC_PATH_POSITIONS
2209: WHERE encoded_path_position = p_encoded_path;
2210: --
2211: --Select the default position reference.
2212: CURSOR get_def_path_pos_ref_csr (p_relationship_id IN NUMBER) IS

Line 2222: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;

2218: l_pos_ref_meaning VARCHAR2(80);
2219: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
2220: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
2221: l_index NUMBER;
2222: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
2223: l_return_val BOOLEAN;
2224: l_uc_header NUMBER;
2225: --
2226: BEGIN

Line 2299: l_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;

2295: )
2296: RETURN VARCHAR2
2297: IS
2298: --
2299: l_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
2300: l_path_pos_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
2301: --
2302: BEGIN
2303: l_path := '';