1 PACKAGE AST_camp_reason_PVT AUTHID CURRENT_USER as
2 /* $Header: astvrcns.pls 115.7 2002/02/06 11:44:22 pkm ship $ */
3
4 -- Start of Comments
5 -- Package name : AST_camp_reason_PVT
6 -- Purpose :
7 -- History :
8 -- NOTE :
9 -- End of Comments
10
11 -- Default number of records fetch per call
12 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
13 -- *******************************************************
14 -- Start of Comments
15 -- -------------------------------------------------------
16 -- Record name:camp_reason_Rec_Type
17 -- -------------------------------------------------------
18 -- Parameters:
19 --
20 -- Required:
21 -- Defaults:
22 -- Note: This is automatic generated record definition, it includes all columns
23 -- defined in the table, developer must manually add or delete some of the attributes.
24 --
25 -- End of Comments
26
27 TYPE camp_reason_Rec_Type IS RECORD
28 (
29 reason_id NUMBER := FND_API.G_MISS_NUM,
30 object_id NUMBER := FND_API.G_MISS_NUM,
31 object_version_number NUMBER := FND_API.G_MISS_NUM,
32 created_by NUMBER := FND_API.G_MISS_NUM,
33 creation_date DATE := FND_API.G_MISS_DATE,
34 last_updated_by NUMBER := FND_API.G_MISS_NUM,
35 last_update_date DATE := FND_API.G_MISS_DATE,
36 last_update_login NUMBER := FND_API.G_MISS_NUM,
37 object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
38 source_code_id NUMBER := FND_API.G_MISS_NUM,
39 source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
40 );
41
42 G_MISS_camp_reason_REC camp_reason_Rec_Type;
43 TYPE camp_reason_Tbl_Type IS TABLE OF camp_reason_Rec_Type
44 INDEX BY BINARY_INTEGER;
45 G_MISS_camp_reason_TBL camp_reason_Tbl_Type;
46
47 -- *******************************************************
48 -- Start of Comments
49 -- *******************************************************
50 -- API Name: Create_camp_reason
51 -- Type : Private
52 -- Pre-Req :
53 -- Parameters:
54 -- IN
55 -- p_api_version_number IN NUMBER Required
56 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
57 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
58 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
59 -- P_camp_reason_Rec IN camp_reason_Rec_Type Required
60 --
61 -- OUT:
62 -- x_return_status OUT VARCHAR2
63 -- x_msg_count OUT NUMBER
64 -- x_msg_data OUT VARCHAR2
65 -- Version : Current version 2.0
66 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
67 -- and basic operation, developer must manually add parameters and business logic as necessary.
68
69 --
70 -- End of Comments
71 --
72 FUNCTION get_camp_reason_REC RETURN AST_camp_reason_PVT.camp_reason_rec_type;
73
74 PROCEDURE Create_camp_reason(
75 P_Api_Version_Number 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_camp_reason_Rec IN camp_reason_Rec_Type := G_MISS_camp_reason_REC,
80 X_Return_Status OUT VARCHAR2,
81 X_Msg_Count OUT NUMBER,
82 X_Msg_Data OUT VARCHAR2
83 );
84
85 -- *******************************************************
86 -- Start of Comments
87 -- *******************************************************
88 -- API Name: Delete_camp_reason
89 -- Type : Private
90 -- Pre-Req :
91 -- Parameters:
92 -- IN
93 -- p_api_version_number IN NUMBER Required
94 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97 -- P_camp_reason_Rec IN camp_reason_Rec_Type Required
98 --
99 -- OUT:
100 -- x_return_status OUT VARCHAR2
101 -- x_msg_count OUT NUMBER
102 -- x_msg_data OUT VARCHAR2
103 -- Version : Current version 2.0
104 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
105 -- and basic operation, developer must manually add parameters and business logic as necessary.
106
107 --
108 -- End of Comments
109 --
110 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
111 -- The Master delete procedure may not be needed depends on different business requirements.
112 PROCEDURE Delete_camp_reason(
113 P_Api_Version_Number IN NUMBER,
114 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
115 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
116 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117 P_camp_reason_Rec IN camp_reason_Rec_Type,
118 X_Return_Status OUT VARCHAR2,
119 X_Msg_Count OUT NUMBER,
120 X_Msg_Data OUT VARCHAR2
121 );
122 End AST_camp_reason_PVT;