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_CLAIM_ACCRUAL_PVT dependencies on MO_GLOBAL

Line 1259: l_orgId := MO_GLOBAL.GET_CURRENT_ORG_ID();

1255: END IF;
1256:
1257: l_resource_id := ozf_utility_pvt.get_resource_id(fnd_global.user_id);
1258: l_is_admin := ams_access_PVT.Check_Admin_Access(l_resource_id);
1259: l_orgId := MO_GLOBAL.GET_CURRENT_ORG_ID();
1260:
1261: -- Added Debug For Multi Currency - kpatro
1262: IF OZF_DEBUG_HIGH_ON THEN
1263: OZF_Utility_PVT.debug_message('----- Get_Utiz_Sql_Stmt_From_Clause:Start -----');

Line 1474: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

1470: SELECT gs.currency_code
1471: FROM gl_sets_of_books gs
1472: , ozf_sys_parameters org
1473: WHERE org.set_of_books_id = gs.set_of_books_id
1474: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1475:
1476: BEGIN
1477: --------------------- initialize -----------------------
1478: IF OZF_DEBUG_HIGH_ON THEN

Line 1959: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

1955: -- fix for bug 5042046
1956: CURSOR csr_system_flag IS
1957: SELECT NVL(prorate_earnings_flag, 'F')
1958: FROM ozf_sys_parameters
1959: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1960:
1961: BEGIN
1962: IF OZF_DEBUG_HIGH_ON THEN
1963: OZF_Utility_PVT.debug_message(l_full_name||': start');

Line 2022: l_currOrgId NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();

2018: l_api_name CONSTANT VARCHAR2(30) := 'Create_Fund_Adjustment';
2019: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2020: l_return_status VARCHAR2(1);
2021:
2022: l_currOrgId NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
2023: l_cust_account_id NUMBER;
2024: l_fund_id NUMBER;
2025: l_act_budget_id NUMBER;
2026: l_fund_curr_code VARCHAR2(15);

Line 2361: OPEN csr_function_currency(MO_GLOBAL.GET_CURRENT_ORG_ID());

2357: END IF;
2358:
2359: --Get FUNCTIONAL currency from system parameters
2360: IF l_currency_rec.functional_currency_code IS NULL THEN
2361: OPEN csr_function_currency(MO_GLOBAL.GET_CURRENT_ORG_ID());
2362: FETCH csr_function_currency INTO l_currency_rec.functional_currency_code;
2363: CLOSE csr_function_currency;
2364: END IF;
2365:

Line 2391: l_line_util_rec.org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();

2387: l_line_util_rec.currency_code := l_claim_currency_code;
2388: l_line_util_rec.exchange_rate_type := l_claim_exc_type;
2389: l_line_util_rec.exchange_rate_date := l_claim_exc_date;
2390: l_line_util_rec.exchange_rate := l_claim_exc_rate;
2391: l_line_util_rec.org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
2392:
2393: l_line_util_rec.object_version_number := 1;
2394: l_line_util_rec.last_updated_by := NVL(FND_GLOBAL.user_id,-1);
2395: l_line_util_rec.created_by := NVL(FND_GLOBAL.user_id,-1);

Line 3192: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

3188: SELECT gs.currency_code
3189: FROM gl_sets_of_books gs
3190: , ozf_sys_parameters org
3191: WHERE org.set_of_books_id = gs.set_of_books_id
3192: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3193:
3194: CURSOR csr_claim_id(cv_claim_line_id IN NUMBER) IS
3195: SELECT claim_id, acctd_amount
3196: FROM ozf_claim_lines

Line 3985: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

3981: SELECT gs.currency_code
3982: FROM gl_sets_of_books gs
3983: , ozf_sys_parameters org
3984: WHERE org.set_of_books_id = gs.set_of_books_id
3985: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3986:
3987: BEGIN
3988: --------------------- initialize -----------------------
3989: SAVEPOINT Delete_Line_Util;

