DBA Data[Home] [Help]

APPS.CSC_COLOR_CODES_PKG dependencies on CSC_COLOR_CODES_PKG

Line 1: PACKAGE BODY CSC_COLOR_CODES_PKG as

1: PACKAGE BODY CSC_COLOR_CODES_PKG as
2: /* $Header: csctpccb.pls 120.2 2005/08/24 04:07:05 vshastry ship $ */
3: -- Start of Comments
4: -- Package name : CSC_COLOR_CODES_PKG
5: -- Purpose :

Line 4: -- Package name : CSC_COLOR_CODES_PKG

1: PACKAGE BODY CSC_COLOR_CODES_PKG as
2: /* $Header: csctpccb.pls 120.2 2005/08/24 04:07:05 vshastry ship $ */
3: -- Start of Comments
4: -- Package name : CSC_COLOR_CODES_PKG
5: -- Purpose :
6: -- History :
7: -- 03 Nov 00 axsubram Added Load_row for NLS (#1487340)
8: -- 27 Nov 02 jamose For Fnd_Api_G_Miss* and NOCOPY changes

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_COLOR_CODES_PKG';

13: -- NOTE :
14: -- End of Comments
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_COLOR_CODES_PKG';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csctpccb.pls';
19:
20: PROCEDURE Insert_Row(
21: px_COLOR_CODE IN OUT NOCOPY VARCHAR2,

Line 149: Csc_Color_Codes_Pkg.Update_Row(

145: Begin
146:
147: l_color_code := p_color_code ;
148:
149: Csc_Color_Codes_Pkg.Update_Row(
150: p_COLOR_CODE => p_color_code,
151: p_RATING_CODE => p_rating_code,
152: p_LAST_UPDATE_DATE => p_last_update_date,
153: p_LAST_UPDATED_BY => p_last_updated_by,

Line 159: Csc_Color_Codes_Pkg.Insert_Row(

155:
156: EXCEPTION
157: WHEN NO_DATA_FOUND THEN
158:
159: Csc_Color_Codes_Pkg.Insert_Row(
160: px_COLOR_CODE => l_color_code,
161: p_RATING_CODE => p_rating_code,
162: p_LAST_UPDATE_DATE => p_last_update_date,
163: p_LAST_UPDATED_BY => p_last_updated_by,

Line 171: End CSC_COLOR_CODES_PKG;

167:
168:
169: End Load_Row;
170:
171: End CSC_COLOR_CODES_PKG;