DBA Data[Home] [Help]

APPS.PO_UDA_DATA_UTIL dependencies on EGO_USER_ATTR_ROW_TABLE

Line 146: -- This procedure accepts a template id and attribute group id and then cretaes EGO_USER_ATTR_ROW_TABLE

142: --------------------------------------------------------------------------------------------------------------------
143: --Start of Comments
144: --Name: UDA_DEFAULT_ATTRIBUTES
145: --Procedure:
146: -- This procedure accepts a template id and attribute group id and then cretaes EGO_USER_ATTR_ROW_TABLE
147: -- and PO_UDA_USAGE_OBJECT_ARRAY to contain the attribute group and attribute information with null values for
148: -- attributes and then run the defaulting actions (Actions with executiond code as XD and XLE)
149: --Parameters:
150: --IN:

Line 159: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details

155: -- 3. p_pk_column_name_value_pairs
156: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values
157: --IN/OUT:
158: -- 1. x_attributes_row_table
159: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details
160: -- 2. x_attr_name_value_pairs
161: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.
162: -- 3. x_external_attr_value_pairs
163: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)

Line 179: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

175: ,p_attr_grp_id IN NUMBER
176: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
177: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
178: ,x_attr_name_value_pairs OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
179: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
180: ,x_return_status OUT NOCOPY VARCHAR2
181: ,x_errorcode OUT NOCOPY NUMBER
182: ,x_msg_count OUT NOCOPY NUMBER
183: ,x_msg_data OUT NOCOPY VARCHAR2

Line 226: x_attributes_row_table := EGO_USER_ATTR_ROW_TABLE

222: WHERE ATTR_GROUP_TYPE = l_attr_group_type
223: AND DATA_LEVEL_NAME NOT LIKE '%ARCHIVE';
224:
225: d_progress := 40;
226: x_attributes_row_table := EGO_USER_ATTR_ROW_TABLE
227: (
228: EGO_USER_ATTR_ROW_OBJ
229: (
230: l_row_identifier

Line 323: -- This procedure accepts a template id and structures EGO_USER_ATTR_DATA_TABLE, EGO_USER_ATTR_ROW_TABLE

319: --------------------------------------------------------------------------------------------------------------------
320: --Start of Comments
321: --Name: UDA_VALIDATE_ATTRIBUTES
322: --Procedure:
323: -- This procedure accepts a template id and structures EGO_USER_ATTR_DATA_TABLE, EGO_USER_ATTR_ROW_TABLE
324: -- and validates the attributes present in the structures it also accepts a array of external attribute value pairs
325: -- It first runs the EGO validations ( EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data) and then executes the UDA
326: -- Actiond with execution code 'XV'.
327: --Parameters:

Line 335: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details

331: -- 2. p_pk_column_name_value_pairs
332: -- This variable would contain an array of type EGO_COL_NAME_VALUE_PAIR_ARRAY with the PK values
333: --IN/OUT:
334: -- 1. x_attributes_row_table
335: -- This variable would contain a table of type EGO_USER_ATTR_ROW_TABLE with the attribute group details
336: -- 2. x_attr_name_value_pairs
337: -- This variable of type PO_UDA_USAGE_OBJECT_ARRAY contains data of hhe usages.
338: -- 3. x_external_attr_value_pairs
339: -- This variable would contain an array of attribute value pairs (EGO_COL_NAME_VALUE_PAIR_TABLE)

Line 354: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

350: p_template_id IN NUMBER
351: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
352: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
353: ,x_attr_name_value_pairs OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
354: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
355: ,x_return_status OUT NOCOPY VARCHAR2
356: ,x_errorcode OUT NOCOPY NUMBER
357: ,x_msg_count OUT NOCOPY NUMBER
358: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2431: ,x_attribute_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

2427: ,p_template_id IN NUMBER
2428: ,p_attribute_group_id IN NUMBER
2429: ,p_event IN VARCHAR2
2430: ,x_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2431: ,x_attribute_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2432: ,x_attribute_data_table IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2433: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
2434: ,x_return_status OUT NOCOPY VARCHAR2
2435: ,x_errorcode OUT NOCOPY NUMBER

Line 2451: p_attribute_row_table EGO_USER_ATTR_ROW_TABLE ;

2447: l_return_status VARCHAR2(10);
2448: l_errorcode NUMBER;
2449: l_msg_count NUMBER;
2450: l_msg_data VARCHAR2(2000);
2451: p_attribute_row_table EGO_USER_ATTR_ROW_TABLE ;
2452: p_attribute_data_table EGO_USER_ATTR_DATA_TABLE;
2453:
2454:
2455: CURSOR c_get_action_id(p_template_id NUMBER, p_attribute_group_id NUMBER, p_event VARCHAR2) IS