Line 4422: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

4418: SELECT gs.currency_code
4419: FROM gl_sets_of_books gs
4420: , ozf_sys_parameters org
4421: WHERE org.set_of_books_id = gs.set_of_books_id
4422: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
4423:
4424: BEGIN
4425: x_performance_flag := FND_API.g_true;
4426:

Line 4880: l_currOrgId NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();

4876: l_amount_ut_curr NUMBER; -- amount in utilization currency (source budget currency)
4877: l_bill_to_site_id NUMBER;
4878:
4879: l_currency_rec currency_rec_type;
4880: l_currOrgId NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
4881:
4882: --Change the amount for multi currency - kpatro - 5/22/2009
4883: CURSOR csr_claim_line(cv_claim_id IN NUMBER) IS
4884: SELECT claim_line_id

Line 5559: WHERE fu.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()

5555: IS
5556: SELECT fu.cust_account_id cust_account_id, fu.plan_type plan_type, fu.plan_id plan_id,
5557: fu.product_id product_id, sum(fu.acctd_amount_remaining) amount, fu.currency_code currency_code
5558: FROM ozf_funds_utilized_all_b fu
5559: WHERE fu.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
5560: AND fu.acctd_amount_remaining <> 0
5561: AND fu.utilization_type IN ('ACCRUAL', 'ADJUSTMENT')
5562: AND fu.cust_account_id = p_cust_account_id
5563: AND fu.fund_id = p_fund_id

Line 6282: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

6278: SELECT gs.currency_code
6279: FROM gl_sets_of_books gs
6280: , ozf_sys_parameters org
6281: WHERE org.set_of_books_id = gs.set_of_books_id
6282: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
6283:
6284: BEGIN
6285: --------------------- initialize -----------------------
6286: SAVEPOINT Asso_Accruals_To_Claim;

Line 6966: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID;

6962:
6963: CURSOR c_get_conversion_type IS
6964: SELECT exchange_rate_type
6965: FROM ozf_sys_parameters_all
6966: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID;
6967:
6968: --POS Batch Processing by profiles by rsatyava (+)
6969: l_auto_claim_profile varchar2(1):= FND_PROFILE.value('OZF_AUTO_CLAIM_POS');
6970: --POS Batch Processing by profiles by rsatyava (+)

Line 7455: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID;

7451:
7452: CURSOR c_get_conversion_type IS
7453: SELECT exchange_rate_type
7454: FROM ozf_sys_parameters_all
7455: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID;
7456:
7457: --POS Batch Processing by profiles by rsatyava (+)
7458: l_auto_claim_profile varchar2(1):= FND_PROFILE.value('OZF_AUTO_CLAIM_POS');
7459: --POS Batch Processing by profiles by rsatyava (+)

Line 7973: l_currOrgId NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();

7969: l_over_paid_amount NUMBER;
7970: l_trd_prf_exist BOOLEAN;
7971: l_total_amt_earned NUMBER;
7972: l_total_amt_remaining NUMBER;
7973: l_currOrgId NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
7974:
7975: CURSOR csr_auto_adjust(cv_activity_product_id IN NUMBER) IS
7976: SELECT adjustment_flag
7977: FROM ams_act_products

Line 8256: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()

8252: , fund_id
8253: , SUM(amount)
8254: FROM ozf_funds_utilized_all_b
8255: WHERE utilization_type = 'ACCRUAL'
8256: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
8257: AND gl_posted_flag = 'Y'
8258: AND plan_type = 'OFFR'
8259: AND plan_id = cv_offer_id
8260: AND cust_account_id = cv_cust_account_id

Line 9177: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()

9173: CURSOR csr_activity_product_id(cv_plan_id IN NUMBER, cv_product_id IN NUMBER) IS
9174: SELECT activity_product_id
9175: FROM ozf_funds_utilized_all_b
9176: WHERE plan_type = 'OFFR'
9177: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
9178: AND plan_id = cv_plan_id
9179: AND product_level_type = 'PRODUCT'
9180: AND product_id = cv_product_id;
9181:

Line 10412: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

10408: SELECT gs.currency_code
10409: FROM gl_sets_of_books gs
10410: , ozf_sys_parameters org
10411: WHERE org.set_of_books_id = gs.set_of_books_id
10412: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
10413:
10414: CURSOR csr_claim_currency(cv_claim_line_id IN NUMBER) IS
10415: SELECT currency_code from ozf_claim_lines
10416: where claim_line_id = cv_claim_line_id;

Line 11602: l_currOrgId NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();

11598: l_amount_remaining NUMBER;
11599: l_amount_threshold NUMBER;
11600: l_util_cust_account_id NUMBER;
11601: l_un_earned_pay_thold_flag VARCHAR2(1) := 'F';
11602: l_currOrgId NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
11603:
11604: CURSOR csr_claim_info(cv_claim_id IN NUMBER) IS
11605: SELECT cust_account_id
11606: FROM ozf_claims

Line 11947: AND ood.operating_unit = MO_GLOBAL.GET_CURRENT_ORG_ID();

11943: WHERE ms.inventory_item_id = cv_item_id
11944: AND ms.organization_id = mp.organization_id
11945: AND mp.organization_id = mp.master_organization_Id
11946: AND mp.organization_id = ood.organization_id
11947: AND ood.operating_unit = MO_GLOBAL.GET_CURRENT_ORG_ID();
11948:
11949: CURSOR csr_req_uom_code ( cv_request_id IN NUMBER
11950: , cv_product_id IN NUMBER
11951: ) IS

Line 12155: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

12151: SELECT gs.currency_code
12152: FROM gl_sets_of_books gs
12153: , ozf_sys_parameters org
12154: WHERE org.set_of_books_id = gs.set_of_books_id
12155: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
12156:
12157: --Fix for Bug 10047209
12158: CURSOR csr_neg_batch_flag(cv_vendor_site_id IN NUMBER, cv_org_id IN NUMBER) IS
12159: SELECT supplier_neg_batch_flag

Line 12283: MO_GLOBAL.init('OZF');

12279:
12280: END IF;
12281:
12282: --Initialization of organization context
12283: MO_GLOBAL.init('OZF');
12284: MO_GLOBAL.set_policy_context('S', l_sd_org_id);
12285:
12286: -- Initialization added for bug 7578152
12287: IF Nvl(fnd_global.user_id,-1) IN (0,-1) THEN

Line 12284: MO_GLOBAL.set_policy_context('S', l_sd_org_id);

12280: END IF;
12281:
12282: --Initialization of organization context
12283: MO_GLOBAL.init('OZF');
12284: MO_GLOBAL.set_policy_context('S', l_sd_org_id);
12285:
12286: -- Initialization added for bug 7578152
12287: IF Nvl(fnd_global.user_id,-1) IN (0,-1) THEN
12288: FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_resp_id, l_appl_id);

Line 12300: OZF_Utility_PVT.debug_message('Org Id : OZF_CLAIM_ACCRUAL_PVT - '||MO_GLOBAL.GET_CURRENT_ORG_ID());

12296: IF OZF_DEBUG_HIGH_ON THEN
12297: OZF_Utility_PVT.debug_message('-ve batch flag : '||l_sup_neg_batch);
12298: END IF;
12299:
12300: OZF_Utility_PVT.debug_message('Org Id : OZF_CLAIM_ACCRUAL_PVT - '||MO_GLOBAL.GET_CURRENT_ORG_ID());
12301: OZF_Utility_PVT.debug_message('User Id : OZF_CLAIM_ACCRUAL_PVT - '||fnd_global.user_id);
12302:
12303: IF OZF_DEBUG_HIGH_ON THEN
12304: OZF_Utility_PVT.debug_message('l_payment_method : '||l_payment_method);