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 128: l_has_Grace_date VARCHAR2(1) := NVL(fnd_profile.VALUE('OZF_HAS_GRACE_PERIOD'), 'N');

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

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

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

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

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

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

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

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

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

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

1056: l_fund_curr_req_amount NUMBER;
1057: l_forecast_tbl forecast_tbl_type;
1058:
1059: l_exceed_flag VARCHAR2 (1)
1060: := NVL (fnd_profile.VALUE ('OZF_COMM_BUDGET_EXCEED'), 'N');
1061: l_parent_flag VARCHAR2 (1)
1062: := NVL (fnd_profile.VALUE ('OZF_SOURCE_FROM_PARENT'), 'N');
1063: --l_recal_period NUMBER := TO_NUMBER (NVL (fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'), '7'));
1064: l_recal_period NUMBER := fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'); -- changed by feliu on 12/01/05

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

1058:
1059: l_exceed_flag VARCHAR2 (1)
1060: := NVL (fnd_profile.VALUE ('OZF_COMM_BUDGET_EXCEED'), 'N');
1061: l_parent_flag VARCHAR2 (1)
1062: := NVL (fnd_profile.VALUE ('OZF_SOURCE_FROM_PARENT'), 'N');
1063: --l_recal_period NUMBER := TO_NUMBER (NVL (fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'), '7'));
1064: l_recal_period NUMBER := fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'); -- changed by feliu on 12/01/05
1065: l_max_committed NUMBER;
1066: l_commit BOOLEAN := TRUE;

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

1059: l_exceed_flag VARCHAR2 (1)
1060: := NVL (fnd_profile.VALUE ('OZF_COMM_BUDGET_EXCEED'), 'N');
1061: l_parent_flag VARCHAR2 (1)
1062: := NVL (fnd_profile.VALUE ('OZF_SOURCE_FROM_PARENT'), 'N');
1063: --l_recal_period NUMBER := TO_NUMBER (NVL (fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'), '7'));
1064: l_recal_period NUMBER := fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'); -- changed by feliu on 12/01/05
1065: l_max_committed NUMBER;
1066: l_commit BOOLEAN := TRUE;
1067: l_last_flag BOOLEAN := FALSE;

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

1060: := NVL (fnd_profile.VALUE ('OZF_COMM_BUDGET_EXCEED'), 'N');
1061: l_parent_flag VARCHAR2 (1)
1062: := NVL (fnd_profile.VALUE ('OZF_SOURCE_FROM_PARENT'), 'N');
1063: --l_recal_period NUMBER := TO_NUMBER (NVL (fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'), '7'));
1064: l_recal_period NUMBER := fnd_profile.VALUE ('OZF_BUDGET_ADJ_RECAL_PERIOD'); -- changed by feliu on 12/01/05
1065: l_max_committed NUMBER;
1066: l_commit BOOLEAN := TRUE;
1067: l_last_flag BOOLEAN := FALSE;
1068: l_remaining_amt NUMBER;

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

1180: || 'start');
1181: END IF;
1182:
1183: -- get recalculating flag from profile
1184: l_recal_flag := NVL (fnd_profile.VALUE ('OZF_BUDGET_ADJ_ALLOW_RECAL'), 'N');
1185:
1186: IF G_DEBUG THEN
1187: ozf_utility_pvt.debug_message ( 'Recalculating flag: '|| l_recal_flag || ' l_parent_flag: ' || l_parent_flag ) ;
1188: END IF;

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

2127: l_approved_in_currency VARCHAR2(30);
2128: l_act_budget_used_by VARCHAR2(30);
2129: l_msg_data VARCHAR2(30);
2130: l_act_budget_id NUMBER;
2131: l_profile_value VARCHAR2(10) := NVL(FND_PROFILE.value('OZF_COMM_BUDGET_EXCEED'),'N');
2132: l_message VARCHAR2(500);
2133: l_status_code VARCHAR2(30);
2134:
2135: -- getting the old budgets amount details ....