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_ICC_BULKLOAD_PVT dependencies on EGO_FUNC_PARAMS_MAP_INTERFACE

Line 306: FROM EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

302: ,G_CONC_REQUEST_ID
303: ,G_PROG_APPL_ID
304: ,G_PROGRAM_ID
305: ,l_sysdate
306: FROM EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
307: WHERE ( efpmi.transaction_type IS NULL OR
308: efpmi.transaction_type NOT IN ( G_TTYPE_CREATE , G_TTYPE_UPDATE ,
309: G_TTYPE_SYNC , G_TTYPE_DELETE)
310: )

Line 321: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

317: ;
318:
319:
320:
321: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
322: SET efpmi.process_status = G_PROCESS_STATUS_ERROR
323: WHERE ( efpmi.transaction_type IS NULL OR
324: efpmi.transaction_type NOT IN ( G_TTYPE_CREATE , G_TTYPE_UPDATE
325: ,G_TTYPE_SYNC, G_TTYPE_DELETE)

Line 669: FROM EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

665: ,G_CONC_REQUEST_ID
666: ,G_PROG_APPL_ID
667: ,G_PROGRAM_ID
668: ,l_sysdate
669: FROM EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
670: WHERE ( (efpmi.item_catalog_group_id IS NULL AND
671: efpmi.item_catalog_name IS NULL)
672: OR
673: (

Line 689: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

685: )
686: AND efpmi.process_status = G_PROCESS_STATUS_INITIAL
687: ;
688:
689: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
690: SET efpmi.process_status = G_PROCESS_STATUS_ERROR
691: WHERE ( (efpmi.item_catalog_group_id IS NULL AND
692: efpmi.item_catalog_name IS NULL)
693: OR

Line 1448: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1444: ----
1445:
1446:
1447: --- ICC Name
1448: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1449: SET efpmi.item_catalog_name = ( select icc_kfv.concatenated_segments
1450: from mtl_item_catalog_groups_kfv icc_kfv
1451: where icc_kfv.item_catalog_group_id = efpmi.item_catalog_group_id
1452: )

Line 1466: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1462:
1463: write_debug (l_proc_name, '19');
1464: -- ICC id
1465:
1466: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1467: SET efpmi.item_catalog_group_id = ( select icc_kfv.item_catalog_group_id
1468: from mtl_item_catalog_groups_kfv icc_kfv
1469: where icc_kfv.concatenated_segments = efpmi.item_catalog_name
1470: )

Line 1486: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1482:
1483:
1484: --- Get the Attr group name
1485: ---
1486: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1487: set efpmi.attr_group_name =( SELECT agv.attr_group_id
1488: FROM ego_attr_groups_v agv,
1489: ego_obj_attr_grp_assocs_v oagv,
1490: ego_catalog_groups_v cg

Line 1518: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1514:
1515: write_debug (l_proc_name, '21');
1516: -- Attr Group id
1517:
1518: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1519: set efpmi.attr_group_id = ( SELECT agv.attr_group_id
1520: FROM ego_attr_groups_v agv,
1521: ego_obj_attr_grp_assocs_v oagv,
1522: ego_catalog_groups_v cg

Line 1552: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1548:
1549: write_debug (l_proc_name, '22');
1550: -- Attribute name
1551:
1552: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1553: set efpmi.attr_name = ( SELECT eav.attr_name
1554: FROM ego_attrs_v eav
1555: WHERE eav.attr_id = efpmi.attr_id
1556: AND eav.attr_group_name = efpmi.attr_group_name

Line 1572: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1568:
1569: write_debug (l_proc_name, '23');
1570: --- Attr ID
1571: ---
1572: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1573: set efpmi.attr_id = ( select eav.attr_id
1574: from ego_attrs_v eav
1575: where eav.attr_name = efpmi.attr_name
1576: and eav.attr_group_name = efpmi.attr_group_name

Line 1592: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1588:
1589: write_debug (l_proc_name, '24');
1590: --- Function name
1591: ---
1592: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1593: set efpmi.function_name = ( select efv.internal_name
1594: from ego_functions_v efv
1595: where efv.function_id = efv.function_id
1596: )

Line 1610: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1606:
1607: write_debug (l_proc_name, '25');
1608: --- Function id
1609: ---
1610: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1611: set efpmi.function_id = ( select efv.function_id
1612: from ego_functions_v efv
1613: where efv.internal_name = efpmi.function_name
1614: )

Line 1627: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1623: ;
1624:
1625: write_debug (l_proc_name, '26');
1626:
1627: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1628: set efpmi.parameter_id = ( select efpb.func_param_id
1629: from ego_func_params_b efpb
1630: where efpb.internal_name = efpmi.parameter_name
1631: and efpb.function_id = efpmi.function_id

Line 1646: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1642: ;
1643:
1644: write_debug (l_proc_name, '27');
1645:
1646: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1647: set efpmi.parameter_name = ( select efpb.internal_name
1648: from ego_func_params_b efpb
1649: where efpb.func_param_id = efpmi.parameter_id
1650: and efpb.function_id = efpmi.function_id

Line 1735: FROM EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1731: ,G_CONC_REQUEST_ID
1732: ,G_PROG_APPL_ID
1733: ,G_PROGRAM_ID
1734: ,l_sysdate
1735: FROM EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1736: WHERE efpmi.item_catalog_name IS NULL
1737: OR efpmi.item_catalog_group_id IS NULL
1738: AND efpmi.transaction_id IS NOT NULL
1739: AND efpmi.process_status = G_PROCESS_STATUS_INITIAL

Line 1786: FROM EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1782: ,G_CONC_REQUEST_ID
1783: ,G_PROG_APPL_ID
1784: ,G_PROGRAM_ID
1785: ,l_sysdate
1786: FROM EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1787: WHERE efpmi.attr_group_name IS NULL
1788: OR efpmi.attr_group_id IS NULL
1789: AND efpmi.transaction_id IS NOT NULL
1790: AND efpmi.process_status = G_PROCESS_STATUS_INITIAL

Line 1837: FROM EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1833: ,G_CONC_REQUEST_ID
1834: ,G_PROG_APPL_ID
1835: ,G_PROGRAM_ID
1836: ,l_sysdate
1837: FROM EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1838: WHERE efpmi.attr_name IS NULL
1839: OR efpmi.attr_id IS NULL
1840: AND efpmi.transaction_id IS NOT NULL
1841: AND efpmi.process_status = G_PROCESS_STATUS_INITIAL

Line 1892: FROM EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1888: ,G_CONC_REQUEST_ID
1889: ,G_PROG_APPL_ID
1890: ,G_PROGRAM_ID
1891: ,l_sysdate
1892: FROM EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1893: WHERE efpmi.function_name IS NULL
1894: OR efpmi.function_id IS NULL
1895: AND efpmi.transaction_id IS NOT NULL
1896: AND efpmi.process_status = G_PROCESS_STATUS_INITIAL

Line 1944: FROM EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1940: ,G_CONC_REQUEST_ID
1941: ,G_PROG_APPL_ID
1942: ,G_PROGRAM_ID
1943: ,l_sysdate
1944: FROM EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1945: WHERE efpmi.parameter_name IS NULL
1946: OR efpmi.parameter_id IS NULL
1947: AND efpmi.transaction_id IS NOT NULL
1948: AND efpmi.process_status = G_PROCESS_STATUS_INITIAL

Line 1959: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi

1955: write_debug (l_proc_name, '35');
1956:
1957: --- update the interface table records to Error
1958: ---
1959: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1960: SET efpmi.process_status = G_PROCESS_STATUS_ERROR
1961: WHERE efpmi.attr_name IS NULL
1962: OR efpmi.attr_group_name IS NULL
1963: OR efpmi.item_catalog_name IS NULL

Line 8392: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE

8388: l_transaction_id_tbl(i) := p_func_assoc_tbl(i).transaction_id;
8389: END LOOP;
8390:
8391: FORALL i in 1..p_func_assoc_tbl.COUNT
8392: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE
8393: SET ROW = p_func_assoc_tbl(i) -- bug 9701271
8394: WHERE transaction_id = l_transaction_id_tbl(i)
8395: AND process_status = G_PROCESS_STATUS_INITIAL
8396: ;

Line 9334: FROM ego_func_params_map_interface

9330:
9331: CURSOR cur_icc_func_params
9332: is
9333: SELECT *
9334: FROM ego_func_params_map_interface
9335: WHERE (
9336: ( G_SET_PROCESS_ID IS NULL )
9337: OR
9338: ( set_process_id = G_SET_PROCESS_ID)

Line 9774: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE

9770: ELSIF p_entity = G_ENTITY_ICC_FN_PARAM_MAP THEN
9771:
9772: write_debug(l_proc_name,'start func param update ');
9773:
9774: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE
9775: SET transaction_id = mtl_system_items_interface_s.nextval
9776: ,transaction_type = upper(transaction_type)
9777: ,creation_date = nvl(creation_date, l_sysdate)
9778: ,created_by = NVL(created_by , G_USER_ID)

Line 9875: FROM EGO_FUNC_PARAMS_MAP_INTERFACE

9871:
9872: CURSOR cur_fn_map_count
9873: IS
9874: SELECT count(1) count
9875: FROM EGO_FUNC_PARAMS_MAP_INTERFACE
9876: WHERE (
9877: ( G_SET_PROCESS_ID IS NULL )
9878: OR
9879: ( set_process_id = G_SET_PROCESS_ID)

Line 10199: DELETE FROM ego_func_params_map_interface

10195: );
10196:
10197:
10198:
10199: DELETE FROM ego_func_params_map_interface
10200: WHERE transaction_id IS NOT NULL
10201: AND process_status = G_PROCESS_STATUS_SUCCESS
10202: AND (
10203: ( G_SET_PROCESS_ID IS NULL )