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_VALUE_SETS

Line 7: SUBTYPE vset_type IS fnd_flex_value_sets%ROWTYPE;

3:
4:
5: chr_newline CONSTANT VARCHAR2(8) := fnd_global.newline;
6:
7: SUBTYPE vset_type IS fnd_flex_value_sets%ROWTYPE;
8: SUBTYPE value_type IS fnd_flex_values_vl%ROWTYPE;
9: SUBTYPE noview_value_type IS fnd_flex_values%ROWTYPE;
10:
11: TYPE bind_record_type IS RECORD

Line 348: RETURN fnd_flex_value_sets.flex_value_set_id%TYPE

344: END;
345:
346:
347: FUNCTION value_set_id_f(value_set_name_in IN VARCHAR2)
348: RETURN fnd_flex_value_sets.flex_value_set_id%TYPE
349: IS
350: value_set_id_i fnd_flex_value_sets.flex_value_set_id%TYPE;
351: BEGIN
352: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */

Line 350: value_set_id_i fnd_flex_value_sets.flex_value_set_id%TYPE;

346:
347: FUNCTION value_set_id_f(value_set_name_in IN VARCHAR2)
348: RETURN fnd_flex_value_sets.flex_value_set_id%TYPE
349: IS
350: value_set_id_i fnd_flex_value_sets.flex_value_set_id%TYPE;
351: BEGIN
352: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
353: flex_value_set_id
354: INTO value_set_id_i

Line 355: FROM fnd_flex_value_sets

351: BEGIN
352: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
353: flex_value_set_id
354: INTO value_set_id_i
355: FROM fnd_flex_value_sets
356: WHERE flex_value_set_name = value_set_name_in;
357: RETURN value_set_id_i;
358: EXCEPTION
359: WHEN no_data_found THEN

Line 575: last_update_login fnd_flex_value_sets.last_update_login%TYPE;

571: dependent_default_meaning IN varchar2 DEFAULT null,
572: parent_flex_value_set_id IN number DEFAULT NULL)
573: RETURN number
574: IS
575: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
576: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
577: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
578: creation_date fnd_flex_value_sets.creation_date%TYPE;
579: created_by fnd_flex_value_sets.created_by%TYPE;

Line 576: last_update_date fnd_flex_value_sets.last_update_date%TYPE;

572: parent_flex_value_set_id IN number DEFAULT NULL)
573: RETURN number
574: IS
575: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
576: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
577: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
578: creation_date fnd_flex_value_sets.creation_date%TYPE;
579: created_by fnd_flex_value_sets.created_by%TYPE;
580: rv NUMBER;

Line 577: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;

573: RETURN number
574: IS
575: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
576: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
577: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
578: creation_date fnd_flex_value_sets.creation_date%TYPE;
579: created_by fnd_flex_value_sets.created_by%TYPE;
580: rv NUMBER;
581: BEGIN

Line 578: creation_date fnd_flex_value_sets.creation_date%TYPE;

574: IS
575: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
576: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
577: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
578: creation_date fnd_flex_value_sets.creation_date%TYPE;
579: created_by fnd_flex_value_sets.created_by%TYPE;
580: rv NUMBER;
581: BEGIN
582: last_update_login := last_update_login_f();

Line 579: created_by fnd_flex_value_sets.created_by%TYPE;

575: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
576: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
577: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
578: creation_date fnd_flex_value_sets.creation_date%TYPE;
579: created_by fnd_flex_value_sets.created_by%TYPE;
580: rv NUMBER;
581: BEGIN
582: last_update_login := last_update_login_f();
583: last_update_date := last_update_date_f();

Line 593: fnd_flex_value_sets(flex_value_set_id,

589: check_yesno(alphanumeric_allowed_flag);
590: check_yesno(numeric_mode_enabled_flag);
591: insert /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
592: INTO
593: fnd_flex_value_sets(flex_value_set_id,
594: flex_value_set_name,
595: validation_type,
596: security_enabled_flag,
597: longlist_flag,

Line 617: VALUES(fnd_flex_value_sets_s.nextval,

613:
614: dependant_default_value,/* note spelling */
615: dependant_default_meaning,/* note spelling */
616: parent_flex_value_set_id)
617: VALUES(fnd_flex_value_sets_s.nextval,
618: value_set_name,
619: validation_type,
620: security_enabled_flag,
621: longlist_flag,

Line 646: fnd_flex_value_sets_s.CURRVAL INTO rv

642: println('created value set (type ' || validation_type || ') '
643: || value_set_name);
644:
645: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
646: fnd_flex_value_sets_s.CURRVAL INTO rv
647: FROM dual;
648: RETURN rv;
649: EXCEPTION
650: when dup_val_on_index THEN

Line 666: last_update_login fnd_flex_value_sets.last_update_login%TYPE;

662: flex_value_set_id IN NUMBER,
663: event_code IN varchar2,
664: user_exit IN clob)
665: IS
666: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
667: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
668: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
669: creation_date fnd_flex_value_sets.creation_date%TYPE;
670: created_by fnd_flex_value_sets.created_by%TYPE;

Line 667: last_update_date fnd_flex_value_sets.last_update_date%TYPE;

663: event_code IN varchar2,
664: user_exit IN clob)
665: IS
666: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
667: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
668: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
669: creation_date fnd_flex_value_sets.creation_date%TYPE;
670: created_by fnd_flex_value_sets.created_by%TYPE;
671: BEGIN

Line 668: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;

664: user_exit IN clob)
665: IS
666: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
667: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
668: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
669: creation_date fnd_flex_value_sets.creation_date%TYPE;
670: created_by fnd_flex_value_sets.created_by%TYPE;
671: BEGIN
672: last_update_login := last_update_login_f();

Line 669: creation_date fnd_flex_value_sets.creation_date%TYPE;

665: IS
666: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
667: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
668: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
669: creation_date fnd_flex_value_sets.creation_date%TYPE;
670: created_by fnd_flex_value_sets.created_by%TYPE;
671: BEGIN
672: last_update_login := last_update_login_f();
673: last_update_date := last_update_date_f();

Line 670: created_by fnd_flex_value_sets.created_by%TYPE;

666: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
667: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
668: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
669: creation_date fnd_flex_value_sets.creation_date%TYPE;
670: created_by fnd_flex_value_sets.created_by%TYPE;
671: BEGIN
672: last_update_login := last_update_login_f();
673: last_update_date := last_update_date_f();
674: last_updated_by := last_updated_by_f();

Line 727: last_update_login fnd_flex_value_sets.last_update_login%TYPE;

723: table_application_id IN NUMBER,
724: additional_where_clause IN clob,
725: additional_quickpick_columns IN VARCHAR2)
726: IS
727: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
728: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
729: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
730: creation_date fnd_flex_value_sets.creation_date%TYPE;
731: created_by fnd_flex_value_sets.created_by%TYPE;

Line 728: last_update_date fnd_flex_value_sets.last_update_date%TYPE;

724: additional_where_clause IN clob,
725: additional_quickpick_columns IN VARCHAR2)
726: IS
727: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
728: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
729: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
730: creation_date fnd_flex_value_sets.creation_date%TYPE;
731: created_by fnd_flex_value_sets.created_by%TYPE;
732:

Line 729: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;

725: additional_quickpick_columns IN VARCHAR2)
726: IS
727: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
728: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
729: last_updated_by fnd_flex_value_sets.last_updated_by%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

Line 730: creation_date fnd_flex_value_sets.creation_date%TYPE;

726: IS
727: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
728: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
729: last_updated_by fnd_flex_value_sets.last_updated_by%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;

Line 731: created_by fnd_flex_value_sets.created_by%TYPE;

727: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
728: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
729: last_updated_by fnd_flex_value_sets.last_updated_by%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

Line 884: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

880: right_justify_zero_fill IN varchar2,
881: min_value IN varchar2,
882: max_value IN VARCHAR2)
883: IS
884: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
885: validation_type fnd_flex_value_sets.validation_type%TYPE;
886: format_code fnd_flex_value_sets.format_type%TYPE;
887: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
888: BEGIN

Line 885: validation_type fnd_flex_value_sets.validation_type%TYPE;

881: min_value IN varchar2,
882: max_value IN VARCHAR2)
883: IS
884: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
885: validation_type fnd_flex_value_sets.validation_type%TYPE;
886: format_code fnd_flex_value_sets.format_type%TYPE;
887: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
888: BEGIN
889: validation_type := 'N';

Line 886: format_code fnd_flex_value_sets.format_type%TYPE;

882: max_value IN VARCHAR2)
883: IS
884: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
885: validation_type fnd_flex_value_sets.validation_type%TYPE;
886: format_code fnd_flex_value_sets.format_type%TYPE;
887: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
888: BEGIN
889: validation_type := 'N';
890:

Line 887: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

883: IS
884: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
885: validation_type fnd_flex_value_sets.validation_type%TYPE;
886: format_code fnd_flex_value_sets.format_type%TYPE;
887: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
888: BEGIN
889: validation_type := 'N';
890:
891: message_init;

Line 931: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

927: right_justify_zero_fill IN varchar2,
928: min_value IN varchar2,
929: max_value IN VARCHAR2)
930: IS
931: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
932: validation_type fnd_flex_value_sets.validation_type%TYPE;
933: format_code fnd_flex_value_sets.format_type%TYPE;
934: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
935: BEGIN

Line 932: validation_type fnd_flex_value_sets.validation_type%TYPE;

928: min_value IN varchar2,
929: max_value IN VARCHAR2)
930: IS
931: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
932: validation_type fnd_flex_value_sets.validation_type%TYPE;
933: format_code fnd_flex_value_sets.format_type%TYPE;
934: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
935: BEGIN
936: validation_type := 'I';

Line 933: format_code fnd_flex_value_sets.format_type%TYPE;

929: max_value IN VARCHAR2)
930: IS
931: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
932: validation_type fnd_flex_value_sets.validation_type%TYPE;
933: format_code fnd_flex_value_sets.format_type%TYPE;
934: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
935: BEGIN
936: validation_type := 'I';
937:

Line 934: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

930: IS
931: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
932: validation_type fnd_flex_value_sets.validation_type%TYPE;
933: format_code fnd_flex_value_sets.format_type%TYPE;
934: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
935: BEGIN
936: validation_type := 'I';
937:
938: message_init;

Line 982: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

978: parent_flex_value_set IN VARCHAR2,
979: dependent_default_value IN varchar2,
980: dependent_default_meaning IN VARCHAR2)
981: IS
982: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
983: parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
984: validation_type fnd_flex_value_sets.validation_type%TYPE;
985: format_code fnd_flex_value_sets.format_type%TYPE;
986: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

Line 983: parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;

979: dependent_default_value IN varchar2,
980: dependent_default_meaning IN VARCHAR2)
981: IS
982: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
983: parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
984: validation_type fnd_flex_value_sets.validation_type%TYPE;
985: format_code fnd_flex_value_sets.format_type%TYPE;
986: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
987: BEGIN

Line 984: validation_type fnd_flex_value_sets.validation_type%TYPE;

980: dependent_default_meaning IN VARCHAR2)
981: IS
982: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
983: parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
984: validation_type fnd_flex_value_sets.validation_type%TYPE;
985: format_code fnd_flex_value_sets.format_type%TYPE;
986: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
987: BEGIN
988: validation_type := 'D';

Line 985: format_code fnd_flex_value_sets.format_type%TYPE;

981: IS
982: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
983: parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
984: validation_type fnd_flex_value_sets.validation_type%TYPE;
985: format_code fnd_flex_value_sets.format_type%TYPE;
986: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
987: BEGIN
988: validation_type := 'D';
989:

Line 986: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

982: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
983: parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
984: validation_type fnd_flex_value_sets.validation_type%TYPE;
985: format_code fnd_flex_value_sets.format_type%TYPE;
986: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
987: BEGIN
988: validation_type := 'D';
989:
990: message_init;

Line 996: FROM fnd_flex_value_sets

992: alphanumeric_allowed := invert_flag_f(numbers_only);
993: BEGIN
994: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
995: flex_value_set_id INTO parent_id
996: FROM fnd_flex_value_sets
997: WHERE flex_value_set_name = parent_flex_value_set;
998: /* the where clause is on a unique key, so 0 or 1 hits expected. */
999: EXCEPTION
1000: WHEN no_data_found THEN

Line 1069: validation_type fnd_flex_value_sets.validation_type%TYPE;

1065: id_column_size IN number DEFAULT NULL,
1066: where_order_by IN varchar2 DEFAULT NULL,
1067: additional_columns IN VARCHAR2 DEFAULT NULL)
1068: IS
1069: validation_type fnd_flex_value_sets.validation_type%TYPE;
1070: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1071: table_application_id_i fnd_application.application_id%TYPE;
1072: format_code fnd_flex_value_sets.format_type%TYPE;
1073: value_column_type_code fnd_flex_value_sets.format_type%TYPE;

Line 1070: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

1066: where_order_by IN varchar2 DEFAULT NULL,
1067: additional_columns IN VARCHAR2 DEFAULT NULL)
1068: IS
1069: validation_type fnd_flex_value_sets.validation_type%TYPE;
1070: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1071: table_application_id_i fnd_application.application_id%TYPE;
1072: format_code fnd_flex_value_sets.format_type%TYPE;
1073: value_column_type_code fnd_flex_value_sets.format_type%TYPE;
1074: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;

Line 1072: format_code fnd_flex_value_sets.format_type%TYPE;

1068: IS
1069: validation_type fnd_flex_value_sets.validation_type%TYPE;
1070: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1071: table_application_id_i fnd_application.application_id%TYPE;
1072: format_code fnd_flex_value_sets.format_type%TYPE;
1073: value_column_type_code fnd_flex_value_sets.format_type%TYPE;
1074: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;
1075: id_column_type_code fnd_flex_value_sets.format_type%TYPE;
1076: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

Line 1073: value_column_type_code fnd_flex_value_sets.format_type%TYPE;

1069: validation_type fnd_flex_value_sets.validation_type%TYPE;
1070: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1071: table_application_id_i fnd_application.application_id%TYPE;
1072: format_code fnd_flex_value_sets.format_type%TYPE;
1073: value_column_type_code fnd_flex_value_sets.format_type%TYPE;
1074: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;
1075: id_column_type_code fnd_flex_value_sets.format_type%TYPE;
1076: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1077: l_result VARCHAR2(10);

Line 1074: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;

1070: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1071: table_application_id_i fnd_application.application_id%TYPE;
1072: format_code fnd_flex_value_sets.format_type%TYPE;
1073: value_column_type_code fnd_flex_value_sets.format_type%TYPE;
1074: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;
1075: id_column_type_code fnd_flex_value_sets.format_type%TYPE;
1076: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1077: l_result VARCHAR2(10);
1078: l_message VARCHAR2(32000);

Line 1075: id_column_type_code fnd_flex_value_sets.format_type%TYPE;

1071: table_application_id_i fnd_application.application_id%TYPE;
1072: format_code fnd_flex_value_sets.format_type%TYPE;
1073: value_column_type_code fnd_flex_value_sets.format_type%TYPE;
1074: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;
1075: id_column_type_code fnd_flex_value_sets.format_type%TYPE;
1076: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1077: l_result VARCHAR2(10);
1078: l_message VARCHAR2(32000);
1079: BEGIN

Line 1076: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

1072: format_code fnd_flex_value_sets.format_type%TYPE;
1073: value_column_type_code fnd_flex_value_sets.format_type%TYPE;
1074: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;
1075: id_column_type_code fnd_flex_value_sets.format_type%TYPE;
1076: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1077: l_result VARCHAR2(10);
1078: l_message VARCHAR2(32000);
1079: BEGIN
1080: validation_type := 'F';

Line 1177: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

1173: right_justify_zero_fill IN varchar2,
1174: min_value IN varchar2,
1175: max_value IN VARCHAR2)
1176: IS
1177: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1178: validation_type fnd_flex_value_sets.validation_type%TYPE;
1179: format_code fnd_flex_value_sets.format_type%TYPE;
1180: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1181: BEGIN

Line 1178: validation_type fnd_flex_value_sets.validation_type%TYPE;

1174: min_value IN varchar2,
1175: max_value IN VARCHAR2)
1176: IS
1177: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1178: validation_type fnd_flex_value_sets.validation_type%TYPE;
1179: format_code fnd_flex_value_sets.format_type%TYPE;
1180: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1181: BEGIN
1182: validation_type := 'U';

Line 1179: format_code fnd_flex_value_sets.format_type%TYPE;

1175: max_value IN VARCHAR2)
1176: IS
1177: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1178: validation_type fnd_flex_value_sets.validation_type%TYPE;
1179: format_code fnd_flex_value_sets.format_type%TYPE;
1180: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1181: BEGIN
1182: validation_type := 'U';
1183:

Line 1180: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

1176: IS
1177: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1178: validation_type fnd_flex_value_sets.validation_type%TYPE;
1179: format_code fnd_flex_value_sets.format_type%TYPE;
1180: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1181: BEGIN
1182: validation_type := 'U';
1183:
1184: message_init;

Line 1226: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

1222: right_justify_zero_fill IN varchar2,
1223: min_value IN varchar2,
1224: max_value IN VARCHAR2)
1225: IS
1226: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1227: validation_type fnd_flex_value_sets.validation_type%TYPE;
1228: format_code fnd_flex_value_sets.format_type%TYPE;
1229: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1230: BEGIN

Line 1227: validation_type fnd_flex_value_sets.validation_type%TYPE;

1223: min_value IN varchar2,
1224: max_value IN VARCHAR2)
1225: IS
1226: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1227: validation_type fnd_flex_value_sets.validation_type%TYPE;
1228: format_code fnd_flex_value_sets.format_type%TYPE;
1229: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1230: BEGIN
1231: validation_type := 'P';

Line 1228: format_code fnd_flex_value_sets.format_type%TYPE;

1224: max_value IN VARCHAR2)
1225: IS
1226: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1227: validation_type fnd_flex_value_sets.validation_type%TYPE;
1228: format_code fnd_flex_value_sets.format_type%TYPE;
1229: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1230: BEGIN
1231: validation_type := 'P';
1232:

Line 1229: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

1225: IS
1226: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1227: validation_type fnd_flex_value_sets.validation_type%TYPE;
1228: format_code fnd_flex_value_sets.format_type%TYPE;
1229: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1230: BEGIN
1231: validation_type := 'P';
1232:
1233: message_init;

Line 1264: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

1260: event IN VARCHAR2,
1261: function_text IN clob)
1262: IS
1263: event_code fnd_flex_validation_events.event_code%TYPE;
1264: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1265: BEGIN
1266: message_init;
1267: value_set_id := value_set_id_f(value_set_name);
1268: -- get the event code from the event name

Line 1294: FROM fnd_flex_value_sets

1290: BEGIN
1291: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1292: flex_value_set_id
1293: INTO l_value_set_id
1294: FROM fnd_flex_value_sets
1295: WHERE flex_value_set_name = p_value_set;
1296: EXCEPTION
1297: WHEN no_data_found THEN
1298: message('could not find value set: ' || p_value_set);

Line 1320: FROM fnd_flex_value_sets

1316: -- Is this value set a parent value set?
1317: --
1318: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1319: count(*) INTO l_row_count
1320: FROM fnd_flex_value_sets
1321: WHERE validation_type = fnd_flex_types.val_dependent
1322: AND parent_flex_value_set_id = l_value_set_id;
1323:
1324: IF (l_row_count <> 0) THEN

Line 1511: FROM fnd_flex_value_sets

1507: --
1508: -- Delete the value set from main table.
1509: --
1510: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1511: FROM fnd_flex_value_sets
1512: WHERE flex_value_set_id = l_value_set_id;
1513:
1514: --
1515: -- Delete the FND_FLEX_VALUES Descriptive Flexfield context associated

Line 1578: FROM fnd_flex_value_sets

1574: BEGIN
1575: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1576: flex_value_set_id
1577: INTO old_value_set_id
1578: FROM fnd_flex_value_sets
1579: WHERE flex_value_set_name = old_value_set;
1580: EXCEPTION
1581: WHEN no_data_found THEN
1582: message('could not find original value set: ' || old_value_set);

Line 1592: FROM fnd_flex_value_sets

1588: BEGIN
1589: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1590: flex_value_set_id
1591: INTO new_value_set_id
1592: FROM fnd_flex_value_sets
1593: WHERE flex_value_set_name = new_value_set;
1594: EXCEPTION
1595: WHEN no_data_found THEN
1596: message('could not find new value set: ' || new_value_set);

