eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_ATTRIBUTE_PVT dependencies on AK_ON_OBJECTS_PVT

Line 23: -- in package AK_ON_OBJECTS_PVT:

19: -- validation tests are passed, or FALSE otherwise.
20: -- Parameters Attribute columns
21: -- p_caller : IN required
22: -- Must be one of the following values defined
23: -- in package AK_ON_OBJECTS_PVT:
24: -- - G_CREATE (if calling from the Create API)
25: -- - G_DOWNLOAD (if calling from the Download API)
26: -- - G_UPDATE (if calling from the Update API)
27: --

Line 109: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then

105: /*** check that required columns are not null and, unless calling ***/
106: /*** from UPDATE procedure, the columns are not missing ***/
107: if ((p_bold is null) or
108: (p_bold = FND_API.G_MISS_CHAR and
109: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
110: l_error := TRUE;
111: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
112: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
113: FND_MESSAGE.SET_TOKEN('COLUMN', 'BOLD');

Line 120: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then

116: end if;
117:
118: if ((p_italic is null) or
119: (p_italic = FND_API.G_MISS_CHAR and
120: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
121: l_error := TRUE;
122: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
123: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
124: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITALIC');

Line 131: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))

127: end if;
128:
129: if ((p_vertical_alignment is null) or
130: (p_vertical_alignment = FND_API.G_MISS_CHAR and
131: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
132: then
133: l_error := TRUE;
134: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
135: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

Line 143: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))

139: end if;
140:
141: if ((p_horizontal_alignment is null) or
142: (p_horizontal_alignment = FND_API.G_MISS_CHAR and
143: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
144: then
145: l_error := TRUE;
146: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
147: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

Line 155: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then

151: end if;
152:
153: if ((p_data_type is null) or
154: (p_data_type = FND_API.G_MISS_CHAR and
155: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
156: l_error := TRUE;
157: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
158: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
159: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATA_TYPE');

Line 166: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then

162: end if;
163:
164: if ((p_name is null) or
165: (p_name = FND_API.G_MISS_CHAR and
166: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
167: l_error := TRUE;
168: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
169: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
170: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');

Line 179: if (NOT AK_ON_OBJECTS_PVT.VALID_APPLICATION_ID (

175: --*** Validate columns ***
176:
177: -- - application ID
178: if (p_attribute_application_id <> FND_API.G_MISS_NUM) then
179: if (NOT AK_ON_OBJECTS_PVT.VALID_APPLICATION_ID (
180: p_api_version_number => 1.0,
181: p_return_status => l_return_status,
182: p_application_id => p_attribute_application_id)
183: ) then

Line 195: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (

191: end if;
192:
193: -- - data type
194: if (p_data_type <> FND_API.G_MISS_CHAR) then
195: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
196: p_api_version_number => 1.0,
197: p_return_status => l_return_status,
198: p_lookup_type => 'DATA_TYPE',
199: p_lookup_code => p_data_type) ) then

Line 211: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_bold)) then

207: end if;
208:
209: -- - bold
210: if (p_bold <> FND_API.G_MISS_CHAR) then
211: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_bold)) then
212: l_error := TRUE;
213: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
214: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
215: FND_MESSAGE.SET_TOKEN('COLUMN','BOLD');

Line 223: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_upper_case_flag)) then

219: end if;
220:
221: -- - upper_case_flag
222: if (p_upper_case_flag <> FND_API.G_MISS_CHAR) then
223: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_upper_case_flag)) then
224: l_error := TRUE;
225: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
226: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
227: FND_MESSAGE.SET_TOKEN('COLUMN','UPPER_CASE_FLAG');

Line 235: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_italic)) then

231: end if;
232:
233: -- - italic
234: if (p_italic <> FND_API.G_MISS_CHAR) then
235: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_italic)) then
236: l_error := TRUE;
237: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
238: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
239: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');

Line 247: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (

243: end if;
244:
245: -- - vertical alignment
246: if (p_vertical_alignment <> FND_API.G_MISS_CHAR) then
247: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
248: p_api_version_number => 1.0,
249: p_return_status => l_return_status,
250: p_lookup_type => 'VERTICAL_ALIGNMENT',
251: p_lookup_code => p_vertical_alignment)) then

Line 263: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (

259: end if;
260:
261: /* - horizontal alignment */
262: if (p_horizontal_alignment <> FND_API.G_MISS_CHAR) then
263: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
264: p_api_version_number => 1.0,
265: p_return_status => l_return_status,
266: p_lookup_type => 'HORIZONTAL_ALIGNMENT',
267: p_lookup_code => p_horizontal_alignment)) then

Line 618: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

614: p_name => p_name,
615: p_attribute_label_long => p_attribute_label_long,
616: p_attribute_label_short => p_attribute_label_short,
617: p_description => p_description,
618: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
619: p_pass => p_pass
620: ) then
621: -- Do not raise an error if it's the first pass, continue to
622: -- insert the record

Line 806: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

802: -- old jlt files didn't have who columns and IS_UPDATEABLE
803: -- calls SET_WHO which populates those columns, for later
804: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
805:
806: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
807: p_loader_timestamp => p_loader_timestamp,
808: p_created_by => l_created_by,
809: p_creation_date => l_creation_date,
810: p_last_updated_by => l_last_updated_by,

Line 1397: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)

1393: p_name => p_attributes_tl_rec.name,
1394: p_attribute_label_long => p_attributes_tl_rec.attribute_label_long,
1395: p_attribute_label_short => p_attributes_tl_rec.attribute_label_short,
1396: p_description => p_attributes_tl_rec.description,
1397: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1398: then
1399: -- dbms_output.put_line('Attribute ' || p_attributes_rec.attribute_code
1400: -- || ' not downloaded due to validation error');
1401: raise FND_API.G_EXC_ERROR;

Line 1413: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.attribute_code) || '"';

1409: l_index := 1;
1410:
1411: l_databuffer_tbl(l_index) := 'BEGIN ATTRIBUTE "' ||
1412: p_attributes_rec.attribute_application_id || '" "' ||
1413: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.attribute_code) || '"';
1414: --
1415: -- only write out columns that is not null
1416: --
1417: if ((p_attributes_rec.attribute_label_length IS NOT NULL) and

Line 1433: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.bold) || '"';

1429: if ((p_attributes_rec.bold IS NOT NULL) and
1430: (p_attributes_rec.bold <> FND_API.G_MISS_CHAR)) then
1431: l_index := l_index + 1;
1432: l_databuffer_tbl(l_index) := ' BOLD = "' ||
1433: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.bold) || '"';
1434: end if;
1435: if ((p_attributes_rec.italic IS NOT NULL) and
1436: (p_attributes_rec.italic <> FND_API.G_MISS_CHAR)) then
1437: l_index := l_index + 1;

Line 1439: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.italic) || '"';

1435: if ((p_attributes_rec.italic IS NOT NULL) and
1436: (p_attributes_rec.italic <> FND_API.G_MISS_CHAR)) then
1437: l_index := l_index + 1;
1438: l_databuffer_tbl(l_index) := ' ITALIC = "' ||
1439: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.italic) || '"';
1440: end if;
1441: if ((p_attributes_rec.vertical_alignment IS NOT NULL) and
1442: (p_attributes_rec.vertical_alignment <> FND_API.G_MISS_CHAR)) then
1443: l_index := l_index + 1;

Line 1445: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.vertical_alignment)

