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

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

720: )
721: VALUES(
722: l_fund_rec.fund_id
723: ,SYSDATE -- LAST_UPDATE_DATE
724: ,NVL(fnd_global.user_id, -1) -- LAST_UPDATED_BY
725: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
726: ,SYSDATE -- CREATION_DATE
727: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
728: ,NULL -- l_fund_rec.created_from -- CREATED_FROM -- we donot use this column

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

721: VALUES(
722: l_fund_rec.fund_id
723: ,SYSDATE -- LAST_UPDATE_DATE
724: ,NVL(fnd_global.user_id, -1) -- LAST_UPDATED_BY
725: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
726: ,SYSDATE -- CREATION_DATE
727: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
728: ,NULL -- l_fund_rec.created_from -- CREATED_FROM -- we donot use this column
729: ,fnd_global.conc_request_id -- REQUEST_ID

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

723: ,SYSDATE -- LAST_UPDATE_DATE
724: ,NVL(fnd_global.user_id, -1) -- LAST_UPDATED_BY
725: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
726: ,SYSDATE -- CREATION_DATE
727: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
728: ,NULL -- l_fund_rec.created_from -- CREATED_FROM -- we donot use this column
729: ,fnd_global.conc_request_id -- REQUEST_ID
730: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
731: ,fnd_global.conc_program_id -- PROGRAM_ID

Line 729: ,fnd_global.conc_request_id -- REQUEST_ID

725: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
726: ,SYSDATE -- CREATION_DATE
727: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
728: ,NULL -- l_fund_rec.created_from -- CREATED_FROM -- we donot use this column
729: ,fnd_global.conc_request_id -- REQUEST_ID
730: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
731: ,fnd_global.conc_program_id -- PROGRAM_ID
732: ,SYSDATE -- PROGRAM_UPDATE_DATE
733: ,l_fund_rec.fund_number

Line 730: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID

726: ,SYSDATE -- CREATION_DATE
727: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
728: ,NULL -- l_fund_rec.created_from -- CREATED_FROM -- we donot use this column
729: ,fnd_global.conc_request_id -- REQUEST_ID
730: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
731: ,fnd_global.conc_program_id -- PROGRAM_ID
732: ,SYSDATE -- PROGRAM_UPDATE_DATE
733: ,l_fund_rec.fund_number
734: ,l_fund_rec.parent_fund_id

Line 731: ,fnd_global.conc_program_id -- PROGRAM_ID

727: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
728: ,NULL -- l_fund_rec.created_from -- CREATED_FROM -- we donot use this column
729: ,fnd_global.conc_request_id -- REQUEST_ID
730: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
731: ,fnd_global.conc_program_id -- PROGRAM_ID
732: ,SYSDATE -- PROGRAM_UPDATE_DATE
733: ,l_fund_rec.fund_number
734: ,l_fund_rec.parent_fund_id
735: ,l_fund_rec.category_id

Line 760: ,NVL(l_fund_rec.owner, NVL(fnd_global.user_id, -1)) -- OWNER

756: ,l_fund_rec.exchange_rate_date
757: ,l_fund_rec.exchange_rate
758: ,l_fund_rec.department_id
759: ,l_fund_rec.costcentre_id
760: ,NVL(l_fund_rec.owner, NVL(fnd_global.user_id, -1)) -- OWNER
761: ,l_fund_rec.accrual_method
762: ,l_fund_rec.accrual_operand
763: ,l_fund_rec.accrual_rate
764: ,l_fund_rec.accrual_basis

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

848: language,
849: org_id )
850: SELECT l_fund_rec.fund_id
851: ,SYSDATE -- LAST_UPDATE_DATE
852: ,NVL(fnd_global.user_id, -1) -- LAST_UPDATED_BY
853: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
854: ,SYSDATE -- CREATION_DATE
855: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
856: ,NULL -- CREATED_FROM

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

849: org_id )
850: SELECT l_fund_rec.fund_id
851: ,SYSDATE -- LAST_UPDATE_DATE
852: ,NVL(fnd_global.user_id, -1) -- LAST_UPDATED_BY
853: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
854: ,SYSDATE -- CREATION_DATE
855: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
856: ,NULL -- CREATED_FROM
857: ,fnd_global.conc_request_id -- REQUEST_ID

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

851: ,SYSDATE -- LAST_UPDATE_DATE
852: ,NVL(fnd_global.user_id, -1) -- LAST_UPDATED_BY
853: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
854: ,SYSDATE -- CREATION_DATE
855: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
856: ,NULL -- CREATED_FROM
857: ,fnd_global.conc_request_id -- REQUEST_ID
858: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
859: ,fnd_global.conc_program_id -- PROGRAM_ID

Line 857: ,fnd_global.conc_request_id -- REQUEST_ID

853: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
854: ,SYSDATE -- CREATION_DATE
855: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
856: ,NULL -- CREATED_FROM
857: ,fnd_global.conc_request_id -- REQUEST_ID
858: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
859: ,fnd_global.conc_program_id -- PROGRAM_ID
860: ,SYSDATE -- PROGRAM_UPDATE_DATE
861: ,l_fund_rec.short_name

Line 858: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID

854: ,SYSDATE -- CREATION_DATE
855: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
856: ,NULL -- CREATED_FROM
857: ,fnd_global.conc_request_id -- REQUEST_ID
858: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
859: ,fnd_global.conc_program_id -- PROGRAM_ID
860: ,SYSDATE -- PROGRAM_UPDATE_DATE
861: ,l_fund_rec.short_name
862: ,l_fund_rec.description

Line 859: ,fnd_global.conc_program_id -- PROGRAM_ID

855: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
856: ,NULL -- CREATED_FROM
857: ,fnd_global.conc_request_id -- REQUEST_ID
858: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
859: ,fnd_global.conc_program_id -- PROGRAM_ID
860: ,SYSDATE -- PROGRAM_UPDATE_DATE
861: ,l_fund_rec.short_name
862: ,l_fund_rec.description
863: ,USERENV('LANG')

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

2377:
2378:
2379: UPDATE ozf_funds_all_b
2380: SET last_update_date = SYSDATE
2381: ,last_updated_by = NVL(fnd_global.user_id, -1)
2382: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2383: ,created_from = NULL
2384: ,request_id = fnd_global.conc_request_id
2385: ,program_application_id = fnd_global.prog_appl_id

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

2378:
2379: UPDATE ozf_funds_all_b
2380: SET last_update_date = SYSDATE
2381: ,last_updated_by = NVL(fnd_global.user_id, -1)
2382: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2383: ,created_from = NULL
2384: ,request_id = fnd_global.conc_request_id
2385: ,program_application_id = fnd_global.prog_appl_id
2386: ,program_id = fnd_global.conc_program_id

Line 2384: ,request_id = fnd_global.conc_request_id

2380: SET last_update_date = SYSDATE
2381: ,last_updated_by = NVL(fnd_global.user_id, -1)
2382: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2383: ,created_from = NULL
2384: ,request_id = fnd_global.conc_request_id
2385: ,program_application_id = fnd_global.prog_appl_id
2386: ,program_id = fnd_global.conc_program_id
2387: ,program_update_date = SYSDATE
2388: ,fund_number = l_fund_rec.fund_number

Line 2385: ,program_application_id = fnd_global.prog_appl_id

2381: ,last_updated_by = NVL(fnd_global.user_id, -1)
2382: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2383: ,created_from = NULL
2384: ,request_id = fnd_global.conc_request_id
2385: ,program_application_id = fnd_global.prog_appl_id
2386: ,program_id = fnd_global.conc_program_id
2387: ,program_update_date = SYSDATE
2388: ,fund_number = l_fund_rec.fund_number
2389: ,parent_fund_id = l_fund_rec.parent_fund_id

Line 2386: ,program_id = fnd_global.conc_program_id

2382: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2383: ,created_from = NULL
2384: ,request_id = fnd_global.conc_request_id
2385: ,program_application_id = fnd_global.prog_appl_id
2386: ,program_id = fnd_global.conc_program_id
2387: ,program_update_date = SYSDATE
2388: ,fund_number = l_fund_rec.fund_number
2389: ,parent_fund_id = l_fund_rec.parent_fund_id
2390: ,category_id = l_fund_rec.category_id

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

2503: END IF;
2504:
2505: UPDATE ozf_funds_all_tl
2506: SET last_update_date = SYSDATE
2507: ,last_updated_by = NVL(fnd_global.user_id, -1)
2508: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2509: ,created_from = NULL
2510: ,request_id = fnd_global.conc_request_id
2511: ,program_application_id = fnd_global.prog_appl_id

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

2504:
2505: UPDATE ozf_funds_all_tl
2506: SET last_update_date = SYSDATE
2507: ,last_updated_by = NVL(fnd_global.user_id, -1)
2508: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2509: ,created_from = NULL
2510: ,request_id = fnd_global.conc_request_id
2511: ,program_application_id = fnd_global.prog_appl_id
2512: ,program_id = fnd_global.conc_program_id

Line 2510: ,request_id = fnd_global.conc_request_id

2506: SET last_update_date = SYSDATE
2507: ,last_updated_by = NVL(fnd_global.user_id, -1)
2508: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2509: ,created_from = NULL
2510: ,request_id = fnd_global.conc_request_id
2511: ,program_application_id = fnd_global.prog_appl_id
2512: ,program_id = fnd_global.conc_program_id
2513: ,program_update_date = SYSDATE
2514: ,short_name = l_fund_rec.short_name

Line 2511: ,program_application_id = fnd_global.prog_appl_id

2507: ,last_updated_by = NVL(fnd_global.user_id, -1)
2508: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2509: ,created_from = NULL
2510: ,request_id = fnd_global.conc_request_id
2511: ,program_application_id = fnd_global.prog_appl_id
2512: ,program_id = fnd_global.conc_program_id
2513: ,program_update_date = SYSDATE
2514: ,short_name = l_fund_rec.short_name
2515: ,description = l_fund_rec.description

Line 2512: ,program_id = fnd_global.conc_program_id

2508: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2509: ,created_from = NULL
2510: ,request_id = fnd_global.conc_request_id
2511: ,program_application_id = fnd_global.prog_appl_id
2512: ,program_id = fnd_global.conc_program_id
2513: ,program_update_date = SYSDATE
2514: ,short_name = l_fund_rec.short_name
2515: ,description = l_fund_rec.description
2516: ,source_lang = USERENV('LANG')

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

2647: ,p_approval_for_id => p_fund_rec.fund_id
2648: /* yzhao: Jan 16 2005 fix bug 4943323(4912954) pass in correct requester id
2649: ,p_requester_id => l_fund_rec.owner
2650: */
2651: ,p_requester_id => ozf_utility_pvt.get_resource_id(p_user_id => fnd_global.user_id)
2652: ,p_requested_amount => l_child_request_amt
2653: ,p_approval_fm => 'FUND'
2654: ,p_approval_fm_id => l_fund_rec.parent_fund_id
2655: ,p_transfer_type => 'REQUEST'

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

2686: ,p_reject_stat_id =>l_reject_status_id
2687: /* yzhao: Jan 16 2005 fix bug 4943323(4912954) pass in correct requester id
2688: ,p_requester_userid =>l_fund_rec.owner
2689: */
2690: ,p_requester_userid =>ozf_utility_pvt.get_resource_id(p_user_id => fnd_global.user_id)
2691: ,p_notes_from_requester =>l_fund_rec.description
2692: ,p_workflowprocess => l_workflow_process
2693: ,p_item_type => l_item_type);
2694:

Line 3846: l_resource_id := ozf_utility_pvt.get_resource_id(p_user_id => fnd_global.user_id);

3842:
3843: -- Check for update validations
3844: IF p_mode = jtf_plsql_api.g_update THEN
3845: -- mpande added on Sep 11 for giving update access to owner and persons who have access with edit metric flag = 'Y'
3846: l_resource_id := ozf_utility_pvt.get_resource_id(p_user_id => fnd_global.user_id);
3847:
3848: IF G_DEBUG THEN
3849: ozf_utility_pvt.debug_message('resource'||ams_access_pvt.check_update_access(p_complete_rec.fund_id, 'FUND', l_resource_id, 'USER'));
3850: END IF;