DBA Data[Home] [Help]

APPS.IBU_ALERT_BIN dependencies on IBU_HOME_PAGE_PVT

Line 25: x_bin_name := ibu_home_page_pvt.get_ak_bin_prompt ('IBU_HOM_CAT_ALERT');

21: as
22: l_api_name CONSTANT VARCHAR2(30) := 'Get_Bin_Name';
23: begin
24: x_return_status := FND_API.G_RET_STS_SUCCESS;
25: x_bin_name := ibu_home_page_pvt.get_ak_bin_prompt ('IBU_HOM_CAT_ALERT');
26:
27: EXCEPTION
28: WHEN OTHERS THEN
29: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 115: l_more := ibu_home_page_pvt.get_ak_bin_prompt ('IBU_HOM_CAT_MORE');

111: FND_MSG_PUB.Add;
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114:
115: l_more := ibu_home_page_pvt.get_ak_bin_prompt ('IBU_HOM_CAT_MORE');
116: IF l_more is NULL OR l_more ='' THEN
117: l_more := 'More';
118: end if;
119:

Line 268: l_user_id NUMBER := IBU_Home_Page_PVT.get_user_id;

264: as
265: l_api_name CONSTANT VARCHAR2(30) := 'Get_HTML';
266: l_api_version CONSTANT NUMBER := 1.0;
267:
268: l_user_id NUMBER := IBU_Home_Page_PVT.get_user_id;
269: l_lang VARCHAR2(5) := IBU_Home_Page_PVT.get_lang_code;
270:
271: l_bin_name VARCHAR2(80);
272: l_more VARCHAR2(80);

Line 269: l_lang VARCHAR2(5) := IBU_Home_Page_PVT.get_lang_code;

265: l_api_name CONSTANT VARCHAR2(30) := 'Get_HTML';
266: l_api_version CONSTANT NUMBER := 1.0;
267:
268: l_user_id NUMBER := IBU_Home_Page_PVT.get_user_id;
269: l_lang VARCHAR2(5) := IBU_Home_Page_PVT.get_lang_code;
270:
271: l_bin_name VARCHAR2(80);
272: l_more VARCHAR2(80);
273: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;

Line 273: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;

269: l_lang VARCHAR2(5) := IBU_Home_Page_PVT.get_lang_code;
270:
271: l_bin_name VARCHAR2(80);
272: l_more VARCHAR2(80);
273: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;
274: header_format VARCHAR2(30) := 'tableSubHeaderCell';
275: cell_format VARCHAR2(20) := 'tableDataCell';
276: tmp_str VARCHAR2 (400);
277: res_clob CLOB;

Line 278: s_all_header_prompts IBU_HOME_PAGE_PVT.IBU_STR_ARR;

274: header_format VARCHAR2(30) := 'tableSubHeaderCell';
275: cell_format VARCHAR2(20) := 'tableDataCell';
276: tmp_str VARCHAR2 (400);
277: res_clob CLOB;
278: s_all_header_prompts IBU_HOME_PAGE_PVT.IBU_STR_ARR;
279:
280: l_data IBU_Home_Page_PVT.Filter_Data_Type;
281: l_filter_list IBU_Home_Page_PVT.Filter_Data_List_Type;
282: l_filter_string VARCHAR2(500);

Line 280: l_data IBU_Home_Page_PVT.Filter_Data_Type;

276: tmp_str VARCHAR2 (400);
277: res_clob CLOB;
278: s_all_header_prompts IBU_HOME_PAGE_PVT.IBU_STR_ARR;
279:
280: l_data IBU_Home_Page_PVT.Filter_Data_Type;
281: l_filter_list IBU_Home_Page_PVT.Filter_Data_List_Type;
282: l_filter_string VARCHAR2(500);
283:
284: l_edit_url VARCHAR2(5000);

Line 281: l_filter_list IBU_Home_Page_PVT.Filter_Data_List_Type;

277: res_clob CLOB;
278: s_all_header_prompts IBU_HOME_PAGE_PVT.IBU_STR_ARR;
279:
280: l_data IBU_Home_Page_PVT.Filter_Data_Type;
281: l_filter_list IBU_Home_Page_PVT.Filter_Data_List_Type;
282: l_filter_string VARCHAR2(500);
283:
284: l_edit_url VARCHAR2(5000);
285: l_close_url VARCHAR2(5000);

Line 348: l_more := ibu_home_page_pvt.get_ak_bin_prompt ('IBU_HOM_CAT_MORE');

344: FND_MSG_PUB.Add;
345: RAISE FND_API.G_EXC_ERROR;
346: END IF;
347:
348: l_more := ibu_home_page_pvt.get_ak_bin_prompt ('IBU_HOM_CAT_MORE');
349: IF l_more is NULL OR l_more ='' THEN
350: l_more := 'More';
351: end if;
352:

Line 353: IBU_Home_Page_PVT.get_bin_info(p_api_version_number => l_api_version,

349: IF l_more is NULL OR l_more ='' THEN
350: l_more := 'More';
351: end if;
352:
353: IBU_Home_Page_PVT.get_bin_info(p_api_version_number => l_api_version,
354: p_init_msg_list => p_init_msg_list,
355: x_return_status => x_return_status,
356: x_msg_count => x_msg_count,
357: x_msg_data => x_msg_data,

Line 371: IBU_Home_Page_PVT.get_filter_list(p_api_version => l_api_version,

367: if l_bin_info.row_number > -1 then
368: batch_size := l_bin_info.row_number ;
369: end if;
370:
371: IBU_Home_Page_PVT.get_filter_list(p_api_version => l_api_version,
372: x_return_status => x_return_status,
373: x_msg_count => x_msg_count,
374: x_msg_data => x_msg_data,
375: p_user_id => l_user_id,

Line 398: l_edit_url := IBU_Home_Page_PVT.get_edit_bin_url(p_bin_id, 'ibuhalrt.jsp', l_filter_string, p_cookie_url);

394: end if;
395: END LOOP;
396: END IF;
397:
398: l_edit_url := IBU_Home_Page_PVT.get_edit_bin_url(p_bin_id, 'ibuhalrt.jsp', l_filter_string, p_cookie_url);
399: if l_bin_info.mandatory_flag = FND_API.G_FALSE then
400: l_close_url := IBU_Home_Page_PVT.get_close_bin_url(p_bin_id, p_cookie_url);
401: else
402: l_close_url := null;

Line 400: l_close_url := IBU_Home_Page_PVT.get_close_bin_url(p_bin_id, p_cookie_url);

396: END IF;
397:
398: l_edit_url := IBU_Home_Page_PVT.get_edit_bin_url(p_bin_id, 'ibuhalrt.jsp', l_filter_string, p_cookie_url);
399: if l_bin_info.mandatory_flag = FND_API.G_FALSE then
400: l_close_url := IBU_Home_Page_PVT.get_close_bin_url(p_bin_id, p_cookie_url);
401: else
402: l_close_url := null;
403: end if;
404: l_detail_url := DETAIL_URL || '?' || p_cookie_url;

Line 434: header_str := IBU_Home_Page_PVT.get_bin_header_html(l_bin_name,

430: dbms_lob.writeappend(res_clob, length(tmp_str), tmp_str);
431: dbms_lob.writeappend(res_clob,length(newln), newln);
432:
433:
434: header_str := IBU_Home_Page_PVT.get_bin_header_html(l_bin_name,
435: '',
436: l_edit_url,
437: l_close_url);
438: