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_LIST_HEADERS

Line 24: TYPE LH_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;

20: ------------------------------------------------------------------------- --
21:
22: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_RATE_CHART_PKG';
23:
24: TYPE LH_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
25: TYPE LH_LIST_TYPE_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26: TYPE LH_START_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE LH_END_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE LH_DESCRIPTION_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

Line 25: TYPE LH_LIST_TYPE_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

21:
22: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_RATE_CHART_PKG';
23:
24: TYPE LH_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
25: TYPE LH_LIST_TYPE_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26: TYPE LH_START_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE LH_END_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE LH_DESCRIPTION_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
29: TYPE LH_CREATION_DATE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 26: TYPE LH_START_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;

22: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_RATE_CHART_PKG';
23:
24: TYPE LH_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
25: TYPE LH_LIST_TYPE_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26: TYPE LH_START_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE LH_END_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE LH_DESCRIPTION_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
29: TYPE LH_CREATION_DATE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.CREATION_DATE%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;

Line 27: TYPE LH_END_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;

23:
24: TYPE LH_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
25: TYPE LH_LIST_TYPE_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26: TYPE LH_START_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE LH_END_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE LH_DESCRIPTION_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
29: TYPE LH_CREATION_DATE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.CREATION_DATE%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;

Line 28: TYPE LH_DESCRIPTION_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

24: TYPE LH_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
25: TYPE LH_LIST_TYPE_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26: TYPE LH_START_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE LH_END_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE LH_DESCRIPTION_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
29: TYPE LH_CREATION_DATE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.CREATION_DATE%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:

Line 29: TYPE LH_CREATION_DATE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;

25: TYPE LH_LIST_TYPE_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.LIST_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26: TYPE LH_START_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE LH_END_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE LH_DESCRIPTION_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
29: TYPE LH_CREATION_DATE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.CREATION_DATE%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

Line 30: TYPE LH_LAST_UPDATE_DATE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;

26: TYPE LH_START_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE LH_END_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE LH_DESCRIPTION_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
29: TYPE LH_CREATION_DATE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.CREATION_DATE%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;

Line 31: TYPE LH_ATTRIBUTE1_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;

27: TYPE LH_END_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE LH_DESCRIPTION_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
29: TYPE LH_CREATION_DATE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.CREATION_DATE%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;

Line 746: -- QP_INTERFACE_LIST_HEADERS, QP_INTERFACE_LIST_LINES,

742: -----------------------------------------------------------------------------
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

Line 885: INSERT INTO QP_INTERFACE_LIST_HEADERS ( PROCESS_ID,

881: END LOOP;
882:
883: BEGIN
884: FORALL cnt IN 1..l_count-1
885: INSERT INTO QP_INTERFACE_LIST_HEADERS ( PROCESS_ID,
886: INTERFACE_ACTION_CODE,
887: LIST_TYPE_CODE,
888: START_DATE_ACTIVE,
889: END_DATE_ACTIVE,