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_ACCRUAL_ENGINE dependencies on FND_GLOBAL

Line 562: l_requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

558: OPEN c_act_budget_id;
559: FETCH c_act_budget_id INTO l_act_budgets_rec.activity_budget_id;
560: CLOSE c_act_budget_id;
561:
562: l_requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
563:
564: INSERT INTO ozf_act_budgets
565: (activity_budget_id,last_update_date
566: ,last_updated_by, creation_date

Line 598: ,fnd_global.user_id, SYSDATE

594: ,approved_amount_fc
595: ,src_curr_request_amt
596: )
597: VALUES (l_act_budgets_rec.activity_budget_id,SYSDATE
598: ,fnd_global.user_id, SYSDATE
599: ,fnd_global.user_id, fnd_global.conc_login_id
600: ,1, l_act_budgets_rec.act_budget_used_by_id
601: ,l_act_budgets_rec.arc_act_budget_used_by, l_act_budgets_rec.budget_source_type
602: ,l_act_budgets_rec.budget_source_id, l_act_budgets_rec.transaction_type

Line 599: ,fnd_global.user_id, fnd_global.conc_login_id

595: ,src_curr_request_amt
596: )
597: VALUES (l_act_budgets_rec.activity_budget_id,SYSDATE
598: ,fnd_global.user_id, SYSDATE
599: ,fnd_global.user_id, fnd_global.conc_login_id
600: ,1, l_act_budgets_rec.act_budget_used_by_id
601: ,l_act_budgets_rec.arc_act_budget_used_by, l_act_budgets_rec.budget_source_type
602: ,l_act_budgets_rec.budget_source_id, l_act_budgets_rec.transaction_type
603: ,l_act_budgets_rec.request_amount, l_act_budgets_rec.request_currency

Line 1365: ,NVL (fnd_global.user_id, -1),NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN

1361: ,univ_curr_amount
1362: ,univ_curr_amount_remaining
1363: )
1364: VALUES (l_utilization_rec.utilization_id,SYSDATE -- LAST_UPDATE_DATE
1365: ,NVL (fnd_global.user_id, -1),NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1366: ,SYSDATE,NVL (fnd_global.user_id, -1) -- CREATED_BY
1367: ,l_utilization_rec.created_from,fnd_global.conc_request_id -- REQUEST_ID
1368: ,fnd_global.prog_appl_id,fnd_global.conc_program_id -- PROGRAM_ID
1369: ,SYSDATE,l_utilization_rec.utilization_type

Line 1366: ,SYSDATE,NVL (fnd_global.user_id, -1) -- CREATED_BY

1362: ,univ_curr_amount_remaining
1363: )
1364: VALUES (l_utilization_rec.utilization_id,SYSDATE -- LAST_UPDATE_DATE
1365: ,NVL (fnd_global.user_id, -1),NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1366: ,SYSDATE,NVL (fnd_global.user_id, -1) -- CREATED_BY
1367: ,l_utilization_rec.created_from,fnd_global.conc_request_id -- REQUEST_ID
1368: ,fnd_global.prog_appl_id,fnd_global.conc_program_id -- PROGRAM_ID
1369: ,SYSDATE,l_utilization_rec.utilization_type
1370: ,l_utilization_rec.fund_id,l_utilization_rec.plan_type

Line 1367: ,l_utilization_rec.created_from,fnd_global.conc_request_id -- REQUEST_ID

1363: )
1364: VALUES (l_utilization_rec.utilization_id,SYSDATE -- LAST_UPDATE_DATE
1365: ,NVL (fnd_global.user_id, -1),NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1366: ,SYSDATE,NVL (fnd_global.user_id, -1) -- CREATED_BY
1367: ,l_utilization_rec.created_from,fnd_global.conc_request_id -- REQUEST_ID
1368: ,fnd_global.prog_appl_id,fnd_global.conc_program_id -- PROGRAM_ID
1369: ,SYSDATE,l_utilization_rec.utilization_type
1370: ,l_utilization_rec.fund_id,l_utilization_rec.plan_type
1371: ,l_utilization_rec.plan_id,l_utilization_rec.component_type

Line 1368: ,fnd_global.prog_appl_id,fnd_global.conc_program_id -- PROGRAM_ID

1364: VALUES (l_utilization_rec.utilization_id,SYSDATE -- LAST_UPDATE_DATE
1365: ,NVL (fnd_global.user_id, -1),NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1366: ,SYSDATE,NVL (fnd_global.user_id, -1) -- CREATED_BY
1367: ,l_utilization_rec.created_from,fnd_global.conc_request_id -- REQUEST_ID
1368: ,fnd_global.prog_appl_id,fnd_global.conc_program_id -- PROGRAM_ID
1369: ,SYSDATE,l_utilization_rec.utilization_type
1370: ,l_utilization_rec.fund_id,l_utilization_rec.plan_type
1371: ,l_utilization_rec.plan_id,l_utilization_rec.component_type
1372: ,l_utilization_rec.component_id,l_utilization_rec.object_type

Line 1427: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY

1423: ,org_id
1424: )
1425: SELECT l_utilization_rec.utilization_id
1426: ,SYSDATE -- LAST_UPDATE_DATE
1427: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1428: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1429: ,SYSDATE -- CREATION_DATE
1430: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1431: ,l_utilization_rec.created_from -- CREATED_FROM

Line 1428: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN

1424: )
1425: SELECT l_utilization_rec.utilization_id
1426: ,SYSDATE -- LAST_UPDATE_DATE
1427: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1428: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1429: ,SYSDATE -- CREATION_DATE
1430: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1431: ,l_utilization_rec.created_from -- CREATED_FROM
1432: ,fnd_global.conc_request_id -- REQUEST_ID

