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

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

966: , approved_amount = NVL(approved_amount, 0) + l_plan_curr_amount
967: , approved_original_amount = NVL(approved_original_amount, 0) + l_utilization_rec.amount
968: , approved_amount_fc = NVL(approved_amount_fc, 0) + l_utilization_rec.acctd_amount
969: , last_update_date = sysdate
970: , last_updated_by = NVL (fnd_global.user_id, -1)
971: , last_update_login = NVL (fnd_global.conc_login_id, -1)
972: , object_version_number = l_act_budget_objver + 1
973: WHERE activity_budget_id = l_act_budget_id
974: AND object_version_number = l_act_budget_objver;

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

967: , approved_original_amount = NVL(approved_original_amount, 0) + l_utilization_rec.amount
968: , approved_amount_fc = NVL(approved_amount_fc, 0) + l_utilization_rec.acctd_amount
969: , last_update_date = sysdate
970: , last_updated_by = NVL (fnd_global.user_id, -1)
971: , last_update_login = NVL (fnd_global.conc_login_id, -1)
972: , object_version_number = l_act_budget_objver + 1
973: WHERE activity_budget_id = l_act_budget_id
974: AND object_version_number = l_act_budget_objver;
975:

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

992: , plan_curr_amount = NVL(plan_curr_amount, 0) + NVL(l_plan_curr_amount, 0)
993: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_univ_curr_amount, 0)
994: , acctd_amount = NVL(acctd_amount, 0) + NVL(l_utilization_rec.acctd_amount, 0)
995: , last_update_date = sysdate
996: , last_updated_by = NVL (fnd_global.user_id, -1)
997: , last_update_login = NVL (fnd_global.conc_login_id, -1)
998: , object_version_number = l_act_budget_objver + 1
999: WHERE utilization_id = l_act_budget_id
1000: AND object_version_number = l_act_budget_objver;

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

993: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_univ_curr_amount, 0)
994: , acctd_amount = NVL(acctd_amount, 0) + NVL(l_utilization_rec.acctd_amount, 0)
995: , last_update_date = sysdate
996: , last_updated_by = NVL (fnd_global.user_id, -1)
997: , last_update_login = NVL (fnd_global.conc_login_id, -1)
998: , object_version_number = l_act_budget_objver + 1
999: WHERE utilization_id = l_act_budget_id
1000: AND object_version_number = l_act_budget_objver;
1001: yzhao END: 09/29/2005 R12 no TRANSFER/REQUEST in utilization table

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

1439: ,univ_curr_amount_remaining
1440: )
1441: VALUES (l_utilization_rec.utilization_id
1442: ,SYSDATE -- LAST_UPDATE_DATE
1443: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1444: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1445: ,SYSDATE -- CREATION_DATE
1446: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1447: ,l_utilization_rec.created_from -- CREATED_FROM

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

1440: )
1441: VALUES (l_utilization_rec.utilization_id
1442: ,SYSDATE -- LAST_UPDATE_DATE
1443: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1444: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1445: ,SYSDATE -- CREATION_DATE
1446: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1447: ,l_utilization_rec.created_from -- CREATED_FROM
1448: ,fnd_global.conc_request_id -- REQUEST_ID

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

1442: ,SYSDATE -- LAST_UPDATE_DATE
1443: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1444: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1445: ,SYSDATE -- CREATION_DATE
1446: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1447: ,l_utilization_rec.created_from -- CREATED_FROM
1448: ,fnd_global.conc_request_id -- REQUEST_ID
1449: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1450: ,fnd_global.conc_program_id -- PROGRAM_ID

Line 1448: ,fnd_global.conc_request_id -- REQUEST_ID

1444: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1445: ,SYSDATE -- CREATION_DATE
1446: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1447: ,l_utilization_rec.created_from -- CREATED_FROM
1448: ,fnd_global.conc_request_id -- REQUEST_ID
1449: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1450: ,fnd_global.conc_program_id -- PROGRAM_ID
1451: ,SYSDATE -- PROGRAM_UPDATE_DATE
1452: ,l_utilization_rec.utilization_type

Line 1449: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID

1445: ,SYSDATE -- CREATION_DATE
1446: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1447: ,l_utilization_rec.created_from -- CREATED_FROM
1448: ,fnd_global.conc_request_id -- REQUEST_ID
1449: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1450: ,fnd_global.conc_program_id -- PROGRAM_ID
1451: ,SYSDATE -- PROGRAM_UPDATE_DATE
1452: ,l_utilization_rec.utilization_type
1453: ,l_utilization_rec.fund_id

Line 1450: ,fnd_global.conc_program_id -- PROGRAM_ID

1446: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1447: ,l_utilization_rec.created_from -- CREATED_FROM
1448: ,fnd_global.conc_request_id -- REQUEST_ID
1449: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1450: ,fnd_global.conc_program_id -- PROGRAM_ID
1451: ,SYSDATE -- PROGRAM_UPDATE_DATE
1452: ,l_utilization_rec.utilization_type
1453: ,l_utilization_rec.fund_id
1454: ,l_utilization_rec.plan_type

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

1539: ,org_id
1540: )
1541: SELECT l_utilization_rec.utilization_id
1542: ,SYSDATE -- LAST_UPDATE_DATE
1543: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1544: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1545: ,SYSDATE -- CREATION_DATE
1546: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1547: ,l_utilization_rec.created_from -- CREATED_FROM

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

