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_ITEM_OUTPUT_OBJ

Line 277: ,x_out OUT NOCOPY inv_ebi_item_output_obj

273: ***********************************************************************************/
274:
275: PROCEDURE populate_item_ids(
276: p_item IN inv_ebi_item_obj
277: ,x_out OUT NOCOPY inv_ebi_item_output_obj
278: ,x_item OUT NOCOPY inv_ebi_item_obj
279: ) IS
280: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
281: l_output_status inv_ebi_output_status;

Line 286: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);

282: BEGIN
283: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_HELPER.populate_item_ids');
284: x_item := p_item;
285: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
286: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
287: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
288: IF ( (p_item.main_obj_type.organization_id IS NULL OR p_item.main_obj_type.organization_id = fnd_api.g_miss_num)
289: AND p_item.main_obj_type.organization_code IS NOT NULL ) THEN
290: l_pk_col_name_val_pairs.EXTEND(1);

Line 1533: ,x_out OUT NOCOPY inv_ebi_item_output_obj

1529: PROCEDURE process_item_pvt(
1530: p_commit IN VARCHAR2 := FND_API.g_false
1531: ,p_operation IN VARCHAR2
1532: ,p_item IN inv_ebi_item_obj
1533: ,x_out OUT NOCOPY inv_ebi_item_output_obj
1534: )
1535: IS
1536: l_transaction_type VARCHAR2(20);
1537: l_item_exits VARCHAR2(3);

Line 1614: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);

1610: SAVEPOINT inv_ebi_pvt_item_save_pnt;
1611: l_item := p_item;
1612: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_HELPER.process_item_pvt ');
1613: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1614: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
1615: l_item_number := l_item.main_obj_type.item_number;
1616: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
1617: IF(l_item_number IS NULL OR l_item_number = fnd_api.g_miss_char) THEN
1618: l_item_number := get_item_num(

Line 2668: ,x_uda_output_obj OUT NOCOPY inv_ebi_item_output_obj

2664: ,p_revision_id IN NUMBER DEFAULT NULL
2665: ,p_revision_code IN VARCHAR2 DEFAULT NULL
2666: ,p_uda_input_obj IN inv_ebi_uda_input_obj
2667: ,p_commit IN VARCHAR2 := fnd_api.g_false
2668: ,x_uda_output_obj OUT NOCOPY inv_ebi_item_output_obj
2669: )
2670: IS
2671: l_uda_out inv_ebi_uda_output_obj;
2672: l_attributes_row_table ego_user_attr_row_table;

Line 2704: x_uda_output_obj := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,l_uda_out,NULL,NULL,NULL,NULL,NULL);

2700: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_HELPER.process_item_uda');
2701: INV_EBI_UTIL.debug_line('STEP 20: INVENTORY ITEM ID: '|| p_inventory_item_id || 'ORG ID: '||p_organization_id);
2702: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
2703: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2704: x_uda_output_obj := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,l_uda_out,NULL,NULL,NULL,NULL,NULL);
2705: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_ITEM_HELPER.transform_uda');
2706: INV_EBI_UTIL.transform_uda (
2707: p_uda_input_obj => p_uda_input_obj
2708: ,x_attributes_row_table => l_attributes_row_table

Line 2880: ,x_out OUT NOCOPY inv_ebi_item_output_obj

2876: ,p_commit IN VARCHAR2 := fnd_api.g_false
2877: ,p_inventory_item_id IN NUMBER
2878: ,p_item_number IN VARCHAR2
2879: ,p_org_id_tbl IN inv_ebi_org_tbl
2880: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2881: )
2882: IS
2883: l_item_org_assignment_rec ego_item_pub.item_org_assignment_rec_type;
2884: l_item_org_assignment_tbl ego_item_pub.item_org_assignment_tbl_type;

Line 2893: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);

2889: SAVEPOINT inv_ebi_org_id_save_pnt;
2890: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_HELPER.process_org_id_assignments ');
2891: INV_EBI_UTIL.debug_line('STEP 20: ITEM ID: '|| p_inventory_item_id || 'ITEM NUMBER: ' || p_item_number);
2892: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2893: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
2894: IF p_org_id_tbl.COUNT > 0 THEN
2895: FOR i IN 1..p_org_id_tbl.COUNT LOOP
2896: l_item_org_assignment_rec.inventory_item_id := p_inventory_item_id;
2897: l_item_org_assignment_rec.item_number := p_item_number;

Line 3110: ,x_out OUT NOCOPY inv_ebi_item_output_obj

3106: ,p_commit IN VARCHAR2 := fnd_api.g_false
3107: ,p_inventory_item_id IN NUMBER
3108: ,p_organization_id IN NUMBER
3109: ,p_category_id_tbl IN inv_ebi_category_obj_tbl_type
3110: ,x_out OUT NOCOPY inv_ebi_item_output_obj
3111: )
3112: IS
3113:
3114: l_category_output inv_ebi_category_output_obj;

Line 3125: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_category_output,NULL,NULL,NULL,NULL);

3121: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');
3122: INV_EBI_UTIL.debug_line('STEP 20: ITEM ID: '|| p_inventory_item_id || 'ORG ID: '|| p_organization_id);
3123: l_category_output := inv_ebi_category_output_obj(NULL);
3124: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
3125: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_category_output,NULL,NULL,NULL,NULL);
3126: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING EGO_ITEM_PUB.process_item_cat_assignment');
3127: l_no_multi_assign_cat_set_tbl :=FND_TABLE_OF_NUMBER();
3128: FOR i IN 1..p_category_id_tbl.COUNT LOOP
3129: l_category_id := p_category_id_tbl(i).cat_id;

Line 3254: ,x_out OUT NOCOPY inv_ebi_item_output_obj

3250: p_commit IN VARCHAR2 := fnd_api.g_false
3251: ,p_organization_id IN NUMBER
3252: ,p_inventory_item_id IN NUMBER
3253: ,p_mfg_part_obj IN inv_ebi_manufacturer_part_obj
3254: ,x_out OUT NOCOPY inv_ebi_item_output_obj
3255: )
3256: IS
3257: l_count NUMBER := 0;
3258: l_rowid VARCHAR2(100);

Line 3319: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);

3315: BEGIN
3316: SAVEPOINT inv_ebi_part_num_save_pnt;
3317: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_HELPER.process_part_num_association ');
3318: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
3319: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
3320: IF p_mfg_part_obj.mfg_part_num IS NOT NULL THEN
3321: INV_EBI_UTIL.debug_line('STEP 20: ORGANIZATION ID: '|| p_organization_id || 'MFG PART NUMBER: '|| p_mfg_part_obj.mfg_part_num ||
3322: ' MANUFACTURER ID : '|| p_mfg_part_obj.manufacturer_id);
3323: OPEN c_mfg_part_num(

Line 3603: ,x_out OUT NOCOPY inv_ebi_item_output_obj

3599:
3600: PROCEDURE process_update_item_lifecycle(
3601: p_commit IN VARCHAR2 := FND_API.g_false
3602: ,p_update_item_tbl IN inv_ebi_item_attr_tbl
3603: ,x_out OUT NOCOPY inv_ebi_item_output_obj
3604: ) IS
3605:
3606: l_output_status inv_ebi_output_status;
3607: l_inventory_item_id NUMBER;

Line 3680: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);

3676: SAVEPOINT inv_ebi_proc_upd_item_lc_pnt;
3677:
3678: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_HELPER.process_update_item_lifecycle');
3679: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
3680: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
3681:
3682: IF(p_update_item_tbl IS NOT NULL AND p_update_item_tbl.COUNT > 0) THEN
3683:
3684: FOR i IN 1..p_update_item_tbl.COUNT LOOP

Line 3995: ,x_out OUT NOCOPY inv_ebi_item_output_obj

3991: Procedure sync_item (
3992: p_commit IN VARCHAR2 := FND_API.g_false
3993: ,p_operation IN VARCHAR2
3994: ,p_item IN inv_ebi_item_obj
3995: ,x_out OUT NOCOPY inv_ebi_item_output_obj
3996: ) IS
3997: l_out inv_ebi_item_output_obj;
3998: l_api_version NUMBER:=1.0;
3999: l_inventory_item_id NUMBER;

Line 3997: l_out inv_ebi_item_output_obj;

3993: ,p_operation IN VARCHAR2
3994: ,p_item IN inv_ebi_item_obj
3995: ,x_out OUT NOCOPY inv_ebi_item_output_obj
3996: ) IS
3997: l_out inv_ebi_item_output_obj;
3998: l_api_version NUMBER:=1.0;
3999: l_inventory_item_id NUMBER;
4000: l_organization_id NUMBER;
4001: l_organization_code VARCHAR2(3);

Line 4017: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);

4013: l_ret VARCHAR2(1);
4014: BEGIN
4015: SAVEPOINT inv_ebi_sync_item_save_pnt;
4016: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
4017: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
4018: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
4019:
4020: --Create or update item
4021: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_HELPER.sync_item ');

Line 4142: x_out := inv_ebi_item_output_obj(l_inventory_item_id,l_organization_id,l_organization_code,l_item_number,l_out.output_status,NULL,l_category_output,NULL,l_operating_unit,l_operating_unit_id,l_description);

4138: IF (l_ret <> FND_API.g_ret_sts_success) THEN
4139: RAISE FND_API.g_exc_unexpected_error;
4140: END IF;
4141: END IF;
4142: x_out := inv_ebi_item_output_obj(l_inventory_item_id,l_organization_id,l_organization_code,l_item_number,l_out.output_status,NULL,l_category_output,NULL,l_operating_unit,l_operating_unit_id,l_description);
4143:
4144: IF fnd_api.to_boolean(p_commit) THEN
4145: COMMIT;
4146: END IF;