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.FTE_LANE_PKG dependencies on FTE_PRC_PARAMETERS

Line 79: TYPE VALUE_FROM_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;

75: TYPE SCH_LANE_ID_TBL IS TABLE OF FTE_SCHEDULES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
76: TYPE SCHEDULES_ID_TBL IS TABLE OF FTE_SCHEDULES.SCHEDULES_ID%TYPE INDEX BY BINARY_INTEGER;
77: TYPE SCH_LANE_NUMBER_TBL IS TABLE OF FTE_SCHEDULES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
78:
79: TYPE VALUE_FROM_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
80: TYPE VALUE_TO_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
81: TYPE UOM_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
82: TYPE CURRENCY_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83: TYPE PRC_LANE_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.LANE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 80: TYPE VALUE_TO_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_TO%TYPE INDEX BY BINARY_INTEGER;

76: TYPE SCHEDULES_ID_TBL IS TABLE OF FTE_SCHEDULES.SCHEDULES_ID%TYPE INDEX BY BINARY_INTEGER;
77: TYPE SCH_LANE_NUMBER_TBL IS TABLE OF FTE_SCHEDULES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
78:
79: TYPE VALUE_FROM_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
80: TYPE VALUE_TO_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
81: TYPE UOM_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
82: TYPE CURRENCY_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83: TYPE PRC_LANE_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
84: TYPE PARAMETER_INS_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_INSTANCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 81: TYPE UOM_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.UOM_CODE%TYPE INDEX BY BINARY_INTEGER;

77: TYPE SCH_LANE_NUMBER_TBL IS TABLE OF FTE_SCHEDULES.LANE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
78:
79: TYPE VALUE_FROM_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
80: TYPE VALUE_TO_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
81: TYPE UOM_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
82: TYPE CURRENCY_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83: TYPE PRC_LANE_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
84: TYPE PARAMETER_INS_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_INSTANCE_ID%TYPE INDEX BY BINARY_INTEGER;
85: TYPE PARAMETER_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_ID%TYPE INDEX BY BINARY_INTEGER;

Line 82: TYPE CURRENCY_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

78:
79: TYPE VALUE_FROM_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
80: TYPE VALUE_TO_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
81: TYPE UOM_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
82: TYPE CURRENCY_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83: TYPE PRC_LANE_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
84: TYPE PARAMETER_INS_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_INSTANCE_ID%TYPE INDEX BY BINARY_INTEGER;
85: TYPE PARAMETER_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_ID%TYPE INDEX BY BINARY_INTEGER;
86:

Line 83: TYPE PRC_LANE_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.LANE_ID%TYPE INDEX BY BINARY_INTEGER;

79: TYPE VALUE_FROM_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
80: TYPE VALUE_TO_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
81: TYPE UOM_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
82: TYPE CURRENCY_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83: TYPE PRC_LANE_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
84: TYPE PARAMETER_INS_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_INSTANCE_ID%TYPE INDEX BY BINARY_INTEGER;
85: TYPE PARAMETER_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_ID%TYPE INDEX BY BINARY_INTEGER;
86:
87: --------------------------------------------------------------------------

Line 84: TYPE PARAMETER_INS_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_INSTANCE_ID%TYPE INDEX BY BINARY_INTEGER;

80: TYPE VALUE_TO_TBL IS TABLE OF FTE_PRC_PARAMETERS.VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
81: TYPE UOM_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
82: TYPE CURRENCY_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83: TYPE PRC_LANE_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
84: TYPE PARAMETER_INS_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_INSTANCE_ID%TYPE INDEX BY BINARY_INTEGER;
85: TYPE PARAMETER_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_ID%TYPE INDEX BY BINARY_INTEGER;
86:
87: --------------------------------------------------------------------------
88: -- FUNCTION GET_NEXT_SCHEDULE_ID

Line 85: TYPE PARAMETER_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_ID%TYPE INDEX BY BINARY_INTEGER;

81: TYPE UOM_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
82: TYPE CURRENCY_CODE_TBL IS TABLE OF FTE_PRC_PARAMETERS.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
83: TYPE PRC_LANE_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
84: TYPE PARAMETER_INS_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_INSTANCE_ID%TYPE INDEX BY BINARY_INTEGER;
85: TYPE PARAMETER_ID_TBL IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_ID%TYPE INDEX BY BINARY_INTEGER;
86:
87: --------------------------------------------------------------------------
88: -- FUNCTION GET_NEXT_SCHEDULE_ID
89: --

Line 118: SELECT fte_prc_parameters_s.nextval

114: --------------------------------------------------------------------------
115: FUNCTION GET_NEXT_PRC_PARAMETER_ID RETURN NUMBER IS
116: l_id NUMBER;
117: BEGIN
118: SELECT fte_prc_parameters_s.nextval
119: INTO l_id
120: FROM dual;
121: RETURN l_id;
122: EXCEPTION

Line 657: ELSIF (p_table = 'FTE_PRC_PARAMETERS') THEN

