DBA Data[Home] [Help]

APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_ID_FLEXS

Line 64: creation_date fnd_id_flexs.creation_date%TYPE,

60: g_session_mode VARCHAR2(100) := 'NOT_SET';
61:
62: TYPE who_rec_type IS RECORD
63: (session_mode VARCHAR2(100),
64: creation_date fnd_id_flexs.creation_date%TYPE,
65: created_by fnd_id_flexs.created_by%TYPE,
66: last_update_date fnd_id_flexs.last_update_date%TYPE,
67: last_updated_by fnd_id_flexs.last_updated_by%TYPE,
68: last_update_login fnd_id_flexs.last_update_login%TYPE);

Line 65: created_by fnd_id_flexs.created_by%TYPE,

61:
62: TYPE who_rec_type IS RECORD
63: (session_mode VARCHAR2(100),
64: creation_date fnd_id_flexs.creation_date%TYPE,
65: created_by fnd_id_flexs.created_by%TYPE,
66: last_update_date fnd_id_flexs.last_update_date%TYPE,
67: last_updated_by fnd_id_flexs.last_updated_by%TYPE,
68: last_update_login fnd_id_flexs.last_update_login%TYPE);
69:

Line 66: last_update_date fnd_id_flexs.last_update_date%TYPE,

62: TYPE who_rec_type IS RECORD
63: (session_mode VARCHAR2(100),
64: creation_date fnd_id_flexs.creation_date%TYPE,
65: created_by fnd_id_flexs.created_by%TYPE,
66: last_update_date fnd_id_flexs.last_update_date%TYPE,
67: last_updated_by fnd_id_flexs.last_updated_by%TYPE,
68: last_update_login fnd_id_flexs.last_update_login%TYPE);
69:
70: SUBTYPE vset_rec_type IS fnd_flex_value_sets%ROWTYPE;

Line 67: last_updated_by fnd_id_flexs.last_updated_by%TYPE,

63: (session_mode VARCHAR2(100),
64: creation_date fnd_id_flexs.creation_date%TYPE,
65: created_by fnd_id_flexs.created_by%TYPE,
66: last_update_date fnd_id_flexs.last_update_date%TYPE,
67: last_updated_by fnd_id_flexs.last_updated_by%TYPE,
68: last_update_login fnd_id_flexs.last_update_login%TYPE);
69:
70: SUBTYPE vset_rec_type IS fnd_flex_value_sets%ROWTYPE;
71:

Line 68: last_update_login fnd_id_flexs.last_update_login%TYPE);

64: creation_date fnd_id_flexs.creation_date%TYPE,
65: created_by fnd_id_flexs.created_by%TYPE,
66: last_update_date fnd_id_flexs.last_update_date%TYPE,
67: last_updated_by fnd_id_flexs.last_updated_by%TYPE,
68: last_update_login fnd_id_flexs.last_update_login%TYPE);
69:
70: SUBTYPE vset_rec_type IS fnd_flex_value_sets%ROWTYPE;
71:
72: TYPE cursor_type IS REF CURSOR;

Line 1639: FROM fnd_id_flexs idf, fnd_id_flex_structures_vl ifst,

1635: ifst.id_flex_num, ifst.id_flex_structure_name,
1636: ifsg.segment_name, ifsg.application_column_name,
1637: ifsg.default_type, ifsg.default_value,
1638: fc.column_type, fc.width
1639: FROM fnd_id_flexs idf, fnd_id_flex_structures_vl ifst,
1640: fnd_id_flex_segments ifsg, fnd_columns fc
1641: WHERE idf.application_id = ifst.application_id
1642: AND idf.id_flex_code = ifst.id_flex_code
1643: AND ifst.application_id = ifsg.application_id

Line 1908: fnd_id_flexs f,

1904: count(*)
1905: INTO
1906: l_num_segs
1907: FROM
1908: fnd_id_flexs f,
1909: fnd_id_flex_segments s
1910: WHERE
1911: s.flex_value_set_id=l_ind_vset_rec.flex_value_set_id AND
1912: f.application_id=s.application_id AND

Line 1926: fnd_id_flexs fif, fnd_id_flex_structures fifst,

1922: ''' Application Id ''' || fif.application_id
1923: INTO
1924: l_trans_msg
1925: FROM
1926: fnd_id_flexs fif, fnd_id_flex_structures fifst,
1927: fnd_id_flex_segments fifsg
1928: WHERE
1929: fifst.application_id = fif.application_id
1930: and fifst.id_flex_code = fif.id_flex_code

Line 2285: FROM fnd_id_flexs idf, fnd_id_flex_structures_vl ifst,

2281: ifst.id_flex_num, ifst.id_flex_structure_name,
2282: ifsg.segment_name, ifsg.application_column_name,
2283: ifsg.default_type, ifsg.default_value, ifsg.ROWID,
2284: fc.column_type, fc.width
2285: FROM fnd_id_flexs idf, fnd_id_flex_structures_vl ifst,
2286: fnd_id_flex_segments ifsg, fnd_columns fc
2287: WHERE idf.application_id = ifst.application_id
2288: AND idf.id_flex_code = ifst.id_flex_code
2289: AND ifst.application_id = ifsg.application_id

Line 3503: fnd_id_flexs idf, fnd_application_vl fa,

3499: fvs.maximum_size,
3500: fl3.meaning format_type_lookup
3501:
3502: FROM fnd_id_flex_segments_vl ifsg, fnd_id_flex_structures_vl ifst,
3503: fnd_id_flexs idf, fnd_application_vl fa,
3504: fnd_lookups fl1, fnd_lookups fl2, fnd_lookups fl3,
3505: fnd_flex_value_sets fvs
3506: WHERE idf.application_id = fa.application_id
3507: AND ifst.application_id = idf.application_id