DBA Data[Home] [Help]

APPS.EGO_VS_BULKLOAD_PVT dependencies on EGO_VS_VALUES_DISP_ORDER

Line 2804: FROM ego_vs_values_disp_order

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:

Line 7265: FROM ego_vs_values_disp_order

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.

Line 7275: FROM Ego_VS_Values_Disp_Order

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 );

Line 9115: FROM ego_vs_values_disp_order

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.

Line 9125: FROM Ego_VS_Values_Disp_Order

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);

Line 10665: FROM Ego_VS_Values_Disp_Order

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: