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_RECONCILE_PVT dependencies on FND_PROFILE

Line 131: l_has_Grace_date VARCHAR2(1) := NVL(fnd_profile.VALUE('OZF_HAS_GRACE_PERIOD'), 'N');

127: l_object_curr VARCHAR2 (30);
128: l_object_id NUMBER;
129: l_object_tbl object_tbl_type;
130: i NUMBER := 1;
131: l_has_Grace_date VARCHAR2(1) := NVL(fnd_profile.VALUE('OZF_HAS_GRACE_PERIOD'), 'N');
132: l_object_status VARCHAR2(30);
133: l_util_paid VARCHAR2(1) := NVL(p_util_paid, 'N');
134: l_object_end_date DATE;
135: l_object_type VARCHAR2 (30) := p_object_type ;

Line 295: - NVL (to_number(fnd_profile.VALUE ('OZF_SF_GRACE_DAYS')), 0); --bug fix for 3654855. Added to_number

291: l_grace_date := SYSDATE;
292: ELSE
293: IF p_object_type = 'SOFT_FUND' THEN
294: l_grace_date := TRUNC(SYSDATE)
295: - NVL (to_number(fnd_profile.VALUE ('OZF_SF_GRACE_DAYS')), 0); --bug fix for 3654855. Added to_number
296: l_object_type := 'OFFR';
297: ELSIF p_object_type = 'SPECIAL_PRICE' THEN
298: l_grace_date := TRUNC(SYSDATE)
299: - NVL (to_number(fnd_profile.VALUE ('OZF_SP_GRACE_DAYS')), 0);

Line 299: - NVL (to_number(fnd_profile.VALUE ('OZF_SP_GRACE_DAYS')), 0);

295: - NVL (to_number(fnd_profile.VALUE ('OZF_SF_GRACE_DAYS')), 0); --bug fix for 3654855. Added to_number
296: l_object_type := 'OFFR';
297: ELSIF p_object_type = 'SPECIAL_PRICE' THEN
298: l_grace_date := TRUNC(SYSDATE)
299: - NVL (to_number(fnd_profile.VALUE ('OZF_SP_GRACE_DAYS')), 0);
300: l_object_type := 'OFFR';
301: ELSE
302: l_grace_date := TRUNC(SYSDATE)
303: - NVL (to_number(fnd_profile.VALUE ('OZF_BUDGET_ADJ_GRACE_PERIOD')), 0);

Line 303: - NVL (to_number(fnd_profile.VALUE ('OZF_BUDGET_ADJ_GRACE_PERIOD')), 0);

299: - NVL (to_number(fnd_profile.VALUE ('OZF_SP_GRACE_DAYS')), 0);
300: l_object_type := 'OFFR';
301: ELSE
302: l_grace_date := TRUNC(SYSDATE)
303: - NVL (to_number(fnd_profile.VALUE ('OZF_BUDGET_ADJ_GRACE_PERIOD')), 0);
304: END IF;
305:
306: END IF;
307:

Line 762: -- l_source_from_par_flag := fnd_profile.VALUE ('OZF_SOURCE_FROM_PARENT');

758: END IF;
759:
760: -- commented for R12 by feliu.
761: -- flag indicating wether funding is done by fund or parent
762: -- l_source_from_par_flag := fnd_profile.VALUE ('OZF_SOURCE_FROM_PARENT');
763: /* l_source_from_par_flag := 'Y';
764:
765: IF l_source_from_par_flag = 'Y' THEN
766: -- for all these high level objects sourcing is always from funds

Line 1073: := NVL (fnd_profile.VALUE ('OZF_COMM_BUDGET_EXCEED'), 'N');

1069: l_fund_curr_req_amount NUMBER;
1070: l_forecast_tbl forecast_tbl_type;
1071:
1072: l_exceed_flag VARCHAR2 (1)
1073: := NVL (fnd_profile.VALUE ('OZF_COMM_BUDGET_EXCEED'), 'N');
1074: l_parent_flag VARCHAR2 (1)
1075: := NVL (fnd_profile.VALUE ('OZF_SOURCE_FROM_PARENT'), 'N');
1076: --l_recal_period NUMBER := TO_NUMBER (NVL (fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'), '7'));
1077: l_recal_period NUMBER := fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'); -- changed by feliu on 12/01/05

Line 1075: := NVL (fnd_profile.VALUE ('OZF_SOURCE_FROM_PARENT'), 'N');

1071:
1072: l_exceed_flag VARCHAR2 (1)
1073: := NVL (fnd_profile.VALUE ('OZF_COMM_BUDGET_EXCEED'), 'N');
1074: l_parent_flag VARCHAR2 (1)
1075: := NVL (fnd_profile.VALUE ('OZF_SOURCE_FROM_PARENT'), 'N');
1076: --l_recal_period NUMBER := TO_NUMBER (NVL (fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'), '7'));
1077: l_recal_period NUMBER := fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'); -- changed by feliu on 12/01/05
1078: l_max_committed NUMBER;
1079: l_commit BOOLEAN := TRUE;

Line 1076: --l_recal_period NUMBER := TO_NUMBER (NVL (fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'), '7'));

1072: l_exceed_flag VARCHAR2 (1)
1073: := NVL (fnd_profile.VALUE ('OZF_COMM_BUDGET_EXCEED'), 'N');
1074: l_parent_flag VARCHAR2 (1)
1075: := NVL (fnd_profile.VALUE ('OZF_SOURCE_FROM_PARENT'), 'N');
1076: --l_recal_period NUMBER := TO_NUMBER (NVL (fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'), '7'));
1077: l_recal_period NUMBER := fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'); -- changed by feliu on 12/01/05
1078: l_max_committed NUMBER;
1079: l_commit BOOLEAN := TRUE;
1080: l_last_flag BOOLEAN := FALSE;

Line 1077: l_recal_period NUMBER := fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'); -- changed by feliu on 12/01/05

1073: := NVL (fnd_profile.VALUE ('OZF_COMM_BUDGET_EXCEED'), 'N');
1074: l_parent_flag VARCHAR2 (1)
1075: := NVL (fnd_profile.VALUE ('OZF_SOURCE_FROM_PARENT'), 'N');
1076: --l_recal_period NUMBER := TO_NUMBER (NVL (fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'), '7'));
1077: l_recal_period NUMBER := fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'); -- changed by feliu on 12/01/05
1078: l_max_committed NUMBER;
1079: l_commit BOOLEAN := TRUE;
1080: l_last_flag BOOLEAN := FALSE;
1081: l_remaining_amt NUMBER;

Line 1197: l_recal_flag := NVL (fnd_profile.VALUE ('OZF_BUDGET_ADJ_ALLOW_RECAL'), 'N');

1193: || 'start');
1194: END IF;
1195:
1196: -- get recalculating flag from profile
1197: l_recal_flag := NVL (fnd_profile.VALUE ('OZF_BUDGET_ADJ_ALLOW_RECAL'), 'N');
1198:
1199: IF G_DEBUG THEN
1200: ozf_utility_pvt.debug_message ( 'Recalculating flag: '|| l_recal_flag || ' l_parent_flag: ' || l_parent_flag ) ;
1201: END IF;

Line 2179: l_profile_value VARCHAR2(10) := NVL(FND_PROFILE.value('OZF_COMM_BUDGET_EXCEED'),'N');

2175: l_approved_in_currency VARCHAR2(30);
2176: l_act_budget_used_by VARCHAR2(30);
2177: l_msg_data VARCHAR2(30);
2178: l_act_budget_id NUMBER;
2179: l_profile_value VARCHAR2(10) := NVL(FND_PROFILE.value('OZF_COMM_BUDGET_EXCEED'),'N');
2180: l_message VARCHAR2(500);
2181: l_status_code VARCHAR2(30);
2182:
2183: -- getting the old budgets amount details ....