Line 1430: ,NVL (fnd_global.user_id, -1) -- CREATED_BY

1426: ,SYSDATE -- LAST_UPDATE_DATE
1427: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1428: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1429: ,SYSDATE -- CREATION_DATE
1430: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1431: ,l_utilization_rec.created_from -- CREATED_FROM
1432: ,fnd_global.conc_request_id -- REQUEST_ID
1433: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1434: ,fnd_global.conc_program_id -- PROGRAM_ID

Line 1432: ,fnd_global.conc_request_id -- REQUEST_ID

1428: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1429: ,SYSDATE -- CREATION_DATE
1430: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1431: ,l_utilization_rec.created_from -- CREATED_FROM
1432: ,fnd_global.conc_request_id -- REQUEST_ID
1433: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1434: ,fnd_global.conc_program_id -- PROGRAM_ID
1435: ,SYSDATE -- PROGRAM_UPDATE_DATE
1436: ,l_utilization_rec.adjustment_desc -- ADJUSTMENT_DESCRIPTION

Line 1433: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID

1429: ,SYSDATE -- CREATION_DATE
1430: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1431: ,l_utilization_rec.created_from -- CREATED_FROM
1432: ,fnd_global.conc_request_id -- REQUEST_ID
1433: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1434: ,fnd_global.conc_program_id -- PROGRAM_ID
1435: ,SYSDATE -- PROGRAM_UPDATE_DATE
1436: ,l_utilization_rec.adjustment_desc -- ADJUSTMENT_DESCRIPTION
1437: ,USERENV ('LANG') -- SOURCE_LANGUAGE

Line 1434: ,fnd_global.conc_program_id -- PROGRAM_ID

1430: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1431: ,l_utilization_rec.created_from -- CREATED_FROM
1432: ,fnd_global.conc_request_id -- REQUEST_ID
1433: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1434: ,fnd_global.conc_program_id -- PROGRAM_ID
1435: ,SYSDATE -- PROGRAM_UPDATE_DATE
1436: ,l_utilization_rec.adjustment_desc -- ADJUSTMENT_DESCRIPTION
1437: ,USERENV ('LANG') -- SOURCE_LANGUAGE
1438: ,l.language_code -- LANGUAGE

