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