1 PACKAGE PSB_BUDGET_REVISION_POS_PVT AS
2 /* $Header: PSBBPOSS.pls 120.2 2005/07/13 11:22:30 shtripat ship $ */
3
4 PROCEDURE Insert_Row
5 (
6 p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8 p_commit IN VARCHAR2 := FND_API.G_FALSE,
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 p_return_status OUT NOCOPY VARCHAR2,
11 p_msg_count OUT NOCOPY NUMBER,
12 p_msg_data OUT NOCOPY VARCHAR2,
13 --
14 p_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
15 p_budget_revision_pos_line_id IN OUT NOCOPY NUMBER,
16 p_position_id IN NUMBER,
17 p_budget_group_id IN NUMBER,
18 p_effective_start_date IN DATE,
19 p_effective_end_date IN DATE,
20 p_revision_type IN VARCHAR2,
21 p_revision_value_type IN VARCHAR2,
22 p_revision_value IN NUMBER,
23 p_note_id IN NUMBER,
24 p_freeze_flag IN VARCHAR2,
25 p_view_line_flag IN VARCHAR2,
26 p_last_update_date IN DATE,
27 p_last_updated_by IN NUMBER,
28 p_last_update_login IN NUMBER,
29 p_created_by IN NUMBER,
30 p_creation_date IN DATE
31 );
32
33
34 PROCEDURE Update_Row
35 (
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
38 p_commit IN VARCHAR2 := FND_API.G_FALSE,
39 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40 p_return_status OUT NOCOPY VARCHAR2,
41 p_msg_count OUT NOCOPY NUMBER,
42 p_msg_data OUT NOCOPY VARCHAR2,
43 --
44 p_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
45 p_budget_revision_pos_line_id IN OUT NOCOPY NUMBER,
46 p_position_id IN NUMBER,
47 p_budget_group_id IN NUMBER,
48 p_effective_start_date IN DATE,
49 p_effective_end_date IN DATE,
50 p_revision_type IN VARCHAR2,
51 p_revision_value_type IN VARCHAR2,
52 p_revision_value IN NUMBER,
53 p_note_id IN NUMBER,
54 p_freeze_flag IN VARCHAR2,
55 p_view_line_flag IN VARCHAR2,
56 p_last_update_date IN DATE,
57 p_last_updated_by IN NUMBER,
58 p_last_update_login IN NUMBER,
59 p_created_by IN NUMBER,
60 p_creation_date IN DATE
61 );
62
63 END PSB_BUDGET_REVISION_POS_PVT;