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_REGION2_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: cursor l_check_fnd_category_name_csr (p_category_id in number) is

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: cursor l_check_fnd_category_name_csr (p_category_id in number) is
66: select name

Line 92: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;

88: -- l_graph_column_index NUMBER := 0;
89: -- l_graph_column_rec AK_REGION_GRAPH_COLUMNS%ROWTYPE;
90: -- l_empty_graph_column_rec AK_REGION_GRAPH_COLUMNS%ROWTYPE;
91: -- l_graph_column_tbl AK_REGION_PUB.Graph_Column_Tbl_Type;
92: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
93: l_column varchar2(30);
94: l_dummy NUMBER;
95: l_eof_flag VARCHAR2(1);
96: l_index NUMBER;

Line 114: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;

110: l_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;
111: l_empty_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;
112: l_category_usage_tbl AK_REGION_PUB.Category_Usages_Tbl_Type;
113: l_return_status varchar2(1);
114: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
115: l_state NUMBER;
116: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
117: l_value_count NUMBER;
118: l_copy_redo_flag BOOLEAN := FALSE;

Line 116: l_token AK_ON_OBJECTS_PUB.Buffer_Type;

112: l_category_usage_tbl AK_REGION_PUB.Category_Usages_Tbl_Type;
113: l_return_status varchar2(1);
114: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
115: l_state NUMBER;
116: l_token AK_ON_OBJECTS_PUB.Buffer_Type;
117: l_value_count NUMBER;
118: l_copy_redo_flag BOOLEAN := FALSE;
119: l_user_id1 NUMBER;
120: l_user_id2 NUMBER;

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

339: --
340: if (l_value_count = 2) then
341: l_saved_token := l_token;
342: end if;
343: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
344: (l_value_count is null) then
345: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
346: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
347: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 475: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

471: elsif (l_column = 'CREATED_BY') then
472: l_region_rec.created_by := to_number(l_token);
473: elsif (l_column = 'CREATION_DATE') then
474: l_region_rec.creation_date := to_date(l_token,
475: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
476: elsif (l_column = 'LAST_UPDATED_BY') then
477: l_region_rec.last_updated_by := to_number(l_token);
478: elsif (l_column = 'OWNER') then
479: l_region_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);

Line 482: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

478: elsif (l_column = 'OWNER') then
479: l_region_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
480: elsif (l_column = 'LAST_UPDATE_DATE') then
481: l_region_rec.last_update_date := to_date(l_token,
482: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
483: elsif (l_column = 'LAST_UPDATE_LOGIN') then
484: l_region_rec.last_update_login := to_number(l_token);
485: else
486: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

700: --
701: if (l_value_count = 2) then
702: l_saved_token := l_token;
703: end if;
704: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
705: (l_value_count is null) then
706: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
707: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
708: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 788: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

784: l_item_rec.default_value_number := to_number(l_token);
785: l_state := 30;
786: elsif (l_column = 'DEFAULT_VALUE_DATE') then
787: l_item_rec.default_value_date := to_date(l_token,
788: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
789: l_state := 30;
790: elsif (l_column = 'LOV_REGION') then
791: l_item_rec.lov_region_application_id := to_number(l_token);
792: l_state := 34;

Line 978: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

974: l_item_rec.created_by := to_number(l_token);
975: l_state := 30;
976: elsif (l_column = 'CREATION_DATE') then
977: l_item_rec.creation_date := to_date(l_token,
978: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
979: l_state := 30;
980: elsif (l_column = 'LAST_UPDATED_BY') then
981: l_item_rec.last_updated_by := to_number(l_token);
982: l_state := 30;

Line 988: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

984: l_item_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
985: l_state := 30;
986: elsif (l_column = 'LAST_UPDATE_DATE') then
987: l_item_rec.last_update_date := to_date(l_token,
988: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
989: l_state := 30;
990: elsif (l_column = 'LAST_UPDATE_LOGIN') then
991: l_item_rec.last_update_login := to_number(l_token);
992: l_state := 30;

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

1175: --
1176: if (l_value_count = 2) then
1177: l_saved_token := l_token;
1178: end if;
1179: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1180: (l_value_count is null) then
1181: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1182: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1183: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 1224: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

1220: l_lov_relation_rec.created_by := to_number(l_token);
1221: l_state := 130;
1222: elsif (l_column = 'CREATION_DATE') then
1223: l_lov_relation_rec.creation_date := to_date(l_token,
1224: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
1225: l_state := 130;
1226: elsif (l_column = 'LAST_UPDATED_BY') then
1227: l_lov_relation_rec.last_updated_by := to_number(l_token);
1228: l_state := 130;

Line 1234: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

1230: l_lov_relation_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
1231: l_state := 130;
1232: elsif (l_column = 'LAST_UPDATE_DATE') then
1233: l_lov_relation_rec.last_update_date := to_date(l_token,
1234: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
1235: l_state := 130;
1236: elsif (l_column = 'LAST_UPDATE_LOGIN') then
1237: l_lov_relation_rec.last_update_login := to_number(l_token);
1238: l_state := 130;

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

1309: --
1310: if (l_value_count = 2) then
1311: l_saved_token := l_token;
1312: end if;
1313: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1314: (l_value_count is null) then
1315: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1316: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1317: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 1358: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

1354: l_category_usage_rec.created_by := to_number(l_token);
1355: l_state := 230;
1356: elsif (l_column = 'CREATION_DATE') then
1357: l_category_usage_rec.creation_date := to_date(l_token,
1358: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
1359: l_state := 230;
1360: elsif (l_column = 'LAST_UPDATED_BY') then
1361: l_category_usage_rec.last_updated_by := to_number(l_token);
1362: l_state := 230;

Line 1368: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

1364: l_category_usage_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);
1365: l_state := 230;
1366: elsif (l_column = 'LAST_UPDATE_DATE') then
1367: l_category_usage_rec.last_update_date := to_date(l_token,
1368: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
1369: l_state := 230;
1370: elsif (l_column = 'LAST_UPDATE_LOGIN') then
1371: l_category_usage_rec.last_update_login := to_number(l_token);
1372: l_state := 230;

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

1444: --
1445: if (l_value_count = 2) then
1446: l_saved_token := l_token;
1447: end if;
1448: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1449: (l_value_count is null) then
1450: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1451: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1452: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

Line 1499: -- AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

1495: -- l_graph_rec.created_by := to_number(l_token);
1496: l_state := 310;
1497: elsif (l_column = 'CREATION_DATE') then
1498: -- l_graph_rec.creation_date := to_date(l_token,
1499: -- AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
1500: l_state := 310;
1501: elsif (l_column = 'LAST_UPDATED_BY') then
1502: -- l_graph_rec.last_updated_by := to_number(l_token);
1503: l_state := 310;

Line 1506: -- AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

1502: -- l_graph_rec.last_updated_by := to_number(l_token);
1503: l_state := 310;
1504: elsif (l_column = 'LAST_UPDATE_DATE') then
1505: -- l_graph_rec.last_update_date := to_date(l_token,
1506: -- AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
1507: l_state := 310;
1508: elsif (l_column = 'LAST_UPDATE_LOGIN') then
1509: -- l_graph_rec.last_update_login := to_number(l_token);
1510: l_state := 310;

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

1583: --
1584: if (l_value_count = 2) then
1585: l_saved_token := l_token;
1586: end if;
1587: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1588: (l_value_count is null) then
1589: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1590: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1591: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));