PACKAGE: APPS.CSC_PROF_GROUP_CHECKS_PKG

Source

1 PACKAGE CSC_PROF_GROUP_CHECKS_PKG as
2 /* $Header: csctpgcs.pls 120.1 2005/08/03 22:56:44 mmadhavi noship $ */
3 -- Start of Comments
4 -- Package name     : CSC_PROF_GROUP_CHECKS_PKG
5 -- Purpose          :
6 -- History          :
7 -- 27 Nov 02   jamose For Fnd_Api_G_Miss* and NOCOPY changes
8 -- NOTE             :
9 -- End of Comments
10 
11 PROCEDURE Insert_Row(
12           p_GROUP_ID   IN NUMBER,
13           p_CHECK_ID    NUMBER,
14           p_CHECK_SEQUENCE    NUMBER,
15           p_END_DATE_ACTIVE    DATE,
16           p_START_DATE_ACTIVE    DATE,
17           p_CATEGORY_CODE    VARCHAR2,
18           p_CATEGORY_SEQUENCE    NUMBER,
19           p_THRESHOLD_FLAG    VARCHAR2,
20 	  p_CRITICAL_FLAG     VARCHAR2, --mmadhavi added for JIT
21           p_SEEDED_FLAG   VARCHAR2,
22           p_CREATED_BY    NUMBER,
23           p_CREATION_DATE    DATE,
24           p_LAST_UPDATED_BY    NUMBER,
25           p_LAST_UPDATE_DATE    DATE,
26           p_LAST_UPDATE_LOGIN    NUMBER);
27 
28 PROCEDURE Update_Row(
29           p_GROUP_ID    NUMBER,
30           p_CHECK_ID    NUMBER,
31           p_CHECK_SEQUENCE    NUMBER,
32           p_END_DATE_ACTIVE    DATE,
33           p_START_DATE_ACTIVE    DATE,
34           p_CATEGORY_CODE    VARCHAR2,
35           p_CATEGORY_SEQUENCE    NUMBER,
36           p_THRESHOLD_FLAG    VARCHAR2,
37 	  p_CRITICAL_FLAG     VARCHAR2, --mmadhavi added for JIT
38           p_SEEDED_FLAG       VARCHAR2,
39           p_LAST_UPDATED_BY    NUMBER,
40           p_LAST_UPDATE_DATE    DATE,
41           p_LAST_UPDATE_LOGIN    NUMBER);
42 
43 PROCEDURE Lock_Row(
44           p_GROUP_ID    NUMBER,
45           p_CHECK_ID    NUMBER,
46           p_CHECK_SEQUENCE    NUMBER,
47           p_END_DATE_ACTIVE    DATE,
48           p_START_DATE_ACTIVE    DATE,
49           p_CATEGORY_CODE    VARCHAR2,
50           p_CATEGORY_SEQUENCE    NUMBER,
51           p_THRESHOLD_FLAG    VARCHAR2,
52 	  p_CRITICAL_FLAG    VARCHAR2,
53           p_SEEDED_FLAG       VARCHAR2,
54           p_CREATED_BY    NUMBER,
55           p_CREATION_DATE    DATE,
56           p_LAST_UPDATED_BY    NUMBER,
57           p_LAST_UPDATE_DATE    DATE,
58           p_LAST_UPDATE_LOGIN    NUMBER);
59 
60 PROCEDURE Delete_Row(
61     p_GROUP_ID  NUMBER,
62     p_CHECK_ID  NUMBER,
63     p_CHECK_SEQUENCE  NUMBER);
64 
65 End CSC_PROF_GROUP_CHECKS_PKG;