eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_BUDGETAPPROVAL_PVT dependencies on OZF_ACTBUDGETS_PVT

Line 149: l_act_budget_rec OZF_ActBudgets_PVT.Act_Budgets_Rec_Type;

145: l_api_name CONSTANT VARCHAR2(30) := 'WF_Respond';
146: l_api_version CONSTANT NUMBER := 1.0;
147:
148: l_status_code VARCHAR2(30);
149: l_act_budget_rec OZF_ActBudgets_PVT.Act_Budgets_Rec_Type;
150: l_org_id NUMBER;
151:
152: CURSOR c_status_code (p_status_id IN NUMBER) IS
153: SELECT system_status_code

Line 219: OZF_ActBudgets_PVT.Init_Act_Budgets_Rec (l_act_budget_rec);

215: ELSE
216: -- an error has occurred during the Workflow
217: -- process, so revert the status to NEW -- rely
218: -- on WF to generate a notification.
219: OZF_ActBudgets_PVT.Init_Act_Budgets_Rec (l_act_budget_rec);
220: l_act_budget_rec.activity_budget_id := p_activity_budget_id;
221: l_act_budget_rec.status_code := 'NEW';
222: l_act_budget_rec.user_status_id := ozf_utility_pvt.get_default_user_status(g_status_type, l_act_budget_rec.status_code);
223: -- 11/12/2001 mpande added the following

Line 225: OZF_ActBudgets_PVT.Update_Act_Budgets (

221: l_act_budget_rec.status_code := 'NEW';
222: l_act_budget_rec.user_status_id := ozf_utility_pvt.get_default_user_status(g_status_type, l_act_budget_rec.status_code);
223: -- 11/12/2001 mpande added the following
224: l_act_budget_rec.comment := p_comment ;
225: OZF_ActBudgets_PVT.Update_Act_Budgets (
226: p_api_version => 1.0,
227: p_init_msg_list => FND_API.g_false,
228: p_commit => FND_API.g_false,
229: p_validation_level => p_validation_level,

Line 269: l_act_budgets_rec OZF_ActBudgets_PVT.Act_Budgets_Rec_Type;

265: -- 11/12/2001 mpande added the following
266: p_comment IN VARCHAR2 := NULL
267: )
268: IS
269: l_act_budgets_rec OZF_ActBudgets_PVT.Act_Budgets_Rec_Type;
270: BEGIN
271: OZF_ActBudgets_PVT.Init_Act_Budgets_Rec (l_act_budgets_rec);
272: l_act_budgets_rec.activity_budget_id := p_activity_budget_id;
273: l_act_budgets_rec.status_code := 'APPROVED';

Line 271: OZF_ActBudgets_PVT.Init_Act_Budgets_Rec (l_act_budgets_rec);

267: )
268: IS
269: l_act_budgets_rec OZF_ActBudgets_PVT.Act_Budgets_Rec_Type;
270: BEGIN
271: OZF_ActBudgets_PVT.Init_Act_Budgets_Rec (l_act_budgets_rec);
272: l_act_budgets_rec.activity_budget_id := p_activity_budget_id;
273: l_act_budgets_rec.status_code := 'APPROVED';
274: --05/17/2001 mpande
275: l_act_budgets_rec.user_status_id := ozf_utility_pvt.get_default_user_status(g_status_type, l_act_budgets_rec.status_code);

