eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_CHART_OF_ACCOUNTS_API_PKG dependencies on FND_FLEX_VALIDATION_QUALIFIERS

Line 1110: -- (FND_FLEX_VALIDATION_QUALIFIERS table)

1106: -- Procedure
1107: -- validate_validation_qualifier
1108: -- Purpose
1109: -- Do the validation for one particular validation qualifier
1110: -- (FND_FLEX_VALIDATION_QUALIFIERS table)
1111: -- History
1112: -- 10.09.2000 O Monnier Created.
1113: --
1114: PROCEDURE validate_validation_qualifier(v_id_flex_application_id IN NUMBER,

Line 1139: FROM FND_FLEX_VALIDATION_QUALIFIERS

1135: -- Cursor to check if the assignment dates for the GL Accounting
1136: -- Flexfield qualifiers are in the right order.
1137: CURSOR c_check_date_detail_budgeting IS
1138: SELECT value_attribute_type, assignment_date
1139: FROM FND_FLEX_VALIDATION_QUALIFIERS
1140: WHERE id_flex_application_id = v_id_flex_application_id
1141: AND id_flex_code = v_id_flex_code
1142: AND flex_value_set_id = v_flex_value_set_id
1143: AND value_attribute_type IN ('DETAIL_POSTING_ALLOWED',

Line 1151: FROM FND_FLEX_VALIDATION_QUALIFIERS

1147: AND assignment_date < v_assignment_date;
1148:
1149: CURSOR c_check_date_detail_posting IS
1150: SELECT value_attribute_type, assignment_date
1151: FROM FND_FLEX_VALIDATION_QUALIFIERS
1152: WHERE id_flex_application_id = v_id_flex_application_id
1153: AND id_flex_code = v_id_flex_code
1154: AND flex_value_set_id = v_flex_value_set_id
1155: AND ((value_attribute_type = 'DETAIL_BUDGETING_ALLOWED'

Line 1165: FROM FND_FLEX_VALIDATION_QUALIFIERS

1161: AND assignment_date < v_assignment_date));
1162:
1163: CURSOR c_check_date_account IS
1164: SELECT value_attribute_type, assignment_date
1165: FROM FND_FLEX_VALIDATION_QUALIFIERS
1166: WHERE id_flex_application_id = v_id_flex_application_id
1167: AND id_flex_code = v_id_flex_code
1168: AND flex_value_set_id = v_flex_value_set_id
1169: AND ((value_attribute_type IN ('DETAIL_BUDGETING_ALLOWED',

Line 1179: FROM FND_FLEX_VALIDATION_QUALIFIERS

1175: AND assignment_date < v_assignment_date));
1176:
1177: CURSOR c_check_date_control IS
1178: SELECT value_attribute_type, assignment_date
1179: FROM FND_FLEX_VALIDATION_QUALIFIERS
1180: WHERE id_flex_application_id = v_id_flex_application_id
1181: AND id_flex_code = v_id_flex_code
1182: AND flex_value_set_id = v_flex_value_set_id
1183: AND value_attribute_type IN ('DETAIL_BUDGETING_ALLOWED',

Line 1191: FROM FND_FLEX_VALIDATION_QUALIFIERS

1187:
1188:
1189: CURSOR c_check_date_reconcilition IS
1190: SELECT value_attribute_type, assignment_date
1191: FROM FND_FLEX_VALIDATION_QUALIFIERS
1192: WHERE id_flex_application_id = v_id_flex_application_id
1193: AND id_flex_code = v_id_flex_code
1194: AND flex_value_set_id = v_flex_value_set_id
1195: AND value_attribute_type IN ('DETAIL_BUDGETING_ALLOWED',

Line 1232: FROM FND_FLEX_VALIDATION_QUALIFIERS

1228: -- DETAIL_BUDGETING_ALLOWED, DETAIL_POSTING_ALLOWED, and GL_ACCOUNT_TYPE
1229: -- GL_CONTROL_ACCOUNT and RECONCILIATION FLAG after.
1230: SELECT assignment_date
1231: INTO v_assignment_date
1232: FROM FND_FLEX_VALIDATION_QUALIFIERS
1233: WHERE id_flex_application_id = v_id_flex_application_id
1234: AND id_flex_code = v_id_flex_code
1235: AND flex_value_set_id = v_flex_value_set_id
1236: AND segment_attribute_type = v_segment_attribute_type

Line 1400: FND_FLEX_VALIDATION_QUALIFIERS fvq

1396: SELECT vat.required_flag AS required_flag,
1397: vat.lookup_type AS lookup_type,
1398: vat.value_attribute_type AS value_attribute_type
1399: FROM FND_VALUE_ATTRIBUTE_TYPES vat,
1400: FND_FLEX_VALIDATION_QUALIFIERS fvq
1401: WHERE fvq.flex_value_set_id = v_flex_value_set_id
1402: AND vat.id_flex_code = fvq.id_flex_code
1403: AND vat.application_id = fvq.id_flex_application_id
1404: AND vat.segment_attribute_type = fvq.segment_attribute_type

Line 1481: FND_FLEX_VALIDATION_QUALIFIERS fvq

1477: -- Retrieve the count of the value attribute types required for the validation.
1478:
1479: SELECT COUNT(*) INTO v_count_value_attribute_types
1480: FROM FND_VALUE_ATTRIBUTE_TYPES vat,
1481: FND_FLEX_VALIDATION_QUALIFIERS fvq
1482: WHERE fvq.flex_value_set_id = v_flex_value_set_id
1483: AND vat.id_flex_code = fvq.id_flex_code
1484: AND vat.application_id = fvq.id_flex_application_id
1485: AND vat.segment_attribute_type = fvq.segment_attribute_type

Line 2076: -- we also need to insert into the FND_FLEX_VALIDATION_QUALIFIERS table,

2072: END IF;
2073:
2074: --
2075: -- After inserting or updating a new segment for the flexfield,
2076: -- we also need to insert into the FND_FLEX_VALIDATION_QUALIFIERS table,
2077: -- if this has not already been done.
2078: --
2079: INSERT INTO fnd_flex_validation_qualifiers( flex_value_set_id,
2080: id_flex_application_id,

Line 2079: INSERT INTO fnd_flex_validation_qualifiers( flex_value_set_id,

2075: -- After inserting or updating a new segment for the flexfield,
2076: -- we also need to insert into the FND_FLEX_VALIDATION_QUALIFIERS table,
2077: -- if this has not already been done.
2078: --
2079: INSERT INTO fnd_flex_validation_qualifiers( flex_value_set_id,
2080: id_flex_application_id,
2081: id_flex_code,
2082: segment_attribute_type,
2083: value_attribute_type,

Line 2109: FROM fnd_flex_validation_qualifiers q

2105: AND sav.id_flex_code = vat.id_flex_code
2106: AND sav.segment_attribute_type = vat.segment_attribute_type
2107: AND NOT EXISTS
2108: (SELECT NULL
2109: FROM fnd_flex_validation_qualifiers q
2110: WHERE q.flex_value_set_id = seg.flex_value_set_id
2111: AND q.id_flex_application_id = v_application_id
2112: AND q.id_flex_code = v_id_flex_code
2113: AND q.segment_attribute_type = sav.segment_attribute_type