1 PACKAGE PSB_Set_Relation_PVT AS
2 /* $Header: PSBVSTRS.pls 120.2 2005/07/13 11:30:07 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_set_relation_id IN OUT NOCOPY NUMBER,
16 p_account_Position_set_id IN NUMBER,
17 p_allocation_Rule_id IN NUMBER,
18 p_budget_group_id IN NUMBER,
19 p_budget_workflow_rule_id IN NUMBER,
20 p_constraint_id IN NUMBER,
21 p_default_Rule_id IN NUMBER,
22 p_parameter_id IN NUMBER,
23 p_position_set_group_id IN NUMBER,
24 p_gl_budget_id IN NUMBER := FND_API.G_MISS_NUM,
25 /* Budget Revision Rules Enhancement Start */
26 p_rule_id IN VARCHAR2,
27 p_apply_balance_flag IN VARCHAR2,
28 /* Budget Revision Rules Enhancement End */
29 p_effective_start_date IN DATE,
30 p_effective_end_date IN DATE,
31 p_last_update_date IN DATE,
32 p_last_updated_By IN NUMBER,
33 p_last_update_login IN NUMBER,
34 p_created_by IN NUMBER,
35 p_creation_date IN DATE
36 );
37
38
39
40 PROCEDURE Lock_Row
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_row_id IN VARCHAR2,
51 p_set_Relation_id IN NUMBER,
52 p_account_Position_set_id IN NUMBER,
53 p_allocation_Rule_id IN NUMBER,
54 p_budget_group_id IN NUMBER,
55 p_budget_workflow_rule_id IN NUMBER,
56 p_Constraint_id IN NUMBER,
57 p_default_Rule_id IN NUMBER,
58 p_parameter_id IN NUMBER,
59 p_position_set_group_id IN NUMBER,
60 p_gl_budget_id IN NUMBER := FND_API.G_MISS_NUM,
61 /* Budget Revision Rules Enhancement Start */
62 p_rule_id IN VARCHAR2,
63 p_apply_balance_flag IN VARCHAR2,
64 /* Budget Revision Rules Enhancement End */
65 p_effective_start_date IN DATE,
66 p_effective_end_date IN DATE,
67 --
68 p_row_locked OUT NOCOPY VARCHAR2
69 );
70
71
72
73 PROCEDURE Update_Row
74 (
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77 p_commit IN VARCHAR2 := FND_API.G_FALSE,
78 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79 p_return_status OUT NOCOPY VARCHAR2,
80 p_msg_count OUT NOCOPY NUMBER,
81 p_msg_data OUT NOCOPY VARCHAR2,
82 --
83 p_row_id IN VARCHAR2,
84 p_set_Relation_id IN NUMBER,
85 p_account_Position_set_id IN NUMBER,
86 p_allocation_Rule_id IN NUMBER,
87 p_budget_group_id IN NUMBER,
88 p_budget_workflow_rule_id IN NUMBER,
89 p_Constraint_id IN NUMBER,
90 p_default_Rule_id IN NUMBER,
91 p_parameter_id IN NUMBER,
92 p_position_set_group_id IN NUMBER,
93 p_gl_budget_id IN NUMBER := FND_API.G_MISS_NUM,
94 /* Budget Revision Rules Enhancement Start */
95 p_rule_id IN VARCHAR2,
96 p_apply_balance_flag IN VARCHAR2,
97 /* Budget Revision Rules Enhancement End */
98 p_effective_start_date IN DATE,
99 p_effective_end_date IN DATE,
100 p_last_update_date IN DATE,
101 p_last_updated_By IN NUMBER,
102 p_last_update_login IN NUMBER
103 );
104
105
106
107 PROCEDURE Delete_Row
108 ( p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110 p_commit IN VARCHAR2 := FND_API.G_FALSE,
111 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112 p_return_status OUT NOCOPY VARCHAR2,
113 p_msg_count OUT NOCOPY NUMBER,
114 p_msg_data OUT NOCOPY VARCHAR2,
115 --
116 p_row_id IN VARCHAR2
117 );
118
119
120 PROCEDURE Delete_Entity_Relation
121 (
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
124 p_commit IN VARCHAR2 := FND_API.G_FALSE,
125 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
126 p_return_status OUT NOCOPY VARCHAR2,
127 p_msg_count OUT NOCOPY NUMBER,
128 p_msg_data OUT NOCOPY VARCHAR2,
129 --
130 p_entity_type IN VARCHAR2,
131 p_entity_id IN NUMBER
132 );
133
134
135 PROCEDURE Check_Unique
136 (
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139 p_commit IN VARCHAR2 := FND_API.G_FALSE,
140 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141 p_return_status OUT NOCOPY VARCHAR2,
142 p_msg_count OUT NOCOPY NUMBER,
143 p_msg_data OUT NOCOPY VARCHAR2,
144 --
145 p_row_id IN VARCHAR2,
146 p_account_position_set_id IN NUMBER,
147 p_account_or_position_type IN VARCHAR2,
148 p_entity_type IN VARCHAR2,
149 p_entity_id IN NUMBER,
150 /* Bug No 2131841 Start */
151 p_apply_balance_flag IN VARCHAR2,
152 /* Bug No 2131841 End */
153 p_return_value IN OUT NOCOPY VARCHAR2
154 );
155
156
157 END PSB_Set_Relation_PVT;