eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_PROF_COLOR_CODE_PVT dependencies on CSC_CORE_UTILS_PVT

Line 55: -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE

51: -- Pre-Req :
52: -- Parameters:
53: -- IN
54: -- p_api_version_number IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE
56: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
57: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
58: -- P_prof_color_rec_type_Rec IN prof_color_Rec_Type Required
59: --

Line 56: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE

52: -- Parameters:
53: -- IN
54: -- p_api_version_number IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE
56: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
57: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
58: -- P_prof_color_rec_type_Rec IN prof_color_Rec_Type Required
59: --
60: -- OUT:

Line 57: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL

53: -- IN
54: -- p_api_version_number IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE
56: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
57: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
58: -- P_prof_color_rec_type_Rec IN prof_color_Rec_Type Required
59: --
60: -- OUT:
61: -- x_return_status OUT VARCHAR2

Line 72: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

68: -- End of Comments
69: --
70: PROCEDURE Create_prof_color_code(
71: P_Api_Version_Number IN NUMBER,
72: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
73: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
74: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
75: px_COLOR_CODE IN OUT NOCOPY VARCHAR2 ,
76: p_RATING_CODE IN VARCHAR2,

Line 73: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

69: --
70: PROCEDURE Create_prof_color_code(
71: P_Api_Version_Number IN NUMBER,
72: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
73: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
74: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
75: px_COLOR_CODE IN OUT NOCOPY VARCHAR2 ,
76: p_RATING_CODE IN VARCHAR2,
77: p_LAST_UPDATE_DATE IN DATE ,

Line 74: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

70: PROCEDURE Create_prof_color_code(
71: P_Api_Version_Number IN NUMBER,
72: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
73: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
74: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
75: px_COLOR_CODE IN OUT NOCOPY VARCHAR2 ,
76: p_RATING_CODE IN VARCHAR2,
77: p_LAST_UPDATE_DATE IN DATE ,
78: p_LAST_UPDATED_BY IN NUMBER,

Line 89: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

85: );
86:
87: PROCEDURE Create_prof_color_code(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
92: P_prof_color_rec IN prof_color_Rec_Type := G_MISS_prof_color_rec_type_REC,
93: px_COLOR_CODE IN OUT NOCOPY VARCHAR2,

Line 90: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

86:
87: PROCEDURE Create_prof_color_code(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
92: P_prof_color_rec IN prof_color_Rec_Type := G_MISS_prof_color_rec_type_REC,
93: px_COLOR_CODE IN OUT NOCOPY VARCHAR2,
94: X_Return_Status OUT NOCOPY VARCHAR2,

Line 91: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

87: PROCEDURE Create_prof_color_code(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
92: P_prof_color_rec IN prof_color_Rec_Type := G_MISS_prof_color_rec_type_REC,
93: px_COLOR_CODE IN OUT NOCOPY VARCHAR2,
94: X_Return_Status OUT NOCOPY VARCHAR2,
95: X_Msg_Count OUT NOCOPY NUMBER,

Line 108: -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE

104: -- Pre-Req :
105: -- Parameters:
106: -- IN
107: -- p_api_version_number IN NUMBER Required
108: -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE
109: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
110: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
111: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
112: -- P_prof_color_rec_type_Rec IN prof_color_Rec_Type Required

Line 109: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE

105: -- Parameters:
106: -- IN
107: -- p_api_version_number IN NUMBER Required
108: -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE
109: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
110: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
111: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
112: -- P_prof_color_rec_type_Rec IN prof_color_Rec_Type Required
113: --

Line 110: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL

106: -- IN
107: -- p_api_version_number IN NUMBER Required
108: -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE
109: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
110: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
111: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
112: -- P_prof_color_rec_type_Rec IN prof_color_Rec_Type Required
113: --
114: -- OUT:

Line 127: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

123: --
124:
125: PROCEDURE Update_prof_color_code(
126: P_Api_Version_Number IN NUMBER,
127: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
128: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
129: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
130: p_COLOR_CODE IN VARCHAR2,
131: p_RATING_CODE IN VARCHAR2,

Line 128: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

124:
125: PROCEDURE Update_prof_color_code(
126: P_Api_Version_Number IN NUMBER,
127: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
128: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
129: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
130: p_COLOR_CODE IN VARCHAR2,
131: p_RATING_CODE IN VARCHAR2,
132: p_LAST_UPDATE_DATE IN DATE ,

Line 129: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

125: PROCEDURE Update_prof_color_code(
126: P_Api_Version_Number IN NUMBER,
127: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
128: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
129: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
130: p_COLOR_CODE IN VARCHAR2,
131: p_RATING_CODE IN VARCHAR2,
132: p_LAST_UPDATE_DATE IN DATE ,
133: p_LAST_UPDATED_BY IN NUMBER,

Line 144: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

140: );
141:
142: PROCEDURE Update_prof_color_code(
143: P_Api_Version_Number IN NUMBER,
144: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
145: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
146: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
147: P_prof_color_rec IN prof_color_Rec_Type,
148: X_Return_Status OUT NOCOPY VARCHAR2,

Line 145: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

141:
142: PROCEDURE Update_prof_color_code(
143: P_Api_Version_Number IN NUMBER,
144: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
145: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
146: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
147: P_prof_color_rec IN prof_color_Rec_Type,
148: X_Return_Status OUT NOCOPY VARCHAR2,
149: X_Msg_Count OUT NOCOPY NUMBER,

Line 146: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

142: PROCEDURE Update_prof_color_code(
143: P_Api_Version_Number IN NUMBER,
144: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
145: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
146: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
147: P_prof_color_rec IN prof_color_Rec_Type,
148: X_Return_Status OUT NOCOPY VARCHAR2,
149: X_Msg_Count OUT NOCOPY NUMBER,
150: X_Msg_Data OUT NOCOPY VARCHAR2

Line 162: -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE

158: -- Pre-Req :
159: -- Parameters:
160: -- IN
161: -- p_api_version_number IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE
163: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
164: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
165: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
166: -- P_prof_color_rec_type_Rec IN prof_color_Rec_Type Required

Line 163: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE

159: -- Parameters:
160: -- IN
161: -- p_api_version_number IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE
163: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
164: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
165: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
166: -- P_prof_color_rec_type_Rec IN prof_color_Rec_Type Required
167: --

Line 164: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL

160: -- IN
161: -- p_api_version_number IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT_G_FALSE
163: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
164: -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
165: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
166: -- P_prof_color_rec_type_Rec IN prof_color_Rec_Type Required
167: --
168: -- OUT:

Line 182: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

178: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
179: -- The Master delete procedure may not be needed depends on different business requirements.
180: PROCEDURE Delete_prof_color_code(
181: P_Api_Version_Number IN NUMBER,
182: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
183: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
184: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
185: P_COLOR_CODE IN VARCHAR2,
186: X_Return_Status OUT NOCOPY VARCHAR2,

Line 183: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

179: -- The Master delete procedure may not be needed depends on different business requirements.
180: PROCEDURE Delete_prof_color_code(
181: P_Api_Version_Number IN NUMBER,
182: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
183: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
184: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
185: P_COLOR_CODE IN VARCHAR2,
186: X_Return_Status OUT NOCOPY VARCHAR2,
187: X_Msg_Count OUT NOCOPY NUMBER,

Line 184: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

180: PROCEDURE Delete_prof_color_code(
181: P_Api_Version_Number IN NUMBER,
182: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
183: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
184: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
185: P_COLOR_CODE IN VARCHAR2,
186: X_Return_Status OUT NOCOPY VARCHAR2,
187: X_Msg_Count OUT NOCOPY NUMBER,
188: X_Msg_Data OUT NOCOPY VARCHAR2

Line 196: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package

192: -- Start of Comments
193: --
194: -- Item level validation procedures
195: --
196: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
197: -- For create: G_CREATE, for update: G_UPDATE
198: -- Note: 1. This is automated generated item level validation procedure.
199: -- The actual validation detail is needed to be added.
200: --

Line 204: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

200: --
201: -- End of Comments
202:
203: PROCEDURE Validate_COLOR_CODE (
204: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
205: P_Validation_mode IN VARCHAR2,
206: P_COLOR_CODE IN VARCHAR2,
207: X_Return_Status OUT NOCOPY VARCHAR2,
208: X_Msg_Count OUT NOCOPY NUMBER,

Line 216: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package

212: -- Start of Comments
213: --
214: -- Item level validation procedures
215: --
216: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
217: -- For create: G_CREATE, for update: G_UPDATE
218: -- Note: 1. This is automated generated item level validation procedure.
219: -- The actual validation detail is needed to be added.
220: --

Line 224: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

220: --
221: -- End of Comments
222:
223: PROCEDURE Validate_RATING_CODE (
224: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
225: P_Validation_mode IN VARCHAR2,
226: P_RATING_CODE IN VARCHAR2,
227: X_Return_Status OUT NOCOPY VARCHAR2,
228: X_Msg_Count OUT NOCOPY NUMBER,

Line 237: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package

233: -- Start of Comments
234: --
235: -- validation procedures
236: --
237: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
238: -- For create: G_CREATE, for update: G_UPDATE
239: -- Note: 1. This is automated generated item level validation procedure.
240: -- The actual validation detail is needed to be added.
241: -- 2. We can also validate table instead of record. There will be an option for user to choose.

Line 245: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

241: -- 2. We can also validate table instead of record. There will be an option for user to choose.
242: -- End of Comments
243:
244: PROCEDURE Validate_prof_color_code(
245: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
246: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
247: P_Validation_mode IN VARCHAR2,
248: P_prof_color_rec_type_Rec IN prof_color_Rec_Type,
249: X_Return_Status OUT NOCOPY VARCHAR2,

Line 246: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

242: -- End of Comments
243:
244: PROCEDURE Validate_prof_color_code(
245: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
246: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
247: P_Validation_mode IN VARCHAR2,
248: P_prof_color_rec_type_Rec IN prof_color_Rec_Type,
249: X_Return_Status OUT NOCOPY VARCHAR2,
250: X_Msg_Count OUT NOCOPY NUMBER,