DBA Data[Home] [Help]

APPS.AHL_DI_ASSO_DOC_ASO_PVT dependencies on FND_API

Line 9: DOC_TITLE_ASSO_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 10: DOCUMENT_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 11: DOC_REVISION_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,

Line 12: USE_LATEST_REV_FLAG VARCHAR2(1) := 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,

Line 13: ASO_OBJECT_TYPE_CODE VARCHAR2(30) := 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,

Line 14: ASO_OBJECT_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,
18: CHAPTER VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 15: SERIAL_NO 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,

Line 16: SOURCE_LANG VARCHAR2(4) := 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,

Line 17: LANGUAGE VARCHAR2(4) := 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,

Line 18: CHAPTER 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,
22: FIGURE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 19: SECTION 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,

Line 20: SUBJECT VARCHAR2(240) := 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,

Line 21: PAGE VARCHAR2(5) := 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,

Line 22: FIGURE VARCHAR2(30) := 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,
26: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 23: NOTE VARCHAR2(2000) := 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,

Line 24: SOURCE_REF_CODE 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,
28: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 25: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,

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,

Line 26: ATTRIBUTE_CATEGORY VARCHAR2(30) := 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,

Line 27: ATTRIBUTE1 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,

Line 28: ATTRIBUTE2 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,

Line 29: ATTRIBUTE3 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,

Line 30: ATTRIBUTE4 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,

Line 31: ATTRIBUTE5 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,

Line 32: ATTRIBUTE6 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,

Line 33: ATTRIBUTE7 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,

Line 34: ATTRIBUTE8 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,

Line 35: ATTRIBUTE9 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,

Line 36: ATTRIBUTE10 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,

Line 37: ATTRIBUTE11 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,

Line 38: ATTRIBUTE12 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'

Line 39: ATTRIBUTE13 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'
43: );

Line 40: ATTRIBUTE14 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: );
44:

Line 41: ATTRIBUTE15 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:
45: --Declare table type

Line 52: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

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 ,

Line 53: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 54: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,

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 ,

Line 55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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);

Line 65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

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 ,

Line 66: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

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 ,

Line 67: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,

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 ,

Line 68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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);

Line 78: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,

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,

Line 79: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,

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,

Line 80: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,

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,

Line 81: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

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,