1 PACKAGE PSB_GL_Budget_Pvt AS
2 /* $Header: PSBVGBDS.pls 120.2 2005/07/13 11:26:34 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_row_id IN OUT NOCOPY VARCHAR2,
15 p_gl_budget_id IN OUT NOCOPY NUMBER,
16 p_gl_budget_set_id IN NUMBER,
17 p_gl_budget_version_id IN NUMBER,
18 p_start_period IN VARCHAR2,
19 p_end_period IN VARCHAR2,
20 p_start_date IN DATE,
21 p_end_date IN DATE,
22 p_dual_posting_type IN VARCHAR2,
23 p_last_update_date IN DATE,
24 p_last_updated_by IN NUMBER,
25 p_last_update_login IN NUMBER,
26 p_created_by IN NUMBER,
27 p_creation_date IN DATE
28 );
29
30
31 PROCEDURE Lock_Row
32 (
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 --
41 p_row_id IN VARCHAR2,
42 p_gl_budget_id IN NUMBER,
43 p_gl_budget_set_id IN NUMBER,
44 p_gl_budget_version_id IN NUMBER,
45 p_start_period IN VARCHAR2,
46 p_end_period IN VARCHAR2,
47 p_start_date IN DATE,
48 p_end_date IN DATE,
49 p_dual_posting_type IN VARCHAR2,
50 --
51 p_row_locked OUT NOCOPY VARCHAR2
52 );
53
54
55 PROCEDURE Update_Row
56 (
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59 p_commit IN VARCHAR2 := FND_API.G_FALSE,
60 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61 p_return_status OUT NOCOPY VARCHAR2,
62 p_msg_count OUT NOCOPY NUMBER,
63 p_msg_data OUT NOCOPY VARCHAR2,
64 --
65 p_row_id IN VARCHAR2,
66 p_gl_budget_set_id IN NUMBER,
67 p_gl_budget_version_id IN NUMBER,
68 p_start_period IN VARCHAR2,
69 p_end_period IN VARCHAR2,
70 p_start_date IN DATE,
71 p_end_date IN DATE,
72 p_dual_posting_type IN VARCHAR2,
73 p_last_update_date IN DATE,
74 p_last_updated_by IN NUMBER,
75 p_last_update_login IN NUMBER
76 );
77
78
79 PROCEDURE Delete_Row
80 (
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83 p_commit IN VARCHAR2 := FND_API.G_FALSE,
84 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85 p_return_status OUT NOCOPY VARCHAR2,
86 p_msg_count OUT NOCOPY NUMBER,
87 p_msg_data OUT NOCOPY VARCHAR2,
88 --
89 p_row_id IN VARCHAR2
90 );
91
92
93 PROCEDURE Find_GL_Budget
94 (
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97 p_commit IN VARCHAR2 := FND_API.G_FALSE,
98 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99 p_return_status OUT NOCOPY VARCHAR2,
100 p_msg_count OUT NOCOPY NUMBER,
101 p_msg_data OUT NOCOPY VARCHAR2,
102 --
103 p_gl_budget_set_id IN NUMBER,
104 p_code_combination_id IN NUMBER,
105 p_start_date IN DATE,
106 p_dual_posting_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
107 --
108 p_gl_budget_version_id OUT NOCOPY NUMBER
109 );
110
111 END PSB_GL_Budget_Pvt ;