DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 16: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

12: p_api_version IN NUMBER
13: ,p_object_name IN VARCHAR2
14: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
15: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
16: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
19: ,p_entity_id IN NUMBER DEFAULT NULL
20: ,p_entity_index IN NUMBER DEFAULT NULL

Line 17: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

13: ,p_object_name IN VARCHAR2
14: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
15: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
16: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
19: ,p_entity_id IN NUMBER DEFAULT NULL
20: ,p_entity_index IN NUMBER DEFAULT NULL
21: ,p_entity_code IN VARCHAR2 DEFAULT NULL

Line 73: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

69: p_api_version IN NUMBER
70: ,p_object_name IN VARCHAR2
71: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
72: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
73: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
74: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
75: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
76: ,p_entity_id IN NUMBER DEFAULT NULL
77: ,p_entity_index IN NUMBER DEFAULT NULL

Line 74: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

70: ,p_object_name IN VARCHAR2
71: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
72: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
73: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
74: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
75: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
76: ,p_entity_id IN NUMBER DEFAULT NULL
77: ,p_entity_index IN NUMBER DEFAULT NULL
78: ,p_entity_code IN VARCHAR2 DEFAULT NULL

Line 114: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

110: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
111: l_curr_data_element EGO_USER_ATTR_DATA_OBJ;
112:
113: -- pk
114: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
115: l_curr_pk_col_name_val_element EGO_COL_NAME_VALUE_PAIR_OBJ;
116: l_revision_id NUMBER;
117:
118: -- catalog category

Line 119: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

115: l_curr_pk_col_name_val_element EGO_COL_NAME_VALUE_PAIR_OBJ;
116: l_revision_id NUMBER;
117:
118: -- catalog category
119: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
120: l_curr_class_cd_val_element EGO_COL_NAME_VALUE_PAIR_OBJ;
121:
122: -- declarations
123: l_row_identifier NUMBER;

Line 128: l_error_messages EGO_COL_NAME_VALUE_PAIR_ARRAY := EGO_COL_NAME_VALUE_PAIR_ARRAY();

124: l_data_row_identifier NUMBER;
125:
126: -- output
127: l_telco_return_status VARCHAR2(1);
128: l_error_messages EGO_COL_NAME_VALUE_PAIR_ARRAY := EGO_COL_NAME_VALUE_PAIR_ARRAY();
129: l_error_col_name_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY :=EGO_COL_NAME_VALUE_PAIR_ARRAY();
130: l_error_element EGO_COL_NAME_VALUE_PAIR_OBJ;
131:
132:

Line 129: l_error_col_name_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY :=EGO_COL_NAME_VALUE_PAIR_ARRAY();

125:
126: -- output
127: l_telco_return_status VARCHAR2(1);
128: l_error_messages EGO_COL_NAME_VALUE_PAIR_ARRAY := EGO_COL_NAME_VALUE_PAIR_ARRAY();
129: l_error_col_name_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY :=EGO_COL_NAME_VALUE_PAIR_ARRAY();
130: l_error_element EGO_COL_NAME_VALUE_PAIR_OBJ;
131:
132:
133: l_next_attr_group BOOLEAN := FALSE;

Line 289: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

285:
286: PROCEDURE Get_User_Attrs_Data (
287: p_api_version IN NUMBER
288: ,p_object_name IN VARCHAR2
289: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
290: ,p_attr_group_request_table IN EGO_ATTR_GROUP_REQUEST_TABLE
291: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
292: ,p_entity_id IN VARCHAR2 DEFAULT NULL
293: ,p_entity_index IN NUMBER DEFAULT NULL

Line 342: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

338: p_api_version IN NUMBER
339: ,p_application_id IN NUMBER
340: ,p_object_id IN NUMBER DEFAULT NULL
341: ,p_object_name IN VARCHAR2 DEFAULT NULL
342: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
343: ,p_old_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
344: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
345: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
346: ,p_new_data_level_id IN NUMBER DEFAULT NULL --bug 8941665

Line 344: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

340: ,p_object_id IN NUMBER DEFAULT NULL
341: ,p_object_name IN VARCHAR2 DEFAULT NULL
342: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
343: ,p_old_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
344: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
345: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
346: ,p_new_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
347: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
348: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 345: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

341: ,p_object_name IN VARCHAR2 DEFAULT NULL
342: ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
343: ,p_old_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
344: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
345: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
346: ,p_new_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
347: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
348: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
349: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 347: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

343: ,p_old_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
344: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
345: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
346: ,p_new_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
347: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
348: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
349: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
350: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
351: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 348: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

344: ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
345: ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
346: ,p_new_data_level_id IN NUMBER DEFAULT NULL --bug 8941665
347: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
348: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
349: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
350: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
351: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
352: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 389: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

385: PROCEDURE Validate_Required_Attrs (
386: p_api_version IN NUMBER
387: ,p_object_name IN VARCHAR2
388: -- FND_OBJECTS.OBJECT_NAME
389: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
390: -- Attr values to be validated
391: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
392: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
393: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 391: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

387: ,p_object_name IN VARCHAR2
388: -- FND_OBJECTS.OBJECT_NAME
389: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
390: -- Attr values to be validated
391: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
392: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
393: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
394: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
395: -- FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME

Line 393: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

389: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
390: -- Attr values to be validated
391: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
392: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
393: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
394: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
395: -- FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME
396: ,p_entity_id IN NUMBER
397: ,p_entity_index IN NUMBER