APPS.EGO_ITEM_CATALOG_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 234

                		(Ego_Globals.G_OPR_UPDATE, Ego_Globals.G_OPR_CREATE)
        		THEN
				Error_Handler.Write_Debug('Performing check attributes');

Line: 254

			-- Process Flow step 10: Populate null columns for UPDATE
			-- OR Perform attribute defaulting for CREATE
			--

			IF EGO_Globals.G_Catalog_Group_Rec.transaction_type IN
                		(EGO_Globals.G_OPR_UPDATE, EGO_Globals.G_OPR_DELETE)
            		THEN
                    		Error_Handler.Write_Debug('Populate NULL columns . . .');

Line: 297

			IF EGO_Globals.G_Catalog_Group_Rec.transaction_type <> EGO_Globals.G_OPR_DELETE
           		THEN
                		Ego_Validate_Catalog_Group.Check_Entity
                		(  x_Mesg_Token_Tbl             => l_Mesg_Token_Tbl
                		,  x_return_status              => l_Return_Status
                		);

Line: 315

			ELSIF EGO_Globals.G_Catalog_Group_Rec.transaction_type = EGO_Globals.G_OPR_DELETE
                        THEN
                                Ego_Validate_Catalog_Group.Check_Entity_Delete
                                (  x_Mesg_Token_Tbl             => l_Mesg_Token_Tbl
                                ,  x_return_status              => l_Return_Status
                                );

Line: 326

					-- dbms_output.put_line('Raising exception in delete');