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

Line 59: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,

55: p_return_status OUT NOCOPY VARCHAR2,
56: p_index IN OUT NOCOPY NUMBER,
57: p_loader_timestamp IN DATE,
58: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
59: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
60: p_line_num_out OUT NOCOPY NUMBER,
61: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
62: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
63: p_pass IN NUMBER := 1

Line 61: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,

57: p_loader_timestamp IN DATE,
58: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
59: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
60: p_line_num_out OUT NOCOPY NUMBER,
61: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
62: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
63: p_pass IN NUMBER := 1
64: ) is
65: l_api_version_number CONSTANT number := 1.0;

Line 62: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,

58: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
59: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
60: p_line_num_out OUT NOCOPY NUMBER,
61: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
62: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,
63: p_pass IN NUMBER := 1
64: ) is
65: l_api_version_number CONSTANT number := 1.0;
66: l_api_name CONSTANT varchar2(30) := 'Upload_Custom';

Line 67: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;

63: p_pass IN NUMBER := 1
64: ) is
65: l_api_version_number CONSTANT number := 1.0;
66: l_api_name CONSTANT varchar2(30) := 'Upload_Custom';
67: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
68: l_column varchar2(30);
69: l_dummy NUMBER;
70: l_eof_flag VARCHAR2(1);
71: l_custom_index NUMBER := 0;

Line 79: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;

75: l_more_custom BOOLEAN := TRUE;
76: l_msg_count NUMBER;
77: l_msg_data VARCHAR2(2000);
78: l_return_status varchar2(1);
79: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
80: l_state NUMBER;
81: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
82: l_value_count NUMBER;
83: l_copy_redo_flag BOOLEAN := FALSE;

Line 81: l_token AK_ON_OBJECTS_PUB.Buffer_Type;

77: l_msg_data VARCHAR2(2000);
78: l_return_status varchar2(1);
79: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
80: l_state NUMBER;
81: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
82: l_value_count NUMBER;
83: l_copy_redo_flag BOOLEAN := FALSE;
84: l_user_id1 NUMBER;
85: l_user_id2 NUMBER;

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

299: --
300: if (l_value_count = 2) then
301: l_saved_token := l_token;
302: end if;
303: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
304: (l_value_count is null) then
305: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
306: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
307: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 359: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