1441: if ((p_attributes_rec.vertical_alignment IS NOT NULL) and
1442: (p_attributes_rec.vertical_alignment <> FND_API.G_MISS_CHAR)) then
1443: l_index := l_index + 1;
1444: l_databuffer_tbl(l_index) := ' VERTICAL_ALIGNMENT = "' ||
1445: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.vertical_alignment)
1446: || '"';
1447: end if;
1448: if ((p_attributes_rec.horizontal_alignment IS NOT NULL) and
1449: (p_attributes_rec.horizontal_alignment <> FND_API.G_MISS_CHAR)) then

Line 1452: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.horizontal_alignment)

1448: if ((p_attributes_rec.horizontal_alignment IS NOT NULL) and
1449: (p_attributes_rec.horizontal_alignment <> FND_API.G_MISS_CHAR)) then
1450: l_index := l_index + 1;
1451: l_databuffer_tbl(l_index) := ' HORIZONTAL_ALIGNMENT = "' ||
1452: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.horizontal_alignment)
1453: || '"';
1454: end if;
1455: if ((p_attributes_rec.data_type IS NOT NULL) and
1456: (p_attributes_rec.data_type <> FND_API.G_MISS_CHAR)) then

Line 1459: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.data_type) || '"';

1455: if ((p_attributes_rec.data_type IS NOT NULL) and
1456: (p_attributes_rec.data_type <> FND_API.G_MISS_CHAR)) then
1457: l_index := l_index + 1;
1458: l_databuffer_tbl(l_index) := ' DATA_TYPE = "' ||
1459: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.data_type) || '"';
1460: end if;
1461: if ((p_attributes_rec.upper_case_flag IS NOT NULL) and
1462: (p_attributes_rec.upper_case_flag <> FND_API.G_MISS_CHAR)) then
1463: l_index := l_index + 1;

Line 1465: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.upper_case_flag)

1461: if ((p_attributes_rec.upper_case_flag IS NOT NULL) and
1462: (p_attributes_rec.upper_case_flag <> FND_API.G_MISS_CHAR)) then
1463: l_index := l_index + 1;
1464: l_databuffer_tbl(l_index) := ' UPPER_CASE_FLAG = "' ||
1465: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.upper_case_flag)
1466: || '"';
1467: end if;
1468: if ((p_attributes_rec.default_value_varchar2 IS NOT NULL) and
1469: (p_attributes_rec.default_value_varchar2 <> FND_API.G_MISS_CHAR)) then

Line 1472: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1468: if ((p_attributes_rec.default_value_varchar2 IS NOT NULL) and
1469: (p_attributes_rec.default_value_varchar2 <> FND_API.G_MISS_CHAR)) then
1470: l_index := l_index + 1;
1471: l_databuffer_tbl(l_index) := ' DEFAULT_VALUE_VARCHAR2 = "' ||
1472: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1473: p_attributes_rec.default_value_varchar2) || '"';
1474: end if;
1475: if ((p_attributes_rec.default_value_number IS NOT NULL) and
1476: (p_attributes_rec.default_value_number <> FND_API.G_MISS_NUM)) then

Line 1495: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.lov_region_code) ||

1491: (p_attributes_rec.lov_region_code <> FND_API.G_MISS_CHAR)) then
1492: l_index := l_index + 1;
1493: l_databuffer_tbl(l_index) := ' LOV_REGION = "' ||
1494: nvl(to_char(p_attributes_rec.lov_region_application_id),'')||'" "'||
1495: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.lov_region_code) ||
1496: '"';
1497: end if;
1498: -- new columns for JSP renderer
1499: if ((p_attributes_rec.item_style IS NOT NULL) and

Line 1503: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1499: if ((p_attributes_rec.item_style IS NOT NULL) and
1500: (p_attributes_rec.item_style <> FND_API.G_MISS_CHAR)) then
1501: l_index := l_index + 1;
1502: l_databuffer_tbl(l_index) := ' ITEM_STYLE = "' ||
1503: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1504: p_attributes_rec.item_style) || '"';
1505: end if;
1506: if ((p_attributes_rec.display_height IS NOT NULL) and
1507: (p_attributes_rec.display_height <> FND_API.G_MISS_NUM)) then

Line 1516: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1512: if ((p_attributes_rec.css_class_name IS NOT NULL) and
1513: (p_attributes_rec.css_class_name <> FND_API.G_MISS_CHAR)) then
1514: l_index := l_index + 1;
1515: l_databuffer_tbl(l_index) := ' CSS_CLASS_NAME = "' ||
1516: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1517: p_attributes_rec.css_class_name) || '"';
1518: end if;
1519: if ((p_attributes_rec.poplist_viewobject IS NOT NULL) and
1520: (p_attributes_rec.poplist_viewobject <> FND_API.G_MISS_CHAR)) then

Line 1523: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1519: if ((p_attributes_rec.poplist_viewobject IS NOT NULL) and
1520: (p_attributes_rec.poplist_viewobject <> FND_API.G_MISS_CHAR)) then
1521: l_index := l_index + 1;
1522: l_databuffer_tbl(l_index) := ' POPLIST_VIEWOBJECT = "' ||
1523: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1524: p_attributes_rec.poplist_viewobject) || '"';
1525: end if;
1526: if ((p_attributes_rec.poplist_display_attribute IS NOT NULL) and
1527: (p_attributes_rec.poplist_display_attribute <> FND_API.G_MISS_CHAR)) then

Line 1530: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1526: if ((p_attributes_rec.poplist_display_attribute IS NOT NULL) and
1527: (p_attributes_rec.poplist_display_attribute <> FND_API.G_MISS_CHAR)) then
1528: l_index := l_index + 1;
1529: l_databuffer_tbl(l_index) := ' POPLIST_DISPLAY_ATTRIBUTE = "' ||
1530: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1531: p_attributes_rec.poplist_display_attribute) || '"';
1532: end if;
1533: if ((p_attributes_rec.poplist_value_attribute IS NOT NULL) and
1534: (p_attributes_rec.poplist_value_attribute <> FND_API.G_MISS_CHAR)) then

Line 1537: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1533: if ((p_attributes_rec.poplist_value_attribute IS NOT NULL) and
1534: (p_attributes_rec.poplist_value_attribute <> FND_API.G_MISS_CHAR)) then
1535: l_index := l_index + 1;
1536: l_databuffer_tbl(l_index) := ' POPLIST_VALUE_ATTRIBUTE = "' ||
1537: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1538: p_attributes_rec.poplist_value_attribute) || '"';
1539: end if;
1540: if ((p_attributes_rec.css_label_class_name IS NOT NULL ) and
1541: (p_attributes_rec.css_label_class_name <> FND_API.G_MISS_CHAR)) then

Line 1544: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1540: if ((p_attributes_rec.css_label_class_name IS NOT NULL ) and
1541: (p_attributes_rec.css_label_class_name <> FND_API.G_MISS_CHAR)) then
1542: l_index := l_index + 1;
1543: l_databuffer_tbl(l_index) := ' CSS_LABEL_CLASS_NAME = "' ||
1544: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1545: p_attributes_rec.css_label_class_name) || '"';
1546: end if;
1547: if ((p_attributes_rec.precision IS NOT NULL ) and
1548: (p_attributes_rec.precision <> FND_API.G_MISS_NUM)) then

Line 1573: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1569: if ((p_attributes_rec.attribute_category IS NOT NULL) and
1570: (p_attributes_rec.attribute_category <> FND_API.G_MISS_CHAR)) then
1571: l_index := l_index + 1;
1572: l_databuffer_tbl(l_index) := ' ATTRIBUTE_CATEGORY = "' ||
1573: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1574: p_attributes_rec.attribute_category) || '"';
1575: end if;
1576: if ((p_attributes_rec.attribute1 IS NOT NULL) and
1577: (p_attributes_rec.attribute1 <> FND_API.G_MISS_CHAR)) then

Line 1580: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1576: if ((p_attributes_rec.attribute1 IS NOT NULL) and
1577: (p_attributes_rec.attribute1 <> FND_API.G_MISS_CHAR)) then
1578: l_index := l_index + 1;
1579: l_databuffer_tbl(l_index) := ' ATTRIBUTE1 = "' ||
1580: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1581: p_attributes_rec.attribute1) || '"';
1582: end if;
1583: if ((p_attributes_rec.attribute2 IS NOT NULL) and
1584: (p_attributes_rec.attribute2 <> FND_API.G_MISS_CHAR)) then

Line 1587: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1583: if ((p_attributes_rec.attribute2 IS NOT NULL) and
1584: (p_attributes_rec.attribute2 <> FND_API.G_MISS_CHAR)) then
1585: l_index := l_index + 1;
1586: l_databuffer_tbl(l_index) := ' ATTRIBUTE2 = "' ||
1587: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1588: p_attributes_rec.attribute2) || '"';
1589: end if;
1590: if ((p_attributes_rec.attribute3 IS NOT NULL) and
1591: (p_attributes_rec.attribute3 <> FND_API.G_MISS_CHAR)) then

Line 1594: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1590: if ((p_attributes_rec.attribute3 IS NOT NULL) and
1591: (p_attributes_rec.attribute3 <> FND_API.G_MISS_CHAR)) then
1592: l_index := l_index + 1;
1593: l_databuffer_tbl(l_index) := ' ATTRIBUTE3 = "' ||
1594: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1595: p_attributes_rec.attribute3) || '"';
1596: end if;
1597: if ((p_attributes_rec.attribute4 IS NOT NULL) and
1598: (p_attributes_rec.attribute4 <> FND_API.G_MISS_CHAR)) then

Line 1601: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1597: if ((p_attributes_rec.attribute4 IS NOT NULL) and
1598: (p_attributes_rec.attribute4 <> FND_API.G_MISS_CHAR)) then
1599: l_index := l_index + 1;
1600: l_databuffer_tbl(l_index) := ' ATTRIBUTE4 = "' ||
1601: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1602: p_attributes_rec.attribute4) || '"';
1603: end if;
1604: if ((p_attributes_rec.attribute5 IS NOT NULL) and
1605: (p_attributes_rec.attribute5 <> FND_API.G_MISS_CHAR)) then

Line 1608: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1604: if ((p_attributes_rec.attribute5 IS NOT NULL) and
1605: (p_attributes_rec.attribute5 <> FND_API.G_MISS_CHAR)) then
1606: l_index := l_index + 1;
1607: l_databuffer_tbl(l_index) := ' ATTRIBUTE5 = "' ||
1608: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1609: p_attributes_rec.attribute5) || '"';
1610: end if;
1611: if ((p_attributes_rec.attribute6 IS NOT NULL) and
1612: (p_attributes_rec.attribute6 <> FND_API.G_MISS_CHAR)) then

Line 1615: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1611: if ((p_attributes_rec.attribute6 IS NOT NULL) and
1612: (p_attributes_rec.attribute6 <> FND_API.G_MISS_CHAR)) then
1613: l_index := l_index + 1;
1614: l_databuffer_tbl(l_index) := ' ATTRIBUTE6 = "' ||
1615: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1616: p_attributes_rec.attribute6) || '"';
1617: end if;
1618: if ((p_attributes_rec.attribute7 IS NOT NULL) and
1619: (p_attributes_rec.attribute7 <> FND_API.G_MISS_CHAR)) then

Line 1622: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1618: if ((p_attributes_rec.attribute7 IS NOT NULL) and
1619: (p_attributes_rec.attribute7 <> FND_API.G_MISS_CHAR)) then
1620: l_index := l_index + 1;
1621: l_databuffer_tbl(l_index) := ' ATTRIBUTE7 = "' ||
1622: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1623: p_attributes_rec.attribute7) || '"';
1624: end if;
1625: if ((p_attributes_rec.attribute8 IS NOT NULL) and
1626: (p_attributes_rec.attribute8 <> FND_API.G_MISS_CHAR)) then

