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_PRICING_ATTRIBS

Line 61: TYPE AT_PROCESS_TYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PROCESS_TYPE%TYPE INDEX BY BINARY_INTEGER;

57: TYPE LL_START_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_LINES.START_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
58: TYPE LL_END_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_LINES.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
59:
60: -- GLOBAL VARIABLES FROM ATTRIBUTE
61: TYPE AT_PROCESS_TYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PROCESS_TYPE%TYPE INDEX BY BINARY_INTEGER;
62: TYPE AT_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
63: TYPE AT_EXCLUDER_FLAG_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
64: TYPE AT_PRODUCT_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
65: TYPE AT_PRODUCT_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;

Line 62: TYPE AT_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;

58: TYPE LL_END_DATE_ACTIVE_TAB IS TABLE OF QP_INTERFACE_LIST_LINES.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;
59:
60: -- GLOBAL VARIABLES FROM ATTRIBUTE
61: TYPE AT_PROCESS_TYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PROCESS_TYPE%TYPE INDEX BY BINARY_INTEGER;
62: TYPE AT_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
63: TYPE AT_EXCLUDER_FLAG_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
64: TYPE AT_PRODUCT_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
65: TYPE AT_PRODUCT_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE AT_PRODUCT_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 63: TYPE AT_EXCLUDER_FLAG_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;

59:
60: -- GLOBAL VARIABLES FROM ATTRIBUTE
61: TYPE AT_PROCESS_TYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PROCESS_TYPE%TYPE INDEX BY BINARY_INTEGER;
62: TYPE AT_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
63: TYPE AT_EXCLUDER_FLAG_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
64: TYPE AT_PRODUCT_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
65: TYPE AT_PRODUCT_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE AT_PRODUCT_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
67: TYPE AT_PRODUCT_UOM_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 64: TYPE AT_PRODUCT_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;

60: -- GLOBAL VARIABLES FROM ATTRIBUTE
61: TYPE AT_PROCESS_TYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PROCESS_TYPE%TYPE INDEX BY BINARY_INTEGER;
62: TYPE AT_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
63: TYPE AT_EXCLUDER_FLAG_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
64: TYPE AT_PRODUCT_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
65: TYPE AT_PRODUCT_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE AT_PRODUCT_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
67: TYPE AT_PRODUCT_UOM_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
68: TYPE AT_PRODUCT_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;

Line 65: TYPE AT_PRODUCT_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;

61: TYPE AT_PROCESS_TYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PROCESS_TYPE%TYPE INDEX BY BINARY_INTEGER;
62: TYPE AT_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
63: TYPE AT_EXCLUDER_FLAG_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
64: TYPE AT_PRODUCT_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
65: TYPE AT_PRODUCT_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE AT_PRODUCT_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
67: TYPE AT_PRODUCT_UOM_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
68: TYPE AT_PRODUCT_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
69: TYPE AT_PRICING_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;

Line 66: TYPE AT_PRODUCT_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;

62: TYPE AT_INT_ACTION_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.INTERFACE_ACTION_CODE%TYPE INDEX BY BINARY_INTEGER;
63: TYPE AT_EXCLUDER_FLAG_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
64: TYPE AT_PRODUCT_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
65: TYPE AT_PRODUCT_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE AT_PRODUCT_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
67: TYPE AT_PRODUCT_UOM_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
68: TYPE AT_PRODUCT_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
69: TYPE AT_PRICING_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
70: TYPE AT_PRICING_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;

Line 67: TYPE AT_PRODUCT_UOM_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;

63: TYPE AT_EXCLUDER_FLAG_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.EXCLUDER_FLAG%TYPE INDEX BY BINARY_INTEGER;
64: TYPE AT_PRODUCT_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
65: TYPE AT_PRODUCT_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE AT_PRODUCT_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
67: TYPE AT_PRODUCT_UOM_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
68: TYPE AT_PRODUCT_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
69: TYPE AT_PRICING_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
70: TYPE AT_PRICING_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
71: TYPE AT_PRICING_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;

Line 68: TYPE AT_PRODUCT_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;

64: TYPE AT_PRODUCT_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
65: TYPE AT_PRODUCT_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE AT_PRODUCT_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
67: TYPE AT_PRODUCT_UOM_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
68: TYPE AT_PRODUCT_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
69: TYPE AT_PRICING_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
70: TYPE AT_PRICING_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
71: TYPE AT_PRICING_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE AT_COMP_OPERATOR_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 69: TYPE AT_PRICING_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;

