76: -- Procedure to get visit cost details for a specific visit --
77: --------------------------------------------------------------------------
78: PROCEDURE get_visit_cost_details(
79: p_api_version IN NUMBER := 1.0,
80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: p_module_type IN VARCHAR2 := 'JSP',
84: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
77: --------------------------------------------------------------------------
78: PROCEDURE get_visit_cost_details(
79: p_api_version IN NUMBER := 1.0,
80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: p_module_type IN VARCHAR2 := 'JSP',
84: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
85: x_return_status OUT NOCOPY VARCHAR2,
78: PROCEDURE get_visit_cost_details(
79: p_api_version IN NUMBER := 1.0,
80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: p_module_type IN VARCHAR2 := 'JSP',
84: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
90: -- Procedure to estimate visit cost for a specific visit --
91: --------------------------------------------------------------------------
92: PROCEDURE estimate_visit_cost(
93: p_api_version IN NUMBER := 1.0,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
97: p_module_type IN VARCHAR2 := 'JSP',
98: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
91: --------------------------------------------------------------------------
92: PROCEDURE estimate_visit_cost(
93: p_api_version IN NUMBER := 1.0,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
97: p_module_type IN VARCHAR2 := 'JSP',
98: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
99: x_return_status OUT NOCOPY VARCHAR2,
92: PROCEDURE estimate_visit_cost(
93: p_api_version IN NUMBER := 1.0,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
97: p_module_type IN VARCHAR2 := 'JSP',
98: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
104: -- Procedure to estimate visit price for a specific visit --
105: --------------------------------------------------------------------------
106: PROCEDURE estimate_visit_price(
107: p_api_version IN NUMBER := 1.0,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111: p_module_type IN VARCHAR2 := 'JSP',
112: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
105: --------------------------------------------------------------------------
106: PROCEDURE estimate_visit_price(
107: p_api_version IN NUMBER := 1.0,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111: p_module_type IN VARCHAR2 := 'JSP',
112: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
113: x_return_status OUT NOCOPY VARCHAR2,
106: PROCEDURE estimate_visit_price(
107: p_api_version IN NUMBER := 1.0,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111: p_module_type IN VARCHAR2 := 'JSP',
112: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
118: -- Procedure to take a price snapshot for a specific visit --
119: --------------------------------------------------------------------------
120: PROCEDURE create_price_snapshot(
121: p_api_version IN NUMBER := 1.0,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: p_module_type IN VARCHAR2 := 'JSP',
126: p_visit_id IN NUMBER,
119: --------------------------------------------------------------------------
120: PROCEDURE create_price_snapshot(
121: p_api_version IN NUMBER := 1.0,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: p_module_type IN VARCHAR2 := 'JSP',
126: p_visit_id IN NUMBER,
127: x_return_status OUT NOCOPY VARCHAR2,
120: PROCEDURE create_price_snapshot(
121: p_api_version IN NUMBER := 1.0,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: p_module_type IN VARCHAR2 := 'JSP',
126: p_visit_id IN NUMBER,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
132: -- Procedure to take a cost snapshot for a specific visit --
133: --------------------------------------------------------------------------
134: PROCEDURE create_cost_snapshot(
135: p_api_version IN NUMBER := 1.0,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: p_module_type IN VARCHAR2 := 'JSP',
140: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
133: --------------------------------------------------------------------------
134: PROCEDURE create_cost_snapshot(
135: p_api_version IN NUMBER := 1.0,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: p_module_type IN VARCHAR2 := 'JSP',
140: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
141: x_return_status OUT NOCOPY VARCHAR2,
134: PROCEDURE create_cost_snapshot(
135: p_api_version IN NUMBER := 1.0,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: p_module_type IN VARCHAR2 := 'JSP',
140: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
146: -- Procedure to get visit cost details for a specific visit --
147: --------------------------------------------------------------------------
148: PROCEDURE update_visit_cost_details(
149: p_api_version IN NUMBER := 1.0,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: p_module_type IN VARCHAR2 := 'JSP',
154: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
147: --------------------------------------------------------------------------
148: PROCEDURE update_visit_cost_details(
149: p_api_version IN NUMBER := 1.0,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: p_module_type IN VARCHAR2 := 'JSP',
154: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
155: x_return_status OUT NOCOPY VARCHAR2,
148: PROCEDURE update_visit_cost_details(
149: p_api_version IN NUMBER := 1.0,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: p_module_type IN VARCHAR2 := 'JSP',
154: p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
158:
159: PROCEDURE Get_Visit_Items_no_price
160: (
161: p_api_version IN NUMBER := 1.0,
162: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: p_module_type IN VARCHAR2 :=NULL,
166: x_return_status OUT NOCOPY VARCHAR2,
159: PROCEDURE Get_Visit_Items_no_price
160: (
161: p_api_version IN NUMBER := 1.0,
162: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: p_module_type IN VARCHAR2 :=NULL,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
160: (
161: p_api_version IN NUMBER := 1.0,
162: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: p_module_type IN VARCHAR2 :=NULL,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,