DBA Data[Home] [Help]

APPS.OZF_FUND_ALLOCATIONS_PVT dependencies on FND_API

Line 74: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 75: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 94: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 95: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 96: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

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

Line 116: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 117: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 118: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

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

Line 144: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 145: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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',

Line 146: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

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,

Line 172: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 173: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 174: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

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

Line 198: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 199: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 200: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

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,

Line 223: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 224: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 225: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

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,

Line 247: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 248: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 249: p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

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,