DBA Data[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 2167: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

2163: l_act_budgets_rec.status_code := 'APPROVED';
2164: l_act_budgets_rec.approved_amount := l_line_acc_amount;
2165: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
2166: l_act_budgets_rec.approval_date := SYSDATE;
2167: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
2168: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY');
2169: l_act_budgets_rec.transfer_type := 'UTILIZED';
2170: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
2171:

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

2269: l_act_budgets_rec.status_code := 'APPROVED';
2270: l_act_budgets_rec.approved_amount := l_accrual_amount;
2271: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
2272: l_act_budgets_rec.approval_date := SYSDATE;
2273: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
2274: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY');
2275: l_act_budgets_rec.transfer_type := 'UTILIZED';
2276: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
2277:

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

2505: l_act_budgets_rec.status_code := 'APPROVED';
2506: l_act_budgets_rec.approved_amount := l_ar_dedu_line_amt;
2507: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
2508: l_act_budgets_rec.approval_date := SYSDATE;
2509: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
2510: l_act_budgets_rec.justification := 'NA: AR DEDUCTION' || TO_CHAR(SYSDATE, 'MM/DD/YYYY');
2511: l_act_budgets_rec.transfer_type := 'UTILIZED';
2512: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
2513:

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

2588: l_act_budgets_rec.status_code := 'APPROVED';
2589: l_act_budgets_rec.approved_amount := l_ar_dedu_amount;
2590: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
2591: l_act_budgets_rec.approval_date := SYSDATE;
2592: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
2593: l_act_budgets_rec.justification := 'NA: AR DEDUCTION' || TO_CHAR(SYSDATE, 'MM/DD/YYYY');
2594: l_act_budgets_rec.transfer_type := 'UTILIZED';
2595: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
2596:

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

2813: l_act_budgets_rec.status_code := 'APPROVED';
2814: l_act_budgets_rec.approved_amount := l_om_dedu_line_amt;
2815: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
2816: l_act_budgets_rec.approval_date := SYSDATE;
2817: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
2818: l_act_budgets_rec.justification := 'NA: OM Deduction' || TO_CHAR(SYSDATE, 'MON-DD-YYYY');
2819: l_act_budgets_rec.transfer_type := 'UTILIZED';
2820: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
2821:

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

2899: l_act_budgets_rec.status_code := 'APPROVED';
2900: l_act_budgets_rec.approved_amount := l_om_dedu_amount;
2901: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
2902: l_act_budgets_rec.approval_date := SYSDATE;
2903: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
2904: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(SYSDATE, 'MON-DD-YYYY');
2905: l_act_budgets_rec.transfer_type := 'UTILIZED';
2906: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
2907:

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

3024: l_act_budgets_rec.status_code := 'APPROVED';
3025: l_act_budgets_rec.approved_amount := -1 * l_tm_dedu_amount;
3026: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
3027: l_act_budgets_rec.approval_date := SYSDATE;
3028: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
3029: l_act_budgets_rec.justification := 'NA: TM DEDUCTION' || TO_CHAR(SYSDATE, 'MON-DD-YYYY');
3030: l_act_budgets_rec.transfer_type := 'UTILIZED';
3031: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
3032:

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

3326: l_act_budgets_rec.status_code := 'APPROVED';
3327: l_act_budgets_rec.approved_amount := l_line_acc_amount;
3328: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
3329: l_act_budgets_rec.approval_date := SYSDATE;
3330: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
3331: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY');
3332: l_act_budgets_rec.transfer_type := 'UTILIZED';
3333: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
3334:

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

3432: l_act_budgets_rec.status_code := 'APPROVED';
3433: l_act_budgets_rec.approved_amount := l_accrual_amount;
3434: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
3435: l_act_budgets_rec.approval_date := SYSDATE;
3436: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
3437: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY');
3438: l_act_budgets_rec.transfer_type := 'UTILIZED';
3439: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
3440: