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.FND_FLEX_VAL_API dependencies on FND_FLEX_VALIDATION_TABLES

Line 723: fnd_flex_validation_tables.enabled_column_name%TYPE;

719: creation_date fnd_flex_value_sets.creation_date%TYPE;
720: created_by fnd_flex_value_sets.created_by%TYPE;
721:
722: enabled_column_name
723: fnd_flex_validation_tables.enabled_column_name%TYPE;
724: hierarchy_level_column_name
725: fnd_flex_validation_tables.hierarchy_level_column_name%TYPE;
726: start_date_column_name
727: fnd_flex_validation_tables.start_date_column_name%TYPE;

Line 725: fnd_flex_validation_tables.hierarchy_level_column_name%TYPE;

721:
722: enabled_column_name
723: fnd_flex_validation_tables.enabled_column_name%TYPE;
724: hierarchy_level_column_name
725: fnd_flex_validation_tables.hierarchy_level_column_name%TYPE;
726: start_date_column_name
727: fnd_flex_validation_tables.start_date_column_name%TYPE;
728: end_date_column_name
729: fnd_flex_validation_tables.end_date_column_name%TYPE;

Line 727: fnd_flex_validation_tables.start_date_column_name%TYPE;

723: fnd_flex_validation_tables.enabled_column_name%TYPE;
724: hierarchy_level_column_name
725: fnd_flex_validation_tables.hierarchy_level_column_name%TYPE;
726: start_date_column_name
727: fnd_flex_validation_tables.start_date_column_name%TYPE;
728: end_date_column_name
729: fnd_flex_validation_tables.end_date_column_name%TYPE;
730: summary_column_name
731: fnd_flex_validation_tables.summary_column_name%TYPE;

Line 729: fnd_flex_validation_tables.end_date_column_name%TYPE;

725: fnd_flex_validation_tables.hierarchy_level_column_name%TYPE;
726: start_date_column_name
727: fnd_flex_validation_tables.start_date_column_name%TYPE;
728: end_date_column_name
729: fnd_flex_validation_tables.end_date_column_name%TYPE;
730: summary_column_name
731: fnd_flex_validation_tables.summary_column_name%TYPE;
732: compiled_attribute_column_name
733: fnd_flex_validation_tables.compiled_attribute_column_name%TYPE;

Line 731: fnd_flex_validation_tables.summary_column_name%TYPE;

727: fnd_flex_validation_tables.start_date_column_name%TYPE;
728: end_date_column_name
729: fnd_flex_validation_tables.end_date_column_name%TYPE;
730: summary_column_name
731: fnd_flex_validation_tables.summary_column_name%TYPE;
732: compiled_attribute_column_name
733: fnd_flex_validation_tables.compiled_attribute_column_name%TYPE;
734: BEGIN
735: last_update_login := last_update_login_f();

Line 733: fnd_flex_validation_tables.compiled_attribute_column_name%TYPE;

729: fnd_flex_validation_tables.end_date_column_name%TYPE;
730: summary_column_name
731: fnd_flex_validation_tables.summary_column_name%TYPE;
732: compiled_attribute_column_name
733: fnd_flex_validation_tables.compiled_attribute_column_name%TYPE;
734: BEGIN
735: last_update_login := last_update_login_f();
736: last_update_date := last_update_date_f();
737: last_updated_by := last_updated_by_f();

Line 757: fnd_flex_validation_tables(flex_value_set_id,

753: summary_column_name => summary_column_name,
754: compiled_attribute_column_name => compiled_attribute_column_name);
755: INSERT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
756: INTO
757: fnd_flex_validation_tables(flex_value_set_id,
758: application_table_name,
759: value_column_name,
760: value_column_type,
761: value_column_size,

Line 1479: FROM fnd_flex_validation_tables

1475: --
1476: -- Delete Table Validated Value set.
1477: --
1478: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1479: FROM fnd_flex_validation_tables
1480: WHERE flex_value_set_id = l_value_set_id;
1481:
1482: --
1483: -- Delete Special Value set.

Line 1612: fnd_flex_validation_tables SET

1608:
1609: /* update fk references */
1610: BEGIN
1611: UPDATE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1612: fnd_flex_validation_tables SET
1613: flex_value_set_id = old_value_set_id
1614: WHERE flex_value_set_id = new_value_set_id;
1615: EXCEPTION
1616: WHEN no_data_found THEN NULL;

Line 1787: table_r fnd_flex_validation_tables%ROWTYPE;

1783: -- or if type is date or if either size is null.
1784:
1785: PROCEDURE crosscheck_size(valueset_r IN fnd_flex_value_sets%ROWTYPE)
1786: IS
1787: table_r fnd_flex_validation_tables%ROWTYPE;
1788: BEGIN
1789: IF(valueset_r.validation_type = 'F') THEN
1790: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1791: *

Line 1793: FROM fnd_flex_validation_tables

1789: IF(valueset_r.validation_type = 'F') THEN
1790: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1791: *
1792: INTO table_r
1793: FROM fnd_flex_validation_tables
1794: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1795:
1796: IF((valueset_r.validation_type = 'F') AND
1797: (table_r.value_column_type <> 'D') AND

Line 1803: fnd_flex_validation_tables SET

1799: (table_r.value_column_size IS NOT NULL) AND
1800: (valueset_r.maximum_size > table_r.value_column_size))
1801: THEN
1802: UPDATE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1803: fnd_flex_validation_tables SET
1804: value_column_size = valueset_r.maximum_size
1805: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1806: println('increasing value column size');
1807: END IF;

Line 1833: table_r IN fnd_flex_validation_tables%ROWTYPE);

1829: END check_precision;
1830:
1831:
1832: PROCEDURE check_id_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1833: table_r IN fnd_flex_validation_tables%ROWTYPE);
1834:
1835: PROCEDURE check_meaning_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1836: table_r IN fnd_flex_validation_tables%ROWTYPE);
1837:

Line 1836: table_r IN fnd_flex_validation_tables%ROWTYPE);