355: elsif (l_column = 'FUNCTION_NAME') then
356: l_custom_rec.function_name := l_token;
357: elsif (l_column = 'START_DATE_ACTIVE') then
358: l_custom_rec.start_date_active := to_date(l_token,
359: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
360: elsif (l_column = 'END_DATE_ACTIVE') then
361: l_custom_rec.end_date_active := to_date(l_token,
362: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
363: elsif (l_column = 'NAME') then

Line 362: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

358: l_custom_rec.start_date_active := to_date(l_token,
359: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
360: elsif (l_column = 'END_DATE_ACTIVE') then
361: l_custom_rec.end_date_active := to_date(l_token,
362: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
363: elsif (l_column = 'NAME') then
364: l_custom_rec.name := l_token;
365: elsif (l_column = 'DESCRIPTION') then
366: l_custom_rec.description := l_token;

Line 371: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

367: elsif (l_column = 'CREATED_BY') then
368: l_custom_rec.created_by := to_number(l_token);
369: elsif (l_column = 'CREATION_DATE') then
370: l_custom_rec.creation_date := to_date(l_token,
371: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
372: elsif (l_column = 'LAST_UPDATED_BY') then
373: l_custom_rec.last_updated_by := to_number(l_token);
374: elsif (l_column = 'OWNER') then
375: l_custom_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);

Line 378: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

374: elsif (l_column = 'OWNER') then
375: l_custom_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
376: elsif (l_column = 'LAST_UPDATE_DATE') then
377: l_custom_rec.last_update_date := to_date(l_token,
378: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
379: elsif (l_column = 'LAST_UPDATE_LOGIN') then
380: l_custom_rec.last_update_login := to_number(l_token);
381: else
382: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

489: --
490: if (l_value_count = 2) then
491: l_saved_token := l_token;
492: end if;
493: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
494: (l_value_count is null) then
495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
496: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
497: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 541: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

537: l_cust_region_rec.created_by := to_number(l_token);
538: l_state := 30;
539: elsif (l_column = 'CREATION_DATE') then
540: l_cust_region_rec.creation_date := to_date(l_token,
541: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
542: l_state := 30;
543: elsif (l_column = 'LAST_UPDATED_BY') then
544: l_cust_region_rec.last_updated_by := to_number(l_token);
545: l_state := 30;

Line 551: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

547: l_cust_region_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
548: l_state := 30;
549: elsif (l_column = 'LAST_UPDATE_DATE') then
550: l_cust_region_rec.last_update_date := to_date(l_token,
551: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
552: l_state := 30;
553: elsif (l_column = 'LAST_UPDATE_LOGIN') then
554: l_cust_region_rec.last_update_login := to_number(l_token);
555: l_state := 30;

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

654: --
655: if (l_value_count = 2) then
656: l_saved_token := l_token;
657: end if;
658: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
659: (l_value_count is null) then
660: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
661: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
662: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 697: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

693: l_cust_reg_item_rec.PROPERTY_NUMBER_VALUE := to_number(l_token);
694: l_state := 130;
695: elsif (l_column = 'PROPERTY_DATE_VALUE') then
696: l_cust_reg_item_rec.PROPERTY_DATE_VALUE := to_date(l_token,
697: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
698: l_state := 130;
699: elsif (l_column = 'PROPERTY_VARCHAR2_VALUE_TL') then
700: l_cust_reg_item_rec.PROPERTY_VARCHAR2_VALUE_TL := l_token;
701: l_state := 130;

Line 707: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

703: l_cust_reg_item_rec.created_by := to_number(l_token);
704: l_state := 130;
705: elsif (l_column = 'CREATION_DATE') then
706: l_cust_reg_item_rec.creation_date := to_date(l_token,
707: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
708: l_state := 130;
709: elsif (l_column = 'LAST_UPDATED_BY') then
710: l_cust_reg_item_rec.last_updated_by := to_number(l_token);
711: l_state := 130;

Line 717: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

713: l_cust_reg_item_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
714: l_state := 130;
715: elsif (l_column = 'LAST_UPDATE_DATE') then
716: l_cust_reg_item_rec.last_update_date := to_date(l_token,
717: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
718: l_state := 130;
719: elsif (l_column = 'LAST_UPDATE_LOGIN') then
720: l_cust_reg_item_rec.last_update_login := to_number(l_token);
721: l_state := 130;

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

821: --
822: if (l_value_count = 2) then
823: l_saved_token := l_token;
824: end if;
825: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
826: (l_value_count is null) then
827: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
828: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
829: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 867: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

863: l_criteria_rec.VALUE_NUMBER := to_number(l_token);
864: l_state := 230;
865: elsif (l_column = 'VALUE_DATE') then
866: l_criteria_rec.VALUE_DATE := to_date(l_token,
867: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
868: l_state := 230;
869: elsif (l_column = 'START_DATE_ACTIVE') then
870: l_criteria_rec.START_DATE_ACTIVE := to_date(l_token,
871: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

Line 871: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

867: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
868: l_state := 230;
869: elsif (l_column = 'START_DATE_ACTIVE') then
870: l_criteria_rec.START_DATE_ACTIVE := to_date(l_token,
871: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
872: l_state := 230;
873: elsif (l_column = 'END_DATE_ACTIVE') then
874: l_criteria_rec.END_DATE_ACTIVE := to_date(l_token,
875: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

Line 875: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

871: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
872: l_state := 230;
873: elsif (l_column = 'END_DATE_ACTIVE') then
874: l_criteria_rec.END_DATE_ACTIVE := to_date(l_token,
875: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
876: l_state := 230;
877: elsif (l_column = 'CREATED_BY') then
878: l_criteria_rec.created_by := to_number(l_token);
879: l_state := 230;

Line 882: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

878: l_criteria_rec.created_by := to_number(l_token);
879: l_state := 230;
880: elsif (l_column = 'CREATION_DATE') then
881: l_criteria_rec.creation_date := to_date(l_token,
882: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
883: l_state := 230;
884: elsif (l_column = 'LAST_UPDATED_BY') then
885: l_criteria_rec.last_updated_by := to_number(l_token);
886: l_state := 230;

Line 892: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

888: l_criteria_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
889: l_state := 230;
890: elsif (l_column = 'LAST_UPDATE_DATE') then
891: l_criteria_rec.last_update_date := to_date(l_token,
892: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
893: l_state := 230;
894: elsif (l_column = 'LAST_UPDATE_LOGIN') then
895: l_criteria_rec.last_update_login := to_number(l_token);
896: l_state := 230;