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

Line 646: ,FND_GLOBAL.User_Id

642: VALUES (
643: NVL(p_activity_log_id,l_act_log_id)
644: -- standard who columns
645: ,SYSDATE
646: ,FND_GLOBAL.User_Id
647: ,SYSDATE
648: ,FND_GLOBAL.User_Id
649: ,FND_GLOBAL.Conc_Login_Id
650: ,1 -- Object Version Number

Line 648: ,FND_GLOBAL.User_Id

644: -- standard who columns
645: ,SYSDATE
646: ,FND_GLOBAL.User_Id
647: ,SYSDATE
648: ,FND_GLOBAL.User_Id
649: ,FND_GLOBAL.Conc_Login_Id
650: ,1 -- Object Version Number
651: ,p_log_used_by_id
652: ,p_arc_log_used_by

Line 649: ,FND_GLOBAL.Conc_Login_Id

645: ,SYSDATE
646: ,FND_GLOBAL.User_Id
647: ,SYSDATE
648: ,FND_GLOBAL.User_Id
649: ,FND_GLOBAL.Conc_Login_Id
650: ,1 -- Object Version Number
651: ,p_log_used_by_id
652: ,p_arc_log_used_by
653: ,NVL(p_transaction_id,l_log_tran_id)

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

3761: ,approved_original_amount = NVL(approved_original_amount, 0) + NVL(px_ozf_act_budgets_tbl(i).APPROVED_ORIGINAL_AMOUNT,0)
3762: ,approved_amount_fc = NVL(approved_amount_fc, 0) + NVL(px_ozf_act_budgets_tbl(i).APPROVED_AMOUNT_FC,0)
3763: ,parent_src_apprvd_amt = NVL(parent_src_apprvd_amt, 0) + NVL(px_ozf_act_budgets_tbl(i).PARENT_SRC_APPRVD_AMT ,0)
3764: ,last_update_date = sysdate
3765: ,last_updated_by = NVL (fnd_global.user_id, -1)
3766: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
3767: ,object_version_number = NVL (object_version_number,0) + 1
3768: WHERE activity_budget_id = px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID
3769: AND OBJECT_VERSION_NUMBER = l_object_version_number;

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

3762: ,approved_amount_fc = NVL(approved_amount_fc, 0) + NVL(px_ozf_act_budgets_tbl(i).APPROVED_AMOUNT_FC,0)
3763: ,parent_src_apprvd_amt = NVL(parent_src_apprvd_amt, 0) + NVL(px_ozf_act_budgets_tbl(i).PARENT_SRC_APPRVD_AMT ,0)
3764: ,last_update_date = sysdate
3765: ,last_updated_by = NVL (fnd_global.user_id, -1)
3766: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
3767: ,object_version_number = NVL (object_version_number,0) + 1
3768: WHERE activity_budget_id = px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID
3769: AND OBJECT_VERSION_NUMBER = l_object_version_number;
3770:

Line 3802: NVL(fnd_global.user_id, -1),

3798: VALUES(
3799: p_batch_id,
3800: px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID,
3801: SYSDATE,
3802: NVL(fnd_global.user_id, -1),
3803: SYSDATE,
3804: NVL(fnd_global.user_id, -1),
3805: NVL(fnd_global.user_id, -1),
3806: (NVL(px_ozf_act_budgets_tbl(i).REQUEST_AMOUNT,0)),

Line 3804: NVL(fnd_global.user_id, -1),

3800: px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID,
3801: SYSDATE,
3802: NVL(fnd_global.user_id, -1),
3803: SYSDATE,
3804: NVL(fnd_global.user_id, -1),
3805: NVL(fnd_global.user_id, -1),
3806: (NVL(px_ozf_act_budgets_tbl(i).REQUEST_AMOUNT,0)),
3807: (NVL(px_ozf_act_budgets_tbl(i).APPROVED_AMOUNT,0)),
3808: (NVL(px_ozf_act_budgets_tbl(i).APPROVED_ORIGINAL_AMOUNT,0)),

Line 3805: NVL(fnd_global.user_id, -1),

3801: SYSDATE,
3802: NVL(fnd_global.user_id, -1),
3803: SYSDATE,
3804: NVL(fnd_global.user_id, -1),
3805: NVL(fnd_global.user_id, -1),
3806: (NVL(px_ozf_act_budgets_tbl(i).REQUEST_AMOUNT,0)),
3807: (NVL(px_ozf_act_budgets_tbl(i).APPROVED_AMOUNT,0)),
3808: (NVL(px_ozf_act_budgets_tbl(i).APPROVED_ORIGINAL_AMOUNT,0)),
3809: (NVL(px_ozf_act_budgets_tbl(i).APPROVED_AMOUNT_FC,0)),

Line 3814: fnd_global.conc_request_id

3810: (NVL(px_ozf_act_budgets_tbl(i).PARENT_SRC_APPRVD_AMT ,0)),
3811: (NVL(px_ozf_act_budgets_tbl(i).SRC_CURR_REQUEST_AMT,0)),
3812: -- For JMS ER (+)
3813: p_batch_type,
3814: fnd_global.conc_request_id
3815: -- For JMS ER (-)
3816: );
3817: -- END IF;
3818: END LOOP;

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

4069:
4070: -- Updating the fund tl tables.
4071: UPDATE ozf_funds_all_tl
4072: SET last_update_date = SYSDATE
4073: ,last_updated_by = NVL(fnd_global.user_id, -1)
4074: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
4075: ,request_id = fnd_global.conc_request_id
4076: ,program_application_id = fnd_global.prog_appl_id
4077: ,program_id = fnd_global.conc_program_id

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

4070: -- Updating the fund tl tables.
4071: UPDATE ozf_funds_all_tl
4072: SET last_update_date = SYSDATE
4073: ,last_updated_by = NVL(fnd_global.user_id, -1)
4074: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
4075: ,request_id = fnd_global.conc_request_id
4076: ,program_application_id = fnd_global.prog_appl_id
4077: ,program_id = fnd_global.conc_program_id
4078: ,program_update_date = SYSDATE

Line 4075: ,request_id = fnd_global.conc_request_id

4071: UPDATE ozf_funds_all_tl
4072: SET last_update_date = SYSDATE
4073: ,last_updated_by = NVL(fnd_global.user_id, -1)
4074: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
4075: ,request_id = fnd_global.conc_request_id
4076: ,program_application_id = fnd_global.prog_appl_id
4077: ,program_id = fnd_global.conc_program_id
4078: ,program_update_date = SYSDATE
4079: WHERE fund_id = l_fund_id

Line 4076: ,program_application_id = fnd_global.prog_appl_id

4072: SET last_update_date = SYSDATE
4073: ,last_updated_by = NVL(fnd_global.user_id, -1)
4074: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
4075: ,request_id = fnd_global.conc_request_id
4076: ,program_application_id = fnd_global.prog_appl_id
4077: ,program_id = fnd_global.conc_program_id
4078: ,program_update_date = SYSDATE
4079: WHERE fund_id = l_fund_id
4080: AND USERENV('LANG') IN(language, source_lang);

Line 4077: ,program_id = fnd_global.conc_program_id

4073: ,last_updated_by = NVL(fnd_global.user_id, -1)
4074: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
4075: ,request_id = fnd_global.conc_request_id
4076: ,program_application_id = fnd_global.prog_appl_id
4077: ,program_id = fnd_global.conc_program_id
4078: ,program_update_date = SYSDATE
4079: WHERE fund_id = l_fund_id
4080: AND USERENV('LANG') IN(language, source_lang);
4081:

Line 4211: fnd_global.conc_request_id,

4207: ) VALUES
4208: (
4209: p_batch_id,
4210: p_batch_type,
4211: fnd_global.conc_request_id,
4212: px_ozf_funds_new_tbl(i).FUND_ID,
4213: SYSDATE,
4214: NVL(fnd_global.user_id, -1),
4215: SYSDATE,

Line 4214: NVL(fnd_global.user_id, -1),

4210: p_batch_type,
4211: fnd_global.conc_request_id,
4212: px_ozf_funds_new_tbl(i).FUND_ID,
4213: SYSDATE,
4214: NVL(fnd_global.user_id, -1),
4215: SYSDATE,
4216: NVL(fnd_global.user_id, -1),
4217: NVL(fnd_global.user_id, -1),
4218: NVL(px_ozf_funds_new_tbl(i).BUDGET_AMOUNT_TC,0),

Line 4216: NVL(fnd_global.user_id, -1),

4212: px_ozf_funds_new_tbl(i).FUND_ID,
4213: SYSDATE,
4214: NVL(fnd_global.user_id, -1),
4215: SYSDATE,
4216: NVL(fnd_global.user_id, -1),
4217: NVL(fnd_global.user_id, -1),
4218: NVL(px_ozf_funds_new_tbl(i).BUDGET_AMOUNT_TC,0),
4219: NVL(px_ozf_funds_new_tbl(i).BUDGET_AMOUNT_FC,0),
4220: NVL(px_ozf_funds_new_tbl(i).AVAILABLE_AMOUNT,0),

Line 4217: NVL(fnd_global.user_id, -1),

4213: SYSDATE,
4214: NVL(fnd_global.user_id, -1),
4215: SYSDATE,
4216: NVL(fnd_global.user_id, -1),
4217: NVL(fnd_global.user_id, -1),
4218: NVL(px_ozf_funds_new_tbl(i).BUDGET_AMOUNT_TC,0),
4219: NVL(px_ozf_funds_new_tbl(i).BUDGET_AMOUNT_FC,0),
4220: NVL(px_ozf_funds_new_tbl(i).AVAILABLE_AMOUNT,0),
4221: NVL(px_ozf_funds_new_tbl(i).TRANSFERED_IN_AMT,0),