APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_NA_CONC_EXCEPTIONS

Line 1312: SELECT ozf_na_conc_exceptions_s.NEXTVAL

1308: PROCEDURE log_exception(p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1309: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type)
1310: IS
1311: CURSOR c_na_conc_exception_id IS
1312: SELECT ozf_na_conc_exceptions_s.NEXTVAL
1313: FROM DUAL;
1314:
1315: CURSOR c_pk_exist(p_na_conc_exception_id NUMBER) IS
1316: SELECT 1

Line 1319: FROM ozf_na_conc_exceptions

1315: CURSOR c_pk_exist(p_na_conc_exception_id NUMBER) IS
1316: SELECT 1
1317: FROM DUAL
1318: WHERE EXISTS (SELECT 1
1319: FROM ozf_na_conc_exceptions
1320: WHERE na_conc_exception_id = p_na_conc_exception_id);
1321:
1322: l_na_conc_exception_id NUMBER;
1323: l_pk_exist NUMBER;

Line 1340: INSERT INTO ozf_na_conc_exceptions(na_conc_exception_id

1336:
1337: EXIT WHEN l_pk_exist IS NULL;
1338: END LOOP;
1339:
1340: INSERT INTO ozf_na_conc_exceptions(na_conc_exception_id
1341: ,act_budget_used_by_id
1342: ,arc_act_budget_used_by
1343: ,budget_source_type
1344: ,budget_source_id

Line 1403: FROM ozf_na_conc_exceptions;

1399: PROCEDURE process_exceptions IS
1400:
1401: CURSOR c_exception_rec IS
1402: SELECT *
1403: FROM ozf_na_conc_exceptions;
1404:
1405: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1406: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1407: l_return_status VARCHAR2(1);

Line 1473: DELETE FROM ozf_na_conc_exceptions

1469:
1470: IF l_return_status = FND_API.g_ret_sts_success
1471: THEN
1472: --
1473: DELETE FROM ozf_na_conc_exceptions
1474: WHERE na_conc_exception_id = l_exception_rec.na_conc_exception_id;
1475: --
1476: END IF;
1477: l_utilized_amount := 0;