Line 281: OZF_ActBudgets_PVT.Update_Act_Budgets (

277: l_act_budgets_rec.approved_in_currency := p_approved_currency;
278: l_act_budgets_rec.approved_original_amount := p_approved_amount;
279: -- 11/12/2001 mpande added the following
280: l_act_budgets_rec.comment := p_comment ;
281: OZF_ActBudgets_PVT.Update_Act_Budgets (
282: p_api_version => 1.0,
283: p_init_msg_list => p_init_msg_list,
284: p_commit => p_commit,
285: p_validation_level => p_validation_level,

Line 317: l_act_budgets_rec OZF_ActBudgets_PVT.Act_Budgets_Rec_Type;

313: -- 11/12/2001 mpande added the following
314: p_comment IN VARCHAR2 := NULL
315: )
316: IS
317: l_act_budgets_rec OZF_ActBudgets_PVT.Act_Budgets_Rec_Type;
318: -- add by feliu on 02/24/04 for soft fund. when request is rejected, the soft fund
319: -- approval should be revoke.
320: l_request_header_id NUMBER;
321:

Line 342: OZF_ActBudgets_PVT.Init_Act_Budgets_Rec (l_act_budgets_rec);

338: AND approval_level = (SELECT min(approval_level) from ozf_approval_access WHERE object_type ='SOFT_FUND'
339: AND object_id = l_request_header_id );
340: END IF;
341:
342: OZF_ActBudgets_PVT.Init_Act_Budgets_Rec (l_act_budgets_rec);
343: l_act_budgets_rec.activity_budget_id := p_activity_budget_id;
344: l_act_budgets_rec.approver_id := p_approver_id;
345: l_act_budgets_rec.status_code := 'REJECTED';
346: --05/17/2001 mpande

Line 350: OZF_ActBudgets_PVT.Update_Act_Budgets (

346: --05/17/2001 mpande
347: l_act_budgets_rec.user_status_id := ozf_utility_pvt.get_default_user_status(g_status_type, l_act_budgets_rec.status_code);
348: -- 11/12/2001 mpande added the following
349: l_act_budgets_rec.comment := p_comment ;
350: OZF_ActBudgets_PVT.Update_Act_Budgets (
351: p_api_version => 1.0,
352: p_init_msg_list => p_init_msg_list,
353: p_commit => p_commit,
354: p_validation_level => p_validation_level,

Line 392: p_act_budget_rec IN OZF_ACTBUDGETS_PVT.Act_Budgets_Rec_Type,

388: -- History
389: -- Created Mpande 01/03/2002
390: ----------------------------------------------------------------
391: PROCEDURE notify_vendor (
392: p_act_budget_rec IN OZF_ACTBUDGETS_PVT.Act_Budgets_Rec_Type,
393: x_return_status OUT NOCOPY VARCHAR2,
394: x_msg_count OUT NOCOPY NUMBER,
395: x_msg_data OUT NOCOPY VARCHAR2)
396: IS

Line 523: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

519: x_msg_count OUT NOCOPY NUMBER,
520: x_msg_data OUT NOCOPY VARCHAR2)
521: IS
522:
523: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
524: l_fund_rec ozf_funds_pvt.fund_rec_type;
525: l_activity_budget_id NUMBER;
526: l_budget_source_id NUMBER;
527: l_committed_amt NUMBER;

Line 601: ozf_actbudgets_pvt.update_act_budgets ( p_api_version => 1.0

597: l_act_budgets_rec.approved_original_amount := fnd_api.g_miss_num;
598: l_act_budgets_rec.approved_in_currency := fnd_api.g_miss_char;
599:
600: -- revert the APPROVED budget line to NEW
601: ozf_actbudgets_pvt.update_act_budgets ( p_api_version => 1.0
602: ,p_init_msg_list => fnd_api.g_false
603: ,p_commit => fnd_api.g_false
604: ,p_validation_level => fnd_api.g_valid_level_full
605: ,x_return_status => l_return_status

Line 2932: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type ;

2928: l_new_status_id NUMBER;
2929: l_return_status VARCHAR2(30);
2930: l_msg_count NUMBER;
2931: l_msg_data VARCHAR2(2048);
2932: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type ;
2933: l_offer_status VARCHAR2(30) := 'ACTIVE';
2934: l_strSubject VARCHAR2(300);
2935: l_strBody VARCHAR2(2000);
2936: l_owner_id NUMBER;

Line 2999: -- single budget request submission. called from ozf_actbudgets_pvt.

2995: IF p_actbudget_id IS NOT NULL THEN
2996:
2997: ozf_utility_pvt.Write_Conc_log('p_actbudget_id IS NOT NULL');
2998:
2999: -- single budget request submission. called from ozf_actbudgets_pvt.
3000: validate_object_budget ( p_object_id => p_object_id,
3001: p_object_type => p_object_type,
3002: p_actbudget_id => p_actbudget_id,
3003: x_return_status => l_return_status,

Line 3008: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budgets_rec);

3004: x_msg_count => l_msg_count,
3005: x_msg_data => l_msg_data);
3006:
3007:
3008: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budgets_rec);
3009: l_act_budgets_rec.activity_budget_id := p_actbudget_id;
3010:
3011: IF l_return_status = fnd_api.G_RET_STS_SUCCESS THEN
3012: ozf_utility_pvt.Write_Conc_log('validation succeeds');

Line 3091: ozf_actbudgets_pvt.Update_Act_Budgets (

3087: END IF;
3088:
3089: END IF; -- end of validation fail.
3090:
3091: ozf_actbudgets_pvt.Update_Act_Budgets (
3092: p_api_version => 1.0,
3093: p_init_msg_list => FND_API.g_false,
3094: p_commit => FND_API.g_false,
3095: p_validation_level => fnd_api.g_valid_level_full,

Line 3120: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budgets_rec);

3116: x_return_status => l_return_status,
3117: x_msg_count => l_msg_count,
3118: x_msg_data => l_msg_data);
3119:
3120: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budgets_rec);
3121: l_act_budgets_rec.activity_budget_id := request_rec.activity_budget_id;
3122:
3123: ozf_utility_pvt.Write_Conc_log('Validation return status = ' || l_return_status);
3124:

Line 3202: ozf_actbudgets_pvt.Update_Act_Budgets ( p_api_version => 1.0,

3198:
3199: ozf_utility_pvt.Write_Conc_log('l_act_budgets_rec.activity_budget_id: ' || l_act_budgets_rec.activity_budget_id);
3200:
3201: /*kdass 05-DEC-2005 bug 4662453 - Update_Act_Budgets is being called twice, so removing this one
3202: ozf_actbudgets_pvt.Update_Act_Budgets ( p_api_version => 1.0,
3203: p_init_msg_list => FND_API.g_false,
3204: p_commit => FND_API.g_false,
3205: p_validation_level => fnd_api.g_valid_level_full,
3206: x_return_status => l_return_status,

Line 3221: ozf_actbudgets_pvt.Update_Act_Budgets ( p_api_version => 1.0,

3217: */
3218:
3219: END IF; -- end of validation fail
3220:
3221: ozf_actbudgets_pvt.Update_Act_Budgets ( p_api_version => 1.0,
3222: p_init_msg_list => FND_API.g_false,
3223: p_commit => FND_API.g_false,
3224: p_validation_level => fnd_api.g_valid_level_full,
3225: x_return_status => l_return_status,

Line 3461: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type ;

3457: FROM ozf_offers
3458: WHERE qp_list_header_id = p_object_id;
3459:
3460: l_act_budget_id NUMBER;
3461: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type ;
3462: l_check_validation VARCHAR2(50) := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');
3463: l_request_id NUMBER;
3464: l_status_code VARCHAR2(50):= 'APPROVED';
3465: l_total_budget NUMBER;

Line 3534: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budgets_rec);

3530: IF l_status_code <> 'NEW' THEN
3531:
3532: FOR actbudget_rec IN c_act_budgets(p_object_type,p_object_id)
3533: LOOP
3534: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budgets_rec);
3535: l_act_budgets_rec.activity_budget_id := actbudget_rec.activity_budget_id;
3536:
3537: l_act_budgets_rec.status_code := 'APPROVED'; -- will changed to "PENDING_VALIDATION" by api.
3538: l_act_budgets_rec.user_status_id :=

Line 3541: ozf_actbudgets_pvt.update_act_budgets (

3537: l_act_budgets_rec.status_code := 'APPROVED'; -- will changed to "PENDING_VALIDATION" by api.
3538: l_act_budgets_rec.user_status_id :=
3539: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);
3540:
3541: ozf_actbudgets_pvt.update_act_budgets (
3542: p_api_version=> 1.0
3543: ,p_init_msg_list=> fnd_api.g_false
3544: ,p_commit=> fnd_api.g_false
3545: ,p_validation_level=> fnd_api.g_valid_level_full