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

Line 713: l_requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

709: OPEN c_act_budget_id;
710: FETCH c_act_budget_id INTO l_act_budgets_rec.activity_budget_id;
711: CLOSE c_act_budget_id;
712:
713: l_requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
714:
715: INSERT INTO ozf_act_budgets
716: (activity_budget_id,last_update_date
717: ,last_updated_by, creation_date

Line 749: ,fnd_global.user_id, SYSDATE

745: ,approved_amount_fc
746: ,src_curr_request_amt
747: )
748: VALUES (l_act_budgets_rec.activity_budget_id,SYSDATE
749: ,fnd_global.user_id, SYSDATE
750: ,fnd_global.user_id, fnd_global.conc_login_id
751: ,1, l_act_budgets_rec.act_budget_used_by_id
752: ,l_act_budgets_rec.arc_act_budget_used_by, l_act_budgets_rec.budget_source_type
753: ,l_act_budgets_rec.budget_source_id, l_act_budgets_rec.transaction_type

Line 750: ,fnd_global.user_id, fnd_global.conc_login_id

746: ,src_curr_request_amt
747: )
748: VALUES (l_act_budgets_rec.activity_budget_id,SYSDATE
749: ,fnd_global.user_id, SYSDATE
750: ,fnd_global.user_id, fnd_global.conc_login_id
751: ,1, l_act_budgets_rec.act_budget_used_by_id
752: ,l_act_budgets_rec.arc_act_budget_used_by, l_act_budgets_rec.budget_source_type
753: ,l_act_budgets_rec.budget_source_id, l_act_budgets_rec.transaction_type
754: ,l_act_budgets_rec.request_amount, l_act_budgets_rec.request_currency

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

1721: ,discount_amount_currency_code
1722: ,year_id -- Fix for Bug 12657908
1723: )
1724: VALUES (l_utilization_rec.utilization_id,SYSDATE -- LAST_UPDATE_DATE
1725: ,NVL (fnd_global.user_id, -1),NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1726: ,SYSDATE,NVL (fnd_global.user_id, -1) -- CREATED_BY
1727: ,l_utilization_rec.created_from,fnd_global.conc_request_id -- REQUEST_ID
1728: ,fnd_global.prog_appl_id,fnd_global.conc_program_id -- PROGRAM_ID
1729: ,SYSDATE,l_utilization_rec.utilization_type

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

1722: ,year_id -- Fix for Bug 12657908
1723: )
1724: VALUES (l_utilization_rec.utilization_id,SYSDATE -- LAST_UPDATE_DATE
1725: ,NVL (fnd_global.user_id, -1),NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1726: ,SYSDATE,NVL (fnd_global.user_id, -1) -- CREATED_BY
1727: ,l_utilization_rec.created_from,fnd_global.conc_request_id -- REQUEST_ID
1728: ,fnd_global.prog_appl_id,fnd_global.conc_program_id -- PROGRAM_ID
1729: ,SYSDATE,l_utilization_rec.utilization_type
1730: ,l_utilization_rec.fund_id,l_utilization_rec.plan_type

Line 1727: ,l_utilization_rec.created_from,fnd_global.conc_request_id -- REQUEST_ID

1723: )
1724: VALUES (l_utilization_rec.utilization_id,SYSDATE -- LAST_UPDATE_DATE
1725: ,NVL (fnd_global.user_id, -1),NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1726: ,SYSDATE,NVL (fnd_global.user_id, -1) -- CREATED_BY
1727: ,l_utilization_rec.created_from,fnd_global.conc_request_id -- REQUEST_ID
1728: ,fnd_global.prog_appl_id,fnd_global.conc_program_id -- PROGRAM_ID
1729: ,SYSDATE,l_utilization_rec.utilization_type
1730: ,l_utilization_rec.fund_id,l_utilization_rec.plan_type
1731: ,l_utilization_rec.plan_id,l_utilization_rec.component_type

Line 1728: ,fnd_global.prog_appl_id,fnd_global.conc_program_id -- PROGRAM_ID

1724: VALUES (l_utilization_rec.utilization_id,SYSDATE -- LAST_UPDATE_DATE
1725: ,NVL (fnd_global.user_id, -1),NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1726: ,SYSDATE,NVL (fnd_global.user_id, -1) -- CREATED_BY
1727: ,l_utilization_rec.created_from,fnd_global.conc_request_id -- REQUEST_ID
1728: ,fnd_global.prog_appl_id,fnd_global.conc_program_id -- PROGRAM_ID
1729: ,SYSDATE,l_utilization_rec.utilization_type
1730: ,l_utilization_rec.fund_id,l_utilization_rec.plan_type
1731: ,l_utilization_rec.plan_id,l_utilization_rec.component_type
1732: ,l_utilization_rec.component_id,l_utilization_rec.object_type

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

1796: ,org_id
1797: )
1798: SELECT l_utilization_rec.utilization_id
1799: ,SYSDATE -- LAST_UPDATE_DATE
1800: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1801: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1802: ,SYSDATE -- CREATION_DATE
1803: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1804: ,l_utilization_rec.created_from -- CREATED_FROM

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

1797: )
1798: SELECT l_utilization_rec.utilization_id
1799: ,SYSDATE -- LAST_UPDATE_DATE
1800: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1801: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1802: ,SYSDATE -- CREATION_DATE
1803: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1804: ,l_utilization_rec.created_from -- CREATED_FROM
1805: ,fnd_global.conc_request_id -- REQUEST_ID

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

