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_OBJECT3_PVT dependencies on AK_ON_OBJECTS_PUB

Line 1877: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,

1873: p_return_status OUT NOCOPY VARCHAR2,
1874: p_index IN OUT NOCOPY NUMBER,
1875: p_loader_timestamp IN DATE,
1876: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
1877: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
1878: p_line_num_out OUT NOCOPY NUMBER,
1879: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
1880: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
1881: p_pass IN NUMBER := 1

Line 1879: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,

1875: p_loader_timestamp IN DATE,
1876: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
1877: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
1878: p_line_num_out OUT NOCOPY NUMBER,
1879: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
1880: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
1881: p_pass IN NUMBER := 1
1882: ) is
1883: l_api_version_number CONSTANT number := 1.0;

Line 1880: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,

1876: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
1877: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
1878: p_line_num_out OUT NOCOPY NUMBER,
1879: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
1880: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
1881: p_pass IN NUMBER := 1
1882: ) is
1883: l_api_version_number CONSTANT number := 1.0;
1884: l_api_name CONSTANT varchar2(30) := 'Upload_Object';

Line 1891: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;

1887: l_attribute_tbl AK_OBJECT_PUB.Object_Attribute_Tbl_Type;
1888: l_attribute_value_index NUMBER := 0;
1889: l_attribute_value_rec AK_OBJECT_PUB.Attribute_Value_Rec_Type;
1890: l_attribute_value_tbl AK_OBJECT_PUB.Attribute_Value_Tbl_Type;
1891: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
1892: l_column varchar2(30);
1893: l_dummy NUMBER;
1894: l_eof_flag VARCHAR2(1);
1895: l_foreign_key_index NUMBER := 0;

Line 1920: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;

1916: l_unique_key_tbl AK_KEY_PUB.Unique_Key_Tbl_Type;
1917: l_unique_key_column_index NUMBER := 0;
1918: l_unique_key_column_rec AK_KEY_PUB.Unique_Key_Column_Rec_Type;
1919: l_unique_key_column_tbl AK_KEY_PUB.Unique_Key_Column_Tbl_Type;
1920: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
1921: l_state NUMBER;
1922: l_return_status varchar2(1);
1923: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
1924: l_value_count NUMBER; -- # of values read for current column

Line 1923: l_token AK_ON_OBJECTS_PUB.Buffer_Type;

1919: l_unique_key_column_tbl AK_KEY_PUB.Unique_Key_Column_Tbl_Type;
1920: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
1921: l_state NUMBER;
1922: l_return_status varchar2(1);
1923: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
1924: l_value_count NUMBER; -- # of values read for current column
1925: l_copy_redo_flag BOOLEAN := FALSE;
1926: l_user_id1 NUMBER;
1927: l_user_id2 NUMBER;

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

2113: --
2114: if (l_value_count = 2) then
2115: l_saved_token := l_token;
2116: end if;
2117: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2118: (l_value_count is null) then
2119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2120: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
2121: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 2201: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2197: elsif (l_column = 'CREATED_BY') then
2198: l_object_rec.created_by := to_number(l_token);
2199: elsif (l_column = 'CREATION_DATE') then
2200: l_object_rec.creation_date := to_date(l_token,
2201: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2202: elsif (l_column = 'LAST_UPDATED_BY') then
2203: l_object_rec.last_updated_by := to_number(l_token);
2204: elsif (l_column = 'OWNER') then
2205: l_object_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);

Line 2208: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2204: elsif (l_column = 'OWNER') then
2205: l_object_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
2206: elsif (l_column = 'LAST_UPDATE_DATE') then
2207: l_object_rec.last_update_date := to_date(l_token,
2208: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2209: elsif (l_column = 'LAST_UPDATE_LOGIN') then
2210: l_object_rec.last_update_login := to_number(l_token);
2211: else
2212: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

2357: --
2358: if (l_value_count = 2) then
2359: l_saved_token := l_token;
2360: end if;
2361: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2362: (l_value_count is null) then
2363: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2364: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
2365: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 2437: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2433: l_attribute_rec.default_value_number := to_number(l_token);
2434: l_state := 110;
2435: elsif (l_column = 'DEFAULT_VALUE_DATE') then
2436: l_attribute_rec.default_value_date := to_date(l_token,
2437: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2438: l_state := 110;
2439: elsif (l_column = 'LOV_REGION') then
2440: l_attribute_rec.lov_region_application_id := to_number(l_token);
2441: l_state := 114;

Line 2519: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2515: l_attribute_rec.created_by := to_number(l_token);
2516: l_state := 110;
2517: elsif (l_column = 'CREATION_DATE') then
2518: l_attribute_rec.creation_date := to_date(l_token,
2519: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2520: l_state := 110;
2521: elsif (l_column = 'LAST_UPDATED_BY') then
2522: l_attribute_rec.last_updated_by := to_number(l_token);
2523: l_state := 110;

Line 2529: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2525: l_attribute_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
2526: l_state := 110;
2527: elsif (l_column = 'LAST_UPDATE_DATE') then
2528: l_attribute_rec.last_update_date := to_date(l_token,
2529: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2530: l_state := 110;
2531: elsif (l_column = 'LAST_UPDATE_LOGIN') then
2532: l_attribute_rec.last_update_login := to_number(l_token);
2533: l_state := 110;

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

2660: --
2661: if (l_value_count = 2) then
2662: l_saved_token := l_token;
2663: end if;
2664: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2665: (l_value_count is null) then
2666: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2667: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
2668: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 2711: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2707: l_state := 134;
2708: elsif (l_state = 134) then
2709: if (l_column = 'VALUE') then
2710: l_attribute_value_rec.value_date:= to_date(l_token,
2711: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2712: else
2713: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2714: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2715: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 2773: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2769: l_navigation_rec.value_varchar2 := l_token;
2770: l_state := 141;
2771: elsif (l_state = 141) then
2772: l_navigation_rec.value_date := to_date(l_token,
2773: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2774: l_state := 142;
2775: elsif (l_state = 142) then
2776: l_navigation_rec.value_number := to_number(l_token);
2777: l_value_count := null;

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

2818: --
2819: if (l_value_count = 2) then
2820: l_saved_token := l_token;
2821: end if;
2822: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2823: (l_value_count is null) then
2824: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2825: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
2826: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 2909: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2905: l_navigation_rec.created_by := to_number(l_token);
2906: l_state := 150;
2907: elsif (l_column = 'CREATION_DATE') then
2908: l_navigation_rec.creation_date := to_date(l_token,
2909: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2910: l_state := 150;
2911: elsif (l_column = 'LAST_UPDATED_BY') then
2912: l_navigation_rec.last_updated_by := to_number(l_token);
2913: l_state := 150;

Line 2919: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

2915: l_navigation_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
2916: l_state := 150;
2917: elsif (l_column = 'LAST_UPDATE_DATE') then
2918: l_navigation_rec.last_update_date := to_date(l_token,
2919: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2920: l_state := 150;
2921: elsif (l_column = 'LAST_UPDATE_LOGIN') then
2922: l_navigation_rec.last_update_login := to_number(l_token);
2923: l_state := 150;

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

3034: --
3035: if (l_value_count = 2) then
3036: l_saved_token := l_token;
3037: end if;
3038: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
3039: (l_value_count is null) then
3040: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3041: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
3042: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 3107: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

3103: elsif (l_column = 'CREATED_BY') then
3104: l_unique_key_rec.created_by := to_number(l_token);
3105: elsif (l_column = 'CREATION_DATE') then
3106: l_unique_key_rec.creation_date := to_date(l_token,
3107: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
3108: elsif (l_column = 'LAST_UPDATED_BY') then
3109: l_unique_key_rec.last_updated_by := to_number(l_token);
3110: elsif (l_column = 'OWNER') then
3111: l_unique_key_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);

Line 3114: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

3110: elsif (l_column = 'OWNER') then
3111: l_unique_key_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
3112: elsif (l_column = 'LAST_UPDATE_DATE') then
3113: l_unique_key_rec.last_update_date := to_date(l_token,
3114: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
3115: elsif (l_column = 'LAST_UPDATE_LOGIN') then
3116: l_unique_key_rec.last_update_login := to_number(l_token);
3117: else
3118: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

3234: --
3235: if (l_value_count = 2) then
3236: l_saved_token := l_token;
3237: end if;
3238: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
3239: (l_value_count is null) then
3240: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3241: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
3242: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 3307: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

3303: elsif (l_column = 'CREATED_BY') then
3304: l_unique_key_column_rec.created_by := to_number(l_token);
3305: elsif (l_column = 'CREATION_DATE') then
3306: l_unique_key_column_rec.creation_date := to_date(l_token,
3307: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
3308: elsif (l_column = 'LAST_UPDATED_BY') then
3309: l_unique_key_column_rec.last_updated_by := to_number(l_token);
3310: elsif (l_column = 'OWNER') then
3311: l_unique_key_column_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);

Line 3314: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

3310: elsif (l_column = 'OWNER') then
3311: l_unique_key_column_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
3312: elsif (l_column = 'LAST_UPDATE_DATE') then
3313: l_unique_key_column_rec.last_update_date := to_date(l_token,
3314: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
3315: elsif (l_column = 'LAST_UPDATE_LOGIN') then
3316: l_unique_key_column_rec.last_update_login := to_number(l_token);
3317: else
3318: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

3414: --
3415: if (l_value_count = 2) then
3416: l_saved_token := l_token;
3417: end if;
3418: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
3419: (l_value_count is null) then
3420: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3421: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
3422: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 3497: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

3493: elsif (l_column = 'CREATED_BY') then
3494: l_foreign_key_rec.created_by := to_number(l_token);
3495: elsif (l_column = 'CREATION_DATE') then
3496: l_foreign_key_rec.creation_date := to_date(l_token,
3497: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
3498: elsif (l_column = 'LAST_UPDATED_BY') then
3499: l_foreign_key_rec.last_updated_by := to_number(l_token);
3500: elsif (l_column = 'OWNER') then
3501: l_foreign_key_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);

Line 3504: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

3500: elsif (l_column = 'OWNER') then
3501: l_foreign_key_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
3502: elsif (l_column = 'LAST_UPDATE_DATE') then
3503: l_foreign_key_rec.last_update_date := to_date(l_token,
3504: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
3505: elsif (l_column = 'LAST_UPDATE_LOGIN') then
3506: l_foreign_key_rec.last_update_login := to_number(l_token);
3507: else
3508: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

3620: --
3621: if (l_value_count = 2) then
3622: l_saved_token := l_token;
3623: end if;
3624: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
3625: (l_value_count is null) then
3626: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3627: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
3628: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 3693: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

3689: elsif (l_column = 'CREATED_BY') then
3690: l_foreign_key_column_rec.created_by := to_number(l_token);
3691: elsif (l_column = 'CREATION_DATE') then
3692: l_foreign_key_column_rec.creation_date := to_date(l_token,
3693: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
3694: elsif (l_column = 'LAST_UPDATED_BY') then
3695: l_foreign_key_column_rec.last_updated_by := to_number(l_token);
3696: elsif (l_column = 'OWNER') then
3697: l_foreign_key_column_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);

Line 3700: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

3696: elsif (l_column = 'OWNER') then
3697: l_foreign_key_column_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
3698: elsif (l_column = 'LAST_UPDATE_DATE') then
3699: l_foreign_key_column_rec.last_update_date := to_date(l_token,
3700: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
3701: elsif (l_column = 'LAST_UPDATE_LOGIN') then
3702: l_foreign_key_column_rec.last_update_login := to_number(l_token);
3703: else
3704: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN