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 808: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

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

Line 1401: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)

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

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

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

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

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

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

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

Line 1449: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.vertical_alignment)

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

Line 1456: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.horizontal_alignment)

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

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

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

Line 1469: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_rec.upper_case_flag)

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

Line 1476: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

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

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

Line 1507: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1520: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1527: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1534: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1541: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1548: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1577: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1584: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1591: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1598: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1605: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1612: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1619: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1626: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1633: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1640: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1647: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1654: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1661: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1668: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1675: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

Line 1682: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(

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

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

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

Line 1718: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.attribute_label_long)

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

Line 1725: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_attributes_tl_rec.attribute_label_short)

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

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

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

Line 1743: AK_ON_OBJECTS_PVT.WRITE_FILE (

1739:
1740: --
1741: -- - Write attribute data out to the specified file
1742: --
1743: AK_ON_OBJECTS_PVT.WRITE_FILE (
1744: p_return_status => l_return_status,
1745: p_buffer_tbl => l_databuffer_tbl,
1746: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1747: );

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

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

Line 2212: AK_ON_OBJECTS_PVT.READ_LINE (

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

Line 2253: AK_ON_OBJECTS_PVT.GET_TOKEN(

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

Line 2295: -- (ak_on_objects_pvt.upload).

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

Line 2625: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

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

Line 2636: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

2632: p_db_last_update_date => l_update1,
2633: p_last_update_login => l_attribute_rec.last_update_login,
2634: p_create_or_update => 'UPDATE') and
2635:
2636: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
2637: p_loader_timestamp => p_loader_timestamp,
2638: p_created_by => l_attribute_rec.created_by,
2639: p_creation_date => l_attribute_rec.creation_date,
2640: p_last_updated_by => l_attribute_rec.last_updated_by,

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

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

Line 2881: AK_ON_OBJECTS_PVT.READ_LINE (

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

Line 3239: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

3235: p_name => p_name,
3236: p_attribute_label_long => p_attribute_label_long,
3237: p_attribute_label_short => p_attribute_label_short,
3238: p_description => p_description,
3239: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
3240: p_pass => p_pass
3241: ) then
3242: if (p_pass = 1) then
3243: p_copy_redo_flag := TRUE;

Line 3505: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3501: if (p_last_update_login <> FND_API.G_MISS_NUM) then
3502: l_last_update_login := p_last_update_login;
3503: end if;
3504:
3505: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3506: p_loader_timestamp => p_loader_timestamp,
3507: p_created_by => l_created_by,
3508: p_creation_date => l_creation_date,
3509: p_last_updated_by => l_last_updated_by,