PACKAGE: APPS.CSC_PROF_BLOCKS_PKG

Source

1 PACKAGE CSC_PROF_BLOCKS_PKG AUTHID CURRENT_USER as
2 /* $Header: csctpvas.pls 120.1 2005/08/26 02:48:07 adhanara noship $ */
3 -- Start of Comments
4 -- Package name     : CSC_PROF_BLOCKS_PKG
5 -- Purpose          :
6 -- History          :
7 --	03 Nov 00	axsubram	Added Load_row and Translate_row for NLS (#1487860)
8 -- 15 Nov 02   jamose made changes for the NOCOPY and FND_API.G_MISS*
9 -- NOTE             :
10 -- End of Comments
11 
12 PROCEDURE Insert_Row(
13           px_BLOCK_ID   IN OUT NOCOPY NUMBER,
14           p_CREATED_BY    	 NUMBER,
15           p_CREATION_DATE    	 DATE,
16           p_LAST_UPDATED_BY    NUMBER,
17           p_LAST_UPDATE_DATE   DATE,
18           p_LAST_UPDATE_LOGIN  NUMBER,
19           p_BLOCK_NAME         VARCHAR2,
20           p_DESCRIPTION        VARCHAR2,
21           p_START_DATE_ACTIVE  DATE,
22           p_END_DATE_ACTIVE    DATE,
23           p_SEEDED_FLAG        VARCHAR2,
24           p_BLOCK_NAME_CODE    VARCHAR2,
25           p_OBJECT_CODE 	      VARCHAR2,
26           p_SQL_STMNT_FOR_DRILLDOWN    VARCHAR2,
27           p_SQL_STMNT          VARCHAR2,
28 	  p_BATCH_SQL_STMNT    VARCHAR2,
29           p_SELECT_CLAUSE      VARCHAR2,
30           p_CURRENCY_CODE      VARCHAR2,
31           p_FROM_CLAUSE        VARCHAR2,
32           p_WHERE_CLAUSE       VARCHAR2,
33           p_OTHER_CLAUSE       VARCHAR2,
34           p_BLOCK_LEVEL        VARCHAR2,
35           x_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
36           p_APPLICATION_ID NUMBER);
37 
38 PROCEDURE Update_Row(
39           p_BLOCK_ID           NUMBER,
40           p_LAST_UPDATED_BY    NUMBER,
41           p_LAST_UPDATE_DATE   DATE,
42           p_LAST_UPDATE_LOGIN  NUMBER,
43           p_BLOCK_NAME         VARCHAR2,
44           p_DESCRIPTION        VARCHAR2,
45           p_START_DATE_ACTIVE  DATE,
46           p_END_DATE_ACTIVE    DATE,
47           p_SEEDED_FLAG        VARCHAR2,
48           p_BLOCK_NAME_CODE    VARCHAR2,
49           p_OBJECT_CODE        VARCHAR2,
50           p_SQL_STMNT_FOR_DRILLDOWN    VARCHAR2,
51           p_SQL_STMNT          VARCHAR2,
52 	  p_BATCH_SQL_STMNT    VARCHAR2,
53           p_SELECT_CLAUSE      VARCHAR2,
54           p_CURRENCY_CODE      VARCHAR2,
55           p_FROM_CLAUSE        VARCHAR2,
56           p_WHERE_CLAUSE       VARCHAR2,
57           p_OTHER_CLAUSE       VARCHAR2,
58           p_BLOCK_LEVEL        VARCHAR2,
59           px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
60           p_APPLICATION_ID NUMBER);
61 
62 PROCEDURE Lock_Row(
63           p_BLOCK_ID                 NUMBER,
64           p_OBJECT_VERSION_NUMBER    NUMBER);
65 
66 PROCEDURE Delete_Row(
67     p_BLOCK_ID              NUMBER,
68     p_OBJECT_VERSION_NUMBER NUMBER);
69 
70 PROCEDURE Add_Language;
71 
72 PROCEDURE	 Translate_Row(
73 		p_block_id	NUMBER,
74 		p_block_name	VARCHAR2,
75 		p_description	VARCHAR2,
76 		p_owner		VARCHAR2);
77 
78 PROCEDURE Load_Row(
79           p_BLOCK_ID           NUMBER,
80           p_LAST_UPDATED_BY    NUMBER,
81           p_LAST_UPDATE_DATE   DATE,
82           p_LAST_UPDATE_LOGIN  NUMBER,
83           p_BLOCK_NAME         VARCHAR2,
84           p_DESCRIPTION        VARCHAR2,
85           p_START_DATE_ACTIVE  DATE,
86           p_END_DATE_ACTIVE    DATE,
87           p_SEEDED_FLAG        VARCHAR2,
88           p_BLOCK_NAME_CODE    VARCHAR2,
89           p_OBJECT_CODE        VARCHAR2,
90           p_SQL_STMNT_FOR_DRILLDOWN    VARCHAR2,
91           p_SQL_STMNT          VARCHAR2,
92           p_BATCH_SQL_STMNT    VARCHAR2,
93           p_SELECT_CLAUSE      VARCHAR2,
94           p_CURRENCY_CODE      VARCHAR2,
95           p_FROM_CLAUSE        VARCHAR2,
96           p_WHERE_CLAUSE       VARCHAR2,
97           p_OTHER_CLAUSE       VARCHAR2,
98           p_BLOCK_LEVEL        VARCHAR2,
99           px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
100           p_APPLICATION_ID NUMBER,
101 		p_owner		      VARCHAR2);
102 
103 End CSC_PROF_BLOCKS_PKG;