1 PACKAGE PSB_Create_BR_Pvt AS
2 /* $Header: PSBVCBRS.pls 120.2 2005/07/13 11:23:38 shtripat ship $ */
3
4 --
5 -- Table type to store Budget_Revision_Id
6 --
7 TYPE Budget_Revision_Tbl_Type IS TABLE OF NUMBER
8 INDEX BY BINARY_INTEGER;
9
10 PROCEDURE Enforce_BR_Concurrency
11 (
12 p_api_version IN NUMBER ,
13 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
14 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
15 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
16 p_return_status OUT NOCOPY VARCHAR2 ,
17 p_msg_count OUT NOCOPY NUMBER ,
18 p_msg_data OUT NOCOPY VARCHAR2 ,
19 --
20 p_budget_revision_id IN NUMBER,
21 p_parent_or_child_mode IN VARCHAR2 ,
22 p_maintenance_mode IN VARCHAR2 := 'MAINTENANCE'
23 );
24
25
26 PROCEDURE Check_BR_Ops_Concurrency
27 (
28 p_api_version IN NUMBER ,
29 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
30 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
31 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
32 p_return_status OUT NOCOPY VARCHAR2 ,
33 p_msg_count OUT NOCOPY NUMBER ,
34 p_msg_data OUT NOCOPY VARCHAR2 ,
35 --
36 p_budget_revision_id IN NUMBER,
37 p_operation_type IN VARCHAR2
38 );
39
40 PROCEDURE Create_Budget_Revision
41 (
42 p_api_version IN NUMBER ,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
44 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
45 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
46 p_return_status OUT NOCOPY VARCHAR2 ,
47 p_msg_count OUT NOCOPY NUMBER ,
48 p_msg_data OUT NOCOPY VARCHAR2 ,
49 --
50 p_budget_revision_id IN NUMBER,
51 p_revision_option_flag IN VARCHAR2,
52 p_budget_group_id IN NUMBER,
53 p_budget_revision_id_out OUT NOCOPY NUMBER
54 );
55
56 PROCEDURE Freeze_Budget_Revision
57 (
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 --
66 p_budget_revision_id IN NUMBER,
67 p_freeze_flag IN VARCHAR2
68 );
69
70 PROCEDURE Find_Parent_Budget_Revision
71 (
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74 p_commit IN VARCHAR2 := FND_API.G_FALSE,
75 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76 p_return_status OUT NOCOPY VARCHAR2,
77 p_msg_count OUT NOCOPY NUMBER,
78 p_msg_data OUT NOCOPY VARCHAR2,
79 --
80 p_budget_revision_id IN NUMBER,
81 p_budget_revision_id_OUT OUT NOCOPY NUMBER
82 );
83
84 PROCEDURE Find_Parent_Budget_Revisions
85 (
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88 p_commit IN VARCHAR2 := FND_API.G_FALSE,
89 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90 p_return_status OUT NOCOPY VARCHAR2,
91 p_msg_count OUT NOCOPY NUMBER,
92 p_msg_data OUT NOCOPY VARCHAR2,
93 --
94 p_budget_revision_id IN NUMBER,
95 p_budget_revision_tbl IN OUT NOCOPY Budget_Revision_Tbl_Type
96 );
97
98
99 PROCEDURE Find_Child_Budget_Revisions
100 (
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103 p_commit IN VARCHAR2 := FND_API.G_FALSE,
104 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105 p_return_status OUT NOCOPY VARCHAR2,
106 p_msg_count OUT NOCOPY NUMBER,
107 p_msg_data OUT NOCOPY VARCHAR2,
108 --
109 p_budget_revision_id IN NUMBER,
110 p_budget_revision_tbl IN OUT NOCOPY Budget_Revision_Tbl_Type
111 );
112
113 PROCEDURE Update_Target_Budget_Revision
114 (
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
117 p_commit IN VARCHAR2 := FND_API.G_FALSE,
118 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
119 p_return_status OUT NOCOPY VARCHAR2,
120 p_msg_count OUT NOCOPY NUMBER,
121 p_msg_data OUT NOCOPY VARCHAR2,
122 --
123 p_source_budget_revision_id IN NUMBER,
124 p_revision_option_flag IN VARCHAR2,
125 p_target_budget_revision_id IN NUMBER
126 );
127
128 END PSB_Create_BR_Pvt ;