1 PACKAGE PSB_BUDGET_REVISION_ACCTS_PVT AS
2 /* $Header: PSBBACCS.pls 120.2 2005/07/13 11:22:19 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_acct_line_id IN OUT NOCOPY NUMBER,
16 p_code_combination_id IN NUMBER,
17 p_budget_group_id IN NUMBER,
18 p_gl_period_name IN VARCHAR2,
19 p_gl_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
20 p_currency_code IN VARCHAR2,
21 p_budget_balance IN NUMBER,
22 p_revision_type IN VARCHAR2,
23 p_revision_value_type IN VARCHAR2,
24 p_revision_amount IN NUMBER,
25 p_funds_status_code IN VARCHAR2,
26 p_funds_result_code IN VARCHAR2,
27 p_funds_control_timestamp IN DATE,
28 p_note_id IN NUMBER,
29 p_freeze_flag IN VARCHAR2,
30 p_view_line_flag IN VARCHAR2
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_acct_line_id IN OUT NOCOPY NUMBER,
46 p_code_combination_id IN NUMBER,
47 p_budget_group_id IN NUMBER,
48 p_gl_period_name IN VARCHAR2,
49 p_gl_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
50 p_currency_code IN VARCHAR2,
51 p_budget_balance IN NUMBER,
52 p_revision_type IN VARCHAR2,
53 p_revision_value_type IN VARCHAR2,
54 p_revision_amount IN NUMBER,
55 p_funds_status_code IN VARCHAR2,
56 p_funds_result_code IN VARCHAR2,
57 p_funds_control_timestamp IN DATE,
58 p_note_id IN NUMBER,
59 p_freeze_flag IN VARCHAR2,
60 p_view_line_flag IN VARCHAR2
61 );
62 END PSB_BUDGET_REVISION_ACCTS_PVT;