179: CREATE EGO_USER_ATTR_CHANGE_TABLE AS TABLE OF EGO_USER_ATTR_CHANGE_OBJ;
180: *
181: *
182: * ==============================
183: * = EGO_ATTR_GROUP_REQUEST_OBJ =
184: * ==============================
185: *
186: *
187: CREATE EGO_ATTR_GROUP_REQUEST_OBJ AS OBJECT
183: * = EGO_ATTR_GROUP_REQUEST_OBJ =
184: * ==============================
185: *
186: *
187: CREATE EGO_ATTR_GROUP_REQUEST_OBJ AS OBJECT
188: (
189: ATTR_GROUP_ID NUMBER
190: ,APPLICATION_ID NUMBER
191: ,ATTR_GROUP_TYPE VARCHAR2(40)
196: ,ATTR_NAME_LIST VARCHAR2(3000)
197: );
198: *
199: *
200: * EGO_ATTR_GROUP_REQUEST_OBJ represents a request to retrieve data for
201: * one attribute group row from the database. It is very similar in
202: * structure to EGO_USER_ATTR_ROW_OBJ (discussed above); the notable
203: * difference is the field ATTR_NAME_LIST, which contains a comma-delimited
204: * list of attribute internal names specifying the attributes for which to
209: * = EGO_ATTR_GROUP_REQUEST_TABLE =
210: * ================================
211: *
212: *
213: CREATE EGO_ATTR_GROUP_REQUEST_TABLE AS TABLE OF EGO_ATTR_GROUP_REQUEST_OBJ;
214: *
215: *
216: * ========================
217: * = EGO_VARCHAR_TBL_TYPE =
733:
734:
735: /*#
736: * Build_Attr_Group_Request_Table builds up the EGO_ATTR_GROUP_REQUEST_TABLE.
737: * An instance of EGO_ATTR_GROUP_REQUEST_OBJ is built using the passed in
738: * infomation and appended to the table here.
739: * @param p_ag_req_table This is the table to which the row object is added.
740: * @param p_attr_group_id Attribute group id for which the request object
741: * is to be built.
772: RETURN EGO_ATTR_GROUP_REQUEST_TABLE;
773:
774: /*#
775: * Build_Attr_Group_Request_Obj creates and returns an instance of
776: * EGO_ATTR_GROUP_REQUEST_OBJ using the passed in infomation.
777: * @param p_attr_group_id Attribute group id for which the request object
778: * is to be built.
779: * @param p_application_id Application Id.
780: * @param p_attr_group_type Attribute group type of the attribute group.
803: ,p_data_level_4 IN VARCHAR2 DEFAULT NULL
804: ,p_data_level_5 IN VARCHAR2 DEFAULT NULL
805: ,p_attr_name_list IN VARCHAR2 DEFAULT NULL
806: )
807: RETURN EGO_ATTR_GROUP_REQUEST_OBJ;
808:
809:
810:
811: END EGO_USER_ATTRS_DATA_PUB;