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.EGO_GTIN_ATTRS_PVT dependencies on EGO_ITEM_PUB

Line 8: G_MISS_NUM NUMBER := EGO_ITEM_PUB.G_INTF_NULL_NUM;

4: TYPE l_attr_disp_name_tbl_type IS TABLE OF VARCHAR2(1000) INDEX BY VARCHAR2(1000);
5: l_single_row_attrs_disp_names l_attr_disp_name_tbl_type;
6: l_multi_row_attrs_disp_names l_attr_disp_name_tbl_type;
7: l_op_attrs_disp_names l_attr_disp_name_tbl_type;
8: G_MISS_NUM NUMBER := EGO_ITEM_PUB.G_INTF_NULL_NUM;
9: G_MISS_CHAR VARCHAR2(1) := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
10: G_MISS_DATE DATE := EGO_ITEM_PUB.G_INTF_NULL_DATE;
11: g_row_identifier NUMBER;
12: EGO_APPL_ID CONSTANT NUMBER := 431;

Line 9: G_MISS_CHAR VARCHAR2(1) := EGO_ITEM_PUB.G_INTF_NULL_CHAR;

5: l_single_row_attrs_disp_names l_attr_disp_name_tbl_type;
6: l_multi_row_attrs_disp_names l_attr_disp_name_tbl_type;
7: l_op_attrs_disp_names l_attr_disp_name_tbl_type;
8: G_MISS_NUM NUMBER := EGO_ITEM_PUB.G_INTF_NULL_NUM;
9: G_MISS_CHAR VARCHAR2(1) := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
10: G_MISS_DATE DATE := EGO_ITEM_PUB.G_INTF_NULL_DATE;
11: g_row_identifier NUMBER;
12: EGO_APPL_ID CONSTANT NUMBER := 431;
13: G_CALLED_FROM_INTF VARCHAR2(1);

Line 10: G_MISS_DATE DATE := EGO_ITEM_PUB.G_INTF_NULL_DATE;

6: l_multi_row_attrs_disp_names l_attr_disp_name_tbl_type;
7: l_op_attrs_disp_names l_attr_disp_name_tbl_type;
8: G_MISS_NUM NUMBER := EGO_ITEM_PUB.G_INTF_NULL_NUM;
9: G_MISS_CHAR VARCHAR2(1) := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
10: G_MISS_DATE DATE := EGO_ITEM_PUB.G_INTF_NULL_DATE;
11: g_row_identifier NUMBER;
12: EGO_APPL_ID CONSTANT NUMBER := 431;
13: G_CALLED_FROM_INTF VARCHAR2(1);
14: G_DATA_SET_ID NUMBER;

Line 124: ,x_singe_row_attrs_rec OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP

120: ,p_target_proc_status IN NUMBER
121: ,p_inventory_item_id IN NUMBER
122: ,p_organization_id IN NUMBER
123: ,p_ignore_delete IN VARCHAR2 DEFAULT 'N'
124: ,x_singe_row_attrs_rec OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP
125: ,x_multi_row_attrs_tbl OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP
126: ,x_return_status OUT NOCOPY VARCHAR2
127: ,x_msg_count OUT NOCOPY NUMBER
128: ,x_msg_data OUT NOCOPY VARCHAR2

Line 125: ,x_multi_row_attrs_tbl OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP

121: ,p_inventory_item_id IN NUMBER
122: ,p_organization_id IN NUMBER
123: ,p_ignore_delete IN VARCHAR2 DEFAULT 'N'
124: ,x_singe_row_attrs_rec OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP
125: ,x_multi_row_attrs_tbl OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP
126: ,x_return_status OUT NOCOPY VARCHAR2
127: ,x_msg_count OUT NOCOPY NUMBER
128: ,x_msg_data OUT NOCOPY VARCHAR2
129: )

Line 285: l_single_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ;

281: );
282:
283: TYPE l_uom_codes_type IS TABLE OF VARCHAR2(1000) INDEX BY VARCHAR2(1000);
284: l_uom_tbl l_uom_codes_type;
285: l_single_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ;
286: l_multi_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ;
287: k BINARY_INTEGER;
288: l_conversion_error EXCEPTION;
289: PRAGMA EXCEPTION_INIT(l_conversion_error, -6502);

