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 734: fnd_flex_validation_tables.enabled_column_name%TYPE;

730: creation_date fnd_flex_value_sets.creation_date%TYPE;
731: created_by fnd_flex_value_sets.created_by%TYPE;
732:
733: enabled_column_name
734: fnd_flex_validation_tables.enabled_column_name%TYPE;
735: hierarchy_level_column_name
736: fnd_flex_validation_tables.hierarchy_level_column_name%TYPE;
737: start_date_column_name
738: fnd_flex_validation_tables.start_date_column_name%TYPE;

Line 736: fnd_flex_validation_tables.hierarchy_level_column_name%TYPE;

732:
733: enabled_column_name
734: fnd_flex_validation_tables.enabled_column_name%TYPE;
735: hierarchy_level_column_name
736: fnd_flex_validation_tables.hierarchy_level_column_name%TYPE;
737: start_date_column_name
738: fnd_flex_validation_tables.start_date_column_name%TYPE;
739: end_date_column_name
740: fnd_flex_validation_tables.end_date_column_name%TYPE;

Line 738: fnd_flex_validation_tables.start_date_column_name%TYPE;

734: fnd_flex_validation_tables.enabled_column_name%TYPE;
735: hierarchy_level_column_name
736: fnd_flex_validation_tables.hierarchy_level_column_name%TYPE;
737: start_date_column_name
738: fnd_flex_validation_tables.start_date_column_name%TYPE;
739: end_date_column_name
740: fnd_flex_validation_tables.end_date_column_name%TYPE;
741: summary_column_name
742: fnd_flex_validation_tables.summary_column_name%TYPE;

Line 740: fnd_flex_validation_tables.end_date_column_name%TYPE;

736: fnd_flex_validation_tables.hierarchy_level_column_name%TYPE;
737: start_date_column_name
738: fnd_flex_validation_tables.start_date_column_name%TYPE;
739: end_date_column_name
740: fnd_flex_validation_tables.end_date_column_name%TYPE;
741: summary_column_name
742: fnd_flex_validation_tables.summary_column_name%TYPE;
743: compiled_attribute_column_name
744: fnd_flex_validation_tables.compiled_attribute_column_name%TYPE;

Line 742: fnd_flex_validation_tables.summary_column_name%TYPE;

738: fnd_flex_validation_tables.start_date_column_name%TYPE;
739: end_date_column_name
740: fnd_flex_validation_tables.end_date_column_name%TYPE;
741: summary_column_name
742: fnd_flex_validation_tables.summary_column_name%TYPE;
743: compiled_attribute_column_name
744: fnd_flex_validation_tables.compiled_attribute_column_name%TYPE;
745: BEGIN
746: last_update_login := last_update_login_f();

Line 744: fnd_flex_validation_tables.compiled_attribute_column_name%TYPE;

740: fnd_flex_validation_tables.end_date_column_name%TYPE;
741: summary_column_name
742: fnd_flex_validation_tables.summary_column_name%TYPE;
743: compiled_attribute_column_name
744: fnd_flex_validation_tables.compiled_attribute_column_name%TYPE;
745: BEGIN
746: last_update_login := last_update_login_f();
747: last_update_date := last_update_date_f();
748: last_updated_by := last_updated_by_f();

Line 768: fnd_flex_validation_tables(flex_value_set_id,

764: summary_column_name => summary_column_name,
765: compiled_attribute_column_name => compiled_attribute_column_name);
766: INSERT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
767: INTO
768: fnd_flex_validation_tables(flex_value_set_id,
769: application_table_name,
770: value_column_name,
771: value_column_type,
772: value_column_size,

Line 1490: FROM fnd_flex_validation_tables

1486: --
1487: -- Delete Table Validated Value set.
1488: --
1489: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1490: FROM fnd_flex_validation_tables
1491: WHERE flex_value_set_id = l_value_set_id;
1492:
1493: --
1494: -- Delete Special Value set.

Line 1623: fnd_flex_validation_tables SET

1619:
1620: /* update fk references */
1621: BEGIN
1622: UPDATE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1623: fnd_flex_validation_tables SET
1624: flex_value_set_id = old_value_set_id
1625: WHERE flex_value_set_id = new_value_set_id;
1626: EXCEPTION
1627: WHEN no_data_found THEN NULL;

Line 1798: table_r fnd_flex_validation_tables%ROWTYPE;

1794: -- or if type is date or if either size is null.
1795:
1796: PROCEDURE crosscheck_size(valueset_r IN fnd_flex_value_sets%ROWTYPE)
1797: IS
1798: table_r fnd_flex_validation_tables%ROWTYPE;
1799: BEGIN
1800: IF(valueset_r.validation_type = 'F') THEN
1801: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1802: *

Line 1804: FROM fnd_flex_validation_tables

1800: IF(valueset_r.validation_type = 'F') THEN
1801: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1802: *
1803: INTO table_r
1804: FROM fnd_flex_validation_tables
1805: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1806:
1807: IF((valueset_r.validation_type = 'F') AND
1808: (table_r.value_column_type <> 'D') AND

Line 1814: fnd_flex_validation_tables SET

1810: (table_r.value_column_size IS NOT NULL) AND
1811: (valueset_r.maximum_size > table_r.value_column_size))
1812: THEN
1813: UPDATE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1814: fnd_flex_validation_tables SET
1815: value_column_size = valueset_r.maximum_size
1816: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1817: println('increasing value column size');
1818: END IF;

Line 1844: table_r IN fnd_flex_validation_tables%ROWTYPE);

1840: END check_precision;
1841:
1842:
1843: PROCEDURE check_id_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1844: table_r IN fnd_flex_validation_tables%ROWTYPE);
1845:
1846: PROCEDURE check_meaning_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1847: table_r IN fnd_flex_validation_tables%ROWTYPE);
1848:

Line 1847: table_r IN fnd_flex_validation_tables%ROWTYPE);

1843: PROCEDURE check_id_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1844: table_r IN fnd_flex_validation_tables%ROWTYPE);
1845:
1846: PROCEDURE check_meaning_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1847: table_r IN fnd_flex_validation_tables%ROWTYPE);
1848:
1849:
1850: PROCEDURE update_table_sizes(
1851: value_set_name IN VARCHAR2,

Line 1852: id_size IN fnd_flex_validation_tables.id_column_size%TYPE

1848:
1849:
1850: PROCEDURE update_table_sizes(
1851: value_set_name IN VARCHAR2,
1852: id_size IN fnd_flex_validation_tables.id_column_size%TYPE
1853: DEFAULT NULL,
1854: value_size IN fnd_flex_validation_tables.value_column_size%TYPE
1855: DEFAULT NULL,
1856: meaning_size IN fnd_flex_validation_tables.meaning_column_size%TYPE

Line 1854: value_size IN fnd_flex_validation_tables.value_column_size%TYPE

1850: PROCEDURE update_table_sizes(
1851: value_set_name IN VARCHAR2,
1852: id_size IN fnd_flex_validation_tables.id_column_size%TYPE
1853: DEFAULT NULL,
1854: value_size IN fnd_flex_validation_tables.value_column_size%TYPE
1855: DEFAULT NULL,
1856: meaning_size IN fnd_flex_validation_tables.meaning_column_size%TYPE
1857: DEFAULT NULL)
1858: IS

Line 1856: meaning_size IN fnd_flex_validation_tables.meaning_column_size%TYPE

1852: id_size IN fnd_flex_validation_tables.id_column_size%TYPE
1853: DEFAULT NULL,
1854: value_size IN fnd_flex_validation_tables.value_column_size%TYPE
1855: DEFAULT NULL,
1856: meaning_size IN fnd_flex_validation_tables.meaning_column_size%TYPE
1857: DEFAULT NULL)
1858: IS
1859: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1860: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;

Line 1864: table_r fnd_flex_validation_tables%ROWTYPE;

1860: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1861: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1862:
1863: valueset_r fnd_flex_value_sets%ROWTYPE;
1864: table_r fnd_flex_validation_tables%ROWTYPE;
1865: BEGIN
1866: last_update_login_i := last_update_login_f();
1867: last_update_date_i := last_update_date_f();
1868: last_updated_by_i := last_updated_by_f();

Line 1890: FROM fnd_flex_validation_tables

1886: BEGIN
1887: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1888: *
1889: INTO table_r
1890: FROM fnd_flex_validation_tables
1891: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1892: EXCEPTION
1893: WHEN no_data_found THEN
1894: message('internal inconsistency - could not locate table' ||

Line 1919: fnd_flex_validation_tables SET

1915:
1916: BEGIN
1917: IF(customer_mode) THEN
1918: UPDATE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1919: fnd_flex_validation_tables SET
1920: id_column_size = table_r.id_column_size,
1921: -- value_column_size = table_r.value_column_size,
1922: meaning_column_size = table_r.meaning_column_size,
1923: last_update_date = last_update_date_i,

Line 1929: fnd_flex_validation_tables SET

1925: last_update_login = last_update_login_i
1926: WHERE flex_value_set_id = table_r.flex_value_set_id;
1927: ELSE
1928: UPDATE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1929: fnd_flex_validation_tables SET
1930: id_column_size = table_r.id_column_size,
1931: -- value_column_size = table_r.value_column_size,
1932: meaning_column_size = table_r.meaning_column_size
1933: WHERE flex_value_set_id = table_r.flex_value_set_id;

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

1933: WHERE flex_value_set_id = table_r.flex_value_set_id;
1934: END IF;
1935: EXCEPTION
1936: WHEN OTHERS THEN
1937: message('error updating fnd_flex_validation_tables: ' || Sqlerrm);
1938: RAISE;
1939: END;
1940: EXCEPTION
1941: WHEN OTHERS THEN

Line 1948: table_r IN fnd_flex_validation_tables%ROWTYPE)

1944: END update_table_sizes;
1945:
1946:
1947: PROCEDURE check_id_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1948: table_r IN fnd_flex_validation_tables%ROWTYPE)
1949: IS
1950: width_i NUMBER;
1951: BEGIN
1952: BEGIN

Line 1980: table_r IN fnd_flex_validation_tables%ROWTYPE)

1976: RAISE;
1977: END;
1978:
1979: PROCEDURE check_meaning_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1980: table_r IN fnd_flex_validation_tables%ROWTYPE)
1981: IS
1982: width_i NUMBER;
1983: BEGIN
1984: BEGIN

Line 2070: l_tvset fnd_flex_validation_tables%ROWTYPE;

2066: x_success OUT nocopy NUMBER)
2067: IS
2068: l_func_name VARCHAR2(100);
2069: l_vset fnd_flex_value_sets%ROWTYPE;
2070: l_tvset fnd_flex_validation_tables%ROWTYPE;
2071:
2072: l_and VARCHAR2(10);
2073: l_select VARCHAR2(32000);
2074: l_inc_addtl_where_clause VARCHAR2(1);

Line 2136: FROM fnd_flex_validation_tables

2132: BEGIN
2133: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
2134: *
2135: INTO l_tvset
2136: FROM fnd_flex_validation_tables
2137: WHERE flex_value_set_id = l_vset.flex_value_set_id;
2138: EXCEPTION
2139: WHEN no_data_found THEN
2140: message(l_func_name || 'Table Info does not exist.');

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

2140: message(l_func_name || 'Table Info does not exist.');
2141: x_success := g_ret_no_table_info;
2142: RETURN;
2143: WHEN OTHERS THEN
2144: message(l_func_name || 'SELECT FROM fnd_flex_validation_tables '||
2145: 'is failed.' || chr_newline || 'Error : ' || Sqlerrm);
2146: x_success := g_ret_others;
2147: RETURN;
2148: END;

Line 2555: FROM fnd_flex_value_sets fvs, fnd_flex_validation_tables fvt

2551: x_message := 'This table is not used by Flexfield Value Sets';
2552: BEGIN
2553: SELECT fvs.flex_value_set_name
2554: INTO l_vset_name
2555: FROM fnd_flex_value_sets fvs, fnd_flex_validation_tables fvt
2556: WHERE fvs.validation_type = 'F'
2557: AND fvs.flex_value_set_id = fvt.flex_value_set_id
2558: AND Nvl(fvt.table_application_id, p_application_id) = p_application_id
2559: AND (Upper(fvt.application_table_name) = up_table_name OR

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

2569: WHEN no_data_found THEN
2570: NULL;
2571: WHEN OTHERS THEN
2572: x_message :=
2573: 'SELECT FROM FND_FLEX_VALIDATION_TABLES is failed. '||chr_newline||
2574: 'SQLERRM : ' || Sqlerrm;
2575: RETURN(TRUE);
2576: END;
2577: RETURN(FALSE);

Line 2604: FROM fnd_flex_value_sets fvs, fnd_flex_validation_tables fvt

2600: BEGIN
2601: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
2602: fvs.flex_value_set_name
2603: INTO l_vset_name
2604: FROM fnd_flex_value_sets fvs, fnd_flex_validation_tables fvt
2605: WHERE fvs.validation_type = 'F'
2606: AND fvs.flex_value_set_id = fvt.flex_value_set_id
2607: AND Nvl(fvt.table_application_id, p_application_id) = p_application_id
2608: AND (Upper(fvt.application_table_name) = up_table_name OR

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

2636: WHEN no_data_found THEN
2637: NULL;
2638: WHEN OTHERS THEN
2639: x_message :=
2640: 'SELECT FROM FND_FLEX_VALIDATION_TABLES is failed. '||chr_newline||
2641: 'SQLERRM : ' || Sqlerrm;
2642: RETURN(TRUE);
2643: END;
2644: RETURN(FALSE);

Line 3840: fnd_flex_validation_tables t

3836: l_number_precision, l_flex_value_set_name,
3837: l_id_column_name, l_id_column_type, l_id_column_size
3838: FROM
3839: fnd_flex_value_sets v,
3840: fnd_flex_validation_tables t
3841: WHERE
3842: v.flex_value_set_id = p_value_set_id and
3843: v.flex_value_set_id = t.flex_value_set_id(+);
3844:

Line 3854: fnd_flex_validation_tables t,

3850: INTO
3851: l_column_type, l_appl_col_size
3852: FROM
3853: fnd_flex_value_sets v,
3854: fnd_flex_validation_tables t,
3855: fnd_columns c, fnd_tables tb
3856: WHERE
3857: v.flex_value_set_id = p_value_set_id and
3858: v.flex_value_set_id = t.flex_value_set_id(+) and

Line 4196: p_id_column_type IN fnd_flex_validation_tables.id_column_type%TYPE,

4192:
4193: PROCEDURE check_base_table_column(
4194: p_application_column_type IN fnd_columns.column_type%TYPE,
4195: p_application_column_size IN fnd_columns.width%TYPE,
4196: p_id_column_type IN fnd_flex_validation_tables.id_column_type%TYPE,
4197: p_id_column_size IN fnd_flex_validation_tables.id_column_size%TYPE,
4198: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,
4199: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4200: p_maximum_size IN fnd_flex_value_sets.maximum_size%TYPE,

Line 4197: p_id_column_size IN fnd_flex_validation_tables.id_column_size%TYPE,

4193: PROCEDURE check_base_table_column(
4194: p_application_column_type IN fnd_columns.column_type%TYPE,
4195: p_application_column_size IN fnd_columns.width%TYPE,
4196: p_id_column_type IN fnd_flex_validation_tables.id_column_type%TYPE,
4197: p_id_column_size IN fnd_flex_validation_tables.id_column_size%TYPE,
4198: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,
4199: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4200: p_maximum_size IN fnd_flex_value_sets.maximum_size%TYPE,
4201: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,

Line 4416: fnd_flex_validation_tables t

4412: l_flex_value_set_name, l_id_column_type,
4413: l_id_column_size
4414: FROM
4415: fnd_flex_value_sets v,
4416: fnd_flex_validation_tables t
4417: WHERE
4418: v.flex_value_set_id = p_flex_value_set_id and
4419: v.flex_value_set_id = t.flex_value_set_id(+);
4420:

Line 4584: fnd_flex_validation_tables t

4580: l_number_precision, l_flex_value_set_name,
4581: l_id_column_name, l_id_column_type, l_id_column_size
4582: FROM
4583: fnd_flex_value_sets v,
4584: fnd_flex_validation_tables t
4585: WHERE
4586: v.flex_value_set_id = p_flex_value_set_id and
4587: v.flex_value_set_id = t.flex_value_set_id(+);
4588:

Line 4950: p_id_column_name IN fnd_flex_validation_tables.id_column_name%TYPE,

4946:
4947:
4948: PROCEDURE validate_table_vset(
4949: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4950: p_id_column_name IN fnd_flex_validation_tables.id_column_name%TYPE,
4951: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,
4952: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,
4953: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,
4954: p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,

Line 4951: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,

4947:
4948: PROCEDURE validate_table_vset(
4949: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4950: p_id_column_name IN fnd_flex_validation_tables.id_column_name%TYPE,
4951: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,
4952: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,
4953: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,
4954: p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,
4955: p_additional_where_clause IN fnd_flex_validation_tables.additional_where_clause%TYPE,

Line 4952: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,

4948: PROCEDURE validate_table_vset(
4949: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4950: p_id_column_name IN fnd_flex_validation_tables.id_column_name%TYPE,
4951: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,
4952: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,
4953: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,
4954: p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,
4955: p_additional_where_clause IN fnd_flex_validation_tables.additional_where_clause%TYPE,
4956: x_result OUT NOCOPY VARCHAR2,

Line 4953: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,

4949: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4950: p_id_column_name IN fnd_flex_validation_tables.id_column_name%TYPE,
4951: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,
4952: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,
4953: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,
4954: p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,
4955: p_additional_where_clause IN fnd_flex_validation_tables.additional_where_clause%TYPE,
4956: x_result OUT NOCOPY VARCHAR2,
4957: x_message OUT NOCOPY VARCHAR2)

Line 4954: p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,

4950: p_id_column_name IN fnd_flex_validation_tables.id_column_name%TYPE,
4951: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,
4952: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,
4953: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,
4954: p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,
4955: p_additional_where_clause IN fnd_flex_validation_tables.additional_where_clause%TYPE,
4956: x_result OUT NOCOPY VARCHAR2,
4957: x_message OUT NOCOPY VARCHAR2)
4958: IS

Line 4955: p_additional_where_clause IN fnd_flex_validation_tables.additional_where_clause%TYPE,

4951: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,
4952: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,
4953: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,
4954: p_application_table_name IN fnd_flex_validation_tables.application_table_name%TYPE,
4955: p_additional_where_clause IN fnd_flex_validation_tables.additional_where_clause%TYPE,
4956: x_result OUT NOCOPY VARCHAR2,
4957: x_message OUT NOCOPY VARCHAR2)
4958: IS
4959: l_stmt VARCHAR2(32000);

Line 4963: l_tmpaddlclmn fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

4959: l_stmt VARCHAR2(32000);
4960: l_stmt1 VARCHAR2(32000);
4961: l_message VARCHAR(32000);
4962: l_cur_hdl INTEGER;
4963: l_tmpaddlclmn fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4964: l_tmpaddlclmnfrmt fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4965: l_double_quote varchar2(3);
4966: l_appl_string varchar2(10);
4967: l_star varchar2(2);

Line 4964: l_tmpaddlclmnfrmt fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

4960: l_stmt1 VARCHAR2(32000);
4961: l_message VARCHAR(32000);
4962: l_cur_hdl INTEGER;
4963: l_tmpaddlclmn fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4964: l_tmpaddlclmnfrmt fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4965: l_double_quote varchar2(3);
4966: l_appl_string varchar2(10);
4967: l_star varchar2(2);
4968: l_name_string varchar2(10);

Line 4971: l_additional_column_width1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

4967: l_star varchar2(2);
4968: l_name_string varchar2(10);
4969: l_open_bracket varchar2(3);
4970: l_close_bracket varchar2(3);
4971: l_additional_column_width1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4972: l_additional_column_width2 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4973: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
4974: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
4975: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;

Line 4972: l_additional_column_width2 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

4968: l_name_string varchar2(10);
4969: l_open_bracket varchar2(3);
4970: l_close_bracket varchar2(3);
4971: l_additional_column_width1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4972: l_additional_column_width2 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4973: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
4974: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
4975: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
4976: l_additional_column_width3 varchar2(20);

Line 4973: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

4969: l_open_bracket varchar2(3);
4970: l_close_bracket varchar2(3);
4971: l_additional_column_width1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4972: l_additional_column_width2 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4973: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
4974: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
4975: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
4976: l_additional_column_width3 varchar2(20);
4977: l_position1_double_quote number;

Line 4974: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;

4970: l_close_bracket varchar2(3);
4971: l_additional_column_width1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4972: l_additional_column_width2 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4973: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
4974: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
4975: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
4976: l_additional_column_width3 varchar2(20);
4977: l_position1_double_quote number;
4978: l_position2_double_quote number;

Line 4975: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;

4971: l_additional_column_width1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4972: l_additional_column_width2 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4973: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
4974: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
4975: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
4976: l_additional_column_width3 varchar2(20);
4977: l_position1_double_quote number;
4978: l_position2_double_quote number;
4979: l_position_open_bracket number;

Line 4988: l_tmpaddlclmn1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

4984: NEWLINE VARCHAR2(4);
4985: WHITESPACE VARCHAR2(4);
4986: COMMA VARCHAR2(1);
4987: l_into varchar2_array_type;
4988: l_tmpaddlclmn1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4989: l_tmpaddlclmn_no_into fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4990: l_char varchar2(4);
4991: l_position number;
4992: l_into_begin number;

Line 4989: l_tmpaddlclmn_no_into fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

4985: WHITESPACE VARCHAR2(4);
4986: COMMA VARCHAR2(1);
4987: l_into varchar2_array_type;
4988: l_tmpaddlclmn1 fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4989: l_tmpaddlclmn_no_into fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
4990: l_char varchar2(4);
4991: l_position number;
4992: l_into_begin number;
4993: l_into_end number;

Line 4996: l_ltrim_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

4992: l_into_begin number;
4993: l_into_end number;
4994: l_where varchar2(10);
4995: l_orderby varchar2(10);
4996: l_ltrim_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
4997: l_ret number;
4998: BEGIN
4999:
5000: l_double_quote := '"';