DBA Data[Home] [Help]

APPS.OKS_AVL_PVT dependencies on OKS_SERV_AVAILS

Line 36: -- FUNCTION get_rec for: OKS_SERV_AVAILS

32: null;
33: END api_copy;
34:
35: ---------------------------------------------------------------------------
36: -- FUNCTION get_rec for: OKS_SERV_AVAILS
37: ---------------------------------------------------------------------------
38: FUNCTION get_rec (
39: p_sav_rec IN sav_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN

Line 74: FROM Oks_Serv_Avails

70: ATTRIBUTE12,
71: ATTRIBUTE13,
72: ATTRIBUTE14,
73: ATTRIBUTE15
74: FROM Oks_Serv_Avails
75: WHERE oks_serv_avails.id = p_id;
76: l_sav_pk sav_pk_csr%ROWTYPE;
77: l_sav_rec sav_rec_type;
78: BEGIN

Line 75: WHERE oks_serv_avails.id = p_id;

71: ATTRIBUTE13,
72: ATTRIBUTE14,
73: ATTRIBUTE15
74: FROM Oks_Serv_Avails
75: WHERE oks_serv_avails.id = p_id;
76: l_sav_pk sav_pk_csr%ROWTYPE;
77: l_sav_rec sav_rec_type;
78: BEGIN
79: x_no_data_found := TRUE;

Line 126: -- FUNCTION get_rec for: OKS_SERV_AVAILS_V

122: BEGIN
123: RETURN(get_rec(p_sav_rec, l_row_notfound));
124: END get_rec;
125: ---------------------------------------------------------------------------
126: -- FUNCTION get_rec for: OKS_SERV_AVAILS_V
127: ---------------------------------------------------------------------------
128: FUNCTION get_rec (
129: p_savv_rec IN savv_rec_type,
130: x_no_data_found OUT NOCOPY BOOLEAN

Line 164: FROM Oks_Serv_Avails_V

160: ATTRIBUTE12,
161: ATTRIBUTE13,
162: ATTRIBUTE14,
163: ATTRIBUTE15
164: FROM Oks_Serv_Avails_V
165: WHERE oks_serv_avails_v.id = p_id;
166: l_oks_savv_pk oks_savv_pk_csr%ROWTYPE;
167: l_savv_rec savv_rec_type;
168: BEGIN

Line 165: WHERE oks_serv_avails_v.id = p_id;

161: ATTRIBUTE13,
162: ATTRIBUTE14,
163: ATTRIBUTE15
164: FROM Oks_Serv_Avails_V
165: WHERE oks_serv_avails_v.id = p_id;
166: l_oks_savv_pk oks_savv_pk_csr%ROWTYPE;
167: l_savv_rec savv_rec_type;
168: BEGIN
169: x_no_data_found := TRUE;

Line 217: -- FUNCTION null_out_defaults for: OKS_SERV_AVAILS_V --

213: RETURN(get_rec(p_savv_rec, l_row_notfound));
214: END get_rec;
215:
216: -------------------------------------------------------
217: -- FUNCTION null_out_defaults for: OKS_SERV_AVAILS_V --
218: -------------------------------------------------------
219: FUNCTION null_out_defaults (
220: p_savv_rec IN savv_rec_type
221: ) RETURN savv_rec_type IS

Line 377: p_view_name => 'OKS_SERV_AVAILS_V'

373:
374: -- call column length utility
375: OKC_UTIL.CHECK_LENGTH
376: (
377: p_view_name => 'OKS_SERV_AVAILS_V'
378: ,p_col_name => 'object1_id1'
379: ,p_col_value => P_object1_id1
380: ,x_return_status => l_return_status
381: );

Line 439: p_view_name => 'OKS_SERV_AVAILS_V'

435:
436: -- call column length utility
437: OKC_UTIL.CHECK_LENGTH
438: (
439: p_view_name => 'OKS_SERV_AVAILS_V'
440: ,p_col_name => 'object1_id2'
441: ,p_col_value => P_object1_id2
442: ,x_return_status => l_return_status
443: );

Line 499: p_view_name => 'OKS_SERV_AVAILS_V'

495: RAISE G_EXCEPTION_HALT_VALIDATION;
496: End If;
497: OKC_UTIL.CHECK_LENGTH
498: (
499: p_view_name => 'OKS_SERV_AVAILS_V'
500: ,p_col_name => 'object_version_number'
501: ,p_col_value => P_object_version_number
502: ,x_return_status => l_return_status
503: );

Line 557: p_view_name => 'OKS_SERV_AVAILS_V'

553: End If;
554: -- call column length utility
555: OKC_UTIL.CHECK_LENGTH
556: (
557: p_view_name => 'OKS_SERV_AVAILS_V'
558: ,p_col_name => 'general_yn'
559: ,p_col_value => P_general_yn
560: ,x_return_status => l_return_status
561: );

Line 619: p_view_name => 'OKS_SERV_AVAILS_V'

615: End If;
616: -- call column length utility
617: OKC_UTIL.CHECK_LENGTH
618: (
619: p_view_name => 'OKS_SERV_AVAILS_V'
620: ,p_col_name => 'except_object_type'
621: ,p_col_value => P_except_object_type
622: ,x_return_status => l_return_status
623: );

Line 702: p_view_name => 'OKS_SERV_AVAILS_V'

698:
699: -- call column length utility
700: OKC_UTIL.CHECK_LENGTH
701: (
702: p_view_name => 'OKS_SERV_AVAILS_V'
703: ,p_col_name => 'attribute_category'
704: ,p_col_value => p_attribute_category
705: ,x_return_status => l_return_status
706: );

Line 748: p_view_name => 'OKS_SERV_AVAILS_V'

744: x_return_status := OKC_API.G_RET_STS_SUCCESS;
745: -- call column length utility
746: OKC_UTIL.CHECK_LENGTH
747: (
748: p_view_name => 'OKS_SERV_AVAILS_V'
749: ,p_col_name => 'attribute1'
750: ,p_col_value => p_attribute1
751: ,x_return_status => l_return_status
752: );

Line 794: p_view_name => 'OKS_SERV_AVAILS_V'

790:
791: -- call column length utility
792: OKC_UTIL.CHECK_LENGTH
793: (
794: p_view_name => 'OKS_SERV_AVAILS_V'
795: ,p_col_name => 'attribute2'
796: ,p_col_value => p_attribute2
797: ,x_return_status => l_return_status
798: );

Line 841: p_view_name => 'OKS_SERV_AVAILS_V'

837: x_return_status := OKC_API.G_RET_STS_SUCCESS;
838: -- call column length utility
839: OKC_UTIL.CHECK_LENGTH
840: (
841: p_view_name => 'OKS_SERV_AVAILS_V'
842: ,p_col_name => 'attribute3'
843: ,p_col_value => p_attribute3
844: ,x_return_status => l_return_status
845: );

Line 887: p_view_name => 'OKS_SERV_AVAILS_V'

883:
884: -- call column length utility
885: OKC_UTIL.CHECK_LENGTH
886: (
887: p_view_name => 'OKS_SERV_AVAILS_V'
888: ,p_col_name => 'attribute4'
889: ,p_col_value => p_attribute4
890: ,x_return_status => l_return_status
891: );

Line 934: p_view_name => 'OKS_SERV_AVAILS_V'

930: x_return_status := OKC_API.G_RET_STS_SUCCESS;
931: -- call column length utility
932: OKC_UTIL.CHECK_LENGTH
933: (
934: p_view_name => 'OKS_SERV_AVAILS_V'
935: ,p_col_name => 'attribute5'
936: ,p_col_value => p_attribute5
937: ,x_return_status => l_return_status
938: );

Line 980: p_view_name => 'OKS_SERV_AVAILS_V'

976: x_return_status := OKC_API.G_RET_STS_SUCCESS;
977: -- call column length utility
978: OKC_UTIL.CHECK_LENGTH
979: (
980: p_view_name => 'OKS_SERV_AVAILS_V'
981: ,p_col_name => 'attribute6'
982: ,p_col_value => p_attribute6
983: ,x_return_status => l_return_status
984: );

Line 1026: p_view_name => 'OKS_SERV_AVAILS_V'

1022:
1023: -- call column length utility
1024: OKC_UTIL.CHECK_LENGTH
1025: (
1026: p_view_name => 'OKS_SERV_AVAILS_V'
1027: ,p_col_name => 'attribute7'
1028: ,p_col_value => p_attribute7
1029: ,x_return_status => l_return_status
1030: );

Line 1073: p_view_name => 'OKS_SERV_AVAILS_V'

1069: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1070: -- call column length utility
1071: OKC_UTIL.CHECK_LENGTH
1072: (
1073: p_view_name => 'OKS_SERV_AVAILS_V'
1074: ,p_col_name => 'attribute8'
1075: ,p_col_value => p_attribute8
1076: ,x_return_status => l_return_status
1077: );

Line 1119: p_view_name => 'OKS_SERV_AVAILS_V'

1115:
1116: -- call column length utility
1117: OKC_UTIL.CHECK_LENGTH
1118: (
1119: p_view_name => 'OKS_SERV_AVAILS_V'
1120: ,p_col_name => 'attribute9'
1121: ,p_col_value => p_attribute9
1122: ,x_return_status => l_return_status
1123: );

Line 1166: p_view_name => 'OKS_SERV_AVAILS_V'

1162: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1163: -- call column length utility
1164: OKC_UTIL.CHECK_LENGTH
1165: (
1166: p_view_name => 'OKS_SERV_AVAILS_V'
1167: ,p_col_name => 'attribute10'
1168: ,p_col_value => p_attribute10
1169: ,x_return_status => l_return_status
1170: );

Line 1212: p_view_name => 'OKS_SERV_AVAILS_V'

1208: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1209: -- call column length utility
1210: OKC_UTIL.CHECK_LENGTH
1211: (
1212: p_view_name => 'OKS_SERV_AVAILS_V'
1213: ,p_col_name => 'attribute11'
1214: ,p_col_value => p_attribute11
1215: ,x_return_status => l_return_status
1216: );

Line 1256: p_view_name => 'OKS_SERV_AVAILS_V'

1252: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1253: -- call column length utility
1254: OKC_UTIL.CHECK_LENGTH
1255: (
1256: p_view_name => 'OKS_SERV_AVAILS_V'
1257: ,p_col_name => 'attribute12'
1258: ,p_col_value => p_attribute12
1259: ,x_return_status => l_return_status
1260: );

Line 1302: p_view_name => 'OKS_SERV_AVAILS_V'

1298: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1299: -- call column length utility
1300: OKC_UTIL.CHECK_LENGTH
1301: (
1302: p_view_name => 'OKS_SERV_AVAILS_V'
1303: ,p_col_name => 'attribute13'
1304: ,p_col_value => p_attribute13
1305: ,x_return_status => l_return_status
1306: );

Line 1348: p_view_name => 'OKS_SERV_AVAILS_V'

1344:
1345: -- call column length utility
1346: OKC_UTIL.CHECK_LENGTH
1347: (
1348: p_view_name => 'OKS_SERV_AVAILS_V'
1349: ,p_col_name => 'attribute14'
1350: ,p_col_value => p_attribute14
1351: ,x_return_status => l_return_status
1352: );

Line 1395: p_view_name => 'OKS_SERV_AVAILS_V'

1391: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1392: -- call column length utility
1393: OKC_UTIL.CHECK_LENGTH
1394: (
1395: p_view_name => 'OKS_SERV_AVAILS_V'
1396: ,p_col_name => 'attribute15'
1397: ,p_col_value => p_attribute15
1398: ,x_return_status => l_return_status
1399: );

Line 1434: -- Validate_Attributes for:OKS_SERV_AVAILS_V --

1430: END validate_attribute15;
1431:
1432:
1433: -----------------------------------------------
1434: -- Validate_Attributes for:OKS_SERV_AVAILS_V --
1435: -----------------------------------------------
1436: FUNCTION Validate_Attributes (
1437: p_savv_rec IN savv_rec_type
1438: )

Line 1446: OKC_UTIL.ADD_VIEW('OKS_SERV_AVAILS_V',x_return_status);

1442:
1443: Begin
1444: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1445:
1446: OKC_UTIL.ADD_VIEW('OKS_SERV_AVAILS_V',x_return_status);
1447:
1448: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1449: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1450: -- need to leave

Line 1889: -- Validate_Attributes for:OKS_SERV_AVAILS_V --

1885:
1886:
1887: /*
1888: -----------------------------------------------
1889: -- Validate_Attributes for:OKS_SERV_AVAILS_V --
1890: -----------------------------------------------
1891: FUNCTION Validate_Attributes (
1892: p_savv_rec IN savv_rec_type
1893: ) RETURN VARCHAR2 IS

Line 1925: -- Validate_Record for:OKS_SERV_AVAILS_V --

1921: ---------------------------------------------------------------------------
1922: -- PROCEDURE Validate_Record
1923: ---------------------------------------------------------------------------
1924: -------------------------------------------
1925: -- Validate_Record for:OKS_SERV_AVAILS_V --
1926: -------------------------------------------
1927: FUNCTION Validate_Record (
1928: p_savv_rec IN savv_rec_type
1929: ) RETURN VARCHAR2 IS

Line 2015: -- validate_row for:OKS_SERV_AVAILS_V --

2011: ---------------------------------------------------------------------------
2012: -- PROCEDURE validate_row
2013: ---------------------------------------------------------------------------
2014: ----------------------------------------
2015: -- validate_row for:OKS_SERV_AVAILS_V --
2016: ----------------------------------------
2017: PROCEDURE validate_row(
2018: p_api_version IN NUMBER,
2019: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2165: -- insert_row for:OKS_SERV_AVAILS --

2161: ---------------------------------------------------------------------------
2162: -- PROCEDURE insert_row
2163: ---------------------------------------------------------------------------
2164: ------------------------------------
2165: -- insert_row for:OKS_SERV_AVAILS --
2166: ------------------------------------
2167: PROCEDURE insert_row(
2168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2169: x_return_status OUT NOCOPY VARCHAR2,

Line 2181: -- Set_Attributes for:OKS_SERV_AVAILS --

2177: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2178: l_sav_rec sav_rec_type := p_sav_rec;
2179: l_def_sav_rec sav_rec_type;
2180: ----------------------------------------
2181: -- Set_Attributes for:OKS_SERV_AVAILS --
2182: ----------------------------------------
2183:
2184: FUNCTION Set_Attributes (
2185: p_sav_rec IN sav_rec_type,

Line 2216: INSERT INTO OKS_SERV_AVAILS(

2212: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2213: RAISE OKC_API.G_EXCEPTION_ERROR;
2214: END IF;
2215:
2216: INSERT INTO OKS_SERV_AVAILS(
2217: id,
2218: object1_id1,
2219: object1_id2,
2220: JTOT_OBJECT1_CODE,

Line 2316: -- insert_row for:OKS_SERV_AVAILS_V --

2312: '_PVT'
2313: );
2314: END insert_row;
2315: --------------------------------------
2316: -- insert_row for:OKS_SERV_AVAILS_V --
2317: --------------------------------------
2318: PROCEDURE insert_row(
2319: p_api_version IN NUMBER,
2320: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2350: -- Set_Attributes for:OKS_SERV_AVAILS_V --

2346: l_savv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2347: RETURN(l_savv_rec);
2348: END fill_who_columns;
2349: ------------------------------------------
2350: -- Set_Attributes for:OKS_SERV_AVAILS_V --
2351: ------------------------------------------
2352: FUNCTION Set_Attributes (
2353: p_savv_rec IN savv_rec_type,
2354: x_savv_rec OUT NOCOPY savv_rec_type

Line 2541: -- lock_row for:OKS_SERV_AVAILS --

2537: ---------------------------------------------------------------------------
2538: -- PROCEDURE lock_row
2539: ---------------------------------------------------------------------------
2540: ----------------------------------
2541: -- lock_row for:OKS_SERV_AVAILS --
2542: ----------------------------------
2543: PROCEDURE lock_row(
2544: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2545: x_return_status OUT NOCOPY VARCHAR2,

Line 2554: FROM OKS_SERV_AVAILS

2550: E_Resource_Busy EXCEPTION;
2551: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2552: CURSOR lock_csr (p_sav_rec IN sav_rec_type) IS
2553: SELECT OBJECT_VERSION_NUMBER
2554: FROM OKS_SERV_AVAILS
2555: WHERE ID = p_sav_rec.id
2556: AND OBJECT_VERSION_NUMBER = p_sav_rec.object_version_number
2557: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2558:

Line 2561: FROM OKS_SERV_AVAILS

2557: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2558:
2559: CURSOR lchk_csr (p_sav_rec IN sav_rec_type) IS
2560: SELECT OBJECT_VERSION_NUMBER
2561: FROM OKS_SERV_AVAILS
2562: WHERE ID = p_sav_rec.id;
2563: l_api_version CONSTANT NUMBER := 1;
2564: l_api_name CONSTANT VARCHAR2(30) := 'AVAILS_lock_row';
2565: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2566: l_object_version_number OKS_SERV_AVAILS.OBJECT_VERSION_NUMBER%TYPE;

2562: WHERE ID = p_sav_rec.id;
2563: l_api_version CONSTANT NUMBER := 1;
2564: l_api_name CONSTANT VARCHAR2(30) := 'AVAILS_lock_row';
2565: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2566: l_object_version_number OKS_SERV_AVAILS.OBJECT_VERSION_NUMBER%TYPE;
2567: lc_object_version_number OKS_SERV_AVAILS.OBJECT_VERSION_NUMBER%TYPE;
2568: l_row_notfound BOOLEAN := FALSE;
2569: lc_row_notfound BOOLEAN := FALSE;
2570: BEGIN

Line 2567: lc_object_version_number OKS_SERV_AVAILS.OBJECT_VERSION_NUMBER%TYPE;

2563: l_api_version CONSTANT NUMBER := 1;
2564: l_api_name CONSTANT VARCHAR2(30) := 'AVAILS_lock_row';
2565: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2566: l_object_version_number OKS_SERV_AVAILS.OBJECT_VERSION_NUMBER%TYPE;
2567: lc_object_version_number OKS_SERV_AVAILS.OBJECT_VERSION_NUMBER%TYPE;
2568: l_row_notfound BOOLEAN := FALSE;
2569: lc_row_notfound BOOLEAN := FALSE;
2570: BEGIN
2571: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2647: -- lock_row for:OKS_SERV_AVAILS_V --

2643: '_PVT'
2644: );
2645: END lock_row;
2646: ------------------------------------
2647: -- lock_row for:OKS_SERV_AVAILS_V --
2648: ------------------------------------
2649: PROCEDURE lock_row(
2650: p_api_version IN NUMBER,
2651: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2795: -- update_row for:OKS_SERV_AVAILS --

2791: ---------------------------------------------------------------------------
2792: -- PROCEDURE update_row
2793: ---------------------------------------------------------------------------
2794: ------------------------------------
2795: -- update_row for:OKS_SERV_AVAILS --
2796: ------------------------------------
2797: PROCEDURE update_row(
2798: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2799: x_return_status OUT NOCOPY VARCHAR2,

Line 2951: -- Set_Attributes for:OKS_SERV_AVAILS --

2947: END IF;
2948: RETURN(l_return_status);
2949: END populate_new_record;
2950: ----------------------------------------
2951: -- Set_Attributes for:OKS_SERV_AVAILS --
2952: ----------------------------------------
2953: FUNCTION Set_Attributes (
2954: p_sav_rec IN sav_rec_type,
2955: x_sav_rec OUT NOCOPY sav_rec_type

Line 2988: UPDATE OKS_SERV_AVAILS

2984: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2985: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2986: RAISE OKC_API.G_EXCEPTION_ERROR;
2987: END IF;
2988: UPDATE OKS_SERV_AVAILS
2989: SET OBJECT1_ID1 = l_def_sav_rec.object1_id1,
2990: OBJECT1_ID2 = l_def_sav_rec.object1_id2,
2991: JTOT_OBJECT1_CODE = l_def_sav_rec.JTOT_OBJECT1_CODE,
2992: OBJECT_VERSION_NUMBER = l_def_sav_rec.object_version_number,

Line 3056: -- update_row for:OKS_SERV_AVAILS_V --

3052: '_PVT'
3053: );
3054: END update_row;
3055: --------------------------------------
3056: -- update_row for:OKS_SERV_AVAILS_V --
3057: --------------------------------------
3058: PROCEDURE update_row(
3059: p_api_version IN NUMBER,
3060: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3227: -- Set_Attributes for:OKS_SERV_AVAILS_V --

3223: END IF;
3224: RETURN(l_return_status);
3225: END populate_new_record;
3226: ------------------------------------------
3227: -- Set_Attributes for:OKS_SERV_AVAILS_V --
3228: ------------------------------------------
3229:
3230: FUNCTION Set_Attributes (
3231: p_savv_rec IN savv_rec_type,

Line 3411: -- delete_row for:OKS_SERV_AVAILS --

3407: ---------------------------------------------------------------------------
3408: -- PROCEDURE delete_row
3409: ---------------------------------------------------------------------------
3410: ------------------------------------
3411: -- delete_row for:OKS_SERV_AVAILS --
3412: ------------------------------------
3413: PROCEDURE delete_row(
3414: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3415: x_return_status OUT NOCOPY VARCHAR2,

Line 3435: DELETE FROM OKS_SERV_AVAILS

3431: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3432: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3433: RAISE OKC_API.G_EXCEPTION_ERROR;
3434: END IF;
3435: DELETE FROM OKS_SERV_AVAILS
3436: WHERE ID = l_sav_rec.id;
3437:
3438: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3439: EXCEPTION

Line 3472: -- delete_row for:OKS_SERV_AVAILS_V --

3468: '_PVT'
3469: );
3470: END delete_row;
3471: --------------------------------------
3472: -- delete_row for:OKS_SERV_AVAILS_V --
3473: --------------------------------------
3474: PROCEDURE delete_row(
3475: p_api_version IN NUMBER,
3476: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3699: OKS_SERV_AVAILS

3695: i:=p_savv_tbl.next(i);
3696: END LOOP;
3697: FORALL i in 1..l_tabsize
3698: Insert into
3699: OKS_SERV_AVAILS
3700: (
3701: id
3702: , object1_id1
3703: , object1_id2