9:
10: /*
11: TYPE Qte_Access_Rec_Type IS RECORD
12: (
13: ACCESS_ID NUMBER := FND_API.G_MISS_NUM,
14: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
15: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
16: RESOURCE_GRP_ID NUMBER := FND_API.G_MISS_NUM,
17: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
10: /*
11: TYPE Qte_Access_Rec_Type IS RECORD
12: (
13: ACCESS_ID NUMBER := FND_API.G_MISS_NUM,
14: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
15: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
16: RESOURCE_GRP_ID NUMBER := FND_API.G_MISS_NUM,
17: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
18: CREATION_DATE DATE := FND_API.G_MISS_DATE,
11: TYPE Qte_Access_Rec_Type IS RECORD
12: (
13: ACCESS_ID NUMBER := FND_API.G_MISS_NUM,
14: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
15: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
16: RESOURCE_GRP_ID NUMBER := FND_API.G_MISS_NUM,
17: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
18: CREATION_DATE DATE := FND_API.G_MISS_DATE,
19: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
12: (
13: ACCESS_ID NUMBER := FND_API.G_MISS_NUM,
14: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
15: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
16: RESOURCE_GRP_ID NUMBER := FND_API.G_MISS_NUM,
17: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
18: CREATION_DATE DATE := FND_API.G_MISS_DATE,
19: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
20: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
13: ACCESS_ID NUMBER := FND_API.G_MISS_NUM,
14: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
15: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
16: RESOURCE_GRP_ID NUMBER := FND_API.G_MISS_NUM,
17: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
18: CREATION_DATE DATE := FND_API.G_MISS_DATE,
19: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
20: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
14: QUOTE_NUMBER NUMBER := FND_API.G_MISS_NUM,
15: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
16: RESOURCE_GRP_ID NUMBER := FND_API.G_MISS_NUM,
17: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
18: CREATION_DATE DATE := FND_API.G_MISS_DATE,
19: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
20: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
15: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
16: RESOURCE_GRP_ID NUMBER := FND_API.G_MISS_NUM,
17: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
18: CREATION_DATE DATE := FND_API.G_MISS_DATE,
19: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
20: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
23: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
16: RESOURCE_GRP_ID NUMBER := FND_API.G_MISS_NUM,
17: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
18: CREATION_DATE DATE := FND_API.G_MISS_DATE,
19: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
20: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
23: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
17: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
18: CREATION_DATE DATE := FND_API.G_MISS_DATE,
19: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
20: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
23: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
25: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
18: CREATION_DATE DATE := FND_API.G_MISS_DATE,
19: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
20: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
23: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
25: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
26: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
19: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
20: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
23: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
25: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
26: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
27: UPDATE_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
20: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
23: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
25: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
26: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
27: UPDATE_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: CREATED_BY_TAP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
23: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
25: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
26: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
27: UPDATE_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: CREATED_BY_TAP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
29: TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
22: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
23: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
25: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
26: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
27: UPDATE_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: CREATED_BY_TAP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
29: TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
30: TERRITORY_SOURCE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
23: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
24: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
25: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
26: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
27: UPDATE_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: CREATED_BY_TAP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
29: TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
30: TERRITORY_SOURCE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: ROLE_ID NUMBER := FND_API.G_MISS_NUM,
24: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
25: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
26: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
27: UPDATE_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: CREATED_BY_TAP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
29: TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
30: TERRITORY_SOURCE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: ROLE_ID NUMBER := FND_API.G_MISS_NUM,
32: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
25: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
26: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
27: UPDATE_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: CREATED_BY_TAP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
29: TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
30: TERRITORY_SOURCE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: ROLE_ID NUMBER := FND_API.G_MISS_NUM,
32: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
26: KEEP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
27: UPDATE_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: CREATED_BY_TAP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
29: TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
30: TERRITORY_SOURCE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: ROLE_ID NUMBER := FND_API.G_MISS_NUM,
32: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
27: UPDATE_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
28: CREATED_BY_TAP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
29: TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
30: TERRITORY_SOURCE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: ROLE_ID NUMBER := FND_API.G_MISS_NUM,
32: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
28: CREATED_BY_TAP_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
29: TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
30: TERRITORY_SOURCE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: ROLE_ID NUMBER := FND_API.G_MISS_NUM,
32: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
29: TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
30: TERRITORY_SOURCE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: ROLE_ID NUMBER := FND_API.G_MISS_NUM,
32: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
30: TERRITORY_SOURCE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: ROLE_ID NUMBER := FND_API.G_MISS_NUM,
32: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
31: ROLE_ID NUMBER := FND_API.G_MISS_NUM,
32: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
44: ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
45: ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: BATCH_PRICE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
46: ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
47: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: BATCH_PRICE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
54: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
47: ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
48: ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: BATCH_PRICE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
54: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
55: );
48: ATTRIBUTE16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
49: ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: BATCH_PRICE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
54: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
55: );
56: */
49: ATTRIBUTE17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: BATCH_PRICE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
54: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
55: );
56: */
57:
50: ATTRIBUTE18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE20 VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: BATCH_PRICE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
54: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
55: );
56: */
57:
58: SUBTYPE Qte_Access_Rec_Type IS aso_quote_pub.Qte_Access_Rec_Type;
73: ) RETURN VARCHAR2;
74:
75: PROCEDURE Add_Resource
76: (
77: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
78: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
79: P_Qte_Access_Tbl IN Qte_Access_Tbl_Type,
80: X_Qte_Access_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Access_Tbl_Type,
81: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
74:
75: PROCEDURE Add_Resource
76: (
77: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
78: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
79: P_Qte_Access_Tbl IN Qte_Access_Tbl_Type,
80: X_Qte_Access_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Access_Tbl_Type,
81: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
82: X_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
84: );
85:
86: PROCEDURE Add_Resource
87: (
88: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
89: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
90: P_Qte_Access_Tbl IN Qte_Access_Tbl_Type,
91: p_call_from_oafwk_flag IN VARCHAR2,
92: X_Qte_Access_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Access_Tbl_Type,
85:
86: PROCEDURE Add_Resource
87: (
88: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
89: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
90: P_Qte_Access_Tbl IN Qte_Access_Tbl_Type,
91: p_call_from_oafwk_flag IN VARCHAR2,
92: X_Qte_Access_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Access_Tbl_Type,
93: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
96: );
97:
98: PROCEDURE Delete_Resource
99: (
100: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
101: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
102: P_Qte_Access_Tbl IN Qte_Access_Tbl_Type,
103: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
104: X_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
97:
98: PROCEDURE Delete_Resource
99: (
100: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
101: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
102: P_Qte_Access_Tbl IN Qte_Access_Tbl_Type,
103: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
104: X_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
105: X_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106: );
107:
108: PROCEDURE Add_SalesRep_QuoteCreator
109: (
110: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
111: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
112: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
113: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
114: X_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
107:
108: PROCEDURE Add_SalesRep_QuoteCreator
109: (
110: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
111: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
112: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
113: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
114: X_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
115: X_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2