DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_BULK_PVT dependencies on EGO_ATTR_TABLE

Line 1406: attr_name_val_pair EGO_ATTR_TABLE;

1402: l_attr_name_val_str VARCHAR2(30000);
1403: l_event_name VARCHAR2(240);
1404: l_is_pre_event_enabled_flag VARCHAR2(1);
1405: l_pre_event_name VARCHAR2(240);
1406: attr_name_val_pair EGO_ATTR_TABLE;
1407: l_event_key VARCHAR2(300);
1408: l_group_by_pre VARCHAR2(200);
1409: l_successful_rowcount NUMBER;
1410:

Line 5348: attr_name_val_pair := EGO_ATTR_TABLE();

5344: EXIT WHEN l_dynamic_cursor%NOTFOUND;
5345: -- Loop through the deflatened string containing the old and new values and
5346: -- prepare the table to be passed in as a parameter to pre-event
5347: l_attr_name_val_str := l_ag_deflatened_row.ATTR_NAME_VALUES;
5348: attr_name_val_pair := EGO_ATTR_TABLE();
5349: WHILE (INSTR(l_attr_name_val_str,'#') <> 0 AND l_ag_deflatened_row.TRANSACTION_TYPE <> EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE)
5350: LOOP
5351: l_attr_name := SUBSTR(l_attr_name_val_str
5352: ,INSTR(l_attr_name_val_str,'#*')+2

Line 5522: attr_name_val_pair := EGO_ATTR_TABLE();

5518: EXIT WHEN l_dynamic_cursor%NOTFOUND;
5519: -- Loop through the deflatened string containing the old values and
5520: -- prepare the table to be passed in as a parameter to pre-event
5521: l_attr_name_val_str := l_ag_deflatened_row.ATTR_NAME_VALUES;
5522: attr_name_val_pair := EGO_ATTR_TABLE();
5523: WHILE (INSTR(l_attr_name_val_str,'#*') <> 0)
5524: LOOP
5525: l_attr_name := SUBSTR(l_attr_name_val_str
5526: ,INSTR(l_attr_name_val_str,'#*')+2