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 55: PROCESS_ID qp_interface_pricing_attribs.process_id%TYPE,

51: qp_list_line_rec
52: INDEX BY BINARY_INTEGER;
53:
54: TYPE qp_pricing_attrib_rec IS RECORD (
55: PROCESS_ID qp_interface_pricing_attribs.process_id%TYPE,
56: PROCESS_TYPE qp_interface_pricing_attribs.process_type%TYPE,
57: INTERFACE_ACTION_CODE qp_interface_pricing_attribs.interface_action_code%TYPE,
58: EXCLUDER_FLAG qp_interface_pricing_attribs.excluder_flag%TYPE,
59: PRODUCT_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.product_attribute_context%TYPE,

Line 56: PROCESS_TYPE qp_interface_pricing_attribs.process_type%TYPE,

52: INDEX BY BINARY_INTEGER;
53:
54: TYPE qp_pricing_attrib_rec IS RECORD (
55: PROCESS_ID qp_interface_pricing_attribs.process_id%TYPE,
56: PROCESS_TYPE qp_interface_pricing_attribs.process_type%TYPE,
57: INTERFACE_ACTION_CODE qp_interface_pricing_attribs.interface_action_code%TYPE,
58: EXCLUDER_FLAG qp_interface_pricing_attribs.excluder_flag%TYPE,
59: PRODUCT_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.product_attribute_context%TYPE,
60: PRODUCT_ATTRIBUTE qp_interface_pricing_attribs.product_attribute%TYPE,

Line 57: INTERFACE_ACTION_CODE qp_interface_pricing_attribs.interface_action_code%TYPE,

53:
54: TYPE qp_pricing_attrib_rec IS RECORD (
55: PROCESS_ID qp_interface_pricing_attribs.process_id%TYPE,
56: PROCESS_TYPE qp_interface_pricing_attribs.process_type%TYPE,
57: INTERFACE_ACTION_CODE qp_interface_pricing_attribs.interface_action_code%TYPE,
58: EXCLUDER_FLAG qp_interface_pricing_attribs.excluder_flag%TYPE,
59: PRODUCT_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.product_attribute_context%TYPE,
60: PRODUCT_ATTRIBUTE qp_interface_pricing_attribs.product_attribute%TYPE,
61: PRODUCT_ATTR_VALUE qp_interface_pricing_attribs.product_attr_value%TYPE,

Line 58: EXCLUDER_FLAG qp_interface_pricing_attribs.excluder_flag%TYPE,

54: TYPE qp_pricing_attrib_rec IS RECORD (
55: PROCESS_ID qp_interface_pricing_attribs.process_id%TYPE,
56: PROCESS_TYPE qp_interface_pricing_attribs.process_type%TYPE,
57: INTERFACE_ACTION_CODE qp_interface_pricing_attribs.interface_action_code%TYPE,
58: EXCLUDER_FLAG qp_interface_pricing_attribs.excluder_flag%TYPE,
59: PRODUCT_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.product_attribute_context%TYPE,
60: PRODUCT_ATTRIBUTE qp_interface_pricing_attribs.product_attribute%TYPE,
61: PRODUCT_ATTR_VALUE qp_interface_pricing_attribs.product_attr_value%TYPE,
62: PRODUCT_UOM_CODE qp_interface_pricing_attribs.product_uom_code%TYPE,

Line 59: PRODUCT_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.product_attribute_context%TYPE,

55: PROCESS_ID qp_interface_pricing_attribs.process_id%TYPE,
56: PROCESS_TYPE qp_interface_pricing_attribs.process_type%TYPE,
57: INTERFACE_ACTION_CODE qp_interface_pricing_attribs.interface_action_code%TYPE,
58: EXCLUDER_FLAG qp_interface_pricing_attribs.excluder_flag%TYPE,
59: PRODUCT_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.product_attribute_context%TYPE,
60: PRODUCT_ATTRIBUTE qp_interface_pricing_attribs.product_attribute%TYPE,
61: PRODUCT_ATTR_VALUE qp_interface_pricing_attribs.product_attr_value%TYPE,
62: PRODUCT_UOM_CODE qp_interface_pricing_attribs.product_uom_code%TYPE,
63: PRODUCT_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.product_attribute_datatype%TYPE,

Line 60: PRODUCT_ATTRIBUTE qp_interface_pricing_attribs.product_attribute%TYPE,

56: PROCESS_TYPE qp_interface_pricing_attribs.process_type%TYPE,
57: INTERFACE_ACTION_CODE qp_interface_pricing_attribs.interface_action_code%TYPE,
58: EXCLUDER_FLAG qp_interface_pricing_attribs.excluder_flag%TYPE,
59: PRODUCT_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.product_attribute_context%TYPE,
60: PRODUCT_ATTRIBUTE qp_interface_pricing_attribs.product_attribute%TYPE,
61: PRODUCT_ATTR_VALUE qp_interface_pricing_attribs.product_attr_value%TYPE,
62: PRODUCT_UOM_CODE qp_interface_pricing_attribs.product_uom_code%TYPE,
63: PRODUCT_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.product_attribute_datatype%TYPE,
64: PRICING_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.pricing_attribute_datatype%TYPE,

Line 61: PRODUCT_ATTR_VALUE qp_interface_pricing_attribs.product_attr_value%TYPE,

57: INTERFACE_ACTION_CODE qp_interface_pricing_attribs.interface_action_code%TYPE,
58: EXCLUDER_FLAG qp_interface_pricing_attribs.excluder_flag%TYPE,
59: PRODUCT_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.product_attribute_context%TYPE,
60: PRODUCT_ATTRIBUTE qp_interface_pricing_attribs.product_attribute%TYPE,
61: PRODUCT_ATTR_VALUE qp_interface_pricing_attribs.product_attr_value%TYPE,
62: PRODUCT_UOM_CODE qp_interface_pricing_attribs.product_uom_code%TYPE,
63: PRODUCT_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.product_attribute_datatype%TYPE,
64: PRICING_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.pricing_attribute_datatype%TYPE,
65: PRICING_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.pricing_attribute_context%TYPE,

Line 62: PRODUCT_UOM_CODE qp_interface_pricing_attribs.product_uom_code%TYPE,

58: EXCLUDER_FLAG qp_interface_pricing_attribs.excluder_flag%TYPE,
59: PRODUCT_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.product_attribute_context%TYPE,
60: PRODUCT_ATTRIBUTE qp_interface_pricing_attribs.product_attribute%TYPE,
61: PRODUCT_ATTR_VALUE qp_interface_pricing_attribs.product_attr_value%TYPE,
62: PRODUCT_UOM_CODE qp_interface_pricing_attribs.product_uom_code%TYPE,
63: PRODUCT_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.product_attribute_datatype%TYPE,
64: PRICING_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.pricing_attribute_datatype%TYPE,
65: PRICING_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.pricing_attribute_context%TYPE,
66: PRICING_ATTRIBUTE qp_interface_pricing_attribs.pricing_attribute%TYPE,

Line 63: PRODUCT_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.product_attribute_datatype%TYPE,

59: PRODUCT_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.product_attribute_context%TYPE,
60: PRODUCT_ATTRIBUTE qp_interface_pricing_attribs.product_attribute%TYPE,
61: PRODUCT_ATTR_VALUE qp_interface_pricing_attribs.product_attr_value%TYPE,
62: PRODUCT_UOM_CODE qp_interface_pricing_attribs.product_uom_code%TYPE,
63: PRODUCT_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.product_attribute_datatype%TYPE,
64: PRICING_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.pricing_attribute_datatype%TYPE,
65: PRICING_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.pricing_attribute_context%TYPE,
66: PRICING_ATTRIBUTE qp_interface_pricing_attribs.pricing_attribute%TYPE,
67: PRICING_ATTR_VALUE_FROM qp_interface_pricing_attribs.pricing_attr_value_from%TYPE,

Line 64: PRICING_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.pricing_attribute_datatype%TYPE,

60: PRODUCT_ATTRIBUTE qp_interface_pricing_attribs.product_attribute%TYPE,
61: PRODUCT_ATTR_VALUE qp_interface_pricing_attribs.product_attr_value%TYPE,
62: PRODUCT_UOM_CODE qp_interface_pricing_attribs.product_uom_code%TYPE,
63: PRODUCT_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.product_attribute_datatype%TYPE,
64: PRICING_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.pricing_attribute_datatype%TYPE,
65: PRICING_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.pricing_attribute_context%TYPE,
66: PRICING_ATTRIBUTE qp_interface_pricing_attribs.pricing_attribute%TYPE,
67: PRICING_ATTR_VALUE_FROM qp_interface_pricing_attribs.pricing_attr_value_from%TYPE,
68: PRICING_ATTR_VALUE_TO qp_interface_pricing_attribs.pricing_attr_value_to%TYPE,

Line 65: PRICING_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.pricing_attribute_context%TYPE,

61: PRODUCT_ATTR_VALUE qp_interface_pricing_attribs.product_attr_value%TYPE,
62: PRODUCT_UOM_CODE qp_interface_pricing_attribs.product_uom_code%TYPE,
63: PRODUCT_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.product_attribute_datatype%TYPE,
64: PRICING_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.pricing_attribute_datatype%TYPE,
65: PRICING_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.pricing_attribute_context%TYPE,
66: PRICING_ATTRIBUTE qp_interface_pricing_attribs.pricing_attribute%TYPE,
67: PRICING_ATTR_VALUE_FROM qp_interface_pricing_attribs.pricing_attr_value_from%TYPE,
68: PRICING_ATTR_VALUE_TO qp_interface_pricing_attribs.pricing_attr_value_to%TYPE,
69: ATTRIBUTE_GROUPING_NO qp_interface_pricing_attribs.attribute_grouping_no%TYPE,

Line 66: PRICING_ATTRIBUTE qp_interface_pricing_attribs.pricing_attribute%TYPE,

62: PRODUCT_UOM_CODE qp_interface_pricing_attribs.product_uom_code%TYPE,
63: PRODUCT_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.product_attribute_datatype%TYPE,
64: PRICING_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.pricing_attribute_datatype%TYPE,
65: PRICING_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.pricing_attribute_context%TYPE,
66: PRICING_ATTRIBUTE qp_interface_pricing_attribs.pricing_attribute%TYPE,
67: PRICING_ATTR_VALUE_FROM qp_interface_pricing_attribs.pricing_attr_value_from%TYPE,
68: PRICING_ATTR_VALUE_TO qp_interface_pricing_attribs.pricing_attr_value_to%TYPE,
69: ATTRIBUTE_GROUPING_NO qp_interface_pricing_attribs.attribute_grouping_no%TYPE,
70: COMPARISON_OPERATOR_CODE qp_interface_pricing_attribs.comparison_operator_code%TYPE,

Line 67: PRICING_ATTR_VALUE_FROM qp_interface_pricing_attribs.pricing_attr_value_from%TYPE,

63: PRODUCT_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.product_attribute_datatype%TYPE,
64: PRICING_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.pricing_attribute_datatype%TYPE,
65: PRICING_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.pricing_attribute_context%TYPE,
66: PRICING_ATTRIBUTE qp_interface_pricing_attribs.pricing_attribute%TYPE,
67: PRICING_ATTR_VALUE_FROM qp_interface_pricing_attribs.pricing_attr_value_from%TYPE,
68: PRICING_ATTR_VALUE_TO qp_interface_pricing_attribs.pricing_attr_value_to%TYPE,
69: ATTRIBUTE_GROUPING_NO qp_interface_pricing_attribs.attribute_grouping_no%TYPE,
70: COMPARISON_OPERATOR_CODE qp_interface_pricing_attribs.comparison_operator_code%TYPE,
71: LIST_LINE_NO qp_interface_pricing_attribs.list_line_no%TYPE);

Line 68: PRICING_ATTR_VALUE_TO qp_interface_pricing_attribs.pricing_attr_value_to%TYPE,

64: PRICING_ATTRIBUTE_DATATYPE qp_interface_pricing_attribs.pricing_attribute_datatype%TYPE,
65: PRICING_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.pricing_attribute_context%TYPE,
66: PRICING_ATTRIBUTE qp_interface_pricing_attribs.pricing_attribute%TYPE,
67: PRICING_ATTR_VALUE_FROM qp_interface_pricing_attribs.pricing_attr_value_from%TYPE,
68: PRICING_ATTR_VALUE_TO qp_interface_pricing_attribs.pricing_attr_value_to%TYPE,
69: ATTRIBUTE_GROUPING_NO qp_interface_pricing_attribs.attribute_grouping_no%TYPE,
70: COMPARISON_OPERATOR_CODE qp_interface_pricing_attribs.comparison_operator_code%TYPE,
71: LIST_LINE_NO qp_interface_pricing_attribs.list_line_no%TYPE);
72:

Line 69: ATTRIBUTE_GROUPING_NO qp_interface_pricing_attribs.attribute_grouping_no%TYPE,

65: PRICING_ATTRIBUTE_CONTEXT qp_interface_pricing_attribs.pricing_attribute_context%TYPE,
66: PRICING_ATTRIBUTE qp_interface_pricing_attribs.pricing_attribute%TYPE,
67: PRICING_ATTR_VALUE_FROM qp_interface_pricing_attribs.pricing_attr_value_from%TYPE,
68: PRICING_ATTR_VALUE_TO qp_interface_pricing_attribs.pricing_attr_value_to%TYPE,
69: ATTRIBUTE_GROUPING_NO qp_interface_pricing_attribs.attribute_grouping_no%TYPE,
70: COMPARISON_OPERATOR_CODE qp_interface_pricing_attribs.comparison_operator_code%TYPE,
71: LIST_LINE_NO qp_interface_pricing_attribs.list_line_no%TYPE);
72:
73: TYPE qp_pricing_attrib_tbl IS TABLE OF

Line 70: COMPARISON_OPERATOR_CODE qp_interface_pricing_attribs.comparison_operator_code%TYPE,

66: PRICING_ATTRIBUTE qp_interface_pricing_attribs.pricing_attribute%TYPE,
67: PRICING_ATTR_VALUE_FROM qp_interface_pricing_attribs.pricing_attr_value_from%TYPE,
68: PRICING_ATTR_VALUE_TO qp_interface_pricing_attribs.pricing_attr_value_to%TYPE,
69: ATTRIBUTE_GROUPING_NO qp_interface_pricing_attribs.attribute_grouping_no%TYPE,
70: COMPARISON_OPERATOR_CODE qp_interface_pricing_attribs.comparison_operator_code%TYPE,
71: LIST_LINE_NO qp_interface_pricing_attribs.list_line_no%TYPE);
72:
73: TYPE qp_pricing_attrib_tbl IS TABLE OF
74: qp_pricing_attrib_rec

Line 71: LIST_LINE_NO qp_interface_pricing_attribs.list_line_no%TYPE);

67: PRICING_ATTR_VALUE_FROM qp_interface_pricing_attribs.pricing_attr_value_from%TYPE,
68: PRICING_ATTR_VALUE_TO qp_interface_pricing_attribs.pricing_attr_value_to%TYPE,
69: ATTRIBUTE_GROUPING_NO qp_interface_pricing_attribs.attribute_grouping_no%TYPE,
70: COMPARISON_OPERATOR_CODE qp_interface_pricing_attribs.comparison_operator_code%TYPE,
71: LIST_LINE_NO qp_interface_pricing_attribs.list_line_no%TYPE);
72:
73: TYPE qp_pricing_attrib_tbl IS TABLE OF
74: qp_pricing_attrib_rec
75: INDEX BY BINARY_INTEGER;

Line 205: -- QP_INTERFACE_QUALIFIERS and QP_INTERFACE_PRICING_ATTRIBS.

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
209: -- several rate charts, and the QP loading is done elsewhere for all