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 1637: FROM fnd_id_flexs idf, fnd_id_flex_structures_vl ifst,

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

Line 1906: fnd_id_flexs f,

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

Line 1924: fnd_id_flexs fif, fnd_id_flex_structures fifst,

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

Line 2283: FROM fnd_id_flexs idf, fnd_id_flex_structures_vl ifst,

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

Line 3501: fnd_id_flexs idf, fnd_application_vl fa,

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