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_TRANSACTION_ATTRS_PVT dependencies on EGO_TRAN_ATTR_TBL

Line 31: p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,

27:
28: /* Create transaction attribute API*/
29: PROCEDURE Create_Transaction_Attribute (
30: p_api_version IN NUMBER,
31: p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2)
35: IS

Line 832: PROCEDURE IS_METADATA_CHANGE (p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,

828: END;
829:
830:
831:
832: PROCEDURE IS_METADATA_CHANGE (p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,
833: p_ta_metadata_tbl OUT NOCOPY EGO_TRAN_ATTR_TBL,
834: x_return_status OUT NOCOPY VARCHAR2,
835: x_msg_count OUT NOCOPY NUMBER,
836: x_msg_data OUT NOCOPY VARCHAR2)

Line 833: p_ta_metadata_tbl OUT NOCOPY EGO_TRAN_ATTR_TBL,

829:
830:
831:
832: PROCEDURE IS_METADATA_CHANGE (p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,
833: p_ta_metadata_tbl OUT NOCOPY EGO_TRAN_ATTR_TBL,
834: x_return_status OUT NOCOPY VARCHAR2,
835: x_msg_count OUT NOCOPY NUMBER,
836: x_msg_data OUT NOCOPY VARCHAR2)
837: IS

Line 954: p_ta_metadata_tbl := EGO_TRAN_ATTR_TBL(NULL);

950:
951: BEGIN
952: --Reset all global variables
953: FND_MSG_PUB.Initialize;
954: p_ta_metadata_tbl := EGO_TRAN_ATTR_TBL(NULL);
955: FOR i IN p_tran_attrs_tbl.first..p_tran_attrs_tbl.last
956: LOOP
957: l_item_cat_group_id := p_tran_attrs_tbl(i).ItemCatalogGroupId;
958: l_attr_id := p_tran_attrs_tbl(i).attrid;

Line 1274: p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,

1270: /* Create inherited transaction attribute API*/
1271: PROCEDURE Create_Inherited_Trans_Attr
1272: (
1273: p_api_version IN NUMBER,
1274: p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,
1275: x_return_status OUT NOCOPY VARCHAR2,
1276: x_msg_count OUT NOCOPY NUMBER,
1277: x_msg_data OUT NOCOPY VARCHAR2)
1278: IS

Line 1330: l_ta_metadata_tbl EGO_TRAN_ATTR_TBL;

1326: l_revision_id NUMBER;
1327: l_item_obj_id NUMBER;
1328: l_versioned_value_set NUMBER:=0;
1329:
1330: l_ta_metadata_tbl EGO_TRAN_ATTR_TBL;
1331:
1332: BEGIN
1333: --Reset all global variables
1334: FND_MSG_PUB.Initialize;

Line 1335: l_ta_metadata_tbl := EGO_TRAN_ATTR_TBL(NULL);

1331:
1332: BEGIN
1333: --Reset all global variables
1334: FND_MSG_PUB.Initialize;
1335: l_ta_metadata_tbl := EGO_TRAN_ATTR_TBL(NULL);
1336: IS_METADATA_CHANGE(p_tran_attrs_tbl,l_ta_metadata_tbl,l_return_status,l_msg_count,l_msg_data );
1337:
1338: FOR i IN l_ta_metadata_tbl.first..l_ta_metadata_tbl.last
1339: LOOP

Line 1549: p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,

1545: --============ Update_Transaction_Attribute API===============
1546:
1547: PROCEDURE Update_Transaction_Attribute (
1548: p_api_version IN NUMBER,
1549: p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,
1550: x_return_status OUT NOCOPY VARCHAR2,
1551: x_msg_count OUT NOCOPY NUMBER,
1552: x_msg_data OUT NOCOPY VARCHAR2)
1553: IS

Line 1596: l_ta_metadata_tbl EGO_TRAN_ATTR_TBL;

1592: e_ta_int_name_exist EXCEPTION;
1593: e_ta_disp_name_exist EXCEPTION;
1594: e_ta_sequence_exist EXCEPTION;
1595: e_ta_default_value_null EXCEPTION;
1596: l_ta_metadata_tbl EGO_TRAN_ATTR_TBL;
1597:
1598: BEGIN
1599: --Reset all global variables
1600: FND_MSG_PUB.Initialize;

Line 1794: p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,

1790:
1791: --========Override method=======
1792: PROCEDURE Delete_Transaction_Attribute (
1793: p_api_version IN NUMBER,
1794: p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,
1795: x_return_status OUT NOCOPY VARCHAR2,
1796: x_msg_count OUT NOCOPY NUMBER,
1797: x_msg_data OUT NOCOPY VARCHAR2) IS
1798:

Line 1846: --p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,

1842: PROCEDURE Release_Transaction_Attribute (
1843: p_api_version IN NUMBER,
1844: p_icc_id IN NUMBER,
1845: p_version_number IN NUMBER,
1846: --p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,
1847: x_return_status OUT NOCOPY VARCHAR2
1848: ,x_msg_count OUT NOCOPY NUMBER
1849: ,x_msg_data OUT NOCOPY VARCHAR2)
1850: IS

Line 2478: PROCEDURE GET_TRANS_ATTR_METADATA( x_ta_metadata_tbl OUT NOCOPY EGO_TRAN_ATTR_TBL,

2474:
2475:
2476: /*API will return the record of transaction attribute metadata based on given input.It will return null
2477: if given input is invalid */
2478: PROCEDURE GET_TRANS_ATTR_METADATA( x_ta_metadata_tbl OUT NOCOPY EGO_TRAN_ATTR_TBL,
2479: p_item_catalog_category_id IN number,
2480: p_icc_version IN number,
2481: p_attribute_id IN NUMBER,
2482: p_inventory_item_id IN NUMBER ,

Line 2506: l_ta_metadata_tbl EGO_TRAN_ATTR_TBL;

2502: l_ATTRID NUMBER:=0;
2503: l_icc_version_number VARCHAR2(15);
2504: l_Value_Set_Id VARCHAR2(15);
2505: l_uom_class VARCHAR2(10);
2506: l_ta_metadata_tbl EGO_TRAN_ATTR_TBL;
2507: l_default_value VARCHAR2(2000);
2508: l_rejectedvalue VARCHAR2(2000);
2509: l_required VARCHAR2(1);
2510: l_readonlyflag VARCHAR2(1);

Line 2672: x_ta_metadata_tbl := EGO_TRAN_ATTR_TBL(NULL);

2668:
2669: get_ICC_TA_metadata_rec get_ICC_TA_metadata%ROWTYPE;
2670:
2671: BEGIN
2672: x_ta_metadata_tbl := EGO_TRAN_ATTR_TBL(NULL);
2673: x_is_inherited := 'N';
2674: x_is_modified := 'N';
2675: IF(p_attribute_id IS null) THEN
2676: RAISE l_exception ;