APPS.OZF_ACCTNG_EVENTS_PVT dependencies on OZF_ACCTNG_EVENTS_ALL

Line 47: SELECT OZF_ACCTNG_EVENTS_ALL_s.NEXTVAL

43: l_ACCOUNTING_EVENT_ID NUMBER;
44: l_dummy NUMBER;
45:
46: CURSOR c_id IS
47: SELECT OZF_ACCTNG_EVENTS_ALL_s.NEXTVAL
48: FROM dual;
49:
50: CURSOR c_id_exists (l_id IN NUMBER) IS
51: SELECT count(accounting_event_id) FROM OZF_ACCTNG_EVENTS_ALL

Line 51: SELECT count(accounting_event_id) FROM OZF_ACCTNG_EVENTS_ALL

47: SELECT OZF_ACCTNG_EVENTS_ALL_s.NEXTVAL
48: FROM dual;
49:
50: CURSOR c_id_exists (l_id IN NUMBER) IS
51: SELECT count(accounting_event_id) FROM OZF_ACCTNG_EVENTS_ALL
52: WHERE ACCOUNTING_EVENT_ID = l_id;
53:
54: BEGIN
55: -- Standard Start of API savepoint

Line 253: FROM OZF_ACCTNG_EVENTS_ALL

249: IS
250:
251: CURSOR c_get_acctng_events(p_accounting_event_id NUMBER) IS
252: SELECT *
253: FROM OZF_ACCTNG_EVENTS_ALL
254: WHERE accounting_event_id = p_accounting_event_id;
255:
256: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Acctng_Events';
257: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 591: FROM OZF_ACCTNG_EVENTS_ALL

587: l_ACCOUNTING_EVENT_ID NUMBER;
588:
589: CURSOR c_Acctng_Events IS
590: SELECT ACCOUNTING_EVENT_ID
591: FROM OZF_ACCTNG_EVENTS_ALL
592: WHERE ACCOUNTING_EVENT_ID = p_ACCOUNTING_EVENT_ID
593: AND object_version_number = p_object_version
594: FOR UPDATE NOWAIT;
595:

Line 704: 'OZF_ACCTNG_EVENTS_ALL',

700: BEGIN
701: x_return_status := FND_API.g_ret_sts_success;
702: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
703: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
704: 'OZF_ACCTNG_EVENTS_ALL',
705: 'ACCOUNTING_EVENT_ID = ''' || p_acctng_event_rec.ACCOUNTING_EVENT_ID ||''''
706: );
707: ELSE
708: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 709: 'OZF_ACCTNG_EVENTS_ALL',

705: 'ACCOUNTING_EVENT_ID = ''' || p_acctng_event_rec.ACCOUNTING_EVENT_ID ||''''
706: );
707: ELSE
708: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
709: 'OZF_ACCTNG_EVENTS_ALL',
710: 'ACCOUNTING_EVENT_ID = ''' || p_acctng_event_rec.ACCOUNTING_EVENT_ID ||
711: ''' AND ACCOUNTING_EVENT_ID <> ' || p_acctng_event_rec.ACCOUNTING_EVENT_ID
712: );
713: END IF;

Line 970: FROM ozf_acctng_events_all

966: l_return_status VARCHAR2(1);
967:
968: CURSOR c_complete IS
969: SELECT *
970: FROM ozf_acctng_events_all
971: WHERE accounting_event_id = p_acctng_event_rec.accounting_event_id;
972: l_acctng_event_rec c_complete%ROWTYPE;
973: BEGIN
974: x_complete_rec := p_acctng_event_rec;