Line 1614: fnd_flex_value_sets SET

1610:
1611: /* rename the new value set, and change the id */
1612: BEGIN
1613: UPDATE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1614: fnd_flex_value_sets SET
1615: flex_value_set_id = old_value_set_id,
1616: flex_value_set_name = old_value_set
1617: WHERE flex_value_set_id = new_value_set_id;
1618: END;

Line 1639: fnd_flex_value_sets SET

1635: WHEN no_data_found THEN NULL;
1636: END;
1637: BEGIN
1638: UPDATE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1639: fnd_flex_value_sets SET
1640: parent_flex_value_set_id = old_value_set_id
1641: WHERE parent_flex_value_set_id = new_value_set_id;
1642: EXCEPTION
1643: WHEN no_data_found THEN NULL;

Line 1660: FROM fnd_flex_value_sets

1656: BEGIN
1657: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1658: COUNT(*)
1659: INTO cnt
1660: FROM fnd_flex_value_sets
1661: WHERE flex_value_set_name = value_set;
1662: IF(cnt > 0) THEN
1663: RETURN TRUE;
1664: ELSE

Line 1670: PROCEDURE crosscheck_size(valueset_r IN fnd_flex_value_sets%ROWTYPE);

1666: END IF;
1667: END;
1668:
1669:
1670: PROCEDURE crosscheck_size(valueset_r IN fnd_flex_value_sets%ROWTYPE);
1671: PROCEDURE check_precision(valueset_r IN OUT nocopy fnd_flex_value_sets%ROWTYPE);
1672:
1673:
1674: PROCEDURE update_maxsize(

Line 1671: PROCEDURE check_precision(valueset_r IN OUT nocopy fnd_flex_value_sets%ROWTYPE);

1667: END;
1668:
1669:
1670: PROCEDURE crosscheck_size(valueset_r IN fnd_flex_value_sets%ROWTYPE);
1671: PROCEDURE check_precision(valueset_r IN OUT nocopy fnd_flex_value_sets%ROWTYPE);
1672:
1673:
1674: PROCEDURE update_maxsize(
1675: value_set_name IN VARCHAR2,

Line 1676: maxsize IN fnd_flex_value_sets.maximum_size%TYPE)

1672:
1673:
1674: PROCEDURE update_maxsize(
1675: value_set_name IN VARCHAR2,
1676: maxsize IN fnd_flex_value_sets.maximum_size%TYPE)
1677: IS
1678: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1679: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1680: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;

Line 1678: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;

1674: PROCEDURE update_maxsize(
1675: value_set_name IN VARCHAR2,
1676: maxsize IN fnd_flex_value_sets.maximum_size%TYPE)
1677: IS
1678: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1679: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1680: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1681:
1682: valueset_r fnd_flex_value_sets%ROWTYPE;

Line 1679: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;

1675: value_set_name IN VARCHAR2,
1676: maxsize IN fnd_flex_value_sets.maximum_size%TYPE)
1677: IS
1678: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1679: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1680: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1681:
1682: valueset_r fnd_flex_value_sets%ROWTYPE;
1683: maxsize_old NUMBER;

Line 1680: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;

1676: maxsize IN fnd_flex_value_sets.maximum_size%TYPE)
1677: IS
1678: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1679: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1680: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1681:
1682: valueset_r fnd_flex_value_sets%ROWTYPE;
1683: maxsize_old NUMBER;
1684: BEGIN

Line 1682: valueset_r fnd_flex_value_sets%ROWTYPE;

1678: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1679: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1680: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1681:
1682: valueset_r fnd_flex_value_sets%ROWTYPE;
1683: maxsize_old NUMBER;
1684: BEGIN
1685: last_update_login_i := last_update_login_f();
1686: last_update_date_i := last_update_date_f();

Line 1694: FROM fnd_flex_value_sets

1690: BEGIN
1691: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1692: *
1693: INTO valueset_r
1694: FROM fnd_flex_value_sets
1695: WHERE flex_value_set_name = value_set_name;
1696: EXCEPTION
1697: WHEN no_data_found THEN
1698: message('could not find valueset ' || value_set_name);

Line 1763: fnd_flex_value_sets SET

1759:
1760: BEGIN
1761: IF(customer_mode) THEN
1762: UPDATE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1763: fnd_flex_value_sets SET
1764: maximum_size = valueset_r.maximum_size,
1765: number_precision = valueset_r.number_precision,
1766: last_update_date = last_update_date_i,
1767: last_updated_by = last_updated_by_i,

Line 1772: fnd_flex_value_sets SET

1768: last_update_login = last_update_login_i
1769: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1770: ELSE
1771: UPDATE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1772: fnd_flex_value_sets SET
1773: maximum_size = valueset_r.maximum_size,
1774: number_precision = valueset_r.number_precision
1775: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1776: END IF;

Line 1779: message('error updating fnd_flex_value_sets: ' || Sqlerrm);

1775: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1776: END IF;
1777: EXCEPTION
1778: WHEN OTHERS THEN
1779: message('error updating fnd_flex_value_sets: ' || Sqlerrm);
1780: RAISE;
1781: END;
1782: EXCEPTION
1783: WHEN OTHERS THEN

Line 1796: PROCEDURE crosscheck_size(valueset_r IN fnd_flex_value_sets%ROWTYPE)

1792: -- Cross check maximum size against table value column size, reducing
1793: -- maximum size if needed. Do not do cross check if not table-validated
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

Line 1832: PROCEDURE check_precision(valueset_r IN OUT nocopy fnd_flex_value_sets%ROWTYPE)

1828:
1829:
1830: -- Make sure precision < Max size (if both are non-null)
1831:
1832: PROCEDURE check_precision(valueset_r IN OUT nocopy fnd_flex_value_sets%ROWTYPE)
1833: IS
1834: BEGIN
1835: IF((valueset_r.maximum_size IS NOT NULL) AND
1836: (valueset_r.number_precision IS NOT NULL) AND

Line 1843: PROCEDURE check_id_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,

1839: END IF;
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);

Line 1846: PROCEDURE check_meaning_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,

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:
1849:
1850: PROCEDURE update_table_sizes(

Line 1859: last_update_login_i fnd_flex_value_sets.last_update_login%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;
1861: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1862:
1863: valueset_r fnd_flex_value_sets%ROWTYPE;

Line 1860: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;

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;
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;

Line 1861: last_updated_by_i fnd_flex_value_sets.last_updated_by%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;
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

Line 1863: valueset_r fnd_flex_value_sets%ROWTYPE;

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;
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();

Line 1875: FROM fnd_flex_value_sets

1871: BEGIN
1872: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1873: *
1874: INTO valueset_r
1875: FROM fnd_flex_value_sets
1876: WHERE flex_value_set_name = value_set_name;
1877: EXCEPTION
1878: WHEN no_data_found THEN
1879: message('could not find valueset ' || value_set_name);

Line 1947: PROCEDURE check_id_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,

1943: RAISE bad_parameter;
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

Line 1979: PROCEDURE check_meaning_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,

1975: message('check id size failed: ' || Sqlerrm);
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

Line 2033: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

2029: END add_to_select;
2030:
2031: PROCEDURE get_valueset_select
2032: (p_validation_type IN VARCHAR2,
2033: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2034: DEFAULT fnd_api.g_miss_char,
2035: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2036: DEFAULT fnd_api.g_miss_num,
2037: p_independent_value IN VARCHAR2 DEFAULT NULL,

Line 2035: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

2031: PROCEDURE get_valueset_select
2032: (p_validation_type IN VARCHAR2,
2033: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2034: DEFAULT fnd_api.g_miss_char,
2035: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2036: DEFAULT fnd_api.g_miss_num,
2037: p_independent_value IN VARCHAR2 DEFAULT NULL,
2038: --
2039: -- Do you want to include these columns in SELECT statement?

Line 2069: l_vset fnd_flex_value_sets%ROWTYPE;

2065: x_mapping_code OUT nocopy VARCHAR2,
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);

Line 2109: FROM fnd_flex_value_sets

2105: BEGIN
2106: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
2107: *
2108: INTO l_vset
2109: FROM fnd_flex_value_sets
2110: WHERE ( (p_value_set_id = fnd_api.g_miss_num
2111: AND flex_value_set_name = p_value_set_name)
2112: OR (p_value_set_name = fnd_api.g_miss_char
2113: AND flex_value_set_id = p_value_set_id));

Line 2120: message(l_func_name || 'SELECT FROM fnd_flex_value_sets is failed.' ||

2116: message(l_func_name || 'Value set does not exist.');
2117: x_success := g_ret_no_value_set;
2118: RETURN;
2119: WHEN OTHERS THEN
2120: message(l_func_name || 'SELECT FROM fnd_flex_value_sets is failed.' ||
2121: chr_newline || 'Error : ' || Sqlerrm);
2122: x_success := g_ret_others;
2123: RETURN;
2124: END;

Line 2316: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

2312: x_success := g_ret_others;
2313: END get_valueset_select;
2314:
2315: PROCEDURE get_table_vset_select
2316: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2317: DEFAULT fnd_api.g_miss_char,
2318: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2319: DEFAULT fnd_api.g_miss_num,
2320: --

Line 2318: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

2314:
2315: PROCEDURE get_table_vset_select
2316: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2317: DEFAULT fnd_api.g_miss_char,
2318: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2319: DEFAULT fnd_api.g_miss_num,
2320: --
2321: -- Do you want to include these columns in SELECT statement?
2322: -- VALUE column is always included.

Line 2394: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

2390: x_success := g_ret_others;
2391: END get_table_vset_select;
2392:
2393: PROCEDURE get_independent_vset_select
2394: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2395: DEFAULT fnd_api.g_miss_char,
2396: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2397: DEFAULT fnd_api.g_miss_num,
2398: --

Line 2396: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

2392:
2393: PROCEDURE get_independent_vset_select
2394: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2395: DEFAULT fnd_api.g_miss_char,
2396: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2397: DEFAULT fnd_api.g_miss_num,
2398: --
2399: -- Do you want to include these columns in SELECT statement?
2400: -- VALUE column is always included.

Line 2468: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

2464: x_success := g_ret_others;
2465: END get_independent_vset_select;
2466:
2467: PROCEDURE get_dependent_vset_select
2468: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2469: DEFAULT fnd_api.g_miss_char,
2470: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2471: DEFAULT fnd_api.g_miss_num,
2472: p_independent_value IN VARCHAR2 DEFAULT NULL,

Line 2470: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

2466:
2467: PROCEDURE get_dependent_vset_select
2468: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2469: DEFAULT fnd_api.g_miss_char,
2470: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2471: DEFAULT fnd_api.g_miss_num,
2472: p_independent_value IN VARCHAR2 DEFAULT NULL,
2473: --
2474: -- Do you want to include these columns in SELECT statement?

Line 2547: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;

2543: p_table_name IN fnd_tables.table_name%TYPE,
2544: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2545: IS
2546: up_table_name fnd_tables.table_name%TYPE;
2547: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2548: BEGIN
2549: up_table_name := Upper(p_table_name);
2550:
2551: x_message := 'This table is not used by Flexfield Value Sets';

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 2594: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;

2590: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2591: IS
2592: up_table_name fnd_tables.table_name%TYPE;
2593: up_column_name fnd_columns.column_name%TYPE;
2594: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2595: BEGIN
2596: up_table_name := Upper(p_table_name);
2597: up_column_name := Upper(p_column_name);
2598:

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 2663: FROM fnd_flex_value_sets

2659: IF (p_flex_value_set_name IS NOT NULL) THEN
2660: BEGIN
2661: SELECT *
2662: INTO x_vset
2663: FROM fnd_flex_value_sets
2664: WHERE flex_value_set_name = p_flex_value_set_name;
2665: EXCEPTION
2666: WHEN OTHERS THEN
2667: raise_error(ERROR_UNABLE_TO_FIND_VSET_NAME,

Line 2675: FROM fnd_flex_value_sets

2671: ELSIF (p_flex_value_set_id IS NOT NULL) THEN
2672: BEGIN
2673: SELECT *
2674: INTO x_vset
2675: FROM fnd_flex_value_sets
2676: WHERE flex_value_set_id = p_flex_value_set_id;
2677: EXCEPTION
2678: WHEN OTHERS THEN
2679: raise_error(ERROR_UNABLE_TO_FIND_VSET_ID,

Line 3839: fnd_flex_value_sets v,

3835: l_validation_type, l_format_type, l_maximum_size,
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(+);

Line 3853: fnd_flex_value_sets v,

3849: c.column_type, c.width
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

Line 4083: fnd_flex_value_sets v, fnd_id_flex_segments s

4079: s.segment_num, v.parent_flex_value_set_id
4080: INTO
4081: l_segment_num, l_parent_value_set_id
4082: FROM
4083: fnd_flex_value_sets v, fnd_id_flex_segments s
4084: WHERE
4085: v.flex_value_set_id = p_value_set_id
4086: AND s.id_flex_num = p_id_flex_num
4087: AND v.parent_flex_value_set_id = s.flex_value_set_id;

Line 4093: from fnd_flex_value_sets

4089: IF(NOT(l_segment_num < p_segment_num)) THEN
4090:
4091: select flex_value_set_name
4092: into l_parent_value_set_name
4093: from fnd_flex_value_sets
4094: where
4095: flex_value_set_id=l_parent_value_set_id;
4096:
4097: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');

Line 4109: from fnd_flex_value_sets

4105: WHEN NO_DATA_FOUND THEN
4106:
4107: select flex_value_set_name
4108: into l_parent_value_set_name
4109: from fnd_flex_value_sets
4110: where
4111: flex_value_set_id in (select parent_flex_value_set_id
4112: from fnd_flex_value_sets
4113: where flex_value_set_id=p_value_set_id);

Line 4112: from fnd_flex_value_sets

4108: into l_parent_value_set_name
4109: from fnd_flex_value_sets
4110: where
4111: flex_value_set_id in (select parent_flex_value_set_id
4112: from fnd_flex_value_sets
4113: where flex_value_set_id=p_value_set_id);
4114:
4115: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
4116: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

Line 4142: fnd_flex_value_sets v, fnd_descr_flex_column_usages u

4138: u.column_seq_num, v.parent_flex_value_set_id
4139: INTO
4140: l_column_seq_num, l_parent_value_set_id
4141: FROM
4142: fnd_flex_value_sets v, fnd_descr_flex_column_usages u
4143: WHERE
4144: v.flex_value_set_id = p_value_set_id and
4145: -- Bug#4410208, In SRS agruments form there is no context code
4146: (p_desc_flex_context_code is null or

Line 4154: from fnd_flex_value_sets

4150: IF(NOT(l_column_seq_num < p_column_seq_num)) THEN
4151:
4152: select flex_value_set_name
4153: into l_parent_value_set_name
4154: from fnd_flex_value_sets
4155: where
4156: flex_value_set_id=l_parent_value_set_id;
4157:
4158: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');

Line 4169: from fnd_flex_value_sets

4165: WHEN NO_DATA_FOUND THEN
4166:
4167: select flex_value_set_name
4168: into l_parent_value_set_name
4169: from fnd_flex_value_sets
4170: where
4171: flex_value_set_id in (select parent_flex_value_set_id
4172: from fnd_flex_value_sets
4173: where flex_value_set_id=p_value_set_id);

Line 4172: from fnd_flex_value_sets

4168: into l_parent_value_set_name
4169: from fnd_flex_value_sets
4170: where
4171: flex_value_set_id in (select parent_flex_value_set_id
4172: from fnd_flex_value_sets
4173: where flex_value_set_id=p_value_set_id);
4174:
4175: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
4176: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

Line 4198: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,

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,
4202: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)

Line 4199: p_format_type IN fnd_flex_value_sets.format_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,
4202: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)
4203: IS

Line 4200: p_maximum_size IN fnd_flex_value_sets.maximum_size%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,
4202: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)
4203: IS
4204:

Line 4201: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%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,
4202: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)
4203: IS
4204:
4205: l_format_type_name VARCHAR2(80);

Line 4300: p_format_type IN fnd_flex_value_sets.format_type%TYPE,

4296:
4297: END check_base_table_column;
4298:
4299: PROCEDURE is_vset_obsolete(
4300: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4301: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4302: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)
4303: IS
4304: BEGIN

Line 4301: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,

4297: END check_base_table_column;
4298:
4299: PROCEDURE is_vset_obsolete(
4300: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4301: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4302: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)
4303: IS
4304: BEGIN
4305:

Line 4330: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,

4326: -- the user a chance to see why he cannot attach a vset to a
4327: -- certain segment. Now we have a separate procedure for DFF/SRS.
4328:
4329: PROCEDURE is_value_set_allowed_dff
4330: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4331: p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,
4332: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
4333: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
4334: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,

Line 4415: fnd_flex_value_sets v,

4411: l_validation_type, l_format_type, l_maximum_size,
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(+);

Line 4458: fnd_flex_value_sets v, fnd_descr_flex_column_usages u

4454: min(u.column_seq_num), v.parent_flex_value_set_id
4455: INTO
4456: l_column_seq_num, l_parent_value_set_id
4457: FROM
4458: fnd_flex_value_sets v, fnd_descr_flex_column_usages u
4459: WHERE
4460: v.flex_value_set_id = p_flex_value_set_id
4461: -- Bug#4564981
4462: AND u.application_id = p_application_id

Line 4474: from fnd_flex_value_sets

4470: IF(NOT(l_column_seq_num < p_column_seq_num)) THEN
4471:
4472: select flex_value_set_name
4473: into l_parent_value_set_name
4474: from fnd_flex_value_sets
4475: where
4476: flex_value_set_id=l_parent_value_set_id;
4477:
4478: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');

Line 4489: from fnd_flex_value_sets

4485: WHEN NO_DATA_FOUND THEN
4486:
4487: select flex_value_set_name
4488: into l_parent_value_set_name
4489: from fnd_flex_value_sets
4490: where
4491: flex_value_set_id in (select parent_flex_value_set_id
4492: from fnd_flex_value_sets
4493: where flex_value_set_id=p_flex_value_set_id);

Line 4492: from fnd_flex_value_sets

4488: into l_parent_value_set_name
4489: from fnd_flex_value_sets
4490: where
4491: flex_value_set_id in (select parent_flex_value_set_id
4492: from fnd_flex_value_sets
4493: where flex_value_set_id=p_flex_value_set_id);
4494:
4495: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
4496: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

Line 4521: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,

4517: -- the user a chance to see why he cannot attach a vset to a
4518: -- certain segment. Now we have a separate procedure for KFF.
4519:
4520: PROCEDURE is_value_set_allowed_kff
4521: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4522: p_application_id IN fnd_id_flex_segments.application_id%TYPE,
4523: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
4524: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
4525: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,

Line 4583: fnd_flex_value_sets v,

4579: l_validation_type, l_format_type, l_maximum_size,
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(+);

Line 4693: fnd_flex_value_sets v, fnd_id_flex_segments s

4689: min(s.segment_num), v.parent_flex_value_set_id
4690: INTO
4691: l_segment_num, l_parent_value_set_id
4692: FROM
4693: fnd_flex_value_sets v, fnd_id_flex_segments s
4694: WHERE
4695: v.flex_value_set_id = p_flex_value_set_id
4696: -- Bug#4564981
4697: AND s.application_id = p_application_id

Line 4707: from fnd_flex_value_sets

4703: IF(NOT(l_segment_num < p_segment_num)) THEN
4704:
4705: select flex_value_set_name
4706: into l_parent_value_set_name
4707: from fnd_flex_value_sets
4708: where
4709: flex_value_set_id=l_parent_value_set_id;
4710:
4711: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');

Line 4723: from fnd_flex_value_sets

4719: WHEN NO_DATA_FOUND THEN
4720:
4721: select flex_value_set_name
4722: into l_parent_value_set_name
4723: from fnd_flex_value_sets
4724: where
4725: flex_value_set_id in (select parent_flex_value_set_id
4726: from fnd_flex_value_sets
4727: where flex_value_set_id=p_flex_value_set_id);

Line 4726: from fnd_flex_value_sets

4722: into l_parent_value_set_name
4723: from fnd_flex_value_sets
4724: where
4725: flex_value_set_id in (select parent_flex_value_set_id
4726: from fnd_flex_value_sets
4727: where flex_value_set_id=p_flex_value_set_id);
4728:
4729: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
4730: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

Line 4949: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,

4945:
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,