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 153: l_act_budget_rec OZF_ActBudgets_PVT.Act_Budgets_Rec_Type;

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

Line 223: OZF_ActBudgets_PVT.Init_Act_Budgets_Rec (l_act_budget_rec);

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

Line 229: OZF_ActBudgets_PVT.Update_Act_Budgets (

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

Line 273: l_act_budgets_rec OZF_ActBudgets_PVT.Act_Budgets_Rec_Type;

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

Line 275: OZF_ActBudgets_PVT.Init_Act_Budgets_Rec (l_act_budgets_rec);

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

Line 285: OZF_ActBudgets_PVT.Update_Act_Budgets (

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

Line 321: l_act_budgets_rec OZF_ActBudgets_PVT.Act_Budgets_Rec_Type;

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

Line 346: OZF_ActBudgets_PVT.Init_Act_Budgets_Rec (l_act_budgets_rec);

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

Line 354: OZF_ActBudgets_PVT.Update_Act_Budgets (

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

Line 396: p_act_budget_rec IN OZF_ACTBUDGETS_PVT.Act_Budgets_Rec_Type,

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

Line 527: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

523: x_msg_count OUT NOCOPY NUMBER,
524: x_msg_data OUT NOCOPY VARCHAR2)
525: IS
526:
527: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
528: l_fund_rec ozf_funds_pvt.fund_rec_type;
529: l_activity_budget_id NUMBER;
530: l_budget_source_id NUMBER;
531: l_committed_amt NUMBER;

Line 605: ozf_actbudgets_pvt.update_act_budgets ( p_api_version => 1.0

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

Line 2936: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type ;

2932: l_new_status_id NUMBER;
2933: l_return_status VARCHAR2(30);
2934: l_msg_count NUMBER;
2935: l_msg_data VARCHAR2(2048);
2936: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type ;
2937: l_offer_status VARCHAR2(30) := 'ACTIVE';
2938: l_strSubject VARCHAR2(300);
2939: l_strBody VARCHAR2(2000);
2940: l_owner_id NUMBER;

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

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

Line 3012: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budgets_rec);

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

Line 3095: ozf_actbudgets_pvt.Update_Act_Budgets (

3091: END IF;
3092:
3093: END IF; -- end of validation fail.
3094:
3095: ozf_actbudgets_pvt.Update_Act_Budgets (
3096: p_api_version => 1.0,
3097: p_init_msg_list => FND_API.g_false,
3098: p_commit => FND_API.g_false,
3099: p_validation_level => fnd_api.g_valid_level_full,

Line 3124: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budgets_rec);

3120: x_return_status => l_return_status,
3121: x_msg_count => l_msg_count,
3122: x_msg_data => l_msg_data);
3123:
3124: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budgets_rec);
3125: l_act_budgets_rec.activity_budget_id := request_rec.activity_budget_id;
3126:
3127: ozf_utility_pvt.Write_Conc_log('Validation return status = ' || l_return_status);
3128:

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

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

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

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

Line 3465: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type ;

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

Line 3538: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budgets_rec);

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

Line 3545: ozf_actbudgets_pvt.update_act_budgets (

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