[Home] [Help]
PACKAGE: APPS.AMW_RISK_TYPE_PVT
Source
1 PACKAGE amw_risk_type_pvt AS
2 /* $Header: amwvmrts.pls 120.0 2005/05/31 23:13:53 appldev noship $ */
3
4 --===================================================================
5 -- Start of Comments
6 -- ==============================================================================
7 -- Start of Comments
8 -- ==============================================================================
9 -- API Name
10 -- Insert_Delete_Risk_Type
11 -- Type
12 -- Public
13 -- Pre-Req
14 --
15 -- Parameters
16 --
17 -- IN
18 -- p_riskrev_id IN NUMBER Optional Default = null
19 -- p_risk_type_code IN VARCHAR2 Required
20 -- p_select_flag IN VARCHAR2 Required
21 -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
22 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
23 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALS ;
24 --
25 --
26 --
27 -- OUT
28 -- x_return_status OUT VARCHAR2
29 -- x_msg_count OUT NUMBER
30 -- x_msg_data OUT VARCHAR2
31 -- Version : Current version 1.0
32 -- Note:
33 --
34 -- End of Comments
35 -- ==============================================================================
36 --
37 PROCEDURE insert_delete_risk_type (
38 p_risk_rev_id IN NUMBER := NULL,
39 p_risk_type_code IN VARCHAR2 := NULL,
40 p_select_flag IN VARCHAR2 := NULL,
41 p_commit IN VARCHAR2 := fnd_api.g_false,
42 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
43 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
44 p_api_version_number IN NUMBER,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2
48 );
49
50
51 -- ===============================================================
52 -- Procedure name
53 -- Revise_Risk_Type
54 -- Purpose
55 -- revise risk type from old RiskRevId to new RiskRevId
56 -- ===============================================================
57 PROCEDURE Revise_Risk_Type(
58 p_old_risk_rev_id IN NUMBER,
59 p_risk_rev_id IN NUMBER,
60 p_commit IN VARCHAR2 := fnd_api.g_false,
61 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
62 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
63 p_api_version_number IN NUMBER,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2
67 );
68
69 END amw_risk_type_pvt;