70: -- PARAMETERS
71: ---------------------------------------------------------------------
72: PROCEDURE create_alloc_hierarchy(
73: p_api_version IN NUMBER DEFAULT 1.0
74: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
75: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
76: , p_alloc_id IN NUMBER
77: , x_return_status OUT NOCOPY VARCHAR2
78: , x_msg_count OUT NOCOPY NUMBER
71: ---------------------------------------------------------------------
72: PROCEDURE create_alloc_hierarchy(
73: p_api_version IN NUMBER DEFAULT 1.0
74: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
75: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
76: , p_alloc_id IN NUMBER
77: , x_return_status OUT NOCOPY VARCHAR2
78: , x_msg_count OUT NOCOPY NUMBER
79: , x_msg_data OUT NOCOPY VARCHAR2
90: -- p_alloc_id allocation id in ozf_act_metrics_all table --
91: -- p_alloc_status allocation status in ozf_act_metric_facts_all table
92: ----------------------------------------------------------------------------------------
93: Procedure publish_allocation( p_api_version IN NUMBER DEFAULT 1.0
94: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
95: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
96: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
97: , p_alloc_id IN NUMBER
98: , p_alloc_status IN VARCHAR2
91: -- p_alloc_status allocation status in ozf_act_metric_facts_all table
92: ----------------------------------------------------------------------------------------
93: Procedure publish_allocation( p_api_version IN NUMBER DEFAULT 1.0
94: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
95: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
96: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
97: , p_alloc_id IN NUMBER
98: , p_alloc_status IN VARCHAR2
99: , p_alloc_obj_ver IN NUMBER
92: ----------------------------------------------------------------------------------------
93: Procedure publish_allocation( p_api_version IN NUMBER DEFAULT 1.0
94: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
95: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
96: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
97: , p_alloc_id IN NUMBER
98: , p_alloc_status IN VARCHAR2
99: , p_alloc_obj_ver IN NUMBER
100: , x_return_status OUT NOCOPY VARCHAR2
112: ---------------------------------PARAMETERS---------------------------------------------
113: -- p_alloc_id allocation id in ozf_act_metrics_all table --
114: ----------------------------------------------------------------------------------------
115: Procedure validate_worksheet(p_api_version IN NUMBER DEFAULT 1.0,
116: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
117: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
118: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
119: p_alloc_id IN NUMBER,
120: x_return_status OUT NOCOPY VARCHAR2,
113: -- p_alloc_id allocation id in ozf_act_metrics_all table --
114: ----------------------------------------------------------------------------------------
115: Procedure validate_worksheet(p_api_version IN NUMBER DEFAULT 1.0,
116: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
117: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
118: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
119: p_alloc_id IN NUMBER,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
114: ----------------------------------------------------------------------------------------
115: Procedure validate_worksheet(p_api_version IN NUMBER DEFAULT 1.0,
116: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
117: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
118: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
119: p_alloc_id IN NUMBER,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2
140: -- recommend_total_amount, recommend_hb_amount, --
141: -- node_id, level_depth --
142: ----------------------------------------------------------------------------------------
143: Procedure update_worksheet_amount(p_api_version IN NUMBER DEFAULT 1.0,
144: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
145: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
146: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
147: p_alloc_id IN NUMBER,
148: p_alloc_obj_ver IN NUMBER,
141: -- node_id, level_depth --
142: ----------------------------------------------------------------------------------------
143: Procedure update_worksheet_amount(p_api_version IN NUMBER DEFAULT 1.0,
144: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
145: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
146: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
147: p_alloc_id IN NUMBER,
148: p_alloc_obj_ver IN NUMBER,
149: p_cascade_flag IN VARCHAR2 DEFAULT 'N',
142: ----------------------------------------------------------------------------------------
143: Procedure update_worksheet_amount(p_api_version IN NUMBER DEFAULT 1.0,
144: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
145: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
146: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
147: p_alloc_id IN NUMBER,
148: p_alloc_obj_ver IN NUMBER,
149: p_cascade_flag IN VARCHAR2 DEFAULT 'N',
150: p_fact_table IN fact_table_type,
168: -- PARAMETERS
169: ---------------------------------------------------------------------
170: PROCEDURE update_alloc_status(
171: p_api_version IN NUMBER DEFAULT 1.0
172: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
173: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
174: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
175: , p_alloc_id IN NUMBER
176: , p_alloc_status IN VARCHAR2
169: ---------------------------------------------------------------------
170: PROCEDURE update_alloc_status(
171: p_api_version IN NUMBER DEFAULT 1.0
172: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
173: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
174: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
175: , p_alloc_id IN NUMBER
176: , p_alloc_status IN VARCHAR2
177: , p_alloc_obj_ver IN NUMBER
170: PROCEDURE update_alloc_status(
171: p_api_version IN NUMBER DEFAULT 1.0
172: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
173: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
174: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
175: , p_alloc_id IN NUMBER
176: , p_alloc_status IN VARCHAR2
177: , p_alloc_obj_ver IN NUMBER
178: , x_return_status OUT NOCOPY VARCHAR2
194: -- p_approve_all_flag Y - approve all levels below; N - approve the next level only --
195: -- p_factid_table children fact ids to be approved --
196: ----------------------------------------------------------------------------------------
197: Procedure approve_levels(p_api_version IN NUMBER DEFAULT 1.0,
198: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
200: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
201: p_approver_factid IN NUMBER,
202: p_approve_all_flag IN VARCHAR2,
195: -- p_factid_table children fact ids to be approved --
196: ----------------------------------------------------------------------------------------
197: Procedure approve_levels(p_api_version IN NUMBER DEFAULT 1.0,
198: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
200: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
201: p_approver_factid IN NUMBER,
202: p_approve_all_flag IN VARCHAR2,
203: p_factid_table IN factid_table_type,
196: ----------------------------------------------------------------------------------------
197: Procedure approve_levels(p_api_version IN NUMBER DEFAULT 1.0,
198: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
200: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
201: p_approver_factid IN NUMBER,
202: p_approve_all_flag IN VARCHAR2,
203: p_factid_table IN factid_table_type,
204: x_return_status OUT NOCOPY VARCHAR2,
219: -- p_fact_obj_ver fact object version number --
220: -- p_note justification note if any --
221: ----------------------------------------------------------------------------------------
222: Procedure submit_request(p_api_version IN NUMBER DEFAULT 1.0,
223: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
224: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
226: p_fact_id IN NUMBER,
227: p_fact_obj_ver IN NUMBER,
220: -- p_note justification note if any --
221: ----------------------------------------------------------------------------------------
222: Procedure submit_request(p_api_version IN NUMBER DEFAULT 1.0,
223: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
224: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
226: p_fact_id IN NUMBER,
227: p_fact_obj_ver IN NUMBER,
228: p_note IN VARCHAR2 DEFAULT NULL,
221: ----------------------------------------------------------------------------------------
222: Procedure submit_request(p_api_version IN NUMBER DEFAULT 1.0,
223: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
224: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
226: p_fact_id IN NUMBER,
227: p_fact_obj_ver IN NUMBER,
228: p_note IN VARCHAR2 DEFAULT NULL,
229: x_return_status OUT NOCOPY VARCHAR2,
243: -- p_rejector_factid rejector's fact id --
244: -- p_factid_table children fact ids to be rejected --
245: ----------------------------------------------------------------------------------------
246: Procedure reject_request(p_api_version IN NUMBER DEFAULT 1.0,
247: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
248: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
249: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
250: p_rejector_factid IN NUMBER,
251: p_factid_table IN factid_table_type,
244: -- p_factid_table children fact ids to be rejected --
245: ----------------------------------------------------------------------------------------
246: Procedure reject_request(p_api_version IN NUMBER DEFAULT 1.0,
247: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
248: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
249: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
250: p_rejector_factid IN NUMBER,
251: p_factid_table IN factid_table_type,
252: x_return_status OUT NOCOPY VARCHAR2,
245: ----------------------------------------------------------------------------------------
246: Procedure reject_request(p_api_version IN NUMBER DEFAULT 1.0,
247: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
248: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
249: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,
250: p_rejector_factid IN NUMBER,
251: p_factid_table IN factid_table_type,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,