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 5: PROCESS_ID qp_interface_list_headers.process_id%TYPE,

1: PACKAGE FTE_RATE_CHART_PKG AUTHID CURRENT_USER AS
2: /* $Header: FTERCPKS.pls 120.3 2005/07/21 14:13:29 jishen noship $ */
3:
4: TYPE qp_list_header_rec IS RECORD (
5: PROCESS_ID qp_interface_list_headers.process_id%TYPE,
6: INTERFACE_ACTION_CODE qp_interface_list_headers.interface_action_code%TYPE,
7: LIST_TYPE_CODE qp_interface_list_headers.list_type_code%TYPE,
8: START_DATE_ACTIVE qp_interface_list_headers.start_date_active%TYPE,
9: END_DATE_ACTIVE qp_interface_list_headers.end_date_active%TYPE,

Line 6: INTERFACE_ACTION_CODE qp_interface_list_headers.interface_action_code%TYPE,

2: /* $Header: FTERCPKS.pls 120.3 2005/07/21 14:13:29 jishen noship $ */
3:
4: TYPE qp_list_header_rec IS RECORD (
5: PROCESS_ID qp_interface_list_headers.process_id%TYPE,
6: INTERFACE_ACTION_CODE qp_interface_list_headers.interface_action_code%TYPE,
7: LIST_TYPE_CODE qp_interface_list_headers.list_type_code%TYPE,
8: START_DATE_ACTIVE qp_interface_list_headers.start_date_active%TYPE,
9: END_DATE_ACTIVE qp_interface_list_headers.end_date_active%TYPE,
10: CURRENCY_CODE qp_interface_list_headers.currency_code%TYPE,

Line 7: LIST_TYPE_CODE qp_interface_list_headers.list_type_code%TYPE,

3:
4: TYPE qp_list_header_rec IS RECORD (
5: PROCESS_ID qp_interface_list_headers.process_id%TYPE,
6: INTERFACE_ACTION_CODE qp_interface_list_headers.interface_action_code%TYPE,
7: LIST_TYPE_CODE qp_interface_list_headers.list_type_code%TYPE,
8: START_DATE_ACTIVE qp_interface_list_headers.start_date_active%TYPE,
9: END_DATE_ACTIVE qp_interface_list_headers.end_date_active%TYPE,
10: CURRENCY_CODE qp_interface_list_headers.currency_code%TYPE,
11: NAME qp_interface_list_headers.name%TYPE,

Line 8: START_DATE_ACTIVE qp_interface_list_headers.start_date_active%TYPE,

4: TYPE qp_list_header_rec IS RECORD (
5: PROCESS_ID qp_interface_list_headers.process_id%TYPE,
6: INTERFACE_ACTION_CODE qp_interface_list_headers.interface_action_code%TYPE,
7: LIST_TYPE_CODE qp_interface_list_headers.list_type_code%TYPE,
8: START_DATE_ACTIVE qp_interface_list_headers.start_date_active%TYPE,
9: END_DATE_ACTIVE qp_interface_list_headers.end_date_active%TYPE,
10: CURRENCY_CODE qp_interface_list_headers.currency_code%TYPE,
11: NAME qp_interface_list_headers.name%TYPE,
12: DESCRIPTION qp_interface_list_headers.description%TYPE,

Line 9: END_DATE_ACTIVE qp_interface_list_headers.end_date_active%TYPE,

5: PROCESS_ID qp_interface_list_headers.process_id%TYPE,
6: INTERFACE_ACTION_CODE qp_interface_list_headers.interface_action_code%TYPE,
7: LIST_TYPE_CODE qp_interface_list_headers.list_type_code%TYPE,
8: START_DATE_ACTIVE qp_interface_list_headers.start_date_active%TYPE,
9: END_DATE_ACTIVE qp_interface_list_headers.end_date_active%TYPE,
10: CURRENCY_CODE qp_interface_list_headers.currency_code%TYPE,
11: NAME qp_interface_list_headers.name%TYPE,
12: DESCRIPTION qp_interface_list_headers.description%TYPE,
13: LIST_HEADER_ID qp_interface_list_headers.list_header_id%TYPE,

Line 10: CURRENCY_CODE qp_interface_list_headers.currency_code%TYPE,

6: INTERFACE_ACTION_CODE qp_interface_list_headers.interface_action_code%TYPE,
7: LIST_TYPE_CODE qp_interface_list_headers.list_type_code%TYPE,
8: START_DATE_ACTIVE qp_interface_list_headers.start_date_active%TYPE,
9: END_DATE_ACTIVE qp_interface_list_headers.end_date_active%TYPE,
10: CURRENCY_CODE qp_interface_list_headers.currency_code%TYPE,
11: NAME qp_interface_list_headers.name%TYPE,
12: DESCRIPTION qp_interface_list_headers.description%TYPE,
13: LIST_HEADER_ID qp_interface_list_headers.list_header_id%TYPE,
14: ATTRIBUTE1 qp_interface_list_headers.attribute1%TYPE);

Line 11: NAME qp_interface_list_headers.name%TYPE,

7: LIST_TYPE_CODE qp_interface_list_headers.list_type_code%TYPE,
8: START_DATE_ACTIVE qp_interface_list_headers.start_date_active%TYPE,
9: END_DATE_ACTIVE qp_interface_list_headers.end_date_active%TYPE,
10: CURRENCY_CODE qp_interface_list_headers.currency_code%TYPE,
11: NAME qp_interface_list_headers.name%TYPE,
12: DESCRIPTION qp_interface_list_headers.description%TYPE,
13: LIST_HEADER_ID qp_interface_list_headers.list_header_id%TYPE,
14: ATTRIBUTE1 qp_interface_list_headers.attribute1%TYPE);
15:

Line 12: DESCRIPTION qp_interface_list_headers.description%TYPE,

8: START_DATE_ACTIVE qp_interface_list_headers.start_date_active%TYPE,
9: END_DATE_ACTIVE qp_interface_list_headers.end_date_active%TYPE,
10: CURRENCY_CODE qp_interface_list_headers.currency_code%TYPE,
11: NAME qp_interface_list_headers.name%TYPE,
12: DESCRIPTION qp_interface_list_headers.description%TYPE,
13: LIST_HEADER_ID qp_interface_list_headers.list_header_id%TYPE,
14: ATTRIBUTE1 qp_interface_list_headers.attribute1%TYPE);
15:
16: TYPE qp_list_header_tbl IS TABLE OF

Line 13: LIST_HEADER_ID qp_interface_list_headers.list_header_id%TYPE,

9: END_DATE_ACTIVE qp_interface_list_headers.end_date_active%TYPE,
10: CURRENCY_CODE qp_interface_list_headers.currency_code%TYPE,
11: NAME qp_interface_list_headers.name%TYPE,
12: DESCRIPTION qp_interface_list_headers.description%TYPE,
13: LIST_HEADER_ID qp_interface_list_headers.list_header_id%TYPE,
14: ATTRIBUTE1 qp_interface_list_headers.attribute1%TYPE);
15:
16: TYPE qp_list_header_tbl IS TABLE OF
17: qp_list_header_rec

