32: BEGIN
33:
34: -- In the future call Flex APIs for defaults
35:
36: IF g_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR THEN
37: g_ref_designator_rec.attribute_category := NULL;
38: END IF;
39:
40: IF g_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR THEN
36: IF g_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR THEN
37: g_ref_designator_rec.attribute_category := NULL;
38: END IF;
39:
40: IF g_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR THEN
41: g_ref_designator_rec.attribute1 := NULL;
42: END IF;
43:
44: IF g_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR THEN
40: IF g_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR THEN
41: g_ref_designator_rec.attribute1 := NULL;
42: END IF;
43:
44: IF g_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR THEN
45: g_ref_designator_rec.attribute2 := NULL;
46: END IF;
47:
48: IF g_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR THEN
44: IF g_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR THEN
45: g_ref_designator_rec.attribute2 := NULL;
46: END IF;
47:
48: IF g_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR THEN
49: g_ref_designator_rec.attribute3 := NULL;
50: END IF;
51:
52: IF g_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR THEN
48: IF g_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR THEN
49: g_ref_designator_rec.attribute3 := NULL;
50: END IF;
51:
52: IF g_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR THEN
53: g_ref_designator_rec.attribute4 := NULL;
54: END IF;
55:
56: IF g_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR THEN
52: IF g_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR THEN
53: g_ref_designator_rec.attribute4 := NULL;
54: END IF;
55:
56: IF g_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR THEN
57: g_ref_designator_rec.attribute5 := NULL;
58: END IF;
59:
60: IF g_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR THEN
56: IF g_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR THEN
57: g_ref_designator_rec.attribute5 := NULL;
58: END IF;
59:
60: IF g_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR THEN
61: g_ref_designator_rec.attribute6 := NULL;
62: END IF;
63:
64: IF g_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR THEN
60: IF g_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR THEN
61: g_ref_designator_rec.attribute6 := NULL;
62: END IF;
63:
64: IF g_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR THEN
65: g_ref_designator_rec.attribute7 := NULL;
66: END IF;
67:
68: IF g_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR THEN
64: IF g_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR THEN
65: g_ref_designator_rec.attribute7 := NULL;
66: END IF;
67:
68: IF g_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR THEN
69: g_ref_designator_rec.attribute8 := NULL;
70: END IF;
71:
72: IF g_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR THEN
68: IF g_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR THEN
69: g_ref_designator_rec.attribute8 := NULL;
70: END IF;
71:
72: IF g_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR THEN
73: g_ref_designator_rec.attribute9 := NULL;
74: END IF;
75:
76: IF g_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR THEN
72: IF g_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR THEN
73: g_ref_designator_rec.attribute9 := NULL;
74: END IF;
75:
76: IF g_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR THEN
77: g_ref_designator_rec.attribute10 := NULL;
78: END IF;
79:
80: IF g_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR THEN
76: IF g_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR THEN
77: g_ref_designator_rec.attribute10 := NULL;
78: END IF;
79:
80: IF g_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR THEN
81: g_ref_designator_rec.attribute11 := NULL;
82: END IF;
83:
84: IF g_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR THEN
80: IF g_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR THEN
81: g_ref_designator_rec.attribute11 := NULL;
82: END IF;
83:
84: IF g_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR THEN
85: g_ref_designator_rec.attribute12 := NULL;
86: END IF;
87:
88: IF g_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR THEN
84: IF g_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR THEN
85: g_ref_designator_rec.attribute12 := NULL;
86: END IF;
87:
88: IF g_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR THEN
89: g_ref_designator_rec.attribute13 := NULL;
90: END IF;
91:
92: IF g_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR THEN
88: IF g_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR THEN
89: g_ref_designator_rec.attribute13 := NULL;
90: END IF;
91:
92: IF g_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR THEN
93: g_ref_designator_rec.attribute14 := NULL;
94: END IF;
95:
96: IF g_ref_designator_rec.attribute15 = FND_API.G_MISS_CHAR THEN
92: IF g_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR THEN
93: g_ref_designator_rec.attribute14 := NULL;
94: END IF;
95:
96: IF g_ref_designator_rec.attribute15 = FND_API.G_MISS_CHAR THEN
97: g_ref_designator_rec.attribute15 := NULL;
98: END IF;
99:
100: END Get_Flex_Ref_Designator;
120: ***************************************************************/
121:
122: g_ref_designator_Rec := p_ref_designator_Rec;
123:
124: IF g_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR
125: OR g_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR
126: OR g_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR
127: OR g_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR
128: OR g_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR
121:
122: g_ref_designator_Rec := p_ref_designator_Rec;
123:
124: IF g_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR
125: OR g_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR
126: OR g_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR
127: OR g_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR
128: OR g_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR
129: OR g_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR
122: g_ref_designator_Rec := p_ref_designator_Rec;
123:
124: IF g_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR
125: OR g_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR
126: OR g_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR
127: OR g_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR
128: OR g_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR
129: OR g_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR
130: OR g_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR
123:
124: IF g_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR
125: OR g_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR
126: OR g_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR
127: OR g_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR
128: OR g_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR
129: OR g_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR
130: OR g_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR
131: OR g_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR
124: IF g_ref_designator_rec.attribute_category = FND_API.G_MISS_CHAR
125: OR g_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR
126: OR g_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR
127: OR g_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR
128: OR g_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR
129: OR g_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR
130: OR g_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR
131: OR g_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR
132: OR g_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR
125: OR g_ref_designator_rec.attribute1 = FND_API.G_MISS_CHAR
126: OR g_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR
127: OR g_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR
128: OR g_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR
129: OR g_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR
130: OR g_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR
131: OR g_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR
132: OR g_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR
133: OR g_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR
126: OR g_ref_designator_rec.attribute2 = FND_API.G_MISS_CHAR
127: OR g_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR
128: OR g_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR
129: OR g_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR
130: OR g_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR
131: OR g_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR
132: OR g_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR
133: OR g_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR
134: OR g_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR
127: OR g_ref_designator_rec.attribute3 = FND_API.G_MISS_CHAR
128: OR g_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR
129: OR g_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR
130: OR g_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR
131: OR g_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR
132: OR g_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR
133: OR g_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR
134: OR g_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR
135: OR g_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR
128: OR g_ref_designator_rec.attribute4 = FND_API.G_MISS_CHAR
129: OR g_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR
130: OR g_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR
131: OR g_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR
132: OR g_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR
133: OR g_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR
134: OR g_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR
135: OR g_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR
136: OR g_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR
129: OR g_ref_designator_rec.attribute5 = FND_API.G_MISS_CHAR
130: OR g_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR
131: OR g_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR
132: OR g_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR
133: OR g_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR
134: OR g_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR
135: OR g_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR
136: OR g_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR
137: OR g_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR
130: OR g_ref_designator_rec.attribute6 = FND_API.G_MISS_CHAR
131: OR g_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR
132: OR g_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR
133: OR g_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR
134: OR g_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR
135: OR g_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR
136: OR g_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR
137: OR g_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR
138: OR g_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR
131: OR g_ref_designator_rec.attribute7 = FND_API.G_MISS_CHAR
132: OR g_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR
133: OR g_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR
134: OR g_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR
135: OR g_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR
136: OR g_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR
137: OR g_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR
138: OR g_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR
139: OR g_ref_designator_rec.attribute15 = FND_API.G_MISS_CHAR
132: OR g_ref_designator_rec.attribute8 = FND_API.G_MISS_CHAR
133: OR g_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR
134: OR g_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR
135: OR g_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR
136: OR g_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR
137: OR g_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR
138: OR g_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR
139: OR g_ref_designator_rec.attribute15 = FND_API.G_MISS_CHAR
140: THEN
133: OR g_ref_designator_rec.attribute9 = FND_API.G_MISS_CHAR
134: OR g_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR
135: OR g_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR
136: OR g_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR
137: OR g_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR
138: OR g_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR
139: OR g_ref_designator_rec.attribute15 = FND_API.G_MISS_CHAR
140: THEN
141:
134: OR g_ref_designator_rec.attribute10 = FND_API.G_MISS_CHAR
135: OR g_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR
136: OR g_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR
137: OR g_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR
138: OR g_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR
139: OR g_ref_designator_rec.attribute15 = FND_API.G_MISS_CHAR
140: THEN
141:
142: Get_Flex_Ref_Designator;
135: OR g_ref_designator_rec.attribute11 = FND_API.G_MISS_CHAR
136: OR g_ref_designator_rec.attribute12 = FND_API.G_MISS_CHAR
137: OR g_ref_designator_rec.attribute13 = FND_API.G_MISS_CHAR
138: OR g_ref_designator_rec.attribute14 = FND_API.G_MISS_CHAR
139: OR g_ref_designator_rec.attribute15 = FND_API.G_MISS_CHAR
140: THEN
141:
142: Get_Flex_Ref_Designator;
143: