APPS.GL_DRM_INTEGRATION_PKG dependencies on FND_FLEX_VALIDATION_QUALIFIERS

Line 13: TYPE flex_vl_attr_tbl_type IS TABLE OF fnd_flex_validation_qualifiers%ROWTYPE INDEX BY BINARY_INTEGER;

9: g_flex_values_tbl GL_COA_SEG_VAL_IMP_PUB.gl_flex_values_tbl_type;
10: g_norm_hierarchy_tbl GL_COA_SEG_VAL_IMP_PUB.gl_flex_values_nh_tbl_type;
11:
12: -- type and table used for validating qualifiers
13: TYPE flex_vl_attr_tbl_type IS TABLE OF fnd_flex_validation_qualifiers%ROWTYPE INDEX BY BINARY_INTEGER;
14: g_list_flex_vl_attr flex_vl_attr_tbl_type;
15:
16: -- Constants used for writing XML to ouput file
17: XML_TAG_OPEN CONSTANT NUMBER(1) := 1;

Line 534: FROM fnd_flex_validation_qualifiers fvq

530: -- cursor to fetch attribute properties for a value set
531: CURSOR c_flex_val_attributes(p_value_set_id NUMBER)
532: IS
533: SELECT fvq.*
534: FROM fnd_flex_validation_qualifiers fvq
535: WHERE flex_value_set_id = p_value_set_id
536: ORDER BY assignment_date, value_attribute_type;
537:
538:

Line 1225: cp_id_flex_code IN fnd_flex_validation_qualifiers.id_flex_code%TYPE,

1221:
1222: /* cursor to fetch assigned segment qualifiers for a given value set */
1223: CURSOR c_flex_val_qual (
1224: cp_flex_value_set_id IN fnd_flex_hierarchies.flex_value_set_id%TYPE,
1225: cp_id_flex_code IN fnd_flex_validation_qualifiers.id_flex_code%TYPE,
1226: cp_id_flex_application_id IN fnd_flex_validation_qualifiers.id_flex_application_id%TYPE)
1227: IS
1228: SELECT
1229: segment_attribute_type,

Line 1226: cp_id_flex_application_id IN fnd_flex_validation_qualifiers.id_flex_application_id%TYPE)

1222: /* cursor to fetch assigned segment qualifiers for a given value set */
1223: CURSOR c_flex_val_qual (
1224: cp_flex_value_set_id IN fnd_flex_hierarchies.flex_value_set_id%TYPE,
1225: cp_id_flex_code IN fnd_flex_validation_qualifiers.id_flex_code%TYPE,
1226: cp_id_flex_application_id IN fnd_flex_validation_qualifiers.id_flex_application_id%TYPE)
1227: IS
1228: SELECT
1229: segment_attribute_type,
1230: value_attribute_type

Line 1231: FROM fnd_flex_validation_qualifiers

1227: IS
1228: SELECT
1229: segment_attribute_type,
1230: value_attribute_type
1231: FROM fnd_flex_validation_qualifiers
1232: WHERE id_flex_code = cp_id_flex_code
1233: AND id_flex_application_id = cp_id_flex_application_id
1234: AND flex_value_set_id = cp_flex_value_set_id
1235: ORDER BY assignment_date, value_attribute_type;

Line 1402: FROM fnd_flex_validation_qualifiers vq

1398: FROM fnd_flex_value_sets vs
1399: WHERE vs.flex_value_set_id = l_value_set_details.flex_value_set_id
1400: AND EXISTS
1401: (SELECT 'X'
1402: FROM fnd_flex_validation_qualifiers vq
1403: WHERE vq.id_flex_code = 'GL#'
1404: AND vq.id_flex_application_id = 101
1405: AND vq.flex_value_set_id = vs.flex_value_set_id
1406: AND vq.segment_attribute_type = 'GL_ACCOUNT');