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:
10: TYPE bind_record_type IS RECORD
11: (pos number,

Line 347: RETURN fnd_flex_value_sets.flex_value_set_id%TYPE

343: END;
344:
345:
346: FUNCTION value_set_id_f(value_set_name_in IN VARCHAR2)
347: RETURN fnd_flex_value_sets.flex_value_set_id%TYPE
348: IS
349: value_set_id_i fnd_flex_value_sets.flex_value_set_id%TYPE;
350: BEGIN
351: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */

Line 349: value_set_id_i fnd_flex_value_sets.flex_value_set_id%TYPE;

345:
346: FUNCTION value_set_id_f(value_set_name_in IN VARCHAR2)
347: RETURN fnd_flex_value_sets.flex_value_set_id%TYPE
348: IS
349: value_set_id_i fnd_flex_value_sets.flex_value_set_id%TYPE;
350: BEGIN
351: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
352: flex_value_set_id
353: INTO value_set_id_i

Line 354: FROM fnd_flex_value_sets

350: BEGIN
351: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
352: flex_value_set_id
353: INTO value_set_id_i
354: FROM fnd_flex_value_sets
355: WHERE flex_value_set_name = value_set_name_in;
356: RETURN value_set_id_i;
357: EXCEPTION
358: WHEN no_data_found THEN

Line 564: last_update_login fnd_flex_value_sets.last_update_login%TYPE;

560: dependent_default_meaning IN varchar2 DEFAULT null,
561: parent_flex_value_set_id IN number DEFAULT NULL)
562: RETURN number
563: IS
564: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
565: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
566: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
567: creation_date fnd_flex_value_sets.creation_date%TYPE;
568: created_by fnd_flex_value_sets.created_by%TYPE;

Line 565: last_update_date fnd_flex_value_sets.last_update_date%TYPE;

561: parent_flex_value_set_id IN number DEFAULT NULL)
562: RETURN number
563: IS
564: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
565: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
566: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
567: creation_date fnd_flex_value_sets.creation_date%TYPE;
568: created_by fnd_flex_value_sets.created_by%TYPE;
569: rv NUMBER;

Line 566: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;

562: RETURN number
563: IS
564: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
565: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
566: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
567: creation_date fnd_flex_value_sets.creation_date%TYPE;
568: created_by fnd_flex_value_sets.created_by%TYPE;
569: rv NUMBER;
570: BEGIN

Line 567: creation_date fnd_flex_value_sets.creation_date%TYPE;

563: IS
564: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
565: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
566: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
567: creation_date fnd_flex_value_sets.creation_date%TYPE;
568: created_by fnd_flex_value_sets.created_by%TYPE;
569: rv NUMBER;
570: BEGIN
571: last_update_login := last_update_login_f();

Line 568: created_by fnd_flex_value_sets.created_by%TYPE;

564: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
565: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
566: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
567: creation_date fnd_flex_value_sets.creation_date%TYPE;
568: created_by fnd_flex_value_sets.created_by%TYPE;
569: rv NUMBER;
570: BEGIN
571: last_update_login := last_update_login_f();
572: last_update_date := last_update_date_f();

Line 582: fnd_flex_value_sets(flex_value_set_id,

578: check_yesno(alphanumeric_allowed_flag);
579: check_yesno(numeric_mode_enabled_flag);
580: insert /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
581: INTO
582: fnd_flex_value_sets(flex_value_set_id,
583: flex_value_set_name,
584: validation_type,
585: security_enabled_flag,
586: longlist_flag,

Line 606: VALUES(fnd_flex_value_sets_s.nextval,

602:
603: dependant_default_value,/* note spelling */
604: dependant_default_meaning,/* note spelling */
605: parent_flex_value_set_id)
606: VALUES(fnd_flex_value_sets_s.nextval,
607: value_set_name,
608: validation_type,
609: security_enabled_flag,
610: longlist_flag,

Line 635: fnd_flex_value_sets_s.CURRVAL INTO rv

631: println('created value set (type ' || validation_type || ') '
632: || value_set_name);
633:
634: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
635: fnd_flex_value_sets_s.CURRVAL INTO rv
636: FROM dual;
637: RETURN rv;
638: EXCEPTION
639: when dup_val_on_index THEN

Line 655: last_update_login fnd_flex_value_sets.last_update_login%TYPE;

651: flex_value_set_id IN NUMBER,
652: event_code IN varchar2,
653: user_exit IN long)
654: IS
655: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
656: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
657: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
658: creation_date fnd_flex_value_sets.creation_date%TYPE;
659: created_by fnd_flex_value_sets.created_by%TYPE;

Line 656: last_update_date fnd_flex_value_sets.last_update_date%TYPE;

652: event_code IN varchar2,
653: user_exit IN long)
654: IS
655: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
656: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
657: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
658: creation_date fnd_flex_value_sets.creation_date%TYPE;
659: created_by fnd_flex_value_sets.created_by%TYPE;
660: BEGIN

Line 657: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;

653: user_exit IN long)
654: IS
655: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
656: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
657: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
658: creation_date fnd_flex_value_sets.creation_date%TYPE;
659: created_by fnd_flex_value_sets.created_by%TYPE;
660: BEGIN
661: last_update_login := last_update_login_f();

Line 658: creation_date fnd_flex_value_sets.creation_date%TYPE;

654: IS
655: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
656: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
657: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
658: creation_date fnd_flex_value_sets.creation_date%TYPE;
659: created_by fnd_flex_value_sets.created_by%TYPE;
660: BEGIN
661: last_update_login := last_update_login_f();
662: last_update_date := last_update_date_f();

Line 659: created_by fnd_flex_value_sets.created_by%TYPE;

655: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
656: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
657: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
658: creation_date fnd_flex_value_sets.creation_date%TYPE;
659: created_by fnd_flex_value_sets.created_by%TYPE;
660: BEGIN
661: last_update_login := last_update_login_f();
662: last_update_date := last_update_date_f();
663: last_updated_by := last_updated_by_f();

Line 716: last_update_login fnd_flex_value_sets.last_update_login%TYPE;

712: table_application_id IN NUMBER,
713: additional_where_clause IN long,
714: additional_quickpick_columns IN VARCHAR2)
715: IS
716: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
717: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
718: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
719: creation_date fnd_flex_value_sets.creation_date%TYPE;
720: created_by fnd_flex_value_sets.created_by%TYPE;

Line 717: last_update_date fnd_flex_value_sets.last_update_date%TYPE;

713: additional_where_clause IN long,
714: additional_quickpick_columns IN VARCHAR2)
715: IS
716: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
717: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
718: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
719: creation_date fnd_flex_value_sets.creation_date%TYPE;
720: created_by fnd_flex_value_sets.created_by%TYPE;
721:

Line 718: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;

714: additional_quickpick_columns IN VARCHAR2)
715: IS
716: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
717: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
718: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
719: creation_date fnd_flex_value_sets.creation_date%TYPE;
720: created_by fnd_flex_value_sets.created_by%TYPE;
721:
722: enabled_column_name

Line 719: creation_date fnd_flex_value_sets.creation_date%TYPE;

715: IS
716: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
717: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
718: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
719: creation_date fnd_flex_value_sets.creation_date%TYPE;
720: created_by fnd_flex_value_sets.created_by%TYPE;
721:
722: enabled_column_name
723: fnd_flex_validation_tables.enabled_column_name%TYPE;

Line 720: created_by fnd_flex_value_sets.created_by%TYPE;

716: last_update_login fnd_flex_value_sets.last_update_login%TYPE;
717: last_update_date fnd_flex_value_sets.last_update_date%TYPE;
718: last_updated_by fnd_flex_value_sets.last_updated_by%TYPE;
719: creation_date fnd_flex_value_sets.creation_date%TYPE;
720: created_by fnd_flex_value_sets.created_by%TYPE;
721:
722: enabled_column_name
723: fnd_flex_validation_tables.enabled_column_name%TYPE;
724: hierarchy_level_column_name

Line 873: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

869: right_justify_zero_fill IN varchar2,
870: min_value IN varchar2,
871: max_value IN VARCHAR2)
872: IS
873: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
874: validation_type fnd_flex_value_sets.validation_type%TYPE;
875: format_code fnd_flex_value_sets.format_type%TYPE;
876: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
877: BEGIN

Line 874: validation_type fnd_flex_value_sets.validation_type%TYPE;

870: min_value IN varchar2,
871: max_value IN VARCHAR2)
872: IS
873: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
874: validation_type fnd_flex_value_sets.validation_type%TYPE;
875: format_code fnd_flex_value_sets.format_type%TYPE;
876: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
877: BEGIN
878: validation_type := 'N';

Line 875: format_code fnd_flex_value_sets.format_type%TYPE;

871: max_value IN VARCHAR2)
872: IS
873: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
874: validation_type fnd_flex_value_sets.validation_type%TYPE;
875: format_code fnd_flex_value_sets.format_type%TYPE;
876: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
877: BEGIN
878: validation_type := 'N';
879:

Line 876: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

872: IS
873: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
874: validation_type fnd_flex_value_sets.validation_type%TYPE;
875: format_code fnd_flex_value_sets.format_type%TYPE;
876: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
877: BEGIN
878: validation_type := 'N';
879:
880: message_init;

Line 920: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

916: right_justify_zero_fill IN varchar2,
917: min_value IN varchar2,
918: max_value IN VARCHAR2)
919: IS
920: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
921: validation_type fnd_flex_value_sets.validation_type%TYPE;
922: format_code fnd_flex_value_sets.format_type%TYPE;
923: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
924: BEGIN

Line 921: validation_type fnd_flex_value_sets.validation_type%TYPE;

917: min_value IN varchar2,
918: max_value IN VARCHAR2)
919: IS
920: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
921: validation_type fnd_flex_value_sets.validation_type%TYPE;
922: format_code fnd_flex_value_sets.format_type%TYPE;
923: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
924: BEGIN
925: validation_type := 'I';

Line 922: format_code fnd_flex_value_sets.format_type%TYPE;

918: max_value IN VARCHAR2)
919: IS
920: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
921: validation_type fnd_flex_value_sets.validation_type%TYPE;
922: format_code fnd_flex_value_sets.format_type%TYPE;
923: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
924: BEGIN
925: validation_type := 'I';
926:

Line 923: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

919: IS
920: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
921: validation_type fnd_flex_value_sets.validation_type%TYPE;
922: format_code fnd_flex_value_sets.format_type%TYPE;
923: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
924: BEGIN
925: validation_type := 'I';
926:
927: message_init;

Line 971: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

967: parent_flex_value_set IN VARCHAR2,
968: dependent_default_value IN varchar2,
969: dependent_default_meaning IN VARCHAR2)
970: IS
971: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
972: parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
973: validation_type fnd_flex_value_sets.validation_type%TYPE;
974: format_code fnd_flex_value_sets.format_type%TYPE;
975: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

Line 972: parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;

968: dependent_default_value IN varchar2,
969: dependent_default_meaning IN VARCHAR2)
970: IS
971: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
972: parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
973: validation_type fnd_flex_value_sets.validation_type%TYPE;
974: format_code fnd_flex_value_sets.format_type%TYPE;
975: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
976: BEGIN

Line 973: validation_type fnd_flex_value_sets.validation_type%TYPE;

969: dependent_default_meaning IN VARCHAR2)
970: IS
971: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
972: parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
973: validation_type fnd_flex_value_sets.validation_type%TYPE;
974: format_code fnd_flex_value_sets.format_type%TYPE;
975: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
976: BEGIN
977: validation_type := 'D';

Line 974: format_code fnd_flex_value_sets.format_type%TYPE;

970: IS
971: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
972: parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
973: validation_type fnd_flex_value_sets.validation_type%TYPE;
974: format_code fnd_flex_value_sets.format_type%TYPE;
975: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
976: BEGIN
977: validation_type := 'D';
978:

Line 975: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

971: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
972: parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
973: validation_type fnd_flex_value_sets.validation_type%TYPE;
974: format_code fnd_flex_value_sets.format_type%TYPE;
975: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
976: BEGIN
977: validation_type := 'D';
978:
979: message_init;

Line 985: FROM fnd_flex_value_sets

981: alphanumeric_allowed := invert_flag_f(numbers_only);
982: BEGIN
983: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
984: flex_value_set_id INTO parent_id
985: FROM fnd_flex_value_sets
986: WHERE flex_value_set_name = parent_flex_value_set;
987: /* the where clause is on a unique key, so 0 or 1 hits expected. */
988: EXCEPTION
989: WHEN no_data_found THEN

Line 1058: validation_type fnd_flex_value_sets.validation_type%TYPE;

1054: id_column_size IN number DEFAULT NULL,
1055: where_order_by IN varchar2 DEFAULT NULL,
1056: additional_columns IN VARCHAR2 DEFAULT NULL)
1057: IS
1058: validation_type fnd_flex_value_sets.validation_type%TYPE;
1059: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1060: table_application_id_i fnd_application.application_id%TYPE;
1061: format_code fnd_flex_value_sets.format_type%TYPE;
1062: value_column_type_code fnd_flex_value_sets.format_type%TYPE;

Line 1059: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

1055: where_order_by IN varchar2 DEFAULT NULL,
1056: additional_columns IN VARCHAR2 DEFAULT NULL)
1057: IS
1058: validation_type fnd_flex_value_sets.validation_type%TYPE;
1059: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1060: table_application_id_i fnd_application.application_id%TYPE;
1061: format_code fnd_flex_value_sets.format_type%TYPE;
1062: value_column_type_code fnd_flex_value_sets.format_type%TYPE;
1063: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;

Line 1061: format_code fnd_flex_value_sets.format_type%TYPE;

1057: IS
1058: validation_type fnd_flex_value_sets.validation_type%TYPE;
1059: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1060: table_application_id_i fnd_application.application_id%TYPE;
1061: format_code fnd_flex_value_sets.format_type%TYPE;
1062: value_column_type_code fnd_flex_value_sets.format_type%TYPE;
1063: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;
1064: id_column_type_code fnd_flex_value_sets.format_type%TYPE;
1065: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

Line 1062: value_column_type_code fnd_flex_value_sets.format_type%TYPE;

1058: validation_type fnd_flex_value_sets.validation_type%TYPE;
1059: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1060: table_application_id_i fnd_application.application_id%TYPE;
1061: format_code fnd_flex_value_sets.format_type%TYPE;
1062: value_column_type_code fnd_flex_value_sets.format_type%TYPE;
1063: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;
1064: id_column_type_code fnd_flex_value_sets.format_type%TYPE;
1065: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1066: l_result VARCHAR2(10);

Line 1063: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;

1059: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1060: table_application_id_i fnd_application.application_id%TYPE;
1061: format_code fnd_flex_value_sets.format_type%TYPE;
1062: value_column_type_code fnd_flex_value_sets.format_type%TYPE;
1063: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;
1064: id_column_type_code fnd_flex_value_sets.format_type%TYPE;
1065: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1066: l_result VARCHAR2(10);
1067: l_message VARCHAR2(32000);

Line 1064: id_column_type_code fnd_flex_value_sets.format_type%TYPE;

1060: table_application_id_i fnd_application.application_id%TYPE;
1061: format_code fnd_flex_value_sets.format_type%TYPE;
1062: value_column_type_code fnd_flex_value_sets.format_type%TYPE;
1063: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;
1064: id_column_type_code fnd_flex_value_sets.format_type%TYPE;
1065: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1066: l_result VARCHAR2(10);
1067: l_message VARCHAR2(32000);
1068: BEGIN

Line 1065: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

1061: format_code fnd_flex_value_sets.format_type%TYPE;
1062: value_column_type_code fnd_flex_value_sets.format_type%TYPE;
1063: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;
1064: id_column_type_code fnd_flex_value_sets.format_type%TYPE;
1065: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1066: l_result VARCHAR2(10);
1067: l_message VARCHAR2(32000);
1068: BEGIN
1069: validation_type := 'F';

Line 1166: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

1162: right_justify_zero_fill IN varchar2,
1163: min_value IN varchar2,
1164: max_value IN VARCHAR2)
1165: IS
1166: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1167: validation_type fnd_flex_value_sets.validation_type%TYPE;
1168: format_code fnd_flex_value_sets.format_type%TYPE;
1169: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1170: BEGIN

Line 1167: validation_type fnd_flex_value_sets.validation_type%TYPE;

1163: min_value IN varchar2,
1164: max_value IN VARCHAR2)
1165: IS
1166: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1167: validation_type fnd_flex_value_sets.validation_type%TYPE;
1168: format_code fnd_flex_value_sets.format_type%TYPE;
1169: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1170: BEGIN
1171: validation_type := 'U';

Line 1168: format_code fnd_flex_value_sets.format_type%TYPE;

1164: max_value IN VARCHAR2)
1165: IS
1166: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1167: validation_type fnd_flex_value_sets.validation_type%TYPE;
1168: format_code fnd_flex_value_sets.format_type%TYPE;
1169: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1170: BEGIN
1171: validation_type := 'U';
1172:

Line 1169: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

1165: IS
1166: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1167: validation_type fnd_flex_value_sets.validation_type%TYPE;
1168: format_code fnd_flex_value_sets.format_type%TYPE;
1169: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1170: BEGIN
1171: validation_type := 'U';
1172:
1173: message_init;

Line 1215: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

1211: right_justify_zero_fill IN varchar2,
1212: min_value IN varchar2,
1213: max_value IN VARCHAR2)
1214: IS
1215: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1216: validation_type fnd_flex_value_sets.validation_type%TYPE;
1217: format_code fnd_flex_value_sets.format_type%TYPE;
1218: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1219: BEGIN

Line 1216: validation_type fnd_flex_value_sets.validation_type%TYPE;

1212: min_value IN varchar2,
1213: max_value IN VARCHAR2)
1214: IS
1215: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1216: validation_type fnd_flex_value_sets.validation_type%TYPE;
1217: format_code fnd_flex_value_sets.format_type%TYPE;
1218: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1219: BEGIN
1220: validation_type := 'P';

Line 1217: format_code fnd_flex_value_sets.format_type%TYPE;

1213: max_value IN VARCHAR2)
1214: IS
1215: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1216: validation_type fnd_flex_value_sets.validation_type%TYPE;
1217: format_code fnd_flex_value_sets.format_type%TYPE;
1218: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1219: BEGIN
1220: validation_type := 'P';
1221:

Line 1218: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;

1214: IS
1215: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1216: validation_type fnd_flex_value_sets.validation_type%TYPE;
1217: format_code fnd_flex_value_sets.format_type%TYPE;
1218: alphanumeric_allowed fnd_flex_value_sets.alphanumeric_allowed_flag%TYPE;
1219: BEGIN
1220: validation_type := 'P';
1221:
1222: message_init;

Line 1253: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

1249: event IN VARCHAR2,
1250: function_text IN long)
1251: IS
1252: event_code fnd_flex_validation_events.event_code%TYPE;
1253: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1254: BEGIN
1255: message_init;
1256: value_set_id := value_set_id_f(value_set_name);
1257: -- get the event code from the event name

Line 1283: FROM fnd_flex_value_sets

1279: BEGIN
1280: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1281: flex_value_set_id
1282: INTO l_value_set_id
1283: FROM fnd_flex_value_sets
1284: WHERE flex_value_set_name = p_value_set;
1285: EXCEPTION
1286: WHEN no_data_found THEN
1287: message('could not find value set: ' || p_value_set);

Line 1309: FROM fnd_flex_value_sets

1305: -- Is this value set a parent value set?
1306: --
1307: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1308: count(*) INTO l_row_count
1309: FROM fnd_flex_value_sets
1310: WHERE validation_type = fnd_flex_types.val_dependent
1311: AND parent_flex_value_set_id = l_value_set_id;
1312:
1313: IF (l_row_count <> 0) THEN

Line 1500: FROM fnd_flex_value_sets

1496: --
1497: -- Delete the value set from main table.
1498: --
1499: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1500: FROM fnd_flex_value_sets
1501: WHERE flex_value_set_id = l_value_set_id;
1502:
1503: --
1504: -- Delete the FND_FLEX_VALUES Descriptive Flexfield context associated

Line 1567: FROM fnd_flex_value_sets

1563: BEGIN
1564: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1565: flex_value_set_id
1566: INTO old_value_set_id
1567: FROM fnd_flex_value_sets
1568: WHERE flex_value_set_name = old_value_set;
1569: EXCEPTION
1570: WHEN no_data_found THEN
1571: message('could not find original value set: ' || old_value_set);

Line 1581: FROM fnd_flex_value_sets

1577: BEGIN
1578: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1579: flex_value_set_id
1580: INTO new_value_set_id
1581: FROM fnd_flex_value_sets
1582: WHERE flex_value_set_name = new_value_set;
1583: EXCEPTION
1584: WHEN no_data_found THEN
1585: message('could not find new value set: ' || new_value_set);

Line 1603: fnd_flex_value_sets SET

1599:
1600: /* rename the new value set, and change the id */
1601: BEGIN
1602: UPDATE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1603: fnd_flex_value_sets SET
1604: flex_value_set_id = old_value_set_id,
1605: flex_value_set_name = old_value_set
1606: WHERE flex_value_set_id = new_value_set_id;
1607: END;

Line 1628: fnd_flex_value_sets SET

1624: WHEN no_data_found THEN NULL;
1625: END;
1626: BEGIN
1627: UPDATE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1628: fnd_flex_value_sets SET
1629: parent_flex_value_set_id = old_value_set_id
1630: WHERE parent_flex_value_set_id = new_value_set_id;
1631: EXCEPTION
1632: WHEN no_data_found THEN NULL;

Line 1649: FROM fnd_flex_value_sets

1645: BEGIN
1646: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1647: COUNT(*)
1648: INTO cnt
1649: FROM fnd_flex_value_sets
1650: WHERE flex_value_set_name = value_set;
1651: IF(cnt > 0) THEN
1652: RETURN TRUE;
1653: ELSE

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

1655: END IF;
1656: END;
1657:
1658:
1659: PROCEDURE crosscheck_size(valueset_r IN fnd_flex_value_sets%ROWTYPE);
1660: PROCEDURE check_precision(valueset_r IN OUT nocopy fnd_flex_value_sets%ROWTYPE);
1661:
1662:
1663: PROCEDURE update_maxsize(

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

1656: END;
1657:
1658:
1659: PROCEDURE crosscheck_size(valueset_r IN fnd_flex_value_sets%ROWTYPE);
1660: PROCEDURE check_precision(valueset_r IN OUT nocopy fnd_flex_value_sets%ROWTYPE);
1661:
1662:
1663: PROCEDURE update_maxsize(
1664: value_set_name IN VARCHAR2,

Line 1665: maxsize IN fnd_flex_value_sets.maximum_size%TYPE)

1661:
1662:
1663: PROCEDURE update_maxsize(
1664: value_set_name IN VARCHAR2,
1665: maxsize IN fnd_flex_value_sets.maximum_size%TYPE)
1666: IS
1667: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1668: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1669: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;

Line 1667: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;

1663: PROCEDURE update_maxsize(
1664: value_set_name IN VARCHAR2,
1665: maxsize IN fnd_flex_value_sets.maximum_size%TYPE)
1666: IS
1667: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1668: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1669: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1670:
1671: valueset_r fnd_flex_value_sets%ROWTYPE;

Line 1668: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;

1664: value_set_name IN VARCHAR2,
1665: maxsize IN fnd_flex_value_sets.maximum_size%TYPE)
1666: IS
1667: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1668: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1669: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1670:
1671: valueset_r fnd_flex_value_sets%ROWTYPE;
1672: maxsize_old NUMBER;

Line 1669: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;

1665: maxsize IN fnd_flex_value_sets.maximum_size%TYPE)
1666: IS
1667: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1668: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1669: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1670:
1671: valueset_r fnd_flex_value_sets%ROWTYPE;
1672: maxsize_old NUMBER;
1673: BEGIN

Line 1671: valueset_r fnd_flex_value_sets%ROWTYPE;

