[Home] [Help]
PACKAGE: APPS.PSB_YEAR_TYPE_PVT
Source
1 PACKAGE PSB_Year_Type_PVT AS
2 /* $Header: PSBVYTPS.pls 120.2 2005/07/13 11:31:56 shtripat ship $ */
3
4
5
6 PROCEDURE Check_Unique_Sequence
7 ( p_api_version IN NUMBER,
8 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9 p_commit IN VARCHAR2 := FND_API.G_FALSE,
10 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11 p_return_status OUT NOCOPY VARCHAR2,
12 p_msg_count OUT NOCOPY NUMBER,
13 p_msg_data OUT NOCOPY VARCHAR2,
14 p_year_type_id IN NUMBER,
15 p_year_type_seq IN NUMBER
16 ) ;
17 --
18 --
19 PROCEDURE Check_Unique_Name
20 ( p_api_version IN NUMBER,
21 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
22 p_commit IN VARCHAR2 := FND_API.G_FALSE,
23 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24 p_return_status OUT NOCOPY VARCHAR2,
25 p_msg_count OUT NOCOPY NUMBER,
26 p_msg_data OUT NOCOPY VARCHAR2,
27 p_year_type_id IN NUMBER,
28 p_name IN VARCHAR2
29 ) ;
30 --
31 --
32 PROCEDURE Check_Sequence
33 ( p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35 p_commit IN VARCHAR2 := FND_API.G_FALSE,
36 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37 p_return_status OUT NOCOPY VARCHAR2,
38 p_msg_count OUT NOCOPY NUMBER,
39 p_msg_data OUT NOCOPY VARCHAR2,
40 p_year_type IN VARCHAR2,
41 p_year_type_seq IN NUMBER
42 );
43 --
44 --
45 PROCEDURE Check_CY_Count
46 ( p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48 p_commit IN VARCHAR2 := FND_API.G_FALSE,
49 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50 p_return_status OUT NOCOPY VARCHAR2,
51 p_msg_count OUT NOCOPY NUMBER,
52 p_msg_data OUT NOCOPY VARCHAR2,
53 p_year_type_id IN NUMBER
54 );
55 --
56 --
57 PROCEDURE Check_Reference
58 ( p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60 p_commit IN VARCHAR2 := FND_API.G_FALSE,
61 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62 p_return_status OUT NOCOPY VARCHAR2,
63 p_msg_count OUT NOCOPY NUMBER,
64 p_msg_data OUT NOCOPY VARCHAR2,
65 p_year_type_id IN NUMBER
66 );
67 --
68 --
69 FUNCTION get_debug RETURN VARCHAR2;
70 --
71 --
72 procedure INSERT_ROW
73 ( p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75 p_commit IN VARCHAR2 := FND_API.G_FALSE,
76 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77 p_return_status OUT NOCOPY VARCHAR2,
78 p_msg_count OUT NOCOPY NUMBER,
79 p_msg_data OUT NOCOPY VARCHAR2,
80 p_ROWID in OUT NOCOPY VARCHAR2,
81 p_BUDGET_YEAR_TYPE_ID in NUMBER,
82 p_YEAR_CATEGORY_TYPE in VARCHAR2,
83 p_SEQUENCE_NUMBER in NUMBER,
84 p_NAME in VARCHAR2,
85 p_DESCRIPTION in VARCHAR2,
86 p_CREATION_DATE in DATE,
87 p_CREATED_BY in NUMBER,
88 p_LAST_UPDATE_DATE in DATE,
89 p_LAST_UPDATED_BY in NUMBER,
90 p_LAST_UPDATE_LOGIN in NUMBER);
91
92
93 procedure LOCK_ROW
94 ( p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96 p_commit IN VARCHAR2 := FND_API.G_FALSE,
97 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98 p_return_status OUT NOCOPY VARCHAR2,
99 p_msg_count OUT NOCOPY NUMBER,
100 p_msg_data OUT NOCOPY VARCHAR2,
101 p_BUDGET_YEAR_TYPE_ID in NUMBER,
102 p_YEAR_CATEGORY_TYPE in VARCHAR2,
103 p_SEQUENCE_NUMBER in NUMBER,
104 p_NAME in VARCHAR2,
105 p_DESCRIPTION in VARCHAR2
106 );
107
108
109 procedure UPDATE_ROW
110 ( p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112 p_commit IN VARCHAR2 := FND_API.G_FALSE,
113 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114 p_return_status OUT NOCOPY VARCHAR2,
115 p_msg_count OUT NOCOPY NUMBER,
116 p_msg_data OUT NOCOPY VARCHAR2,
117 p_BUDGET_YEAR_TYPE_ID in NUMBER,
118 p_YEAR_CATEGORY_TYPE in VARCHAR2,
119 p_SEQUENCE_NUMBER in NUMBER,
120 p_NAME in VARCHAR2,
121 p_DESCRIPTION in VARCHAR2,
122 p_LAST_UPDATE_DATE in DATE,
123 p_LAST_UPDATED_BY in NUMBER,
124 p_LAST_UPDATE_LOGIN in NUMBER
125 );
126
127 procedure DELETE_ROW
128 ( p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130 p_commit IN VARCHAR2 := FND_API.G_FALSE,
131 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132 p_return_status OUT NOCOPY VARCHAR2,
133 p_msg_count OUT NOCOPY NUMBER,
134 p_msg_data OUT NOCOPY VARCHAR2,
135 p_BUDGET_YEAR_TYPE_ID in NUMBER
136 );
137
138 procedure ADD_LANGUAGE;
139 --
140 --
141 END PSB_Year_Type_PVT ;