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 1187: , last_updated_by = NVL (fnd_global.user_id, -1)

1183: , approved_amount = NVL(approved_amount, 0) + l_plan_curr_amount
1184: , approved_original_amount = NVL(approved_original_amount, 0) + l_utilization_rec.amount
1185: , approved_amount_fc = NVL(approved_amount_fc, 0) + l_utilization_rec.acctd_amount
1186: , last_update_date = sysdate
1187: , last_updated_by = NVL (fnd_global.user_id, -1)
1188: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1189: , object_version_number = l_act_budget_objver + 1
1190: WHERE activity_budget_id = l_act_budget_id
1191: AND object_version_number = l_act_budget_objver;

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

1184: , approved_original_amount = NVL(approved_original_amount, 0) + l_utilization_rec.amount
1185: , approved_amount_fc = NVL(approved_amount_fc, 0) + l_utilization_rec.acctd_amount
1186: , last_update_date = sysdate
1187: , last_updated_by = NVL (fnd_global.user_id, -1)
1188: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1189: , object_version_number = l_act_budget_objver + 1
1190: WHERE activity_budget_id = l_act_budget_id
1191: AND object_version_number = l_act_budget_objver;
1192:

Line 1196: l_request_id := fnd_global.conc_request_id;

1192:
1193:
1194: ELSE
1195:
1196: l_request_id := fnd_global.conc_request_id;
1197: l_budget_count := 0;
1198: l_operation := 'INSERT';
1199:
1200: --13-DEC-2010 kdass - TPA Parallel Execution ER - 9614703

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

1267: , plan_curr_amount = NVL(plan_curr_amount, 0) + NVL(l_plan_curr_amount, 0)
1268: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_univ_curr_amount, 0)
1269: , acctd_amount = NVL(acctd_amount, 0) + NVL(l_utilization_rec.acctd_amount, 0)
1270: , last_update_date = sysdate
1271: , last_updated_by = NVL (fnd_global.user_id, -1)
1272: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1273: , object_version_number = l_act_budget_objver + 1
1274: WHERE utilization_id = l_act_budget_id
1275: AND object_version_number = l_act_budget_objver;

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

1268: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_univ_curr_amount, 0)
1269: , acctd_amount = NVL(acctd_amount, 0) + NVL(l_utilization_rec.acctd_amount, 0)
1270: , last_update_date = sysdate
1271: , last_updated_by = NVL (fnd_global.user_id, -1)
1272: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1273: , object_version_number = l_act_budget_objver + 1
1274: WHERE utilization_id = l_act_budget_id
1275: AND object_version_number = l_act_budget_objver;
1276: yzhao END: 09/29/2005 R12 no TRANSFER/REQUEST in utilization table

Line 1728: --kdass - added for Third Party Flow, since fnd_global.conc_request_id initialized to -1 from 2nd iteration

1724: ozf_utility_pvt.debug_message ('exchange_rate l_converted_amt ' || l_utilization_rec.exchange_rate);
1725: ozf_utility_pvt.debug_message ('l_utilization_rec.org_id ' || l_utilization_rec.org_id);
1726: END IF;
1727:
1728: --kdass - added for Third Party Flow, since fnd_global.conc_request_id initialized to -1 from 2nd iteration
1729: l_request_id := fnd_global.conc_request_id;
1730: IF NVL(l_request_id, -1) = -1 THEN
1731: l_request_id := OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID;
1732: END IF;

Line 1729: l_request_id := fnd_global.conc_request_id;

1725: ozf_utility_pvt.debug_message ('l_utilization_rec.org_id ' || l_utilization_rec.org_id);
1726: END IF;
1727:
1728: --kdass - added for Third Party Flow, since fnd_global.conc_request_id initialized to -1 from 2nd iteration
1729: l_request_id := fnd_global.conc_request_id;
1730: IF NVL(l_request_id, -1) = -1 THEN
1731: l_request_id := OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID;
1732: END IF;
1733:

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

1831: ,list_line_id
1832: )
1833: VALUES (l_utilization_rec.utilization_id
1834: ,SYSDATE -- LAST_UPDATE_DATE
1835: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1836: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1837: ,SYSDATE -- CREATION_DATE
1838: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1839: ,l_utilization_rec.created_from -- CREATED_FROM

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

1832: )
1833: VALUES (l_utilization_rec.utilization_id
1834: ,SYSDATE -- LAST_UPDATE_DATE
1835: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1836: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1837: ,SYSDATE -- CREATION_DATE
1838: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1839: ,l_utilization_rec.created_from -- CREATED_FROM
1840: ,l_request_id -- REQUEST_ID

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

1834: ,SYSDATE -- LAST_UPDATE_DATE
1835: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1836: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1837: ,SYSDATE -- CREATION_DATE
1838: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1839: ,l_utilization_rec.created_from -- CREATED_FROM
1840: ,l_request_id -- REQUEST_ID
1841: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1842: ,fnd_global.conc_program_id -- PROGRAM_ID

Line 1841: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID

1837: ,SYSDATE -- CREATION_DATE
1838: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1839: ,l_utilization_rec.created_from -- CREATED_FROM
1840: ,l_request_id -- REQUEST_ID
1841: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1842: ,fnd_global.conc_program_id -- PROGRAM_ID
1843: ,SYSDATE -- PROGRAM_UPDATE_DATE
1844: ,l_utilization_rec.utilization_type
1845: ,l_utilization_rec.fund_id

Line 1842: ,fnd_global.conc_program_id -- PROGRAM_ID

1838: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1839: ,l_utilization_rec.created_from -- CREATED_FROM
1840: ,l_request_id -- REQUEST_ID
1841: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1842: ,fnd_global.conc_program_id -- PROGRAM_ID
1843: ,SYSDATE -- PROGRAM_UPDATE_DATE
1844: ,l_utilization_rec.utilization_type
1845: ,l_utilization_rec.fund_id
1846: ,l_utilization_rec.plan_type

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

1943: ,org_id
1944: )
1945: SELECT l_utilization_rec.utilization_id
1946: ,SYSDATE -- LAST_UPDATE_DATE
1947: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1948: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1949: ,SYSDATE -- CREATION_DATE
1950: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1951: ,l_utilization_rec.created_from -- CREATED_FROM

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

1944: )
1945: SELECT l_utilization_rec.utilization_id
1946: ,SYSDATE -- LAST_UPDATE_DATE
1947: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1948: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1949: ,SYSDATE -- CREATION_DATE
1950: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1951: ,l_utilization_rec.created_from -- CREATED_FROM
1952: ,l_request_id -- REQUEST_ID

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

1946: ,SYSDATE -- LAST_UPDATE_DATE
1947: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1948: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1949: ,SYSDATE -- CREATION_DATE
1950: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1951: ,l_utilization_rec.created_from -- CREATED_FROM
1952: ,l_request_id -- REQUEST_ID
1953: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1954: ,fnd_global.conc_program_id -- PROGRAM_ID

Line 1953: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID

1949: ,SYSDATE -- CREATION_DATE
1950: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1951: ,l_utilization_rec.created_from -- CREATED_FROM
1952: ,l_request_id -- REQUEST_ID
1953: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1954: ,fnd_global.conc_program_id -- PROGRAM_ID
1955: ,SYSDATE -- PROGRAM_UPDATE_DATE
1956: ,l_utilization_rec.adjustment_desc -- ADJUSTMENT_DESCRIPTION
1957: ,USERENV ('LANG') -- SOURCE_LANGUAGE

Line 1954: ,fnd_global.conc_program_id -- PROGRAM_ID

1950: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1951: ,l_utilization_rec.created_from -- CREATED_FROM
1952: ,l_request_id -- REQUEST_ID
1953: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1954: ,fnd_global.conc_program_id -- PROGRAM_ID
1955: ,SYSDATE -- PROGRAM_UPDATE_DATE
1956: ,l_utilization_rec.adjustment_desc -- ADJUSTMENT_DESCRIPTION
1957: ,USERENV ('LANG') -- SOURCE_LANGUAGE
1958: ,l.language_code -- LANGUAGE

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

2104: END IF; -- END IF
2105:
2106: UPDATE ozf_funds_utilized_all_b
2107: SET last_update_date = SYSDATE
2108: , last_updated_by = NVL (fnd_global.user_id, -1)
2109: , last_update_login = NVL (fnd_global.conc_login_id, -1)
2110: , request_id = l_request_id
2111: , gl_posted_flag = l_gl_posted_flag
2112: --, gl_date = sysdate

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

2105:
2106: UPDATE ozf_funds_utilized_all_b
2107: SET last_update_date = SYSDATE
2108: , last_updated_by = NVL (fnd_global.user_id, -1)
2109: , last_update_login = NVL (fnd_global.conc_login_id, -1)
2110: , request_id = l_request_id
2111: , gl_posted_flag = l_gl_posted_flag
2112: --, gl_date = sysdate
2113: WHERE utilization_id = l_utilization_rec.utilization_id

Line 2739: --kdass - added for Third Party Flow, since fnd_global.conc_request_id initialized to -1 from 2nd iteration