Line 1558: , last_updated_by = NVL (fnd_global.user_id, -1)

1554: , approved_amount = NVL(approved_amount, 0) + l_utilization_rec.plan_curr_amount
1555: , approved_original_amount = NVL(approved_original_amount, 0) + l_utilization_rec.amount
1556: , approved_amount_fc = NVL(approved_amount_fc, 0) + l_utilization_rec.acctd_amount
1557: , last_update_date = sysdate
1558: , last_updated_by = NVL (fnd_global.user_id, -1)
1559: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1560: , object_version_number = l_act_budget_objver + 1
1561: WHERE activity_budget_id = l_act_budget_id
1562: AND object_version_number = l_act_budget_objver;

Line 1559: , last_update_login = NVL (fnd_global.conc_login_id, -1)

1555: , approved_original_amount = NVL(approved_original_amount, 0) + l_utilization_rec.amount
1556: , approved_amount_fc = NVL(approved_amount_fc, 0) + l_utilization_rec.acctd_amount
1557: , last_update_date = sysdate
1558: , last_updated_by = NVL (fnd_global.user_id, -1)
1559: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1560: , object_version_number = l_act_budget_objver + 1
1561: WHERE activity_budget_id = l_act_budget_id
1562: AND object_version_number = l_act_budget_objver;
1563:

Line 1586: , last_updated_by = NVL (fnd_global.user_id, -1)

1582: , plan_curr_amount = NVL(plan_curr_amount,0) + NVL(l_utilization_rec.plan_curr_amount,0)
1583: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_utilization_rec.univ_curr_amount, 0)
1584: , acctd_amount = NVL(acctd_amount,0) + NVL(l_utilization_rec.acctd_amount,0)
1585: , last_update_date = sysdate
1586: , last_updated_by = NVL (fnd_global.user_id, -1)
1587: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1588: , object_version_number = l_act_budget_objver + 1
1589: WHERE utilization_id = l_act_budget_id
1590: AND object_version_number = l_act_budget_objver;*/

Line 1587: , last_update_login = NVL (fnd_global.conc_login_id, -1)

1583: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_utilization_rec.univ_curr_amount, 0)
1584: , acctd_amount = NVL(acctd_amount,0) + NVL(l_utilization_rec.acctd_amount,0)
1585: , last_update_date = sysdate
1586: , last_updated_by = NVL (fnd_global.user_id, -1)
1587: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1588: , object_version_number = l_act_budget_objver + 1
1589: WHERE utilization_id = l_act_budget_id
1590: AND object_version_number = l_act_budget_objver;*/
1591: -- yzhao: 10/14/2003 END Fix TEVA bug - customer fully accrual budget committed amount is always 0

Line 4743: , last_updated_by = NVL (fnd_global.user_id, -1)

4739:
4740: -- update utilization gl_posted_flag directly to avoid all validations
4741: UPDATE ozf_funds_utilized_all_b
4742: SET last_update_date = SYSDATE
4743: , last_updated_by = NVL (fnd_global.user_id, -1)
4744: , last_update_login = NVL (fnd_global.conc_login_id, -1)
4745: , object_version_number = p_util_object_version_number + 1
4746: , gl_posted_flag = l_gl_posted_flag
4747: --, gl_date = sysdate

Line 4744: , last_update_login = NVL (fnd_global.conc_login_id, -1)

4740: -- update utilization gl_posted_flag directly to avoid all validations
4741: UPDATE ozf_funds_utilized_all_b
4742: SET last_update_date = SYSDATE
4743: , last_updated_by = NVL (fnd_global.user_id, -1)
4744: , last_update_login = NVL (fnd_global.conc_login_id, -1)
4745: , object_version_number = p_util_object_version_number + 1
4746: , gl_posted_flag = l_gl_posted_flag
4747: --, gl_date = sysdate
4748: WHERE utilization_id = p_util_utilization_id