5: -- Description : Record to hold the attributes of the document associations
6:
7: TYPE association_rec IS RECORD
8: (
9: DOC_TITLE_ASSO_ID NUMBER := FND_API.G_MISS_NUM,
10: DOCUMENT_ID NUMBER := FND_API.G_MISS_NUM,
11: DOC_REVISION_ID NUMBER := FND_API.G_MISS_NUM,
12: USE_LATEST_REV_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
13: ASO_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
6:
7: TYPE association_rec IS RECORD
8: (
9: DOC_TITLE_ASSO_ID NUMBER := FND_API.G_MISS_NUM,
10: DOCUMENT_ID NUMBER := FND_API.G_MISS_NUM,
11: DOC_REVISION_ID NUMBER := FND_API.G_MISS_NUM,
12: USE_LATEST_REV_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
13: ASO_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: ASO_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
7: TYPE association_rec IS RECORD
8: (
9: DOC_TITLE_ASSO_ID NUMBER := FND_API.G_MISS_NUM,
10: DOCUMENT_ID NUMBER := FND_API.G_MISS_NUM,
11: DOC_REVISION_ID NUMBER := FND_API.G_MISS_NUM,
12: USE_LATEST_REV_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
13: ASO_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: ASO_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
15: SERIAL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
8: (
9: DOC_TITLE_ASSO_ID NUMBER := FND_API.G_MISS_NUM,
10: DOCUMENT_ID NUMBER := FND_API.G_MISS_NUM,
11: DOC_REVISION_ID NUMBER := FND_API.G_MISS_NUM,
12: USE_LATEST_REV_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
13: ASO_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: ASO_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
15: SERIAL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR,
9: DOC_TITLE_ASSO_ID NUMBER := FND_API.G_MISS_NUM,
10: DOCUMENT_ID NUMBER := FND_API.G_MISS_NUM,
11: DOC_REVISION_ID NUMBER := FND_API.G_MISS_NUM,
12: USE_LATEST_REV_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
13: ASO_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: ASO_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
15: SERIAL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR,
17: LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR,
10: DOCUMENT_ID NUMBER := FND_API.G_MISS_NUM,
11: DOC_REVISION_ID NUMBER := FND_API.G_MISS_NUM,
12: USE_LATEST_REV_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
13: ASO_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: ASO_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
15: SERIAL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR,
17: LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR,
18: CHAPTER VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: DOC_REVISION_ID NUMBER := FND_API.G_MISS_NUM,
12: USE_LATEST_REV_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
13: ASO_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: ASO_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
15: SERIAL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR,
17: LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR,
18: CHAPTER VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: SECTION VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: USE_LATEST_REV_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
13: ASO_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: ASO_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
15: SERIAL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR,
17: LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR,
18: CHAPTER VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: SECTION VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: SUBJECT VARCHAR2(240) := FND_API.G_MISS_CHAR,
13: ASO_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14: ASO_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
15: SERIAL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR,
17: LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR,
18: CHAPTER VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: SECTION VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: SUBJECT VARCHAR2(240) := FND_API.G_MISS_CHAR,
21: PAGE VARCHAR2(5) := FND_API.G_MISS_CHAR,
14: ASO_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
15: SERIAL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR,
17: LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR,
18: CHAPTER VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: SECTION VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: SUBJECT VARCHAR2(240) := FND_API.G_MISS_CHAR,
21: PAGE VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: FIGURE VARCHAR2(30) := FND_API.G_MISS_CHAR,
15: SERIAL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
16: SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR,
17: LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR,
18: CHAPTER VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: SECTION VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: SUBJECT VARCHAR2(240) := FND_API.G_MISS_CHAR,
21: PAGE VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: FIGURE VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
16: SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR,
17: LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR,
18: CHAPTER VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: SECTION VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: SUBJECT VARCHAR2(240) := FND_API.G_MISS_CHAR,
21: PAGE VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: FIGURE VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
24: SOURCE_REF_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
17: LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR,
18: CHAPTER VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: SECTION VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: SUBJECT VARCHAR2(240) := FND_API.G_MISS_CHAR,
21: PAGE VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: FIGURE VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
24: SOURCE_REF_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
18: CHAPTER VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: SECTION VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: SUBJECT VARCHAR2(240) := FND_API.G_MISS_CHAR,
21: PAGE VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: FIGURE VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
24: SOURCE_REF_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
26: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: SECTION VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: SUBJECT VARCHAR2(240) := FND_API.G_MISS_CHAR,
21: PAGE VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: FIGURE VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
24: SOURCE_REF_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
26: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: SUBJECT VARCHAR2(240) := FND_API.G_MISS_CHAR,
21: PAGE VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: FIGURE VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
24: SOURCE_REF_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
26: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: PAGE VARCHAR2(5) := FND_API.G_MISS_CHAR,
22: FIGURE VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
24: SOURCE_REF_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
26: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: FIGURE VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
24: SOURCE_REF_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
26: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
24: SOURCE_REF_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
26: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: SOURCE_REF_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
26: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
26: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: DELETE_FLAG VARCHAR2(1) := 'N'
35: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: DELETE_FLAG VARCHAR2(1) := 'N'
43: );
36: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: DELETE_FLAG VARCHAR2(1) := 'N'
43: );
44:
37: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: DELETE_FLAG VARCHAR2(1) := 'N'
43: );
44:
45: --Declare table type
48: -- Procedure to create association record
49: PROCEDURE CREATE_ASSOCIATION
50: (
51: p_api_version IN NUMBER := 1.0 ,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
54: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_x_association_tbl IN OUT NOCOPY association_tbl ,
49: PROCEDURE CREATE_ASSOCIATION
50: (
51: p_api_version IN NUMBER := 1.0 ,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
54: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_x_association_tbl IN OUT NOCOPY association_tbl ,
57: x_return_status OUT NOCOPY VARCHAR2 ,
50: (
51: p_api_version IN NUMBER := 1.0 ,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
54: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_x_association_tbl IN OUT NOCOPY association_tbl ,
57: x_return_status OUT NOCOPY VARCHAR2 ,
58: x_msg_count OUT NOCOPY NUMBER ,
51: p_api_version IN NUMBER := 1.0 ,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
54: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_x_association_tbl IN OUT NOCOPY association_tbl ,
57: x_return_status OUT NOCOPY VARCHAR2 ,
58: x_msg_count OUT NOCOPY NUMBER ,
59: x_msg_data OUT NOCOPY VARCHAR2);
61: --Procedure to update, removes association record
62: PROCEDURE MODIFY_ASSOCIATION
63: (
64: p_api_version IN NUMBER := 1.0 ,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
67: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: p_x_association_tbl IN OUT NOCOPY association_tbl ,
62: PROCEDURE MODIFY_ASSOCIATION
63: (
64: p_api_version IN NUMBER := 1.0 ,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
67: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: p_x_association_tbl IN OUT NOCOPY association_tbl ,
70: x_return_status OUT NOCOPY VARCHAR2 ,
63: (
64: p_api_version IN NUMBER := 1.0 ,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
67: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: p_x_association_tbl IN OUT NOCOPY association_tbl ,
70: x_return_status OUT NOCOPY VARCHAR2 ,
71: x_msg_count OUT NOCOPY NUMBER ,
64: p_api_version IN NUMBER := 1.0 ,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
67: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: p_x_association_tbl IN OUT NOCOPY association_tbl ,
70: x_return_status OUT NOCOPY VARCHAR2 ,
71: x_msg_count OUT NOCOPY NUMBER ,
72: x_msg_data OUT NOCOPY VARCHAR2);
74: --Procedure to copy new association record
75: Procedure COPY_ASSOCIATION
76: (
77: p_api_version IN NUMBER := 1.0 ,
78: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
79: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
80: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
81: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
82: p_from_object_id IN NUMBER,
75: Procedure COPY_ASSOCIATION
76: (
77: p_api_version IN NUMBER := 1.0 ,
78: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
79: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
80: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
81: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
82: p_from_object_id IN NUMBER,
83: p_from_object_type IN VARCHAR2,
76: (
77: p_api_version IN NUMBER := 1.0 ,
78: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
79: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
80: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
81: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
82: p_from_object_id IN NUMBER,
83: p_from_object_type IN VARCHAR2,
84: p_to_object_id IN NUMBER,
77: p_api_version IN NUMBER := 1.0 ,
78: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
79: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
80: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
81: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
82: p_from_object_id IN NUMBER,
83: p_from_object_type IN VARCHAR2,
84: p_to_object_id IN NUMBER,
85: p_to_object_type IN VARCHAR2,