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_CHANGE_ORDER_PUB dependencies on INV_EBI_ITEM_HELPER

Line 16: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

12: ,p_revised_item IN inv_ebi_revised_item_obj
13: ,x_item OUT NOCOPY inv_ebi_item_obj
14: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
15: ) IS
16: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
17: l_main_item_obj inv_ebi_item_main_obj;
18: l_output_status inv_ebi_output_status;
19: BEGIN
20: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

Line 78: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

74: IF((p_change_order_obj.organization_id IS NULL
75: OR p_change_order_obj.organization_id = fnd_api.g_miss_num)
76: AND (p_change_order_obj.organization_code IS NOT NULL
77: OR p_change_order_obj.organization_code <> fnd_api.g_miss_char)) THEN
78: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
79: l_pk_col_name_val_pairs.EXTEND(1);
80: l_pk_col_name_val_pairs(1).name := 'organization_code';
81: l_pk_col_name_val_pairs(1).value := p_change_order_obj.organization_code;
82: x_item.main_obj_type.organization_id := INV_EBI_ITEM_HELPER.value_to_id(

Line 82: x_item.main_obj_type.organization_id := INV_EBI_ITEM_HELPER.value_to_id(

78: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
79: l_pk_col_name_val_pairs.EXTEND(1);
80: l_pk_col_name_val_pairs(1).name := 'organization_code';
81: l_pk_col_name_val_pairs(1).value := p_change_order_obj.organization_code;
82: x_item.main_obj_type.organization_id := INV_EBI_ITEM_HELPER.value_to_id(
83: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
84: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
85: );
86: l_pk_col_name_val_pairs.TRIM(1);

Line 84: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION

80: l_pk_col_name_val_pairs(1).name := 'organization_code';
81: l_pk_col_name_val_pairs(1).value := p_change_order_obj.organization_code;
82: x_item.main_obj_type.organization_id := INV_EBI_ITEM_HELPER.value_to_id(
83: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
84: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
85: );
86: l_pk_col_name_val_pairs.TRIM(1);
87: IF (x_item.main_obj_type.organization_id IS NULL) THEN
88: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');

Line 138: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

134: l_output_status inv_ebi_output_status;
135: l_designator_option NUMBER;
136: l_alt_bom_designator VARCHAR2(10);
137: l_inventory_item_id NUMBER;
138: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
139:
140: BEGIN
141: SAVEPOINT inv_ebi_engg_item_save_pnt;
142: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

Line 148: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

144:
145: IF(p_item.main_obj_type.inventory_item_id IS NULL OR
146: p_item.main_obj_type.inventory_item_id = fnd_api.g_miss_num) THEN
147:
148: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
149: l_pk_col_name_val_pairs.EXTEND(2);
150: l_pk_col_name_val_pairs(1).name := 'concatenated_segments';
151: l_pk_col_name_val_pairs(1).value := p_item.main_obj_type.item_number;
152: l_pk_col_name_val_pairs(2).name := 'organization_id';

Line 155: l_inventory_item_id := INV_EBI_ITEM_HELPER.value_to_id(

151: l_pk_col_name_val_pairs(1).value := p_item.main_obj_type.item_number;
152: l_pk_col_name_val_pairs(2).name := 'organization_id';
153: l_pk_col_name_val_pairs(2).value := p_item.main_obj_type.organization_id;
154:
155: l_inventory_item_id := INV_EBI_ITEM_HELPER.value_to_id(
156: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
157: ,p_entity_name => INV_EBI_ITEM_HELPER.G_INVENTORY_ITEM
158: );
159: l_pk_col_name_val_pairs.TRIM(2);

Line 157: ,p_entity_name => INV_EBI_ITEM_HELPER.G_INVENTORY_ITEM

153: l_pk_col_name_val_pairs(2).value := p_item.main_obj_type.organization_id;
154:
155: l_inventory_item_id := INV_EBI_ITEM_HELPER.value_to_id(
156: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
157: ,p_entity_name => INV_EBI_ITEM_HELPER.G_INVENTORY_ITEM
158: );
159: l_pk_col_name_val_pairs.TRIM(2);
160: IF (l_inventory_item_id IS NULL ) THEN
161: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');

Line 182: l_is_engineering_item := INV_EBI_ITEM_HELPER.is_engineering_item(

178: WHERE inventory_item_id = l_inventory_item_id
179: AND organization_id = p_item.main_obj_type.organization_id;
180:
181: END IF;
182: l_is_engineering_item := INV_EBI_ITEM_HELPER.is_engineering_item(
183: p_organization_id => p_item.main_obj_type.organization_id
184: ,p_item_number => p_item.main_obj_type.item_number
185: );
186:

Line 279: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

275: l_is_master_org VARCHAR2(3);
276: l_organization_id NUMBER;
277: l_component_item_name VARCHAR2(240);
278: l_is_component_item_exists VARCHAR2(3);
279: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
280: l_output_status inv_ebi_output_status;
281: BEGIN
282: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
283: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

Line 284: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

280: l_output_status inv_ebi_output_status;
281: BEGIN
282: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
283: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
284: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
285: l_pk_col_name_val_pairs.EXTEND(1);
286: l_pk_col_name_val_pairs(1).name := 'organization_code';
287: l_pk_col_name_val_pairs(1).value := p_organization_code;
288: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(

Line 288: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(

284: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
285: l_pk_col_name_val_pairs.EXTEND(1);
286: l_pk_col_name_val_pairs(1).name := 'organization_code';
287: l_pk_col_name_val_pairs(1).value := p_organization_code;
288: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(
289: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
290: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
291: );
292: IF (l_organization_id IS NULL) THEN

Line 290: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION

286: l_pk_col_name_val_pairs(1).name := 'organization_code';
287: l_pk_col_name_val_pairs(1).value := p_organization_code;
288: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(
289: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
290: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
291: );
292: IF (l_organization_id IS NULL) THEN
293: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
294: FND_MESSAGE.set_token('COL_VALUE',p_organization_code);

Line 303: l_is_component_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(

299: IF(p_component_item_tbl IS NOT NULL AND p_component_item_tbl.COUNT > 0) THEN
300: FOR i IN 1.. p_component_item_tbl.COUNT LOOP
301: IF(p_component_item_tbl(i).transaction_type = INV_EBI_ITEM_PUB.g_otype_create ) THEN
302: l_component_item_name := p_component_item_tbl(i).component_item_name;
303: l_is_component_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(
304: p_organization_id => l_organization_id
305: ,p_item_number => l_component_item_name
306: );
307: IF(l_is_master_org = fnd_api.g_true AND l_is_component_item_exists = fnd_api.g_false) THEN

Line 357: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id (

353: FND_MSG_PUB.initialize;
354: IF p_eco_obj.eco_revised_item_type IS NOT NULL THEN
355: FOR i IN 1..p_eco_obj.eco_revised_item_type.COUNT LOOP
356: IF p_eco_obj.eco_revised_item_type(i).item IS NOT NULL THEN
357: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id (
358: p_organization_code => p_eco_obj.eco_change_order_type.organization_code
359: );
360: IF(INV_EBI_ITEM_HELPER.is_item_exists (
361: p_organization_id => l_organization_id

Line 360: IF(INV_EBI_ITEM_HELPER.is_item_exists (

356: IF p_eco_obj.eco_revised_item_type(i).item IS NOT NULL THEN
357: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id (
358: p_organization_code => p_eco_obj.eco_change_order_type.organization_code
359: );
360: IF(INV_EBI_ITEM_HELPER.is_item_exists (
361: p_organization_id => l_organization_id
362: ,p_item_number => p_eco_obj.eco_revised_item_type(i).revised_item_name
363: ) = FND_API.g_false ) THEN
364: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_create;

Line 407: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

403: ,p_revised_item_type_tbl IN inv_ebi_revised_item_tbl
404: ,x_revised_item_type_tbl OUT NOCOPY inv_ebi_revitem_output_obj_tbl
405: )IS
406: l_organization_id NUMBER;
407: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
408: l_revised_item_type_tbl inv_ebi_revitem_output_obj_tbl;
409: l_ouid NUMBER;
410: l_operating_unit VARCHAR2(240);
411: BEGIN

Line 412: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

408: l_revised_item_type_tbl inv_ebi_revitem_output_obj_tbl;
409: l_ouid NUMBER;
410: l_operating_unit VARCHAR2(240);
411: BEGIN
412: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
413: l_revised_item_type_tbl := inv_ebi_revitem_output_obj_tbl();
414: l_pk_col_name_val_pairs.EXTEND(1);
415: l_pk_col_name_val_pairs(1).name := 'organization_code';
416: l_pk_col_name_val_pairs(1).value := p_change_order.organization_code;

Line 418: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(

414: l_pk_col_name_val_pairs.EXTEND(1);
415: l_pk_col_name_val_pairs(1).name := 'organization_code';
416: l_pk_col_name_val_pairs(1).value := p_change_order.organization_code;
417:
418: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(
419: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
420: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
421: );
422: l_pk_col_name_val_pairs.TRIM(1);

Line 420: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION

416: l_pk_col_name_val_pairs(1).value := p_change_order.organization_code;
417:
418: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(
419: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
420: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
421: );
422: l_pk_col_name_val_pairs.TRIM(1);
423:
424: INV_EBI_ITEM_HELPER.get_Operating_unit

Line 424: INV_EBI_ITEM_HELPER.get_Operating_unit

420: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
421: );
422: l_pk_col_name_val_pairs.TRIM(1);
423:
424: INV_EBI_ITEM_HELPER.get_Operating_unit
425: (p_oranization_id => l_organization_id
426: ,x_operating_unit => l_operating_unit
427: ,x_ouid => l_ouid
428: );

Line 438: l_revised_item_type_tbl(i).revised_item.INVENTORY_ITEM_ID := INV_EBI_ITEM_HELPER.get_inventory_item_id

434: l_revised_item_type_tbl(i).revised_item := INV_EBI_ITEM_OUTPUT_OBJ(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
435: l_revised_item_type_tbl(i).revised_item.ORGANIZATION_CODE := p_change_order.organization_code ;
436: l_revised_item_type_tbl(i).revised_item.ORGANIZATION_ID := l_organization_id;
437: l_revised_item_type_tbl(i).revised_item.ITEM_NUMBER := p_revised_item_type_tbl(i).revised_item_name;
438: l_revised_item_type_tbl(i).revised_item.INVENTORY_ITEM_ID := INV_EBI_ITEM_HELPER.get_inventory_item_id
439: ( p_organization_id => l_organization_id
440: ,p_item_number => p_revised_item_type_tbl(i).revised_item_name);
441: l_revised_item_type_tbl(i).revised_item.operating_unit := l_operating_unit;
442: l_revised_item_type_tbl(i).revised_item.operating_unit_id := l_ouid;

Line 453: l_revised_item_type_tbl(i).rev_component(j).component.INVENTORY_ITEM_ID := INV_EBI_ITEM_HELPER.get_inventory_item_id

449: l_revised_item_type_tbl(i).rev_component(j).component := INV_EBI_ITEM_OUTPUT_OBJ(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
450: l_revised_item_type_tbl(i).rev_component(j).component.ORGANIZATION_CODE := p_change_order.organization_code ;
451: l_revised_item_type_tbl(i).rev_component(j).component.ORGANIZATION_ID := l_organization_id;
452: l_revised_item_type_tbl(i).rev_component(j).component.ITEM_NUMBER := p_revised_item_type_tbl(i).component_item_tbl(j).component_item_name;
453: l_revised_item_type_tbl(i).rev_component(j).component.INVENTORY_ITEM_ID := INV_EBI_ITEM_HELPER.get_inventory_item_id
454: ( p_organization_id => l_organization_id
455: ,p_item_number => p_revised_item_type_tbl(i).component_item_tbl(j).component_item_name);
456: l_revised_item_type_tbl(i).rev_component(j).component.operating_unit := l_operating_unit;
457: l_revised_item_type_tbl(i).rev_component(j).component.operating_unit_id := l_ouid;

Line 468: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k).INVENTORY_ITEM_ID :=INV_EBI_ITEM_HELPER.get_inventory_item_id

464: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k) :=INV_EBI_ITEM_OUTPUT_OBJ(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
465: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k).ORGANIZATION_CODE := p_change_order.organization_code ;
466: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k).ORGANIZATION_ID := l_organization_id;
467: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k).ITEM_NUMBER := p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).substitute_component_name;
468: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k).INVENTORY_ITEM_ID :=INV_EBI_ITEM_HELPER.get_inventory_item_id
469: ( p_organization_id => l_organization_id
470: ,p_item_number => p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).substitute_component_name);
471: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k).operating_unit := l_operating_unit;
472: l_revised_item_type_tbl(i).rev_component(j).subcomponent(k).operating_unit_id := l_ouid;

Line 572: INV_EBI_ITEM_HELPER.populate_item_ids(

568: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
569: x_out.output_status.msg_data := l_out.output_status.msg_data;
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572: INV_EBI_ITEM_HELPER.populate_item_ids(
573: p_item => l_item
574: ,x_out => l_item_output
575: ,x_item => l_eco_obj_validate_eco.eco_revised_item_type(i).item
576: );

Line 611: IF( INV_EBI_ITEM_HELPER.is_item_exists (

607: END LOOP;
608: END IF;
609:
610: l_revision_set := FALSE;
611: IF( INV_EBI_ITEM_HELPER.is_item_exists (
612: p_organization_id => l_eco_obj_validate_eco.eco_revised_item_type(i).item.main_obj_type.organization_id
613: ,p_item_number => l_eco_obj_validate_eco.eco_revised_item_type(i).item.main_obj_type.item_number
614: ) = FND_API.g_false ) THEN
615:

Line 628: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

624: l_master_org := INV_EBI_UTIL.get_master_organization(
625: p_organization_id => l_eco_obj_validate_eco.eco_revised_item_type(i).item.main_obj_type.organization_id
626: );
627:
628: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
629: p_organization_id => l_master_org
630: ,p_item_number => l_eco_obj_validate_eco.eco_revised_item_type(i).item.main_obj_type.item_number
631: );
632:

Line 654: INV_EBI_UTIL.debug_line('STEP: 40 START CALLING INV_EBI_ITEM_HELPER.sync_item');

650: END IF;
651: END IF;
652:
653: --call Create New Production Item API .This will also process existing item information.
654: INV_EBI_UTIL.debug_line('STEP: 40 START CALLING INV_EBI_ITEM_HELPER.sync_item');
655: INV_EBI_ITEM_HELPER.sync_item(
656: p_commit => FND_API.g_false
657: ,p_operation => INV_EBI_ITEM_PUB.g_otype_create
658: ,p_item => l_eco_obj_validate_eco.eco_revised_item_type(i).item

Line 655: INV_EBI_ITEM_HELPER.sync_item(

651: END IF;
652:
653: --call Create New Production Item API .This will also process existing item information.
654: INV_EBI_UTIL.debug_line('STEP: 40 START CALLING INV_EBI_ITEM_HELPER.sync_item');
655: INV_EBI_ITEM_HELPER.sync_item(
656: p_commit => FND_API.g_false
657: ,p_operation => INV_EBI_ITEM_PUB.g_otype_create
658: ,p_item => l_eco_obj_validate_eco.eco_revised_item_type(i).item
659: ,x_out => l_item_output

Line 661: INV_EBI_UTIL.debug_line('STEP: 50 END CALLING INV_EBI_ITEM_HELPER.sync_item');

657: ,p_operation => INV_EBI_ITEM_PUB.g_otype_create
658: ,p_item => l_eco_obj_validate_eco.eco_revised_item_type(i).item
659: ,x_out => l_item_output
660: );
661: INV_EBI_UTIL.debug_line('STEP: 50 END CALLING INV_EBI_ITEM_HELPER.sync_item');
662: l_item_count := l_item_count + 1;
663: l_item_output_tbl.EXTEND(1);
664: l_item_output_tbl(l_item_count) := l_item_output;
665:

Line 902: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

898: l_eco_obj.eco_revised_item_type(i).item.uda_type.attribute_group_tbl.COUNT > 0) THEN
899:
900: -- To process Revised Item udas
901:
902: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
903: p_organization_id => l_organization_id
904: ,p_item_number => l_eco_obj.eco_revised_item_type(i).revised_item_name
905: );
906:

Line 907: INV_EBI_ITEM_HELPER.process_item_uda(

903: p_organization_id => l_organization_id
904: ,p_item_number => l_eco_obj.eco_revised_item_type(i).revised_item_name
905: );
906:
907: INV_EBI_ITEM_HELPER.process_item_uda(
908: p_api_version => l_api_version
909: ,p_inventory_item_id => l_inventory_item_id
910: ,p_organization_id => l_organization_id
911: ,p_item_catalog_group_id => l_eco_obj.eco_revised_item_type(i).item.main_obj_type.item_catalog_group_id

Line 950: INV_EBI_UTIL.debug_line('STEP: 180 START CALLING INV_EBI_ITEM_HELPER.sync_item');

946:
947: --Revised Item updation should be done after eco creation Bug 7025686
948: FOR j in 1..l_item_obj_tbl.COUNT LOOP
949: l_update_item_index := l_update_item_tab(j);
950: INV_EBI_UTIL.debug_line('STEP: 180 START CALLING INV_EBI_ITEM_HELPER.sync_item');
951: INV_EBI_ITEM_HELPER.sync_item(
952: p_commit => FND_API.g_false
953: ,p_operation => INV_EBI_ITEM_PUB.g_otype_update
954: ,p_item => l_item_obj_tbl(j).item_obj

Line 951: INV_EBI_ITEM_HELPER.sync_item(

947: --Revised Item updation should be done after eco creation Bug 7025686
948: FOR j in 1..l_item_obj_tbl.COUNT LOOP
949: l_update_item_index := l_update_item_tab(j);
950: INV_EBI_UTIL.debug_line('STEP: 180 START CALLING INV_EBI_ITEM_HELPER.sync_item');
951: INV_EBI_ITEM_HELPER.sync_item(
952: p_commit => FND_API.g_false
953: ,p_operation => INV_EBI_ITEM_PUB.g_otype_update
954: ,p_item => l_item_obj_tbl(j).item_obj
955: ,x_out => l_item_output

Line 957: INV_EBI_UTIL.debug_line('STEP: 190 END CALLING INV_EBI_ITEM_HELPER.sync_item');

953: ,p_operation => INV_EBI_ITEM_PUB.g_otype_update
954: ,p_item => l_item_obj_tbl(j).item_obj
955: ,x_out => l_item_output
956: );
957: INV_EBI_UTIL.debug_line('STEP: 190 END CALLING INV_EBI_ITEM_HELPER.sync_item');
958: l_item_output_tbl(l_update_item_index) := l_item_output;
959:
960: IF (l_item_output.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
961: x_out.output_status.msg_data := l_item_output.output_status.msg_data;

Line 1145: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_date);

1141: ------------------------------------------------------------------------------
1142: -- To Convert Date Fields in eco_change_order_type (INV_EBI_CHANGE_ORDER_OBJ)
1143: ------------------------------------------------------------------------------
1144: x_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_date_str :=
1145: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_date);
1146:
1147: x_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_request_date_str :=
1148: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_request_date);
1149:

Line 1148: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_request_date);

1144: x_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_date_str :=
1145: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_date);
1146:
1147: x_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_request_date_str :=
1148: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_request_date);
1149:
1150: x_eco_lst_obj(i).eco_attr.eco_change_order_type.need_by_date_str :=
1151: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.need_by_date);
1152:

Line 1151: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.need_by_date);

1147: x_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_request_date_str :=
1148: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.approval_request_date);
1149:
1150: x_eco_lst_obj(i).eco_attr.eco_change_order_type.need_by_date_str :=
1151: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.need_by_date);
1152:
1153: x_eco_lst_obj(i).eco_attr.eco_change_order_type.implementation_date_str :=
1154: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.implementation_date);
1155:

Line 1154: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.implementation_date);

1150: x_eco_lst_obj(i).eco_attr.eco_change_order_type.need_by_date_str :=
1151: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.need_by_date);
1152:
1153: x_eco_lst_obj(i).eco_attr.eco_change_order_type.implementation_date_str :=
1154: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.implementation_date);
1155:
1156: x_eco_lst_obj(i).eco_attr.eco_change_order_type.cancellation_date_str :=
1157: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.cancellation_date);
1158: ------------------------------------------------------------------------------

Line 1157: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.cancellation_date);

1153: x_eco_lst_obj(i).eco_attr.eco_change_order_type.implementation_date_str :=
1154: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.implementation_date);
1155:
1156: x_eco_lst_obj(i).eco_attr.eco_change_order_type.cancellation_date_str :=
1157: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.cancellation_date);
1158: ------------------------------------------------------------------------------
1159: -- To Convert Date Fields in eco_change_order_type (INV_EBI_UDA_ATTR_OBJ)
1160: ------------------------------------------------------------------------------
1161:

Line 1171: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.change_order_uda.attribute_group_tbl(j).attributes_tbl(k).attr_value_date);

1167: AND p_eco_lst_obj(i).eco_attr.eco_change_order_type.change_order_uda.attribute_group_tbl(j).attributes_tbl.COUNT>0) THEN
1168: FOR k IN p_eco_lst_obj(i).eco_attr.eco_change_order_type.change_order_uda.attribute_group_tbl(j).attributes_tbl.FIRST..
1169: p_eco_lst_obj(i).eco_attr.eco_change_order_type.change_order_uda.attribute_group_tbl(j).attributes_tbl.LAST LOOP
1170: x_eco_lst_obj(i).eco_attr.eco_change_order_type.change_order_uda.attribute_group_tbl(j).attributes_tbl(k).attr_value_date_str :=
1171: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_change_order_type.change_order_uda.attribute_group_tbl(j).attributes_tbl(k).attr_value_date);
1172: END LOOP;
1173: END IF;
1174: END LOOP;
1175: END IF;

Line 1183: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).start_effective_date);

1179: ----------------------------------------------------------------------------
1180: IF(p_eco_lst_obj(i).eco_attr.eco_revised_item_type IS NOT NULL AND p_eco_lst_obj(i).eco_attr.eco_revised_item_type.COUNT>0) THEN
1181: FOR j IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type.FIRST..p_eco_lst_obj(i).eco_attr.eco_revised_item_type.LAST LOOP
1182: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).start_effective_date_str :=
1183: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).start_effective_date);
1184:
1185: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).new_effective_date_str :=
1186: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).new_effective_date);
1187:

Line 1186: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).new_effective_date);

1182: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).start_effective_date_str :=
1183: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).start_effective_date);
1184:
1185: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).new_effective_date_str :=
1186: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).new_effective_date);
1187:
1188: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).earliest_effective_date_str :=
1189: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).earliest_effective_date);
1190:

Line 1189: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).earliest_effective_date);

1185: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).new_effective_date_str :=
1186: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).new_effective_date);
1187:
1188: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).earliest_effective_date_str :=
1189: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).earliest_effective_date);
1190:
1191: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).selection_date_str :=
1192: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).selection_date);
1193:

Line 1192: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).selection_date);

1188: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).earliest_effective_date_str :=
1189: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).earliest_effective_date);
1190:
1191: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).selection_date_str :=
1192: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).selection_date);
1193:
1194:
1195: -------------------------------------------------------
1196: -- Converting Dates For ORIGNAL_BOM_REFERENCE

Line 1201: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).orignal_bom_reference.as_of_date);

1197: -------------------------------------------------------
1198:
1199: IF(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).orignal_bom_reference IS NOT NULL) THEN
1200: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).orignal_bom_reference.as_of_date_str :=
1201: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).orignal_bom_reference.as_of_date);
1202: END IF;
1203:
1204:
1205: -------------------------------------------------------

Line 1218: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item_revision_uda.attribute_group_tbl(k).attributes_tbl(l).attr_value_date);

1214: IF(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item_revision_uda.attribute_group_tbl(k).attributes_tbl IS NOT NULL) THEN
1215: FOR l IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item_revision_uda.attribute_group_tbl(k).attributes_tbl.FIRST..
1216: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item_revision_uda.attribute_group_tbl(k).attributes_tbl.LAST LOOP
1217: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item_revision_uda.attribute_group_tbl(k).attributes_tbl(l).attr_value_date_str :=
1218: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item_revision_uda.attribute_group_tbl(k).attributes_tbl(l).attr_value_date);
1219: END LOOP;
1220: END IF;
1221: END LOOP;
1222: END IF;

Line 1233: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.start_date_active);

1229:
1230: IF(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type IS NOT NULL) THEN
1231:
1232: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.start_date_active_str :=
1233: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.start_date_active);
1234:
1235: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.end_date_active_str :=
1236: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.end_date_active);
1237:

Line 1236: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.end_date_active);

1232: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.start_date_active_str :=
1233: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.start_date_active);
1234:
1235: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.end_date_active_str :=
1236: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.end_date_active);
1237:
1238: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.creation_date_str :=
1239: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.creation_date);
1240:

Line 1239: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.creation_date);

1235: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.end_date_active_str :=
1236: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.end_date_active);
1237:
1238: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.creation_date_str :=
1239: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.creation_date);
1240:
1241: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date_str :=
1242: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date);
1243:

Line 1242: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date);

1238: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.creation_date_str :=
1239: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.creation_date);
1240:
1241: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date_str :=
1242: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date);
1243:
1244: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date_str :=
1245: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date);
1246:

Line 1245: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date);

1241: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date_str :=
1242: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.last_update_date);
1243:
1244: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date_str :=
1245: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date);
1246:
1247: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.effectivity_date_str :=
1248: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.effectivity_date);
1249:

Line 1248: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.effectivity_date);

1244: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date_str :=
1245: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.program_update_date);
1246:
1247: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.effectivity_date_str :=
1248: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.main_obj_type.effectivity_date);
1249:
1250: END IF;
1251:
1252: ------------------------------------------------------

Line 1259: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.engineering_date);

1255:
1256: IF(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type IS NOT NULL) THEN
1257:
1258: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.engineering_date_str :=
1259: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.engineering_date);
1260:
1261: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.wh_update_date_str :=
1262: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.wh_update_date_str);
1263:

Line 1262: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.wh_update_date_str);

1258: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.engineering_date_str :=
1259: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.engineering_date);
1260:
1261: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.wh_update_date_str :=
1262: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.deprecated_obj_type.wh_update_date_str);
1263:
1264: END IF;
1265:
1266: --------------------------------------------------------

Line 1279: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.uda_type.attribute_group_tbl(k).attributes_tbl(l).attr_value_date);

1275: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.uda_type.attribute_group_tbl(k).attributes_tbl.COUNT>0) THEN
1276: FOR l IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.uda_type.attribute_group_tbl(k).attributes_tbl.FIRST..
1277: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.uda_type.attribute_group_tbl(k).attributes_tbl.LAST LOOP
1278: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.uda_type.attribute_group_tbl(k).attributes_tbl(l).attr_value_date_str :=
1279: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).item.uda_type.attribute_group_tbl(k).attributes_tbl(l).attr_value_date);
1280: END LOOP;
1281: END IF;
1282: END LOOP;
1283: END IF;

Line 1299: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).structure_header.structure_header_uda.attribute_group_tbl(k).attributes_tbl(l).attr_value_date);

1295: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).structure_header.structure_header_uda.attribute_group_tbl(k).attributes_tbl.COUNT>0) THEN
1296: FOR l IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).structure_header.structure_header_uda.attribute_group_tbl(k).attributes_tbl.FIRST..
1297: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).structure_header.structure_header_uda.attribute_group_tbl(k).attributes_tbl.LAST LOOP
1298: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).structure_header.structure_header_uda.attribute_group_tbl(k).attributes_tbl(l).attr_value_date_str :=
1299: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).structure_header.structure_header_uda.attribute_group_tbl(k).attributes_tbl(l).attr_value_date);
1300: END LOOP;
1301: END IF;
1302: END LOOP;
1303: END IF;

Line 1315: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).start_effective_date);

1311: FOR k IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl.FIRST..
1312: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl.LAST LOOP
1313:
1314: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).start_effective_date_str :=
1315: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).start_effective_date);
1316:
1317: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).new_effectivity_date_str :=
1318: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).new_effectivity_date);
1319:

Line 1318: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).new_effectivity_date);

1314: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).start_effective_date_str :=
1315: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).start_effective_date);
1316:
1317: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).new_effectivity_date_str :=
1318: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).new_effectivity_date);
1319:
1320: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).disable_date_str :=
1321: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).disable_date);
1322:

Line 1321: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).disable_date);

1317: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).new_effectivity_date_str :=
1318: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).new_effectivity_date);
1319:
1320: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).disable_date_str :=
1321: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).disable_date);
1322:
1323: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).old_effectivity_date_str :=
1324: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).old_effectivity_date);
1325:

Line 1324: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).old_effectivity_date);

1320: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).disable_date_str :=
1321: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).disable_date);
1322:
1323: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).old_effectivity_date_str :=
1324: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).old_effectivity_date);
1325:
1326: --------------------------------------------------------------------------
1327: -- Converting Dates For substitute_component_tbl( INV_EBI_SUB_COMP_TBL )
1328: --------------------------------------------------------------------------

Line 1335: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).substitute_component_tbl(l).start_effective_date);

1331: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).substitute_component_tbl.COUNT>0) THEN
1332: FOR l IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).substitute_component_tbl.FIRST..
1333: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).substitute_component_tbl.LAST LOOP
1334: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).substitute_component_tbl(l).start_effective_date_str :=
1335: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).substitute_component_tbl(l).start_effective_date);
1336: END LOOP;
1337: END IF;
1338:
1339: ----------------------------------------------------------------------------

Line 1348: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).reference_designator_tbl(l).start_effective_date);

1344: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).reference_designator_tbl.COUNT>0) THEN
1345: FOR l IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).reference_designator_tbl.FIRST..
1346: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).reference_designator_tbl.LAST LOOP
1347: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).reference_designator_tbl(l).start_effective_date_str :=
1348: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).reference_designator_tbl(l).start_effective_date);
1349: END LOOP;
1350: END IF;
1351:
1352: ----------------------------------------------------------------------------

Line 1365: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).component_revision_uda.attribute_group_tbl(l).attributes_tbl(m).attr_value_date);

1361: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).component_revision_uda.attribute_group_tbl(l).attributes_tbl.COUNT>0) THEN
1362: FOR m IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).component_revision_uda.attribute_group_tbl(l).attributes_tbl.FIRST..
1363: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).component_revision_uda.attribute_group_tbl(l).attributes_tbl.LAST LOOP
1364: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).component_revision_uda.attribute_group_tbl(l).attributes_tbl(m).attr_value_date_str :=
1365: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).component_item_tbl(k).component_revision_uda.attribute_group_tbl(l).attributes_tbl(m).attr_value_date);
1366: END LOOP;
1367: END IF;
1368: END LOOP;
1369: END IF;

Line 1381: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).start_effective_date);

1377: FOR k IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl.FIRST..
1378: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl.LAST LOOP
1379:
1380: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).start_effective_date_str :=
1381: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).start_effective_date);
1382:
1383: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).old_start_effective_number_str :=
1384: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).old_start_effective_number);
1385:

Line 1384: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).old_start_effective_number);

1380: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).start_effective_date_str :=
1381: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).start_effective_date);
1382:
1383: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).old_start_effective_number_str :=
1384: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).old_start_effective_number);
1385:
1386: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).disable_number_str :=
1387: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).disable_number);
1388: END LOOP;

Line 1387: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).disable_number);

1383: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).old_start_effective_number_str :=
1384: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).old_start_effective_number);
1385:
1386: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).disable_number_str :=
1387: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_operation_tbl(k).disable_number);
1388: END LOOP;
1389: END IF;
1390:
1391: ----------------------------------------------------------------------------------

Line 1400: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_op_resource_tbl(k).op_start_effective_date);

1396: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_op_resource_tbl.COUNT>0) THEN
1397: FOR k IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_op_resource_tbl.FIRST..
1398: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_op_resource_tbl.LAST LOOP
1399: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_op_resource_tbl(k).op_start_effective_date_str :=
1400: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_op_resource_tbl(k).op_start_effective_date);
1401: END LOOP;
1402: END IF;
1403:
1404: ----------------------------------------------------------------------------------------------------------------

Line 1413: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_sub_resource_tbl(k).op_start_effective_date);

1409: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_sub_resource_tbl.COUNT>0) THEN
1410: FOR k IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_sub_resource_tbl.FIRST..
1411: p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_sub_resource_tbl.LAST LOOP
1412: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_sub_resource_tbl(k).op_start_effective_date_str :=
1413: INV_EBI_ITEM_HELPER.convert_date_str(p_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).revision_sub_resource_tbl(k).op_start_effective_date);
1414: END LOOP;
1415: END IF;
1416: END LOOP;
1417: END IF;

Line 1483: INV_EBI_ITEM_HELPER.set_server_time_zone;

1479: x_return_status := FND_API.G_RET_STS_SUCCESS;
1480: l_mult_org_chg_id_tbl := inv_ebi_change_id_obj_tbl();
1481: l_mult_org_chg_id_temp := inv_ebi_change_id_obj_tbl();
1482:
1483: INV_EBI_ITEM_HELPER.set_server_time_zone;
1484:
1485: IF p_change_lst IS NOT NULL AND p_change_lst.COUNT > 0 THEN
1486: FOR i in 1..p_change_lst.COUNT LOOP
1487: OPEN c_get_multi_org_chg_id(p_change_lst(i).change_id);