Line 1629: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1625: if ((p_attributes_rec.attribute8 IS NOT NULL) and
1626: (p_attributes_rec.attribute8 <> FND_API.G_MISS_CHAR)) then
1627: l_index := l_index + 1;
1628: l_databuffer_tbl(l_index) := ' ATTRIBUTE8 = "' ||
1629: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1630: p_attributes_rec.attribute8) || '"';
1631: end if;
1632: if ((p_attributes_rec.attribute9 IS NOT NULL) and
1633: (p_attributes_rec.attribute9 <> FND_API.G_MISS_CHAR)) then

Line 1636: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1632: if ((p_attributes_rec.attribute9 IS NOT NULL) and
1633: (p_attributes_rec.attribute9 <> FND_API.G_MISS_CHAR)) then
1634: l_index := l_index + 1;
1635: l_databuffer_tbl(l_index) := ' ATTRIBUTE9 = "' ||
1636: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1637: p_attributes_rec.attribute9) || '"';
1638: end if;
1639: if ((p_attributes_rec.attribute10 IS NOT NULL) and
1640: (p_attributes_rec.attribute10 <> FND_API.G_MISS_CHAR)) then

Line 1643: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1639: if ((p_attributes_rec.attribute10 IS NOT NULL) and
1640: (p_attributes_rec.attribute10 <> FND_API.G_MISS_CHAR)) then
1641: l_index := l_index + 1;
1642: l_databuffer_tbl(l_index) := ' ATTRIBUTE10 = "' ||
1643: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1644: p_attributes_rec.attribute10) || '"';
1645: end if;
1646: if ((p_attributes_rec.attribute11 IS NOT NULL) and
1647: (p_attributes_rec.attribute11 <> FND_API.G_MISS_CHAR)) then

Line 1650: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1646: if ((p_attributes_rec.attribute11 IS NOT NULL) and
1647: (p_attributes_rec.attribute11 <> FND_API.G_MISS_CHAR)) then
1648: l_index := l_index + 1;
1649: l_databuffer_tbl(l_index) := ' ATTRIBUTE11 = "' ||
1650: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1651: p_attributes_rec.attribute11) || '"';
1652: end if;
1653: if ((p_attributes_rec.attribute12 IS NOT NULL) and
1654: (p_attributes_rec.attribute12 <> FND_API.G_MISS_CHAR)) then

Line 1657: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1653: if ((p_attributes_rec.attribute12 IS NOT NULL) and
1654: (p_attributes_rec.attribute12 <> FND_API.G_MISS_CHAR)) then
1655: l_index := l_index + 1;
1656: l_databuffer_tbl(l_index) := ' ATTRIBUTE12 = "' ||
1657: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1658: p_attributes_rec.attribute12) || '"';
1659: end if;
1660: if ((p_attributes_rec.attribute13 IS NOT NULL) and
1661: (p_attributes_rec.attribute13 <> FND_API.G_MISS_CHAR)) then

Line 1664: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1660: if ((p_attributes_rec.attribute13 IS NOT NULL) and
1661: (p_attributes_rec.attribute13 <> FND_API.G_MISS_CHAR)) then
1662: l_index := l_index + 1;
1663: l_databuffer_tbl(l_index) := ' ATTRIBUTE13 = "' ||
1664: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1665: p_attributes_rec.attribute13) || '"';
1666: end if;
1667: if ((p_attributes_rec.attribute14 IS NOT NULL) and
1668: (p_attributes_rec.attribute14 <> FND_API.G_MISS_CHAR)) then

Line 1671: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1667: if ((p_attributes_rec.attribute14 IS NOT NULL) and
1668: (p_attributes_rec.attribute14 <> FND_API.G_MISS_CHAR)) then
1669: l_index := l_index + 1;
1670: l_databuffer_tbl(l_index) := ' ATTRIBUTE14 = "' ||
1671: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1672: p_attributes_rec.attribute14) || '"';
1673: end if;
1674: if ((p_attributes_rec.attribute15 IS NOT NULL) and
1675: (p_attributes_rec.attribute15 <> FND_API.G_MISS_CHAR)) then

Line 1678: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

1674: if ((p_attributes_rec.attribute15 IS NOT NULL) and
1675: (p_attributes_rec.attribute15 <> FND_API.G_MISS_CHAR)) then
1676: l_index := l_index + 1;
1677: l_databuffer_tbl(l_index) := ' ATTRIBUTE15 = "' ||
1678: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(
1679: p_attributes_rec.attribute15) || '"';
1680: end if;
1681: -- - Write out who columns
1682: l_index := l_index + 1;

Line 1708: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.name) || '"';

1704: if ((p_attributes_tl_rec.name IS NOT NULL) and
1705: (p_attributes_tl_rec.name <> FND_API.G_MISS_CHAR)) then
1706: l_index := l_index + 1;
1707: l_databuffer_tbl(l_index) := ' NAME = "' ||
1708: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.name) || '"';
1709: end if;
1710: if ((p_attributes_tl_rec.attribute_label_long IS NOT NULL) and
1711: (p_attributes_tl_rec.attribute_label_long <> FND_API.G_MISS_CHAR)) then
1712: l_index := l_index + 1;

Line 1714: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.attribute_label_long)

1710: if ((p_attributes_tl_rec.attribute_label_long IS NOT NULL) and
1711: (p_attributes_tl_rec.attribute_label_long <> FND_API.G_MISS_CHAR)) then
1712: l_index := l_index + 1;
1713: l_databuffer_tbl(l_index) := ' ATTRIBUTE_LABEL_LONG = "' ||
1714: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.attribute_label_long)
1715: || '"';
1716: end if;
1717: if ((p_attributes_tl_rec.attribute_label_short IS NOT NULL) and
1718: (p_attributes_tl_rec.attribute_label_short <> FND_API.G_MISS_CHAR)) then

Line 1721: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.attribute_label_short)

1717: if ((p_attributes_tl_rec.attribute_label_short IS NOT NULL) and
1718: (p_attributes_tl_rec.attribute_label_short <> FND_API.G_MISS_CHAR)) then
1719: l_index := l_index + 1;
1720: l_databuffer_tbl(l_index) := ' ATTRIBUTE_LABEL_SHORT = "' ||
1721: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.attribute_label_short)
1722: || '"';
1723: end if;
1724: if ((p_attributes_tl_rec.description IS NOT NULL) and
1725: (p_attributes_tl_rec.description <> FND_API.G_MISS_CHAR)) then

Line 1728: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.description) || '"';

1724: if ((p_attributes_tl_rec.description IS NOT NULL) and
1725: (p_attributes_tl_rec.description <> FND_API.G_MISS_CHAR)) then
1726: l_index := l_index + 1;
1727: l_databuffer_tbl(l_index) := ' DESCRIPTION = "' ||
1728: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.description) || '"';
1729: end if;
1730:
1731: l_index := l_index + 1;
1732: l_databuffer_tbl(l_index) := 'END ATTRIBUTE';

