DBA Data[Home] [Help]

APPS.CZ_LOGIC_GEN dependencies on CZ_LCE_COMPAT_REC_TYPE

Line 6405: CREATE OR REPLACE TYPE cz_lce_compat_rec_type IS OBJECT (option_a NUMBER, option_b NUMBER);

6401: v_rel VARCHAR2(1);
6402: v_group_by_set_mask_a tVarcharTable;
6403: v_group_by_set_mask_b tVarcharTable;
6404: /*-------------------------------------------------------------------------------------
6405: CREATE OR REPLACE TYPE cz_lce_compat_rec_type IS OBJECT (option_a NUMBER, option_b NUMBER);
6406: CREATE OR REPLACE TYPE cz_lce_compat_tab_type IS TABLE OF cz_lce_compat_rec_type;
6407: ---------------------------------------------------------------------------------------*/
6408: FUNCTION get_feature_minimum(p_feature_id IN NUMBER) RETURN PLS_INTEGER IS
6409: v_idx NUMBER; --kdande; Bug 6881902; 11-Mar-2008

Line 6406: CREATE OR REPLACE TYPE cz_lce_compat_tab_type IS TABLE OF cz_lce_compat_rec_type;

6402: v_group_by_set_mask_a tVarcharTable;
6403: v_group_by_set_mask_b tVarcharTable;
6404: /*-------------------------------------------------------------------------------------
6405: CREATE OR REPLACE TYPE cz_lce_compat_rec_type IS OBJECT (option_a NUMBER, option_b NUMBER);
6406: CREATE OR REPLACE TYPE cz_lce_compat_tab_type IS TABLE OF cz_lce_compat_rec_type;
6407: ---------------------------------------------------------------------------------------*/
6408: FUNCTION get_feature_minimum(p_feature_id IN NUMBER) RETURN PLS_INTEGER IS
6409: v_idx NUMBER; --kdande; Bug 6881902; 11-Mar-2008
6410: v_min NUMBER; --kdande; Bug 6881902; 11-Mar-2008

Line 6490: v_options(rowThreshold + i) := SYSTEM.cz_lce_compat_rec_type(v_option_a(i), v_option_b(i));

6486: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, v_option_b);
6487: nDebug := 8000002;
6488: FOR i IN 1..localNumber LOOP
6489: v_options.EXTEND();
6490: v_options(rowThreshold + i) := SYSTEM.cz_lce_compat_rec_type(v_option_a(i), v_option_b(i));
6491: nDebug := 8000003;
6492: --These arrays store 'bit positions' for every a or b option. Later they will be used in construction
6493: --of the 'bit masks' for compatibility groups and sets.
6494: --The 'inv' arrays allow to quickly get an option_id by its bit position.