DBA Data[Home] [Help]

APPS.PSB_ENTITY_PVT dependencies on FND_API

Line 6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2: /* $Header: PSBVENPS.pls 120.2 2005/07/13 11:24:54 shtripat ship $ */
3:
4: procedure INSERT_ROW (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_return_status OUT NOCOPY VARCHAR2,
10: p_msg_count OUT NOCOPY NUMBER,

Line 7: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3:
4: procedure INSERT_ROW (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_return_status OUT NOCOPY VARCHAR2,
10: p_msg_count OUT NOCOPY NUMBER,
11: p_msg_data OUT NOCOPY VARCHAR2,

Line 8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4: procedure INSERT_ROW (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_return_status OUT NOCOPY VARCHAR2,
10: p_msg_count OUT NOCOPY NUMBER,
11: p_msg_data OUT NOCOPY VARCHAR2,
12: --

Line 21: P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,

17: P_NAME in VARCHAR2,
18: P_DESCRIPTION in VARCHAR2,
19: P_DATA_EXTRACT_ID in NUMBER,
20: P_SET_OF_BOOKS_ID in NUMBER,
21: P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,
22: P_ALLOCATION_TYPE in VARCHAR2,
23: P_BUDGET_YEAR_TYPE_ID in NUMBER,
24: P_BALANCE_TYPE in VARCHAR2,
25: P_PARAMETER_AUTOINC_RULE in VARCHAR2,

Line 45: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,

41: P_ATTRIBUTE8 in VARCHAR2,
42: P_ATTRIBUTE9 in VARCHAR2,
43: P_ATTRIBUTE10 in VARCHAR2,
44: P_CONTEXT in VARCHAR2,
45: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
46: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
47: p_Last_Update_Date DATE,
48: p_Last_Updated_By NUMBER,
49: p_Last_Update_Login NUMBER,

Line 46: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,

42: P_ATTRIBUTE9 in VARCHAR2,
43: P_ATTRIBUTE10 in VARCHAR2,
44: P_CONTEXT in VARCHAR2,
45: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
46: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
47: p_Last_Update_Date DATE,
48: p_Last_Updated_By NUMBER,
49: p_Last_Update_Login NUMBER,
50: p_Created_By NUMBER,

Line 56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

52: );
53:
54: procedure LOCK_ROW (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: p_return_status OUT NOCOPY VARCHAR2,
60: p_msg_count OUT NOCOPY NUMBER,

Line 57: p_commit IN VARCHAR2 := FND_API.G_FALSE,

53:
54: procedure LOCK_ROW (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: p_return_status OUT NOCOPY VARCHAR2,
60: p_msg_count OUT NOCOPY NUMBER,
61: p_msg_data OUT NOCOPY VARCHAR2,

Line 58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

54: procedure LOCK_ROW (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: p_return_status OUT NOCOPY VARCHAR2,
60: p_msg_count OUT NOCOPY NUMBER,
61: p_msg_data OUT NOCOPY VARCHAR2,
62: p_lock_row OUT NOCOPY VARCHAR2,

Line 71: P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,

67: P_NAME in VARCHAR2,
68: P_DESCRIPTION in VARCHAR2,
69: P_DATA_EXTRACT_ID in NUMBER,
70: P_SET_OF_BOOKS_ID in NUMBER,
71: P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,
72: P_ALLOCATION_TYPE in VARCHAR2,
73: P_BUDGET_YEAR_TYPE_ID in NUMBER,
74: P_BALANCE_TYPE in VARCHAR2,
75: P_PARAMETER_AUTOINC_RULE in VARCHAR2,

Line 95: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,

91: P_ATTRIBUTE8 in VARCHAR2,
92: P_ATTRIBUTE9 in VARCHAR2,
93: P_ATTRIBUTE10 in VARCHAR2,
94: P_CONTEXT in VARCHAR2,
95: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
96: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE);
97:
98: procedure UPDATE_ROW (
99: p_api_version IN NUMBER,

Line 96: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE);

92: P_ATTRIBUTE9 in VARCHAR2,
93: P_ATTRIBUTE10 in VARCHAR2,
94: P_CONTEXT in VARCHAR2,
95: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
96: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE);
97:
98: procedure UPDATE_ROW (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

96: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE);
97:
98: procedure UPDATE_ROW (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_return_status OUT NOCOPY VARCHAR2,
104: p_msg_count OUT NOCOPY NUMBER,

Line 101: p_commit IN VARCHAR2 := FND_API.G_FALSE,

97:
98: procedure UPDATE_ROW (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_return_status OUT NOCOPY VARCHAR2,
104: p_msg_count OUT NOCOPY NUMBER,
105: p_msg_data OUT NOCOPY VARCHAR2,

Line 102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

98: procedure UPDATE_ROW (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_return_status OUT NOCOPY VARCHAR2,
104: p_msg_count OUT NOCOPY NUMBER,
105: p_msg_data OUT NOCOPY VARCHAR2,
106: --

Line 114: P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,

110: P_NAME in VARCHAR2,
111: P_DESCRIPTION in VARCHAR2,
112: P_DATA_EXTRACT_ID in NUMBER,
113: P_SET_OF_BOOKS_ID in NUMBER,
114: P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,
115: P_ALLOCATION_TYPE in VARCHAR2,
116: P_BUDGET_YEAR_TYPE_ID in NUMBER,
117: P_BALANCE_TYPE in VARCHAR2,
118: P_PARAMETER_AUTOINC_RULE in VARCHAR2,

Line 138: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,

134: P_ATTRIBUTE8 in VARCHAR2,
135: P_ATTRIBUTE9 in VARCHAR2,
136: P_ATTRIBUTE10 in VARCHAR2,
137: P_CONTEXT in VARCHAR2,
138: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
139: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
140: p_Last_Update_Date DATE,
141: p_Last_Updated_By NUMBER,
142: p_Last_Update_Login NUMBER

Line 139: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,

135: P_ATTRIBUTE9 in VARCHAR2,
136: P_ATTRIBUTE10 in VARCHAR2,
137: P_CONTEXT in VARCHAR2,
138: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
139: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
140: p_Last_Update_Date DATE,
141: p_Last_Updated_By NUMBER,
142: p_Last_Update_Login NUMBER
143: );

Line 148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

144:
145:
146: procedure ADD_ROW(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: p_return_status OUT NOCOPY VARCHAR2,
152: p_msg_count OUT NOCOPY NUMBER,

Line 149: p_commit IN VARCHAR2 := FND_API.G_FALSE,

145:
146: procedure ADD_ROW(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: p_return_status OUT NOCOPY VARCHAR2,
152: p_msg_count OUT NOCOPY NUMBER,
153: p_msg_data OUT NOCOPY VARCHAR2,

Line 150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

146: procedure ADD_ROW(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: p_return_status OUT NOCOPY VARCHAR2,
152: p_msg_count OUT NOCOPY NUMBER,
153: p_msg_data OUT NOCOPY VARCHAR2,
154: --

Line 163: P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,

159: P_NAME in VARCHAR2,
160: P_DESCRIPTION in VARCHAR2,
161: P_DATA_EXTRACT_ID in NUMBER,
162: P_SET_OF_BOOKS_ID in NUMBER,
163: P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,
164: P_ALLOCATION_TYPE in VARCHAR2,
165: P_BUDGET_YEAR_TYPE_ID in NUMBER,
166: P_BALANCE_TYPE in VARCHAR2,
167: P_PARAMETER_AUTOINC_RULE in VARCHAR2,

Line 187: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,

183: P_ATTRIBUTE8 in VARCHAR2,
184: P_ATTRIBUTE9 in VARCHAR2,
185: P_ATTRIBUTE10 in VARCHAR2,
186: P_CONTEXT in VARCHAR2,
187: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
188: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
189: p_Last_Update_Date DATE,
190: p_Last_Updated_By NUMBER,
191: p_Last_Update_Login NUMBER,

Line 188: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,

184: P_ATTRIBUTE9 in VARCHAR2,
185: P_ATTRIBUTE10 in VARCHAR2,
186: P_CONTEXT in VARCHAR2,
187: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
188: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
189: p_Last_Update_Date DATE,
190: p_Last_Updated_By NUMBER,
191: p_Last_Update_Login NUMBER,
192: p_Created_By NUMBER,

Line 199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

195:
196:
197: procedure DELETE_ROW (
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_return_status OUT NOCOPY VARCHAR2,
203: p_msg_count OUT NOCOPY NUMBER,

Line 200: p_commit IN VARCHAR2 := FND_API.G_FALSE,

196:
197: procedure DELETE_ROW (
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_return_status OUT NOCOPY VARCHAR2,
203: p_msg_count OUT NOCOPY NUMBER,
204: p_msg_data OUT NOCOPY VARCHAR2,

Line 201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

197: procedure DELETE_ROW (
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_return_status OUT NOCOPY VARCHAR2,
203: p_msg_count OUT NOCOPY NUMBER,
204: p_msg_data OUT NOCOPY VARCHAR2,
205: --