[Home] [Help]
2800: -- Cursor to get display sequence.
2801: CURSOR c_get_disp_sequence (cp_flex_value_id IN NUMBER)
2802: IS
2803: SELECT disp_sequence
2804: FROM ego_vs_values_disp_order
2805: WHERE value_set_value_id = cp_flex_value_id
2806: AND value_set_id = p_value_set_id; -- Bug 12394675.
2807:
2808:
7261: -- Cursor to get display sequence.
7262: CURSOR c_get_disp_sequence (cp_flex_value_id IN NUMBER)
7263: IS
7264: SELECT disp_sequence
7265: FROM ego_vs_values_disp_order
7266: WHERE value_set_value_id = cp_flex_value_id;
7267:
7268:
7269: -- Cursor to validate sequnce.
7271: cp_value_id NUMBER,
7272: cp_disp_sequence NUMBER)
7273: IS
7274: SELECT 1 AS Seq_exist
7275: FROM Ego_VS_Values_Disp_Order
7276: WHERE disp_sequence = cp_disp_sequence
7277: AND value_set_id = cp_value_set_id
7278: AND ( value_set_value_id <> cp_value_id
7279: OR cp_value_id IS NULL );
9111: -- Cursor to get display sequence.
9112: CURSOR c_get_disp_sequence (cp_flex_value_id IN NUMBER)
9113: IS
9114: SELECT disp_sequence
9115: FROM ego_vs_values_disp_order
9116: WHERE value_set_value_id = cp_flex_value_id;
9117:
9118:
9119: -- Cursor to validate sequnce.
9121: cp_value_id NUMBER,
9122: cp_disp_sequence NUMBER)
9123: IS
9124: SELECT 1 AS Seq_exist
9125: FROM Ego_VS_Values_Disp_Order
9126: WHERE disp_sequence = cp_disp_sequence
9127: AND value_set_id = cp_value_set_id
9128: AND ( value_set_value_id <> cp_value_id
9129: OR cp_value_id IS NULL);
10661: CURSOR Cur_Valid_Sequence ( cp_value_set_id NUMBER,
10662: cp_value_id NUMBER)
10663: IS
10664: SELECT disp_sequence
10665: FROM Ego_VS_Values_Disp_Order
10666: WHERE value_set_id = cp_value_set_id
10667: AND value_set_value_id = cp_value_id;
10668:
10669: