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.INV_EBI_ITEM_HELPER dependencies on INV_EBI_GET_OPR_ATTRS_TBL

Line 4677: ,p_item_tbl IN inv_ebi_get_opr_attrs_tbl

4673: ************************************************************************************/
4674:
4675: PROCEDURE filter_items_based_on_org(
4676: p_org_codes IN VARCHAR2
4677: ,p_item_tbl IN inv_ebi_get_opr_attrs_tbl
4678: ,x_item_tbl OUT NOCOPY inv_ebi_get_opr_attrs_tbl
4679: ,x_return_status OUT NOCOPY VARCHAR2
4680: ,x_msg_count OUT NOCOPY NUMBER
4681: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 4678: ,x_item_tbl OUT NOCOPY inv_ebi_get_opr_attrs_tbl

4674:
4675: PROCEDURE filter_items_based_on_org(
4676: p_org_codes IN VARCHAR2
4677: ,p_item_tbl IN inv_ebi_get_opr_attrs_tbl
4678: ,x_item_tbl OUT NOCOPY inv_ebi_get_opr_attrs_tbl
4679: ,x_return_status OUT NOCOPY VARCHAR2
4680: ,x_msg_count OUT NOCOPY NUMBER
4681: ,x_msg_data OUT NOCOPY VARCHAR2)
4682: IS

Line 4684: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;

4680: ,x_msg_count OUT NOCOPY NUMBER
4681: ,x_msg_data OUT NOCOPY VARCHAR2)
4682: IS
4683: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
4684: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
4685: l_counter NUMBER:=0;
4686: BEGIN
4687: x_return_status := FND_API.g_ret_sts_success;
4688: l_item_output_tbl := inv_ebi_get_opr_attrs_tbl();

Line 4688: l_item_output_tbl := inv_ebi_get_opr_attrs_tbl();

4684: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
4685: l_counter NUMBER:=0;
4686: BEGIN
4687: x_return_status := FND_API.g_ret_sts_success;
4688: l_item_output_tbl := inv_ebi_get_opr_attrs_tbl();
4689:
4690: IF p_org_codes IS NOT NULL THEN
4691: l_org_tbl := parse_input_string(p_org_codes);
4692: END IF;

Line 4725: ,x_item_tbl OUT NOCOPY inv_ebi_get_opr_attrs_tbl

4721: ************************************************************************************/
4722: PROCEDURE parse_and_get_item(
4723: p_item_names IN VARCHAR2
4724: ,p_org_codes IN VARCHAR2
4725: ,x_item_tbl OUT NOCOPY inv_ebi_get_opr_attrs_tbl
4726: ,x_return_status OUT NOCOPY VARCHAR2
4727: ,x_msg_count OUT NOCOPY NUMBER
4728: ,x_msg_data OUT NOCOPY VARCHAR2)
4729: IS

Line 4738: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;

4734: l_entity_exist NUMBER :=0;
4735: l_entity_count NUMBER :=0;
4736: l_org_id NUMBER;
4737: l_item_id NUMBER;
4738: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
4739: l_item_obj inv_ebi_get_operational_attrs;
4740: l_item_tbl FND_TABLE_OF_VARCHAR2_255;
4741: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
4742: l_valid_item_tbl FND_TABLE_OF_VARCHAR2_255;

Line 4752: l_item_output_tbl := inv_ebi_get_opr_attrs_tbl();

4748: WHERE msik.concatenated_segments = p_item_name
4749: AND msik.organization_id = mp.organization_id;
4750: BEGIN
4751: x_return_status := FND_API.g_ret_sts_success;
4752: l_item_output_tbl := inv_ebi_get_opr_attrs_tbl();
4753:
4754: IF p_item_names IS NOT NULL THEN
4755: l_item_tbl := parse_input_string(p_item_names);
4756: END IF;

Line 4908: ,x_items OUT NOCOPY inv_ebi_get_opr_attrs_tbl

4904: p_name_value_list IN inv_ebi_name_value_tbl
4905: ,p_prog_id IN NUMBER
4906: ,p_appl_id IN NUMBER
4907: ,p_cross_reference_type IN VARCHAR2
4908: ,x_items OUT NOCOPY inv_ebi_get_opr_attrs_tbl
4909: ,x_return_status OUT NOCOPY VARCHAR2
4910: ,x_msg_count OUT NOCOPY NUMBER
4911: ,x_msg_data OUT NOCOPY VARCHAR2
4912: )

Line 4922: l_item_org_output_tbl inv_ebi_get_opr_attrs_tbl;

4918: l_to_date DATE := NULL;
4919: l_from_date_str VARCHAR2(30);
4920: l_to_date_str VARCHAR2(30);
4921: l_last_x_hrs NUMBER;
4922: l_item_org_output_tbl inv_ebi_get_opr_attrs_tbl;
4923: l_item_tbl inv_ebi_get_opr_attrs_tbl;
4924: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
4925: l_item_tbl_flst inv_ebi_get_opr_attrs_tbl;
4926: l_msg_data VARCHAR2(2000);

Line 4923: l_item_tbl inv_ebi_get_opr_attrs_tbl;

4919: l_from_date_str VARCHAR2(30);
4920: l_to_date_str VARCHAR2(30);
4921: l_last_x_hrs NUMBER;
4922: l_item_org_output_tbl inv_ebi_get_opr_attrs_tbl;
4923: l_item_tbl inv_ebi_get_opr_attrs_tbl;
4924: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
4925: l_item_tbl_flst inv_ebi_get_opr_attrs_tbl;
4926: l_msg_data VARCHAR2(2000);
4927: l_msg_count NUMBER;

Line 4924: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;

4920: l_to_date_str VARCHAR2(30);
4921: l_last_x_hrs NUMBER;
4922: l_item_org_output_tbl inv_ebi_get_opr_attrs_tbl;
4923: l_item_tbl inv_ebi_get_opr_attrs_tbl;
4924: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
4925: l_item_tbl_flst inv_ebi_get_opr_attrs_tbl;
4926: l_msg_data VARCHAR2(2000);
4927: l_msg_count NUMBER;
4928: CURSOR c_get_item_list_pim IS

Line 4925: l_item_tbl_flst inv_ebi_get_opr_attrs_tbl;

4921: l_last_x_hrs NUMBER;
4922: l_item_org_output_tbl inv_ebi_get_opr_attrs_tbl;
4923: l_item_tbl inv_ebi_get_opr_attrs_tbl;
4924: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
4925: l_item_tbl_flst inv_ebi_get_opr_attrs_tbl;
4926: l_msg_data VARCHAR2(2000);
4927: l_msg_count NUMBER;
4928: CURSOR c_get_item_list_pim IS
4929: SELECT inv_ebi_get_operational_attrs(item_pim.inventory_item_id,item_pim.concatenated_segments,item_pim.organization_id,item_pim.organization_code,NULL,NULL)

Line 4999: FROM THE (SELECT CAST( l_item_output_tbl as inv_ebi_get_opr_attrs_tbl)

4995: CURSOR c_get_item_flist IS
4996: SELECT inv_ebi_get_operational_attrs(item_flst.item_id,item_flst.item_name,item_flst.organization_id,item_flst.organization_code,NULL,NULL)
4997: FROM (
4998: SELECT a.item_id,a.item_name, a.organization_id,a.organization_code
4999: FROM THE (SELECT CAST( l_item_output_tbl as inv_ebi_get_opr_attrs_tbl)
5000: FROM dual ) a
5001: INTERSECT
5002: SELECT b.item_id,b.item_name, b.organization_id,b.organization_code
5003: FROM THE (SELECT CAST( l_item_tbl as inv_ebi_get_opr_attrs_tbl)

Line 5003: FROM THE (SELECT CAST( l_item_tbl as inv_ebi_get_opr_attrs_tbl)

4999: FROM THE (SELECT CAST( l_item_output_tbl as inv_ebi_get_opr_attrs_tbl)
5000: FROM dual ) a
5001: INTERSECT
5002: SELECT b.item_id,b.item_name, b.organization_id,b.organization_code
5003: FROM THE (SELECT CAST( l_item_tbl as inv_ebi_get_opr_attrs_tbl)
5004: FROM dual ) b
5005: ) item_flst;
5006: BEGIN
5007: FND_MSG_PUB.initialize();

Line 5133: ,x_items OUT NOCOPY inv_ebi_get_opr_attrs_tbl

5129: p_name_value_list IN inv_ebi_name_value_tbl
5130: ,p_prog_id IN NUMBER
5131: ,p_appl_id IN NUMBER
5132: ,p_cross_reference_type IN VARCHAR2
5133: ,x_items OUT NOCOPY inv_ebi_get_opr_attrs_tbl
5134: ,x_return_status OUT NOCOPY VARCHAR2
5135: ,x_msg_count OUT NOCOPY NUMBER
5136: ,x_msg_data OUT NOCOPY VARCHAR2
5137: )

Line 5149: l_item_tbl inv_ebi_get_opr_attrs_tbl;

5145: l_to_date DATE := NULL;
5146: l_from_date_str VARCHAR2(30);
5147: l_to_date_str VARCHAR2(30);
5148: l_last_x_hrs NUMBER;
5149: l_item_tbl inv_ebi_get_opr_attrs_tbl;
5150: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
5151: l_item_org_output_tbl inv_ebi_get_opr_attrs_tbl;
5152: l_item_tbl_flst inv_ebi_get_opr_attrs_tbl;
5153: l_msg_data VARCHAR2(2000);

Line 5150: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;

5146: l_from_date_str VARCHAR2(30);
5147: l_to_date_str VARCHAR2(30);
5148: l_last_x_hrs NUMBER;
5149: l_item_tbl inv_ebi_get_opr_attrs_tbl;
5150: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
5151: l_item_org_output_tbl inv_ebi_get_opr_attrs_tbl;
5152: l_item_tbl_flst inv_ebi_get_opr_attrs_tbl;
5153: l_msg_data VARCHAR2(2000);
5154: l_msg_count NUMBER;

Line 5151: l_item_org_output_tbl inv_ebi_get_opr_attrs_tbl;

5147: l_to_date_str VARCHAR2(30);
5148: l_last_x_hrs NUMBER;
5149: l_item_tbl inv_ebi_get_opr_attrs_tbl;
5150: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
5151: l_item_org_output_tbl inv_ebi_get_opr_attrs_tbl;
5152: l_item_tbl_flst inv_ebi_get_opr_attrs_tbl;
5153: l_msg_data VARCHAR2(2000);
5154: l_msg_count NUMBER;
5155: CURSOR c_get_bal_item_lst_pim IS

Line 5152: l_item_tbl_flst inv_ebi_get_opr_attrs_tbl;

5148: l_last_x_hrs NUMBER;
5149: l_item_tbl inv_ebi_get_opr_attrs_tbl;
5150: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
5151: l_item_org_output_tbl inv_ebi_get_opr_attrs_tbl;
5152: l_item_tbl_flst inv_ebi_get_opr_attrs_tbl;
5153: l_msg_data VARCHAR2(2000);
5154: l_msg_count NUMBER;
5155: CURSOR c_get_bal_item_lst_pim IS
5156: SELECT inv_ebi_get_operational_attrs(gibp.inventory_item_id,gibp.concatenated_segments, gibp.organization_id,gibp.organization_code,NULL,NULL)

Line 5183: FROM THE (SELECT cast( l_item_output_tbl as inv_ebi_get_opr_attrs_tbl)

5179: CURSOR c_get_bal_item_flst IS
5180: SELECT inv_ebi_get_operational_attrs(gibf.item_id,gibf.item_name, gibf.organization_id,gibf.organization_code,NULL,NULL)
5181: FROM (
5182: SELECT a.item_id,a.item_name, a.organization_id,a.organization_code
5183: FROM THE (SELECT cast( l_item_output_tbl as inv_ebi_get_opr_attrs_tbl)
5184: FROM dual ) a
5185: INTERSECT
5186: SELECT b.item_id,b.item_name, b.organization_id,b.organization_code
5187: FROM THE (SELECT cast( l_item_tbl as inv_ebi_get_opr_attrs_tbl)

Line 5187: FROM THE (SELECT cast( l_item_tbl as inv_ebi_get_opr_attrs_tbl)

5183: FROM THE (SELECT cast( l_item_output_tbl as inv_ebi_get_opr_attrs_tbl)
5184: FROM dual ) a
5185: INTERSECT
5186: SELECT b.item_id,b.item_name, b.organization_id,b.organization_code
5187: FROM THE (SELECT cast( l_item_tbl as inv_ebi_get_opr_attrs_tbl)
5188: FROM dual ) b ) gibf;
5189:
5190: BEGIN
5191: FND_MSG_PUB.initialize();