1 PACKAGE AHL_VWP_MR_CST_PR_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVMCPS.pls 115.1 2003/09/25 21:15:08 rtadikon noship $ */
3 -----------------------------------------------------------
4 -- PACKAGE
5 -- AHL_VWP_MR_CST_PR_PVT
6 --
7 -- PURPOSE
8 -- This package is a Private API for managing Visit Stages information in CMRO.
9 -- It contains specification for pl/sql records and tables
10 --
11 -- Estimate_mr_cost (see below for specification)
12 -- Estimate_mr_price (see below for specification)
13 --
14 --
15 -- NOTES
16 --
17 --
18 -- HISTORY
19 --
20 --
21 -- Created By Rajanath Tadikonda/rtadikon 25-Aug-2003
22 --
23 -----------------------------------------------------------
24
25 -------------------------------------
26 -- Visit MR Record Type -----
27 -------------------------------------
28 --
29
30 ---------------------------------------------------------------------
31 -- PROCEDURE
32 -- Estimate_mr_cost
33 -- Estimate_mr_price
34 --
35 -- PURPOSE
36 --
37 --
38 -- PARAMETERS
39 --
40 --
41 --
42 -- NOTES
43 -- 1. Procedure helps out to link between JSP page and API package
44 -- 2. On the basis of operation flag as one field in each record type
45 -- the further procedure for create/update/delete for Visit MRs.
46 ---------------------------------------------------------------------
47
48 PROCEDURE Estimate_MR_Cost (
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 :=Fnd_Api.g_false,
51 p_commit IN VARCHAR2 :=Fnd_Api.g_false,
52 p_validation_level IN NUMBER :=Fnd_Api.g_valid_level_full,
53 p_module_type IN VARCHAR2,
54 p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60
61 PROCEDURE Estimate_MR_Price (
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
64 p_commit IN VARCHAR2 :=Fnd_Api.g_false,
65 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
66 p_module_type IN VARCHAR2,
67 p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73
74 PROCEDURE Get_MR_Items_No_Price(
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
77 p_commit IN VARCHAR2 :=Fnd_Api.g_false,
78 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
79 p_module_type IN VARCHAR2,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_cost_price_rec IN AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
84 x_cost_price_tbl OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type
85 );
86
87 PROCEDURE Get_MR_Cost_Details(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
90 p_commit IN VARCHAR2 :=Fnd_Api.g_false,
91 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
92 p_module_type IN VARCHAR2,
93 p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99 END AHL_VWP_MR_CST_PR_PVT;