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 113: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();

109: SELECT gs.currency_code
110: FROM gl_sets_of_books gs
111: , ozf_sys_parameters org
112: WHERE org.set_of_books_id = gs.set_of_books_id
113: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
114:
115: l_offr_currency_code VARCHAR2(15);
116: l_offr_exc_rate NUMBER;
117: l_offr_exc_date DATE;

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

1112: END IF;
1113:
1114: l_resource_id := ozf_utility_pvt.get_resource_id(fnd_global.user_id);
1115: l_is_admin := ams_access_PVT.Check_Admin_Access(l_resource_id);
1116: l_orgId := MO_GLOBAL.GET_CURRENT_ORG_ID();
1117:
1118: IF l_offer_flag = 'Y' THEN
1119: -- restrict offer access if user is sales rep
1120: IF l_funds_util_flt.reference_type = 'LEAD_REFERRAL' THEN

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

1637: -- fix for bug 5042046
1638: CURSOR csr_system_flag IS
1639: SELECT NVL(prorate_earnings_flag, 'F')
1640: FROM ozf_sys_parameters
1641: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1642:
1643: BEGIN
1644: IF OZF_DEBUG_HIGH_ON THEN
1645: OZF_Utility_PVT.debug_message(l_full_name||': start');

Line 1737: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()

1733: cv_product_id IN NUMBER, cv_product_level_type IN VARCHAR2) IS
1734: SELECT utilization_id
1735: FROM ozf_funds_utilized_all_b
1736: WHERE plan_type = 'OFFR'
1737: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
1738: AND plan_id = cv_offer_id
1739: AND fund_id = cv_fund_id
1740: AND adjustment_type_id IN ( -11, -1)
1741: AND ( ( cv_product_id IS NULL AND product_id IS NULL )

Line 1822: l_act_util_rec.org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();

1818: l_act_util_rec.product_id := p_product_id;
1819: l_act_util_rec.product_level_type := p_product_level_type;
1820:
1821: -- Bug 4729839
1822: l_act_util_rec.org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
1823:
1824: l_act_util_rec.reference_type := p_reference_type;
1825: l_act_util_rec.reference_id := p_reference_id;
1826:

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

1912: SELECT gs.currency_code
1913: FROM gl_sets_of_books gs
1914: , ozf_sys_parameters org
1915: WHERE org.set_of_books_id = gs.set_of_books_id
1916: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1917:
1918: CURSOR csr_claim_exc(cv_claim_line_id IN NUMBER) IS
1919: SELECT cla.currency_code
1920: , cla.exchange_rate_type

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

2221: SELECT gs.currency_code
2222: FROM gl_sets_of_books gs
2223: , ozf_sys_parameters org
2224: WHERE org.set_of_books_id = gs.set_of_books_id
2225: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
2226:
2227: CURSOR csr_claim_exc(cv_claim_line_id IN NUMBER) IS
2228: SELECT cla.currency_code
2229: , cla.exchange_rate_type

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

2657: SELECT gs.currency_code
2658: FROM gl_sets_of_books gs
2659: , ozf_sys_parameters org
2660: WHERE org.set_of_books_id = gs.set_of_books_id
2661: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
2662:
2663: BEGIN
2664: --------------------- initialize -----------------------
2665: SAVEPOINT Update_Line_Util_Tbl;

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

2861: SELECT gs.currency_code
2862: FROM gl_sets_of_books gs
2863: , ozf_sys_parameters org
2864: WHERE org.set_of_books_id = gs.set_of_books_id
2865: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
2866:
2867: CURSOR csr_claim_id(cv_claim_line_id IN NUMBER) IS
2868: SELECT claim_id, acctd_amount
2869: FROM ozf_claim_lines

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

3198: SELECT gs.currency_code
3199: FROM gl_sets_of_books gs
3200: , ozf_sys_parameters org
3201: WHERE org.set_of_books_id = gs.set_of_books_id
3202: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3203:
3204: BEGIN
3205: --------------------- initialize -----------------------
3206: SAVEPOINT Delete_All_Line_Util;

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

3393: SELECT gs.currency_code
3394: FROM gl_sets_of_books gs
3395: , ozf_sys_parameters org
3396: WHERE org.set_of_books_id = gs.set_of_books_id
3397: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3398:
3399: CURSOR csr_final_lu_acctd_amt(cv_claim_line_id IN NUMBER) IS
3400: SELECT SUM(acctd_amount)
3401: FROM ozf_claim_lines_util

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

4038: SELECT gs.currency_code
4039: FROM gl_sets_of_books gs
4040: , ozf_sys_parameters org
4041: WHERE org.set_of_books_id = gs.set_of_books_id
4042: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
4043:
4044: BEGIN
4045: x_performance_flag := FND_API.g_true;
4046:

Line 4523: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID;

4519: --Added for bug 7030415
4520: CURSOR c_get_conversion_type IS
4521: SELECT exchange_rate_type
4522: FROM ozf_sys_parameters_all
4523: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID;
4524:
4525: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
4526: l_rate NUMBER;
4527:

Line 5889: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID;

5885: --Added for bug 7030415
5886: CURSOR c_get_conversion_type IS
5887: SELECT exchange_rate_type
5888: FROM ozf_sys_parameters_all
5889: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID;
5890:
5891: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
5892: l_rate NUMBER;
5893:

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

6319: CURSOR csr_sys_pay_unearned IS
6320: SELECT un_earned_pay_allow_to, un_earned_pay_thold_type
6321: , un_earned_pay_thold_amount, un_earned_pay_thold_flag
6322: FROM ozf_sys_parameters
6323: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
6324:
6325: CURSOR csr_earnings(cv_cust_account_id IN NUMBER, cv_plan_id IN NUMBER) IS
6326: SELECT SUM(acctd_amount), SUM(acctd_amount_remaining)
6327: FROM ozf_funds_utilized_all_b

Line 6329: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()

6325: CURSOR csr_earnings(cv_cust_account_id IN NUMBER, cv_plan_id IN NUMBER) IS
6326: SELECT SUM(acctd_amount), SUM(acctd_amount_remaining)
6327: FROM ozf_funds_utilized_all_b
6328: WHERE utilization_type IN ('ACCRUAL', 'ADJUSTMENT')
6329: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
6330: AND plan_type = 'OFFR'
6331: AND plan_id = cv_plan_id
6332: AND cust_account_id = cv_cust_account_id;
6333:

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

6708: SELECT gs.currency_code
6709: FROM gl_sets_of_books gs
6710: , ozf_sys_parameters org
6711: WHERE org.set_of_books_id = gs.set_of_books_id
6712: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
6713:
6714: CURSOR csr_offer_currency(cv_plan_id IN NUMBER) IS
6715: SELECT transaction_currency_code
6716: FROM ozf_offers

Line 6751: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()

6747: CURSOR csr_activity_product_id(cv_plan_id IN NUMBER, cv_product_id IN NUMBER) IS
6748: SELECT activity_product_id
6749: FROM ozf_funds_utilized_all_b
6750: WHERE plan_type = 'OFFR'
6751: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
6752: AND plan_id = cv_plan_id
6753: AND product_level_type = 'PRODUCT'
6754: AND product_id = cv_product_id;
6755:

Line 6838: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()

6834: fund_id,
6835: SUM(amount)
6836: FROM ozf_funds_utilized_all_b
6837: WHERE utilization_type = 'ACCRUAL'
6838: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
6839: AND gl_posted_flag = 'Y'
6840: AND plan_type = 'OFFR'
6841: AND plan_id = cv_offer_id
6842: AND cust_account_id = cv_cust_account_id

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

8072: SELECT gs.currency_code
8073: FROM gl_sets_of_books gs
8074: , ozf_sys_parameters org
8075: WHERE org.set_of_books_id = gs.set_of_books_id
8076: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
8077:
8078: CURSOR csr_claim_currency(cv_claim_line_id IN NUMBER) IS
8079: SELECT currency_code from ozf_claim_lines
8080: where claim_line_id = cv_claim_line_id;

Line 8833: AND fu.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()

8829: ,qp.currency_code
8830: FROM ozf_funds_utilized_all_b fu
8831: ,qp_list_headers_vl qp
8832: WHERE fu.component_id = cv_offer_id
8833: AND fu.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
8834: AND fu.component_type = 'OFFR'
8835: AND fu.utilization_type = 'REQUEST'
8836: AND qp.list_header_id = fu.component_id
8837: GROUP BY fu.fund_id, fu.currency_code, qp.currency_code;

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

9129: SELECT gs.currency_code
9130: FROM gl_sets_of_books gs
9131: , ozf_sys_parameters org
9132: WHERE org.set_of_books_id = gs.set_of_books_id
9133: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
9134:
9135: l_fu_currency_code VARCHAR2(15);
9136: l_fu_exc_rate NUMBER;
9137: l_fu_exc_date DATE;

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

9369: -- fix for bug 5042046
9370: CURSOR csr_sys_param_info IS
9371: SELECT un_earned_pay_thold_type, un_earned_pay_thold_amount, un_earned_pay_thold_flag
9372: FROM ozf_sys_parameters
9373: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
9374:
9375: CURSOR csr_line_util(cv_claim_id IN NUMBER) IS
9376: SELECT fu.plan_id, fu.cust_account_id, sum(lu.acctd_amount)
9377: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu

Line 9388: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()

9384: CURSOR csr_funds_util(cv_cust_account_id IN NUMBER, cv_plan_id IN NUMBER) IS
9385: SELECT sum(acctd_amount), sum(acctd_amount_remaining)
9386: FROM ozf_funds_utilized_all_b
9387: WHERE utilization_type in ('ACCRUAL', 'ADJUSTMENT')
9388: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
9389: AND gl_posted_flag = 'Y'
9390: AND plan_type = 'OFFR'
9391: AND plan_id = cv_plan_id
9392: AND cust_account_id = cv_cust_account_id;

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

9684: WHERE ms.inventory_item_id = cv_item_id
9685: AND ms.organization_id = mp.organization_id
9686: AND mp.organization_id = mp.master_organization_Id
9687: AND mp.organization_id = ood.organization_id
9688: AND ood.operating_unit = MO_GLOBAL.GET_CURRENT_ORG_ID();
9689:
9690: CURSOR csr_req_uom_code ( cv_request_id IN NUMBER
9691: , cv_product_id IN NUMBER
9692: ) IS

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

9973:
9974: END IF;
9975:
9976: --Initialization of organization context
9977: MO_GLOBAL.init('OZF');
9978: MO_GLOBAL.set_policy_context('S', l_sd_org_id);
9979:
9980: -- Initialization added for bug 7578152
9981: IF Nvl(fnd_global.user_id,-1) IN (0,-1) THEN

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

9974: END IF;
9975:
9976: --Initialization of organization context
9977: MO_GLOBAL.init('OZF');
9978: MO_GLOBAL.set_policy_context('S', l_sd_org_id);
9979:
9980: -- Initialization added for bug 7578152
9981: IF Nvl(fnd_global.user_id,-1) IN (0,-1) THEN
9982: FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_resp_id, l_appl_id);

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

9981: IF Nvl(fnd_global.user_id,-1) IN (0,-1) THEN
9982: FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_resp_id, l_appl_id);
9983: END IF;
9984:
9985: OZF_Utility_PVT.debug_message('Org Id : OZF_CLAIM_ACCRUAL_PVT - '||MO_GLOBAL.GET_CURRENT_ORG_ID());
9986: OZF_Utility_PVT.debug_message('User Id : OZF_CLAIM_ACCRUAL_PVT - '||fnd_global.user_id);
9987:
9988: IF OZF_DEBUG_HIGH_ON THEN
9989: OZF_Utility_PVT.debug_message('l_payment_method : '||l_payment_method);