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_RATE_CHART_PKG dependencies on QP_INTERFACE_QUALIFIERS

Line 34: TYPE QL_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;

30: TYPE LH_LAST_UPDATE_DATE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE LH_ATTRIBUTE1_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
32:
33: -- GLOBAL VARIABLES FOR QUALIFIERS
34: TYPE QL_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
35: TYPE QL_QUALIFIER_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
36: TYPE QL_QUALIFIER_ATTR_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
37: TYPE QL_QUALIFIER_CONTEXT_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
38:

Line 35: TYPE QL_QUALIFIER_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;

31: TYPE LH_ATTRIBUTE1_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
32:
33: -- GLOBAL VARIABLES FOR QUALIFIERS
34: TYPE QL_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
35: TYPE QL_QUALIFIER_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
36: TYPE QL_QUALIFIER_ATTR_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
37: TYPE QL_QUALIFIER_CONTEXT_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
38:
39: TYPE LL_OPERAND_TAB IS TABLE OF QP_INTERFACE_LIST_LINES.OPERAND%TYPE INDEX BY BINARY_INTEGER;

Line 36: TYPE QL_QUALIFIER_ATTR_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;

32:
33: -- GLOBAL VARIABLES FOR QUALIFIERS
34: TYPE QL_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
35: TYPE QL_QUALIFIER_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
36: TYPE QL_QUALIFIER_ATTR_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
37: TYPE QL_QUALIFIER_CONTEXT_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
38:
39: TYPE LL_OPERAND_TAB IS TABLE OF QP_INTERFACE_LIST_LINES.OPERAND%TYPE INDEX BY BINARY_INTEGER;
40: TYPE LL_COMMENTS_TAB IS TABLE OF QP_INTERFACE_LIST_LINES.COMMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 37: TYPE QL_QUALIFIER_CONTEXT_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;

33: -- GLOBAL VARIABLES FOR QUALIFIERS
34: TYPE QL_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
35: TYPE QL_QUALIFIER_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
36: TYPE QL_QUALIFIER_ATTR_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
37: TYPE QL_QUALIFIER_CONTEXT_TAB IS TABLE OF QP_INTERFACE_QUALIFIERS.QUALIFIER_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
38:
39: TYPE LL_OPERAND_TAB IS TABLE OF QP_INTERFACE_LIST_LINES.OPERAND%TYPE INDEX BY BINARY_INTEGER;
40: TYPE LL_COMMENTS_TAB IS TABLE OF QP_INTERFACE_LIST_LINES.COMMENTS%TYPE INDEX BY BINARY_INTEGER;
41: TYPE LL_PRIMARY_UOM_FLAG_TAB IS TABLE OF QP_INTERFACE_LIST_LINES.PRIMARY_UOM_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 747: -- QP_INTERFACE_QUALIFIERS and QP_INTERFACE_PRICING_ATTRIBS.

743: -- PROCEDURE: INSERT_QP_INTERFACE_TABLES
744: --
745: -- Purpose: Transfer pricelist data from the temporary tables in memory into
746: -- QP_INTERFACE_LIST_HEADERS, QP_INTERFACE_LIST_LINES,
747: -- QP_INTERFACE_QUALIFIERS and QP_INTERFACE_PRICING_ATTRIBS.
748: -- If input parameter 'p_job_id' IS NOT NULL, then the QP api
749: -- QP_PRL_LOADER_PUB(...) is also used to load the rate chart for
750: -- that particular job id. Otherwise, the data might correspond to
751: -- several rate charts, and the QP loading is done elsewhere for all

Line 960: INSERT INTO QP_INTERFACE_QUALIFIERS( PROCESS_ID,

956:
957: --INSERT QUALIFIERS
958: BEGIN
959: FORALL cnt IN p_qp_qualifier_tbl.FIRST..p_qp_qualifier_tbl.LAST
960: INSERT INTO QP_INTERFACE_QUALIFIERS( PROCESS_ID,
961: INTERFACE_ACTION_CODE,
962: QUALIFIER_ATTR_VALUE,
963: QUALIFIER_GROUPING_NO,
964: PROCESS_TYPE,