1667: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1668: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1669: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1670:
1671: valueset_r fnd_flex_value_sets%ROWTYPE;
1672: maxsize_old NUMBER;
1673: BEGIN
1674: last_update_login_i := last_update_login_f();
1675: last_update_date_i := last_update_date_f();

Line 1683: FROM fnd_flex_value_sets

1679: BEGIN
1680: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1681: *
1682: INTO valueset_r
1683: FROM fnd_flex_value_sets
1684: WHERE flex_value_set_name = value_set_name;
1685: EXCEPTION
1686: WHEN no_data_found THEN
1687: message('could not find valueset ' || value_set_name);

Line 1752: fnd_flex_value_sets SET

1748:
1749: BEGIN
1750: IF(customer_mode) THEN
1751: UPDATE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1752: fnd_flex_value_sets SET
1753: maximum_size = valueset_r.maximum_size,
1754: number_precision = valueset_r.number_precision,
1755: last_update_date = last_update_date_i,
1756: last_updated_by = last_updated_by_i,

Line 1761: fnd_flex_value_sets SET

1757: last_update_login = last_update_login_i
1758: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1759: ELSE
1760: UPDATE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1761: fnd_flex_value_sets SET
1762: maximum_size = valueset_r.maximum_size,
1763: number_precision = valueset_r.number_precision
1764: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1765: END IF;

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

1764: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1765: END IF;
1766: EXCEPTION
1767: WHEN OTHERS THEN
1768: message('error updating fnd_flex_value_sets: ' || Sqlerrm);
1769: RAISE;
1770: END;
1771: EXCEPTION
1772: WHEN OTHERS THEN

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

1781: -- Cross check maximum size against table value column size, reducing
1782: -- maximum size if needed. Do not do cross check if not table-validated
1783: -- or if type is date or if either size is null.
1784:
1785: PROCEDURE crosscheck_size(valueset_r IN fnd_flex_value_sets%ROWTYPE)
1786: IS
1787: table_r fnd_flex_validation_tables%ROWTYPE;
1788: BEGIN
1789: IF(valueset_r.validation_type = 'F') THEN

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

1817:
1818:
1819: -- Make sure precision < Max size (if both are non-null)
1820:
1821: PROCEDURE check_precision(valueset_r IN OUT nocopy fnd_flex_value_sets%ROWTYPE)
1822: IS
1823: BEGIN
1824: IF((valueset_r.maximum_size IS NOT NULL) AND
1825: (valueset_r.number_precision IS NOT NULL) AND

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

1828: END IF;
1829: END check_precision;
1830:
1831:
1832: PROCEDURE check_id_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1833: table_r IN fnd_flex_validation_tables%ROWTYPE);
1834:
1835: PROCEDURE check_meaning_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1836: table_r IN fnd_flex_validation_tables%ROWTYPE);

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

1831:
1832: PROCEDURE check_id_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1833: table_r IN fnd_flex_validation_tables%ROWTYPE);
1834:
1835: PROCEDURE check_meaning_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1836: table_r IN fnd_flex_validation_tables%ROWTYPE);
1837:
1838:
1839: PROCEDURE update_table_sizes(

Line 1848: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;

1844: DEFAULT NULL,
1845: meaning_size IN fnd_flex_validation_tables.meaning_column_size%TYPE
1846: DEFAULT NULL)
1847: IS
1848: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1849: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1850: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1851:
1852: valueset_r fnd_flex_value_sets%ROWTYPE;

Line 1849: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;

1845: meaning_size IN fnd_flex_validation_tables.meaning_column_size%TYPE
1846: DEFAULT NULL)
1847: IS
1848: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1849: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1850: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1851:
1852: valueset_r fnd_flex_value_sets%ROWTYPE;
1853: table_r fnd_flex_validation_tables%ROWTYPE;

Line 1850: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;

1846: DEFAULT NULL)
1847: IS
1848: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1849: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1850: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1851:
1852: valueset_r fnd_flex_value_sets%ROWTYPE;
1853: table_r fnd_flex_validation_tables%ROWTYPE;
1854: BEGIN

Line 1852: valueset_r fnd_flex_value_sets%ROWTYPE;

1848: last_update_login_i fnd_flex_value_sets.last_update_login%TYPE;
1849: last_update_date_i fnd_flex_value_sets.last_update_date%TYPE;
1850: last_updated_by_i fnd_flex_value_sets.last_updated_by%TYPE;
1851:
1852: valueset_r fnd_flex_value_sets%ROWTYPE;
1853: table_r fnd_flex_validation_tables%ROWTYPE;
1854: BEGIN
1855: last_update_login_i := last_update_login_f();
1856: last_update_date_i := last_update_date_f();

Line 1864: FROM fnd_flex_value_sets

1860: BEGIN
1861: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1862: *
1863: INTO valueset_r
1864: FROM fnd_flex_value_sets
1865: WHERE flex_value_set_name = value_set_name;
1866: EXCEPTION
1867: WHEN no_data_found THEN
1868: message('could not find valueset ' || value_set_name);

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

1932: RAISE bad_parameter;
1933: END update_table_sizes;
1934:
1935:
1936: PROCEDURE check_id_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1937: table_r IN fnd_flex_validation_tables%ROWTYPE)
1938: IS
1939: width_i NUMBER;
1940: BEGIN

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

1964: message('check id size failed: ' || Sqlerrm);
1965: RAISE;
1966: END;
1967:
1968: PROCEDURE check_meaning_size(valueset_r IN fnd_flex_value_sets%ROWTYPE,
1969: table_r IN fnd_flex_validation_tables%ROWTYPE)
1970: IS
1971: width_i NUMBER;
1972: BEGIN

Line 2022: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

2018: END add_to_select;
2019:
2020: PROCEDURE get_valueset_select
2021: (p_validation_type IN VARCHAR2,
2022: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2023: DEFAULT fnd_api.g_miss_char,
2024: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2025: DEFAULT fnd_api.g_miss_num,
2026: p_independent_value IN VARCHAR2 DEFAULT NULL,

Line 2024: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

2020: PROCEDURE get_valueset_select
2021: (p_validation_type IN VARCHAR2,
2022: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2023: DEFAULT fnd_api.g_miss_char,
2024: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2025: DEFAULT fnd_api.g_miss_num,
2026: p_independent_value IN VARCHAR2 DEFAULT NULL,
2027: --
2028: -- Do you want to include these columns in SELECT statement?

Line 2058: l_vset fnd_flex_value_sets%ROWTYPE;

2054: x_mapping_code OUT nocopy VARCHAR2,
2055: x_success OUT nocopy NUMBER)
2056: IS
2057: l_func_name VARCHAR2(100);
2058: l_vset fnd_flex_value_sets%ROWTYPE;
2059: l_tvset fnd_flex_validation_tables%ROWTYPE;
2060:
2061: l_and VARCHAR2(10);
2062: l_select VARCHAR2(32000);

Line 2098: FROM fnd_flex_value_sets

2094: BEGIN
2095: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
2096: *
2097: INTO l_vset
2098: FROM fnd_flex_value_sets
2099: WHERE ( (p_value_set_id = fnd_api.g_miss_num
2100: AND flex_value_set_name = p_value_set_name)
2101: OR (p_value_set_name = fnd_api.g_miss_char
2102: AND flex_value_set_id = p_value_set_id));

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

2105: message(l_func_name || 'Value set does not exist.');
2106: x_success := g_ret_no_value_set;
2107: RETURN;
2108: WHEN OTHERS THEN
2109: message(l_func_name || 'SELECT FROM fnd_flex_value_sets is failed.' ||
2110: chr_newline || 'Error : ' || Sqlerrm);
2111: x_success := g_ret_others;
2112: RETURN;
2113: END;

Line 2305: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

2301: x_success := g_ret_others;
2302: END get_valueset_select;
2303:
2304: PROCEDURE get_table_vset_select
2305: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2306: DEFAULT fnd_api.g_miss_char,
2307: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2308: DEFAULT fnd_api.g_miss_num,
2309: --

Line 2307: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

2303:
2304: PROCEDURE get_table_vset_select
2305: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2306: DEFAULT fnd_api.g_miss_char,
2307: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2308: DEFAULT fnd_api.g_miss_num,
2309: --
2310: -- Do you want to include these columns in SELECT statement?
2311: -- VALUE column is always included.

Line 2383: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

2379: x_success := g_ret_others;
2380: END get_table_vset_select;
2381:
2382: PROCEDURE get_independent_vset_select
2383: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2384: DEFAULT fnd_api.g_miss_char,
2385: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2386: DEFAULT fnd_api.g_miss_num,
2387: --

Line 2385: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

2381:
2382: PROCEDURE get_independent_vset_select
2383: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2384: DEFAULT fnd_api.g_miss_char,
2385: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2386: DEFAULT fnd_api.g_miss_num,
2387: --
2388: -- Do you want to include these columns in SELECT statement?
2389: -- VALUE column is always included.

Line 2457: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE

2453: x_success := g_ret_others;
2454: END get_independent_vset_select;
2455:
2456: PROCEDURE get_dependent_vset_select
2457: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2458: DEFAULT fnd_api.g_miss_char,
2459: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2460: DEFAULT fnd_api.g_miss_num,
2461: p_independent_value IN VARCHAR2 DEFAULT NULL,

Line 2459: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE

2455:
2456: PROCEDURE get_dependent_vset_select
2457: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
2458: DEFAULT fnd_api.g_miss_char,
2459: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
2460: DEFAULT fnd_api.g_miss_num,
2461: p_independent_value IN VARCHAR2 DEFAULT NULL,
2462: --
2463: -- Do you want to include these columns in SELECT statement?

Line 2536: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;

2532: p_table_name IN fnd_tables.table_name%TYPE,
2533: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2534: IS
2535: up_table_name fnd_tables.table_name%TYPE;
2536: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2537: BEGIN
2538: up_table_name := Upper(p_table_name);
2539:
2540: x_message := 'This table is not used by Flexfield Value Sets';

Line 2544: FROM fnd_flex_value_sets fvs, fnd_flex_validation_tables fvt

2540: x_message := 'This table is not used by Flexfield Value Sets';
2541: BEGIN
2542: SELECT fvs.flex_value_set_name
2543: INTO l_vset_name
2544: FROM fnd_flex_value_sets fvs, fnd_flex_validation_tables fvt
2545: WHERE fvs.validation_type = 'F'
2546: AND fvs.flex_value_set_id = fvt.flex_value_set_id
2547: AND Nvl(fvt.table_application_id, p_application_id) = p_application_id
2548: AND (Upper(fvt.application_table_name) = up_table_name OR

Line 2583: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;

2579: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2580: IS
2581: up_table_name fnd_tables.table_name%TYPE;
2582: up_column_name fnd_columns.column_name%TYPE;
2583: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2584: BEGIN
2585: up_table_name := Upper(p_table_name);
2586: up_column_name := Upper(p_column_name);
2587:

Line 2593: FROM fnd_flex_value_sets fvs, fnd_flex_validation_tables fvt

2589: BEGIN
2590: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
2591: fvs.flex_value_set_name
2592: INTO l_vset_name
2593: FROM fnd_flex_value_sets fvs, fnd_flex_validation_tables fvt
2594: WHERE fvs.validation_type = 'F'
2595: AND fvs.flex_value_set_id = fvt.flex_value_set_id
2596: AND Nvl(fvt.table_application_id, p_application_id) = p_application_id
2597: AND (Upper(fvt.application_table_name) = up_table_name OR

Line 2652: FROM fnd_flex_value_sets

2648: IF (p_flex_value_set_name IS NOT NULL) THEN
2649: BEGIN
2650: SELECT *
2651: INTO x_vset
2652: FROM fnd_flex_value_sets
2653: WHERE flex_value_set_name = p_flex_value_set_name;
2654: EXCEPTION
2655: WHEN OTHERS THEN
2656: raise_error(ERROR_UNABLE_TO_FIND_VSET_NAME,

Line 2664: FROM fnd_flex_value_sets

2660: ELSIF (p_flex_value_set_id IS NOT NULL) THEN
2661: BEGIN
2662: SELECT *
2663: INTO x_vset
2664: FROM fnd_flex_value_sets
2665: WHERE flex_value_set_id = p_flex_value_set_id;
2666: EXCEPTION
2667: WHEN OTHERS THEN
2668: raise_error(ERROR_UNABLE_TO_FIND_VSET_ID,

Line 3711: fnd_flex_value_sets v,

3707: l_validation_type, l_format_type, l_maximum_size,
3708: l_number_precision, l_flex_value_set_name,
3709: l_id_column_name, l_id_column_type, l_id_column_size
3710: FROM
3711: fnd_flex_value_sets v,
3712: fnd_flex_validation_tables t
3713: WHERE
3714: v.flex_value_set_id = p_value_set_id and
3715: v.flex_value_set_id = t.flex_value_set_id(+);

Line 3725: fnd_flex_value_sets v,

3721: c.column_type, c.width
3722: INTO
3723: l_column_type, l_appl_col_size
3724: FROM
3725: fnd_flex_value_sets v,
3726: fnd_flex_validation_tables t,
3727: fnd_columns c, fnd_tables tb
3728: WHERE
3729: v.flex_value_set_id = p_value_set_id and

Line 3955: fnd_flex_value_sets v, fnd_id_flex_segments s

3951: s.segment_num, v.parent_flex_value_set_id
3952: INTO
3953: l_segment_num, l_parent_value_set_id
3954: FROM
3955: fnd_flex_value_sets v, fnd_id_flex_segments s
3956: WHERE
3957: v.flex_value_set_id = p_value_set_id
3958: AND s.id_flex_num = p_id_flex_num
3959: AND v.parent_flex_value_set_id = s.flex_value_set_id;

Line 3965: from fnd_flex_value_sets

3961: IF(NOT(l_segment_num < p_segment_num)) THEN
3962:
3963: select flex_value_set_name
3964: into l_parent_value_set_name
3965: from fnd_flex_value_sets
3966: where
3967: flex_value_set_id=l_parent_value_set_id;
3968:
3969: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');

Line 3981: from fnd_flex_value_sets

3977: WHEN NO_DATA_FOUND THEN
3978:
3979: select flex_value_set_name
3980: into l_parent_value_set_name
3981: from fnd_flex_value_sets
3982: where
3983: flex_value_set_id in (select parent_flex_value_set_id
3984: from fnd_flex_value_sets
3985: where flex_value_set_id=p_value_set_id);

Line 3984: from fnd_flex_value_sets

3980: into l_parent_value_set_name
3981: from fnd_flex_value_sets
3982: where
3983: flex_value_set_id in (select parent_flex_value_set_id
3984: from fnd_flex_value_sets
3985: where flex_value_set_id=p_value_set_id);
3986:
3987: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
3988: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

Line 4014: fnd_flex_value_sets v, fnd_descr_flex_column_usages u

4010: u.column_seq_num, v.parent_flex_value_set_id
4011: INTO
4012: l_column_seq_num, l_parent_value_set_id
4013: FROM
4014: fnd_flex_value_sets v, fnd_descr_flex_column_usages u
4015: WHERE
4016: v.flex_value_set_id = p_value_set_id and
4017: -- Bug#4410208, In SRS agruments form there is no context code
4018: (p_desc_flex_context_code is null or

Line 4026: from fnd_flex_value_sets

4022: IF(NOT(l_column_seq_num < p_column_seq_num)) THEN
4023:
4024: select flex_value_set_name
4025: into l_parent_value_set_name
4026: from fnd_flex_value_sets
4027: where
4028: flex_value_set_id=l_parent_value_set_id;
4029:
4030: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');

Line 4041: from fnd_flex_value_sets

4037: WHEN NO_DATA_FOUND THEN
4038:
4039: select flex_value_set_name
4040: into l_parent_value_set_name
4041: from fnd_flex_value_sets
4042: where
4043: flex_value_set_id in (select parent_flex_value_set_id
4044: from fnd_flex_value_sets
4045: where flex_value_set_id=p_value_set_id);

Line 4044: from fnd_flex_value_sets

4040: into l_parent_value_set_name
4041: from fnd_flex_value_sets
4042: where
4043: flex_value_set_id in (select parent_flex_value_set_id
4044: from fnd_flex_value_sets
4045: where flex_value_set_id=p_value_set_id);
4046:
4047: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
4048: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

Line 4070: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,

4066: p_application_column_type IN fnd_columns.column_type%TYPE,
4067: p_application_column_size IN fnd_columns.width%TYPE,
4068: p_id_column_type IN fnd_flex_validation_tables.id_column_type%TYPE,
4069: p_id_column_size IN fnd_flex_validation_tables.id_column_size%TYPE,
4070: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,
4071: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4072: p_maximum_size IN fnd_flex_value_sets.maximum_size%TYPE,
4073: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4074: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)

Line 4071: p_format_type IN fnd_flex_value_sets.format_type%TYPE,

4067: p_application_column_size IN fnd_columns.width%TYPE,
4068: p_id_column_type IN fnd_flex_validation_tables.id_column_type%TYPE,
4069: p_id_column_size IN fnd_flex_validation_tables.id_column_size%TYPE,
4070: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,
4071: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4072: p_maximum_size IN fnd_flex_value_sets.maximum_size%TYPE,
4073: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4074: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)
4075: IS

Line 4072: p_maximum_size IN fnd_flex_value_sets.maximum_size%TYPE,

4068: p_id_column_type IN fnd_flex_validation_tables.id_column_type%TYPE,
4069: p_id_column_size IN fnd_flex_validation_tables.id_column_size%TYPE,
4070: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,
4071: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4072: p_maximum_size IN fnd_flex_value_sets.maximum_size%TYPE,
4073: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4074: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)
4075: IS
4076:

Line 4073: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,

4069: p_id_column_size IN fnd_flex_validation_tables.id_column_size%TYPE,
4070: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,
4071: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4072: p_maximum_size IN fnd_flex_value_sets.maximum_size%TYPE,
4073: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4074: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)
4075: IS
4076:
4077: l_format_type_name VARCHAR2(80);

Line 4172: p_format_type IN fnd_flex_value_sets.format_type%TYPE,

4168:
4169: END check_base_table_column;
4170:
4171: PROCEDURE is_vset_obsolete(
4172: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4173: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4174: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)
4175: IS
4176: BEGIN

Line 4173: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,

4169: END check_base_table_column;
4170:
4171: PROCEDURE is_vset_obsolete(
4172: p_format_type IN fnd_flex_value_sets.format_type%TYPE,
4173: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4174: p_segment_name IN fnd_id_flex_segments.segment_name%TYPE)
4175: IS
4176: BEGIN
4177:

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

4198: -- the user a chance to see why he cannot attach a vset to a
4199: -- certain segment. Now we have a separate procedure for DFF/SRS.
4200:
4201: PROCEDURE is_value_set_allowed_dff
4202: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4203: p_application_id IN fnd_descr_flex_column_usages.application_id%TYPE,
4204: p_descriptive_flexfield_name IN fnd_descr_flex_column_usages.descriptive_flexfield_name%TYPE,
4205: p_desc_flex_context_code IN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
4206: p_application_column_name IN fnd_descr_flex_column_usages.application_column_name%TYPE,

Line 4287: fnd_flex_value_sets v,

4283: l_validation_type, l_format_type, l_maximum_size,
4284: l_flex_value_set_name, l_id_column_type,
4285: l_id_column_size
4286: FROM
4287: fnd_flex_value_sets v,
4288: fnd_flex_validation_tables t
4289: WHERE
4290: v.flex_value_set_id = p_flex_value_set_id and
4291: v.flex_value_set_id = t.flex_value_set_id(+);

Line 4330: fnd_flex_value_sets v, fnd_descr_flex_column_usages u

4326: min(u.column_seq_num), v.parent_flex_value_set_id
4327: INTO
4328: l_column_seq_num, l_parent_value_set_id
4329: FROM
4330: fnd_flex_value_sets v, fnd_descr_flex_column_usages u
4331: WHERE
4332: v.flex_value_set_id = p_flex_value_set_id
4333: -- Bug#4564981
4334: AND u.application_id = p_application_id

Line 4346: from fnd_flex_value_sets

4342: IF(NOT(l_column_seq_num < p_column_seq_num)) THEN
4343:
4344: select flex_value_set_name
4345: into l_parent_value_set_name
4346: from fnd_flex_value_sets
4347: where
4348: flex_value_set_id=l_parent_value_set_id;
4349:
4350: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');

Line 4361: from fnd_flex_value_sets

4357: WHEN NO_DATA_FOUND THEN
4358:
4359: select flex_value_set_name
4360: into l_parent_value_set_name
4361: from fnd_flex_value_sets
4362: where
4363: flex_value_set_id in (select parent_flex_value_set_id
4364: from fnd_flex_value_sets
4365: where flex_value_set_id=p_flex_value_set_id);

Line 4364: from fnd_flex_value_sets

4360: into l_parent_value_set_name
4361: from fnd_flex_value_sets
4362: where
4363: flex_value_set_id in (select parent_flex_value_set_id
4364: from fnd_flex_value_sets
4365: where flex_value_set_id=p_flex_value_set_id);
4366:
4367: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
4368: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

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

4389: -- the user a chance to see why he cannot attach a vset to a
4390: -- certain segment. Now we have a separate procedure for KFF.
4391:
4392: PROCEDURE is_value_set_allowed_kff
4393: (p_flex_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE,
4394: p_application_id IN fnd_id_flex_segments.application_id%TYPE,
4395: p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE,
4396: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
4397: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,

Line 4455: fnd_flex_value_sets v,

4451: l_validation_type, l_format_type, l_maximum_size,
4452: l_number_precision, l_flex_value_set_name,
4453: l_id_column_name, l_id_column_type, l_id_column_size
4454: FROM
4455: fnd_flex_value_sets v,
4456: fnd_flex_validation_tables t
4457: WHERE
4458: v.flex_value_set_id = p_flex_value_set_id and
4459: v.flex_value_set_id = t.flex_value_set_id(+);

Line 4565: fnd_flex_value_sets v, fnd_id_flex_segments s

4561: min(s.segment_num), v.parent_flex_value_set_id
4562: INTO
4563: l_segment_num, l_parent_value_set_id
4564: FROM
4565: fnd_flex_value_sets v, fnd_id_flex_segments s
4566: WHERE
4567: v.flex_value_set_id = p_flex_value_set_id
4568: -- Bug#4564981
4569: AND s.application_id = p_application_id

Line 4579: from fnd_flex_value_sets

4575: IF(NOT(l_segment_num < p_segment_num)) THEN
4576:
4577: select flex_value_set_name
4578: into l_parent_value_set_name
4579: from fnd_flex_value_sets
4580: where
4581: flex_value_set_id=l_parent_value_set_id;
4582:
4583: fnd_message.set_name('FND','FLEX-VSET IND DEP VSET ORDER');

Line 4595: from fnd_flex_value_sets

4591: WHEN NO_DATA_FOUND THEN
4592:
4593: select flex_value_set_name
4594: into l_parent_value_set_name
4595: from fnd_flex_value_sets
4596: where
4597: flex_value_set_id in (select parent_flex_value_set_id
4598: from fnd_flex_value_sets
4599: where flex_value_set_id=p_flex_value_set_id);

Line 4598: from fnd_flex_value_sets

4594: into l_parent_value_set_name
4595: from fnd_flex_value_sets
4596: where
4597: flex_value_set_id in (select parent_flex_value_set_id
4598: from fnd_flex_value_sets
4599: where flex_value_set_id=p_flex_value_set_id);
4600:
4601: fnd_message.set_name('FND','FLEX-VSET PARENT VSET MISSING');
4602: fnd_message.set_token('VSET_NAME',l_flex_value_set_name);

Line 4821: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,

4817:
4818:
4819:
4820: PROCEDURE validate_table_vset(
4821: p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE,
4822: p_id_column_name IN fnd_flex_validation_tables.id_column_name%TYPE,
4823: p_value_column_name IN fnd_flex_validation_tables.value_column_name%TYPE,
4824: p_meaning_column_name IN fnd_flex_validation_tables.meaning_column_name%TYPE,
4825: p_additional_quickpick_columns IN fnd_flex_validation_tables.additional_quickpick_columns%TYPE,