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.IBU_MES_BIN dependencies on IBU_HOME_PAGE_PVT

Line 122: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;

118: x_msg_data OUT NOCOPY VARCHAR2,
119: x_bin_name out NOCOPY VARCHAR2)
120: as
121: l_api_name CONSTANT VARCHAR2(30) := 'Get_Bin_Name';
122: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;
123: l_cat_id NUMBER := null;
124: begin
125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126: x_bin_name := '';

Line 129: IBU_Home_Page_PVT.get_bin_info(p_api_version_number => p_api_version_number,

125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126: x_bin_name := '';
127:
128: -- get the bin info
129: IBU_Home_Page_PVT.get_bin_info(p_api_version_number => p_api_version_number,
130: p_init_msg_list => p_init_msg_list,
131: x_return_status => x_return_status,
132: x_msg_count => x_msg_count,
133: x_msg_data => x_msg_data,

Line 182: l_user_id NUMBER := IBU_Home_Page_PVT.get_user_id;

178: as
179: l_api_name CONSTANT VARCHAR2(30) := 'Get_Email_Text';
180: l_api_version CONSTANT NUMBER := 1.0;
181:
182: l_user_id NUMBER := IBU_Home_Page_PVT.get_user_id;
183: l_lang VARCHAR2(5) := IBU_Home_Page_PVT.get_lang_code;
184:
185: l_bin_name VARCHAR2(80);
186: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;

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

179: l_api_name CONSTANT VARCHAR2(30) := 'Get_Email_Text';
180: l_api_version CONSTANT NUMBER := 1.0;
181:
182: l_user_id NUMBER := IBU_Home_Page_PVT.get_user_id;
183: l_lang VARCHAR2(5) := IBU_Home_Page_PVT.get_lang_code;
184:
185: l_bin_name VARCHAR2(80);
186: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;
187: l_data IBU_Home_Page_PVT.Filter_Data_Type;

Line 186: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;

182: l_user_id NUMBER := IBU_Home_Page_PVT.get_user_id;
183: l_lang VARCHAR2(5) := IBU_Home_Page_PVT.get_lang_code;
184:
185: l_bin_name VARCHAR2(80);
186: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;
187: l_data IBU_Home_Page_PVT.Filter_Data_Type;
188: l_filter_list IBU_Home_Page_PVT.Filter_Data_List_Type;
189: l_filter_string VARCHAR2(500);
190:

Line 187: l_data IBU_Home_Page_PVT.Filter_Data_Type;

183: l_lang VARCHAR2(5) := IBU_Home_Page_PVT.get_lang_code;
184:
185: l_bin_name VARCHAR2(80);
186: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;
187: l_data IBU_Home_Page_PVT.Filter_Data_Type;
188: l_filter_list IBU_Home_Page_PVT.Filter_Data_List_Type;
189: l_filter_string VARCHAR2(500);
190:
191: res_clob CLOB;

Line 188: l_filter_list IBU_Home_Page_PVT.Filter_Data_List_Type;

184:
185: l_bin_name VARCHAR2(80);
186: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;
187: l_data IBU_Home_Page_PVT.Filter_Data_Type;
188: l_filter_list IBU_Home_Page_PVT.Filter_Data_List_Type;
189: l_filter_string VARCHAR2(500);
190:
191: res_clob CLOB;
192: tmp_str VARCHAR(400);

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

249: FND_MSG_PUB.Add;
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252:
253: IBU_Home_Page_PVT.get_bin_info(p_api_version_number => l_api_version,
254: p_init_msg_list => p_init_msg_list,
255: x_return_status => x_return_status,
256: x_msg_count => x_msg_count,
257: x_msg_data => x_msg_data,

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

273: FND_MSG_PUB.Add;
274: RAISE FND_API.G_EXC_ERROR;
275: END IF;
276:
277: IBU_Home_Page_PVT.get_filter_list(p_api_version => l_api_version,
278: x_return_status => x_return_status,
279: x_msg_count => x_msg_count,
280: x_msg_data => x_msg_data,
281: p_user_id => l_user_id,

Line 325: channel_title := IBU_HOME_PAGE_PVT.GET_AK_BIN_PROMPT('IBU_HOM_CNEWS_CHANNEL');

321: RAISE FND_API.G_EXC_ERROR;
322: END IF;
323:
324: ---------------------------------------------------------------------------
325: channel_title := IBU_HOME_PAGE_PVT.GET_AK_BIN_PROMPT('IBU_HOM_CNEWS_CHANNEL');
326: items_title := IBU_HOME_PAGE_PVT.GET_AK_BIN_PROMPT('IBU_HOM_CNEWS_ITEMS');
327:
328: dbms_lob.createtemporary(res_clob, TRUE, DBMS_LOB.SESSION);
329:

Line 326: items_title := IBU_HOME_PAGE_PVT.GET_AK_BIN_PROMPT('IBU_HOM_CNEWS_ITEMS');

322: END IF;
323:
324: ---------------------------------------------------------------------------
325: channel_title := IBU_HOME_PAGE_PVT.GET_AK_BIN_PROMPT('IBU_HOM_CNEWS_CHANNEL');
326: items_title := IBU_HOME_PAGE_PVT.GET_AK_BIN_PROMPT('IBU_HOM_CNEWS_ITEMS');
327:
328: dbms_lob.createtemporary(res_clob, TRUE, DBMS_LOB.SESSION);
329:
330: location := 1;

Line 477: l_user_id NUMBER := IBU_Home_Page_PVT.get_user_id;

473: as
474: l_api_name CONSTANT VARCHAR2(30) := 'Get_HTML';
475: l_api_version CONSTANT NUMBER := 1.0;
476:
477: l_user_id NUMBER := IBU_Home_Page_PVT.get_user_id;
478: l_lang VARCHAR2(5) := IBU_Home_Page_PVT.get_lang_code;
479:
480: l_bin_name VARCHAR2(80);
481: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;

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

474: l_api_name CONSTANT VARCHAR2(30) := 'Get_HTML';
475: l_api_version CONSTANT NUMBER := 1.0;
476:
477: l_user_id NUMBER := IBU_Home_Page_PVT.get_user_id;
478: l_lang VARCHAR2(5) := IBU_Home_Page_PVT.get_lang_code;
479:
480: l_bin_name VARCHAR2(80);
481: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;
482: header_format VARCHAR2(30) := 'tableSubHeaderCell';

Line 481: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;

477: l_user_id NUMBER := IBU_Home_Page_PVT.get_user_id;
478: l_lang VARCHAR2(5) := IBU_Home_Page_PVT.get_lang_code;
479:
480: l_bin_name VARCHAR2(80);
481: l_bin_info IBU_Home_Page_PVT.Bin_Data_Type;
482: header_format VARCHAR2(30) := 'tableSubHeaderCell';
483: cell_format VARCHAR2(20) := 'tableDataCell';
484: tmp_str VARCHAR2 (5000);
485: header_str VARCHAR2 (13000);

Line 488: s_all_header_prompts IBU_HOME_PAGE_PVT.IBU_STR_ARR;

484: tmp_str VARCHAR2 (5000);
485: header_str VARCHAR2 (13000);
486: res_clob CLOB;
487: newln VARCHAR2(2) := fnd_global.newline ();
488: s_all_header_prompts IBU_HOME_PAGE_PVT.IBU_STR_ARR;
489:
490: l_data IBU_Home_Page_PVT.Filter_Data_Type;
491: l_filter_list IBU_Home_Page_PVT.Filter_Data_List_Type;
492: l_filter_string VARCHAR2(500);

Line 490: l_data IBU_Home_Page_PVT.Filter_Data_Type;

486: res_clob CLOB;
487: newln VARCHAR2(2) := fnd_global.newline ();
488: s_all_header_prompts IBU_HOME_PAGE_PVT.IBU_STR_ARR;
489:
490: l_data IBU_Home_Page_PVT.Filter_Data_Type;
491: l_filter_list IBU_Home_Page_PVT.Filter_Data_List_Type;
492: l_filter_string VARCHAR2(500);
493:
494: l_edit_url VARCHAR2(5000);

Line 491: l_filter_list IBU_Home_Page_PVT.Filter_Data_List_Type;

487: newln VARCHAR2(2) := fnd_global.newline ();
488: s_all_header_prompts IBU_HOME_PAGE_PVT.IBU_STR_ARR;
489:
490: l_data IBU_Home_Page_PVT.Filter_Data_Type;
491: l_filter_list IBU_Home_Page_PVT.Filter_Data_List_Type;
492: l_filter_string VARCHAR2(500);
493:
494: l_edit_url VARCHAR2(5000);
495: l_close_url VARCHAR2(5000);

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

558: FND_MSG_PUB.Add;
559: RAISE FND_API.G_EXC_ERROR;
560: END IF;
561:
562: IBU_Home_Page_PVT.get_bin_info(p_api_version_number => l_api_version,
563: p_init_msg_list => p_init_msg_list,
564: x_return_status => x_return_status,
565: x_msg_count => x_msg_count,
566: x_msg_data => x_msg_data,

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

582: FND_MSG_PUB.Add;
583: RAISE FND_API.G_EXC_ERROR;
584: END IF;
585:
586: IBU_Home_Page_PVT.get_filter_list(p_api_version => l_api_version,
587: x_return_status => x_return_status,
588: x_msg_count => x_msg_count,
589: x_msg_data => x_msg_data,
590: p_user_id => l_user_id,

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

609: end if;
610: END LOOP;
611: END IF;
612:
613: l_edit_url := IBU_Home_Page_PVT.get_edit_bin_url(p_bin_id, 'ibuhmesc.jsp', l_filter_string, p_cookie_url);
614:
615: if l_bin_info.mandatory_flag = FND_API.G_FALSE then
616: l_close_url := IBU_Home_Page_PVT.get_close_bin_url(p_bin_id, p_cookie_url);
617: else

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

612:
613: l_edit_url := IBU_Home_Page_PVT.get_edit_bin_url(p_bin_id, 'ibuhmesc.jsp', l_filter_string, p_cookie_url);
614:
615: if l_bin_info.mandatory_flag = FND_API.G_FALSE then
616: l_close_url := IBU_Home_Page_PVT.get_close_bin_url(p_bin_id, p_cookie_url);
617: else
618: l_close_url := null;
619: end if;
620:

Line 631: header_str := IBU_Home_Page_PVT.get_bin_header_html (l_bin_name, null, l_edit_url, l_close_url);

627: dbms_lob.writeappend(res_clob,4,'');
628: dbms_lob.writeappend(res_clob,length(newln), newln);
629: dbms_lob.writeappend(res_clob,4,'');
630: dbms_lob.writeappend(res_clob,length(newln), newln);
631: header_str := IBU_Home_Page_PVT.get_bin_header_html (l_bin_name, null, l_edit_url, l_close_url);
632:
633: dbms_lob.writeappend(res_clob,length(header_str),header_str);
634: dbms_lob.writeappend(res_clob,length(newln), newln);
635: dbms_lob.writeappend(res_clob,5,'');

Line 660: channel_title := IBU_HOME_PAGE_PVT.GET_AK_BIN_PROMPT('IBU_HOM_CNEWS_CHANNEL');

656: RAISE FND_API.G_EXC_ERROR;
657: END IF;
658:
659: ---------------------------------------------------------------------------
660: channel_title := IBU_HOME_PAGE_PVT.GET_AK_BIN_PROMPT('IBU_HOM_CNEWS_CHANNEL');
661: items_title := IBU_HOME_PAGE_PVT.GET_AK_BIN_PROMPT('IBU_HOM_CNEWS_ITEMS');
662:
663: /* dbms_output.put_line('title=' || channel_title); */
664: /* dbms_output.put_line('ititle=' || items_title); */

Line 661: items_title := IBU_HOME_PAGE_PVT.GET_AK_BIN_PROMPT('IBU_HOM_CNEWS_ITEMS');

657: END IF;
658:
659: ---------------------------------------------------------------------------
660: channel_title := IBU_HOME_PAGE_PVT.GET_AK_BIN_PROMPT('IBU_HOM_CNEWS_CHANNEL');
661: items_title := IBU_HOME_PAGE_PVT.GET_AK_BIN_PROMPT('IBU_HOM_CNEWS_ITEMS');
662:
663: /* dbms_output.put_line('title=' || channel_title); */
664: /* dbms_output.put_line('ititle=' || items_title); */
665: -- dbms_lob.createtemporary(res_clob, TRUE, DBMS_LOB.SESSION);