PACKAGE: APPS.CSC_PROF_CHECK_RATINGS_PKG

Source

1 PACKAGE CSC_PROF_CHECK_RATINGS_PKG AUTHID CURRENT_USER as
2 /* $Header: csctpras.pls 115.12 2002/12/03 18:00:23 jamose ship $ */
3 -- Start of Comments
4 -- Package name     : CSC_PROF_CHECK_RATINGS_PKG
5 -- Purpose          :
6 -- History          :
7 -- 26 Nov 02 jamose made changes for the NOCOPY and FND_API.G_MISS*
8 --	03 Nov 00 axsubram  Added  load_row (# 1487338)
9 -- NOTE             :
10 -- End of Comments
11 
12 PROCEDURE Insert_Row(
13           px_CHECK_RATING_ID   IN OUT NOCOPY NUMBER,
14           p_CHECK_ID             NUMBER,
15           p_CHECK_RATING_GRADE   VARCHAR2,
16           p_RATING_CODE          VARCHAR2,
17           p_COLOR_CODE           VARCHAR2,
18           p_RANGE_LOW_VALUE      VARCHAR2,
19           p_RANGE_HIGH_VALUE     VARCHAR2,
20           p_LAST_UPDATE_DATE     DATE,
21           p_LAST_UPDATED_BY      NUMBER,
22           p_CREATION_DATE        DATE,
23           p_CREATED_BY           NUMBER,
24           p_LAST_UPDATE_LOGIN    NUMBER,
25           p_SEEDED_FLAG          VARCHAR2);
26 
27 PROCEDURE Update_Row(
28           p_CHECK_RATING_ID    NUMBER,
29           p_CHECK_ID           NUMBER,
30           p_CHECK_RATING_GRADE VARCHAR2,
31           p_RATING_CODE        VARCHAR2,
32           p_COLOR_CODE         VARCHAR2,
33           p_RANGE_LOW_VALUE    VARCHAR2,
34           p_RANGE_HIGH_VALUE   VARCHAR2,
35           p_LAST_UPDATE_DATE   DATE,
36           p_LAST_UPDATED_BY    NUMBER,
37           p_LAST_UPDATE_LOGIN  NUMBER,
38           p_SEEDED_FLAG        VARCHAR2);
39 
40 PROCEDURE Lock_Row(
41           p_CHECK_RATING_ID    NUMBER,
42           p_CHECK_ID           NUMBER,
43           p_CHECK_RATING_GRADE VARCHAR2,
44           p_RATING_CODE        VARCHAR2,
45           p_COLOR_CODE         VARCHAR2,
46           p_RANGE_LOW_VALUE    VARCHAR2,
47           p_RANGE_HIGH_VALUE   VARCHAR2,
48           p_LAST_UPDATE_DATE   DATE,
49           p_LAST_UPDATED_BY    NUMBER,
50           p_CREATION_DATE      DATE,
51           p_CREATED_BY         NUMBER,
52           p_LAST_UPDATE_LOGIN  NUMBER,
53           p_SEEDED_FLAG        VARCHAR2);
54 
55 PROCEDURE Delete_Row(
56     p_CHECK_RATING_ID  NUMBER);
57 
58 PROCEDURE Load_Row(
59           p_CHECK_RATING_ID      NUMBER,
60           p_CHECK_ID             NUMBER,
61           p_CHECK_RATING_GRADE   VARCHAR2,
62           p_RATING_CODE          VARCHAR2,
63           p_COLOR_CODE           VARCHAR2,
64           p_RANGE_LOW_VALUE      VARCHAR2,
65           p_RANGE_HIGH_VALUE     VARCHAR2,
66           p_LAST_UPDATE_DATE     DATE,
67           p_LAST_UPDATED_BY      NUMBER,
68           p_LAST_UPDATE_LOGIN    NUMBER,
69           p_SEEDED_FLAG          VARCHAR2,
70 		P_Owner			   VARCHAR2);
71 
72 End CSC_PROF_CHECK_RATINGS_PKG;