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_PVT

Line 1: PACKAGE BODY AHL_MC_PATH_POSITION_PVT AS

1: PACKAGE BODY AHL_MC_PATH_POSITION_PVT AS
2: /* $Header: AHLVPOSB.pls 120.5 2008/01/29 14:12:16 sathapli ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Ahl_MC_Path_Position_Pvt';
4:
5: --Generic separators for the fields.

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Ahl_MC_Path_Position_Pvt';

1: PACKAGE BODY AHL_MC_PATH_POSITION_PVT AS
2: /* $Header: AHLVPOSB.pls 120.5 2008/01/29 14:12:16 sathapli ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Ahl_MC_Path_Position_Pvt';
4:
5: --Generic separators for the fields.
6: G_ID_SEPARATOR CONSTANT VARCHAR2(1) := ':';
7: G_NODE_SEPARATOR CONSTANT VARCHAR2(1) := '/';

Line 21: -- p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type Required

17: -- Pre-reqs :
18: -- Parameters :
19: --
20: -- Create_Position_ID Parameters:
21: -- p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type Required
22: -- p_pos_ref_meaning IN VARCHAR2 Optional. Position ref for the path
23: --
24: -- End of Comments.
25:

Line 34: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,

30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
33: x_msg_data OUT NOCOPY VARCHAR2,
34: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,
35: p_position_ref_meaning IN VARCHAR2,
36: p_position_ref_code IN VARCHAR2,
37: x_position_id OUT NOCOPY NUMBER)
38: IS

Line 99: l_pos_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

95: --
96: l_junk VARCHAR2(1);
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;

Line 103: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

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;
106: l_index NUMBER;
107: l_sib_pos_ref_code VARCHAR2(30);

Line 109: l_no_ver_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

105: l_return_val BOOLEAN;
106: l_index NUMBER;
107: l_sib_pos_ref_code VARCHAR2(30);
108: l_poskey NUMBER;
109: l_no_ver_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
110: l_common_id NUMBER;
111: l_ver_spec_score NUMBER;
112: l_count NUMBER;
113: --

Line 495: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

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;
498: l_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
499: l_api_version CONSTANT NUMBER := 1.0;

Line 496: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

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;
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';

Line 693: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

689: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.' || g_pkg_name || '.' || l_api_name;
690: l_index NUMBER;
691: l_dummy VARCHAR2(1);
692: l_top_flag BOOLEAN;
693: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
694: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
695: v_CursorID NUMBER;
696: v_Stmt VARCHAR2(4000);
697: v_Select VARCHAR2(4000);

Line 694: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

690: l_index NUMBER;
691: l_dummy VARCHAR2(1);
692: l_top_flag BOOLEAN;
693: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
694: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
695: v_CursorID NUMBER;
696: v_Stmt VARCHAR2(4000);
697: v_Select VARCHAR2(4000);
698: v_From VARCHAR2(4000);

Line 790: ||' AND AHL_MC_PATH_POSITION_PVT.CHECK_POS_REF_PATH_CHAR(v'||TO_CHAR(i)||'.csi_instance_id, v'||TO_CHAR(i)||'.parent_instance_id) = ''T'' ';

786: ' AND v'||TO_CHAR(i)||'.mc_version_number = '||
787: ' nvl(:ver'||TO_CHAR(i)||', v'||TO_CHAR(i)||'.mc_version_number) ' ||
788: ' AND v'||TO_CHAR(i-1)||'.uc_header_id = v'||TO_CHAR(i)||'.parent_uc_header_id '
789: ||' AND v'||TO_CHAR(i)||'.parent_position_key = :pos_key'||TO_CHAR(i-1)||' '
790: ||' AND AHL_MC_PATH_POSITION_PVT.CHECK_POS_REF_PATH_CHAR(v'||TO_CHAR(i)||'.csi_instance_id, v'||TO_CHAR(i)||'.parent_instance_id) = ''T'' ';
791:
792: END LOOP;
793:
794: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 1060: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

1056: l_api_version CONSTANT NUMBER := 1.0;
1057: l_api_name CONSTANT VARCHAR2(30) := 'Get_Pos_Instance';
1058: l_csi_ii_id NUMBER;
1059: l_index NUMBER;
1060: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
1061: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
1062: l_dummy VARCHAR2(1);
1063: l_dummy_id NUMBER;
1064: l_top_flag BOOLEAN;

Line 1061: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

1057: l_api_name CONSTANT VARCHAR2(30) := 'Get_Pos_Instance';
1058: l_csi_ii_id NUMBER;
1059: l_index NUMBER;
1060: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
1061: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
1062: l_dummy VARCHAR2(1);
1063: l_dummy_id NUMBER;
1064: l_top_flag BOOLEAN;
1065: l_found_flag BOOLEAN;

Line 1595: l_pos_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

1591: --
1592: l_api_version CONSTANT NUMBER := 1.0;
1593: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Position';
1594: l_position_node get_mc_path_position_nodes_csr%ROWTYPE;
1595: l_pos_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
1596: l_pos_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
1597: l_mc_id NUMBER;
1598: l_version_number NUMBER;
1599: l_pos_ref_code VARCHAR2(30);

Line 1596: l_pos_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

1592: l_api_version CONSTANT NUMBER := 1.0;
1593: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Position';
1594: l_position_node get_mc_path_position_nodes_csr%ROWTYPE;
1595: l_pos_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
1596: l_pos_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
1597: l_mc_id NUMBER;
1598: l_version_number NUMBER;
1599: l_pos_ref_code VARCHAR2(30);
1600: l_index NUMBER;

Line 2038: -- p_position_path_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type Required

2034: -- Pre-reqs :
2035: -- Parameters :
2036: --
2037: -- get_position_ref_code Parameters:
2038: -- p_position_path_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type Required
2039: -- p_code_flag IN VARHCAR2 If Equal to FND_API.G_TRUE, then return
2040: -- pos ref code, else return pos ref meaning. Default to False.
2041: --
2042: FUNCTION get_posref_by_path(

Line 2043: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,

2039: -- p_code_flag IN VARHCAR2 If Equal to FND_API.G_TRUE, then return
2040: -- pos ref code, else return pos ref meaning. Default to False.
2041: --
2042: FUNCTION get_posref_by_path(
2043: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,
2044: p_code_flag IN VARCHAR2 := FND_API.G_FALSE
2045: )
2046: RETURN VARCHAR2 -- Position Ref Meaning/Code
2047: IS

Line 2068: l_pos_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

2064: order by hd.version_number desc;
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

Line 2161: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

2157: WHERE rel.relationship_id = p_relationship_id;
2158: --
2159: l_pos_ref_code VARCHAR2(30);
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;

Line 2162: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

2158: --
2159: l_pos_ref_code VARCHAR2(30);
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;

Line 2236: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type

2232:
2233: ----------------
2234: ----------------
2235: FUNCTION Encode(
2236: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type
2237: )
2238: RETURN VARCHAR2
2239: IS
2240: --

Line 2242: l_path_pos_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

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 := '';
2246:

Line 2369: IF (AHL_MC_PATH_POSITION_PVT.CHECK_POS_REF_PATH(p_from_csi_id,p_to_csi_id)) THEN

2365: p_from_csi_id IN NUMBER,
2366: p_to_csi_id IN NUMBER)
2367: RETURN VARCHAR2 IS
2368: BEGIN
2369: IF (AHL_MC_PATH_POSITION_PVT.CHECK_POS_REF_PATH(p_from_csi_id,p_to_csi_id)) THEN
2370: RETURN 'T';
2371: ELSE
2372: RETURN 'F';
2373: END IF;

Line 2530: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

2526: AND crel.mc_header_id = subrel.mc_header_id
2527: AND subrel.parent_relationship_id IS NULL);
2528: */
2529:
2530: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
2531: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
2532: l_index NUMBER;
2533: l_api_version CONSTANT NUMBER := 1.0;
2534: l_api_name CONSTANT VARCHAR2(30) := 'Map_Instance_To_Pos_Id';

Line 2531: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

2527: AND subrel.parent_relationship_id IS NULL);
2528: */
2529:
2530: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
2531: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
2532: l_index NUMBER;
2533: l_api_version CONSTANT NUMBER := 1.0;
2534: l_api_name CONSTANT VARCHAR2(30) := 'Map_Instance_To_Pos_Id';
2535: l_unit_csi_id NUMBER;

Line 2828: End AHL_MC_PATH_POSITION_PVT;

2824:
2825: RETURN l_ret_val;
2826: END Is_Position_Serial_Controlled;
2827:
2828: End AHL_MC_PATH_POSITION_PVT;