APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_NA_CONC_EXCEPTIONS

Line 1215: SELECT ozf_na_conc_exceptions_s.NEXTVAL

1211: PROCEDURE log_exception(p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1212: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type)
1213: IS
1214: CURSOR c_na_conc_exception_id IS
1215: SELECT ozf_na_conc_exceptions_s.NEXTVAL
1216: FROM DUAL;
1217:
1218: CURSOR c_pk_exist(p_na_conc_exception_id NUMBER) IS
1219: SELECT 1

Line 1222: FROM ozf_na_conc_exceptions

1218: CURSOR c_pk_exist(p_na_conc_exception_id NUMBER) IS
1219: SELECT 1
1220: FROM DUAL
1221: WHERE EXISTS (SELECT 1
1222: FROM ozf_na_conc_exceptions
1223: WHERE na_conc_exception_id = p_na_conc_exception_id);
1224:
1225: l_na_conc_exception_id NUMBER;
1226: l_pk_exist NUMBER;

Line 1243: INSERT INTO ozf_na_conc_exceptions(na_conc_exception_id

1239:
1240: EXIT WHEN l_pk_exist IS NULL;
1241: END LOOP;
1242:
1243: INSERT INTO ozf_na_conc_exceptions(na_conc_exception_id
1244: ,act_budget_used_by_id
1245: ,arc_act_budget_used_by
1246: ,budget_source_type
1247: ,budget_source_id

Line 1306: FROM ozf_na_conc_exceptions;

1302: PROCEDURE process_exceptions IS
1303:
1304: CURSOR c_exception_rec IS
1305: SELECT *
1306: FROM ozf_na_conc_exceptions;
1307:
1308: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1309: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1310: l_return_status VARCHAR2(1);

Line 1376: DELETE FROM ozf_na_conc_exceptions

1372:
1373: IF l_return_status = FND_API.g_ret_sts_success
1374: THEN
1375: --
1376: DELETE FROM ozf_na_conc_exceptions
1377: WHERE na_conc_exception_id = l_exception_rec.na_conc_exception_id;
1378: --
1379: END IF;
1380: l_utilized_amount := 0;