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 FND_PROFILE

Line 895: l_org_id := FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');

891:
892:
893: BEGIN
894: --------------------- start -----------------------
895: l_org_id := FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
896:
897: l_funds_util_flt := p_funds_util_flt;
898:
899: -- get claim currency

Line 1292: l_org_id := FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');

1288: RAISE FND_API.g_exc_unexpected_error;
1289: END IF;
1290: x_return_status := FND_API.g_ret_sts_success;
1291:
1292: l_org_id := FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
1293:
1294: --------------------- start -----------------------
1295: l_funds_util_flt := p_funds_util_flt;
1296:

Line 2018: G_UNIV_CURRENCY := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');

2014: , l_claim_exc_date
2015: , l_claim_exc_rate;
2016: CLOSE csr_claim_exc;
2017:
2018: G_UNIV_CURRENCY := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');
2019:
2020: FOR i IN p_line_util_tbl.FIRST..p_line_util_tbl.LAST LOOP
2021: IF p_line_util_tbl.exists(i) THEN
2022: l_line_util_rec := p_line_util_tbl(i);

Line 2336: G_UNIV_CURRENCY := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');

2332: OPEN csr_function_currency;
2333: FETCH csr_function_currency INTO G_FUNCTIONAL_CURRENCY;
2334: CLOSE csr_function_currency;
2335:
2336: G_UNIV_CURRENCY := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');
2337: l_line_util_rec.exchange_rate_type := l_exchange_rate_type;
2338: l_line_util_rec.exchange_rate_date := l_exchange_rate_date;
2339: l_line_util_rec.exchange_rate := l_exchange_rate;
2340:

Line 2727: G_UNIV_CURRENCY := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');

2723: IF i IS NOT NULL THEN
2724: OPEN csr_function_currency;
2725: FETCH csr_function_currency INTO G_FUNCTIONAL_CURRENCY;
2726: CLOSE csr_function_currency;
2727: G_UNIV_CURRENCY := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');
2728:
2729: LOOP
2730: l_line_util_rec := p_line_util_tbl(i);
2731: IF l_line_util_rec.claim_line_util_id IS NOT NULL THEN

Line 2965: G_UNIV_CURRENCY := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');

2961: -- get functional_currency
2962: OPEN csr_function_currency;
2963: FETCH csr_function_currency INTO G_FUNCTIONAL_CURRENCY;
2964: CLOSE csr_function_currency;
2965: G_UNIV_CURRENCY := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');
2966:
2967: END IF;
2968:
2969: IF (p_line_util_rec.amount is not null

Line 3248: G_UNIV_CURRENCY := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');

3244: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3245: RAISE FND_API.g_exc_unexpected_error;
3246: END IF;
3247:
3248: G_UNIV_CURRENCY := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');
3249: OPEN csr_function_currency;
3250: FETCH csr_function_currency INTO G_FUNCTIONAL_CURRENCY;
3251: CLOSE csr_function_currency;
3252:

Line 3468: G_UNIV_CURRENCY := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');

3464: OPEN csr_function_currency;
3465: FETCH csr_function_currency INTO G_FUNCTIONAL_CURRENCY;
3466: CLOSE csr_function_currency;
3467:
3468: G_UNIV_CURRENCY := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');
3469:
3470: LOOP
3471: l_line_util_id := p_line_util_tbl(i).claim_line_util_id;
3472: l_object_version := p_line_util_tbl(i).object_version_number;

Line 4512: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');

4508: CURSOR csr_uom_code(cv_item_id IN NUMBER) IS
4509: SELECT primary_uom_code
4510: FROM mtl_system_items
4511: WHERE inventory_item_id = cv_item_id
4512: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
4513:
4514: CURSOR csr_offer_perf(cv_list_header_id IN NUMBER) IS
4515: SELECT 1
4516: FROM ozf_offer_performances

Line 5208: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');

5204: CURSOR csr_uom_code(cv_item_id IN NUMBER) IS
5205: SELECT primary_uom_code
5206: FROM mtl_system_items
5207: WHERE inventory_item_id = cv_item_id
5208: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
5209:
5210: -- Fix for Bug 7632911
5211: CURSOR csr_claim_info(cv_claim_id IN NUMBER) IS
5212: SELECT cust_account_id, amount,claim_class

Line 6376: IF NVL(fnd_profile.value('OZF_CLAIM_SCAN_ADJUST_WORKFLOW'),'N') <> 'Y' THEN

6372: RETURN;
6373:
6374: /*
6375: -- Adjustment workflow can be invoked only when profile is set
6376: IF NVL(fnd_profile.value('OZF_CLAIM_SCAN_ADJUST_WORKFLOW'),'N') <> 'Y' THEN
6377: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6378: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NO_ADJUST_WORKFLOW');
6379: FND_MSG_PUB.add;
6380: END IF;

Line 8142: G_UNIV_CURRENCY := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');

8138: OPEN csr_function_currency;
8139: FETCH csr_function_currency INTO G_FUNCTIONAL_CURRENCY;
8140: CLOSE csr_function_currency;
8141:
8142: G_UNIV_CURRENCY := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');
8143:
8144: Init_Line_Util_Rec(
8145: x_line_util_rec => l_upd_line_util_rec
8146: );

Line 9277: IF FND_PROFILE.VALUE('OZF_OFFR_OVERRIDE_PERF_FLAG') = 'Y' THEN

9273: RETURN FND_API.g_false;
9274: END IF;
9275:
9276: -- Approval is not required if override profile is Yes
9277: IF FND_PROFILE.VALUE('OZF_OFFR_OVERRIDE_PERF_FLAG') = 'Y' THEN
9278: RETURN FND_API.g_false;
9279: END IF;
9280:
9281: OPEN csr_line_util(p_claim_id);

Line 9654: l_sd_claim_lines_grouping VARCHAR2(30) := NVL(FND_PROFILE.VALUE('OZF_SD_CLAIM_LINES_GROUPING'),'Y');

9650: l_vendor_id NUMBER;
9651: l_vendor_site_id NUMBER;
9652:
9653: --Claim lines with/without grouping w.r.t. SDR/Product - Bugfix 7811671
9654: l_sd_claim_lines_grouping VARCHAR2(30) := NVL(FND_PROFILE.VALUE('OZF_SD_CLAIM_LINES_GROUPING'),'Y');
9655: l_batch_line_id NUMBER;
9656:
9657: l_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
9658: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;