1799: ,SYSDATE -- LAST_UPDATE_DATE
1800: ,NVL (fnd_global.user_id, -1) -- LAST_UPDATED_BY
1801: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1802: ,SYSDATE -- CREATION_DATE
1803: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1804: ,l_utilization_rec.created_from -- CREATED_FROM
1805: ,fnd_global.conc_request_id -- REQUEST_ID
1806: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1807: ,fnd_global.conc_program_id -- PROGRAM_ID

Line 1805: ,fnd_global.conc_request_id -- REQUEST_ID

1801: ,NVL (fnd_global.conc_login_id, -1) -- LAST_UPDATE_LOGIN
1802: ,SYSDATE -- CREATION_DATE
1803: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1804: ,l_utilization_rec.created_from -- CREATED_FROM
1805: ,fnd_global.conc_request_id -- REQUEST_ID
1806: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1807: ,fnd_global.conc_program_id -- PROGRAM_ID
1808: ,SYSDATE -- PROGRAM_UPDATE_DATE
1809: ,l_utilization_rec.adjustment_desc -- ADJUSTMENT_DESCRIPTION

Line 1806: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID

1802: ,SYSDATE -- CREATION_DATE
1803: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1804: ,l_utilization_rec.created_from -- CREATED_FROM
1805: ,fnd_global.conc_request_id -- REQUEST_ID
1806: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1807: ,fnd_global.conc_program_id -- PROGRAM_ID
1808: ,SYSDATE -- PROGRAM_UPDATE_DATE
1809: ,l_utilization_rec.adjustment_desc -- ADJUSTMENT_DESCRIPTION
1810: ,USERENV ('LANG') -- SOURCE_LANGUAGE

Line 1807: ,fnd_global.conc_program_id -- PROGRAM_ID

1803: ,NVL (fnd_global.user_id, -1) -- CREATED_BY
1804: ,l_utilization_rec.created_from -- CREATED_FROM
1805: ,fnd_global.conc_request_id -- REQUEST_ID
1806: ,fnd_global.prog_appl_id -- PROGRAM_APPLICATION_ID
1807: ,fnd_global.conc_program_id -- PROGRAM_ID
1808: ,SYSDATE -- PROGRAM_UPDATE_DATE
1809: ,l_utilization_rec.adjustment_desc -- ADJUSTMENT_DESCRIPTION
1810: ,USERENV ('LANG') -- SOURCE_LANGUAGE
1811: ,l.language_code -- LANGUAGE

Line 1837: last_updated_by = NVL (fnd_global.user_id, -1), last_update_login = NVL (fnd_global.conc_login_id, -1),

1833: univ_curr_amount = univ_curr_amount+l_utilization_rec.univ_curr_amount,
1834: univ_curr_amount_remaining = univ_curr_amount_remaining+l_utilization_rec.univ_curr_amount_remaining,
1835: exchange_rate_type = l_utilization_rec.exchange_rate_type, exchange_rate_date = G_FAE_START_DATE,
1836: exchange_rate = l_utilization_rec.exchange_rate, last_update_date = SYSDATE,
1837: last_updated_by = NVL (fnd_global.user_id, -1), last_update_login = NVL (fnd_global.conc_login_id, -1),
1838: object_version_number = l_obj_ver_num + 1
1839: WHERE utilization_id = l_utilization_id
1840: AND object_version_number = l_obj_ver_num;
1841:

Line 1843: SET last_update_date = SYSDATE, last_updated_by = NVL (fnd_global.user_id, -1), last_update_login = NVL (fnd_global.conc_login_id, -1),

1839: WHERE utilization_id = l_utilization_id
1840: AND object_version_number = l_obj_ver_num;
1841:
1842: UPDATE ozf_funds_utilized_all_tl
1843: SET last_update_date = SYSDATE, last_updated_by = NVL (fnd_global.user_id, -1), last_update_login = NVL (fnd_global.conc_login_id, -1),
1844: creation_date = SYSDATE, created_by = NVL (fnd_global.user_id, -1), request_id = fnd_global.conc_request_id,
1845: program_application_id = fnd_global.prog_appl_id, program_id = fnd_global.conc_program_id, program_update_date = SYSDATE,
1846: org_id = l_utilization_rec.org_id
1847: WHERE utilization_id = l_utilization_id;

Line 1844: creation_date = SYSDATE, created_by = NVL (fnd_global.user_id, -1), request_id = fnd_global.conc_request_id,

1840: AND object_version_number = l_obj_ver_num;
1841:
1842: UPDATE ozf_funds_utilized_all_tl
1843: SET last_update_date = SYSDATE, last_updated_by = NVL (fnd_global.user_id, -1), last_update_login = NVL (fnd_global.conc_login_id, -1),
1844: creation_date = SYSDATE, created_by = NVL (fnd_global.user_id, -1), request_id = fnd_global.conc_request_id,
1845: program_application_id = fnd_global.prog_appl_id, program_id = fnd_global.conc_program_id, program_update_date = SYSDATE,
1846: org_id = l_utilization_rec.org_id
1847: WHERE utilization_id = l_utilization_id;
1848: x_utilization_id := l_utilization_id ;

Line 1845: program_application_id = fnd_global.prog_appl_id, program_id = fnd_global.conc_program_id, program_update_date = SYSDATE,

1841:
1842: UPDATE ozf_funds_utilized_all_tl
1843: SET last_update_date = SYSDATE, last_updated_by = NVL (fnd_global.user_id, -1), last_update_login = NVL (fnd_global.conc_login_id, -1),
1844: creation_date = SYSDATE, created_by = NVL (fnd_global.user_id, -1), request_id = fnd_global.conc_request_id,
1845: program_application_id = fnd_global.prog_appl_id, program_id = fnd_global.conc_program_id, program_update_date = SYSDATE,
1846: org_id = l_utilization_rec.org_id
1847: WHERE utilization_id = l_utilization_id;
1848: x_utilization_id := l_utilization_id ;
1849: END IF;

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

1962: , approved_amount = NVL(approved_amount, 0) + l_utilization_rec.fund_request_amount
1963: , approved_original_amount = NVL(approved_original_amount, 0) + l_utilization_rec.amount
1964: , approved_amount_fc = NVL(approved_amount_fc, 0) + l_utilization_rec.acctd_amount
1965: , last_update_date = sysdate
1966: , last_updated_by = NVL (fnd_global.user_id, -1)
1967: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1968: , object_version_number = l_act_budget_objver + 1
1969: WHERE activity_budget_id = l_act_budget_id
1970: AND object_version_number = l_act_budget_objver;

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

1963: , approved_original_amount = NVL(approved_original_amount, 0) + l_utilization_rec.amount
1964: , approved_amount_fc = NVL(approved_amount_fc, 0) + l_utilization_rec.acctd_amount
1965: , last_update_date = sysdate
1966: , last_updated_by = NVL (fnd_global.user_id, -1)
1967: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1968: , object_version_number = l_act_budget_objver + 1
1969: WHERE activity_budget_id = l_act_budget_id
1970: AND object_version_number = l_act_budget_objver;
1971:

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

1990: , plan_curr_amount = NVL(plan_curr_amount,0) + NVL(l_utilization_rec.plan_curr_amount,0)
1991: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_utilization_rec.univ_curr_amount, 0)
1992: , acctd_amount = NVL(acctd_amount,0) + NVL(l_utilization_rec.acctd_amount,0)
1993: , last_update_date = sysdate
1994: , last_updated_by = NVL (fnd_global.user_id, -1)
1995: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1996: , object_version_number = l_act_budget_objver + 1
1997: WHERE utilization_id = l_act_budget_id
1998: AND object_version_number = l_act_budget_objver;*/

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

1991: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_utilization_rec.univ_curr_amount, 0)
1992: , acctd_amount = NVL(acctd_amount,0) + NVL(l_utilization_rec.acctd_amount,0)
1993: , last_update_date = sysdate
1994: , last_updated_by = NVL (fnd_global.user_id, -1)
1995: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1996: , object_version_number = l_act_budget_objver + 1
1997: WHERE utilization_id = l_act_budget_id
1998: AND object_version_number = l_act_budget_objver;*/
1999: -- yzhao: 10/14/2003 END Fix TEVA bug - customer fully accrual budget committed amount is always 0

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