2735: END IF;
2736: END IF;
2737: END IF;
2738:
2739: --kdass - added for Third Party Flow, since fnd_global.conc_request_id initialized to -1 from 2nd iteration
2740: l_request_id := fnd_global.conc_request_id;
2741: IF NVL(l_request_id, -1) = -1 THEN
2742: l_request_id := OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID;
2743: END IF;

Line 2740: l_request_id := fnd_global.conc_request_id;

2736: END IF;
2737: END IF;
2738:
2739: --kdass - added for Third Party Flow, since fnd_global.conc_request_id initialized to -1 from 2nd iteration
2740: l_request_id := fnd_global.conc_request_id;
2741: IF NVL(l_request_id, -1) = -1 THEN
2742: l_request_id := OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID;
2743: END IF;
2744:

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

2743: END IF;
2744:
2745: UPDATE ozf_funds_utilized_all_b
2746: SET last_update_date = SYSDATE
2747: ,last_updated_by = NVL (fnd_global.user_id, -1)
2748: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2749: ,created_from = l_utilization_rec.created_from
2750: ,request_id = l_request_id
2751: ,program_application_id = fnd_global.prog_appl_id

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

2744:
2745: UPDATE ozf_funds_utilized_all_b
2746: SET last_update_date = SYSDATE
2747: ,last_updated_by = NVL (fnd_global.user_id, -1)
2748: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2749: ,created_from = l_utilization_rec.created_from
2750: ,request_id = l_request_id
2751: ,program_application_id = fnd_global.prog_appl_id
2752: ,program_id = fnd_global.conc_program_id

Line 2751: ,program_application_id = fnd_global.prog_appl_id

2747: ,last_updated_by = NVL (fnd_global.user_id, -1)
2748: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2749: ,created_from = l_utilization_rec.created_from
2750: ,request_id = l_request_id
2751: ,program_application_id = fnd_global.prog_appl_id
2752: ,program_id = fnd_global.conc_program_id
2753: ,program_update_date = SYSDATE
2754: ,utilization_type = l_utilization_rec.utilization_type
2755: ,fund_id = l_utilization_rec.fund_id

Line 2752: ,program_id = fnd_global.conc_program_id

2748: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2749: ,created_from = l_utilization_rec.created_from
2750: ,request_id = l_request_id
2751: ,program_application_id = fnd_global.prog_appl_id
2752: ,program_id = fnd_global.conc_program_id
2753: ,program_update_date = SYSDATE
2754: ,utilization_type = l_utilization_rec.utilization_type
2755: ,fund_id = l_utilization_rec.fund_id
2756: ,plan_type = l_utilization_rec.plan_type

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

2832: END IF;
2833:
2834: UPDATE ozf_funds_utilized_all_tl
2835: SET last_update_date = SYSDATE
2836: ,last_updated_by = NVL (fnd_global.user_id, -1)
2837: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2838: ,created_from = l_utilization_rec.created_from
2839: ,request_id = l_request_id
2840: ,program_application_id = fnd_global.prog_appl_id

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

2833:
2834: UPDATE ozf_funds_utilized_all_tl
2835: SET last_update_date = SYSDATE
2836: ,last_updated_by = NVL (fnd_global.user_id, -1)
2837: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2838: ,created_from = l_utilization_rec.created_from
2839: ,request_id = l_request_id
2840: ,program_application_id = fnd_global.prog_appl_id
2841: ,program_id = fnd_global.conc_program_id

Line 2840: ,program_application_id = fnd_global.prog_appl_id

2836: ,last_updated_by = NVL (fnd_global.user_id, -1)
2837: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2838: ,created_from = l_utilization_rec.created_from
2839: ,request_id = l_request_id
2840: ,program_application_id = fnd_global.prog_appl_id
2841: ,program_id = fnd_global.conc_program_id
2842: ,program_update_date = SYSDATE
2843: ,adjustment_desc = l_utilization_rec.adjustment_desc
2844: ,source_lang = USERENV ('LANG')

Line 2841: ,program_id = fnd_global.conc_program_id

2837: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2838: ,created_from = l_utilization_rec.created_from
2839: ,request_id = l_request_id
2840: ,program_application_id = fnd_global.prog_appl_id
2841: ,program_id = fnd_global.conc_program_id
2842: ,program_update_date = SYSDATE
2843: ,adjustment_desc = l_utilization_rec.adjustment_desc
2844: ,source_lang = USERENV ('LANG')
2845: WHERE utilization_id = l_utilization_rec.utilization_id