DBA Data[Home] [Help]

APPS.AK_ATTRIBUTE_PVT dependencies on AK_ON_OBJECTS_PUB

Line 1363: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

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

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

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

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

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

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

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

Line 1742: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

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: );
1744:
1745: --
1746: -- If API call returns with an error status...

Line 2140: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,

2136: p_return_status OUT NOCOPY VARCHAR2,
2137: p_index IN OUT NOCOPY NUMBER,
2138: p_loader_timestamp IN DATE,
2139: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
2140: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
2141: p_line_num_out OUT NOCOPY NUMBER,
2142: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
2143: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
2144: p_pass IN NUMBER := 1

Line 2142: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,

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

Line 2143: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,

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

Line 2150: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;

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

Line 2162: l_saved_token AK_ON_OBJECTS_PUB.Buffer_type;

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

Line 2164: l_token AK_ON_OBJECTS_PUB.Buffer_Type;

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

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

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

Line 2457: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2453: l_attribute_rec.default_value_number := to_number(l_token);
2454: l_state := 10;
2455: elsif (l_column = 'DEFAULT_VALUE_DATE') then
2456: l_attribute_rec.default_value_date := to_date(l_token,
2457: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2458: l_state := 10;
2459: elsif (l_column = 'LOV_REGION') then
2460: l_attribute_rec.lov_region_application_id := to_number(l_token);
2461: l_state := 14;

Line 2545: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2541: l_attribute_rec.created_by := to_number(l_token);
2542: l_state := 10;
2543: elsif (l_column = 'CREATION_DATE') then
2544: l_attribute_rec.creation_date := to_date(l_token,
2545: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2546: l_state := 10;
2547: elsif (l_column = 'LAST_UPDATED_BY') then
2548: l_attribute_rec.last_updated_by := to_number(l_token);
2549: l_state := 10;

Line 2555: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2551: l_attribute_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
2552: l_state := 10;
2553: elsif (l_column = 'LAST_UPDATE_DATE') then
2554: l_attribute_rec.last_update_date := to_date(l_token,
2555: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2556: l_state := 10;
2557: elsif (l_column = 'LAST_UPDATE_LOGIN') then
2558: l_attribute_rec.last_update_login := to_number(l_token);
2559: l_state := 10;