65: TYPE AT_PRODUCT_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
66: TYPE AT_PRODUCT_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
67: TYPE AT_PRODUCT_UOM_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
68: TYPE AT_PRODUCT_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
69: TYPE AT_PRICING_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
70: TYPE AT_PRICING_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
71: TYPE AT_PRICING_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE AT_COMP_OPERATOR_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;
73: TYPE AT_PRICING_ATTR_VALUE_FROM_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 70: TYPE AT_PRICING_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;

66: TYPE AT_PRODUCT_ATTR_VALUE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTR_VALUE%TYPE INDEX BY BINARY_INTEGER;
67: TYPE AT_PRODUCT_UOM_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
68: TYPE AT_PRODUCT_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
69: TYPE AT_PRICING_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
70: TYPE AT_PRICING_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
71: TYPE AT_PRICING_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE AT_COMP_OPERATOR_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;
73: TYPE AT_PRICING_ATTR_VALUE_FROM_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
74: TYPE AT_PRICING_ATTR_VALUE_TO_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTR_VALUE_TO%TYPE INDEX BY BINARY_INTEGER;

Line 71: TYPE AT_PRICING_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;

67: TYPE AT_PRODUCT_UOM_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
68: TYPE AT_PRODUCT_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
69: TYPE AT_PRICING_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
70: TYPE AT_PRICING_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
71: TYPE AT_PRICING_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE AT_COMP_OPERATOR_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;
73: TYPE AT_PRICING_ATTR_VALUE_FROM_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
74: TYPE AT_PRICING_ATTR_VALUE_TO_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTR_VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
75:

Line 72: TYPE AT_COMP_OPERATOR_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;

68: TYPE AT_PRODUCT_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRODUCT_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
69: TYPE AT_PRICING_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
70: TYPE AT_PRICING_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
71: TYPE AT_PRICING_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE AT_COMP_OPERATOR_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;
73: TYPE AT_PRICING_ATTR_VALUE_FROM_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
74: TYPE AT_PRICING_ATTR_VALUE_TO_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTR_VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
75:
76: -------------------------------------------------------------------------------

Line 73: TYPE AT_PRICING_ATTR_VALUE_FROM_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;

69: TYPE AT_PRICING_ATTR_DATATYPE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_DATATYPE%TYPE INDEX BY BINARY_INTEGER;
70: TYPE AT_PRICING_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
71: TYPE AT_PRICING_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE AT_COMP_OPERATOR_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;
73: TYPE AT_PRICING_ATTR_VALUE_FROM_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
74: TYPE AT_PRICING_ATTR_VALUE_TO_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTR_VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
75:
76: -------------------------------------------------------------------------------
77: --

Line 74: TYPE AT_PRICING_ATTR_VALUE_TO_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTR_VALUE_TO%TYPE INDEX BY BINARY_INTEGER;

70: TYPE AT_PRICING_ATTR_CONTEXT_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
71: TYPE AT_PRICING_ATTR_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
72: TYPE AT_COMP_OPERATOR_CODE_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.COMPARISON_OPERATOR_CODE%TYPE INDEX BY BINARY_INTEGER;
73: TYPE AT_PRICING_ATTR_VALUE_FROM_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTR_VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
74: TYPE AT_PRICING_ATTR_VALUE_TO_TAB IS TABLE OF QP_INTERFACE_PRICING_ATTRIBS.PRICING_ATTR_VALUE_TO%TYPE INDEX BY BINARY_INTEGER;
75:
76: -------------------------------------------------------------------------------
77: --
78: -- Reset_Region_Info. Resets GLOBAL record for Region. It is used by

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 1194: INSERT INTO QP_INTERFACE_PRICING_ATTRIBS(PROCESS_ID,

1190: END LOOP;
1191:
1192: BEGIN
1193: FORALL cnt IN p_qp_pricing_attrib_tbl.FIRST..p_qp_pricing_attrib_tbl.LAST
1194: INSERT INTO QP_INTERFACE_PRICING_ATTRIBS(PROCESS_ID,
1195: PROCESS_TYPE,
1196: INTERFACE_ACTION_CODE,
1197: EXCLUDER_FLAG,
1198: PRODUCT_ATTRIBUTE_CONTEXT,