1540: )
1541: SELECT l_utilization_rec.utilization_id
1542: ,SYSDATE -- LAST_UPDATE_DATE
1543: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1544: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1545: ,SYSDATE -- CREATION_DATE
1546: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1547: ,l_utilization_rec.created_from -- CREATED_FROM
1548: ,fnd_global.conc_request_id -- REQUEST_ID

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

1542: ,SYSDATE -- LAST_UPDATE_DATE
1543: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1544: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1545: ,SYSDATE -- CREATION_DATE
1546: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1547: ,l_utilization_rec.created_from -- CREATED_FROM
1548: ,fnd_global.conc_request_id -- REQUEST_ID
1549: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1550: ,fnd_global.conc_program_id -- PROGRAM_ID

Line 1548: ,fnd_global.conc_request_id -- REQUEST_ID

1544: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1545: ,SYSDATE -- CREATION_DATE
1546: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1547: ,l_utilization_rec.created_from -- CREATED_FROM
1548: ,fnd_global.conc_request_id -- REQUEST_ID
1549: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1550: ,fnd_global.conc_program_id -- PROGRAM_ID
1551: ,SYSDATE -- PROGRAM_UPDATE_DATE
1552: ,l_utilization_rec.adjustment_desc -- ADJUSTMENT_DESCRIPTION

Line 1549: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID

1545: ,SYSDATE -- CREATION_DATE
1546: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1547: ,l_utilization_rec.created_from -- CREATED_FROM
1548: ,fnd_global.conc_request_id -- REQUEST_ID
1549: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1550: ,fnd_global.conc_program_id -- PROGRAM_ID
1551: ,SYSDATE -- PROGRAM_UPDATE_DATE
1552: ,l_utilization_rec.adjustment_desc -- ADJUSTMENT_DESCRIPTION
1553: ,USERENV ('LANG') -- SOURCE_LANGUAGE

Line 1550: ,fnd_global.conc_program_id -- PROGRAM_ID

1546: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1547: ,l_utilization_rec.created_from -- CREATED_FROM
1548: ,fnd_global.conc_request_id -- REQUEST_ID
1549: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1550: ,fnd_global.conc_program_id -- PROGRAM_ID
1551: ,SYSDATE -- PROGRAM_UPDATE_DATE
1552: ,l_utilization_rec.adjustment_desc -- ADJUSTMENT_DESCRIPTION
1553: ,USERENV ('LANG') -- SOURCE_LANGUAGE
1554: ,l.language_code -- LANGUAGE

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

1682: END IF; -- END IF
1683:
1684: UPDATE ozf_funds_utilized_all_b
1685: SET last_update_date = SYSDATE
1686: , last_updated_by = NVL (fnd_global.user_id, -1)
1687: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1688: , gl_posted_flag = l_gl_posted_flag
1689: --, gl_date = sysdate
1690: WHERE utilization_id = l_utilization_rec.utilization_id

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

1683:
1684: UPDATE ozf_funds_utilized_all_b
1685: SET last_update_date = SYSDATE
1686: , last_updated_by = NVL (fnd_global.user_id, -1)
1687: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1688: , gl_posted_flag = l_gl_posted_flag
1689: --, gl_date = sysdate
1690: WHERE utilization_id = l_utilization_rec.utilization_id
1691: AND object_version_number = l_object_version_number;

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

2283: END IF;
2284:
2285: UPDATE ozf_funds_utilized_all_b
2286: SET last_update_date = SYSDATE
2287: ,last_updated_by = NVL (fnd_global.user_id, -1)
2288: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2289: ,created_from = l_utilization_rec.created_from
2290: ,request_id = fnd_global.conc_request_id
2291: ,program_application_id = fnd_global.prog_appl_id

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

