APPS.OZF_AE_LINE_PVT dependencies on OZF_AE_LINES_ALL

Line 44: SELECT OZF_AE_LINES_ALL_s.NEXTVAL

40: l_AE_LINE_ID NUMBER;
41: l_dummy NUMBER;
42:
43: CURSOR c_id IS
44: SELECT OZF_AE_LINES_ALL_s.NEXTVAL
45: FROM dual;
46:
47: CURSOR c_id_exists (l_id IN NUMBER) IS
48: SELECT count(ae_line_id) FROM OZF_AE_LINES_ALL

Line 48: SELECT count(ae_line_id) FROM OZF_AE_LINES_ALL

44: SELECT OZF_AE_LINES_ALL_s.NEXTVAL
45: FROM dual;
46:
47: CURSOR c_id_exists (l_id IN NUMBER) IS
48: SELECT count(ae_line_id) FROM OZF_AE_LINES_ALL
49: WHERE AE_LINE_ID = l_id;
50:
51: BEGIN
52: -- Standard Start of API savepoint

Line 304: FROM OZF_AE_LINES_ALL

300: IS
301:
302: CURSOR c_get_ae_line(p_ae_line_id NUMBER) IS
303: SELECT *
304: FROM OZF_AE_LINES_ALL
305: WHERE ae_line_id = p_ae_line_id;
306:
307: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Ae_Line';
308: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 681: FROM OZF_AE_LINES_ALL

677: l_AE_LINE_ID NUMBER;
678:
679: CURSOR c_Ae_Line IS
680: SELECT AE_LINE_ID
681: FROM OZF_AE_LINES_ALL
682: WHERE AE_LINE_ID = p_AE_LINE_ID
683: AND object_version_number = p_object_version
684: FOR UPDATE NOWAIT;
685:

Line 794: 'OZF_AE_LINES_ALL',

790: BEGIN
791: x_return_status := FND_API.g_ret_sts_success;
792: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
793: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
794: 'OZF_AE_LINES_ALL',
795: 'AE_LINE_ID = ''' || p_ae_line_rec.AE_LINE_ID ||''''
796: );
797: ELSE
798: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 799: 'OZF_AE_LINES_ALL',

795: 'AE_LINE_ID = ''' || p_ae_line_rec.AE_LINE_ID ||''''
796: );
797: ELSE
798: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
799: 'OZF_AE_LINES_ALL',
800: 'AE_LINE_ID = ''' || p_ae_line_rec.AE_LINE_ID ||
801: ''' AND AE_LINE_ID <> ' || p_ae_line_rec.AE_LINE_ID
802: );
803: END IF;

Line 1074: FROM ozf_ae_lines_all

1070: l_return_status VARCHAR2(1);
1071:
1072: CURSOR c_complete IS
1073: SELECT *
1074: FROM ozf_ae_lines_all
1075: WHERE ae_line_id = p_ae_line_rec.ae_line_id;
1076: l_ae_line_rec c_complete%ROWTYPE;
1077: BEGIN
1078: x_complete_rec := p_ae_line_rec;