653: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
654: LAST_UPDATE_DATE = sysdate,
655: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
656: WHERE lane_id = p_id;
657: ELSIF (p_table = 'FTE_PRC_PARAMETERS') THEN
658: IF (p_code IS NULL) THEN
659: DELETE from fte_prc_parameters
660: WHERE parameter_instance_id = p_id;
661: ELSE

Line 659: DELETE from fte_prc_parameters

655: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
656: WHERE lane_id = p_id;
657: ELSIF (p_table = 'FTE_PRC_PARAMETERS') THEN
658: IF (p_code IS NULL) THEN
659: DELETE from fte_prc_parameters
660: WHERE parameter_instance_id = p_id;
661: ELSE
662: DELETE from fte_prc_parameters
663: WHERE lane_id = p_id

Line 662: DELETE from fte_prc_parameters

658: IF (p_code IS NULL) THEN
659: DELETE from fte_prc_parameters
660: WHERE parameter_instance_id = p_id;
661: ELSE
662: DELETE from fte_prc_parameters
663: WHERE lane_id = p_id
664: AND parameter_id = TO_NUMBER(p_code);
665: END IF;
666: ELSIF (p_table = 'FTE_SCHEDULES') THEN

Line 1443: INSERT INTO FTE_PRC_PARAMETERS (LANE_ID,

1439: END LOOP;
1440:
1441: BEGIN
1442: FORALL i in p_prc_parameter_tbl.FIRST..p_prc_parameter_tbl.LAST
1443: INSERT INTO FTE_PRC_PARAMETERS (LANE_ID,
1444: PARAMETER_ID,
1445: PARAMETER_INSTANCE_ID,
1446: VALUE_FROM,
1447: VALUE_TO,

Line 1551: l_value_from fte_prc_parameters.value_from%TYPE;

1547: PROCEDURE UPDATE_PRC_PARAMETER( p_prc_parameter_tbl IN prc_parameter_tbl,
1548: x_status OUT NOCOPY NUMBER,
1549: x_error_msg OUT NOCOPY VARCHAR2)IS
1550:
1551: l_value_from fte_prc_parameters.value_from%TYPE;
1552: l_value_to fte_prc_parameters.value_to%TYPE;
1553: l_uom_code fte_prc_parameters.uom_code%TYPE;
1554: l_currency_code fte_prc_parameters.currency_code%TYPE;
1555: l_parameter_instance_id fte_prc_parameters.parameter_instance_id%TYPE;

Line 1552: l_value_to fte_prc_parameters.value_to%TYPE;

1548: x_status OUT NOCOPY NUMBER,
1549: x_error_msg OUT NOCOPY VARCHAR2)IS
1550:
1551: l_value_from fte_prc_parameters.value_from%TYPE;
1552: l_value_to fte_prc_parameters.value_to%TYPE;
1553: l_uom_code fte_prc_parameters.uom_code%TYPE;
1554: l_currency_code fte_prc_parameters.currency_code%TYPE;
1555: l_parameter_instance_id fte_prc_parameters.parameter_instance_id%TYPE;
1556: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.UPDATE_PRC_PARAMETERS';

Line 1553: l_uom_code fte_prc_parameters.uom_code%TYPE;

1549: x_error_msg OUT NOCOPY VARCHAR2)IS
1550:
1551: l_value_from fte_prc_parameters.value_from%TYPE;
1552: l_value_to fte_prc_parameters.value_to%TYPE;
1553: l_uom_code fte_prc_parameters.uom_code%TYPE;
1554: l_currency_code fte_prc_parameters.currency_code%TYPE;
1555: l_parameter_instance_id fte_prc_parameters.parameter_instance_id%TYPE;
1556: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.UPDATE_PRC_PARAMETERS';
1557:

Line 1554: l_currency_code fte_prc_parameters.currency_code%TYPE;

1550:
1551: l_value_from fte_prc_parameters.value_from%TYPE;
1552: l_value_to fte_prc_parameters.value_to%TYPE;
1553: l_uom_code fte_prc_parameters.uom_code%TYPE;
1554: l_currency_code fte_prc_parameters.currency_code%TYPE;
1555: l_parameter_instance_id fte_prc_parameters.parameter_instance_id%TYPE;
1556: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.UPDATE_PRC_PARAMETERS';
1557:
1558: BEGIN

Line 1555: l_parameter_instance_id fte_prc_parameters.parameter_instance_id%TYPE;

1551: l_value_from fte_prc_parameters.value_from%TYPE;
1552: l_value_to fte_prc_parameters.value_to%TYPE;
1553: l_uom_code fte_prc_parameters.uom_code%TYPE;
1554: l_currency_code fte_prc_parameters.currency_code%TYPE;
1555: l_parameter_instance_id fte_prc_parameters.parameter_instance_id%TYPE;
1556: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.UPDATE_PRC_PARAMETERS';
1557:
1558: BEGIN
1559:

Line 1578: UPDATE fte_prc_parameters

1574: END IF;
1575:
1576: x_status := -1;
1577:
1578: UPDATE fte_prc_parameters
1579: SET value_from = l_value_from,
1580: value_to = l_value_to,
1581: uom_code = l_uom_code,
1582: currency_code = l_currency_code,