Line 14: ATTRIBUTE1 qp_interface_list_headers.attribute1%TYPE);

10: CURRENCY_CODE qp_interface_list_headers.currency_code%TYPE,
11: NAME qp_interface_list_headers.name%TYPE,
12: DESCRIPTION qp_interface_list_headers.description%TYPE,
13: LIST_HEADER_ID qp_interface_list_headers.list_header_id%TYPE,
14: ATTRIBUTE1 qp_interface_list_headers.attribute1%TYPE);
15:
16: TYPE qp_list_header_tbl IS TABLE OF
17: qp_list_header_rec
18: INDEX BY BINARY_INTEGER;

Line 97: TYPE LH_CURRENCY_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

93:
94: TYPE VARCHAR2_TAB IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
95: TYPE NUMBER_TAB IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
96:
97: TYPE LH_CURRENCY_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
98: TYPE LH_NAME_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.NAME%TYPE INDEX BY BINARY_INTEGER;
99:
100: -- GLOBAL VARIABLES FOR Rate Chart HEADER
101:

Line 98: TYPE LH_NAME_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.NAME%TYPE INDEX BY BINARY_INTEGER;

94: TYPE VARCHAR2_TAB IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
95: TYPE NUMBER_TAB IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
96:
97: TYPE LH_CURRENCY_CODE_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
98: TYPE LH_NAME_TAB IS TABLE OF QP_INTERFACE_LIST_HEADERS.NAME%TYPE INDEX BY BINARY_INTEGER;
99:
100: -- GLOBAL VARIABLES FOR Rate Chart HEADER
101:
102: G_Chart_Type VARCHAR2(50);

Line 204: -- QP_INTERFACE_LIST_HEADERS, QP_INTERFACE_LIST_LINES,

200: -----------------------------------------------------------------------------
201: -- PROCEDURE: INSERT_QP_INTERFACE_TABLES
202: --
203: -- Purpose: Transfer pricelist data from the temporary tables in memory into
204: -- QP_INTERFACE_LIST_HEADERS, QP_INTERFACE_LIST_LINES,
205: -- QP_INTERFACE_QUALIFIERS and QP_INTERFACE_PRICING_ATTRIBS.
206: -- If input parameter 'p_job_id' IS NOT NULL, then the QP api
207: -- QP_PRL_LOADER_PUB(...) is also used to load the rate chart for
208: -- that particular job id. Otherwise, the data might correspond to