Line 1739: AK_ON_OBJECTS_PVT.WRITE_FILE (

1735:
1736: --
1737: -- - Write attribute data out to the specified file
1738: --
1739: AK_ON_OBJECTS_PVT.WRITE_FILE (
1740: p_return_status => l_return_status,
1741: p_buffer_tbl => l_databuffer_tbl,
1742: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1743: );

Line 2207: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop

2203: else
2204: l_line_num := p_line_num;
2205: end if;
2206:
2207: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
2208: AK_ON_OBJECTS_PVT.READ_LINE (
2209: p_return_status => l_return_status,
2210: p_index => p_index,
2211: p_buffer => l_buffer,

Line 2208: AK_ON_OBJECTS_PVT.READ_LINE (

2204: l_line_num := p_line_num;
2205: end if;
2206:
2207: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
2208: AK_ON_OBJECTS_PVT.READ_LINE (
2209: p_return_status => l_return_status,
2210: p_index => p_index,
2211: p_buffer => l_buffer,
2212: p_lines_read => l_lines_read,

Line 2249: AK_ON_OBJECTS_PVT.GET_TOKEN(

2245: --
2246: while (l_eof_flag = 'N') and (l_buffer is not null)
2247: and (l_more_attr) loop
2248:
2249: AK_ON_OBJECTS_PVT.GET_TOKEN(
2250: p_return_status => l_return_status,
2251: p_in_buf => l_buffer,
2252: p_token => l_token
2253: );

Line 2291: -- (ak_on_objects_pvt.upload).

2287: l_state := 2;
2288: else
2289: -- Found the beginning of a non-attribute object,
2290: -- rebuild last line and pass it back to the caller
2291: -- (ak_on_objects_pvt.upload).
2292: p_buffer_out := 'BEGIN ' || l_token || ' ' || l_buffer;
2293: l_more_attr := FALSE;
2294: end if;
2295: elsif (l_state = 2) then

Line 2621: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

2617: and aat.language = userenv('LANG');
2618:
2619: /*if (( l_user_id1 = 1 or l_user_id1 = 2) and
2620: (l_user_id2 = 1 or l_user_id2 = 2)) then*/
2621: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
2622: p_loader_timestamp => p_loader_timestamp,
2623: p_created_by => l_attribute_rec.created_by,
2624: p_creation_date => l_attribute_rec.creation_date,
2625: p_last_updated_by => l_attribute_rec.last_updated_by,

Line 2632: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

2628: p_db_last_update_date => l_update1,
2629: p_last_update_login => l_attribute_rec.last_update_login,
2630: p_create_or_update => 'UPDATE') and
2631:
2632: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
2633: p_loader_timestamp => p_loader_timestamp,
2634: p_created_by => l_attribute_rec.created_by,
2635: p_creation_date => l_attribute_rec.creation_date,
2636: p_last_updated_by => l_attribute_rec.last_updated_by,

Line 2876: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop

2872: --
2873: -- Get the next non-blank, non-comment line if current line is
2874: -- fully parsed
2875: --
2876: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
2877: AK_ON_OBJECTS_PVT.READ_LINE (
2878: p_return_status => l_return_status,
2879: p_index => p_index,
2880: p_buffer => l_buffer,

Line 2877: AK_ON_OBJECTS_PVT.READ_LINE (

2873: -- Get the next non-blank, non-comment line if current line is
2874: -- fully parsed
2875: --
2876: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
2877: AK_ON_OBJECTS_PVT.READ_LINE (
2878: p_return_status => l_return_status,
2879: p_index => p_index,
2880: p_buffer => l_buffer,
2881: p_lines_read => l_lines_read,

Line 3235: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

3231: p_name => p_name,
3232: p_attribute_label_long => p_attribute_label_long,
3233: p_attribute_label_short => p_attribute_label_short,
3234: p_description => p_description,
3235: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
3236: p_pass => p_pass
3237: ) then
3238: if (p_pass = 1) then
3239: p_copy_redo_flag := TRUE;

Line 3498: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3494: if (p_last_update_login <> FND_API.G_MISS_NUM) then
3495: l_last_update_login := p_last_update_login;
3496: end if;
3497:
3498: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3499: p_loader_timestamp => p_loader_timestamp,
3500: p_created_by => l_created_by,
3501: p_creation_date => l_creation_date,
3502: p_last_updated_by => l_last_updated_by,