[Home] [Help]
4: /* ----------------------------------------------------------------------- */
5:
6: -- API name : Create_WS_Line_Items
7: -- Type : Private
8: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
9: -- Parameters :
10: -- IN : p_api_version IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
8: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
9: -- Parameters :
10: -- IN : p_api_version IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level IN NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_NONE
10: -- IN : p_api_version IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level IN NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_NONE
17: -- p_worksheet_id IN NUMBER Required
18: -- .
12: -- Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level IN NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_NONE
17: -- p_worksheet_id IN NUMBER Required
18: -- .
19: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
20: -- p_msg_count OUT NOCOPY NUMBER
28: --
29:
30: PROCEDURE Create_WS_Line_Items
31: ( p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
35: p_return_status OUT NOCOPY VARCHAR2,
36: p_msg_count OUT NOCOPY NUMBER,
29:
30: PROCEDURE Create_WS_Line_Items
31: ( p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
35: p_return_status OUT NOCOPY VARCHAR2,
36: p_msg_count OUT NOCOPY NUMBER,
37: p_msg_data OUT NOCOPY VARCHAR2,
30: PROCEDURE Create_WS_Line_Items
31: ( p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
35: p_return_status OUT NOCOPY VARCHAR2,
36: p_msg_count OUT NOCOPY NUMBER,
37: p_msg_data OUT NOCOPY VARCHAR2,
38: p_worksheet_id IN NUMBER
41: /* ----------------------------------------------------------------------- */
42:
43: -- API name : Delete_WS_Line_Items
44: -- Type : Private
45: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
46: -- Parameters :
47: -- IN : p_api_version IN NUMBER Required
48: -- p_init_msg_list IN VARCHAR2 Optional
49: -- Default = FND_API.G_FALSE
45: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
46: -- Parameters :
47: -- IN : p_api_version IN NUMBER Required
48: -- p_init_msg_list IN VARCHAR2 Optional
49: -- Default = FND_API.G_FALSE
50: -- p_commit IN VARCHAR2 Optional
51: -- Default = FND_API.G_FALSE
52: -- p_validation_level IN NUMBER Optional
53: -- Default = FND_API.G_VALID_LEVEL_NONE
47: -- IN : p_api_version IN NUMBER Required
48: -- p_init_msg_list IN VARCHAR2 Optional
49: -- Default = FND_API.G_FALSE
50: -- p_commit IN VARCHAR2 Optional
51: -- Default = FND_API.G_FALSE
52: -- p_validation_level IN NUMBER Optional
53: -- Default = FND_API.G_VALID_LEVEL_NONE
54: -- p_worksheet_id IN NUMBER Required
55: -- p_global_worksheet IN VARCHAR2 Optional
49: -- Default = FND_API.G_FALSE
50: -- p_commit IN VARCHAR2 Optional
51: -- Default = FND_API.G_FALSE
52: -- p_validation_level IN NUMBER Optional
53: -- Default = FND_API.G_VALID_LEVEL_NONE
54: -- p_worksheet_id IN NUMBER Required
55: -- p_global_worksheet IN VARCHAR2 Optional
56: -- Default = FND_API.G_TRUE
57: -- .
52: -- p_validation_level IN NUMBER Optional
53: -- Default = FND_API.G_VALID_LEVEL_NONE
54: -- p_worksheet_id IN NUMBER Required
55: -- p_global_worksheet IN VARCHAR2 Optional
56: -- Default = FND_API.G_TRUE
57: -- .
58: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
59: -- p_msg_count OUT NOCOPY NUMBER
60: -- p_msg_data OUT NOCOPY VARCHAR2(2000)
67: --
68:
69: PROCEDURE Delete_WS_Line_Items
70: ( p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
74: p_return_status OUT NOCOPY VARCHAR2,
75: p_msg_count OUT NOCOPY NUMBER,
68:
69: PROCEDURE Delete_WS_Line_Items
70: ( p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
74: p_return_status OUT NOCOPY VARCHAR2,
75: p_msg_count OUT NOCOPY NUMBER,
76: p_msg_data OUT NOCOPY VARCHAR2,
69: PROCEDURE Delete_WS_Line_Items
70: ( p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
74: p_return_status OUT NOCOPY VARCHAR2,
75: p_msg_count OUT NOCOPY NUMBER,
76: p_msg_data OUT NOCOPY VARCHAR2,
77: p_worksheet_id IN NUMBER,
74: p_return_status OUT NOCOPY VARCHAR2,
75: p_msg_count OUT NOCOPY NUMBER,
76: p_msg_data OUT NOCOPY VARCHAR2,
77: p_worksheet_id IN NUMBER,
78: p_global_worksheet IN VARCHAR2 := FND_API.G_TRUE
79: );
80:
81: /* ----------------------------------------------------------------------- */
82:
81: /* ----------------------------------------------------------------------- */
82:
83: -- API name : Create_Worksheet
84: -- Type : Private
85: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
86: -- Parameters :
87: -- IN : p_api_version IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 Optional
89: -- Default = FND_API.G_FALSE
85: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
86: -- Parameters :
87: -- IN : p_api_version IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 Optional
89: -- Default = FND_API.G_FALSE
90: -- p_commit IN VARCHAR2 Optional
91: -- Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional
93: -- Default = FND_API.G_VALID_LEVEL_NONE
87: -- IN : p_api_version IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 Optional
89: -- Default = FND_API.G_FALSE
90: -- p_commit IN VARCHAR2 Optional
91: -- Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional
93: -- Default = FND_API.G_VALID_LEVEL_NONE
94: -- p_budget_group_id IN NUMBER Required
95: -- p_budget_calendar_id IN NUMBER Required
89: -- Default = FND_API.G_FALSE
90: -- p_commit IN VARCHAR2 Optional
91: -- Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional
93: -- Default = FND_API.G_VALID_LEVEL_NONE
94: -- p_budget_group_id IN NUMBER Required
95: -- p_budget_calendar_id IN NUMBER Required
96: -- p_worksheet_type IN VARCHAR2 Optional
97: -- Default = 'O'
97: -- Default = 'O'
98: -- p_name IN VARCHAR2 Required
99: -- p_description IN VARCHAR2 Required
100: -- p_ws_creation_complete IN VARCHAR2 Optional
101: -- Default = FND_API.G_MISS_CHAR
102: -- p_stage_set_id IN NUMBER Required
103: -- p_current_stage_seq IN NUMBER Optional
104: -- Default = FND_API.G_MISS_NUM
105: -- p_global_worksheet_id IN NUMBER Optional
100: -- p_ws_creation_complete IN VARCHAR2 Optional
101: -- Default = FND_API.G_MISS_CHAR
102: -- p_stage_set_id IN NUMBER Required
103: -- p_current_stage_seq IN NUMBER Optional
104: -- Default = FND_API.G_MISS_NUM
105: -- p_global_worksheet_id IN NUMBER Optional
106: -- Default = FND_API.G_MISS_NUM
107: -- p_global_worksheet_flag IN NUMBER Optional
108: -- Default = FND_API.G_MISS_CHAR
102: -- p_stage_set_id IN NUMBER Required
103: -- p_current_stage_seq IN NUMBER Optional
104: -- Default = FND_API.G_MISS_NUM
105: -- p_global_worksheet_id IN NUMBER Optional
106: -- Default = FND_API.G_MISS_NUM
107: -- p_global_worksheet_flag IN NUMBER Optional
108: -- Default = FND_API.G_MISS_CHAR
109: -- p_global_worksheet_option IN VARCHAR2 Optional
110: -- Default = FND_API.G_MISS_CHAR
104: -- Default = FND_API.G_MISS_NUM
105: -- p_global_worksheet_id IN NUMBER Optional
106: -- Default = FND_API.G_MISS_NUM
107: -- p_global_worksheet_flag IN NUMBER Optional
108: -- Default = FND_API.G_MISS_CHAR
109: -- p_global_worksheet_option IN VARCHAR2 Optional
110: -- Default = FND_API.G_MISS_CHAR
111: -- p_local_copy_flag IN VARCHAR2 Optional
112: -- Default = FND_API.G_MISS_CHAR
106: -- Default = FND_API.G_MISS_NUM
107: -- p_global_worksheet_flag IN NUMBER Optional
108: -- Default = FND_API.G_MISS_CHAR
109: -- p_global_worksheet_option IN VARCHAR2 Optional
110: -- Default = FND_API.G_MISS_CHAR
111: -- p_local_copy_flag IN VARCHAR2 Optional
112: -- Default = FND_API.G_MISS_CHAR
113: -- p_copy_of_worksheet_id IN NUMBER Optional
114: -- Default = FND_API.G_MISS_NUM
108: -- Default = FND_API.G_MISS_CHAR
109: -- p_global_worksheet_option IN VARCHAR2 Optional
110: -- Default = FND_API.G_MISS_CHAR
111: -- p_local_copy_flag IN VARCHAR2 Optional
112: -- Default = FND_API.G_MISS_CHAR
113: -- p_copy_of_worksheet_id IN NUMBER Optional
114: -- Default = FND_API.G_MISS_NUM
115: -- p_freeze_flag IN VARCHAR2 Optional
116: -- Default = FND_API.G_MISS_CHAR
110: -- Default = FND_API.G_MISS_CHAR
111: -- p_local_copy_flag IN VARCHAR2 Optional
112: -- Default = FND_API.G_MISS_CHAR
113: -- p_copy_of_worksheet_id IN NUMBER Optional
114: -- Default = FND_API.G_MISS_NUM
115: -- p_freeze_flag IN VARCHAR2 Optional
116: -- Default = FND_API.G_MISS_CHAR
117: -- p_budget_by_position IN VARCHAR2 Optional
118: -- Default = FND_API.G_MISS_CHAR
112: -- Default = FND_API.G_MISS_CHAR
113: -- p_copy_of_worksheet_id IN NUMBER Optional
114: -- Default = FND_API.G_MISS_NUM
115: -- p_freeze_flag IN VARCHAR2 Optional
116: -- Default = FND_API.G_MISS_CHAR
117: -- p_budget_by_position IN VARCHAR2 Optional
118: -- Default = FND_API.G_MISS_CHAR
119: -- p_use_revised_element_rates IN VARCHAR2 Optional
120: -- Default = FND_API.G_MISS_CHAR
114: -- Default = FND_API.G_MISS_NUM
115: -- p_freeze_flag IN VARCHAR2 Optional
116: -- Default = FND_API.G_MISS_CHAR
117: -- p_budget_by_position IN VARCHAR2 Optional
118: -- Default = FND_API.G_MISS_CHAR
119: -- p_use_revised_element_rates IN VARCHAR2 Optional
120: -- Default = FND_API.G_MISS_CHAR
121: -- p_num_proposed_years IN NUMBER Optional
122: -- Default = FND_API.G_MISS_NUM
116: -- Default = FND_API.G_MISS_CHAR
117: -- p_budget_by_position IN VARCHAR2 Optional
118: -- Default = FND_API.G_MISS_CHAR
119: -- p_use_revised_element_rates IN VARCHAR2 Optional
120: -- Default = FND_API.G_MISS_CHAR
121: -- p_num_proposed_years IN NUMBER Optional
122: -- Default = FND_API.G_MISS_NUM
123: -- p_num_years_to_allocate IN NUMBER Optional
124: -- Default = FND_API.G_MISS_NUM
118: -- Default = FND_API.G_MISS_CHAR
119: -- p_use_revised_element_rates IN VARCHAR2 Optional
120: -- Default = FND_API.G_MISS_CHAR
121: -- p_num_proposed_years IN NUMBER Optional
122: -- Default = FND_API.G_MISS_NUM
123: -- p_num_years_to_allocate IN NUMBER Optional
124: -- Default = FND_API.G_MISS_NUM
125: -- p_rounding_factor IN NUMBER Optional
126: -- Default = FND_API.G_MISS_NUM
120: -- Default = FND_API.G_MISS_CHAR
121: -- p_num_proposed_years IN NUMBER Optional
122: -- Default = FND_API.G_MISS_NUM
123: -- p_num_years_to_allocate IN NUMBER Optional
124: -- Default = FND_API.G_MISS_NUM
125: -- p_rounding_factor IN NUMBER Optional
126: -- Default = FND_API.G_MISS_NUM
127: -- p_gl_cutoff_period IN DATE Optional
128: -- Default = FND_API.G_MISS_DATE
122: -- Default = FND_API.G_MISS_NUM
123: -- p_num_years_to_allocate IN NUMBER Optional
124: -- Default = FND_API.G_MISS_NUM
125: -- p_rounding_factor IN NUMBER Optional
126: -- Default = FND_API.G_MISS_NUM
127: -- p_gl_cutoff_period IN DATE Optional
128: -- Default = FND_API.G_MISS_DATE
129: -- p_budget_version_id IN NUMBER Optional
130: -- Default = FND_API.G_MISS_NUM
124: -- Default = FND_API.G_MISS_NUM
125: -- p_rounding_factor IN NUMBER Optional
126: -- Default = FND_API.G_MISS_NUM
127: -- p_gl_cutoff_period IN DATE Optional
128: -- Default = FND_API.G_MISS_DATE
129: -- p_budget_version_id IN NUMBER Optional
130: -- Default = FND_API.G_MISS_NUM
131: -- p_gl_budget_set_id IN NUMBER Optional
132: -- Default = FND_API.G_MISS_NUM
126: -- Default = FND_API.G_MISS_NUM
127: -- p_gl_cutoff_period IN DATE Optional
128: -- Default = FND_API.G_MISS_DATE
129: -- p_budget_version_id IN NUMBER Optional
130: -- Default = FND_API.G_MISS_NUM
131: -- p_gl_budget_set_id IN NUMBER Optional
132: -- Default = FND_API.G_MISS_NUM
133: -- p_include_stat_balance IN VARCHAR2 Optional
134: -- Default = FND_API.G_MISS_CHAR
128: -- Default = FND_API.G_MISS_DATE
129: -- p_budget_version_id IN NUMBER Optional
130: -- Default = FND_API.G_MISS_NUM
131: -- p_gl_budget_set_id IN NUMBER Optional
132: -- Default = FND_API.G_MISS_NUM
133: -- p_include_stat_balance IN VARCHAR2 Optional
134: -- Default = FND_API.G_MISS_CHAR
135: -- p_include_trans_balance IN VARCHAR2 Optional
136: -- Default = FND_API.G_MISS_CHAR
130: -- Default = FND_API.G_MISS_NUM
131: -- p_gl_budget_set_id IN NUMBER Optional
132: -- Default = FND_API.G_MISS_NUM
133: -- p_include_stat_balance IN VARCHAR2 Optional
134: -- Default = FND_API.G_MISS_CHAR
135: -- p_include_trans_balance IN VARCHAR2 Optional
136: -- Default = FND_API.G_MISS_CHAR
137: -- p_include_adj_period IN VARCHAR2 Required
138: -- Default = FND_API.G_MISS_CHAR
132: -- Default = FND_API.G_MISS_NUM
133: -- p_include_stat_balance IN VARCHAR2 Optional
134: -- Default = FND_API.G_MISS_CHAR
135: -- p_include_trans_balance IN VARCHAR2 Optional
136: -- Default = FND_API.G_MISS_CHAR
137: -- p_include_adj_period IN VARCHAR2 Required
138: -- Default = FND_API.G_MISS_CHAR
139: -- p_date_submitted IN DATE Optional
140: -- Default = FND_API.G_MISS_DATE
134: -- Default = FND_API.G_MISS_CHAR
135: -- p_include_trans_balance IN VARCHAR2 Optional
136: -- Default = FND_API.G_MISS_CHAR
137: -- p_include_adj_period IN VARCHAR2 Required
138: -- Default = FND_API.G_MISS_CHAR
139: -- p_date_submitted IN DATE Optional
140: -- Default = FND_API.G_MISS_DATE
141: -- p_submitted_by IN NUMBER Required
142: -- Default = FND_API.G_MISS_NUM
136: -- Default = FND_API.G_MISS_CHAR
137: -- p_include_adj_period IN VARCHAR2 Required
138: -- Default = FND_API.G_MISS_CHAR
139: -- p_date_submitted IN DATE Optional
140: -- Default = FND_API.G_MISS_DATE
141: -- p_submitted_by IN NUMBER Required
142: -- Default = FND_API.G_MISS_NUM
143: -- p_data_extract_id IN NUMBER Optional
144: -- Default = FND_API.G_MISS_NUM
138: -- Default = FND_API.G_MISS_CHAR
139: -- p_date_submitted IN DATE Optional
140: -- Default = FND_API.G_MISS_DATE
141: -- p_submitted_by IN NUMBER Required
142: -- Default = FND_API.G_MISS_NUM
143: -- p_data_extract_id IN NUMBER Optional
144: -- Default = FND_API.G_MISS_NUM
145: -- p_parameter_set_id IN NUMBER Optional
146: -- Default = FND_API.G_MISS_NUM
140: -- Default = FND_API.G_MISS_DATE
141: -- p_submitted_by IN NUMBER Required
142: -- Default = FND_API.G_MISS_NUM
143: -- p_data_extract_id IN NUMBER Optional
144: -- Default = FND_API.G_MISS_NUM
145: -- p_parameter_set_id IN NUMBER Optional
146: -- Default = FND_API.G_MISS_NUM
147: -- p_constraint_set_id IN NUMBER Optional
148: -- Default = FND_API.G_MISS_NUM
142: -- Default = FND_API.G_MISS_NUM
143: -- p_data_extract_id IN NUMBER Optional
144: -- Default = FND_API.G_MISS_NUM
145: -- p_parameter_set_id IN NUMBER Optional
146: -- Default = FND_API.G_MISS_NUM
147: -- p_constraint_set_id IN NUMBER Optional
148: -- Default = FND_API.G_MISS_NUM
149: -- p_allocrule_set_id IN NUMBER Optional
150: -- Default = FND_API.G_MISS_NUM
144: -- Default = FND_API.G_MISS_NUM
145: -- p_parameter_set_id IN NUMBER Optional
146: -- Default = FND_API.G_MISS_NUM
147: -- p_constraint_set_id IN NUMBER Optional
148: -- Default = FND_API.G_MISS_NUM
149: -- p_allocrule_set_id IN NUMBER Optional
150: -- Default = FND_API.G_MISS_NUM
151: -- p_attribute1 IN VARCHAR2 Optional
152: -- Default = FND_API.G_MISS_CHAR
146: -- Default = FND_API.G_MISS_NUM
147: -- p_constraint_set_id IN NUMBER Optional
148: -- Default = FND_API.G_MISS_NUM
149: -- p_allocrule_set_id IN NUMBER Optional
150: -- Default = FND_API.G_MISS_NUM
151: -- p_attribute1 IN VARCHAR2 Optional
152: -- Default = FND_API.G_MISS_CHAR
153: -- p_attribute2 IN VARCHAR2 Optional
154: -- Default = FND_API.G_MISS_CHAR
148: -- Default = FND_API.G_MISS_NUM
149: -- p_allocrule_set_id IN NUMBER Optional
150: -- Default = FND_API.G_MISS_NUM
151: -- p_attribute1 IN VARCHAR2 Optional
152: -- Default = FND_API.G_MISS_CHAR
153: -- p_attribute2 IN VARCHAR2 Optional
154: -- Default = FND_API.G_MISS_CHAR
155: -- p_attribute3 IN VARCHAR2 Optional
156: -- Default = FND_API.G_MISS_CHAR
150: -- Default = FND_API.G_MISS_NUM
151: -- p_attribute1 IN VARCHAR2 Optional
152: -- Default = FND_API.G_MISS_CHAR
153: -- p_attribute2 IN VARCHAR2 Optional
154: -- Default = FND_API.G_MISS_CHAR
155: -- p_attribute3 IN VARCHAR2 Optional
156: -- Default = FND_API.G_MISS_CHAR
157: -- p_attribute4 IN VARCHAR2 Optional
158: -- Default = FND_API.G_MISS_CHAR
152: -- Default = FND_API.G_MISS_CHAR
153: -- p_attribute2 IN VARCHAR2 Optional
154: -- Default = FND_API.G_MISS_CHAR
155: -- p_attribute3 IN VARCHAR2 Optional
156: -- Default = FND_API.G_MISS_CHAR
157: -- p_attribute4 IN VARCHAR2 Optional
158: -- Default = FND_API.G_MISS_CHAR
159: -- p_attribute5 IN VARCHAR2 Optional
160: -- Default = FND_API.G_MISS_CHAR
154: -- Default = FND_API.G_MISS_CHAR
155: -- p_attribute3 IN VARCHAR2 Optional
156: -- Default = FND_API.G_MISS_CHAR
157: -- p_attribute4 IN VARCHAR2 Optional
158: -- Default = FND_API.G_MISS_CHAR
159: -- p_attribute5 IN VARCHAR2 Optional
160: -- Default = FND_API.G_MISS_CHAR
161: -- p_attribute6 IN VARCHAR2 Optional
162: -- Default = FND_API.G_MISS_CHAR
156: -- Default = FND_API.G_MISS_CHAR
157: -- p_attribute4 IN VARCHAR2 Optional
158: -- Default = FND_API.G_MISS_CHAR
159: -- p_attribute5 IN VARCHAR2 Optional
160: -- Default = FND_API.G_MISS_CHAR
161: -- p_attribute6 IN VARCHAR2 Optional
162: -- Default = FND_API.G_MISS_CHAR
163: -- p_attribute7 IN VARCHAR2 Optional
164: -- Default = FND_API.G_MISS_CHAR
158: -- Default = FND_API.G_MISS_CHAR
159: -- p_attribute5 IN VARCHAR2 Optional
160: -- Default = FND_API.G_MISS_CHAR
161: -- p_attribute6 IN VARCHAR2 Optional
162: -- Default = FND_API.G_MISS_CHAR
163: -- p_attribute7 IN VARCHAR2 Optional
164: -- Default = FND_API.G_MISS_CHAR
165: -- p_attribute8 IN VARCHAR2 Optional
166: -- Default = FND_API.G_MISS_CHAR
160: -- Default = FND_API.G_MISS_CHAR
161: -- p_attribute6 IN VARCHAR2 Optional
162: -- Default = FND_API.G_MISS_CHAR
163: -- p_attribute7 IN VARCHAR2 Optional
164: -- Default = FND_API.G_MISS_CHAR
165: -- p_attribute8 IN VARCHAR2 Optional
166: -- Default = FND_API.G_MISS_CHAR
167: -- p_attribute9 IN VARCHAR2 Optional
168: -- Default = FND_API.G_MISS_CHAR
162: -- Default = FND_API.G_MISS_CHAR
163: -- p_attribute7 IN VARCHAR2 Optional
164: -- Default = FND_API.G_MISS_CHAR
165: -- p_attribute8 IN VARCHAR2 Optional
166: -- Default = FND_API.G_MISS_CHAR
167: -- p_attribute9 IN VARCHAR2 Optional
168: -- Default = FND_API.G_MISS_CHAR
169: -- p_attribute10 IN VARCHAR2 Optional
170: -- Default = FND_API.G_MISS_CHAR
164: -- Default = FND_API.G_MISS_CHAR
165: -- p_attribute8 IN VARCHAR2 Optional
166: -- Default = FND_API.G_MISS_CHAR
167: -- p_attribute9 IN VARCHAR2 Optional
168: -- Default = FND_API.G_MISS_CHAR
169: -- p_attribute10 IN VARCHAR2 Optional
170: -- Default = FND_API.G_MISS_CHAR
171: -- p_context IN VARCHAR2 Optional
172: -- Default = FND_API.G_MISS_CHAR
166: -- Default = FND_API.G_MISS_CHAR
167: -- p_attribute9 IN VARCHAR2 Optional
168: -- Default = FND_API.G_MISS_CHAR
169: -- p_attribute10 IN VARCHAR2 Optional
170: -- Default = FND_API.G_MISS_CHAR
171: -- p_context IN VARCHAR2 Optional
172: -- Default = FND_API.G_MISS_CHAR
173: -- .
174: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
168: -- Default = FND_API.G_MISS_CHAR
169: -- p_attribute10 IN VARCHAR2 Optional
170: -- Default = FND_API.G_MISS_CHAR
171: -- p_context IN VARCHAR2 Optional
172: -- Default = FND_API.G_MISS_CHAR
173: -- .
174: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
175: -- p_msg_count OUT NOCOPY NUMBER
176: -- p_msg_data OUT NOCOPY VARCHAR2(2000)
180: --
181:
182: PROCEDURE Create_Worksheet
183: ( p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
187: p_return_status OUT NOCOPY VARCHAR2,
188: p_msg_count OUT NOCOPY NUMBER,
181:
182: PROCEDURE Create_Worksheet
183: ( p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
187: p_return_status OUT NOCOPY VARCHAR2,
188: p_msg_count OUT NOCOPY NUMBER,
189: p_msg_data OUT NOCOPY VARCHAR2,
182: PROCEDURE Create_Worksheet
183: ( p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
187: p_return_status OUT NOCOPY VARCHAR2,
188: p_msg_count OUT NOCOPY NUMBER,
189: p_msg_data OUT NOCOPY VARCHAR2,
190: p_budget_group_id IN NUMBER,
191: p_budget_calendar_id IN NUMBER,
192: p_worksheet_type IN VARCHAR2 := 'O',
193: p_name IN VARCHAR2,
194: p_description IN VARCHAR2,
195: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_stage_set_id IN NUMBER,
197: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
198: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_name IN VARCHAR2,
194: p_description IN VARCHAR2,
195: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_stage_set_id IN NUMBER,
197: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
198: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_description IN VARCHAR2,
195: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_stage_set_id IN NUMBER,
197: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
198: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_stage_set_id IN NUMBER,
197: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
198: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
203: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_stage_set_id IN NUMBER,
197: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
198: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
203: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
198: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
203: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
203: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
199: p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
203: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
207: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
200: p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
203: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
207: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
208: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
201: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
203: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
207: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
208: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
209: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
202: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
203: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
207: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
208: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
209: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
210: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
203: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
207: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
208: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
209: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
210: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
211: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
204: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
207: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
208: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
209: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
210: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
211: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
212: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
207: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
208: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
209: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
210: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
211: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
212: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
207: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
208: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
209: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
210: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
211: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
212: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
208: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
209: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
210: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
211: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
212: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
208: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
209: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
210: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
211: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
212: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
216: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
209: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
210: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
211: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
212: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
216: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
217: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
210: p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
211: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
212: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
216: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
217: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
218: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
211: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
212: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
216: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
217: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
218: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
212: p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
213: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
216: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
217: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
218: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
220: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
213: p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
216: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
217: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
218: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
220: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
221: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
216: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
217: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
218: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
220: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
221: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
216: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
217: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
218: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
220: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
221: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
216: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
217: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
218: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
220: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
221: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
218: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
220: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
221: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
220: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
221: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
220: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
221: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
221: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
231: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
239: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
239: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
239: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
239: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
239: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
239: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
237: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
238: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
239: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: /* For Bug 3157960, Added the federal_Ws_flag */
238: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
239: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: /* For Bug 3157960, Added the federal_Ws_flag */
246: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
240: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: /* For Bug 3157960, Added the federal_Ws_flag */
246: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: /* bug no 4725091 */
240: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: /* For Bug 3157960, Added the federal_Ws_flag */
246: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: /* bug no 4725091 */
248: p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: /* For Bug 3157960, Added the federal_Ws_flag */
246: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: /* bug no 4725091 */
248: p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_worksheet_id OUT NOCOPY NUMBER
250: );
244: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: /* For Bug 3157960, Added the federal_Ws_flag */
246: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: /* bug no 4725091 */
248: p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_worksheet_id OUT NOCOPY NUMBER
250: );
251:
252: /* ----------------------------------------------------------------------- */
252: /* ----------------------------------------------------------------------- */
253:
254: -- API name : Update_Worksheet
255: -- Type : Private
256: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
257: -- Parameters :
258: -- IN : p_api_version IN NUMBER Required
259: -- p_init_msg_list IN VARCHAR2 Optional
260: -- Default = FND_API.G_FALSE
256: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
257: -- Parameters :
258: -- IN : p_api_version IN NUMBER Required
259: -- p_init_msg_list IN VARCHAR2 Optional
260: -- Default = FND_API.G_FALSE
261: -- p_commit IN VARCHAR2 Optional
262: -- Default = FND_API.G_FALSE
263: -- p_validation_level IN NUMBER Optional
264: -- Default = FND_API.G_VALID_LEVEL_NONE
258: -- IN : p_api_version IN NUMBER Required
259: -- p_init_msg_list IN VARCHAR2 Optional
260: -- Default = FND_API.G_FALSE
261: -- p_commit IN VARCHAR2 Optional
262: -- Default = FND_API.G_FALSE
263: -- p_validation_level IN NUMBER Optional
264: -- Default = FND_API.G_VALID_LEVEL_NONE
265: -- p_worksheet_id IN NUMBER Required
266: -- p_worksheet_type IN VARCHAR2 Optional
260: -- Default = FND_API.G_FALSE
261: -- p_commit IN VARCHAR2 Optional
262: -- Default = FND_API.G_FALSE
263: -- p_validation_level IN NUMBER Optional
264: -- Default = FND_API.G_VALID_LEVEL_NONE
265: -- p_worksheet_id IN NUMBER Required
266: -- p_worksheet_type IN VARCHAR2 Optional
267: -- Default = FND_API.G_MISS_CHAR
268: -- p_description IN VARCHAR2 Optional
263: -- p_validation_level IN NUMBER Optional
264: -- Default = FND_API.G_VALID_LEVEL_NONE
265: -- p_worksheet_id IN NUMBER Required
266: -- p_worksheet_type IN VARCHAR2 Optional
267: -- Default = FND_API.G_MISS_CHAR
268: -- p_description IN VARCHAR2 Optional
269: -- Default = FND_API.G_MISS_CHAR
270: -- p_ws_creation_complete IN VARCHAR2 Optional
271: -- Default = FND_API.G_MISS_CHAR
265: -- p_worksheet_id IN NUMBER Required
266: -- p_worksheet_type IN VARCHAR2 Optional
267: -- Default = FND_API.G_MISS_CHAR
268: -- p_description IN VARCHAR2 Optional
269: -- Default = FND_API.G_MISS_CHAR
270: -- p_ws_creation_complete IN VARCHAR2 Optional
271: -- Default = FND_API.G_MISS_CHAR
272: -- p_global_worksheet_id IN NUMBER Optional
273: -- Default = FND_API.G_MISS_NUM
267: -- Default = FND_API.G_MISS_CHAR
268: -- p_description IN VARCHAR2 Optional
269: -- Default = FND_API.G_MISS_CHAR
270: -- p_ws_creation_complete IN VARCHAR2 Optional
271: -- Default = FND_API.G_MISS_CHAR
272: -- p_global_worksheet_id IN NUMBER Optional
273: -- Default = FND_API.G_MISS_NUM
274: -- p_current_stage_seq IN NUMBER Optional
275: -- Default = FND_API.G_MISS_NUM
269: -- Default = FND_API.G_MISS_CHAR
270: -- p_ws_creation_complete IN VARCHAR2 Optional
271: -- Default = FND_API.G_MISS_CHAR
272: -- p_global_worksheet_id IN NUMBER Optional
273: -- Default = FND_API.G_MISS_NUM
274: -- p_current_stage_seq IN NUMBER Optional
275: -- Default = FND_API.G_MISS_NUM
276: -- p_local_copy_flag IN VARCHAR2 Optional
277: -- Default = FND_API.G_MISS_CHAR
271: -- Default = FND_API.G_MISS_CHAR
272: -- p_global_worksheet_id IN NUMBER Optional
273: -- Default = FND_API.G_MISS_NUM
274: -- p_current_stage_seq IN NUMBER Optional
275: -- Default = FND_API.G_MISS_NUM
276: -- p_local_copy_flag IN VARCHAR2 Optional
277: -- Default = FND_API.G_MISS_CHAR
278: -- p_copy_of_worksheet_id IN NUMBER Optional
279: -- Default = FND_API.G_MISS_NUM
273: -- Default = FND_API.G_MISS_NUM
274: -- p_current_stage_seq IN NUMBER Optional
275: -- Default = FND_API.G_MISS_NUM
276: -- p_local_copy_flag IN VARCHAR2 Optional
277: -- Default = FND_API.G_MISS_CHAR
278: -- p_copy_of_worksheet_id IN NUMBER Optional
279: -- Default = FND_API.G_MISS_NUM
280: -- p_freeze_flag IN VARCHAR2 Optional
281: -- Default = FND_API.G_MISS_CHAR
275: -- Default = FND_API.G_MISS_NUM
276: -- p_local_copy_flag IN VARCHAR2 Optional
277: -- Default = FND_API.G_MISS_CHAR
278: -- p_copy_of_worksheet_id IN NUMBER Optional
279: -- Default = FND_API.G_MISS_NUM
280: -- p_freeze_flag IN VARCHAR2 Optional
281: -- Default = FND_API.G_MISS_CHAR
282: -- p_use_revised_element_rates IN VARCHAR2 Optional
283: -- Default = FND_API.G_MISS_CHAR
277: -- Default = FND_API.G_MISS_CHAR
278: -- p_copy_of_worksheet_id IN NUMBER Optional
279: -- Default = FND_API.G_MISS_NUM
280: -- p_freeze_flag IN VARCHAR2 Optional
281: -- Default = FND_API.G_MISS_CHAR
282: -- p_use_revised_element_rates IN VARCHAR2 Optional
283: -- Default = FND_API.G_MISS_CHAR
284: -- p_date_submitted IN DATE Optional
285: -- Default = FND_API.G_MISS_DATE
279: -- Default = FND_API.G_MISS_NUM
280: -- p_freeze_flag IN VARCHAR2 Optional
281: -- Default = FND_API.G_MISS_CHAR
282: -- p_use_revised_element_rates IN VARCHAR2 Optional
283: -- Default = FND_API.G_MISS_CHAR
284: -- p_date_submitted IN DATE Optional
285: -- Default = FND_API.G_MISS_DATE
286: -- p_submitted_by IN NUMBER Required
287: -- Default = FND_API.G_MISS_NUM
281: -- Default = FND_API.G_MISS_CHAR
282: -- p_use_revised_element_rates IN VARCHAR2 Optional
283: -- Default = FND_API.G_MISS_CHAR
284: -- p_date_submitted IN DATE Optional
285: -- Default = FND_API.G_MISS_DATE
286: -- p_submitted_by IN NUMBER Required
287: -- Default = FND_API.G_MISS_NUM
288: -- p_attribute1 IN VARCHAR2 Optional
289: -- Default = FND_API.G_MISS_CHAR
283: -- Default = FND_API.G_MISS_CHAR
284: -- p_date_submitted IN DATE Optional
285: -- Default = FND_API.G_MISS_DATE
286: -- p_submitted_by IN NUMBER Required
287: -- Default = FND_API.G_MISS_NUM
288: -- p_attribute1 IN VARCHAR2 Optional
289: -- Default = FND_API.G_MISS_CHAR
290: -- p_attribute2 IN VARCHAR2 Optional
291: -- Default = FND_API.G_MISS_CHAR
285: -- Default = FND_API.G_MISS_DATE
286: -- p_submitted_by IN NUMBER Required
287: -- Default = FND_API.G_MISS_NUM
288: -- p_attribute1 IN VARCHAR2 Optional
289: -- Default = FND_API.G_MISS_CHAR
290: -- p_attribute2 IN VARCHAR2 Optional
291: -- Default = FND_API.G_MISS_CHAR
292: -- p_attribute3 IN VARCHAR2 Optional
293: -- Default = FND_API.G_MISS_CHAR
287: -- Default = FND_API.G_MISS_NUM
288: -- p_attribute1 IN VARCHAR2 Optional
289: -- Default = FND_API.G_MISS_CHAR
290: -- p_attribute2 IN VARCHAR2 Optional
291: -- Default = FND_API.G_MISS_CHAR
292: -- p_attribute3 IN VARCHAR2 Optional
293: -- Default = FND_API.G_MISS_CHAR
294: -- p_attribute4 IN VARCHAR2 Optional
295: -- Default = FND_API.G_MISS_CHAR
289: -- Default = FND_API.G_MISS_CHAR
290: -- p_attribute2 IN VARCHAR2 Optional
291: -- Default = FND_API.G_MISS_CHAR
292: -- p_attribute3 IN VARCHAR2 Optional
293: -- Default = FND_API.G_MISS_CHAR
294: -- p_attribute4 IN VARCHAR2 Optional
295: -- Default = FND_API.G_MISS_CHAR
296: -- p_attribute5 IN VARCHAR2 Optional
297: -- Default = FND_API.G_MISS_CHAR
291: -- Default = FND_API.G_MISS_CHAR
292: -- p_attribute3 IN VARCHAR2 Optional
293: -- Default = FND_API.G_MISS_CHAR
294: -- p_attribute4 IN VARCHAR2 Optional
295: -- Default = FND_API.G_MISS_CHAR
296: -- p_attribute5 IN VARCHAR2 Optional
297: -- Default = FND_API.G_MISS_CHAR
298: -- p_attribute6 IN VARCHAR2 Optional
299: -- Default = FND_API.G_MISS_CHAR
293: -- Default = FND_API.G_MISS_CHAR
294: -- p_attribute4 IN VARCHAR2 Optional
295: -- Default = FND_API.G_MISS_CHAR
296: -- p_attribute5 IN VARCHAR2 Optional
297: -- Default = FND_API.G_MISS_CHAR
298: -- p_attribute6 IN VARCHAR2 Optional
299: -- Default = FND_API.G_MISS_CHAR
300: -- p_attribute7 IN VARCHAR2 Optional
301: -- Default = FND_API.G_MISS_CHAR
295: -- Default = FND_API.G_MISS_CHAR
296: -- p_attribute5 IN VARCHAR2 Optional
297: -- Default = FND_API.G_MISS_CHAR
298: -- p_attribute6 IN VARCHAR2 Optional
299: -- Default = FND_API.G_MISS_CHAR
300: -- p_attribute7 IN VARCHAR2 Optional
301: -- Default = FND_API.G_MISS_CHAR
302: -- p_attribute8 IN VARCHAR2 Optional
303: -- Default = FND_API.G_MISS_CHAR
297: -- Default = FND_API.G_MISS_CHAR
298: -- p_attribute6 IN VARCHAR2 Optional
299: -- Default = FND_API.G_MISS_CHAR
300: -- p_attribute7 IN VARCHAR2 Optional
301: -- Default = FND_API.G_MISS_CHAR
302: -- p_attribute8 IN VARCHAR2 Optional
303: -- Default = FND_API.G_MISS_CHAR
304: -- p_attribute9 IN VARCHAR2 Optional
305: -- Default = FND_API.G_MISS_CHAR
299: -- Default = FND_API.G_MISS_CHAR
300: -- p_attribute7 IN VARCHAR2 Optional
301: -- Default = FND_API.G_MISS_CHAR
302: -- p_attribute8 IN VARCHAR2 Optional
303: -- Default = FND_API.G_MISS_CHAR
304: -- p_attribute9 IN VARCHAR2 Optional
305: -- Default = FND_API.G_MISS_CHAR
306: -- p_attribute10 IN VARCHAR2 Optional
307: -- Default = FND_API.G_MISS_CHAR
301: -- Default = FND_API.G_MISS_CHAR
302: -- p_attribute8 IN VARCHAR2 Optional
303: -- Default = FND_API.G_MISS_CHAR
304: -- p_attribute9 IN VARCHAR2 Optional
305: -- Default = FND_API.G_MISS_CHAR
306: -- p_attribute10 IN VARCHAR2 Optional
307: -- Default = FND_API.G_MISS_CHAR
308: -- p_context IN VARCHAR2 Optional
309: -- Default = FND_API.G_MISS_CHAR
303: -- Default = FND_API.G_MISS_CHAR
304: -- p_attribute9 IN VARCHAR2 Optional
305: -- Default = FND_API.G_MISS_CHAR
306: -- p_attribute10 IN VARCHAR2 Optional
307: -- Default = FND_API.G_MISS_CHAR
308: -- p_context IN VARCHAR2 Optional
309: -- Default = FND_API.G_MISS_CHAR
310: /* For Bug No. 2312657 : Start */
311: -- p_gl_cutoff_period IN DATE Optional
305: -- Default = FND_API.G_MISS_CHAR
306: -- p_attribute10 IN VARCHAR2 Optional
307: -- Default = FND_API.G_MISS_CHAR
308: -- p_context IN VARCHAR2 Optional
309: -- Default = FND_API.G_MISS_CHAR
310: /* For Bug No. 2312657 : Start */
311: -- p_gl_cutoff_period IN DATE Optional
312: -- Default = NULL
313: -- p_gl_budget_set_id IN NUMBER Optional
330: --
331:
332: PROCEDURE Update_Worksheet
333: ( p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
335: p_commit IN VARCHAR2 := FND_API.G_FALSE,
336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
337: p_return_status OUT NOCOPY VARCHAR2,
338: p_msg_count OUT NOCOPY NUMBER,
331:
332: PROCEDURE Update_Worksheet
333: ( p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
335: p_commit IN VARCHAR2 := FND_API.G_FALSE,
336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
337: p_return_status OUT NOCOPY VARCHAR2,
338: p_msg_count OUT NOCOPY NUMBER,
339: p_msg_data OUT NOCOPY VARCHAR2,
332: PROCEDURE Update_Worksheet
333: ( p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
335: p_commit IN VARCHAR2 := FND_API.G_FALSE,
336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
337: p_return_status OUT NOCOPY VARCHAR2,
338: p_msg_count OUT NOCOPY NUMBER,
339: p_msg_data OUT NOCOPY VARCHAR2,
340: p_worksheet_id IN NUMBER,
337: p_return_status OUT NOCOPY VARCHAR2,
338: p_msg_count OUT NOCOPY NUMBER,
339: p_msg_data OUT NOCOPY VARCHAR2,
340: p_worksheet_id IN NUMBER,
341: p_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
338: p_msg_count OUT NOCOPY NUMBER,
339: p_msg_data OUT NOCOPY VARCHAR2,
340: p_worksheet_id IN NUMBER,
341: p_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
346: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_msg_data OUT NOCOPY VARCHAR2,
340: p_worksheet_id IN NUMBER,
341: p_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
346: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
340: p_worksheet_id IN NUMBER,
341: p_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
346: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
341: p_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
346: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
346: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: /* Bug # 3083970 */
343: p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
346: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: /* Bug # 3083970 */
351: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
344: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
346: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: /* Bug # 3083970 */
351: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
352: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
345: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
346: p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: /* Bug # 3083970 */
351: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
352: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
353: /* End bug # 3083970 */
347: p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: /* Bug # 3083970 */
351: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
352: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
353: /* End bug # 3083970 */
354: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
355: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
348: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: /* Bug # 3083970 */
351: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
352: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
353: /* End bug # 3083970 */
354: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
355: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
356: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: /* Bug # 3083970 */
351: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
352: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
353: /* End bug # 3083970 */
354: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
355: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
356: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
352: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
353: /* End bug # 3083970 */
354: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
355: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
356: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
352: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
353: /* End bug # 3083970 */
354: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
355: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
356: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
360: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
353: /* End bug # 3083970 */
354: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
355: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
356: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
360: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
354: p_date_submitted IN DATE := FND_API.G_MISS_DATE,
355: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
356: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
360: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
362: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
355: p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
356: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
360: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
362: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
363: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
360: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
362: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
363: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
364: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
357: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
360: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
362: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
363: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
364: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
365: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
360: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
362: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
363: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
364: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
365: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
366: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
359: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
360: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
362: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
363: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
364: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
365: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
366: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
367: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
360: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
362: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
363: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
364: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
365: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
366: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
367: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
361: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
362: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
363: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
364: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
365: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
366: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
367: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
362: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
363: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
364: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
365: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
366: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
367: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
363: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
364: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
365: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
366: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
367: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
364: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
365: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
366: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
367: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
365: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
366: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
367: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
366: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
367: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
367: p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
370: p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
378: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
371: p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
372: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
378: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
379: /* For Bug No. 2312657 : Start */
372: p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
373: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
378: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
379: /* For Bug No. 2312657 : Start */
380: p_gl_cutoff_period IN DATE := NULL,
373: p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
374: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
378: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
379: /* For Bug No. 2312657 : Start */
380: p_gl_cutoff_period IN DATE := NULL,
381: p_gl_budget_set_id IN NUMBER := NULL,
374: p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
378: p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
379: /* For Bug No. 2312657 : Start */
380: p_gl_cutoff_period IN DATE := NULL,
381: p_gl_budget_set_id IN NUMBER := NULL,
382: /* For Bug No. 2312657 : End */
380: p_gl_cutoff_period IN DATE := NULL,
381: p_gl_budget_set_id IN NUMBER := NULL,
382: /* For Bug No. 2312657 : End */
383: /* For Bug No. 3157960, added the federal_ws_flag */
384: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: /* bug no 4725091 */
386: p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR
387:
388: );
382: /* For Bug No. 2312657 : End */
383: /* For Bug No. 3157960, added the federal_ws_flag */
384: p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: /* bug no 4725091 */
386: p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR
387:
388: );
389:
390: /* ----------------------------------------------------------------------- */
390: /* ----------------------------------------------------------------------- */
391:
392: -- API name : Delete_Worksheet
393: -- Type : Private
394: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
395: -- Parameters :
396: -- IN : p_api_version IN NUMBER Required
397: -- p_init_msg_list IN VARCHAR2 Optional
398: -- Default = FND_API.G_FALSE
394: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
395: -- Parameters :
396: -- IN : p_api_version IN NUMBER Required
397: -- p_init_msg_list IN VARCHAR2 Optional
398: -- Default = FND_API.G_FALSE
399: -- p_commit IN VARCHAR2 Optional
400: -- Default = FND_API.G_FALSE
401: -- p_worksheet_id IN NUMBER Required
402: -- .
396: -- IN : p_api_version IN NUMBER Required
397: -- p_init_msg_list IN VARCHAR2 Optional
398: -- Default = FND_API.G_FALSE
399: -- p_commit IN VARCHAR2 Optional
400: -- Default = FND_API.G_FALSE
401: -- p_worksheet_id IN NUMBER Required
402: -- .
403: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
404: -- p_msg_count OUT NOCOPY NUMBER
412: --
413:
414: PROCEDURE Delete_Worksheet
415: ( p_api_version IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_commit IN VARCHAR2 := FND_API.G_FALSE,
418: p_return_status OUT NOCOPY VARCHAR2,
419: p_msg_count OUT NOCOPY NUMBER,
420: p_msg_data OUT NOCOPY VARCHAR2,
413:
414: PROCEDURE Delete_Worksheet
415: ( p_api_version IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_commit IN VARCHAR2 := FND_API.G_FALSE,
418: p_return_status OUT NOCOPY VARCHAR2,
419: p_msg_count OUT NOCOPY NUMBER,
420: p_msg_data OUT NOCOPY VARCHAR2,
421: p_worksheet_id IN NUMBER
424: /* ----------------------------------------------------------------------- */
425:
426: -- API name : Apply_Constraints
427: -- Type : Public
428: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
429: -- Parameters :
430: -- IN : p_api_version IN NUMBER Required
431: -- p_init_msg_list IN VARCHAR2 Optional
432: -- Default = FND_API.G_FALSE
428: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
429: -- Parameters :
430: -- IN : p_api_version IN NUMBER Required
431: -- p_init_msg_list IN VARCHAR2 Optional
432: -- Default = FND_API.G_FALSE
433: -- p_commit IN VARCHAR2 Optional
434: -- Default = FND_API.G_FALSE
435: -- p_validation_level IN NUMBER Optional
436: -- Default = FND_API.G_VALID_LEVEL_NONE
430: -- IN : p_api_version IN NUMBER Required
431: -- p_init_msg_list IN VARCHAR2 Optional
432: -- Default = FND_API.G_FALSE
433: -- p_commit IN VARCHAR2 Optional
434: -- Default = FND_API.G_FALSE
435: -- p_validation_level IN NUMBER Optional
436: -- Default = FND_API.G_VALID_LEVEL_NONE
437: -- p_worksheet_id IN NUMBER Required
438: -- p_budget_group_id IN NUMBER Optional
432: -- Default = FND_API.G_FALSE
433: -- p_commit IN VARCHAR2 Optional
434: -- Default = FND_API.G_FALSE
435: -- p_validation_level IN NUMBER Optional
436: -- Default = FND_API.G_VALID_LEVEL_NONE
437: -- p_worksheet_id IN NUMBER Required
438: -- p_budget_group_id IN NUMBER Optional
439: -- Default = FND_API.G_MISS_NUM
440: -- p_flex_code IN NUMBER Optional
435: -- p_validation_level IN NUMBER Optional
436: -- Default = FND_API.G_VALID_LEVEL_NONE
437: -- p_worksheet_id IN NUMBER Required
438: -- p_budget_group_id IN NUMBER Optional
439: -- Default = FND_API.G_MISS_NUM
440: -- p_flex_code IN NUMBER Optional
441: -- Default = FND_API.G_MISS_NUM
442: -- p_func_currency IN VARCHAR2 Optional
443: -- Default = FND_API.G_MISS_CHAR
437: -- p_worksheet_id IN NUMBER Required
438: -- p_budget_group_id IN NUMBER Optional
439: -- Default = FND_API.G_MISS_NUM
440: -- p_flex_code IN NUMBER Optional
441: -- Default = FND_API.G_MISS_NUM
442: -- p_func_currency IN VARCHAR2 Optional
443: -- Default = FND_API.G_MISS_CHAR
444: -- p_global_worksheet_id IN NUMBER Optional
445: -- Default = FND_API.G_MISS_NUM
439: -- Default = FND_API.G_MISS_NUM
440: -- p_flex_code IN NUMBER Optional
441: -- Default = FND_API.G_MISS_NUM
442: -- p_func_currency IN VARCHAR2 Optional
443: -- Default = FND_API.G_MISS_CHAR
444: -- p_global_worksheet_id IN NUMBER Optional
445: -- Default = FND_API.G_MISS_NUM
446: -- p_constraint_set_id IN NUMBER Optional
447: -- Default = FND_API.G_MISS_NUM
441: -- Default = FND_API.G_MISS_NUM
442: -- p_func_currency IN VARCHAR2 Optional
443: -- Default = FND_API.G_MISS_CHAR
444: -- p_global_worksheet_id IN NUMBER Optional
445: -- Default = FND_API.G_MISS_NUM
446: -- p_constraint_set_id IN NUMBER Optional
447: -- Default = FND_API.G_MISS_NUM
448: -- p_constraint_set_name IN VARCHAR2 Optional
449: -- Default = FND_API.G_MISS_CHAR
443: -- Default = FND_API.G_MISS_CHAR
444: -- p_global_worksheet_id IN NUMBER Optional
445: -- Default = FND_API.G_MISS_NUM
446: -- p_constraint_set_id IN NUMBER Optional
447: -- Default = FND_API.G_MISS_NUM
448: -- p_constraint_set_name IN VARCHAR2 Optional
449: -- Default = FND_API.G_MISS_CHAR
450: -- p_constraint_set_threshold IN NUMBER Optional
451: -- Default = FND_API.G_MISS_NUM
445: -- Default = FND_API.G_MISS_NUM
446: -- p_constraint_set_id IN NUMBER Optional
447: -- Default = FND_API.G_MISS_NUM
448: -- p_constraint_set_name IN VARCHAR2 Optional
449: -- Default = FND_API.G_MISS_CHAR
450: -- p_constraint_set_threshold IN NUMBER Optional
451: -- Default = FND_API.G_MISS_NUM
452: -- p_budget_calendar_id IN NUMBER Optional
453: -- Default = FND_API.G_MISS_NUM
447: -- Default = FND_API.G_MISS_NUM
448: -- p_constraint_set_name IN VARCHAR2 Optional
449: -- Default = FND_API.G_MISS_CHAR
450: -- p_constraint_set_threshold IN NUMBER Optional
451: -- Default = FND_API.G_MISS_NUM
452: -- p_budget_calendar_id IN NUMBER Optional
453: -- Default = FND_API.G_MISS_NUM
454: -- p_data_extract_id IN NUMBER Optional
455: -- Default = FND_API.G_MISS_NUM
449: -- Default = FND_API.G_MISS_CHAR
450: -- p_constraint_set_threshold IN NUMBER Optional
451: -- Default = FND_API.G_MISS_NUM
452: -- p_budget_calendar_id IN NUMBER Optional
453: -- Default = FND_API.G_MISS_NUM
454: -- p_data_extract_id IN NUMBER Optional
455: -- Default = FND_API.G_MISS_NUM
456: -- p_business_group_id IN NUMBER Optional
457: -- Default = FND_API.G_MISS_NUM
451: -- Default = FND_API.G_MISS_NUM
452: -- p_budget_calendar_id IN NUMBER Optional
453: -- Default = FND_API.G_MISS_NUM
454: -- p_data_extract_id IN NUMBER Optional
455: -- Default = FND_API.G_MISS_NUM
456: -- p_business_group_id IN NUMBER Optional
457: -- Default = FND_API.G_MISS_NUM
458: -- p_budget_by_position IN VARCHAR2 Optional
459: -- Default = FND_API.G_MISS_CHAR
453: -- Default = FND_API.G_MISS_NUM
454: -- p_data_extract_id IN NUMBER Optional
455: -- Default = FND_API.G_MISS_NUM
456: -- p_business_group_id IN NUMBER Optional
457: -- Default = FND_API.G_MISS_NUM
458: -- p_budget_by_position IN VARCHAR2 Optional
459: -- Default = FND_API.G_MISS_CHAR
460: -- .
461: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
455: -- Default = FND_API.G_MISS_NUM
456: -- p_business_group_id IN NUMBER Optional
457: -- Default = FND_API.G_MISS_NUM
458: -- p_budget_by_position IN VARCHAR2 Optional
459: -- Default = FND_API.G_MISS_CHAR
460: -- .
461: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
462: -- p_msg_count OUT NOCOPY NUMBER
463: -- p_msg_data OUT NOCOPY VARCHAR2(2000)
471: -- Validation Errors
472:
473: PROCEDURE Apply_Constraints
474: ( p_api_version IN NUMBER,
475: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
476: p_commit IN VARCHAR2 := FND_API.G_FALSE,
477: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
478: p_return_status OUT NOCOPY VARCHAR2,
479: p_msg_count OUT NOCOPY NUMBER,
472:
473: PROCEDURE Apply_Constraints
474: ( p_api_version IN NUMBER,
475: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
476: p_commit IN VARCHAR2 := FND_API.G_FALSE,
477: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
478: p_return_status OUT NOCOPY VARCHAR2,
479: p_msg_count OUT NOCOPY NUMBER,
480: p_msg_data OUT NOCOPY VARCHAR2,
473: PROCEDURE Apply_Constraints
474: ( p_api_version IN NUMBER,
475: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
476: p_commit IN VARCHAR2 := FND_API.G_FALSE,
477: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
478: p_return_status OUT NOCOPY VARCHAR2,
479: p_msg_count OUT NOCOPY NUMBER,
480: p_msg_data OUT NOCOPY VARCHAR2,
481: p_validation_status OUT NOCOPY VARCHAR2,
479: p_msg_count OUT NOCOPY NUMBER,
480: p_msg_data OUT NOCOPY VARCHAR2,
481: p_validation_status OUT NOCOPY VARCHAR2,
482: p_worksheet_id IN NUMBER,
483: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
484: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
485: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
487: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
480: p_msg_data OUT NOCOPY VARCHAR2,
481: p_validation_status OUT NOCOPY VARCHAR2,
482: p_worksheet_id IN NUMBER,
483: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
484: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
485: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
487: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
488: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
481: p_validation_status OUT NOCOPY VARCHAR2,
482: p_worksheet_id IN NUMBER,
483: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
484: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
485: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
487: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
488: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
482: p_worksheet_id IN NUMBER,
483: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
484: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
485: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
487: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
488: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
490: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
483: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
484: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
485: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
487: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
488: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
490: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
491: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
484: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
485: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
487: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
488: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
490: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
491: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
492: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
487: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
488: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
490: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
491: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
492: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
493: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR
486: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
487: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
488: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
490: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
491: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
492: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
493: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR
494: );
487: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
488: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
490: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
491: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
492: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
493: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR
494: );
495:
488: p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
490: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
491: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
492: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
493: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR
494: );
495:
496: /* ----------------------------------------------------------------------- */
489: p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
490: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
491: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
492: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
493: p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR
494: );
495:
496: /* ----------------------------------------------------------------------- */
497:
496: /* ----------------------------------------------------------------------- */
497:
498: -- API name : Validate_Entity_Set
499: -- Type : Public
500: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
501: -- Parameters :
502: -- IN : p_api_version IN NUMBER Required
503: -- p_init_msg_list IN VARCHAR2 Optional
504: -- Default = FND_API.G_FALSE
500: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
501: -- Parameters :
502: -- IN : p_api_version IN NUMBER Required
503: -- p_init_msg_list IN VARCHAR2 Optional
504: -- Default = FND_API.G_FALSE
505: -- p_validation_level IN NUMBER Optional
506: -- Default = FND_API.G_VALID_LEVEL_NONE
507: -- p_data_extract_id IN NUMBER Required
508: -- p_parameter_set_id IN NUMBER Required
502: -- IN : p_api_version IN NUMBER Required
503: -- p_init_msg_list IN VARCHAR2 Optional
504: -- Default = FND_API.G_FALSE
505: -- p_validation_level IN NUMBER Optional
506: -- Default = FND_API.G_VALID_LEVEL_NONE
507: -- p_data_extract_id IN NUMBER Required
508: -- p_parameter_set_id IN NUMBER Required
509: -- p_constraint_set_id IN NUMBER Required
510: -- .
519: -- Notes : Validate Entity Sets for a Data Extract
520:
521: PROCEDURE Validate_Entity_Set
522: ( p_api_version IN NUMBER,
523: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
524: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
525: p_return_status OUT NOCOPY VARCHAR2,
526: p_msg_count OUT NOCOPY NUMBER,
527: p_msg_data OUT NOCOPY VARCHAR2,
520:
521: PROCEDURE Validate_Entity_Set
522: ( p_api_version IN NUMBER,
523: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
524: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
525: p_return_status OUT NOCOPY VARCHAR2,
526: p_msg_count OUT NOCOPY NUMBER,
527: p_msg_data OUT NOCOPY VARCHAR2,
528: p_data_extract_id IN NUMBER,
533: /* ----------------------------------------------------------------------- */
534:
535: -- API name : Delete_WPL
536: -- Type : Private
537: -- Pre-reqs : FND_API, FND_MESSAGE
538: -- .
539: -- Parameters :
540: -- IN : p_api_version IN NUMBER Required
541: -- p_init_msg_list IN VARCHAR2 Optional
538: -- .
539: -- Parameters :
540: -- IN : p_api_version IN NUMBER Required
541: -- p_init_msg_list IN VARCHAR2 Optional
542: -- Default = FND_API.G_FALSE
543: -- p_validation_level IN NUMBER Optional
544: -- Default = FND_API.G_VALID_LEVEL_NONE
545: -- p_worksheet_id IN NUMBER Required
546: -- p_position_line_id IN NUMBER Required
540: -- IN : p_api_version IN NUMBER Required
541: -- p_init_msg_list IN VARCHAR2 Optional
542: -- Default = FND_API.G_FALSE
543: -- p_validation_level IN NUMBER Optional
544: -- Default = FND_API.G_VALID_LEVEL_NONE
545: -- p_worksheet_id IN NUMBER Required
546: -- p_position_line_id IN NUMBER Required
547: -- .
548: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
557: --
558:
559: PROCEDURE Delete_WPL
560: ( p_api_version IN NUMBER,
561: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
562: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
563: p_return_status OUT NOCOPY VARCHAR2,
564: p_msg_count OUT NOCOPY NUMBER,
565: p_msg_data OUT NOCOPY VARCHAR2,
558:
559: PROCEDURE Delete_WPL
560: ( p_api_version IN NUMBER,
561: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
562: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
563: p_return_status OUT NOCOPY VARCHAR2,
564: p_msg_count OUT NOCOPY NUMBER,
565: p_msg_data OUT NOCOPY VARCHAR2,
566: p_worksheet_id IN NUMBER,