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.12020000.2 2012/12/07 08:05:07 sareepar 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.12020000.2 2012/12/07 08:05:07 sareepar 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 524: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

520: AND amr.parent_relationship_id is null;
521: --modification by jrotich end
522: --
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;

Line 525: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

521: --modification by jrotich end
522: --
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';

Line 533: l_mc_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

529: l_api_name CONSTANT VARCHAR2(30) := 'Map_Instance_To_Positions';
530: l_position_id NUMBER;
531: l_unit_csi_id NUMBER;
532: --l_mc_path_tbl added by jrotich to fix bug 13472472
533: l_mc_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
534:
535: --
536: BEGIN
537: -- Standard start of API savepoint

Line 747: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

743: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.' || g_pkg_name || '.' || l_api_name;
744: l_index NUMBER;
745: l_dummy VARCHAR2(1);
746: l_top_flag BOOLEAN;
747: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
748: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
749: v_CursorID NUMBER;
750: v_Stmt VARCHAR2(4000);
751: v_Select VARCHAR2(4000);

Line 748: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

744: l_index NUMBER;
745: l_dummy VARCHAR2(1);
746: l_top_flag BOOLEAN;
747: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
748: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
749: v_CursorID NUMBER;
750: v_Stmt VARCHAR2(4000);
751: v_Select VARCHAR2(4000);
752: v_From VARCHAR2(4000);

Line 844: ||' 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'' ';

840: ' AND v'||TO_CHAR(i)||'.mc_version_number = '||
841: ' nvl(:ver'||TO_CHAR(i)||', v'||TO_CHAR(i)||'.mc_version_number) ' ||
842: ' AND v'||TO_CHAR(i-1)||'.uc_header_id = v'||TO_CHAR(i)||'.parent_uc_header_id '
843: ||' AND v'||TO_CHAR(i)||'.parent_position_key = :pos_key'||TO_CHAR(i-1)||' '
844: ||' 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'' ';
845:
846: END LOOP;
847:
848: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 1118: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

1114: l_api_version CONSTANT NUMBER := 1.0;
1115: l_api_name CONSTANT VARCHAR2(30) := 'Get_Pos_Instance';
1116: l_csi_ii_id NUMBER;
1117: l_index NUMBER;
1118: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
1119: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
1120: l_dummy VARCHAR2(1);
1121: l_dummy_id NUMBER;
1122: l_top_flag BOOLEAN;

Line 1119: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

1115: l_api_name CONSTANT VARCHAR2(30) := 'Get_Pos_Instance';
1116: l_csi_ii_id NUMBER;
1117: l_index NUMBER;
1118: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
1119: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
1120: l_dummy VARCHAR2(1);
1121: l_dummy_id NUMBER;
1122: l_top_flag BOOLEAN;
1123: l_found_flag BOOLEAN;

Line 1653: l_pos_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

1649: --
1650: l_api_version CONSTANT NUMBER := 1.0;
1651: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Position';
1652: l_position_node get_mc_path_position_nodes_csr%ROWTYPE;
1653: l_pos_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
1654: l_pos_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
1655: l_mc_id NUMBER;
1656: l_version_number NUMBER;
1657: l_pos_ref_code VARCHAR2(30);

Line 1654: l_pos_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

1650: l_api_version CONSTANT NUMBER := 1.0;
1651: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Position';
1652: l_position_node get_mc_path_position_nodes_csr%ROWTYPE;
1653: l_pos_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
1654: l_pos_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
1655: l_mc_id NUMBER;
1656: l_version_number NUMBER;
1657: l_pos_ref_code VARCHAR2(30);
1658: l_index NUMBER;

Line 2096: -- p_position_path_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type Required

2092: -- Pre-reqs :
2093: -- Parameters :
2094: --
2095: -- get_position_ref_code Parameters:
2096: -- p_position_path_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type Required
2097: -- p_code_flag IN VARHCAR2 If Equal to FND_API.G_TRUE, then return
2098: -- pos ref code, else return pos ref meaning. Default to False.
2099: --
2100: FUNCTION get_posref_by_path(

Line 2101: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,

2097: -- p_code_flag IN VARHCAR2 If Equal to FND_API.G_TRUE, then return
2098: -- pos ref code, else return pos ref meaning. Default to False.
2099: --
2100: FUNCTION get_posref_by_path(
2101: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,
2102: p_code_flag IN VARCHAR2 := FND_API.G_FALSE
2103: )
2104: RETURN VARCHAR2 -- Position Ref Meaning/Code
2105: IS

Line 2126: l_pos_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

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

Line 2219: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

2215: WHERE rel.relationship_id = p_relationship_id;
2216: --
2217: l_pos_ref_code VARCHAR2(30);
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;

Line 2220: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

2216: --
2217: l_pos_ref_code VARCHAR2(30);
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;

Line 2294: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type

2290:
2291: ----------------
2292: ----------------
2293: FUNCTION Encode(
2294: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type
2295: )
2296: RETURN VARCHAR2
2297: IS
2298: --

Line 2300: l_path_pos_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

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

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

2423: p_from_csi_id IN NUMBER,
2424: p_to_csi_id IN NUMBER)
2425: RETURN VARCHAR2 IS
2426: BEGIN
2427: IF (AHL_MC_PATH_POSITION_PVT.CHECK_POS_REF_PATH(p_from_csi_id,p_to_csi_id)) THEN
2428: RETURN 'T';
2429: ELSE
2430: RETURN 'F';
2431: END IF;

Line 2588: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

2584: AND crel.mc_header_id = subrel.mc_header_id
2585: AND subrel.parent_relationship_id IS NULL);
2586: */
2587:
2588: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
2589: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
2590: l_index NUMBER;
2591: l_api_version CONSTANT NUMBER := 1.0;
2592: l_api_name CONSTANT VARCHAR2(30) := 'Map_Instance_To_Pos_Id';

Line 2589: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

2585: AND subrel.parent_relationship_id IS NULL);
2586: */
2587:
2588: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
2589: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
2590: l_index NUMBER;
2591: l_api_version CONSTANT NUMBER := 1.0;
2592: l_api_name CONSTANT VARCHAR2(30) := 'Map_Instance_To_Pos_Id';
2593: l_unit_csi_id NUMBER;

Line 2886: End AHL_MC_PATH_POSITION_PVT;

2882:
2883: RETURN l_ret_val;
2884: END Is_Position_Serial_Controlled;
2885:
2886: End AHL_MC_PATH_POSITION_PVT;