1832: PROCEDURE check_id_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1833: table_r IN fnd_flex_validation_tables%ROWTYPE);
1834:
1835: PROCEDURE check_meaning_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1836: table_r IN fnd_flex_validation_tables%ROWTYPE);
1837:
1838:
1839: PROCEDURE update_table_sizes(
1840: value_set_name IN VARCHAR2,

Line 1841: id_size IN fnd_flex_validation_tables.id_column_size%TYPE

1837:
1838:
1839: PROCEDURE update_table_sizes(
1840: value_set_name IN VARCHAR2,
1841: id_size IN fnd_flex_validation_tables.id_column_size%TYPE
1842: DEFAULT NULL,
1843: value_size IN fnd_flex_validation_tables.value_column_size%TYPE
1844: DEFAULT NULL,
1845: meaning_size IN fnd_flex_validation_tables.meaning_column_size%TYPE

Line 1843: value_size IN fnd_flex_validation_tables.value_column_size%TYPE

1839: PROCEDURE update_table_sizes(
1840: value_set_name IN VARCHAR2,
1841: id_size IN fnd_flex_validation_tables.id_column_size%TYPE
1842: DEFAULT NULL,
1843: value_size IN fnd_flex_validation_tables.value_column_size%TYPE
1844: DEFAULT NULL,
1845: meaning_size IN fnd_flex_validation_tables.meaning_column_size%TYPE
1846: DEFAULT NULL)
1847: IS

Line 1845: meaning_size IN fnd_flex_validation_tables.meaning_column_size%TYPE

1841: id_size IN fnd_flex_validation_tables.id_column_size%TYPE
1842: DEFAULT NULL,
1843: value_size IN fnd_flex_validation_tables.value_column_size%TYPE
1844: DEFAULT NULL,
1845: meaning_size IN fnd_flex_validation_tables.meaning_column_size%TYPE
1846: DEFAULT NULL)
1847: IS
1848: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1849: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;

Line 1853: table_r fnd_flex_validation_tables%ROWTYPE;

1849: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1850: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1851:
1852: valueset_r fnd_flex_value_sets%ROWTYPE;
1853: table_r fnd_flex_validation_tables%ROWTYPE;
1854: BEGIN
1855: last_update_login_i := last_update_login_f();
1856: last_update_date_i := last_update_date_f();
1857: last_updated_by_i := last_updated_by_f();

Line 1879: FROM fnd_flex_validation_tables

1875: BEGIN
1876: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1877: *
1878: INTO table_r
1879: FROM fnd_flex_validation_tables
1880: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1881: EXCEPTION
1882: WHEN no_data_found THEN
1883: message('internal inconsistency - could not locate table' ||

Line 1908: fnd_flex_validation_tables SET

1904:
1905: BEGIN
1906: IF(customer_mode) THEN
1907: UPDATE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1908: fnd_flex_validation_tables SET
1909: id_column_size = table_r.id_column_size,
1910: -- value_column_size = table_r.value_column_size,
1911: meaning_column_size = table_r.meaning_column_size,
1912: last_update_date = last_update_date_i,

Line 1918: fnd_flex_validation_tables SET

1914: last_update_login = last_update_login_i
1915: WHERE flex_value_set_id = table_r.flex_value_set_id;
1916: ELSE
1917: UPDATE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1918: fnd_flex_validation_tables SET
1919: id_column_size = table_r.id_column_size,
1920: -- value_column_size = table_r.value_column_size,
1921: meaning_column_size = table_r.meaning_column_size
1922: WHERE flex_value_set_id = table_r.flex_value_set_id;

Line 1926: message('error updating fnd_flex_validation_tables: ' || Sqlerrm);

1922: WHERE flex_value_set_id = table_r.flex_value_set_id;
1923: END IF;
1924: EXCEPTION
1925: WHEN OTHERS THEN
1926: message('error updating fnd_flex_validation_tables: ' || Sqlerrm);
1927: RAISE;
1928: END;
1929: EXCEPTION
1930: WHEN OTHERS THEN

Line 1937: table_r IN fnd_flex_validation_tables%ROWTYPE)

1933: END update_table_sizes;
1934:
1935:
1936: PROCEDURE check_id_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1937: table_r IN fnd_flex_validation_tables%ROWTYPE)
1938: IS
1939: width_i NUMBER;
1940: BEGIN
1941: BEGIN

Line 1969: table_r IN fnd_flex_validation_tables%ROWTYPE)

1965: RAISE;
1966: END;
1967:
1968: PROCEDURE check_meaning_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1969: table_r IN fnd_flex_validation_tables%ROWTYPE)
1970: IS
1971: width_i NUMBER;
1972: BEGIN
1973: BEGIN

Line 2059: l_tvset fnd_flex_validation_tables%ROWTYPE;

2055: x_success OUT nocopy NUMBER)
2056: IS
2057: l_func_name VARCHAR2(100);
2058: l_vset fnd_flex_value_sets%ROWTYPE;
2059: l_tvset fnd_flex_validation_tables%ROWTYPE;
2060:
2061: l_and VARCHAR2(10);
2062: l_select VARCHAR2(32000);
2063: l_inc_addtl_where_clause VARCHAR2(1);

Line 2125: FROM fnd_flex_validation_tables

2121: BEGIN
2122: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
2123: *
2124: INTO l_tvset
2125: FROM fnd_flex_validation_tables
2126: WHERE flex_value_set_id = l_vset.flex_value_set_id;
2127: EXCEPTION
2128: WHEN no_data_found THEN
2129: message(l_func_name || 'Table Info does not exist.');

Line 2133: message(l_func_name || 'SELECT FROM fnd_flex_validation_tables '||

2129: message(l_func_name || 'Table Info does not exist.');
2130: x_success := g_ret_no_table_info;
2131: RETURN;
2132: WHEN OTHERS THEN
2133: message(l_func_name || 'SELECT FROM fnd_flex_validation_tables '||
2134: 'is failed.' || chr_newline || 'Error : ' || Sqlerrm);
2135: x_success := g_ret_others;
2136: RETURN;
2137: END;

Line 2544: FROM fnd_flex_value_sets fvs, fnd_flex_validation_tables fvt

2540: x_message := 'This table is not used by Flexfield Value Sets';
2541: BEGIN
2542: SELECT fvs.flex_value_set_name
2543: INTO l_vset_name
2544: FROM fnd_flex_value_sets fvs, fnd_flex_validation_tables fvt
2545: WHERE fvs.validation_type = 'F'
2546: AND fvs.flex_value_set_id = fvt.flex_value_set_id
2547: AND Nvl(fvt.table_application_id, p_application_id) = p_application_id
2548: AND (Upper(fvt.application_table_name) = up_table_name OR

Line 2562: 'SELECT FROM FND_FLEX_VALIDATION_TABLES is failed. '||chr_newline||

2558: WHEN no_data_found THEN
2559: NULL;
2560: WHEN OTHERS THEN
2561: x_message :=
2562: 'SELECT FROM FND_FLEX_VALIDATION_TABLES is failed. '||chr_newline||
2563: 'SQLERRM : ' || Sqlerrm;
2564: RETURN(TRUE);
2565: END;
2566: RETURN(FALSE);

Line 2593: FROM fnd_flex_value_sets fvs, fnd_flex_validation_tables fvt

2589: BEGIN
2590: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
2591: fvs.flex_value_set_name
2592: INTO l_vset_name
2593: FROM fnd_flex_value_sets fvs, fnd_flex_validation_tables fvt
2594: WHERE fvs.validation_type = 'F'
2595: AND fvs.flex_value_set_id = fvt.flex_value_set_id
2596: AND Nvl(fvt.table_application_id, p_application_id) = p_application_id
2597: AND (Upper(fvt.application_table_name) = up_table_name OR

Line 2629: 'SELECT FROM FND_FLEX_VALIDATION_TABLES is failed. '||chr_newline||

2625: WHEN no_data_found THEN
2626: NULL;
2627: WHEN OTHERS THEN
2628: x_message :=
2629: 'SELECT FROM FND_FLEX_VALIDATION_TABLES is failed. '||chr_newline||
2630: 'SQLERRM : ' || Sqlerrm;
2631: RETURN(TRUE);
2632: END;
2633: RETURN(FALSE);

Line 3712: fnd_flex_validation_tables t

3708: l_number_precision, l_flex_value_set_name,
3709: l_id_column_name, l_id_column_type, l_id_column_size
3710: FROM
3711: fnd_flex_value_sets v,
3712: fnd_flex_validation_tables t
3713: WHERE
3714: v.flex_value_set_id = p_value_set_id and
3715: v.flex_value_set_id = t.flex_value_set_id(+);
3716:

Line 3726: fnd_flex_validation_tables t,

3722: INTO
3723: l_column_type, l_appl_col_size
3724: FROM
3725: fnd_flex_value_sets v,
3726: fnd_flex_validation_tables t,
3727: fnd_columns c, fnd_tables tb
3728: WHERE
3729: v.flex_value_set_id = p_value_set_id and
3730: v.flex_value_set_id = t.flex_value_set_id(+) and

Line 4068: p_id_column_type IN fnd_flex_validation_tables.id_column_type%TYPE,

4064:
4065: PROCEDURE check_base_table_column(
4066: p_application_column_type IN fnd_columns.column_type%TYPE,
4067: p_application_column_size IN fnd_columns.width%TYPE,
4068: p_id_column_type IN fnd_flex_validation_tables.id_column_type%TYPE,
4069: p_id_column_size IN fnd_flex_validation_tables.id_column_size%TYPE,
4070: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,
4071: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4072: p_maximum_size IN fnd_flex_value_sets.maximum_size%TYPE,

Line 4069: p_id_column_size IN fnd_flex_validation_tables.id_column_size%TYPE,

4065: PROCEDURE check_base_table_column(
4066: p_application_column_type IN fnd_columns.column_type%TYPE,
4067: p_application_column_size IN fnd_columns.width%TYPE,
4068: p_id_column_type IN fnd_flex_validation_tables.id_column_type%TYPE,
4069: p_id_column_size IN fnd_flex_validation_tables.id_column_size%TYPE,
4070: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,
4071: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4072: p_maximum_size IN fnd_flex_value_sets.maximum_size%TYPE,
4073: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,

Line 4288: fnd_flex_validation_tables t

4284: l_flex_value_set_name, l_id_column_type,
4285: l_id_column_size
4286: FROM
4287: fnd_flex_value_sets v,
4288: fnd_flex_validation_tables t
4289: WHERE
4290: v.flex_value_set_id = p_flex_value_set_id and
4291: v.flex_value_set_id = t.flex_value_set_id(+);
4292:

Line 4456: fnd_flex_validation_tables t

4452: l_number_precision, l_flex_value_set_name,
4453: l_id_column_name, l_id_column_type, l_id_column_size
4454: FROM
4455: fnd_flex_value_sets v,
4456: fnd_flex_validation_tables t
4457: WHERE
4458: v.flex_value_set_id = p_flex_value_set_id and
4459: v.flex_value_set_id = t.flex_value_set_id(+);
4460:

Line 4822: p_id_column_name IN fnd_flex_validation_tables.id_column_name%TYPE,

4818:
4819:
4820: PROCEDURE validate_table_vset(
4821: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4822: p_id_column_name IN fnd_flex_validation_tables.id_column_name%TYPE,
4823: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,
4824: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,
4825: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,
4826: p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,

Line 4823: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,

4819:
4820: PROCEDURE validate_table_vset(
4821: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4822: p_id_column_name IN fnd_flex_validation_tables.id_column_name%TYPE,
4823: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,
4824: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,
4825: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,
4826: p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,
4827: p_additional_where_clause IN fnd_flex_validation_tables.additional_where_clause%TYPE,

Line 4824: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,

4820: PROCEDURE validate_table_vset(
4821: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4822: p_id_column_name IN fnd_flex_validation_tables.id_column_name%TYPE,
4823: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,
4824: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,
4825: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,
4826: p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,
4827: p_additional_where_clause IN fnd_flex_validation_tables.additional_where_clause%TYPE,
4828: x_result OUT NOCOPY VARCHAR2,

Line 4825: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,

4821: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4822: p_id_column_name IN fnd_flex_validation_tables.id_column_name%TYPE,
4823: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,
4824: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,
4825: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,
4826: p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,
4827: p_additional_where_clause IN fnd_flex_validation_tables.additional_where_clause%TYPE,
4828: x_result OUT NOCOPY VARCHAR2,
4829: x_message OUT NOCOPY VARCHAR2)

Line 4826: p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,

4822: p_id_column_name IN fnd_flex_validation_tables.id_column_name%TYPE,
4823: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,
4824: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,
4825: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,
4826: p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,
4827: p_additional_where_clause IN fnd_flex_validation_tables.additional_where_clause%TYPE,
4828: x_result OUT NOCOPY VARCHAR2,
4829: x_message OUT NOCOPY VARCHAR2)
4830: IS

Line 4827: p_additional_where_clause IN fnd_flex_validation_tables.additional_where_clause%TYPE,

4823: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,
4824: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,
4825: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,
4826: p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,
4827: p_additional_where_clause IN fnd_flex_validation_tables.additional_where_clause%TYPE,
4828: x_result OUT NOCOPY VARCHAR2,
4829: x_message OUT NOCOPY VARCHAR2)
4830: IS
4831: l_stmt VARCHAR2(32000);

Line 4835: l_tmpaddlclmn fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

4831: l_stmt VARCHAR2(32000);
4832: l_stmt1 VARCHAR2(32000);
4833: l_message VARCHAR(32000);
4834: l_cur_hdl INTEGER;
4835: l_tmpaddlclmn fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4836: l_tmpaddlclmnfrmt fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4837: l_double_quote varchar2(3);
4838: l_appl_string varchar2(10);
4839: l_star varchar2(2);

Line 4836: l_tmpaddlclmnfrmt fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

4832: l_stmt1 VARCHAR2(32000);
4833: l_message VARCHAR(32000);
4834: l_cur_hdl INTEGER;
4835: l_tmpaddlclmn fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4836: l_tmpaddlclmnfrmt fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4837: l_double_quote varchar2(3);
4838: l_appl_string varchar2(10);
4839: l_star varchar2(2);
4840: l_name_string varchar2(10);

Line 4843: l_additional_column_width1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

4839: l_star varchar2(2);
4840: l_name_string varchar2(10);
4841: l_open_bracket varchar2(3);
4842: l_close_bracket varchar2(3);
4843: l_additional_column_width1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4844: l_additional_column_width2 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4845: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
4846: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
4847: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;

Line 4844: l_additional_column_width2 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

4840: l_name_string varchar2(10);
4841: l_open_bracket varchar2(3);
4842: l_close_bracket varchar2(3);
4843: l_additional_column_width1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4844: l_additional_column_width2 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4845: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
4846: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
4847: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
4848: l_additional_column_width3 varchar2(20);

Line 4845: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

4841: l_open_bracket varchar2(3);
4842: l_close_bracket varchar2(3);
4843: l_additional_column_width1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4844: l_additional_column_width2 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4845: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
4846: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
4847: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
4848: l_additional_column_width3 varchar2(20);
4849: l_position1_double_quote number;

Line 4846: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;

4842: l_close_bracket varchar2(3);
4843: l_additional_column_width1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4844: l_additional_column_width2 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4845: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
4846: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
4847: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
4848: l_additional_column_width3 varchar2(20);
4849: l_position1_double_quote number;
4850: l_position2_double_quote number;

Line 4847: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;

4843: l_additional_column_width1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4844: l_additional_column_width2 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4845: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
4846: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
4847: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
4848: l_additional_column_width3 varchar2(20);
4849: l_position1_double_quote number;
4850: l_position2_double_quote number;
4851: l_position_open_bracket number;

Line 4860: l_tmpaddlclmn1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

4856: NEWLINE VARCHAR2(4);
4857: WHITESPACE VARCHAR2(4);
4858: COMMA VARCHAR2(1);
4859: l_into varchar2_array_type;
4860: l_tmpaddlclmn1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4861: l_tmpaddlclmn_no_into fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4862: l_char varchar2(4);
4863: l_position number;
4864: l_into_begin number;

Line 4861: l_tmpaddlclmn_no_into fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

4857: WHITESPACE VARCHAR2(4);
4858: COMMA VARCHAR2(1);
4859: l_into varchar2_array_type;
4860: l_tmpaddlclmn1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4861: l_tmpaddlclmn_no_into fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4862: l_char varchar2(4);
4863: l_position number;
4864: l_into_begin number;
4865: l_into_end number;

Line 4868: l_ltrim_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

4864: l_into_begin number;
4865: l_into_end number;
4866: l_where varchar2(10);
4867: l_orderby varchar2(10);
4868: l_ltrim_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
4869:
4870: BEGIN
4871:
4872: l_double_quote := '"';