DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETS_PVT dependencies on FND_GLOBAL

Line 536: l_act_budgets_rec.approver_id := ams_utility_pvt.get_resource_id (fnd_global.user_id);

532: END IF;
533:
534: IF l_act_budgets_rec.approver_id IS NULL OR
535: l_act_budgets_rec.approver_id = fnd_api.g_miss_num THEN
536: l_act_budgets_rec.approver_id := ams_utility_pvt.get_resource_id (fnd_global.user_id);
537: END IF;
538:
539: IF l_act_budgets_rec.approved_amount IS NULL OR
540: l_act_budgets_rec.approved_amount = fnd_api.g_miss_num THEN

Line 883: SYSDATE, fnd_global.user_id, SYSDATE

879: ,approved_amount_fc
880: ,src_curr_request_amt
881: )
882: VALUES (l_act_budgets_rec.activity_budget_id, -- standard who columns
883: SYSDATE, fnd_global.user_id, SYSDATE
884: ,fnd_global.user_id, fnd_global.conc_login_id, 1
885: , -- object_version_number
886: l_act_budgets_rec.act_budget_used_by_id
887: ,l_act_budgets_rec.arc_act_budget_used_by, l_act_budgets_rec.budget_source_type

Line 884: ,fnd_global.user_id, fnd_global.conc_login_id, 1

880: ,src_curr_request_amt
881: )
882: VALUES (l_act_budgets_rec.activity_budget_id, -- standard who columns
883: SYSDATE, fnd_global.user_id, SYSDATE
884: ,fnd_global.user_id, fnd_global.conc_login_id, 1
885: , -- object_version_number
886: l_act_budgets_rec.act_budget_used_by_id
887: ,l_act_budgets_rec.arc_act_budget_used_by, l_act_budgets_rec.budget_source_type
888: ,l_act_budgets_rec.budget_source_id, l_act_budgets_rec.transaction_type

Line 903: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)

899: ,l_act_budgets_rec.parent_act_budget_id, l_act_budgets_rec.contact_id
900: ,l_act_budgets_rec.reason_code, l_act_budgets_rec.transfer_type
901: ,NVL (
902: l_act_budgets_rec.requester_id
903: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
904: ) --l_act_budgets_rec.requester_id
905: ,l_act_budgets_rec.date_required_by
906: ,null --l_act_budgets_rec.parent_source_id
907: ,l_act_budgets_rec.parent_src_curr

Line 937: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)

933: ,p_note=> l_act_budgets_rec.justification
934: ,p_note_type=> 'AMS_JUSTIFICATION'
935: ,p_user=> NVL (
936: l_act_budgets_rec.requester_id
937: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
938: )
939: ,x_msg_count=> x_msg_count
940: ,x_msg_data=> x_msg_data
941: ,x_return_status=> l_return_status

Line 2262: ,last_updated_by = fnd_global.user_id

2258:
2259: -- Perform the database operation
2260: UPDATE ozf_act_budgets
2261: SET last_update_date = SYSDATE
2262: ,last_updated_by = fnd_global.user_id
2263: ,last_update_login = fnd_global.conc_login_id
2264: ,object_version_number = l_act_budgets_rec.object_version_number
2265: + 1
2266: ,act_budget_used_by_id = l_act_budgets_rec.act_budget_used_by_id

Line 2263: ,last_update_login = fnd_global.conc_login_id

2259: -- Perform the database operation
2260: UPDATE ozf_act_budgets
2261: SET last_update_date = SYSDATE
2262: ,last_updated_by = fnd_global.user_id
2263: ,last_update_login = fnd_global.conc_login_id
2264: ,object_version_number = l_act_budgets_rec.object_version_number
2265: + 1
2266: ,act_budget_used_by_id = l_act_budgets_rec.act_budget_used_by_id
2267: ,arc_act_budget_used_by = l_act_budgets_rec.arc_act_budget_used_by

