DBA Data[Home] [Help]

APPS.AK_ATTRIBUTE_PVT dependencies on AK_ON_OBJECTS_PUB

Line 1367: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

1363: p_attributes_rec IN ak_attributes%ROWTYPE,
1364: p_attributes_tl_rec IN ak_attributes_tl%ROWTYPE
1365: ) is
1366: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
1367: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1368: l_index NUMBER;
1369: l_lov_object VARCHAR2(30);
1370: l_return_status varchar2(1);
1371: begin

Line 1490: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1486: (p_attributes_rec.default_value_date <> FND_API.G_MISS_DATE)) then
1487: l_index := l_index + 1;
1488: l_databuffer_tbl(l_index) := ' DEFAULT_VALUE_DATE = "' ||
1489: to_char(p_attributes_rec.default_value_date,
1490: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1491: end if;
1492: if ((p_attributes_rec.lov_region_application_id IS NOT NULL) and
1493: (p_attributes_rec.lov_region_application_id <> FND_API.G_MISS_NUM) and
1494: (p_attributes_rec.lov_region_code IS NOT NULL) and

Line 1692: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1688: nvl(to_char(p_attributes_rec.created_by),'') || '"';
1689: l_index := l_index + 1;
1690: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
1691: to_char(p_attributes_rec.creation_date,
1692: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1693: l_index := l_index + 1;
1694: -- CHANGED TO OWNER FOR R12
1695: -- l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
1696: -- nvl(to_char(p_attributes_rec.last_updated_by),'') || '"';

Line 1702: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1698: FND_LOAD_UTIL.OWNER_NAME(p_attributes_rec.last_updated_by) || '"';
1699: l_index := l_index + 1;
1700: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
1701: to_char(p_attributes_rec.last_update_date,
1702: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1703: l_index := l_index + 1;
1704: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
1705: nvl(to_char(p_attributes_rec.last_update_login),'') || '"';
1706: -- translation columns

Line 1746: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

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: );
1748:
1749: --
1750: -- If API call returns with an error status...

Line 2144: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,

2140: p_return_status OUT NOCOPY VARCHAR2,
2141: p_index IN OUT NOCOPY NUMBER,
2142: p_loader_timestamp IN DATE,
2143: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
2144: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
2145: p_line_num_out OUT NOCOPY NUMBER,
2146: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
2147: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
2148: p_pass IN NUMBER := 1

Line 2146: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,

2142: p_loader_timestamp IN DATE,
2143: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
2144: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
2145: p_line_num_out OUT NOCOPY NUMBER,
2146: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
2147: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
2148: p_pass IN NUMBER := 1
2149: ) is
2150: l_api_version_number CONSTANT number := 1.0;

Line 2147: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,

2143: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
2144: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
2145: p_line_num_out OUT NOCOPY NUMBER,
2146: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
2147: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
2148: p_pass IN NUMBER := 1
2149: ) is
2150: l_api_version_number CONSTANT number := 1.0;
2151: l_api_name CONSTANT varchar2(30) := 'Upload_Attribute';

Line 2154: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;

2150: l_api_version_number CONSTANT number := 1.0;
2151: l_api_name CONSTANT varchar2(30) := 'Upload_Attribute';
2152: l_attribute_rec ak_attributes%ROWTYPE;
2153: l_attribute_tl_rec AK_ATTRIBUTE_PUB.Attribute_Tl_Rec_Type;
2154: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
2155: l_column varchar2(30);
2156: l_dummy NUMBER;
2157: l_empty_attribute_rec ak_attributes%ROWTYPE;
2158: l_empty_attribute_tl_rec AK_ATTRIBUTE_PUB.Attribute_Tl_Rec_Type;

Line 2166: l_saved_token AK_ON_OBJECTS_PUB.Buffer_type;

2162: l_msg_count NUMBER;
2163: l_msg_data VARCHAR2(2000);
2164: l_more_attr BOOLEAN := TRUE;
2165: l_return_status varchar2(1);
2166: l_saved_token AK_ON_OBJECTS_PUB.Buffer_type;
2167: l_state NUMBER; /* parse state */
2168: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
2169: l_value_count NUMBER; /* # of values read for current column */
2170: l_copy_redo_flag BOOLEAN := FALSE;

Line 2168: l_token AK_ON_OBJECTS_PUB.Buffer_Type;

2164: l_more_attr BOOLEAN := TRUE;
2165: l_return_status varchar2(1);
2166: l_saved_token AK_ON_OBJECTS_PUB.Buffer_type;
2167: l_state NUMBER; /* parse state */
2168: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
2169: l_value_count NUMBER; /* # of values read for current column */
2170: l_copy_redo_flag BOOLEAN := FALSE;
2171: l_user_id1 NUMBER;
2172: l_user_id2 NUMBER;

Line 2397: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or

2393: --
2394: if (l_value_count = 2) then
2395: l_saved_token := l_token;
2396: end if;
2397: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2398: (l_value_count is null) then
2399: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2400: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
2401: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 2461: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2457: l_attribute_rec.default_value_number := to_number(l_token);
2458: l_state := 10;
2459: elsif (l_column = 'DEFAULT_VALUE_DATE') then
2460: l_attribute_rec.default_value_date := to_date(l_token,
2461: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2462: l_state := 10;
2463: elsif (l_column = 'LOV_REGION') then
2464: l_attribute_rec.lov_region_application_id := to_number(l_token);
2465: l_state := 14;

Line 2549: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2545: l_attribute_rec.created_by := to_number(l_token);
2546: l_state := 10;
2547: elsif (l_column = 'CREATION_DATE') then
2548: l_attribute_rec.creation_date := to_date(l_token,
2549: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2550: l_state := 10;
2551: elsif (l_column = 'LAST_UPDATED_BY') then
2552: l_attribute_rec.last_updated_by := to_number(l_token);
2553: l_state := 10;

Line 2559: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2555: l_attribute_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
2556: l_state := 10;
2557: elsif (l_column = 'LAST_UPDATE_DATE') then
2558: l_attribute_rec.last_update_date := to_date(l_token,
2559: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2560: l_state := 10;
2561: elsif (l_column = 'LAST_UPDATE_LOGIN') then
2562: l_attribute_rec.last_update_login := to_number(l_token);
2563: l_state := 10;