4907: END IF;
4908: ELSE--if amount is zero then only update gl_posted_flag to Y in ozf_funds_utilized_all and do not insert record to ozf_ae_lines_all
4909: UPDATE ozf_funds_utilized_all_b
4910: SET last_update_date = SYSDATE
4911: , last_updated_by = NVL (fnd_global.user_id, -1)
4912: , last_update_login = NVL (fnd_global.conc_login_id, -1)
4913: , object_version_number = l_objVerTbl(t_i) + 1
4914: , gl_posted_flag = G_GL_FLAG_YES
4915: WHERE utilization_id = l_utilIdTbl(t_i)

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

4908: ELSE--if amount is zero then only update gl_posted_flag to Y in ozf_funds_utilized_all and do not insert record to ozf_ae_lines_all
4909: UPDATE ozf_funds_utilized_all_b
4910: SET last_update_date = SYSDATE
4911: , last_updated_by = NVL (fnd_global.user_id, -1)
4912: , last_update_login = NVL (fnd_global.conc_login_id, -1)
4913: , object_version_number = l_objVerTbl(t_i) + 1
4914: , gl_posted_flag = G_GL_FLAG_YES
4915: WHERE utilization_id = l_utilIdTbl(t_i)
4916: AND object_version_number = l_objVerTbl(t_i);

Line 5718: AND util.request_id = fnd_global.conc_request_id

5714: ozf_xref_map map
5715: WHERE line.line_id = util.order_line_id
5716: AND line.header_id = util.object_id
5717: AND util.object_type = ''ORDER''
5718: AND util.request_id = fnd_global.conc_request_id
5719: AND util.plan_type = ''OFFR''
5720: AND util.plan_id = off.qp_list_header_id
5721: AND util.price_adjustment_id = oe.price_adjustment_id
5722: AND util.gl_posted_flag IN (''Y'', ''X'')

Line 5746: AND util.request_id = fnd_global.conc_request_id

5742: ozf_xref_map map
5743: WHERE line.line_id = util.order_line_id
5744: AND line.header_id = util.object_id
5745: AND util.object_type = ''ORDER''
5746: AND util.request_id = fnd_global.conc_request_id
5747: AND util.price_adjustment_id = oe.price_adjustment_id
5748: AND util.plan_type = ''OFFR''
5749: AND util.plan_id = off.qp_list_header_id
5750: AND util.price_adjustment_id = oe.price_adjustment_id

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

5988: -- update utilization gl_posted_flag directly to avoid all validations
5989: --ninarasi fix for bug 16029659. Set exchange_rate_date to gl_date since exchange_rate_date has to be same as the shipment date.
5990: UPDATE ozf_funds_utilized_all_b
5991: SET last_update_date = SYSDATE
5992: , last_updated_by = NVL (fnd_global.user_id, -1)
5993: , last_update_login = NVL (fnd_global.conc_login_id, -1)
5994: , object_version_number = p_util_object_version_number + 1
5995: , gl_posted_flag = l_gl_posted_flag
5996: , exchange_rate_date = gl_date

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

5989: --ninarasi fix for bug 16029659. Set exchange_rate_date to gl_date since exchange_rate_date has to be same as the shipment date.
5990: UPDATE ozf_funds_utilized_all_b
5991: SET last_update_date = SYSDATE
5992: , last_updated_by = NVL (fnd_global.user_id, -1)
5993: , last_update_login = NVL (fnd_global.conc_login_id, -1)
5994: , object_version_number = p_util_object_version_number + 1
5995: , gl_posted_flag = l_gl_posted_flag
5996: , exchange_rate_date = gl_date
5997: --, gl_date = sysdate

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

6998: + NVL(l_conv_fund_req_amount, 0)
6999: , approved_amount = NVL(approved_amount, 0) - NVL(p_fund_req_amount, 0)
7000: + NVL(l_conv_fund_req_amount, 0)
7001: , last_update_date = sysdate
7002: , last_updated_by = NVL (fnd_global.user_id, -1)
7003: , last_update_login = NVL (fnd_global.conc_login_id, -1)
7004: , object_version_number = l_act_budget_objver + 1
7005: WHERE activity_budget_id = l_act_budget_id
7006: AND object_version_number = l_act_budget_objver;

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

6999: , approved_amount = NVL(approved_amount, 0) - NVL(p_fund_req_amount, 0)
7000: + NVL(l_conv_fund_req_amount, 0)
7001: , last_update_date = sysdate
7002: , last_updated_by = NVL (fnd_global.user_id, -1)
7003: , last_update_login = NVL (fnd_global.conc_login_id, -1)
7004: , object_version_number = l_act_budget_objver + 1
7005: WHERE activity_budget_id = l_act_budget_id
7006: AND object_version_number = l_act_budget_objver;
7007: