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_DSC_API dependencies on FND_FLEX_VALUE_SETS

Line 239: value_set_id OUT nocopy fnd_flex_value_sets.flex_value_set_id%TYPE)

235: /* ---------------------------------------------------------------------- */
236:
237: PROCEDURE value_set_id_f(
238: value_set_name IN VARCHAR2,
239: value_set_id OUT nocopy fnd_flex_value_sets.flex_value_set_id%TYPE)
240: IS
241: BEGIN
242: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
243: flex_value_set_id

Line 245: FROM fnd_flex_value_sets

241: BEGIN
242: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
243: flex_value_set_id
244: INTO value_set_id
245: FROM fnd_flex_value_sets
246: WHERE flex_value_set_name = value_set_name;
247: EXCEPTION
248: WHEN no_data_found THEN
249: message('bad valueset name:' || value_set_name);

Line 323: last_update_login fnd_flex_value_sets.last_update_login%TYPE

319: protected_flag IN VARCHAR2,
320: default_context_field_name IN VARCHAR2,
321: default_context_value IN VARCHAR2)
322: IS
323: last_update_login fnd_flex_value_sets.last_update_login%TYPE
324: := last_update_login_f;
325: last_update_date fnd_flex_value_sets.last_update_date%TYPE
326: := last_update_date_f;
327: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE

Line 325: last_update_date fnd_flex_value_sets.last_update_date%TYPE

321: default_context_value IN VARCHAR2)
322: IS
323: last_update_login fnd_flex_value_sets.last_update_login%TYPE
324: := last_update_login_f;
325: last_update_date fnd_flex_value_sets.last_update_date%TYPE
326: := last_update_date_f;
327: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
328: := last_updated_by_f;
329: creation_date fnd_flex_value_sets.creation_date%TYPE

Line 327: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE

323: last_update_login fnd_flex_value_sets.last_update_login%TYPE
324: := last_update_login_f;
325: last_update_date fnd_flex_value_sets.last_update_date%TYPE
326: := last_update_date_f;
327: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
328: := last_updated_by_f;
329: creation_date fnd_flex_value_sets.creation_date%TYPE
330: := creation_date_f;
331: created_by fnd_flex_value_sets.created_by%TYPE

Line 329: creation_date fnd_flex_value_sets.creation_date%TYPE

325: last_update_date fnd_flex_value_sets.last_update_date%TYPE
326: := last_update_date_f;
327: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
328: := last_updated_by_f;
329: creation_date fnd_flex_value_sets.creation_date%TYPE
330: := creation_date_f;
331: created_by fnd_flex_value_sets.created_by%TYPE
332: := created_by_f;
333: dummy NUMBER(1);

Line 331: created_by fnd_flex_value_sets.created_by%TYPE

327: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
328: := last_updated_by_f;
329: creation_date fnd_flex_value_sets.creation_date%TYPE
330: := creation_date_f;
331: created_by fnd_flex_value_sets.created_by%TYPE
332: := created_by_f;
333: dummy NUMBER(1);
334: BEGIN
335: /* assume valid application_id, table_application_id */

Line 418: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE

414: p_context_default_value IN VARCHAR2,
415: p_context_override_value_set_i IN NUMBER,
416: p_context_runtime_property_fun IN VARCHAR2)
417: IS
418: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
419: := last_update_login_f;
420: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
421: := last_update_date_f;
422: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE

Line 420: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE

416: p_context_runtime_property_fun IN VARCHAR2)
417: IS
418: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
419: := last_update_login_f;
420: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
421: := last_update_date_f;
422: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
423: := last_updated_by_f;
424: BEGIN

Line 422: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE

418: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
419: := last_update_login_f;
420: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
421: := last_update_date_f;
422: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
423: := last_updated_by_f;
424: BEGIN
425: UPDATE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
426: fnd_descriptive_flexs SET

Line 464: last_update_login fnd_flex_value_sets.last_update_login%TYPE

460: title IN VARCHAR2,
461: description IN VARCHAR2,
462: form_context_prompt IN VARCHAR2)
463: IS
464: last_update_login fnd_flex_value_sets.last_update_login%TYPE
465: := last_update_login_f;
466: last_update_date fnd_flex_value_sets.last_update_date%TYPE
467: := last_update_date_f;
468: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE

Line 466: last_update_date fnd_flex_value_sets.last_update_date%TYPE

462: form_context_prompt IN VARCHAR2)
463: IS
464: last_update_login fnd_flex_value_sets.last_update_login%TYPE
465: := last_update_login_f;
466: last_update_date fnd_flex_value_sets.last_update_date%TYPE
467: := last_update_date_f;
468: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
469: := last_updated_by_f;
470: creation_date fnd_flex_value_sets.creation_date%TYPE

Line 468: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE

464: last_update_login fnd_flex_value_sets.last_update_login%TYPE
465: := last_update_login_f;
466: last_update_date fnd_flex_value_sets.last_update_date%TYPE
467: := last_update_date_f;
468: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
469: := last_updated_by_f;
470: creation_date fnd_flex_value_sets.creation_date%TYPE
471: := creation_date_f;
472: created_by fnd_flex_value_sets.created_by%TYPE

Line 470: creation_date fnd_flex_value_sets.creation_date%TYPE

466: last_update_date fnd_flex_value_sets.last_update_date%TYPE
467: := last_update_date_f;
468: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
469: := last_updated_by_f;
470: creation_date fnd_flex_value_sets.creation_date%TYPE
471: := creation_date_f;
472: created_by fnd_flex_value_sets.created_by%TYPE
473: := created_by_f;
474: BEGIN

Line 472: created_by fnd_flex_value_sets.created_by%TYPE

468: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
469: := last_updated_by_f;
470: creation_date fnd_flex_value_sets.creation_date%TYPE
471: := creation_date_f;
472: created_by fnd_flex_value_sets.created_by%TYPE
473: := created_by_f;
474: BEGIN
475: FOR lang_rec IN lang_cur
476: LOOP

Line 531: last_update_login fnd_flex_value_sets.last_update_login%TYPE

527: enabled_flag IN VARCHAR2,
528: global_flag IN VARCHAR2,
529: description IN VARCHAR2)
530: IS
531: last_update_login fnd_flex_value_sets.last_update_login%TYPE
532: := last_update_login_f;
533: last_update_date fnd_flex_value_sets.last_update_date%TYPE
534: := last_update_date_f;
535: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE

Line 533: last_update_date fnd_flex_value_sets.last_update_date%TYPE

529: description IN VARCHAR2)
530: IS
531: last_update_login fnd_flex_value_sets.last_update_login%TYPE
532: := last_update_login_f;
533: last_update_date fnd_flex_value_sets.last_update_date%TYPE
534: := last_update_date_f;
535: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
536: := last_updated_by_f;
537: creation_date fnd_flex_value_sets.creation_date%TYPE

Line 535: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE

531: last_update_login fnd_flex_value_sets.last_update_login%TYPE
532: := last_update_login_f;
533: last_update_date fnd_flex_value_sets.last_update_date%TYPE
534: := last_update_date_f;
535: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
536: := last_updated_by_f;
537: creation_date fnd_flex_value_sets.creation_date%TYPE
538: := creation_date_f;
539: created_by fnd_flex_value_sets.created_by%TYPE

Line 537: creation_date fnd_flex_value_sets.creation_date%TYPE

533: last_update_date fnd_flex_value_sets.last_update_date%TYPE
534: := last_update_date_f;
535: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
536: := last_updated_by_f;
537: creation_date fnd_flex_value_sets.creation_date%TYPE
538: := creation_date_f;
539: created_by fnd_flex_value_sets.created_by%TYPE
540: := created_by_f;
541: BEGIN

Line 539: created_by fnd_flex_value_sets.created_by%TYPE

535: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
536: := last_updated_by_f;
537: creation_date fnd_flex_value_sets.creation_date%TYPE
538: := creation_date_f;
539: created_by fnd_flex_value_sets.created_by%TYPE
540: := created_by_f;
541: BEGIN
542: INSERT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
543: INTO fnd_descr_flex_contexts(application_id,

Line 581: last_update_login fnd_flex_value_sets.last_update_login%TYPE

577: descriptive_flex_context_code IN VARCHAR2,
578: descriptive_flex_context_name IN VARCHAR2,
579: description IN VARCHAR2)
580: IS
581: last_update_login fnd_flex_value_sets.last_update_login%TYPE
582: := last_update_login_f;
583: last_update_date fnd_flex_value_sets.last_update_date%TYPE
584: := last_update_date_f;
585: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE

Line 583: last_update_date fnd_flex_value_sets.last_update_date%TYPE

579: description IN VARCHAR2)
580: IS
581: last_update_login fnd_flex_value_sets.last_update_login%TYPE
582: := last_update_login_f;
583: last_update_date fnd_flex_value_sets.last_update_date%TYPE
584: := last_update_date_f;
585: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
586: := last_updated_by_f;
587: creation_date fnd_flex_value_sets.creation_date%TYPE

Line 585: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE

581: last_update_login fnd_flex_value_sets.last_update_login%TYPE
582: := last_update_login_f;
583: last_update_date fnd_flex_value_sets.last_update_date%TYPE
584: := last_update_date_f;
585: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
586: := last_updated_by_f;
587: creation_date fnd_flex_value_sets.creation_date%TYPE
588: := creation_date_f;
589: created_by fnd_flex_value_sets.created_by%TYPE

Line 587: creation_date fnd_flex_value_sets.creation_date%TYPE

583: last_update_date fnd_flex_value_sets.last_update_date%TYPE
584: := last_update_date_f;
585: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
586: := last_updated_by_f;
587: creation_date fnd_flex_value_sets.creation_date%TYPE
588: := creation_date_f;
589: created_by fnd_flex_value_sets.created_by%TYPE
590: := created_by_f;
591: BEGIN

Line 589: created_by fnd_flex_value_sets.created_by%TYPE

585: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
586: := last_updated_by_f;
587: creation_date fnd_flex_value_sets.creation_date%TYPE
588: := creation_date_f;
589: created_by fnd_flex_value_sets.created_by%TYPE
590: := created_by_f;
591: BEGIN
592: FOR lang_rec IN lang_cur
593: LOOP

Line 669: last_update_login fnd_flex_value_sets.last_update_login%TYPE

665: default_value IN VARCHAR2,
666: runtime_property_function IN VARCHAR2,
667: srw_param IN VARCHAR2)
668: IS
669: last_update_login fnd_flex_value_sets.last_update_login%TYPE
670: := last_update_login_f;
671: last_update_date fnd_flex_value_sets.last_update_date%TYPE
672: := last_update_date_f;
673: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE

Line 671: last_update_date fnd_flex_value_sets.last_update_date%TYPE

667: srw_param IN VARCHAR2)
668: IS
669: last_update_login fnd_flex_value_sets.last_update_login%TYPE
670: := last_update_login_f;
671: last_update_date fnd_flex_value_sets.last_update_date%TYPE
672: := last_update_date_f;
673: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
674: := last_updated_by_f;
675: creation_date fnd_flex_value_sets.creation_date%TYPE

Line 673: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE

669: last_update_login fnd_flex_value_sets.last_update_login%TYPE
670: := last_update_login_f;
671: last_update_date fnd_flex_value_sets.last_update_date%TYPE
672: := last_update_date_f;
673: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
674: := last_updated_by_f;
675: creation_date fnd_flex_value_sets.creation_date%TYPE
676: := creation_date_f;
677: created_by fnd_flex_value_sets.created_by%TYPE

Line 675: creation_date fnd_flex_value_sets.creation_date%TYPE

671: last_update_date fnd_flex_value_sets.last_update_date%TYPE
672: := last_update_date_f;
673: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
674: := last_updated_by_f;
675: creation_date fnd_flex_value_sets.creation_date%TYPE
676: := creation_date_f;
677: created_by fnd_flex_value_sets.created_by%TYPE
678: := created_by_f;
679: BEGIN

Line 677: created_by fnd_flex_value_sets.created_by%TYPE

673: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
674: := last_updated_by_f;
675: creation_date fnd_flex_value_sets.creation_date%TYPE
676: := creation_date_f;
677: created_by fnd_flex_value_sets.created_by%TYPE
678: := created_by_f;
679: BEGIN
680: INSERT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
681: INTO fnd_descr_flex_column_usages(application_id,

Line 748: last_update_login fnd_flex_value_sets.last_update_login%TYPE

744: form_left_prompt IN VARCHAR2,
745: form_above_prompt IN VARCHAR2,
746: description IN VARCHAR2)
747: IS
748: last_update_login fnd_flex_value_sets.last_update_login%TYPE
749: := last_update_login_f;
750: last_update_date fnd_flex_value_sets.last_update_date%TYPE
751: := last_update_date_f;
752: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE

Line 750: last_update_date fnd_flex_value_sets.last_update_date%TYPE

746: description IN VARCHAR2)
747: IS
748: last_update_login fnd_flex_value_sets.last_update_login%TYPE
749: := last_update_login_f;
750: last_update_date fnd_flex_value_sets.last_update_date%TYPE
751: := last_update_date_f;
752: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
753: := last_updated_by_f;
754: creation_date fnd_flex_value_sets.creation_date%TYPE

Line 752: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE

748: last_update_login fnd_flex_value_sets.last_update_login%TYPE
749: := last_update_login_f;
750: last_update_date fnd_flex_value_sets.last_update_date%TYPE
751: := last_update_date_f;
752: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
753: := last_updated_by_f;
754: creation_date fnd_flex_value_sets.creation_date%TYPE
755: := creation_date_f;
756: created_by fnd_flex_value_sets.created_by%TYPE

Line 754: creation_date fnd_flex_value_sets.creation_date%TYPE

750: last_update_date fnd_flex_value_sets.last_update_date%TYPE
751: := last_update_date_f;
752: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
753: := last_updated_by_f;
754: creation_date fnd_flex_value_sets.creation_date%TYPE
755: := creation_date_f;
756: created_by fnd_flex_value_sets.created_by%TYPE
757: := created_by_f;
758: BEGIN

Line 756: created_by fnd_flex_value_sets.created_by%TYPE

752: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
753: := last_updated_by_f;
754: creation_date fnd_flex_value_sets.creation_date%TYPE
755: := creation_date_f;
756: created_by fnd_flex_value_sets.created_by%TYPE
757: := created_by_f;
758: BEGIN
759: FOR lang_rec IN lang_cur
760: LOOP

Line 807: last_update_login fnd_flex_value_sets.last_update_login%TYPE

803: flexfield_name_in IN VARCHAR2,
804: context_field_name_in IN VARCHAR2,
805: description_in IN VARCHAR2)
806: IS
807: last_update_login fnd_flex_value_sets.last_update_login%TYPE
808: := last_update_login_f;
809: last_update_date fnd_flex_value_sets.last_update_date%TYPE
810: := last_update_date_f;
811: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE

Line 809: last_update_date fnd_flex_value_sets.last_update_date%TYPE

805: description_in IN VARCHAR2)
806: IS
807: last_update_login fnd_flex_value_sets.last_update_login%TYPE
808: := last_update_login_f;
809: last_update_date fnd_flex_value_sets.last_update_date%TYPE
810: := last_update_date_f;
811: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
812: := last_updated_by_f;
813: creation_date fnd_flex_value_sets.creation_date%TYPE

Line 811: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE

807: last_update_login fnd_flex_value_sets.last_update_login%TYPE
808: := last_update_login_f;
809: last_update_date fnd_flex_value_sets.last_update_date%TYPE
810: := last_update_date_f;
811: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
812: := last_updated_by_f;
813: creation_date fnd_flex_value_sets.creation_date%TYPE
814: := creation_date_f;
815: created_by fnd_flex_value_sets.created_by%TYPE

Line 813: creation_date fnd_flex_value_sets.creation_date%TYPE

809: last_update_date fnd_flex_value_sets.last_update_date%TYPE
810: := last_update_date_f;
811: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
812: := last_updated_by_f;
813: creation_date fnd_flex_value_sets.creation_date%TYPE
814: := creation_date_f;
815: created_by fnd_flex_value_sets.created_by%TYPE
816: := created_by_f;
817: BEGIN

Line 815: created_by fnd_flex_value_sets.created_by%TYPE

811: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE
812: := last_updated_by_f;
813: creation_date fnd_flex_value_sets.creation_date%TYPE
814: := creation_date_f;
815: created_by fnd_flex_value_sets.created_by%TYPE
816: := created_by_f;
817: BEGIN
818: INSERT
819: INTO fnd_default_context_fields(application_id,

Line 970: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE

966: protected_flag IN VARCHAR2 DEFAULT 'N',
967: enable_columns IN VARCHAR2 DEFAULT NULL,
968: concatenated_segs_view_name IN VARCHAR2 DEFAULT NULL)
969: IS
970: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
971: := last_update_login_f;
972: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
973: := last_update_date_f;
974: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE

Line 972: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE

968: concatenated_segs_view_name IN VARCHAR2 DEFAULT NULL)
969: IS
970: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
971: := last_update_login_f;
972: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
973: := last_update_date_f;
974: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
975: := last_updated_by_f;
976: application_id_i fnd_application.application_id%TYPE;

Line 974: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE

970: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
971: := last_update_login_f;
972: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
973: := last_update_date_f;
974: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
975: := last_updated_by_f;
976: application_id_i fnd_application.application_id%TYPE;
977: table_application_id_i fnd_application.application_id%TYPE;
978: application_table_id_i fnd_tables.table_id%TYPE;

Line 1185: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE

1181: PROCEDURE enable_columns(appl_short_name IN VARCHAR2,
1182: flexfield_name IN VARCHAR2,
1183: pattern IN VARCHAR2)
1184: IS
1185: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
1186: := last_update_login_f;
1187: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
1188: := last_update_date_f;
1189: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE

Line 1187: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE

1183: pattern IN VARCHAR2)
1184: IS
1185: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
1186: := last_update_login_f;
1187: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
1188: := last_update_date_f;
1189: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
1190: := last_updated_by_f;
1191: application_id_i fnd_application.application_id%TYPE;

Line 1189: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE

1185: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
1186: := last_update_login_f;
1187: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
1188: := last_update_date_f;
1189: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
1190: := last_updated_by_f;
1191: application_id_i fnd_application.application_id%TYPE;
1192: table_application_id_i fnd_application.application_id%TYPE;
1193: application_table_id_i fnd_tables.table_id%TYPE;

Line 1277: FROM fnd_flex_value_sets

1273: IF (context_override_value_set_nam IS NOT NULL) THEN
1274: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1275: flex_value_set_id
1276: INTO l_context_override_value_set_i
1277: FROM fnd_flex_value_sets
1278: WHERE flex_value_set_name = context_override_value_set_nam;
1279: END IF;
1280:
1281: upd_descriptive_flexs(

Line 1312: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE

1308:
1309: PROCEDURE freeze(appl_short_name IN VARCHAR2,
1310: flexfield_name IN VARCHAR2)
1311: IS
1312: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
1313: := last_update_login_f;
1314: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
1315: := last_update_date_f;
1316: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE

Line 1314: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE

1310: flexfield_name IN VARCHAR2)
1311: IS
1312: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
1313: := last_update_login_f;
1314: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
1315: := last_update_date_f;
1316: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
1317: := last_updated_by_f;
1318: appid fnd_application.application_id%TYPE;

Line 1316: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE

1312: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
1313: := last_update_login_f;
1314: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
1315: := last_update_date_f;
1316: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
1317: := last_updated_by_f;
1318: appid fnd_application.application_id%TYPE;
1319: BEGIN
1320: message_init;

Line 1398: value_set_id_i fnd_flex_value_sets.flex_value_set_id%TYPE;

1394: runtime_property_function IN VARCHAR2 DEFAULT NULL)
1395: IS
1396: application_id_i fnd_application.application_id%TYPE;
1397: default_type_i fnd_descr_flex_column_usages.default_type%TYPE;
1398: value_set_id_i fnd_flex_value_sets.flex_value_set_id%TYPE;
1399: range_code_i fnd_descr_flex_column_usages.range_code%TYPE;
1400: dummy NUMBER(1);
1401: BEGIN
1402: message_init;

Line 1435: FROM fnd_flex_value_sets v

1431: ELSIF(value_set IS NOT NULL) THEN
1432: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1433: Decode(validation_type, 'P', 'P', NULL)
1434: INTO range_code_i
1435: FROM fnd_flex_value_sets v
1436: WHERE v.flex_value_set_id = value_set_id_i;
1437: END IF;
1438: EXCEPTION
1439: WHEN no_data_found THEN

Line 1449: FROM fnd_flex_value_sets v

1445: BEGIN
1446: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1447: NULL
1448: INTO dummy
1449: FROM fnd_flex_value_sets v
1450: WHERE v.flex_value_set_id = value_set_id_i
1451: AND Decode(v.validation_type, 'P', 'P', 'A')
1452: = Decode(range_code_i, 'P', 'P', 'A');
1453: EXCEPTION

Line 1494: FROM fnd_flex_value_sets v, fnd_lookup_values vt,

1490: -- this should really be in the value sets package
1491: BEGIN
1492: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1493: NULL INTO dummy
1494: FROM fnd_flex_value_sets v, fnd_lookup_values vt,
1495: fnd_lookup_values ft
1496: WHERE v.flex_value_set_id = value_set_id_i
1497: AND vt.lookup_type = 'SEG_VAL_TYPES'
1498: AND vt.lookup_code = v.validation_type

Line 1511: FROM fnd_flex_value_sets v, fnd_flex_validation_tables t

1507: END;
1508: BEGIN
1509: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1510: NULL INTO dummy
1511: FROM fnd_flex_value_sets v, fnd_flex_validation_tables t
1512: WHERE v.flex_value_set_id = value_set_id_i
1513: AND v.flex_value_set_id = t.flex_value_set_id (+)
1514: AND (application_column_type_i IN ('C', 'V')
1515: OR v.validation_type = 'U'

Line 1761: FROM fnd_flex_value_sets v, fnd_lookup_values vt,

1757: -- this should really be in the value sets package
1758: BEGIN
1759: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1760: NULL INTO dummy
1761: FROM fnd_flex_value_sets v, fnd_lookup_values vt,
1762: fnd_lookup_values ft
1763: WHERE v.flex_value_set_id = l_flex_value_set_id
1764: AND vt.lookup_type = 'SEG_VAL_TYPES'
1765: AND vt.lookup_code = v.validation_type

Line 1800: FROM fnd_flex_value_sets v, fnd_flex_validation_tables t

1796: -- check column type.
1797: BEGIN
1798: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1799: NULL INTO dummy
1800: FROM fnd_flex_value_sets v, fnd_flex_validation_tables t
1801: WHERE v.flex_value_set_id = l_flex_value_set_id
1802: AND v.flex_value_set_id = t.flex_value_set_id (+)
1803: AND (l_column_type IN ('C', 'V')
1804: OR v.validation_type = 'U'

Line 1916: FROM fnd_flex_value_sets

1912: ELSIF (l_flex_value_set_id IS NOT NULL) THEN
1913: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1914: Decode(validation_type, 'P', 'P', NULL)
1915: INTO l_range
1916: FROM fnd_flex_value_sets
1917: WHERE flex_value_set_id = l_flex_value_set_id;
1918: END IF;
1919: EXCEPTION
1920: WHEN no_data_found THEN

Line 1929: FROM fnd_flex_value_sets

1925: BEGIN
1926: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1927: NULL
1928: INTO dummy
1929: FROM fnd_flex_value_sets
1930: WHERE flex_value_set_id = l_flex_value_set_id
1931: AND Decode(validation_type, 'P', 'P', 'A') =
1932: Decode(l_range, 'P', 'P', 'A');
1933: EXCEPTION

Line 2032: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE

2028: PROCEDURE disable_columns(appl_short_name IN VARCHAR2,
2029: flexfield_name IN VARCHAR2,
2030: pattern IN VARCHAR2)
2031: IS
2032: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
2033: := last_update_login_f;
2034: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
2035: := last_update_date_f;
2036: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE

Line 2034: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE

2030: pattern IN VARCHAR2)
2031: IS
2032: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
2033: := last_update_login_f;
2034: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
2035: := last_update_date_f;
2036: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
2037: := last_updated_by_f;
2038: application_id_i fnd_application.application_id%TYPE;

Line 2036: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE

2032: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE
2033: := last_update_login_f;
2034: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE
2035: := last_update_date_f;
2036: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE
2037: := last_updated_by_f;
2038: application_id_i fnd_application.application_id%TYPE;
2039: table_application_id_i fnd_application.application_id%TYPE;
2040: application_table_id_i fnd_tables.table_id%TYPE;