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_REGION_PUB

Line 82: l_item_rec AK_REGION_PUB.Item_Rec_Type;

78: and region_code = region_code_param;
79: l_api_version_number CONSTANT number := 1.0;
80: l_api_name CONSTANT varchar2(30) := 'Upload_Region';
81: l_item_index NUMBER := 0;
82: l_item_rec AK_REGION_PUB.Item_Rec_Type;
83: l_item_tbl AK_REGION_PUB.Item_Tbl_Type;
84: -- l_graph_index NUMBER := 0;
85: -- l_graph_rec AK_REGION_PUB.Graph_Rec_Type;
86: -- l_empty_graph_rec AK_REGION_PUB.Graph_Rec_Type;

Line 83: l_item_tbl AK_REGION_PUB.Item_Tbl_Type;

79: l_api_version_number CONSTANT number := 1.0;
80: l_api_name CONSTANT varchar2(30) := 'Upload_Region';
81: l_item_index NUMBER := 0;
82: l_item_rec AK_REGION_PUB.Item_Rec_Type;
83: l_item_tbl AK_REGION_PUB.Item_Tbl_Type;
84: -- l_graph_index NUMBER := 0;
85: -- l_graph_rec AK_REGION_PUB.Graph_Rec_Type;
86: -- l_empty_graph_rec AK_REGION_PUB.Graph_Rec_Type;
87: -- l_graph_tbl AK_REGION_PUB.Graph_Tbl_Type;

Line 85: -- l_graph_rec AK_REGION_PUB.Graph_Rec_Type;

81: l_item_index NUMBER := 0;
82: l_item_rec AK_REGION_PUB.Item_Rec_Type;
83: l_item_tbl AK_REGION_PUB.Item_Tbl_Type;
84: -- l_graph_index NUMBER := 0;
85: -- l_graph_rec AK_REGION_PUB.Graph_Rec_Type;
86: -- l_empty_graph_rec AK_REGION_PUB.Graph_Rec_Type;
87: -- l_graph_tbl AK_REGION_PUB.Graph_Tbl_Type;
88: -- l_graph_column_index NUMBER := 0;
89: -- l_graph_column_rec AK_REGION_GRAPH_COLUMNS%ROWTYPE;

Line 86: -- l_empty_graph_rec AK_REGION_PUB.Graph_Rec_Type;

82: l_item_rec AK_REGION_PUB.Item_Rec_Type;
83: l_item_tbl AK_REGION_PUB.Item_Tbl_Type;
84: -- l_graph_index NUMBER := 0;
85: -- l_graph_rec AK_REGION_PUB.Graph_Rec_Type;
86: -- l_empty_graph_rec AK_REGION_PUB.Graph_Rec_Type;
87: -- l_graph_tbl AK_REGION_PUB.Graph_Tbl_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;

Line 87: -- l_graph_tbl AK_REGION_PUB.Graph_Tbl_Type;

83: l_item_tbl AK_REGION_PUB.Item_Tbl_Type;
84: -- l_graph_index NUMBER := 0;
85: -- l_graph_rec AK_REGION_PUB.Graph_Rec_Type;
86: -- l_empty_graph_rec AK_REGION_PUB.Graph_Rec_Type;
87: -- l_graph_tbl AK_REGION_PUB.Graph_Tbl_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;

Line 91: -- l_graph_column_tbl AK_REGION_PUB.Graph_Column_Tbl_Type;

87: -- l_graph_tbl AK_REGION_PUB.Graph_Tbl_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);

Line 105: l_region_rec AK_REGION_PUB.Region_Rec_Type;

101: l_msg_data VARCHAR2(2000);
102: l_region_index NUMBER := 0;
103: l_lov_relation_index NUMBER := 0;
104: l_category_usage_index NUMBER := 0;
105: l_region_rec AK_REGION_PUB.Region_Rec_Type;
106: l_region_tbl AK_REGION_PUB.Region_Tbl_Type;
107: l_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;
108: l_empty_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;
109: l_lov_relation_tbl AK_REGION_PUB.Lov_Relation_Tbl_Type;

Line 106: l_region_tbl AK_REGION_PUB.Region_Tbl_Type;

102: l_region_index NUMBER := 0;
103: l_lov_relation_index NUMBER := 0;
104: l_category_usage_index NUMBER := 0;
105: l_region_rec AK_REGION_PUB.Region_Rec_Type;
106: l_region_tbl AK_REGION_PUB.Region_Tbl_Type;
107: l_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;
108: l_empty_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;
109: l_lov_relation_tbl AK_REGION_PUB.Lov_Relation_Tbl_Type;
110: l_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;

Line 109: l_lov_relation_tbl AK_REGION_PUB.Lov_Relation_Tbl_Type;

105: l_region_rec AK_REGION_PUB.Region_Rec_Type;
106: l_region_tbl AK_REGION_PUB.Region_Tbl_Type;
107: l_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;
108: l_empty_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;
109: l_lov_relation_tbl AK_REGION_PUB.Lov_Relation_Tbl_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);

Line 112: l_category_usage_tbl AK_REGION_PUB.Category_Usages_Tbl_Type;

108: l_empty_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;
109: l_lov_relation_tbl AK_REGION_PUB.Lov_Relation_Tbl_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;

Line 236: l_region_rec := AK_REGION_PUB.G_MISS_REGION_REC;

232: end if;
233: elsif (l_state = 1) then
234: if (l_token = 'REGION') then
235: --== Clear out previous column data ==--
236: l_region_rec := AK_REGION_PUB.G_MISS_REGION_REC;
237: l_state := 2;
238: else
239: -- Found the beginning of a non-region object,
240: -- rebuild last line and pass it back to the caller

Line 500: l_item_rec := AK_REGION_PUB.G_MISS_ITEM_REC;

496: elsif (l_state = 13) then
497: if (l_token = 'REGION_ITEM') then
498: --== Clear out previous region item column data ==--
499: -- and load region key values into record --
500: l_item_rec := AK_REGION_PUB.G_MISS_ITEM_REC;
501: l_item_rec.region_application_id := l_region_rec.region_application_id;
502: l_item_rec.region_code := l_region_rec.region_code;
503: l_state := 20;
504: elsif ( l_token = 'REGION_LOV_RELATION') then