PACKAGE: APPS.CSC_PROF_CHECKS_PKG

Source

1 PACKAGE CSC_PROF_CHECKS_PKG AUTHID CURRENT_USER as
2 /* $Header: csctpcks.pls 115.13 2002/12/03 17:51:15 jamose ship $ */
3 -- Start of Comments
4 -- Package name     : CSC_PROF_CHECKS_PKG
5 -- Purpose          :
6 -- History          :
7 --	03 Nov 00	axsubram	Added Load_row and Translate_row for NLS (#1487864)
8 -- NOTE             :
9 -- End of Comments
10 
11 PROCEDURE Insert_Row(
12           px_CHECK_ID   IN OUT NOCOPY NUMBER,
13           p_CHECK_NAME         VARCHAR2,
14           p_CHECK_NAME_CODE    VARCHAR2,
15           p_DESCRIPTION        VARCHAR2,
16           p_START_DATE_ACTIVE  DATE,
17           p_END_DATE_ACTIVE    DATE,
18           p_SEEDED_FLAG        VARCHAR2,
19           p_SELECT_TYPE        VARCHAR2,
20           p_SELECT_BLOCK_ID    NUMBER,
21           p_DATA_TYPE          VARCHAR2,
22           p_FORMAT_MASK        VARCHAR2,
23           p_THRESHOLD_GRADE    VARCHAR2,
24           p_THRESHOLD_RATING_CODE     VARCHAR2,
25           p_CHECK_UPPER_LOWER_FLAG    VARCHAR2,
26           p_THRESHOLD_COLOR_CODE      VARCHAR2,
27           p_CHECK_LEVEL               VARCHAR2,
28           p_CREATED_BY         NUMBER,
29           p_CREATION_DATE      DATE,
30           p_LAST_UPDATED_BY    NUMBER,
31           p_LAST_UPDATE_DATE   DATE,
32           p_LAST_UPDATE_LOGIN  NUMBER,
33 	  x_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
34           p_APPLICATION_ID     NUMBER );
35 
36 PROCEDURE Update_Row(
37           p_CHECK_ID           NUMBER,
38           p_CHECK_NAME         VARCHAR2,
39           p_CHECK_NAME_CODE    VARCHAR2,
40           p_DESCRIPTION        VARCHAR2,
41           p_START_DATE_ACTIVE  DATE,
42           p_END_DATE_ACTIVE    DATE,
43           p_SEEDED_FLAG        VARCHAR2,
44           p_SELECT_TYPE        VARCHAR2,
45           p_SELECT_BLOCK_ID    NUMBER,
46           p_DATA_TYPE          VARCHAR2,
47           p_FORMAT_MASK        VARCHAR2,
48           p_THRESHOLD_GRADE    VARCHAR2,
49           p_THRESHOLD_RATING_CODE     VARCHAR2,
50           p_CHECK_UPPER_LOWER_FLAG    VARCHAR2,
51           p_THRESHOLD_COLOR_CODE      VARCHAR2,
52           p_CHECK_LEVEL               VARCHAR2,
53           p_LAST_UPDATED_BY    NUMBER,
54           p_LAST_UPDATE_DATE   DATE,
55           p_LAST_UPDATE_LOGIN  NUMBER,
56 	  px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
57           p_APPLICATION_ID     NUMBER );
58 
59 procedure LOCK_ROW (
60   P_CHECK_ID              NUMBER,
61   P_OBJECT_VERSION_NUMBER NUMBER);
62 
63 PROCEDURE Delete_Row(
64     p_CHECK_ID              NUMBER,
65     p_OBJECT_VERSION_NUMBER NUMBER);
66 
67 PROCEDURE Add_Language;
68 
69 procedure TRANSLATE_ROW (
70   P_CHECK_ID        NUMBER,
71   p_CHECK_NAME      VARCHAR2,
72   p_DESCRIPTION    	VARCHAR2,
73   P_OWNER 		VARCHAR2);
74 
75 PROCEDURE Load_Row(
76           p_CHECK_ID    		NUMBER,
77           p_CHECK_NAME    	VARCHAR2,
78           p_CHECK_NAME_CODE   VARCHAR2,
79           p_DESCRIPTION    	VARCHAR2,
80           p_START_DATE_ACTIVE DATE,
81           p_END_DATE_ACTIVE   DATE,
82           p_SEEDED_FLAG    	VARCHAR2,
83           p_SELECT_TYPE    	VARCHAR2,
84           p_SELECT_BLOCK_ID   NUMBER,
85           p_DATA_TYPE    	VARCHAR2,
86           p_FORMAT_MASK    	VARCHAR2,
87           p_THRESHOLD_GRADE   VARCHAR2,
88           p_THRESHOLD_RATING_CODE    VARCHAR2,
89           p_CHECK_UPPER_LOWER_FLAG   VARCHAR2,
90           p_THRESHOLD_COLOR_CODE     VARCHAR2,
91           p_CHECK_LEVEL              VARCHAR2,
92           p_LAST_UPDATED_BY     NUMBER,
93           p_LAST_UPDATE_DATE    DATE,
94           p_LAST_UPDATE_LOGIN   NUMBER,
95 	  px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER ,
96           p_APPLICATION_ID     NUMBER,
97        	  P_OWNER			   VARCHAR2);
98 
99 
100 
101 End CSC_PROF_CHECKS_PKG;
102