[Home] [Help]
PACKAGE: APPS.CSC_PROF_COLOR_CODE_PUB
Source
1 PACKAGE CSC_PROF_COLOR_CODE_PUB AUTHID CURRENT_USER as
2 /* $Header: cscppccs.pls 115.6 2002/11/29 04:21:22 bhroy ship $ */
3 -- Start of Comments
4 -- Package name : CSC_PROF_COLOR_CODE_PUB
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:prof_color_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- COLOR_CODE
19 -- RATING_CODE
20 -- LAST_UPDATE_DATE
21 -- LAST_UPDATED_BY
22 -- CREATION_DATE
23 -- CREATED_BY
24 -- LAST_UPDATE_LOGIN
25 --
26 -- Required:
27 -- Defaults:
28 --
29 -- End of Comments
30
31 TYPE prof_color_Rec_Type IS RECORD
32 (
33 COLOR_CODE VARCHAR2(30),
34 RATING_CODE VARCHAR2(30),
35 LAST_UPDATE_DATE DATE,
36 LAST_UPDATED_BY NUMBER,
37 CREATION_DATE DATE,
38 CREATED_BY NUMBER,
39 LAST_UPDATE_LOGIN NUMBER
40 );
41
42 G_MISS_prof_color_rec_type_REC prof_color_Rec_Type;
43 TYPE prof_color_rec_type_Tbl_Type IS TABLE OF prof_color_Rec_Type
44 INDEX BY BINARY_INTEGER;
45 G_MISS_prof_color_rec_type_TBL prof_color_rec_type_Tbl_Type;
46
47 TYPE color_rec_sort_rec_type IS RECORD
48 (
49 -- Please define your own sort by record here.
50 RATING_CODE NUMBER := NULL
51 );
52
53 -- *******************************************************
54 -- Start of Comments
55 -- *******************************************************
56 -- API Name: Create_prof_color_code
57 -- Type : Public
58 -- Pre-Req :
59 -- Parameters:
60 -- IN
61 -- p_api_version_number IN NUMBER Required
62 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
63 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
64 -- P_prof_color_rec_type_Rec IN prof_color_Rec_Type Required
65 --
66 -- OUT :
67 -- x_return_status OUT NOCOPY VARCHAR2
68 -- x_msg_count OUT NOCOPY NUMBER
69 -- x_msg_data OUT NOCOPY VARCHAR2
70 --
71 -- End of Comments
72 --
73
74 PROCEDURE Create_prof_color_code(
75 P_Api_Version_Number IN NUMBER,
76 P_Init_Msg_List IN VARCHAR2,
77 P_Commit IN VARCHAR2,
78 px_COLOR_CODE IN OUT NOCOPY VARCHAR2 ,
79 p_RATING_CODE VARCHAR2 DEFAULT NULL,
80 p_LAST_UPDATE_DATE DATE DEFAULT NULL,
81 p_LAST_UPDATED_BY NUMBER DEFAULT NULL,
82 p_CREATION_DATE DATE DEFAULT NULL,
83 p_CREATED_BY NUMBER DEFAULT NULL,
84 p_LAST_UPDATE_LOGIN NUMBER DEFAULT NULL,
85 X_Return_Status OUT NOCOPY VARCHAR2,
86 X_Msg_Count OUT NOCOPY NUMBER,
87 X_Msg_Data OUT NOCOPY VARCHAR2
88 );
89
90 PROCEDURE Create_prof_color_code(
91 P_Api_Version_Number IN NUMBER,
92 P_Init_Msg_List IN VARCHAR2,
93 P_Commit IN VARCHAR2,
94 P_prof_color_rec IN prof_color_Rec_Type,
95 px_COLOR_CODE IN OUT NOCOPY VARCHAR2,
96 X_Return_Status OUT NOCOPY VARCHAR2,
97 X_Msg_Count OUT NOCOPY NUMBER,
98 X_Msg_Data OUT NOCOPY VARCHAR2
99 );
100
101 -- *******************************************************
102 -- Start of Comments
103 -- *******************************************************
104 -- API Name: Update_prof_color_code
105 -- Type : Public
106 -- Pre-Req :
107 -- Parameters:
108 -- IN
109 -- p_api_version_number IN NUMBER Required
110 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112 -- P_prof_color_rec_type_Rec IN prof_color_Rec_Type Required
113 --
114 -- OUT :
115 -- x_return_status OUT NOCOPY VARCHAR2
116 -- x_msg_count OUT NOCOPY NUMBER
117 -- x_msg_data OUT NOCOPY VARCHAR2
118 -- End of Comments
119 --
120
121 PROCEDURE Update_prof_color_code(
122 P_Api_Version_Number IN NUMBER,
123 P_Init_Msg_List IN VARCHAR2,
124 P_Commit IN VARCHAR2,
125 p_COLOR_CODE VARCHAR2 DEFAULT NULL,
126 p_RATING_CODE VARCHAR2 DEFAULT NULL,
127 p_LAST_UPDATE_DATE DATE DEFAULT NULL,
128 p_LAST_UPDATED_BY NUMBER DEFAULT NULL,
129 p_CREATION_DATE DATE DEFAULT NULL,
130 p_CREATED_BY NUMBER DEFAULT NULL,
131 p_LAST_UPDATE_LOGIN NUMBER DEFAULT NULL,
132 X_Return_Status OUT NOCOPY VARCHAR2,
133 X_Msg_Count OUT NOCOPY NUMBER,
134 X_Msg_Data OUT NOCOPY VARCHAR2
135 );
136
137 PROCEDURE Update_prof_color_code(
138 P_Api_Version_Number IN NUMBER,
139 P_Init_Msg_List IN VARCHAR2,
140 P_Commit IN VARCHAR2,
141 P_prof_color_rec IN prof_color_Rec_Type,
142 X_Return_Status OUT NOCOPY VARCHAR2,
143 X_Msg_Count OUT NOCOPY NUMBER,
144 X_Msg_Data OUT NOCOPY VARCHAR2
145 );
146
147 End CSC_PROF_COLOR_CODE_PUB;