PACKAGE: APPS.CSC_COLOR_CODES_PKG

Source

1 PACKAGE CSC_COLOR_CODES_PKG AUTHID CURRENT_USER as
2 /* $Header: csctpccs.pls 115.6 2002/12/03 19:30:03 jamose 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
9 -- NOTE             :
10 -- End of Comments
11 
12 PROCEDURE Insert_Row(
13           px_COLOR_CODE   IN OUT NOCOPY VARCHAR2,
14           p_RATING_CODE          VARCHAR2,
15           p_LAST_UPDATE_DATE     DATE,
16           p_LAST_UPDATED_BY      NUMBER,
17           p_CREATION_DATE        DATE,
18           p_CREATED_BY           NUMBER,
19           p_LAST_UPDATE_LOGIN    NUMBER);
20 
21 PROCEDURE Update_Row(
22           p_COLOR_CODE         VARCHAR2,
23           p_RATING_CODE        VARCHAR2,
24           p_LAST_UPDATE_DATE   DATE,
25           p_LAST_UPDATED_BY    NUMBER,
26           p_LAST_UPDATE_LOGIN  NUMBER);
27 
28 PROCEDURE Lock_Row(
29           p_COLOR_CODE         VARCHAR2,
30           p_RATING_CODE        VARCHAR2,
31           p_LAST_UPDATE_DATE   DATE,
32           p_LAST_UPDATED_BY    NUMBER,
33           p_CREATION_DATE      DATE,
34           p_CREATED_BY         NUMBER,
35           p_LAST_UPDATE_LOGIN  NUMBER);
36 
37 PROCEDURE Delete_Row(
38     p_COLOR_CODE  VARCHAR2);
39 
40 PROCEDURE Load_Row(
41           p_COLOR_CODE         VARCHAR2,
42           p_RATING_CODE        VARCHAR2,
43           p_LAST_UPDATE_DATE   DATE,
44           p_LAST_UPDATED_BY    NUMBER,
45           p_LAST_UPDATE_LOGIN  NUMBER,
46 		p_Owner			 VARCHAR2);
47 End CSC_COLOR_CODES_PKG;