DBA Data[Home] [Help]

APPS.FND_FLEX_SERVER dependencies on FND_ID_FLEXS

Line 53: set_defining_column_name fnd_id_flexs.set_defining_column_name%TYPE,

49: -- --------------------------------------------------
50: TYPE kfvssc_record_type IS RECORD
51: (compact_sql VARCHAR2(32000),
52: padded_sql VARCHAR2(32000),
53: set_defining_column_name fnd_id_flexs.set_defining_column_name%TYPE,
54: unique_id_column_name fnd_id_flexs.unique_id_column_name%TYPE);
55:
56: TYPE kfvssc_table_type IS TABLE OF kfvssc_record_type INDEX BY BINARY_INTEGER;
57:

Line 54: unique_id_column_name fnd_id_flexs.unique_id_column_name%TYPE);

50: TYPE kfvssc_record_type IS RECORD
51: (compact_sql VARCHAR2(32000),
52: padded_sql VARCHAR2(32000),
53: set_defining_column_name fnd_id_flexs.set_defining_column_name%TYPE,
54: unique_id_column_name fnd_id_flexs.unique_id_column_name%TYPE);
55:
56: TYPE kfvssc_table_type IS TABLE OF kfvssc_record_type INDEX BY BINARY_INTEGER;
57:
58: kfvssc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

Line 65: (table_application_id fnd_id_flexs.table_application_id%TYPE,

61: -- --------------------------------------------------
62: -- Get KFV Concat Segs: Code Combination Table Info Cache
63: -- --------------------------------------------------
64: TYPE kfvcct_record_type IS RECORD
65: (table_application_id fnd_id_flexs.table_application_id%TYPE,
66: application_table_name fnd_id_flexs.application_table_name%TYPE,
67: table_id fnd_tables.table_id%TYPE,
68: set_defining_column_name fnd_id_flexs.set_defining_column_name%TYPE,
69: unique_id_column_name fnd_id_flexs.unique_id_column_name%TYPE);

Line 66: application_table_name fnd_id_flexs.application_table_name%TYPE,

62: -- Get KFV Concat Segs: Code Combination Table Info Cache
63: -- --------------------------------------------------
64: TYPE kfvcct_record_type IS RECORD
65: (table_application_id fnd_id_flexs.table_application_id%TYPE,
66: application_table_name fnd_id_flexs.application_table_name%TYPE,
67: table_id fnd_tables.table_id%TYPE,
68: set_defining_column_name fnd_id_flexs.set_defining_column_name%TYPE,
69: unique_id_column_name fnd_id_flexs.unique_id_column_name%TYPE);
70:

Line 68: set_defining_column_name fnd_id_flexs.set_defining_column_name%TYPE,

64: TYPE kfvcct_record_type IS RECORD
65: (table_application_id fnd_id_flexs.table_application_id%TYPE,
66: application_table_name fnd_id_flexs.application_table_name%TYPE,
67: table_id fnd_tables.table_id%TYPE,
68: set_defining_column_name fnd_id_flexs.set_defining_column_name%TYPE,
69: unique_id_column_name fnd_id_flexs.unique_id_column_name%TYPE);
70:
71: TYPE kfvcct_table_type IS TABLE OF kfvcct_record_type INDEX BY BINARY_INTEGER;
72:

Line 69: unique_id_column_name fnd_id_flexs.unique_id_column_name%TYPE);

65: (table_application_id fnd_id_flexs.table_application_id%TYPE,
66: application_table_name fnd_id_flexs.application_table_name%TYPE,
67: table_id fnd_tables.table_id%TYPE,
68: set_defining_column_name fnd_id_flexs.set_defining_column_name%TYPE,
69: unique_id_column_name fnd_id_flexs.unique_id_column_name%TYPE);
70:
71: TYPE kfvcct_table_type IS TABLE OF kfvcct_record_type INDEX BY BINARY_INTEGER;
72:
73: kfvcct_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

Line 5424: FROM fnd_id_flexs fif, fnd_tables ft

5420: px_kfvcct_record.application_table_name,
5421: px_kfvcct_record.table_id,
5422: px_kfvcct_record.set_defining_column_name,
5423: px_kfvcct_record.unique_id_column_name
5424: FROM fnd_id_flexs fif, fnd_tables ft
5425: WHERE fif.application_id = p_application_id
5426: AND fif.id_flex_code = p_id_flex_code
5427: AND ft.application_id = fif.table_application_id
5428: AND ft.table_name = fif.application_table_name;