DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 145: * = EGO_COL_NAME_VALUE_PAIR_ARRAY =

141: * value for one Primary Key, Classification Code, or other column relevant
142: * to the API.
143: *
144: * =================================
145: * = EGO_COL_NAME_VALUE_PAIR_ARRAY =
146: * =================================
147: *
148: *


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

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

145: * = EGO_COL_NAME_VALUE_PAIR_ARRAY =
146: * =================================
147: *
148: *


149: CREATE EGO_COL_NAME_VALUE_PAIR_ARRAY AS VARRAY(6) OF EGO_COL_NAME_VALUE_PAIR_OBJ;
150: *

151: *
152: * ============================
153: * = EGO_USER_ATTR_CHANGE_OBJ =

Line 319: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

315: p_api_version IN NUMBER
316: ,p_object_name IN VARCHAR2
317: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
318: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
319: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
320: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
321: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
322: ,p_entity_id IN NUMBER DEFAULT NULL
323: ,p_entity_index IN NUMBER DEFAULT NULL

Line 320: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

316: ,p_object_name IN VARCHAR2
317: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
318: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
319: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
320: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
321: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
322: ,p_entity_id IN NUMBER DEFAULT NULL
323: ,p_entity_index IN NUMBER DEFAULT NULL
324: ,p_entity_code IN VARCHAR2 DEFAULT NULL

Line 346: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

342: p_api_version IN NUMBER
343: ,p_object_name IN VARCHAR2
344: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
345: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
346: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
347: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
348: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
349: ,p_entity_id IN NUMBER DEFAULT NULL
350: ,p_entity_index IN NUMBER DEFAULT NULL

Line 347: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

343: ,p_object_name IN VARCHAR2
344: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
345: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
346: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
347: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
348: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
349: ,p_entity_id IN NUMBER DEFAULT NULL
350: ,p_entity_index IN NUMBER DEFAULT NULL
351: ,p_entity_code IN VARCHAR2 DEFAULT NULL

Line 439: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

435: */
436: PROCEDURE Get_User_Attrs_Data (
437: p_api_version IN NUMBER
438: ,p_object_name IN VARCHAR2
439: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
440: ,p_attr_group_request_table IN EGO_ATTR_GROUP_REQUEST_TABLE
441: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
442: ,p_entity_id IN VARCHAR2 DEFAULT NULL
443: ,p_entity_index IN NUMBER DEFAULT NULL

Line 534: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

530: p_api_version IN NUMBER
531: ,p_application_id IN NUMBER
532: ,p_object_id IN NUMBER DEFAULT NULL
533: ,p_object_name IN VARCHAR2 DEFAULT NULL
534: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
535: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
536: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
537: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
538: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 535: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

531: ,p_application_id IN NUMBER
532: ,p_object_id IN NUMBER DEFAULT NULL
533: ,p_object_name IN VARCHAR2 DEFAULT NULL
534: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
535: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
536: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
537: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
538: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
539: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 536: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

532: ,p_object_id IN NUMBER DEFAULT NULL
533: ,p_object_name IN VARCHAR2 DEFAULT NULL
534: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
535: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
536: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
537: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
538: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
539: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
540: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 537: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

533: ,p_object_name IN VARCHAR2 DEFAULT NULL
534: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
535: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
536: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
537: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
538: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
539: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
540: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
541: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 538: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

534: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
535: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
536: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
537: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
538: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
539: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
540: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
541: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
542: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 624: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

620: PROCEDURE Validate_Required_Attrs (
621: p_api_version IN NUMBER
622: ,p_object_name IN VARCHAR2
623: -- FND_OBJECTS.OBJECT_NAME
624: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
625: -- Attr values to be validated
626: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
627: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
628: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 626: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

622: ,p_object_name IN VARCHAR2
623: -- FND_OBJECTS.OBJECT_NAME
624: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
625: -- Attr values to be validated
626: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
627: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
628: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
629: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
630: -- FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME

Line 628: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

624: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
625: -- Attr values to be validated
626: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
627: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
628: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
629: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
630: -- FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME
631: ,p_entity_id IN NUMBER
632: ,p_entity_index IN NUMBER