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.

[Home] [Help]

APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on FND_GLOBAL

Line 424: FND_DSQL.add_text('SELECT SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

420: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
421: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,marketing_medium_id,start_date,end_date,');
422: FND_DSQL.add_text('party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');
423: FND_DSQL.add_text('qualifier_attribute,qualifier_context) ');
424: FND_DSQL.add_text('SELECT SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
425: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,NULL,');
426: FND_DSQL.add_bind(p_offer_id);
427: FND_DSQL.add_text(',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL');
428: FND_DSQL.add_text(',party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code, ');

Line 425: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,NULL,');

421: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,marketing_medium_id,start_date,end_date,');
422: FND_DSQL.add_text('party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code,');
423: FND_DSQL.add_text('qualifier_attribute,qualifier_context) ');
424: FND_DSQL.add_text('SELECT SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
425: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,NULL,');
426: FND_DSQL.add_bind(p_offer_id);
427: FND_DSQL.add_text(',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL');
428: FND_DSQL.add_text(',party_id,cust_account_id,cust_acct_site_id,site_use_id,site_use_code, ');
429: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''QUALIFIER_ATTRIBUTE14'',''SHIP_TO'',''QUALIFIER_ATTRIBUTE11'',substr(site_use_code,INSTR(site_use_code,'':'')+1)) qualifier_attribute,');

Line 2802: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

2798: --nirprasa,12.2 ER 8399135.
2799: --l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
2800: l_act_budgets_rec.approved_in_currency := l_act_budgets_rec.request_currency;
2801: l_act_budgets_rec.approval_date := l_sysdate;--nepanda : fix for bug 8766564
2802: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
2803: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(l_sysdate, 'MM/DD/YYYY');
2804: l_act_budgets_rec.transfer_type := 'UTILIZED';
2805: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
2806:

Line 2932: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

2928: l_act_budgets_rec.status_code := 'APPROVED';
2929: l_act_budgets_rec.approved_amount := l_accrual_amount;
2930: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
2931: l_act_budgets_rec.approval_date := l_sysdate;--nepanda : fix for bug 8766564
2932: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
2933: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(l_sysdate, 'MM/DD/YYYY');
2934: l_act_budgets_rec.transfer_type := 'UTILIZED';
2935: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
2936:

Line 3231: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

3227: l_act_budgets_rec.approved_amount := l_ar_dedu_line_amt;
3228: --nirprasa,12.2 ER 8399135.l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
3229: l_act_budgets_rec.approved_in_currency := l_act_budgets_rec.request_currency;
3230: l_act_budgets_rec.approval_date := l_sysdate;--nepanda : fix for bug 8766564
3231: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
3232: l_act_budgets_rec.justification := 'NA: AR DEDUCTION' || TO_CHAR(l_sysdate, 'MM/DD/YYYY');
3233: l_act_budgets_rec.transfer_type := 'UTILIZED';
3234: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
3235:

Line 3320: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

3316: l_act_budgets_rec.status_code := 'APPROVED';
3317: l_act_budgets_rec.approved_amount := l_ar_dedu_amount;
3318: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
3319: l_act_budgets_rec.approval_date := l_sysdate;--nepanda : fix for bug 8766564
3320: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
3321: l_act_budgets_rec.justification := 'NA: AR DEDUCTION' || TO_CHAR(l_sysdate, 'MM/DD/YYYY');
3322: l_act_budgets_rec.transfer_type := 'UTILIZED';
3323: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
3324:

Line 3605: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

3601: l_act_budgets_rec.approved_amount := l_om_dedu_line_amt;
3602: --nirprasa,12.2 ER 8399135. l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
3603: l_act_budgets_rec.approved_in_currency := l_act_budgets_rec.request_currency;
3604: l_act_budgets_rec.approval_date := l_sysdate;--nepanda : fix for bug 8766564
3605: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
3606: l_act_budgets_rec.justification := 'NA: OM Deduction' || TO_CHAR(l_sysdate, 'MON-DD-YYYY');
3607: l_act_budgets_rec.transfer_type := 'UTILIZED';
3608: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
3609:

Line 3696: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

3692: l_act_budgets_rec.status_code := 'APPROVED';
3693: l_act_budgets_rec.approved_amount := l_om_dedu_amount;
3694: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
3695: l_act_budgets_rec.approval_date := l_sysdate;--nepanda : fix for bug 8766564
3696: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
3697: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(l_sysdate, 'MON-DD-YYYY');
3698: l_act_budgets_rec.transfer_type := 'UTILIZED';
3699: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
3700:

Line 4026: l_act_budgets_rec_tbl(l_index).approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

4022: l_act_budgets_rec_tbl(l_index).status_code := 'APPROVED';
4023: l_act_budgets_rec_tbl(l_index).approved_amount := -1 * l_tm_dedu_amount;
4024: l_act_budgets_rec_tbl(l_index).approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
4025: l_act_budgets_rec_tbl(l_index).approval_date := l_sysdate;--nepanda : fix for bug 8766564
4026: l_act_budgets_rec_tbl(l_index).approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
4027: l_act_budgets_rec_tbl(l_index).justification := 'NA: TM DEDUCTION' || TO_CHAR(l_sysdate, 'MON-DD-YYYY');
4028: l_act_budgets_rec_tbl(l_index).transfer_type := 'UTILIZED';
4029: l_act_budgets_rec_tbl(l_index).requester_id := l_net_accrual_offers.owner_id;
4030: IF l_net_accrual_offers.orig_org_id IS NULL THEN

Line 4459: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

4455: l_act_budgets_rec.status_code := 'APPROVED';
4456: l_act_budgets_rec.approved_amount := l_line_acc_amount;
4457: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
4458: l_act_budgets_rec.approval_date := l_sysdate;--nepanda : fix for bug 8766564
4459: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
4460: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(l_sysdate, 'MM/DD/YYYY');
4461: l_act_budgets_rec.transfer_type := 'UTILIZED';
4462: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
4463:

Line 4567: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

4563: l_act_budgets_rec.status_code := 'APPROVED';
4564: l_act_budgets_rec.approved_amount := l_accrual_amount;
4565: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
4566: l_act_budgets_rec.approval_date := l_sysdate;--nepanda : fix for bug 8766564
4567: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
4568: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(l_sysdate, 'MM/DD/YYYY');
4569: l_act_budgets_rec.transfer_type := 'UTILIZED';
4570: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
4571: