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 732: ,NVL(fnd_global.user_id, -1) -- LAST_UPDATED_BY

728: )
729: VALUES(
730: l_fund_rec.fund_id
731: ,SYSDATE -- LAST_UPDATE_DATE
732: ,NVL(fnd_global.user_id, -1) -- LAST_UPDATED_BY
733: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
734: ,SYSDATE -- CREATION_DATE
735: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
736: ,NULL -- l_fund_rec.created_from -- CREATED_FROM -- we donot use this column

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

729: VALUES(
730: l_fund_rec.fund_id
731: ,SYSDATE -- LAST_UPDATE_DATE
732: ,NVL(fnd_global.user_id, -1) -- LAST_UPDATED_BY
733: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
734: ,SYSDATE -- CREATION_DATE
735: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
736: ,NULL -- l_fund_rec.created_from -- CREATED_FROM -- we donot use this column
737: ,fnd_global.conc_request_id -- REQUEST_ID

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

731: ,SYSDATE -- LAST_UPDATE_DATE
732: ,NVL(fnd_global.user_id, -1) -- LAST_UPDATED_BY
733: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
734: ,SYSDATE -- CREATION_DATE
735: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
736: ,NULL -- l_fund_rec.created_from -- CREATED_FROM -- we donot use this column
737: ,fnd_global.conc_request_id -- REQUEST_ID
738: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
739: ,fnd_global.conc_program_id -- PROGRAM_ID

Line 737: ,fnd_global.conc_request_id -- REQUEST_ID

733: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
734: ,SYSDATE -- CREATION_DATE
735: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
736: ,NULL -- l_fund_rec.created_from -- CREATED_FROM -- we donot use this column
737: ,fnd_global.conc_request_id -- REQUEST_ID
738: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
739: ,fnd_global.conc_program_id -- PROGRAM_ID
740: ,SYSDATE -- PROGRAM_UPDATE_DATE
741: ,l_fund_rec.fund_number

Line 738: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID

734: ,SYSDATE -- CREATION_DATE
735: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
736: ,NULL -- l_fund_rec.created_from -- CREATED_FROM -- we donot use this column
737: ,fnd_global.conc_request_id -- REQUEST_ID
738: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
739: ,fnd_global.conc_program_id -- PROGRAM_ID
740: ,SYSDATE -- PROGRAM_UPDATE_DATE
741: ,l_fund_rec.fund_number
742: ,l_fund_rec.parent_fund_id

Line 739: ,fnd_global.conc_program_id -- PROGRAM_ID

735: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
736: ,NULL -- l_fund_rec.created_from -- CREATED_FROM -- we donot use this column
737: ,fnd_global.conc_request_id -- REQUEST_ID
738: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
739: ,fnd_global.conc_program_id -- PROGRAM_ID
740: ,SYSDATE -- PROGRAM_UPDATE_DATE
741: ,l_fund_rec.fund_number
742: ,l_fund_rec.parent_fund_id
743: ,l_fund_rec.category_id

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

764: ,l_fund_rec.exchange_rate_date
765: ,l_fund_rec.exchange_rate
766: ,l_fund_rec.department_id
767: ,l_fund_rec.costcentre_id
768: ,NVL(l_fund_rec.owner, NVL(fnd_global.user_id, -1)) -- OWNER
769: ,l_fund_rec.accrual_method
770: ,l_fund_rec.accrual_operand
771: ,l_fund_rec.accrual_rate
772: ,l_fund_rec.accrual_basis

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

856: language,
857: org_id )
858: SELECT l_fund_rec.fund_id
859: ,SYSDATE -- LAST_UPDATE_DATE
860: ,NVL(fnd_global.user_id, -1) -- LAST_UPDATED_BY
861: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
862: ,SYSDATE -- CREATION_DATE
863: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
864: ,NULL -- CREATED_FROM

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

857: org_id )
858: SELECT l_fund_rec.fund_id
859: ,SYSDATE -- LAST_UPDATE_DATE
860: ,NVL(fnd_global.user_id, -1) -- LAST_UPDATED_BY
861: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
862: ,SYSDATE -- CREATION_DATE
863: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
864: ,NULL -- CREATED_FROM
865: ,fnd_global.conc_request_id -- REQUEST_ID

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

859: ,SYSDATE -- LAST_UPDATE_DATE
860: ,NVL(fnd_global.user_id, -1) -- LAST_UPDATED_BY
861: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
862: ,SYSDATE -- CREATION_DATE
863: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
864: ,NULL -- CREATED_FROM
865: ,fnd_global.conc_request_id -- REQUEST_ID
866: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
867: ,fnd_global.conc_program_id -- PROGRAM_ID

Line 865: ,fnd_global.conc_request_id -- REQUEST_ID

861: ,NVL(fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
862: ,SYSDATE -- CREATION_DATE
863: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
864: ,NULL -- CREATED_FROM
865: ,fnd_global.conc_request_id -- REQUEST_ID
866: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
867: ,fnd_global.conc_program_id -- PROGRAM_ID
868: ,SYSDATE -- PROGRAM_UPDATE_DATE
869: ,l_fund_rec.short_name

Line 866: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID

862: ,SYSDATE -- CREATION_DATE
863: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
864: ,NULL -- CREATED_FROM
865: ,fnd_global.conc_request_id -- REQUEST_ID
866: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
867: ,fnd_global.conc_program_id -- PROGRAM_ID
868: ,SYSDATE -- PROGRAM_UPDATE_DATE
869: ,l_fund_rec.short_name
870: ,l_fund_rec.description

Line 867: ,fnd_global.conc_program_id -- PROGRAM_ID

863: ,NVL(fnd_global.user_id, -1) -- CREATED_BY
864: ,NULL -- CREATED_FROM
865: ,fnd_global.conc_request_id -- REQUEST_ID
866: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
867: ,fnd_global.conc_program_id -- PROGRAM_ID
868: ,SYSDATE -- PROGRAM_UPDATE_DATE
869: ,l_fund_rec.short_name
870: ,l_fund_rec.description
871: ,USERENV('LANG')

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

2600:
2601:
2602: UPDATE ozf_funds_all_tl
2603: SET last_update_date = SYSDATE
2604: ,last_updated_by = NVL(fnd_global.user_id, -1)
2605: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2606: ,created_from = NULL
2607: ,request_id = fnd_global.conc_request_id
2608: ,program_application_id = fnd_global.prog_appl_id

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

2601:
2602: UPDATE ozf_funds_all_tl
2603: SET last_update_date = SYSDATE
2604: ,last_updated_by = NVL(fnd_global.user_id, -1)
2605: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2606: ,created_from = NULL
2607: ,request_id = fnd_global.conc_request_id
2608: ,program_application_id = fnd_global.prog_appl_id
2609: ,program_id = fnd_global.conc_program_id

Line 2607: ,request_id = fnd_global.conc_request_id

2603: SET last_update_date = SYSDATE
2604: ,last_updated_by = NVL(fnd_global.user_id, -1)
2605: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2606: ,created_from = NULL
2607: ,request_id = fnd_global.conc_request_id
2608: ,program_application_id = fnd_global.prog_appl_id
2609: ,program_id = fnd_global.conc_program_id
2610: ,program_update_date = SYSDATE
2611: ,short_name = l_fund_rec.short_name

Line 2608: ,program_application_id = fnd_global.prog_appl_id

2604: ,last_updated_by = NVL(fnd_global.user_id, -1)
2605: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2606: ,created_from = NULL
2607: ,request_id = fnd_global.conc_request_id
2608: ,program_application_id = fnd_global.prog_appl_id
2609: ,program_id = fnd_global.conc_program_id
2610: ,program_update_date = SYSDATE
2611: ,short_name = l_fund_rec.short_name
2612: ,description = l_fund_rec.description

Line 2609: ,program_id = fnd_global.conc_program_id

2605: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2606: ,created_from = NULL
2607: ,request_id = fnd_global.conc_request_id
2608: ,program_application_id = fnd_global.prog_appl_id
2609: ,program_id = fnd_global.conc_program_id
2610: ,program_update_date = SYSDATE
2611: ,short_name = l_fund_rec.short_name
2612: ,description = l_fund_rec.description
2613: ,source_lang = USERENV('LANG')

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

2615: AND USERENV('LANG') IN(language, source_lang);
2616:
2617: UPDATE ozf_funds_all_b
2618: SET last_update_date = SYSDATE
2619: ,last_updated_by = NVL(fnd_global.user_id, -1)
2620: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2621: ,created_from = NULL
2622: ,request_id = fnd_global.conc_request_id
2623: ,program_application_id = fnd_global.prog_appl_id

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

2616:
2617: UPDATE ozf_funds_all_b
2618: SET last_update_date = SYSDATE
2619: ,last_updated_by = NVL(fnd_global.user_id, -1)
2620: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2621: ,created_from = NULL
2622: ,request_id = fnd_global.conc_request_id
2623: ,program_application_id = fnd_global.prog_appl_id
2624: ,program_id = fnd_global.conc_program_id

Line 2622: ,request_id = fnd_global.conc_request_id

2618: SET last_update_date = SYSDATE
2619: ,last_updated_by = NVL(fnd_global.user_id, -1)
2620: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2621: ,created_from = NULL
2622: ,request_id = fnd_global.conc_request_id
2623: ,program_application_id = fnd_global.prog_appl_id
2624: ,program_id = fnd_global.conc_program_id
2625: ,program_update_date = SYSDATE
2626: ,fund_number = l_fund_rec.fund_number

Line 2623: ,program_application_id = fnd_global.prog_appl_id

2619: ,last_updated_by = NVL(fnd_global.user_id, -1)
2620: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2621: ,created_from = NULL
2622: ,request_id = fnd_global.conc_request_id
2623: ,program_application_id = fnd_global.prog_appl_id
2624: ,program_id = fnd_global.conc_program_id
2625: ,program_update_date = SYSDATE
2626: ,fund_number = l_fund_rec.fund_number
2627: ,parent_fund_id = l_fund_rec.parent_fund_id

Line 2624: ,program_id = fnd_global.conc_program_id

2620: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2621: ,created_from = NULL
2622: ,request_id = fnd_global.conc_request_id
2623: ,program_application_id = fnd_global.prog_appl_id
2624: ,program_id = fnd_global.conc_program_id
2625: ,program_update_date = SYSDATE
2626: ,fund_number = l_fund_rec.fund_number
2627: ,parent_fund_id = l_fund_rec.parent_fund_id
2628: ,category_id = l_fund_rec.category_id

Line 2875: px_ozf_funds_new_tbl(l_fund_record_num).REQUEST_ID := fnd_global.conc_request_id;

2871:
2872: px_ozf_funds_new_tbl(l_fund_record_num).RESALE_BATCH_ID := p_resale_batch_id;
2873: px_ozf_funds_new_tbl(l_fund_record_num).FUND_ID := l_fund_rec.fund_id;
2874: px_ozf_funds_new_tbl(l_fund_record_num).BATCH_TYPE := p_batch_type;
2875: px_ozf_funds_new_tbl(l_fund_record_num).REQUEST_ID := fnd_global.conc_request_id;
2876: px_ozf_funds_new_tbl(l_fund_record_num).BUDGET_AMOUNT_TC := NVL(l_fund_rec.budget_amount_tc,0) - NVL(px_ozf_funds_old_rectype.budget_amount_tc,0);
2877: px_ozf_funds_new_tbl(l_fund_record_num).BUDGET_AMOUNT_FC := NVL(l_fund_rec.budget_amount_fc,0)- NVL(px_ozf_funds_old_rectype.budget_amount_fc,0);
2878: px_ozf_funds_new_tbl(l_fund_record_num).AVAILABLE_AMOUNT := NVL(l_fund_rec.available_amount,0) - NVL(px_ozf_funds_old_rectype.available_amount,0);
2879: px_ozf_funds_new_tbl(l_fund_record_num).TRANSFERED_IN_AMT := NVL(l_fund_rec.transfered_in_amt,0) - NVL(px_ozf_funds_old_rectype.transfered_in_amt,0);

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

3044: ,p_approval_for_id => p_fund_rec.fund_id
3045: /* yzhao: Jan 16 2005 fix bug 4943323(4912954) pass in correct requester id
3046: ,p_requester_id => l_fund_rec.owner
3047: */
3048: ,p_requester_id => ozf_utility_pvt.get_resource_id(p_user_id => fnd_global.user_id)
3049: ,p_requested_amount => l_child_request_amt
3050: ,p_approval_fm => 'FUND'
3051: ,p_approval_fm_id => l_fund_rec.parent_fund_id
3052: ,p_transfer_type => 'REQUEST'

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

3083: ,p_reject_stat_id =>l_reject_status_id
3084: /* yzhao: Jan 16 2005 fix bug 4943323(4912954) pass in correct requester id
3085: ,p_requester_userid =>l_fund_rec.owner
3086: */
3087: ,p_requester_userid =>ozf_utility_pvt.get_resource_id(p_user_id => fnd_global.user_id)
3088: ,p_notes_from_requester =>l_fund_rec.description
3089: ,p_workflowprocess => l_workflow_process
3090: ,p_item_type => l_item_type);
3091:

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

4244:
4245: -- Check for update validations
4246: IF p_mode = jtf_plsql_api.g_update THEN
4247: -- mpande added on Sep 11 for giving update access to owner and persons who have access with edit metric flag = 'Y'
4248: l_resource_id := ozf_utility_pvt.get_resource_id(p_user_id => fnd_global.user_id);
4249:
4250: IF G_DEBUG THEN
4251: ozf_utility_pvt.debug_message('resource'||ams_access_pvt.check_update_access(p_complete_rec.fund_id, 'FUND', l_resource_id, 'USER'));
4252: END IF;