DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 152: * = EGO_COL_NAME_VALUE_PAIR_ARRAY =

148: * value for one Primary Key, Classification Code, or other column relevant
149: * to the API.
150: *
151: * =================================
152: * = EGO_COL_NAME_VALUE_PAIR_ARRAY =
153: * =================================
154: *
155: *


156: CREATE EGO_COL_NAME_VALUE_PAIR_ARRAY AS VARRAY(6) OF EGO_COL_NAME_VALUE_PAIR_OBJ;

Line 156: CREATE EGO_COL_NAME_VALUE_PAIR_ARRAY AS VARRAY(6) OF EGO_COL_NAME_VALUE_PAIR_OBJ;

152: * = EGO_COL_NAME_VALUE_PAIR_ARRAY =
153: * =================================
154: *
155: *


156: CREATE EGO_COL_NAME_VALUE_PAIR_ARRAY AS VARRAY(6) OF EGO_COL_NAME_VALUE_PAIR_OBJ;
157: *

158: *
159: * ============================
160: * = EGO_USER_ATTR_CHANGE_OBJ =

Line 328: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

324: p_api_version IN NUMBER
325: ,p_object_name IN VARCHAR2
326: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
327: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
328: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
329: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
330: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
331: ,p_entity_id IN NUMBER DEFAULT NULL
332: ,p_entity_index IN NUMBER DEFAULT NULL

Line 329: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

325: ,p_object_name IN VARCHAR2
326: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
327: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
328: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
329: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
330: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
331: ,p_entity_id IN NUMBER DEFAULT NULL
332: ,p_entity_index IN NUMBER DEFAULT NULL
333: ,p_entity_code IN VARCHAR2 DEFAULT NULL

Line 355: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

351: p_api_version IN NUMBER
352: ,p_object_name IN VARCHAR2
353: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
354: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
355: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
356: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
357: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
358: ,p_entity_id IN NUMBER DEFAULT NULL
359: ,p_entity_index IN NUMBER DEFAULT NULL

Line 356: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

352: ,p_object_name IN VARCHAR2
353: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
354: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
355: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
356: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
357: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
358: ,p_entity_id IN NUMBER DEFAULT NULL
359: ,p_entity_index IN NUMBER DEFAULT NULL
360: ,p_entity_code IN VARCHAR2 DEFAULT NULL

Line 448: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

444: */
445: PROCEDURE Get_User_Attrs_Data (
446: p_api_version IN NUMBER
447: ,p_object_name IN VARCHAR2
448: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
449: ,p_attr_group_request_table IN EGO_ATTR_GROUP_REQUEST_TABLE
450: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
451: ,p_entity_id IN VARCHAR2 DEFAULT NULL
452: ,p_entity_index IN NUMBER DEFAULT NULL

Line 552: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

548: p_api_version IN NUMBER
549: ,p_application_id IN NUMBER
550: ,p_object_id IN NUMBER DEFAULT NULL
551: ,p_object_name IN VARCHAR2 DEFAULT NULL
552: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
553: ,p_old_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
554: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
555: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
556: ,p_new_data_level_id IN NUMBER DEFAULT NULL --bug 8941665

Line 554: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

550: ,p_object_id IN NUMBER DEFAULT NULL
551: ,p_object_name IN VARCHAR2 DEFAULT NULL
552: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
553: ,p_old_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
554: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
555: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
556: ,p_new_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
557: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
558: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 555: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

551: ,p_object_name IN VARCHAR2 DEFAULT NULL
552: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
553: ,p_old_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
554: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
555: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
556: ,p_new_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
557: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
558: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
559: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 557: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

553: ,p_old_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
554: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
555: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
556: ,p_new_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
557: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
558: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
559: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
560: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
561: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 558: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

554: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
555: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
556: ,p_new_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
557: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
558: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
559: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
560: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
561: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
562: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 644: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

640: PROCEDURE Validate_Required_Attrs (
641: p_api_version IN NUMBER
642: ,p_object_name IN VARCHAR2
643: -- FND_OBJECTS.OBJECT_NAME
644: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
645: -- Attr values to be validated
646: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
647: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
648: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 646: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

642: ,p_object_name IN VARCHAR2
643: -- FND_OBJECTS.OBJECT_NAME
644: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
645: -- Attr values to be validated
646: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
647: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
648: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
649: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
650: -- FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME

Line 648: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

644: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
645: -- Attr values to be validated
646: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
647: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
648: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
649: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
650: -- FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME
651: ,p_entity_id IN NUMBER
652: ,p_entity_index IN NUMBER