Line 2293: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)

2289: ,parent_act_budget_id = l_act_budgets_rec.parent_act_budget_id
2290: ,contact_id = l_act_budgets_rec.contact_id
2291: ,requester_id = NVL (
2292: l_act_budgets_rec.requester_id
2293: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
2294: ) --l_act_budgets_rec.requester_id
2295: ,date_required_by = l_act_budgets_rec.date_required_by
2296: ,parent_source_id = l_act_budgets_rec.parent_source_id,
2297: parent_src_curr = l_act_budgets_rec.parent_src_curr,

Line 2372: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)

2368: ,p_note=> l_act_budgets_rec.COMMENT
2369: ,p_note_type=> 'AMS_COMMENT'
2370: ,p_user=> NVL (
2371: l_act_budgets_rec.requester_id
2372: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
2373: )
2374: ,x_msg_count=> x_msg_count
2375: ,x_msg_data=> x_msg_data
2376: ,x_return_status=> l_return_status

Line 2393: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)

2389: ,p_note=> l_act_budgets_rec.justification
2390: ,p_note_type=> 'AMS_JUSTIFICATION'
2391: ,p_user=> NVL (
2392: l_act_budgets_rec.requester_id
2393: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
2394: )
2395: ,x_msg_count=> x_msg_count
2396: ,x_msg_data=> x_msg_data
2397: ,x_return_status=> l_return_status

Line 4264: ,p_user_id=> ozf_utility_pvt.get_resource_id (fnd_global.user_id)

4260: ,p_validation_level=> fnd_api.g_valid_level_full
4261: ,x_return_status=> l_return_status
4262: ,x_msg_data=> x_msg_data
4263: ,x_msg_count=> x_msg_count
4264: ,p_user_id=> ozf_utility_pvt.get_resource_id (fnd_global.user_id)
4265: ,p_act_budget_id=> p_act_budget_rec.activity_budget_id
4266: ,p_orig_status_id=> l_orig_status
4267: ,p_new_status_id=> l_new_status
4268: ,p_rejected_status_id=> l_reject_status

Line 5635: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

5631: 'OZF_BUDGETSOURCE_STATUS'
5632: ,l_act_budgets_rec.status_code
5633: );
5634: l_act_budgets_rec.approval_date := SYSDATE;
5635: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
5636: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
5637:
5638: ozf_actbudgets_pvt.create_act_budgets (
5639: p_api_version=> l_api_version

Line 5636: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

5632: ,l_act_budgets_rec.status_code
5633: );
5634: l_act_budgets_rec.approval_date := SYSDATE;
5635: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
5636: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
5637:
5638: ozf_actbudgets_pvt.create_act_budgets (
5639: p_api_version=> l_api_version
5640: ,x_return_status=> l_return_status

Line 6086: last_updated_by = Fnd_Global.User_ID,

6082:
6083: UPDATE ozf_object_fund_summary
6084: SET object_version_number= object_version_number + 1,
6085: last_update_date = SYSDATE,
6086: last_updated_by = Fnd_Global.User_ID,
6087: last_update_login = Fnd_Global.Conc_Login_ID,
6088: fund_id = l_objfundsum_rec.fund_id,
6089: fund_currency = l_objfundsum_rec.fund_currency,
6090: object_type = l_objfundsum_rec.object_type,

Line 6087: last_update_login = Fnd_Global.Conc_Login_ID,

6083: UPDATE ozf_object_fund_summary
6084: SET object_version_number= object_version_number + 1,
6085: last_update_date = SYSDATE,
6086: last_updated_by = Fnd_Global.User_ID,
6087: last_update_login = Fnd_Global.Conc_Login_ID,
6088: fund_id = l_objfundsum_rec.fund_id,
6089: fund_currency = l_objfundsum_rec.fund_currency,
6090: object_type = l_objfundsum_rec.object_type,
6091: object_id = l_objfundsum_rec.object_id,