Line 286: l_multi_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ;

282:
283: TYPE l_uom_codes_type IS TABLE OF VARCHAR2(1000) INDEX BY VARCHAR2(1000);
284: l_uom_tbl l_uom_codes_type;
285: l_single_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ;
286: l_multi_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ;
287: k BINARY_INTEGER;
288: l_conversion_error EXCEPTION;
289: PRAGMA EXCEPTION_INIT(l_conversion_error, -6502);
290: l_attr_name VARCHAR2(1000);

Line 292: -- these are all NUMBER columns in EGO_ITEM_GTN_ATTRS_VL. The record EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ

288: l_conversion_error EXCEPTION;
289: PRAGMA EXCEPTION_INIT(l_conversion_error, -6502);
290: l_attr_name VARCHAR2(1000);
291:
292: -- these are all NUMBER columns in EGO_ITEM_GTN_ATTRS_VL. The record EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ
293: -- contains the type of these columns as NUMBER
294: -- so these variables are used to find out any precesion problem in these attributes
295: l_gross_weight EGO_ITEM_GTN_ATTRS_VL.GROSS_WEIGHT%TYPE;
296: l_stacking_factor EGO_ITEM_GTN_ATTRS_VL.STACKING_FACTOR%TYPE;

Line 329: -- these are all NUMBER columns in EGO_ITM_GTN_MUL_ATTRS_VL. The record EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ

325: l_nesting_increment EGO_ITEM_GTN_ATTRS_VL.NESTING_INCREMENT%TYPE;
326: l_pieces_per_trade_item EGO_ITEM_GTN_ATTRS_VL.PIECES_PER_TRADE_ITEM%TYPE;
327:
328:
329: -- these are all NUMBER columns in EGO_ITM_GTN_MUL_ATTRS_VL. The record EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ
330: -- contains the type of these columns as NUMBER
331: -- so these variables are used to find out any precesion problem in these attributes
332: l_manufacturer_id EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_ID%TYPE;
333: l_united_nations_dang_goods_no EGO_ITM_GTN_MUL_ATTRS_VL.UNITED_NATIONS_DANG_GOODS_NO%TYPE;

Line 1630: l_single_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ;

1626: l_return_status VARCHAR2(10);
1627: l_msg_count NUMBER;
1628: l_msg_data VARCHAR2(4000);
1629: l_msg_text VARCHAR2(4000);
1630: l_single_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ;
1631: l_multi_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ;
1632: BEGIN
1633: Debug_Msg('Starting Validate_Intf_Rows');
1634: FOR i IN c_intf_rows LOOP

Line 1631: l_multi_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ;

1627: l_msg_count NUMBER;
1628: l_msg_data VARCHAR2(4000);
1629: l_msg_text VARCHAR2(4000);
1630: l_single_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ;
1631: l_multi_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ;
1632: BEGIN
1633: Debug_Msg('Starting Validate_Intf_Rows');
1634: FOR i IN c_intf_rows LOOP
1635: Debug_Msg('Calling Get_Gdsn_Intf_Rows for Item, Org='||i.INVENTORY_ITEM_ID||','||i.ORGANIZATION_ID);

Line 1777: ,p_singe_row_attrs_rec IN EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP

1773: */
1774: PROCEDURE Validate_Attributes (
1775: p_inventory_item_id IN NUMBER
1776: ,p_organization_id IN NUMBER
1777: ,p_singe_row_attrs_rec IN EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP
1778: ,p_multi_row_attrs_tbl IN EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP
1779: ,p_extra_attrs_rec IN EGO_ITEM_PUB.UCCnet_Extra_Attrs_Rec_Typ
1780: ,x_return_status OUT NOCOPY VARCHAR2
1781: ,x_msg_count OUT NOCOPY NUMBER

Line 1778: ,p_multi_row_attrs_tbl IN EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP

1774: PROCEDURE Validate_Attributes (
1775: p_inventory_item_id IN NUMBER
1776: ,p_organization_id IN NUMBER
1777: ,p_singe_row_attrs_rec IN EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP
1778: ,p_multi_row_attrs_tbl IN EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP
1779: ,p_extra_attrs_rec IN EGO_ITEM_PUB.UCCnet_Extra_Attrs_Rec_Typ
1780: ,x_return_status OUT NOCOPY VARCHAR2
1781: ,x_msg_count OUT NOCOPY NUMBER
1782: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1779: ,p_extra_attrs_rec IN EGO_ITEM_PUB.UCCnet_Extra_Attrs_Rec_Typ

1775: p_inventory_item_id IN NUMBER
1776: ,p_organization_id IN NUMBER
1777: ,p_singe_row_attrs_rec IN EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP
1778: ,p_multi_row_attrs_tbl IN EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP
1779: ,p_extra_attrs_rec IN EGO_ITEM_PUB.UCCnet_Extra_Attrs_Rec_Typ
1780: ,x_return_status OUT NOCOPY VARCHAR2
1781: ,x_msg_count OUT NOCOPY NUMBER
1782: ,x_msg_data OUT NOCOPY VARCHAR2
1783: )

Line 3830: ,p_single_row_attrs_rec IN EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ

3826: PROCEDURE Process_UCCnet_Attrs_For_Item (
3827: p_api_version IN NUMBER
3828: ,p_inventory_item_id IN NUMBER
3829: ,p_organization_id IN NUMBER
3830: ,p_single_row_attrs_rec IN EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ
3831: ,p_multi_row_attrs_table IN EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ
3832: ,p_check_policy IN VARCHAR2 DEFAULT FND_API.G_TRUE
3833: ,p_entity_id IN NUMBER DEFAULT NULL
3834: ,p_entity_index IN NUMBER DEFAULT NULL

Line 3831: ,p_multi_row_attrs_table IN EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ

3827: p_api_version IN NUMBER
3828: ,p_inventory_item_id IN NUMBER
3829: ,p_organization_id IN NUMBER
3830: ,p_single_row_attrs_rec IN EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ
3831: ,p_multi_row_attrs_table IN EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ
3832: ,p_check_policy IN VARCHAR2 DEFAULT FND_API.G_TRUE
3833: ,p_entity_id IN NUMBER DEFAULT NULL
3834: ,p_entity_index IN NUMBER DEFAULT NULL
3835: ,p_entity_code IN VARCHAR2 DEFAULT NULL

Line 3877: l_single_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ;

3873: FROM EGO_ATTRS_V
3874: WHERE ATTR_GROUP_TYPE IN ('EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS')
3875: AND APPLICATION_ID = EGO_APPL_ID;
3876:
3877: l_single_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ;
3878: l_multi_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ;
3879: l_return_status VARCHAR2(10);
3880: l_msg_count NUMBER;
3881: l_msg_data VARCHAR2(4000);

Line 3878: l_multi_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ;

3874: WHERE ATTR_GROUP_TYPE IN ('EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS')
3875: AND APPLICATION_ID = EGO_APPL_ID;
3876:
3877: l_single_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Singl_Row_Rec_Typ;
3878: l_multi_row_attrs EGO_ITEM_PUB.UCCnet_Attrs_Multi_Row_Tbl_Typ;
3879: l_return_status VARCHAR2(10);
3880: l_msg_count NUMBER;
3881: l_msg_data VARCHAR2(4000);
3882: l_failed_row_id_list VARCHAR2(4000);

Line 5887: Debug_Msg('Calling EGO_ITEM_PUB.Process_User_Attrs_For_Item');

5883: l_attribute_names.EXTEND;
5884: l_attribute_names(l_attribute_names.COUNT) := l_single_row_attrs_metadata('STACKING_FACTOR').ATTR_NAME;
5885: END IF;
5886:
5887: Debug_Msg('Calling EGO_ITEM_PUB.Process_User_Attrs_For_Item');
5888: EGO_ITEM_PVT.Process_User_Attrs_For_Item(
5889: p_api_version => 1.0
5890: ,p_inventory_item_id => p_inventory_item_id
5891: ,p_organization_id => p_organization_id