APPS.AHL_VWP_VISITS_PUB dependencies on AHL_VWP_VISITS_PVT

Line 8: p_x_visit_rec IN OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type);

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VWP_VISITS_PUB';
5:
6: -- Declare local functions and procedures
7: PROCEDURE Validate_And_Prepare_Params(
8: p_x_visit_rec IN OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type);
9:
10:
11: -------------------------------------------------------------------------------------------
12: -- Start of Comments

Line 20: -- p_x_visit_rec IN OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type

16: -- Pre-reqs :
17: -- Parameters :
18: --
19: -- Create_Visit Parameters:
20: -- p_x_visit_rec IN OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type
21: -- Description of some key attributes in p_x_visit_rec:
22: -- VISIT_NAME VARCHAR2(80) Mandatory
23: -- DESCRIPTION VARCHAR2(4000) Optional
24: -- ORGANIZATION_ID NUMBER Optional

Line 58: p_x_visit_rec IN OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,

54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
56: p_commit IN VARCHAR2 := FND_API.G_FALSE,
57: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58: p_x_visit_rec IN OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2
62: ) IS

Line 68: l_Visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type ;

64: --
65: l_api_version CONSTANT NUMBER := 1.0;
66: l_api_name CONSTANT VARCHAR2(30) := 'Create_Visit';
67: l_full_name CONSTANT VARCHAR2(99) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
68: l_Visit_tbl AHL_VWP_VISITS_PVT.Visit_Tbl_Type ;
69:
70: --
71:
72: BEGIN

Line 99: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'About to call AHL_VWP_VISITS_PVT.Create_Visit.');

95: -- If there are errors, an exception is raised.
96: Validate_And_Prepare_Params(p_x_visit_rec => p_x_visit_rec);
97:
98: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
99: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'About to call AHL_VWP_VISITS_PVT.Create_Visit.');
100: END IF;
101: l_Visit_tbl(1) := p_x_visit_rec;
102:
103: AHL_VWP_VISITS_PVT.Process_Visit(p_api_version => 1.0,

Line 103: AHL_VWP_VISITS_PVT.Process_Visit(p_api_version => 1.0,

99: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'About to call AHL_VWP_VISITS_PVT.Create_Visit.');
100: END IF;
101: l_Visit_tbl(1) := p_x_visit_rec;
102:
103: AHL_VWP_VISITS_PVT.Process_Visit(p_api_version => 1.0,
104: p_init_msg_list => Fnd_Api.g_false,
105: p_commit => Fnd_Api.g_false,
106: p_validation_level => Fnd_Api.g_valid_level_full,
107: p_module_type => 'API',

Line 114: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Returned from AHL_VWP_VISITS_PVT.Create_Visit. x_return_status = ' || x_return_status);

110: x_msg_count => x_msg_count,
111: x_msg_data => x_msg_data);
112:
113: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
114: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Returned from AHL_VWP_VISITS_PVT.Create_Visit. x_return_status = ' || x_return_status);
115: END IF;
116:
117: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
118: RAISE FND_API.G_EXC_ERROR;

Line 178: p_x_visit_rec IN OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type

174: -- It also resets unwanted attributes so that only the attributes needed for creating
175: -- a visit are retained.
176: --
177: PROCEDURE Validate_And_Prepare_Params(
178: p_x_visit_rec IN OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type
179: ) IS
180:
181: l_api_name CONSTANT VARCHAR2(30) := 'Validate_And_Prepare_Params';
182: l_full_name CONSTANT VARCHAR2(99) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;