2284:
2285: UPDATE ozf_funds_utilized_all_b
2286: SET last_update_date = SYSDATE
2287: ,last_updated_by = NVL (fnd_global.user_id, -1)
2288: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2289: ,created_from = l_utilization_rec.created_from
2290: ,request_id = fnd_global.conc_request_id
2291: ,program_application_id = fnd_global.prog_appl_id
2292: ,program_id = fnd_global.conc_program_id

Line 2290: ,request_id = fnd_global.conc_request_id

2286: SET last_update_date = SYSDATE
2287: ,last_updated_by = NVL (fnd_global.user_id, -1)
2288: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2289: ,created_from = l_utilization_rec.created_from
2290: ,request_id = fnd_global.conc_request_id
2291: ,program_application_id = fnd_global.prog_appl_id
2292: ,program_id = fnd_global.conc_program_id
2293: ,program_update_date = SYSDATE
2294: ,utilization_type = l_utilization_rec.utilization_type

Line 2291: ,program_application_id = fnd_global.prog_appl_id

2287: ,last_updated_by = NVL (fnd_global.user_id, -1)
2288: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2289: ,created_from = l_utilization_rec.created_from
2290: ,request_id = fnd_global.conc_request_id
2291: ,program_application_id = fnd_global.prog_appl_id
2292: ,program_id = fnd_global.conc_program_id
2293: ,program_update_date = SYSDATE
2294: ,utilization_type = l_utilization_rec.utilization_type
2295: ,fund_id = l_utilization_rec.fund_id

Line 2292: ,program_id = fnd_global.conc_program_id

2288: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2289: ,created_from = l_utilization_rec.created_from
2290: ,request_id = fnd_global.conc_request_id
2291: ,program_application_id = fnd_global.prog_appl_id
2292: ,program_id = fnd_global.conc_program_id
2293: ,program_update_date = SYSDATE
2294: ,utilization_type = l_utilization_rec.utilization_type
2295: ,fund_id = l_utilization_rec.fund_id
2296: ,plan_type = l_utilization_rec.plan_type

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

2370: END IF;
2371:
2372: UPDATE ozf_funds_utilized_all_tl
2373: SET last_update_date = SYSDATE
2374: ,last_updated_by = NVL (fnd_global.user_id, -1)
2375: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2376: ,created_from = l_utilization_rec.created_from
2377: ,request_id = fnd_global.conc_request_id
2378: ,program_application_id = fnd_global.prog_appl_id

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

2371:
2372: UPDATE ozf_funds_utilized_all_tl
2373: SET last_update_date = SYSDATE
2374: ,last_updated_by = NVL (fnd_global.user_id, -1)
2375: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2376: ,created_from = l_utilization_rec.created_from
2377: ,request_id = fnd_global.conc_request_id
2378: ,program_application_id = fnd_global.prog_appl_id
2379: ,program_id = fnd_global.conc_program_id

Line 2377: ,request_id = fnd_global.conc_request_id

2373: SET last_update_date = SYSDATE
2374: ,last_updated_by = NVL (fnd_global.user_id, -1)
2375: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2376: ,created_from = l_utilization_rec.created_from
2377: ,request_id = fnd_global.conc_request_id
2378: ,program_application_id = fnd_global.prog_appl_id
2379: ,program_id = fnd_global.conc_program_id
2380: ,program_update_date = SYSDATE
2381: ,adjustment_desc = l_utilization_rec.adjustment_desc

Line 2378: ,program_application_id = fnd_global.prog_appl_id

2374: ,last_updated_by = NVL (fnd_global.user_id, -1)
2375: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2376: ,created_from = l_utilization_rec.created_from
2377: ,request_id = fnd_global.conc_request_id
2378: ,program_application_id = fnd_global.prog_appl_id
2379: ,program_id = fnd_global.conc_program_id
2380: ,program_update_date = SYSDATE
2381: ,adjustment_desc = l_utilization_rec.adjustment_desc
2382: ,source_lang = USERENV ('LANG')

Line 2379: ,program_id = fnd_global.conc_program_id

2375: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2376: ,created_from = l_utilization_rec.created_from
2377: ,request_id = fnd_global.conc_request_id
2378: ,program_application_id = fnd_global.prog_appl_id
2379: ,program_id = fnd_global.conc_program_id
2380: ,program_update_date = SYSDATE
2381: ,adjustment_desc = l_utilization_rec.adjustment_desc
2382: ,source_lang = USERENV ('LANG')
2383: WHERE utilization_id = l_utilization_rec.utilization_id