DBA Data[Home] [Help]

APPS.FTE_RATE_CHART_PKG dependencies on QP_INTERFACE_QUALIFIERS

Line 78: PROCESS_ID qp_interface_qualifiers.process_id%TYPE,

74: qp_pricing_attrib_rec
75: INDEX BY BINARY_INTEGER;
76:
77: TYPE qp_qualifier_rec IS RECORD (
78: PROCESS_ID qp_interface_qualifiers.process_id%TYPE,
79: INTERFACE_ACTION_CODE qp_interface_qualifiers.interface_action_code%TYPE,
80: QUALIFIER_ATTR_VALUE qp_interface_qualifiers.qualifier_attr_value%TYPE,
81: QUALIFIER_GROUPING_NO qp_interface_qualifiers.qualifier_grouping_no%TYPE,
82: PROCESS_TYPE qp_interface_qualifiers.process_type%TYPE,

Line 79: INTERFACE_ACTION_CODE qp_interface_qualifiers.interface_action_code%TYPE,

75: INDEX BY BINARY_INTEGER;
76:
77: TYPE qp_qualifier_rec IS RECORD (
78: PROCESS_ID qp_interface_qualifiers.process_id%TYPE,
79: INTERFACE_ACTION_CODE qp_interface_qualifiers.interface_action_code%TYPE,
80: QUALIFIER_ATTR_VALUE qp_interface_qualifiers.qualifier_attr_value%TYPE,
81: QUALIFIER_GROUPING_NO qp_interface_qualifiers.qualifier_grouping_no%TYPE,
82: PROCESS_TYPE qp_interface_qualifiers.process_type%TYPE,
83: EXCLUDER_FLAG qp_interface_qualifiers.excluder_flag%TYPE,

Line 80: QUALIFIER_ATTR_VALUE qp_interface_qualifiers.qualifier_attr_value%TYPE,

76:
77: TYPE qp_qualifier_rec IS RECORD (
78: PROCESS_ID qp_interface_qualifiers.process_id%TYPE,
79: INTERFACE_ACTION_CODE qp_interface_qualifiers.interface_action_code%TYPE,
80: QUALIFIER_ATTR_VALUE qp_interface_qualifiers.qualifier_attr_value%TYPE,
81: QUALIFIER_GROUPING_NO qp_interface_qualifiers.qualifier_grouping_no%TYPE,
82: PROCESS_TYPE qp_interface_qualifiers.process_type%TYPE,
83: EXCLUDER_FLAG qp_interface_qualifiers.excluder_flag%TYPE,
84: COMPARISON_OPERATOR_CODE qp_interface_qualifiers.comparison_operator_code%TYPE,

Line 81: QUALIFIER_GROUPING_NO qp_interface_qualifiers.qualifier_grouping_no%TYPE,

77: TYPE qp_qualifier_rec IS RECORD (
78: PROCESS_ID qp_interface_qualifiers.process_id%TYPE,
79: INTERFACE_ACTION_CODE qp_interface_qualifiers.interface_action_code%TYPE,
80: QUALIFIER_ATTR_VALUE qp_interface_qualifiers.qualifier_attr_value%TYPE,
81: QUALIFIER_GROUPING_NO qp_interface_qualifiers.qualifier_grouping_no%TYPE,
82: PROCESS_TYPE qp_interface_qualifiers.process_type%TYPE,
83: EXCLUDER_FLAG qp_interface_qualifiers.excluder_flag%TYPE,
84: COMPARISON_OPERATOR_CODE qp_interface_qualifiers.comparison_operator_code%TYPE,
85: QUALIFIER_CONTEXT qp_interface_qualifiers.qualifier_context%TYPE,

Line 82: PROCESS_TYPE qp_interface_qualifiers.process_type%TYPE,

78: PROCESS_ID qp_interface_qualifiers.process_id%TYPE,
79: INTERFACE_ACTION_CODE qp_interface_qualifiers.interface_action_code%TYPE,
80: QUALIFIER_ATTR_VALUE qp_interface_qualifiers.qualifier_attr_value%TYPE,
81: QUALIFIER_GROUPING_NO qp_interface_qualifiers.qualifier_grouping_no%TYPE,
82: PROCESS_TYPE qp_interface_qualifiers.process_type%TYPE,
83: EXCLUDER_FLAG qp_interface_qualifiers.excluder_flag%TYPE,
84: COMPARISON_OPERATOR_CODE qp_interface_qualifiers.comparison_operator_code%TYPE,
85: QUALIFIER_CONTEXT qp_interface_qualifiers.qualifier_context%TYPE,
86: QUALIFIER_ATTRIBUTE qp_interface_qualifiers.qualifier_attribute%TYPE);

Line 83: EXCLUDER_FLAG qp_interface_qualifiers.excluder_flag%TYPE,

79: INTERFACE_ACTION_CODE qp_interface_qualifiers.interface_action_code%TYPE,
80: QUALIFIER_ATTR_VALUE qp_interface_qualifiers.qualifier_attr_value%TYPE,
81: QUALIFIER_GROUPING_NO qp_interface_qualifiers.qualifier_grouping_no%TYPE,
82: PROCESS_TYPE qp_interface_qualifiers.process_type%TYPE,
83: EXCLUDER_FLAG qp_interface_qualifiers.excluder_flag%TYPE,
84: COMPARISON_OPERATOR_CODE qp_interface_qualifiers.comparison_operator_code%TYPE,
85: QUALIFIER_CONTEXT qp_interface_qualifiers.qualifier_context%TYPE,
86: QUALIFIER_ATTRIBUTE qp_interface_qualifiers.qualifier_attribute%TYPE);
87:

Line 84: COMPARISON_OPERATOR_CODE qp_interface_qualifiers.comparison_operator_code%TYPE,

80: QUALIFIER_ATTR_VALUE qp_interface_qualifiers.qualifier_attr_value%TYPE,
81: QUALIFIER_GROUPING_NO qp_interface_qualifiers.qualifier_grouping_no%TYPE,
82: PROCESS_TYPE qp_interface_qualifiers.process_type%TYPE,
83: EXCLUDER_FLAG qp_interface_qualifiers.excluder_flag%TYPE,
84: COMPARISON_OPERATOR_CODE qp_interface_qualifiers.comparison_operator_code%TYPE,
85: QUALIFIER_CONTEXT qp_interface_qualifiers.qualifier_context%TYPE,
86: QUALIFIER_ATTRIBUTE qp_interface_qualifiers.qualifier_attribute%TYPE);
87:
88: TYPE qp_qualifier_tbl IS TABLE OF

Line 85: QUALIFIER_CONTEXT qp_interface_qualifiers.qualifier_context%TYPE,

81: QUALIFIER_GROUPING_NO qp_interface_qualifiers.qualifier_grouping_no%TYPE,
82: PROCESS_TYPE qp_interface_qualifiers.process_type%TYPE,
83: EXCLUDER_FLAG qp_interface_qualifiers.excluder_flag%TYPE,
84: COMPARISON_OPERATOR_CODE qp_interface_qualifiers.comparison_operator_code%TYPE,
85: QUALIFIER_CONTEXT qp_interface_qualifiers.qualifier_context%TYPE,
86: QUALIFIER_ATTRIBUTE qp_interface_qualifiers.qualifier_attribute%TYPE);
87:
88: TYPE qp_qualifier_tbl IS TABLE OF
89: qp_qualifier_rec

Line 86: QUALIFIER_ATTRIBUTE qp_interface_qualifiers.qualifier_attribute%TYPE);

82: PROCESS_TYPE qp_interface_qualifiers.process_type%TYPE,
83: EXCLUDER_FLAG qp_interface_qualifiers.excluder_flag%TYPE,
84: COMPARISON_OPERATOR_CODE qp_interface_qualifiers.comparison_operator_code%TYPE,
85: QUALIFIER_CONTEXT qp_interface_qualifiers.qualifier_context%TYPE,
86: QUALIFIER_ATTRIBUTE qp_interface_qualifiers.qualifier_attribute%TYPE);
87:
88: TYPE qp_qualifier_tbl IS TABLE OF
89: qp_qualifier_rec
90: 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