APPS.AHL_UC_UTILIZATION_PVT dependencies on AHL_UC_UTILIZATION_PVT

Line 1: PACKAGE BODY AHL_UC_UTILIZATION_PVT AS

1: PACKAGE BODY AHL_UC_UTILIZATION_PVT AS
2: /* $Header: AHLVUCUB.pls 120.4.12010000.3 2008/12/04 01:15:24 jaramana ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UC_UTILIZATION_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UC_UTILIZATION_PVT';

1: PACKAGE BODY AHL_UC_UTILIZATION_PVT AS
2: /* $Header: AHLVUCUB.pls 120.4.12010000.3 2008/12/04 01:15:24 jaramana ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UC_UTILIZATION_PVT';
5:
6: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_UC_UTILIZATION_PVT';
7:
8: -- Added by jaramana on 03-DEC-2008 to improve performance by localising FND_LOG package variables.

Line 6: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_UC_UTILIZATION_PVT';

2: /* $Header: AHLVUCUB.pls 120.4.12010000.3 2008/12/04 01:15:24 jaramana ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UC_UTILIZATION_PVT';
5:
6: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_UC_UTILIZATION_PVT';
7:
8: -- Added by jaramana on 03-DEC-2008 to improve performance by localising FND_LOG package variables.
9: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 17: PROCEDURE convert_value_id(p_utilization_rec IN OUT NOCOPY AHL_UC_UTILIZATION_PVT.utilization_rec_type);

13: ----------------------------------------------
14: -- Define local Procedures for Utilization --
15: ----------------------------------------------
16: -- Convert Value to ID.
17: PROCEDURE convert_value_id(p_utilization_rec IN OUT NOCOPY AHL_UC_UTILIZATION_PVT.utilization_rec_type);
18:
19: -- Validate utilization record and get the two flag variables
20: PROCEDURE validate_utilization_rec(p_utilization_rec IN OUT NOCOPY AHL_UC_UTILIZATION_PVT.utilization_rec_type,
21: x_found OUT NOCOPY VARCHAR2,

Line 20: PROCEDURE validate_utilization_rec(p_utilization_rec IN OUT NOCOPY AHL_UC_UTILIZATION_PVT.utilization_rec_type,

16: -- Convert Value to ID.
17: PROCEDURE convert_value_id(p_utilization_rec IN OUT NOCOPY AHL_UC_UTILIZATION_PVT.utilization_rec_type);
18:
19: -- Validate utilization record and get the two flag variables
20: PROCEDURE validate_utilization_rec(p_utilization_rec IN OUT NOCOPY AHL_UC_UTILIZATION_PVT.utilization_rec_type,
21: x_found OUT NOCOPY VARCHAR2,
22: x_based_on OUT NOCOPY VARCHAR2);
23:
24: -- Update counter reading only for a given counter_id (p_cascade_flag is not applicable)

Line 102: p_utilization_tbl IN AHL_UC_UTILIZATION_PVT.utilization_tbl_type,

98: PROCEDURE update_utilization(p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
100: p_commit IN VARCHAR2 := FND_API.G_FALSE,
101: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
102: p_utilization_tbl IN AHL_UC_UTILIZATION_PVT.utilization_tbl_type,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2)
106: IS

Line 109: l_utilization_rec AHL_UC_UTILIZATION_PVT.utilization_rec_type;

105: x_msg_data OUT NOCOPY VARCHAR2)
106: IS
107: l_api_name CONSTANT VARCHAR2(30) := 'update_utilization';
108: l_api_version CONSTANT NUMBER := 1.0;
109: l_utilization_rec AHL_UC_UTILIZATION_PVT.utilization_rec_type;
110: l_utilization_tbl AHL_UC_UTILIZATION_PVT.utilization_tbl_type DEFAULT p_utilization_tbl;
111: l_found VARCHAR2(50) := NULL;
112: l_based_on VARCHAR2(50) := NULL;
113:

Line 110: l_utilization_tbl AHL_UC_UTILIZATION_PVT.utilization_tbl_type DEFAULT p_utilization_tbl;

106: IS
107: l_api_name CONSTANT VARCHAR2(30) := 'update_utilization';
108: l_api_version CONSTANT NUMBER := 1.0;
109: l_utilization_rec AHL_UC_UTILIZATION_PVT.utilization_rec_type;
110: l_utilization_tbl AHL_UC_UTILIZATION_PVT.utilization_tbl_type DEFAULT p_utilization_tbl;
111: l_found VARCHAR2(50) := NULL;
112: l_based_on VARCHAR2(50) := NULL;
113:
114: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Update_Utilization';

Line 233: AHL_UC_UTILIZATION_PVT.utilization_rec_type)

229:
230: ---------------------------------------------------------------------------------
231:
232: PROCEDURE convert_value_id(p_utilization_rec IN OUT NOCOPY
233: AHL_UC_UTILIZATION_PVT.utilization_rec_type)
234: IS
235: -- For organization id.
236: CURSOR mtl_parameters_csr(c_org_code VARCHAR2) IS
237: SELECT organization_id

Line 373: PROCEDURE validate_utilization_rec(p_utilization_rec IN OUT NOCOPY AHL_UC_UTILIZATION_PVT.utilization_rec_type,

369: END convert_value_id;
370:
371: ---------------------------------------------------------------------------------
372:
373: PROCEDURE validate_utilization_rec(p_utilization_rec IN OUT NOCOPY AHL_UC_UTILIZATION_PVT.utilization_rec_type,
374: x_found OUT NOCOPY VARCHAR2,
375: x_based_on OUT NOCOPY VARCHAR2)
376: IS
377: -- Get location type code.

Line 1658: END AHL_UC_UTILIZATION_PVT;

1654: FND_MSG_PUB.add;
1655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1656: END get_counter_ratio;
1657:
1658: END AHL_UC_UTILIZATION_PVT;