DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETS_PVT dependencies on FND_GLOBAL

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

794: END IF;
795:
796: IF l_act_budgets_rec.approver_id IS NULL OR
797: l_act_budgets_rec.approver_id = fnd_api.g_miss_num THEN
798: l_act_budgets_rec.approver_id := ams_utility_pvt.get_resource_id (fnd_global.user_id);
799: END IF;
800:
801: IF l_act_budgets_rec.approved_amount IS NULL OR
802: l_act_budgets_rec.approved_amount = fnd_api.g_miss_num THEN

Line 1223: SYSDATE, fnd_global.user_id, SYSDATE

1219: ,approved_amount_fc
1220: ,src_curr_request_amt
1221: )
1222: VALUES (l_act_budgets_rec.activity_budget_id, -- standard who columns
1223: SYSDATE, fnd_global.user_id, SYSDATE
1224: ,fnd_global.user_id, fnd_global.conc_login_id, 1
1225: , -- object_version_number
1226: l_act_budgets_rec.act_budget_used_by_id
1227: ,l_act_budgets_rec.arc_act_budget_used_by, l_act_budgets_rec.budget_source_type

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

1220: ,src_curr_request_amt
1221: )
1222: VALUES (l_act_budgets_rec.activity_budget_id, -- standard who columns
1223: SYSDATE, fnd_global.user_id, SYSDATE
1224: ,fnd_global.user_id, fnd_global.conc_login_id, 1
1225: , -- object_version_number
1226: l_act_budgets_rec.act_budget_used_by_id
1227: ,l_act_budgets_rec.arc_act_budget_used_by, l_act_budgets_rec.budget_source_type
1228: ,l_act_budgets_rec.budget_source_id, l_act_budgets_rec.transaction_type

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

1239: ,l_act_budgets_rec.parent_act_budget_id, l_act_budgets_rec.contact_id
1240: ,l_act_budgets_rec.reason_code, l_act_budgets_rec.transfer_type
1241: ,NVL (
1242: l_act_budgets_rec.requester_id
1243: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
1244: ) --l_act_budgets_rec.requester_id
1245: ,l_act_budgets_rec.date_required_by
1246: ,null --l_act_budgets_rec.parent_source_id
1247: ,l_act_budgets_rec.parent_src_curr

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

1286: ,p_note=> l_act_budgets_rec.justification
1287: ,p_note_type=> 'AMS_JUSTIFICATION'
1288: ,p_user=> NVL (
1289: l_act_budgets_rec.requester_id
1290: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
1291: )
1292: ,x_msg_count=> x_msg_count
1293: ,x_msg_data=> x_msg_data
1294: ,x_return_status=> l_return_status

Line 2938: ,last_updated_by = fnd_global.user_id

2934:
2935: -- Perform the database operation
2936: UPDATE ozf_act_budgets
2937: SET last_update_date = SYSDATE
2938: ,last_updated_by = fnd_global.user_id
2939: ,last_update_login = fnd_global.conc_login_id
2940: ,object_version_number = l_act_budgets_rec.object_version_number
2941: + 1
2942: ,act_budget_used_by_id = l_act_budgets_rec.act_budget_used_by_id

Line 2939: ,last_update_login = fnd_global.conc_login_id

2935: -- Perform the database operation
2936: UPDATE ozf_act_budgets
2937: SET last_update_date = SYSDATE
2938: ,last_updated_by = fnd_global.user_id
2939: ,last_update_login = fnd_global.conc_login_id
2940: ,object_version_number = l_act_budgets_rec.object_version_number
2941: + 1
2942: ,act_budget_used_by_id = l_act_budgets_rec.act_budget_used_by_id
2943: ,arc_act_budget_used_by = l_act_budgets_rec.arc_act_budget_used_by

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

2965: ,parent_act_budget_id = l_act_budgets_rec.parent_act_budget_id
2966: ,contact_id = l_act_budgets_rec.contact_id
2967: ,requester_id = NVL (
2968: l_act_budgets_rec.requester_id
2969: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
2970: ) --l_act_budgets_rec.requester_id
2971: ,date_required_by = l_act_budgets_rec.date_required_by
2972: ,parent_source_id = l_act_budgets_rec.parent_source_id,
2973: parent_src_curr = l_act_budgets_rec.parent_src_curr,

Line 3079: l_request_id := fnd_global.conc_request_id;

3075: if l_act_budgets_rec.request_currency is not null then
3076: l_act_budgets_rec.request_amount := ozf_utility_pvt.currround(l_act_budgets_rec.request_amount, l_act_budgets_rec.request_currency);
3077: end if;
3078:
3079: l_request_id := fnd_global.conc_request_id;
3080: l_budget_count := 0;
3081: l_operation := 'INSERT';
3082:
3083: --13-DEC-2010 kdass - TPA Parallel Execution ER - 9614703

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

3170: ,p_note=> l_act_budgets_rec.COMMENT
3171: ,p_note_type=> 'AMS_COMMENT'
3172: ,p_user=> NVL (
3173: l_act_budgets_rec.requester_id
3174: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
3175: )
3176: ,x_msg_count=> x_msg_count
3177: ,x_msg_data=> x_msg_data
3178: ,x_return_status=> l_return_status

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

3191: ,p_note=> l_act_budgets_rec.justification
3192: ,p_note_type=> 'AMS_JUSTIFICATION'
3193: ,p_user=> NVL (
3194: l_act_budgets_rec.requester_id
3195: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
3196: )
3197: ,x_msg_count=> x_msg_count
3198: ,x_msg_data=> x_msg_data
3199: ,x_return_status=> l_return_status

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

5077: ,p_validation_level=> fnd_api.g_valid_level_full
5078: ,x_return_status=> l_return_status
5079: ,x_msg_data=> x_msg_data
5080: ,x_msg_count=> x_msg_count
5081: ,p_user_id=> ozf_utility_pvt.get_resource_id (fnd_global.user_id)
5082: ,p_act_budget_id=> p_act_budget_rec.activity_budget_id
5083: ,p_orig_status_id=> l_orig_status
5084: ,p_new_status_id=> l_new_status
5085: ,p_rejected_status_id=> l_reject_status

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

6649: 'OZF_BUDGETSOURCE_STATUS'
6650: ,l_act_budgets_rec.status_code
6651: );
6652: l_act_budgets_rec.approval_date := SYSDATE;
6653: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
6654: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
6655:
6656: ozf_actbudgets_pvt.create_act_budgets (
6657: p_api_version=> l_api_version

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

6650: ,l_act_budgets_rec.status_code
6651: );
6652: l_act_budgets_rec.approval_date := SYSDATE;
6653: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
6654: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
6655:
6656: ozf_actbudgets_pvt.create_act_budgets (
6657: p_api_version=> l_api_version
6658: ,x_return_status=> l_return_status

Line 7106: last_updated_by = Fnd_Global.User_ID,

7102:
7103: UPDATE ozf_object_fund_summary
7104: SET object_version_number= object_version_number + 1,
7105: last_update_date = SYSDATE,
7106: last_updated_by = Fnd_Global.User_ID,
7107: last_update_login = Fnd_Global.Conc_Login_ID,
7108: fund_id = l_objfundsum_rec.fund_id,
7109: fund_currency = l_objfundsum_rec.fund_currency,
7110: object_type = l_objfundsum_rec.object_type,

Line 7107: last_update_login = Fnd_Global.Conc_Login_ID,

7103: UPDATE ozf_object_fund_summary
7104: SET object_version_number= object_version_number + 1,
7105: last_update_date = SYSDATE,
7106: last_updated_by = Fnd_Global.User_ID,
7107: last_update_login = Fnd_Global.Conc_Login_ID,
7108: fund_id = l_objfundsum_rec.fund_id,
7109: fund_currency = l_objfundsum_rec.fund_currency,
7110: object_type = l_objfundsum_rec.object_type,
7111: object_id = l_objfundsum_rec.object_id,